一套开源的管理软件（asp.net）

if col_length('st_device','dev_xs') is null alter table st_device add dev_xs varchar(50) if col_length('st_device','dev_lx') is null alter table st_device add dev_lx varchar(30) if col_length('st_device','kmry') is null alter table st_device add kmry varchar(20) if col_length('st_device','dyip') is null alter table st_device add dyip varchar(20) if col_length('st_device','jksz') is null alter table st_device add jksz tinyint if not exists(select A.name as DefaultName,B.name as TableName from sysobjects A inner join sysobjects B on A.parent_obj = B.id where A.xtype = 'D' and B.xtype = 'U' and B.name = 'st_device' and A.name='DF_st_device_112312') alter table st_device add constraint DF_st_device_112312 default (1) for jksz update st_device set jksz =1 if object_id('jk_DingCan') is null CREATE TABLE [dbo].[jk_DingCan] ([CODE] [varchar] (20) NULL ,[NAME] [varchar] (50) NULL ,[VAL1] [varchar] (20) NULL ,[VAL2] [varchar] (20) NULL ,[IFYOUXIAO] [tinyint] NULL ) ON [PRIMARY] if object_id('jk_locdc') is null CREATE TABLE [dbo].[jk_locdc] ([user_serial] [int] NULL ,[dc_sj] [datetime] NULL ,[dc_bz] [tinyint] NULL ,[dc_cb] [varchar] (5) NULL ) ON [PRIMARY] if object_id('ssbb_fxjg') is null CREATE TABLE [dbo].[ssbb_fxjg] ([pbrq] [datetime] NOT NULL ,[user_serial] [int] NOT NULL ,[sbks] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[sbsj] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[sbjs] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [xbks] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[xbsj] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[xbjs] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL) ON [PRIMARY] if object_id('ssbb_hzjl') is null CREATE TABLE [dbo].[ssbb_hzjl] ([dep_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[yingdao] [int] NULL ,[zaigang] [int] NULL ,[weidao] [int] NULL ,[chidao] [int] NULL ,[zaotui] [int] NULL ) ON [PRIMARY] if object_id('scip') is null CREATE TABLE [dbo].[scip] ([id] [int] IDENTITY (1, 1) NOT NULL ,[serverip] [varchar] (19) COLLATE Chinese_PRC_CI_AS NULL ,[clientip] [varchar] (19) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY] if object_id('ssbb_hzjl') is null CREATE TABLE [dbo].[ssbb_hzjl] ([dep_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[yingdao] [int] NULL ,[zaigang] [int] NULL ,[weidao] [int] NULL ,[chidao] [int] NULL ,[zaotui] [int] NULL ) ON [PRIMARY] insert into jk_dingcan(code,name,val1,val2,ifyouxiao) values('01','早餐','','',0) insert into jk_dingcan(code,name,val1,val2,ifyouxiao) values('02','午餐','','',0) insert into jk_dingcan(code,name,val1,val2,ifyouxiao) values('03','晚餐','','',0) insert into jk_dingcan(code,name,val1,val2,ifyouxiao) values('04','夜餐','','',0) insert into jk_dingcan(code,name,val1,val2,ifyouxiao) values('00','是否启用定餐功能','','',0)