/****** Object: Table [Central].[Alarm_T001] Script Date: 07/30/2012 11:14:03 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[Alarm_T001]') AND type in (N'U')) DROP TABLE [Central].[Alarm_T001] GO /****** Object: Table [Central].[AlarmMessages] Script Date: 07/30/2012 11:14:47 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[AlarmMessages]') AND type in (N'U')) DROP TABLE [Central].[AlarmMessages] GO /****** Object: Table [Central].[Alarms] Script Date: 07/30/2012 11:15:00 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[Alarms]') AND type in (N'U')) DROP TABLE [Central].[Alarms] GO /****** Object: Table [Central].[AlarmUpdate] Script Date: 07/30/2012 11:15:19 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[AlarmUpdate]') AND type in (N'U')) DROP TABLE [Central].[AlarmUpdate] GO /****** Object: Table [Central].[Statistics] Script Date: 07/30/2012 11:15:19 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[Statistics]') AND type in (N'U')) DROP TABLE [Central].[Statistics] GO /****** Object: Table [Central].[T001_EventHeader_T002] Script Date: 07/30/2012 11:18:04 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T001_EventHeader_T002]') AND type in (N'U')) DROP TABLE [Central].[T001_EventHeader_T002] GO /****** Object: Table [Central].[T001_ObjectList_T014] Script Date: 07/30/2012 11:18:15 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T001_ObjectList_T014]') AND type in (N'U')) DROP TABLE [Central].[T001_ObjectList_T014] GO /****** Object: Table [Central].[T001_ReferenceList_T027] Script Date: 07/30/2012 11:18:26 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T001_ReferenceList_T027]') AND type in (N'U')) DROP TABLE [Central].[T001_ReferenceList_T027] GO /****** Object: Table [Central].[T001_RuleList_T006] Script Date: 07/30/2012 11:18:37 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T001_RuleList_T006]') AND type in (N'U')) DROP TABLE [Central].[T001_RuleList_T006] GO /****** Object: Table [Central].[T001_SnapshotList_T031] Script Date: 07/30/2012 11:18:47 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T001_SnapshotList_T031]') AND type in (N'U')) DROP TABLE [Central].[T001_SnapshotList_T031] GO /****** Object: Table [Central].[T001_Vendor_T035] Script Date: 07/30/2012 11:19:02 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T001_Vendor_T035]') AND type in (N'U')) DROP TABLE [Central].[T001_Vendor_T035] GO /****** Object: Table [Central].[T002_Source_T003] Script Date: 07/30/2012 11:19:12 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T002_Source_T003]') AND type in (N'U')) DROP TABLE [Central].[T002_Source_T003] GO /****** Object: Table [Central].[T003_FQID_T004] Script Date: 07/30/2012 11:19:23 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T003_FQID_T004]') AND type in (N'U')) DROP TABLE [Central].[T003_FQID_T004] GO /****** Object: Table [Central].[T004_ServerId_T005] Script Date: 07/30/2012 11:19:34 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T004_ServerId_T005]') AND type in (N'U')) DROP TABLE [Central].[T004_ServerId_T005] GO /****** Object: Table [Central].[T006_Rule_T007] Script Date: 07/30/2012 11:19:44 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T006_Rule_T007]') AND type in (N'U')) DROP TABLE [Central].[T006_Rule_T007] GO /****** Object: Table [Central].[T007_PolygonList_T008] Script Date: 07/30/2012 11:19:56 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T007_PolygonList_T008]') AND type in (N'U')) DROP TABLE [Central].[T007_PolygonList_T008] GO /****** Object: Table [Central].[T014_Object_T015] Script Date: 07/30/2012 11:20:10 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T014_Object_T015]') AND type in (N'U')) DROP TABLE [Central].[T014_Object_T015] GO /****** Object: Table [Central].[T015_BoundingBox_T016] Script Date: 07/30/2012 11:20:23 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T015_BoundingBox_T016]') AND type in (N'U')) DROP TABLE [Central].[T015_BoundingBox_T016] GO /****** Object: Table [Central].[T015_Motion_T022] Script Date: 07/30/2012 11:20:34 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T015_Motion_T022]') AND type in (N'U')) DROP TABLE [Central].[T015_Motion_T022] GO /****** Object: Table [Central].[T015_Polygon_T018] Script Date: 07/30/2012 11:20:44 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T015_Polygon_T018]') AND type in (N'U')) DROP TABLE [Central].[T015_Polygon_T018] GO /****** Object: Table [Central].[T022_Path_T023] Script Date: 07/30/2012 11:21:00 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T022_Path_T023]') AND type in (N'U')) DROP TABLE [Central].[T022_Path_T023] GO /****** Object: Table [Central].[T027_Reference_T028] Script Date: 07/30/2012 11:21:11 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T027_Reference_T028]') AND type in (N'U')) DROP TABLE [Central].[T027_Reference_T028] GO /****** Object: Table [Central].[T028_FQID_T029] Script Date: 07/30/2012 11:21:21 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T028_FQID_T029]') AND type in (N'U')) DROP TABLE [Central].[T028_FQID_T029] GO /****** Object: Table [Central].[T029_ServerId_T030] Script Date: 07/30/2012 11:21:33 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T029_ServerId_T030]') AND type in (N'U')) DROP TABLE [Central].[T029_ServerId_T030] GO /****** Object: Table [Central].[T031_Snapshot_T032] Script Date: 07/30/2012 11:21:46 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T031_Snapshot_T032]') AND type in (N'U')) DROP TABLE [Central].[T031_Snapshot_T032] GO /****** Object: Table [Central].[T032_FQID_T033] Script Date: 07/30/2012 11:21:56 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T032_FQID_T033]') AND type in (N'U')) DROP TABLE [Central].[T032_FQID_T033] GO /****** Object: Table [Central].[T033_ServerId_T034] Script Date: 07/30/2012 11:22:07 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Central].[T033_ServerId_T034]') AND type in (N'U')) DROP TABLE [Central].[T033_ServerId_T034] GO