lyfz_repos/经典版源码/document/数据库维护脚本/生成version表.sql

USE [db]
GO
/****** 对象:  Table [dbo].[version]    脚本日期: 01/02/2016 18:53:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[version](
	[version] [nvarchar](50) NULL,
	[curdate] [nvarchar](50) NULL,
	[check1] [nvarchar](50) NULL,
	[check2] [nvarchar](50) NULL,
	[check3] [nvarchar](50) NULL,
	[check4] [nvarchar](50) NULL,
	[edit1] [nvarchar](50) NULL,
	[edit2] [nvarchar](50) NULL,
	[edit3] [nvarchar](50) NULL,
	[edit4] [nvarchar](50) NULL,
	[info1] [nvarchar](50) NULL,
	[info2] [nvarchar](50) NULL,
	[info3] [nvarchar](50) NULL,
	[info4] [nvarchar](50) NULL,
	[info5] [nvarchar](50) NULL,
	[bak1] [nvarchar](50) NULL,
	[bak2] [nvarchar](50) NULL,
	[bak3] [nvarchar](50) NULL,
	[bak4] [nvarchar](50) NULL,
	[bak5] [nvarchar](50) NULL,
	[bak6] [nvarchar](50) NULL,
	[baktime] [nvarchar](50) NULL,
	[bakserver1] [nvarchar](50) NULL,
	[bakserver2] [nvarchar](50) NULL,
	[bakserver3] [nvarchar](50) NULL,
	[bakserver4] [nvarchar](50) NULL,
	[bakserver5] [nvarchar](50) NULL,
	[msgaccount] [nvarchar](50) NULL,
	[msgpsw] [nvarchar](50) NULL,
	[msgused] [nvarchar](50) NULL,
	[msgbalance] [nvarchar](50) NULL,
	[msgcheck1] [nvarchar](50) NULL,
	[msgcheck2] [nvarchar](50) NULL,
	[msgdays1] [nvarchar](50) NULL,
	[msgdays2] [nvarchar](50) NULL,
	[msgcontent1] [nvarchar](max) NULL,
	[msgcontent2] [nvarchar](max) NULL,
	[remarks] [nvarchar](max) NULL,
	[rate] [nvarchar](50) NULL,
	[msgcheck3] [nvarchar](50) NULL,
	[msgcontent3] [nvarchar](max) NULL,
	[salarycheck1] [nvarchar](50) NULL,
	[salarycheck2] [nvarchar](50) NULL,
	[msgcheck4] [nvarchar](50) NULL,
	[msgtime] [nvarchar](50) NULL,
	[msgphones] [nvarchar](max) NULL,
	[info6] [nvarchar](50) NULL,
	[msgcompanyname] [nvarchar](50) NULL,
	[msgphones2] [nvarchar](max) NULL,
	[msgsendtype] [nvarchar](50) NULL,
	[msgcontent5] [nvarchar](max) NULL,
	[msgcheck5] [nvarchar](50) NULL,
	[msgcontent6] [nvarchar](max) NULL,
	[msgcheck6] [nvarchar](50) NULL,
	[cardlength] [nvarchar](50) NULL,
	[salarycheck3] [nvarchar](50) NULL,
	[salarycheck4] [nvarchar](50) NULL,
	[setcheck1] [nvarchar](50) NULL,
	[setcheck2] [nvarchar](50) NULL,
	[setcheck3] [nvarchar](50) NULL,
	[setcheck4] [nvarchar](50) NULL,
	[setcheck5] [nvarchar](50) NULL,
	[printer1] [nvarchar](50) NULL,
	[printer2] [nvarchar](50) NULL,
	[printer3] [nvarchar](50) NULL,
	[setprintstyle] [nvarchar](50) NULL,
	[uploadcheck1] [nvarchar](50) NULL,
	[uploadcheck2] [nvarchar](50) NULL,
	[uploadcheck3] [nvarchar](50) NULL,
	[uploadcheck4] [nvarchar](50) NULL,
	[bak11] [nvarchar](50) NULL,
	[bak22] [nvarchar](50) NULL,
	[bak33] [nvarchar](50) NULL,
	[bak44] [nvarchar](50) NULL,
	[setprintstyle2] [nvarchar](50) NULL,
	[setcheck10] [nvarchar](50) NULL,
	[ziptype1] [nvarchar](50) NULL,
	[ziptype2] [nvarchar](50) NULL,
	[ziptype3] [nvarchar](50) NULL,
	[ziptype4] [nvarchar](50) NULL,
	[salaryset] [nvarchar](max) NULL,
	[limitcount1] [nvarchar](50) NULL,
	[limitcount2] [nvarchar](50) NULL,
	[limitcount3] [nvarchar](50) NULL,
	[rate2] [nvarchar](50) NULL,
	[setcheck11] [nvarchar](50) NULL,
	[setcheck12] [nvarchar](50) NULL,
	[setprintstyle3] [nvarchar](50) NULL,
	[msgcheck7] [nvarchar](50) NULL,
	[msgcheck8] [nvarchar](50) NULL,
	[msgcheck9] [nvarchar](50) NULL,
	[msgcheck10] [nvarchar](50) NULL,
	[msgcontent8] [nvarchar](max) NULL,
	[msgcontent9] [nvarchar](max) NULL,
	[msgcontent10] [nvarchar](max) NULL,
	[setcheck13] [nvarchar](50) NULL,
	[time1] [nvarchar](50) NULL,
	[time2] [nvarchar](50) NULL,
	[time3] [nvarchar](50) NULL,
	[setcheck14] [nvarchar](50) NULL,
	[setcheck15] [nvarchar](50) NULL,
	[msgcheck11] [nvarchar](50) NULL,
	[msgcheck12] [nvarchar](50) NULL,
	[msgcheck13] [nvarchar](50) NULL,
	[msgcheck14] [nvarchar](50) NULL,
	[msgcontent11] [nvarchar](max) NULL,
	[msgcontent12] [nvarchar](max) NULL,
	[msgcontent13] [nvarchar](max) NULL,
	[msgcontent14] [nvarchar](max) NULL,
	[setcheck6] [nvarchar](50) NULL,
	[msgcheck15] [nvarchar](50) NULL,
	[msgcontent15] [nvarchar](max) NULL,
	[logdays] [nvarchar](50) NULL,
	[setcheck17] [nvarchar](50) NULL,
	[setcheck18] [nvarchar](50) NULL,
	[setcheck19] [nvarchar](50) NULL,
	[uploadrule] [nvarchar](max) NULL,
	[setcheck20] [nvarchar](50) NULL,
	[cardnum] [nvarchar](50) NULL,
	[cardscale] [nvarchar](500) NULL,
	[info7] [nvarchar](120) NULL,
	[setcheck21] [nvarchar](50) NULL,
	[msgcheck16] [nvarchar](50) NULL,
	[hospitalmsgcheck1] [nvarchar](50) NULL,
	[hospitalmsgcheck2] [nvarchar](50) NULL,
	[serialno] [nvarchar](50) NULL,
	[serialno2] [nvarchar](50) NULL,
	[msgcheck17] [nvarchar](50) NULL,
	[msgcontent17] [nvarchar](max) NULL,
	[setcheck22] [nvarchar](50) NULL,
	[setcheck23] [nvarchar](50) NULL,
	[info8] [nvarchar](120) NULL,
	[setcheck24] [nvarchar](120) NULL,
	[outtime] [nvarchar](120) NULL,
	[info9] [nvarchar](120) NULL,
	[reverse1] [nvarchar](50) NULL,
	[reverse2] [nvarchar](50) NULL,
	[reverse3] [nvarchar](50) NULL,
	[reverse4] [nvarchar](50) NULL,
	[reverse5] [nvarchar](50) NULL,
	[photo] [image] NULL,
	[delcheck1] [nvarchar](50) NULL,
	[delcheck2] [nvarchar](50) NULL,
	[delcheck3] [nvarchar](50) NULL,
	[delcheck4] [nvarchar](50) NULL,
	[deledit1] [nvarchar](50) NULL,
	[deledit2] [nvarchar](50) NULL,
	[deledit3] [nvarchar](50) NULL,
	[deledit4] [nvarchar](50) NULL,
	[alarmdays1] [nvarchar](50) NULL,
	[alarmdays2] [nvarchar](50) NULL,
	[alarmdays3] [nvarchar](50) NULL,
	[alarmdays4] [nvarchar](50) NULL,
	[alarmdays5] [nvarchar](50) NULL,
	[alarmdays6] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]