Manitou Core - SQL Query - BoldTrak - Fix Geofences

01/03/2024 10:36 am EST

This script is to fix issues with geofences in BoldTrak. This is generally needed when tracking is presenting a DB error, or if replication is failing on BT_GEOFENCES.

USE [MANITOU]
GO

DROP TABLE BT_GEOFENCE
DROP TABLE BT_GEOFENCE_ASSN
DROP TABLE BT_GEOFENCES

/****** Object:  Table [dbo].[BT_GEOFENCE]    Script Date: 1/29/2013 4:27:09 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BT_GEOFENCE](
	[LASTUPD] [datetime] NULL,
	[CREDATE] [datetime] NULL,
	[FID] [int] IDENTITY(1,1) NOT NULL,
	[NAME] [nvarchar](50) NULL,
	[GID] [int] NULL,
	[XMLFence] [nvarchar](max) NULL,
 CONSTRAINT [PK_MG_GEOFENCE] PRIMARY KEY CLUSTERED 
(
	[FID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

USE [MANITOU]
GO

/****** Object:  Table [dbo].[BT_GEOFENCE_ASSN]    Script Date: 1/29/2013 4:27:29 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[BT_GEOFENCE_ASSN](
	[LASTUPD] [datetime] NULL,
	[CREDATE] [datetime] NULL,
	[AID] [int] IDENTITY(1,1) NOT NULL,
	[GID] [int] NOT NULL,
	[RLDES] [nvarchar](5) NULL,
	[TXID] [nvarchar](255) NULL,
	[COMMSNO] [varchar](4) NULL,
 CONSTRAINT [PK_MG_GEOFENCE_ASSN] PRIMARY KEY CLUSTERED 
(
	[AID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

USE [MANITOU]
GO

/****** Object:  Table [dbo].[BT_GEOFENCES]    Script Date: 1/29/2013 4:27:36 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BT_GEOFENCES](
	[LASTUPD] [datetime] NULL,
	[CREDATE] [datetime] NULL,
	[GID] [int] IDENTITY(1,1) NOT NULL,
	[CONTTYPE] [int] NULL,
	[SERIALNO] [int] NULL,
	[NAME] [nvarchar](50) NULL,
	[INHERIT] [int] NULL,
	[ACTIVE] [int] NULL,
	[ASSIGNABLE] [smallint] NULL,
 CONSTRAINT [PK_MG_GEOFENCES] PRIMARY KEY CLUSTERED 
(
	[GID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

USE [MANITOU]
GO

Was this article helpful?