【文章內容簡介】 BENXINXI]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[LINGJIANJIBENXINXI]GOif exists (select * from where id = object_id(N39。[dbo].[LINGJIANLINGYONGDAN]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[LINGJIANLINGYONGDAN]GOif exists (select * from where id = object_id(N39。[dbo].[LINGJIANRUKUDAN]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[LINGJIANRUKUDAN]GOif exists (select * from where id = object_id(N39。[dbo].[M_USER]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[M_USER]GOif exists (select * from where id = object_id(N39。[dbo].[QICHEDENGJI]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[QICHEDENGJI]GOif exists (select * from where id = object_id(N39。[dbo].[QICHEJIBENXINXI]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[QICHEJIBENXINXI]GOif exists (select * from where id = object_id(N39。[dbo].[QICHEXIULIDAN]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[QICHEXIULIDAN]GOif exists (select * from where id = object_id(N39。[dbo].[XIUCHEFAPIAO]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[XIUCHEFAPIAO]GO20 / 35if exists (select * from where id = object_id(N39。[dbo].[XIULIGONGMINGCHE]39。) and OBJECTPROPERTY(id, N39。IsUserTable39。) = 1)drop table [dbo].[XIULIGONGMINGCHE]GOCREATE TABLE [dbo].[KUCUNLINGJIANTAIZHANG] ([id] [int] NULL ,[ljno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[kcmin] [int] NULL ,[kcdinghuo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[KUCUNLINGJIANTAIZHANG2] ([id] [int] NOT NULL ,[kcljno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[kcljname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[kcljchengben] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[kcljmoney] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[kcljnumber] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[kcljmin] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[kcdinghuo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[LINGJIANJIBENXINXI] ([id] [int] NULL ,[ljno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljchengben] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljmoney] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[LINGJIANLINGYONGDAN] ([id] [int] NOT NULL ,[ljlydanid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[ljlyid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljlyljhao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljlynumber] [int] NULL ,[ljlydate] [datetime] NULL ,[manager] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]21 / 35GOCREATE TABLE [dbo].[LINGJIANRUKUDAN] ([id] [int] NOT NULL ,[ljrkno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljrkname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljrkPrice] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[ljrknumber] [int] NULL ,[ljrkdate] [datetime] NULL ,[ljrkperson] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[manager] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[M_USER] ([id] [int] NOT NULL ,[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[power] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[QICHEDENGJI] ([id] [int] NOT NULL ,[xcdjno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[qcdjno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcdjclass] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcdjfactory] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcdjperson] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcdjtel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcdjaddr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcdjxiangmu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcdjdate] [datetime] NULL ,[manager] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[QICHEJIBENXINXI] ([id] [int] NOT NULL ,[qo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[qcclass] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcfactory] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcperson] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qctel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,22 / 35[qcaddr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[QICHEXIULIDAN] ([id] [int] NOT NULL ,[qcxlid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[xcdjno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcxlno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcxlfrdate] [datetime] NULL ,[qcxlxiangmu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcxlgonghao] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcxlpai] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcxllingjianno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[qcxlnumber] [int] NULL ,[qcxlhour] [int] NULL ,[qcxltodate] [datetime] NULL ,[qcxlxlg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[manager] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[XIUCHEFAPIAO] ([id] [int] NOT NULL ,[xldno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[fpname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[fpaddr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[fpno] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[fpxiangmu] [va