if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[User]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Action]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Action]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[HandDetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[HandDetail]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[HandMaster]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[HandMaster]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NotifyInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NotifyInfo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[group]
GO

CREATE TABLE [dbo].[User] (
	[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
	[Userid] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pwd] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[groupid] [int] NULL ,
	[limit] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Action] (
	[NotifyID] [bigint] NOT NULL ,
	[ActionID] [int] NULL ,
	[Oper] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[OperInfo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[OperTime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[HandDetail] (
	[ID] [bigint] NULL ,
	[NotifyID] [bigint] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[HandMaster] (
	[ID] [bigint] NOT NULL ,
	[CreateDate] [datetime] NULL ,
	[UserId] [int] NULL ,
	[InputMan] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[ActionID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NotifyInfo] (
	[id] [bigint] NOT NULL ,
	[Cph] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CarMan] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Addr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CarType] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[CarColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wfdate] [datetime] NULL ,
	[WfAddr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[WfCode] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[wfmoney] [decimal](18, 0) NULL ,
	[Phone] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[NotifyNo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Createdate] [datetime] NULL ,
	[driveno] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[memo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[userid] [int] NULL ,
	[sxmoney] [decimal](18, 0) NULL ,
	[InputMan] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[CarPP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Actionid] [int] NULL ,
	[stateid] [int] NULL ,
	[groupid] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[group] (
	[id] [int] NULL ,
	[groupname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

