sql数据库.inc

客户管理系统-支持 Ms Sql-Server

 if exists (select * from sysobjects where id = OBJECT_ID('[fzb]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [fzb] 
 CREATE TABLE [fzb] (  [fzbid] [int] IDENTITY (1, 1) NOT NULL ,  [kfglid] [int] NULL ,  [fzbm] [text] NULL ,  [fzbsm] [text] NULL )

 if exists (select * from sysobjects where id = OBJECT_ID('[kfgl]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [kfgl] 
 CREATE TABLE [kfgl] (  [kfglid] [int] IDENTITY (1, 1) NOT NULL , [kfglxm] [varchar] (50) NULL , [kfgldl] [varchar] (50) NULL , [kfglmm] [varchar] (50) NULL ,  [kfglgsmc] [text] NULL ,  [kfglsj] [text] NULL ,  [kfglemail] [text] NULL ,  [kfgldz] [text] NULL , [kfglck] [money] NULL , [kfglzcsj] [datetime]  NULL ,  [kfglzlbm] [text] NULL ,  [kfglfzbm] [text] NULL ,  [kfglsjdxbm] [text] NULL ,  [kfglscsjbm] [text] NULL ,  [kfglgrdxkbm] [text] NULL ,  [kfgldxlsjlbm] [text] NULL ,  [kfgldxlsjlxxbm] [text] NULL ,  [kfglyfkjlbm] [text] NULL ,  [kfglkfxwglbm] [text] NULL , [kfglzt] [varchar] (50) NULL , [kfglbz] [varchar] (50) NULL , [kfglsm] [varchar] (50) NULL , [kfglgs] [varchar] (50) NULL , [lm] [varchar] (50) NULL , [lm2] [varchar] (50) NULL , [lm3] [varchar] (50) NULL , [kfgldycczje] [money] NULL , [kfglbb] [varchar] (50) NULL , [kfglqm] [varchar] (50) NULL )

 SET IDENTITY_INSERT [kfgl] ON

 INSERT [kfgl] ( [kfglid] , [kfglxm] , [kfgldl] , [kfglmm] , [kfglgsmc] , [kfglsj] , [kfglemail] , [kfgldz] , [kfglck] , [kfglzcsj] , [kfglzlbm] , [kfglfzbm] , [kfglsjdxbm] , [kfglscsjbm] , [kfglgrdxkbm] , [kfgldxlsjlbm] , [kfgldxlsjlxxbm] , [kfglyfkjlbm] , [kfglkfxwglbm] , [kfglbz] , [kfglsm] , [kfglgs] , [kfgldycczje] , [kfglbb] , [kfglqm] ) VALUES ( 182 , '袁小磊' , 'piaoy' , 'piaoy' , '漂移网络' , '13965078652' , '[e-mail]' , '安徽省合肥市' , 1.0000 , '2006-10-30 11:36:27.000' , 'xkfb' , 'fzb' , 'sjdxb' , 'sjhmb' , 'grdxk' , 'dxlsjl' , 'dxlsjlxx' , 'yfkjl' , 'kfxwgl' , '1' , 'piaoy手动添加用户!' , '' , 1.0000 , '' , '袁小磊' )

 SET IDENTITY_INSERT [kfgl] OFF

 if exists (select * from sysobjects where id = OBJECT_ID('[kfxwgl]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [kfxwgl] 
 CREATE TABLE [kfxwgl] (  [kfxwglid] [int] IDENTITY (1, 1) NOT NULL ,  [kfglid] [int] NULL ,  [xkfid] [int] NULL ,  [kfxwglxwjl] [text] NULL ,  [kfxwglywy] [text] NULL ,  [kfxwglje] [text] NULL ,  [kfxwglbz] [text] NULL , [kfxwglsj] [datetime]  NULL , [kfxwglxwzl] [varchar] (50) NULL )

 if exists (select * from sysobjects where id = OBJECT_ID('[sms]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [sms] 
 CREATE TABLE [sms] (  [smsid] [int] IDENTITY (1, 1) NOT NULL , [smsxm] [varchar] (50) NULL , [smsm] [varchar] (50) NULL , [smsglyxm] [varchar] (50) NULL , [lmid] [varchar] (50) NULL )

 SET IDENTITY_INSERT [sms] ON

 INSERT [sms] ( [smsid] , [smsxm] , [smsm] , [smsglyxm] , [lmid] ) VALUES ( 19 , 'piaoy' , '961978e870bc41a5' , 'piaoy' , '16' )

 SET IDENTITY_INSERT [sms] OFF

 if exists (select * from sysobjects where id = OBJECT_ID('[smsqxb]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [smsqxb] 
 CREATE TABLE [smsqxb] (  [id] [int] IDENTITY (1, 1) NOT NULL , [lm] [varchar] (50) NULL , [lm2] [varchar] (50) NULL , [lm3] [varchar] (50) NULL , [lmid] [varchar] (50) NULL )

 SET IDENTITY_INSERT [smsqxb] ON

 INSERT [smsqxb] ( [id] , [lm] ) VALUES ( 16 , '管理员' )

 SET IDENTITY_INSERT [smsqxb] OFF

 if exists (select * from sysobjects where id = OBJECT_ID('[smsrz]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [smsrz] 
 CREATE TABLE [smsrz] (  [smsrzID] [int] IDENTITY (1, 1) NOT NULL , [smsrzczy] [varchar] (50) NULL , [smsrzrzlx] [varchar] (50) NULL ,  [smsrzrznr] [text] NULL , [smsrzczip] [varchar] (50) NULL , [smsrzsj] [datetime]  NULL )

 if exists (select * from sysobjects where id = OBJECT_ID('[xkfb]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [xkfb] 
 CREATE TABLE [xkfb] (  [xkfid] [int] IDENTITY (1, 1) NOT NULL ,  [kfglid] [int] NULL ,  [xkfzb] [int] NULL ,  [xkfdwmc] [text] NULL , [xkfxm] [varchar] (50) NULL ,  [xkfzc] [text] NULL ,  [xkfdh] [text] NULL , [xkfsj] [varchar] (50) NULL ,  [xkfcz] [text] NULL ,  [xkfemail] [text] NULL ,  [xkfwz] [text] NULL ,  [xkfqq] [text] NULL ,  [xkfdz] [text] NULL ,  [xkfyb] [text] NULL ,  [xkfxb] [text] NULL ,  [xkfsr] [text] NULL ,  [xkfzjh] [text] NULL ,  [xkfbz] [text] NULL , [xkfscbj] [varchar] (50) NULL )