GSM终端远程设备巡检(点检)系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BD_Dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[BD_Dept] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BD_Operator]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[BD_Operator] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BD_Parter]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[BD_Parter] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[K_Group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[K_Group] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[K_Machine]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[K_Machine] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[K_MachineState]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[K_MachineState] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[K_RunLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[K_RunLog] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[K_RunState]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[K_RunState] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[K_StateGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[K_StateGroup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS_LOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[SYS_LOG] GO CREATE TABLE [dbo].[BD_Dept] ( [DeptID] [int] IDENTITY (1, 1) NOT NULL , [DeptName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [Manager] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [Tel] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL , [Addr] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [BZ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BD_Operator] ( [UserID] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [UserName] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [UserPass] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [DeptID] [int] NOT NULL , [PartID] [int] NOT NULL , [enterDate] [smalldatetime] NULL , [exitDate] [smalldatetime] NULL , [lastDate] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BD_Parter] ( [PartID] [int] IDENTITY (1, 1) NOT NULL , [PartName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [Power] [varchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL , [BZ] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[K_Group] ( [GroupID] [int] IDENTITY (1, 1) NOT NULL , [GroupName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [Manager] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL , [Tel] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL , [Address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [BZ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[K_Machine] ( [MachID] [int] IDENTITY (1, 1) NOT NULL , [GroupID] [int] NOT NULL , [MachName] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [MachCode] [varchar] (11) COLLATE Chinese_PRC_CI_AS NOT NULL , [Address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [BZ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [TestDate] [datetime] NULL , [TestReturn] [bit] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[K_MachineState] ( [MachID] [int] NOT NULL , [StateID] [int] NOT NULL , [StateDate] [datetime] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[K_RunLog] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [MachID] [int] NOT NULL , [StateID] [int] NOT NULL , [LogDate] [datetime] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[K_RunState] ( [StateID] [int] IDENTITY (1, 1) NOT NULL , [GroupID] [int] NOT NULL , [StateName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [StateFlag] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [StateColor] [decimal](10, 0) NOT NULL , [WarrManager] [bit] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[K_StateGroup] ( [GroupID] [int] IDENTITY (1, 1) NOT NULL , [GroupName] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [SmsPrefix] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SYS_LOG] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Oper] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL , [IP] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL , [LogDate] [datetime] NULL , [Log1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Log2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[BD_Dept] WITH NOCHECK ADD CONSTRAINT [PK_BD_Dep] PRIMARY KEY CLUSTERED ( [DeptID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BD_Operator] WITH NOCHECK ADD CONSTRAINT [PK_BD_Operator] PRIMARY KEY CLUSTERED ( [UserID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BD_Parter] WITH NOCHECK ADD CONSTRAINT [PK_BD_Power] PRIMARY KEY CLUSTERED ( [PartID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[K_Group] WITH NOCHECK ADD CONSTRAINT [PK_K_Group] PRIMARY KEY CLUSTERED ( [GroupID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[K_Machine] WITH NOCHECK ADD CONSTRAINT [PK_K_Machine] PRIMARY KEY CLUSTERED ( [MachID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[K_RunLog] WITH NOCHECK ADD CONSTRAINT [PK_BD_StateCount] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[K_RunState] WITH NOCHECK ADD CONSTRAINT [PK_K_StateList] PRIMARY KEY CLUSTERED ( [StateID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[K_StateGroup] WITH NOCHECK ADD CONSTRAINT [PK_K_SmsGroup] PRIMARY KEY CLUSTERED ( [GroupID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SYS_LOG] WITH NOCHECK ADD CONSTRAINT [PK_SYS_LOG] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BD_Operator] ADD CONSTRAINT [DF_BD_Operator_DeptID] DEFAULT (0) FOR [DeptID], CONSTRAINT [DF_BD_Operator_PowerID] DEFAULT (0) FOR [PartID] GO ALTER TABLE [dbo].[BD_Parter] ADD CONSTRAINT [DF_BD_Power_Power] DEFAULT (0) FOR [Power] GO ALTER TABLE [dbo].[K_Machine] ADD CONSTRAINT [DF_K_Machine_TestReture] DEFAULT (0) FOR [TestReturn] GO ALTER TABLE [dbo].[K_MachineState] ADD CONSTRAINT [DF_K_MachineState_StateDate] DEFAULT (getdate()) FOR [StateDate] GO ALTER TABLE [dbo].[K_RunLog] ADD CONSTRAINT [DF_BD_StateCount_DateTime] DEFAULT (getdate()) FOR [LogDate] GO ALTER TABLE [dbo].[K_RunState] ADD CONSTRAINT [DF_K_StateList_StateColor] DEFAULT (12639424) FOR [StateColor], CONSTRAINT [DF_K_RunState_WarrManager] DEFAULT (0) FOR [WarrManager] GO