$PBExportHeader$uo_version_email.sru forward global type uo_version_email from nonvisualobject end type end forward global type uo_version_email from nonvisualobject end type global uo_version_email uo_version_email type variables long cur_i end variables forward prototypes public function integer uof_createtable (boolean arg_if_version) public subroutine uof_createtable_arr_20130201 (ref s_sys_create_table arg_tb[]) public subroutine uof_createtable_arr_20130202 (ref s_sys_create_table arg_tb[]) public subroutine uof_createtable_arr_20130203 (ref s_sys_create_table arg_tb[]) public subroutine uof_createtable_arr_20130204 (ref s_sys_create_table arg_tb[]) public subroutine uof_createtable_arr_demo (long i, ref s_sys_create_table arg_tb[]) public subroutine uof_createtable_arr_20130817 (long i, ref s_sys_create_table arg_tb[]) end prototypes public function integer uof_createtable (boolean arg_if_version);String ls_email_version Long i, li_suc String createsql_string String ls_update_version String ls_tbname String ls_errmsg If sys_email_sqlca.DBHandle() = 0 Then Return 0 s_sys_create_table s_table[] Select email_version Into :ls_email_version From sys_db_version; If sqlca.SQLCode <> 0 Then ls_email_version = '419249917573705627508968519049' End If ls_email_version = f_psw_bczh(ls_email_version,1,sys_power_key) //If Long(sys_email_version) <= Long(ls_email_version) Then Return 1 uof_createtable_arr_20130201(s_table) uof_createtable_arr_20130202(s_table) uof_createtable_arr_20130203(s_table) uof_createtable_arr_20130204(s_table) //uof_createtable_arr_120924(s_table) Open(w_sys_wait_jdt) //初始化进度条 w_sys_wait_jdt.Show() If arg_if_version Then w_sys_wait_jdt.wf_accepttol(UpperBound(s_table) + 1) Else w_sys_wait_jdt.wf_accepttol(UpperBound(s_table)) End If w_sys_wait_jdt.wf_inc(0) w_sys_wait_jdt.st_msg.Text = "正在升级邮件数据库..." For i = 1 To UpperBound(s_table) w_sys_wait_jdt.wf_inc(i) w_sys_wait_jdt.st_msg.Text = "正在升级表:"+s_table[i].tbname+'...' createsql_string = '' ls_update_version = '' createsql_string = s_table[i].createsql_string ls_update_version = s_table[i].update_version ls_tbname = s_table[i].tbname If createsql_string = '' Then Continue If arg_if_version Then If ls_update_version <= ls_email_version Then Continue End If ls_errmsg = '' Execute Immediate :createsql_string Using sys_email_sqlca; If sys_email_sqlca.SQLCode <> 0 Then //更新版本日志 ls_errmsg = String(i) + '-' + ls_tbname + ','+ sys_email_sqlca.SQLErrText End If Commit Using sys_email_sqlca; li_suc = 0 IF sqlca.SQLCode = 0 THEN li_suc = 1 END IF INSERT INTO sys_version_log (Ori_version,cur_version,updatenum,updatenum_suc,Update_dt,errmsg,arrid) VALUES (:ls_email_version,'E:'+:sys_email_version,1,:li_suc,getdate(),:ls_errmsg,:i); COMMIT; Next If arg_if_version Then w_sys_wait_jdt.wf_inc(i + 1) w_sys_wait_jdt.st_msg.Text = "正在更新邮件数据库版本号..." String ls_new_version ls_new_version = f_psw_bczh(sys_email_version,0,sys_power_key) Update sys_db_version Set email_version = :ls_new_version; If sqlca.SQLCode <> 0 Then Rollback; Close(w_sys_wait_jdt) MessageBox('Error','更新邮件数据库版本失败,'+sqlca.SQLErrText) Return 0 End If commit; End If Close(w_sys_wait_jdt) Return 1 end function public subroutine uof_createtable_arr_20130201 (ref s_sys_create_table arg_tb[]); cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_mtrlware_propel] ( " arg_tb[cur_i].createsql_string += " [sptid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [storagename] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [status] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [plancode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcuscode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [location] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [notauditnoallocqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [senddate] [datetime] NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_mtrlware_propel_rule] ( " arg_tb[cur_i].createsql_string += " [ruleid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [rulename] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [storageid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [rulestr] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [modemp] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [propeltime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [handtypestr] [char] (255) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel_rule" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_mtrlware_propel_rule_mx] ( " arg_tb[cur_i].createsql_string += " [ruleid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [cusid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ifmatch] [tinyint] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel_rule_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_mtrlware_propel] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_mtrlware_propel] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [sptid], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [mtrlwareid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_mtrlware_propel_rule] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_mtrlware_propel_rule] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [ruleid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel_rule" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_mtrlware_propel_rule_mx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_mtrlware_propel_rule_mx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [ruleid], " arg_tb[cur_i].createsql_string += " [cusid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel_rule_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_mtrlware_propel] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_sptid] DEFAULT (0) FOR [sptid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_mtrlwareid] DEFAULT (0) FOR [mtrlwareid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_mtrlid] DEFAULT (0) FOR [mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_mtrlcode] DEFAULT ('') FOR [mtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_mtrlname] DEFAULT ('') FOR [mtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_storagename] DEFAULT ('') FOR [storagename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_status] DEFAULT ('') FOR [status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_woodcode] DEFAULT ('') FOR [woodcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_pcode] DEFAULT ('') FOR [pcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_plancode] DEFAULT ('') FOR [plancode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_mtrlcuscode] DEFAULT ('') FOR [mtrlcuscode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_location] DEFAULT ('') FOR [location], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_notauditnoallocqty] DEFAULT (0) FOR [notauditnoallocqty] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_mtrlware_propel_rule] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_ruleid] DEFAULT (0) FOR [ruleid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_rulename] DEFAULT ('') FOR [rulename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_storageid] DEFAULT (0) FOR [storageid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_rulestr] DEFAULT ('') FOR [rulestr], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_modemp] DEFAULT ('') FOR [modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_handtypestr] DEFAULT ('') FOR [handtypestr] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel_rule" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_mtrlware_propel_rule_mx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_mx_ruleid] DEFAULT (0) FOR [ruleid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_mx_cusid] DEFAULT (0) FOR [cusid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_mtrlware_propel_rule_mx_ifmatch] DEFAULT (1) FOR [ifmatch] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_mtrlware_propel_rule_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_buytask_jd] ( " arg_tb[cur_i].createsql_string += " [taskcode] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [orderqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [perfinishdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [acmpqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [saleoutqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [sendtime] [datetime] NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_buytask_jd] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_buytask_jd] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [taskcode], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130201" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_buytask_jd] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_taskcode] DEFAULT ('') FOR [taskcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_mtrlcode] DEFAULT ('') FOR [mtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_mtrlname] DEFAULT ('') FOR [mtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_orderqty] DEFAULT (0) FOR [orderqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_acmpqty] DEFAULT (0) FOR [acmpqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_saleoutqty] DEFAULT (0) FOR [saleoutqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_buytask_jd_outwareqty] DEFAULT (0) FOR [outwareqty] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_buytask_jd" arg_tb[cur_i].createsql_string = " " arg_tb[cur_i].createsql_string += " ALTER TABLE dbo.LJFIEB_packet ADD " arg_tb[cur_i].createsql_string += " cusid int NOT NULL CONSTRAINT DF_LJFIEB_packet_cusid DEFAULT 0 " cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissue" arg_tb[cur_i].createsql_string = " " arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_reissue] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [reissueid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [reissuecode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cuscode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cusname] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reissuedate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [banktypename] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moneyname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reissueemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [itemcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [itemname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [auditingrep] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [auditingdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [type] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [flag] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [fiebrelcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [confirmtime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [confirmuser] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relreissuecode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissuemx" arg_tb[cur_i].createsql_string = " " arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_reissuemx] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [reissueid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [expensescode] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [expensesname] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [qty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [amt] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [price] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [tax] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissue" arg_tb[cur_i].createsql_string = " " arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissue] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_reissue] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [reissueid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissuemx" arg_tb[cur_i].createsql_string = " " arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissuemx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_reissuemx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [reissueid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissue" arg_tb[cur_i].createsql_string = " " arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissue] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_reissueid] DEFAULT (0) FOR [reissueid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_reissuecode] DEFAULT ('') FOR [reissuecode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_cuscode] DEFAULT ('') FOR [cuscode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_cusname] DEFAULT ('') FOR [cusname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_banktypename] DEFAULT ('') FOR [banktypename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_moneyname] DEFAULT ('') FOR [moneyname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_relcode] DEFAULT ('') FOR [relcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_reissueemp] DEFAULT ('') FOR [reissueemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_itemcode] DEFAULT ('') FOR [itemcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_itemname] DEFAULT ('') FOR [itemname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_modemp] DEFAULT ('') FOR [modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_auditingrep] DEFAULT ('') FOR [auditingrep], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_type] DEFAULT (0) FOR [type], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_flag] DEFAULT (0) FOR [flag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_fiebrelcode] DEFAULT ('') FOR [fiebrelcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_confirmuser] DEFAULT ('') FOR [confirmuser], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_relreissuecode] DEFAULT ('') FOR [relreissuecode] " cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissuemx" arg_tb[cur_i].createsql_string = " " arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissuemx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_reissueid] DEFAULT (0) FOR [reissueid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_expensescode] DEFAULT ('') FOR [expensescode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_expensesname] DEFAULT ('') FOR [expensesname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_qty] DEFAULT (0) FOR [qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_amt] DEFAULT (0) FOR [amt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_price] DEFAULT (0) FOR [price], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_tax] DEFAULT (0) FOR [tax], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_dscrp] DEFAULT ('') FOR [dscrp] " end subroutine public subroutine uof_createtable_arr_20130202 (ref s_sys_create_table arg_tb[]);cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_CusComm] ( " arg_tb[cur_i].createsql_string += " [CusCommID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [CusType] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [CusCode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [CusName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [CusKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [IP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Port1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [Accept] [bit] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_CusComm" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_configure_code] ( " arg_tb[cur_i].createsql_string += " [typeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pzid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pzcode] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [name] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [inputtype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [configtype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_code" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_configure_codemx] ( " arg_tb[cur_i].createsql_string += " [pzid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pzcodemx] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [namemx] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_codemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_configure_type] ( " arg_tb[cur_i].createsql_string += " [contfigtypeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [contfigtypename] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [contfigtype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_type" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_mtrl_configure] ( " arg_tb[cur_i].createsql_string += " [cid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [Mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [code] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [name] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ename] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [type] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Planprice] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [price] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [DefaultPZ] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [ifzj] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [capacity] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [capaparm] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [net_weight] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [gross_weight] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [cubage] [decimal](23, 10) NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_configure" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_mtrl_configure2] ( " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pzid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [Mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pzcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pzname] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pzcodemx] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pznamemx] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_configure2" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_mtrldef_code] ( " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrltype] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlsectype] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlmode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Mtrlorigin] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [unit] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [isuse] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [packqty] [decimal](18, 4) NOT NULL , " arg_tb[cur_i].createsql_string += " [prdpackcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [net_weight] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [gross_weight] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [cubage] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlengname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [zxmtrlmode] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [unit_scll] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [unit_buy] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rate_buy] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [rate_scll] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [rate_sale] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [unit_sale] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [statusflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [statustype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcodeflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcodetype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pcodeflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [pcodetype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [usermtrlmode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ifcustom] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [buyunit] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [wfjgunit] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [scllunit] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [saleunit] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [buydec] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [wfjgdec] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sclldec] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [saledec] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [status_check] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode_check] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode_check] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [status_config] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode_config] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode_config] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [configcodetype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [configcode] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [configname] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcolor] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [handtype] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ifpack] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [ifpackpro] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [ifpackpz] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [ifpackpro2] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [ifpacktype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlprp] [tinyint] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrldef_code" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_mtrltype] ( " arg_tb[cur_i].createsql_string += " [mtrltypeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrltype] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [handtype] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sonflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [parentid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlprp] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [typecode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [typecodestr] [char] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrltype" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_packet] ( " arg_tb[cur_i].createsql_string += " [SerialNum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [TableName] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [SendCusCommID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [SendSCcode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [AddUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [AddTime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ReceiveCusCommID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ReceiveSCcode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ReceiveUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Status] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [BillType] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [Summary] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Postscript] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Remark] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [SendTime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [Complete] [bit] NOT NULL , " arg_tb[cur_i].createsql_string += " [LJFIEBTime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ReceiveTime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ConfirmTime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ConfirmUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [RelatedSerialNum] [uniqueidentifier] NULL , " arg_tb[cur_i].createsql_string += " [RelatedCode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [FailCount] [int] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_packet" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_pztype_def] ( " arg_tb[cur_i].createsql_string += " [typeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [typename] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_pztype_def" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_pztype_mx] ( " arg_tb[cur_i].createsql_string += " [typeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pztype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [tdscrp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_pztype_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempbuyTask] ( " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [TaskID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [TaskCode] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [orderid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [kind] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [sptID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [requiredate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [accomplishdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [finishemp] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [Status] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [Opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [Assign_Emp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Permit_Emp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Permit_date] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [Dscrp] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [stopemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ctmint] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printnum] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [relcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [banktypeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [train] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reason] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [billtype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [firpermitemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [firpermitdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [billamt] [decimal](18, 2) NOT NULL , " arg_tb[cur_i].createsql_string += " [moneyid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mrate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [banktypename] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moneyname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempbuyTaskMx] ( " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [TaskID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [MtrlID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [iforder] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [Qty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [fprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [rebate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [Price] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [AssignQty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [status] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [consignedqty] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [Requiredate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [storageid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [orderid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ctmint] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [uqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [uprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [unit] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [stopflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [stopemp] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [stopdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [stopreason] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rqmxprintid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [requestbuyid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [relrqbuycode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [wrkGrpid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [taskmxprintid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sptbackdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [delayreason] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [stopqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [rebuyqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [buybargainid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [buybargainprintid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [buybargaincode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [accomplishdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [admtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [relprintid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [fpqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [ffpqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [autostopqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [enprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [tax] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlmode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [spt_uqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [spt_enprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [spt_Requiredate] [datetime] NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTaskMx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempoutware] ( " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [outwarecode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [billtype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [relid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [StorageID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [flag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [auditingdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [auditingrep] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [outdate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [outrep] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [part] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cusid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [cusname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [balcflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [balcdateint] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [thflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [secflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [secauditingdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [secauditingrep] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [ctmint] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printnum] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [wagemth] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [otheramt] [decimal](18, 2) NOT NULL , " arg_tb[cur_i].createsql_string += " [relstr_1] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relstr_2] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relstr_3] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relint_1] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [relint_2] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [relint_3] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [priceflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [pricedate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [priceemp] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rel_address] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rel_tele] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rel_fax] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rel_rep] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mrate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [damt] [decimal](18, 2) NOT NULL , " arg_tb[cur_i].createsql_string += " [upname] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ifauto] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [viewdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [deptid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [banktypename] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moneyname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempoutwaremx] ( " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [storageid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [plancode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [status] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [qty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [fprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [rebate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [price] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [costamt] [decimal](18, 2) NOT NULL , " arg_tb[cur_i].createsql_string += " [planprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [mxdscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Sptid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [Dxflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ifrel] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [olmtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [relid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [packqty] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relcode] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [enprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [newpriceamt] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [ctmint] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [outtype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [dftsaleprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [cost] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [planqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [relprintid] [int] NULL , " arg_tb[cur_i].createsql_string += " [uqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [rate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [unit] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [scidprice] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [outtypestr] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [overqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcuscode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [location] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pricetype] [char] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [formula] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [capacity] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [saleqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [saleoutid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [saleoutprintid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [net_weight] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [gross_weight] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [cubage] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [mxdscrp2] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [taxrate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlmode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [fiebrelcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutwaremx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempoutwaremx_mx] ( " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mxprintid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [storageid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [plancode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [status] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcuscode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [location] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [dxflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [planqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [qty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [mxdscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ctmint] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlmode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutwaremx_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempoutwaremx_mx_barcode] ( " arg_tb[cur_i].createsql_string += " [billtype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [barcode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [qty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [ctmint] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutwaremx_mx_barcode" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempquote] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [quoteid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [quotecode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cusid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [quotedate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [assign_emp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [moneyname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [flag] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [fiebrelcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ConfirmTime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ConfirmUser] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempquote" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempquotemx] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [quoteid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlmode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [unit] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [price] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [rebate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [qty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [qty1] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [mxdscrp] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [status] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempquotemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempspt_price_change] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [billid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [billcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [billdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [inrep] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [moneyname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [flag] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [relquotecode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ConfirmTime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ConfirmUser] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_change" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempspt_price_changemx] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [billid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sptmtrlmode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [unit] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [price] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [qty] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [qty1] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_changemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_unit_def] ( " arg_tb[cur_i].createsql_string += " [unitid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [unit] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [unit_en] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ifstandard] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [samedscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_unit_def" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_CusComm] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_CusComm] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [CusCommID] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_CusComm" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_configure_code] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_configure_code] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [typeid], " arg_tb[cur_i].createsql_string += " [pzid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_code" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrl_configure] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_mtrl_configure] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [cid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_configure" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrltype] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_mtrltype] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [mtrltypeid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrltype" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_packet] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_packet] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [SerialNum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_packet" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempquote] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempquote] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [quoteid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempquote" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempquotemx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempquotemx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [quoteid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempquotemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempspt_price_change] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempspt_price_change] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [billid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_change" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempspt_price_changemx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempspt_price_changemx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [billid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_changemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_unit_def] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_unit_def] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [unitid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_unit_def" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_CusComm] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__CusCo__33869366] DEFAULT (0) FOR [CusCommID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__CusTy__347AB79F] DEFAULT (0) FOR [CusType], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__CusCo__356EDBD8] DEFAULT ('') FOR [CusCode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__CusNa__36630011] DEFAULT ('') FOR [CusName], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__CusKe__3757244A] DEFAULT ('') FOR [CusKey], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_CusCo__IP__384B4883] DEFAULT ('') FOR [IP], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__Port1__393F6CBC] DEFAULT ('') FOR [Port1], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__sys_c__3A3390F5] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_Cu__Accep__3B27B52E] DEFAULT (1) FOR [Accept] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_CusComm" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_configure_code] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__typei__034D705F] DEFAULT (0) FOR [typeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_con__pzid__04419498] DEFAULT (0) FOR [pzid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__pzcod__0535B8D1] DEFAULT ('') FOR [pzcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_con__name__0629DD0A] DEFAULT ('') FOR [name], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__input__071E0143] DEFAULT (0) FOR [inputtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__confi__0812257C] DEFAULT (0) FOR [configtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__sys_c__090649B5] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_code" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_configure_codemx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_con__pzid__0BE2B660] DEFAULT (0) FOR [pzid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__print__0CD6DA99] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__pzcod__0DCAFED2] DEFAULT ('') FOR [pzcodemx], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__namem__0EBF230B] DEFAULT ('') FOR [namemx], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__sys_c__0FB34744] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_configure_codemx] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [pzid], " arg_tb[cur_i].createsql_string += " [printid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_codemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_configure_type] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__contf__128FB3EF] DEFAULT (0) FOR [contfigtypeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__contf__1383D828] DEFAULT ('') FOR [contfigtypename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__contf__1477FC61] DEFAULT (0) FOR [contfigtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_co__sys_c__156C209A] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_configure_type] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [contfigtypeid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_type" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrl_configure] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtrl__cid__18488D45] DEFAULT (0) FOR [cid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__Mtrli__193CB17E] DEFAULT (0) FOR [Mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtr__code__1A30D5B7] DEFAULT ('') FOR [code], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtr__name__1B24F9F0] DEFAULT ('') FOR [name], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__ename__1C191E29] DEFAULT ('') FOR [ename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtr__type__1D0D4262] DEFAULT (0) FOR [type], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__dscrp__1E01669B] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__Planp__1EF58AD4] DEFAULT (0) FOR [Planprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__price__1FE9AF0D] DEFAULT (0) FOR [price], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__Defau__20DDD346] DEFAULT (0) FOR [DefaultPZ], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtr__ifzj__21D1F77F] DEFAULT (0) FOR [ifzj], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__capac__22C61BB8] DEFAULT (0) FOR [capacity], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__capap__23BA3FF1] DEFAULT (1) FOR [capaparm], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__sys_c__24AE642A] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrl_configure_net_weight] DEFAULT (0) FOR [net_weight], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrl_configure_gross_weight] DEFAULT (0) FOR [gross_weight], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrl_configure_cubage] DEFAULT (0) FOR [cubage] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_configure" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrl_configure2] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtr__scid__278AD0D5] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtr__pzid__287EF50E] DEFAULT (0) FOR [pzid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__print__29731947] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__Mtrli__2A673D80] DEFAULT (0) FOR [Mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__pzcod__2B5B61B9] DEFAULT ('') FOR [pzcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__pznam__2C4F85F2] DEFAULT ('') FOR [pzname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__pzcod__2D43AA2B] DEFAULT ('') FOR [pzcodemx], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__pznam__2E37CE64] DEFAULT ('') FOR [pznamemx], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__sys_c__2F2BF29D] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_mtrl_configure2] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [pzid], " arg_tb[cur_i].createsql_string += " [printid], " arg_tb[cur_i].createsql_string += " [Mtrlid], " arg_tb[cur_i].createsql_string += " [pzname], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_configure2" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrldef_code] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrlc__32085F48] DEFAULT ('') FOR [mtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrln__32FC8381] DEFAULT ('') FOR [mtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrlt__33F0A7BA] DEFAULT ('') FOR [mtrltype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrls__34E4CBF3] DEFAULT ('') FOR [mtrlsectype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrlm__35D8F02C] DEFAULT ('') FOR [mtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__Mtrlo__36CD1465] DEFAULT (0) FOR [Mtrlorigin], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mtr__unit__37C1389E] DEFAULT ('') FOR [unit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__dscrp__38B55CD7] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__isuse__39A98110] DEFAULT (1) FOR [isuse], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__packq__3A9DA549] DEFAULT (0) FOR [packqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__prdpa__3B91C982] DEFAULT ('') FOR [prdpackcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__net_w__3C85EDBB] DEFAULT (0) FOR [net_weight], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__gross__3D7A11F4] DEFAULT (0) FOR [gross_weight], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__cubag__3E6E362D] DEFAULT (0) FOR [cubage], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrle__3F625A66] DEFAULT ('') FOR [mtrlengname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__zxmtr__40567E9F] DEFAULT ('') FOR [zxmtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__unit___414AA2D8] DEFAULT ('') FOR [unit_scll], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__unit___423EC711] DEFAULT ('') FOR [unit_buy], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__rate___4332EB4A] DEFAULT (0) FOR [rate_buy], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__rate___44270F83] DEFAULT (0) FOR [rate_scll], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__rate___451B33BC] DEFAULT (0) FOR [rate_sale], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__unit___460F57F5] DEFAULT ('') FOR [unit_sale], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__statu__47037C2E] DEFAULT (0) FOR [statusflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__statu__47F7A067] DEFAULT (0) FOR [statustype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__woodc__48EBC4A0] DEFAULT (0) FOR [woodcodeflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__woodc__49DFE8D9] DEFAULT (0) FOR [woodcodetype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__pcode__4AD40D12] DEFAULT (0) FOR [pcodeflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__pcode__4BC8314B] DEFAULT (0) FOR [pcodetype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__userm__4CBC5584] DEFAULT ('') FOR [usermtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__ifcus__4DB079BD] DEFAULT (0) FOR [ifcustom], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__buyun__4EA49DF6] DEFAULT (0) FOR [buyunit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__wfjgu__4F98C22F] DEFAULT (0) FOR [wfjgunit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__scllu__508CE668] DEFAULT (0) FOR [scllunit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__saleu__51810AA1] DEFAULT (0) FOR [saleunit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__buyde__52752EDA] DEFAULT (5) FOR [buydec], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__wfjgd__53695313] DEFAULT (5) FOR [wfjgdec], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__sclld__545D774C] DEFAULT (5) FOR [sclldec], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__saled__55519B85] DEFAULT (5) FOR [saledec], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__statu__5645BFBE] DEFAULT (0) FOR [status_check], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__woodc__5739E3F7] DEFAULT (0) FOR [woodcode_check], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__pcode__582E0830] DEFAULT (0) FOR [pcode_check], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__sys_c__59222C69] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_status_config] DEFAULT ('') FOR [status_config], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_woodcode_config] DEFAULT ('') FOR [woodcode_config], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_pcode_config] DEFAULT ('') FOR [pcode_config], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_configcodetype] DEFAULT (0) FOR [configcodetype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_configcode] DEFAULT ('') FOR [configcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_configname] DEFAULT ('') FOR [configname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_mtrlcolor] DEFAULT ('') FOR [mtrlcolor], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_handtype] DEFAULT ('') FOR [handtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_ifpack] DEFAULT (0) FOR [ifpack], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_ifpackpro] DEFAULT (0) FOR [ifpackpro], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_ifpackpz] DEFAULT (0) FOR [ifpackpz], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_ifpackpro2] DEFAULT (0) FOR [ifpackpro2], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_ifpacktype] DEFAULT (0) FOR [ifpacktype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrldef_code_mtrlprp] DEFAULT (0) FOR [mtrlprp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_mtrldef_code] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [mtrlid], " arg_tb[cur_i].createsql_string += " [mtrlcode], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrldef_code" cur_i++ arg_tb[cur_i].update_version = "5.0.130202" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrltype] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrlt__75F37541] DEFAULT (0) FOR [mtrltypeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrlt__76E7997A] DEFAULT ('') FOR [mtrltype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__handt__77DBBDB3] DEFAULT ('') FOR [handtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__sonfl__78CFE1EC] DEFAULT (1) FOR [sonflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__paren__79C40625] DEFAULT (0) FOR [parentid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__mtrlp__7AB82A5E] DEFAULT (0) FOR [mtrlprp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__typec__7BAC4E97] DEFAULT ('') FOR [typecode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__typec__7CA072D0] DEFAULT ('') FOR [typecodestr], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_mt__sys_c__7D949709] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrltype" end subroutine public subroutine uof_createtable_arr_20130203 (ref s_sys_create_table arg_tb[]);cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_packet] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_SendCusCommID] DEFAULT (0) FOR [SendCusCommID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_SendSCcode] DEFAULT ('') FOR [SendSCcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_AddUser] DEFAULT ('') FOR [AddUser], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_ReceiveCusCommID] DEFAULT (0) FOR [ReceiveCusCommID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_ReceiveSCcode] DEFAULT ('') FOR [ReceiveSCcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_ReceiveUser] DEFAULT ('') FOR [ReceiveUser], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_Status] DEFAULT (0) FOR [Status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_BillType] DEFAULT (0) FOR [BillType], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_Summary] DEFAULT ('') FOR [Summary], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_Postscript] DEFAULT ('') FOR [Postscript], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_Remark] DEFAULT ('') FOR [Remark], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_Complete] DEFAULT (0) FOR [Complete], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_packet_RelatedCode] DEFAULT ('') FOR [RelatedCode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pa__FailC__703A9BEB] DEFAULT (0) FOR [FailCount] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_packet" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_pztype_def] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__typei__5BFE9914] DEFAULT (0) FOR [typeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__typen__5CF2BD4D] DEFAULT ('') FOR [typename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__sys_c__5DE6E186] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_pztype_def] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [typeid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_pztype_def" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_pztype_mx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__typei__60C34E31] DEFAULT (0) FOR [typeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__pztyp__61B7726A] DEFAULT (0) FOR [pztype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__dscrp__62AB96A3] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__tdscr__639FBADC] DEFAULT ('') FOR [tdscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_pz__sys_c__6493DF15] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_pztype_mx] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [typeid], " arg_tb[cur_i].createsql_string += " [pztype], " arg_tb[cur_i].createsql_string += " [dscrp], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_pztype_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempbuyTask] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__TaskC__67704BC0] DEFAULT ('') FOR [TaskCode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__order__68646FF9] DEFAULT (0) FOR [orderid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__kind__69589432] DEFAULT (0) FOR [kind], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sptID__6A4CB86B] DEFAULT (0) FOR [sptID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Statu__6B40DCA4] DEFAULT (0) FOR [Status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Opemp__6C3500DD] DEFAULT ('') FOR [Opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Modem__6D292516] DEFAULT ('') FOR [Modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Assig__6E1D494F] DEFAULT ('') FOR [Assign_Emp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Permi__6F116D88] DEFAULT ('') FOR [Permit_Emp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Dscrp__700591C1] DEFAULT ('') FOR [Dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stope__70F9B5FA] DEFAULT ('') FOR [stopemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ctmin__71EDDA33] DEFAULT (0) FOR [ctmint], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__print__72E1FE6C] DEFAULT (0) FOR [printnum], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relco__73D622A5] DEFAULT ('') FOR [relcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__bankt__74CA46DE] DEFAULT (0) FOR [banktypeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__train__75BE6B17] DEFAULT ('') FOR [train], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__reaso__76B28F50] DEFAULT ('') FOR [reason], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__billt__77A6B389] DEFAULT (0) FOR [billtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__firpe__789AD7C2] DEFAULT ('') FOR [firpermitemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__billa__798EFBFB] DEFAULT (0) FOR [billamt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__money__7A832034] DEFAULT (0) FOR [moneyid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mrate__7B77446D] DEFAULT (1) FOR [mrate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sys_c__7C6B68A6] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTask_banktypename] DEFAULT ('') FOR [banktypename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTask_moneyname] DEFAULT ('') FOR [moneyname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempbuyTask] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [TaskID], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempbuyTaskMx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTaskMx_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTaskMx_TaskID] DEFAULT (0) FOR [TaskID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTaskMx_MtrlID] DEFAULT (0) FOR [MtrlID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__iford__7F47D551] DEFAULT (0) FOR [iforder], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_temp__Qty__003BF98A] DEFAULT (0) FOR [Qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__fpric__01301DC3] DEFAULT (0) FOR [fprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rebat__022441FC] DEFAULT (1) FOR [rebate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Price__03186635] DEFAULT (0) FOR [Price], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Assig__040C8A6E] DEFAULT (0) FOR [AssignQty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__statu__0500AEA7] DEFAULT ('') FOR [status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__dscrp__05F4D2E0] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__print__06E8F719] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__consi__07DD1B52] DEFAULT (0) FOR [consignedqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Requi__08D13F8B] DEFAULT (getdate()) FOR [Requiredate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stora__09C563C4] DEFAULT (0) FOR [storageid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__order__0AB987FD] DEFAULT (0) FOR [orderid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ctmin__0BADAC36] DEFAULT (0) FOR [ctmint], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sptmt__0CA1D06F] DEFAULT ('') FOR [sptmtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__uqty__0D95F4A8] DEFAULT (0) FOR [uqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__upric__0E8A18E1] DEFAULT (0) FOR [uprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__unit__0F7E3D1A] DEFAULT ('') FOR [unit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__rate__10726153] DEFAULT (1) FOR [rate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stopf__1166858C] DEFAULT (0) FOR [stopflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stope__125AA9C5] DEFAULT ('') FOR [stopemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stopr__134ECDFE] DEFAULT ('') FOR [stopreason], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__woodc__1442F237] DEFAULT ('') FOR [woodcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__pcode__15371670] DEFAULT ('') FOR [pcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rqmxp__162B3AA9] DEFAULT (0) FOR [rqmxprintid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__reque__171F5EE2] DEFAULT (0) FOR [requestbuyid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relrq__1813831B] DEFAULT ('') FOR [relrqbuycode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__wrkGr__1907A754] DEFAULT (0) FOR [wrkGrpid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__taskm__19FBCB8D] DEFAULT (0) FOR [taskmxprintid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__delay__1AEFEFC6] DEFAULT ('') FOR [delayreason], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stopq__1BE413FF] DEFAULT (0) FOR [stopqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rebuy__1CD83838] DEFAULT (0) FOR [rebuyqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__buyba__1DCC5C71] DEFAULT (0) FOR [buybargainid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__buyba__1EC080AA] DEFAULT (0) FOR [buybargainprintid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__buyba__1FB4A4E3] DEFAULT ('') FOR [buybargaincode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__admtr__20A8C91C] DEFAULT (0) FOR [admtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relpr__219CED55] DEFAULT (0) FOR [relprintid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__fpqty__2291118E] DEFAULT (0) FOR [fpqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ffpqt__238535C7] DEFAULT (0) FOR [ffpqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__autos__24795A00] DEFAULT (0) FOR [autostopqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__enpri__256D7E39] DEFAULT (0) FOR [enprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_temp__tax__2661A272] DEFAULT (0) FOR [tax], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sys_c__2755C6AB] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTaskMx_sptmtrlcode] DEFAULT ('') FOR [sptmtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTaskMx_sptmtrlmode] DEFAULT ('') FOR [sptmtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTaskMx_spt_uqty] DEFAULT (0) FOR [spt_uqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempbuyTaskMx_spt_enprice] DEFAULT (0) FOR [spt_enprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempbuyTaskMx] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [TaskID], " arg_tb[cur_i].createsql_string += " [printid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTaskMx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempoutware] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__outwa__2A323356] DEFAULT ('') FOR [outwarecode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__billt__2B26578F] DEFAULT (0) FOR [billtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relid__2C1A7BC8] DEFAULT (0) FOR [relid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Stora__2D0EA001] DEFAULT (0) FOR [StorageID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__opemp__2E02C43A] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Modem__2EF6E873] DEFAULT ('') FOR [Modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__flag__2FEB0CAC] DEFAULT (0) FOR [flag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__audit__30DF30E5] DEFAULT ('') FOR [auditingrep], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__outre__31D3551E] DEFAULT ('') FOR [outrep], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__part__32C77957] DEFAULT ('') FOR [part], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__dscrp__33BB9D90] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__cusid__34AFC1C9] DEFAULT (0) FOR [cusid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__cusna__35A3E602] DEFAULT ('') FOR [cusname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__balcf__36980A3B] DEFAULT (0) FOR [balcflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__balcd__378C2E74] DEFAULT (0) FOR [balcdateint], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__thfla__388052AD] DEFAULT (0) FOR [thflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__secfl__397476E6] DEFAULT (0) FOR [secflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ctmin__3A689B1F] DEFAULT (0) FOR [ctmint], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__print__3B5CBF58] DEFAULT (0) FOR [printnum], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__wagem__3C50E391] DEFAULT (0) FOR [wagemth], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__other__3D4507CA] DEFAULT (0) FOR [otheramt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relst__3E392C03] DEFAULT ('') FOR [relstr_1], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relst__3F2D503C] DEFAULT ('') FOR [relstr_2], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relst__40217475] DEFAULT ('') FOR [relstr_3], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relin__411598AE] DEFAULT (0) FOR [relint_1], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relin__4209BCE7] DEFAULT (0) FOR [relint_2], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relin__42FDE120] DEFAULT (0) FOR [relint_3], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__price__43F20559] DEFAULT (0) FOR [priceflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__price__44E62992] DEFAULT ('') FOR [priceemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rel_a__45DA4DCB] DEFAULT ('') FOR [rel_address], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rel_t__46CE7204] DEFAULT ('') FOR [rel_tele], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rel_f__47C2963D] DEFAULT ('') FOR [rel_fax], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rel_r__48B6BA76] DEFAULT ('') FOR [rel_rep], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mrate__49AADEAF] DEFAULT (0) FOR [mrate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__damt__4A9F02E8] DEFAULT (0) FOR [damt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__upnam__4B932721] DEFAULT ('') FOR [upname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ifaut__4C874B5A] DEFAULT (0) FOR [ifauto], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__depti__4D7B6F93] DEFAULT (0) FOR [deptid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sys_c__4E6F93CC] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_banktypename] DEFAULT ('') FOR [banktypename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_moneyname] DEFAULT ('') FOR [moneyname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempoutware] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [outwareid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempoutwaremx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mtrlw__514C0077] DEFAULT (0) FOR [mtrlwareid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mtrli__524024B0] DEFAULT (0) FOR [mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stora__533448E9] DEFAULT (0) FOR [storageid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__planc__54286D22] DEFAULT ('') FOR [plancode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__statu__551C915B] DEFAULT ('') FOR [status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_temp__qty__5610B594] DEFAULT (0) FOR [qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__fpric__5704D9CD] DEFAULT (0) FOR [fprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__rebat__57F8FE06] DEFAULT (1) FOR [rebate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__price__58ED223F] DEFAULT (0) FOR [price], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__costa__59E14678] DEFAULT (0) FOR [costamt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__planp__5AD56AB1] DEFAULT (0) FOR [planprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mxdsc__5BC98EEA] DEFAULT ('') FOR [mxdscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Sptid__5CBDB323] DEFAULT (0) FOR [Sptid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__Dxfla__5DB1D75C] DEFAULT (0) FOR [Dxflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__print__5EA5FB95] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ifrel__5F9A1FCE] DEFAULT (0) FOR [ifrel], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__olmtr__608E4407] DEFAULT (0) FOR [olmtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relid__61826840] DEFAULT (0) FOR [relid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__packq__62768C79] DEFAULT (0) FOR [packqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__woodc__636AB0B2] DEFAULT ('') FOR [woodcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relco__645ED4EB] DEFAULT ('') FOR [relcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__pcode__6552F924] DEFAULT ('') FOR [pcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__enpri__66471D5D] DEFAULT (0) FOR [enprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__newpr__673B4196] DEFAULT (0) FOR [newpriceamt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ctmin__682F65CF] DEFAULT (0) FOR [ctmint], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__outty__69238A08] DEFAULT (0) FOR [outtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__dftsa__6A17AE41] DEFAULT (0) FOR [dftsaleprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__cost__6B0BD27A] DEFAULT (0) FOR [cost], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__planq__6BFFF6B3] DEFAULT (0) FOR [planqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__relpr__6CF41AEC] DEFAULT (0) FOR [relprintid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__uqty__6DE83F25] DEFAULT (0) FOR [uqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__rate__6EDC635E] DEFAULT (0) FOR [rate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__unit__6FD08797] DEFAULT ('') FOR [unit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__scidp__70C4ABD0] DEFAULT (0) FOR [scidprice], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__outty__71B8D009] DEFAULT ('') FOR [outtypestr], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__overq__72ACF442] DEFAULT (0) FOR [overqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mtrlc__73A1187B] DEFAULT ('') FOR [mtrlcuscode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__locat__74953CB4] DEFAULT ('') FOR [location], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__price__758960ED] DEFAULT ('') FOR [pricetype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__formu__767D8526] DEFAULT ('') FOR [formula], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__capac__7771A95F] DEFAULT (0) FOR [capacity], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__saleq__7865CD98] DEFAULT (0) FOR [saleqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__saleo__7959F1D1] DEFAULT (0) FOR [saleoutid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__saleo__7A4E160A] DEFAULT (0) FOR [saleoutprintid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__net_w__7B423A43] DEFAULT (0) FOR [net_weight], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__gross__7C365E7C] DEFAULT (0) FOR [gross_weight], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__cubag__7D2A82B5] DEFAULT (0) FOR [cubage], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mxdsc__7E1EA6EE] DEFAULT ('') FOR [mxdscrp2], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__taxra__7F12CB27] DEFAULT (0) FOR [taxrate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sys_c__0006EF60] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_sptmtrlcode] DEFAULT ('') FOR [sptmtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_sptmtrlname] DEFAULT ('') FOR [sptmtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_sptmtrlmode] DEFAULT ('') FOR [sptmtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_fiebrelcode] DEFAULT ('') FOR [fiebrelcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempoutwaremx] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [outwareid], " arg_tb[cur_i].createsql_string += " [printid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutwaremx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempoutwaremx_mx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__scid__02E35C0B] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__outwa__03D78044] DEFAULT (0) FOR [outwareid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__print__04CBA47D] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mxpri__05BFC8B6] DEFAULT (0) FOR [mxprintid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mtrlw__06B3ECEF] DEFAULT (0) FOR [mtrlwareid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__stora__07A81128] DEFAULT (0) FOR [storageid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mtrli__089C3561] DEFAULT (0) FOR [mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__planc__0990599A] DEFAULT ('') FOR [plancode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__statu__0A847DD3] DEFAULT ('') FOR [status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__woodc__0B78A20C] DEFAULT ('') FOR [woodcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__pcode__0C6CC645] DEFAULT ('') FOR [pcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mtrlc__0D60EA7E] DEFAULT ('') FOR [mtrlcuscode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__locat__0E550EB7] DEFAULT ('') FOR [location], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sptid__0F4932F0] DEFAULT (0) FOR [sptid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__dxfla__103D5729] DEFAULT (0) FOR [dxflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__planq__11317B62] DEFAULT (0) FOR [planqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_temp__qty__12259F9B] DEFAULT (0) FOR [qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__mxdsc__1319C3D4] DEFAULT ('') FOR [mxdscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ctmin__140DE80D] DEFAULT (0) FOR [ctmint], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sys_c__15020C46] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_mx_sptmtrlcode] DEFAULT ('') FOR [sptmtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_mx_sptmtrlname] DEFAULT ('') FOR [sptmtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_mx_sptmtrlmode] DEFAULT ('') FOR [sptmtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempoutwaremx_mx] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [outwareid], " arg_tb[cur_i].createsql_string += " [printid], " arg_tb[cur_i].createsql_string += " [mxprintid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutwaremx_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempoutwaremx_mx_barcode] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__billt__17DE78F1] DEFAULT (0) FOR [billtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_tem__scid__18D29D2A] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__outwa__19C6C163] DEFAULT (0) FOR [outwareid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__barco__1ABAE59C] DEFAULT ('') FOR [barcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_temp__qty__1BAF09D5] DEFAULT (0) FOR [qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__ctmin__1CA32E0E] DEFAULT (0) FOR [ctmint], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_te__sys_c__1D975247] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutwaremx_mx_barcode_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempoutwaremx_mx_barcode] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [billtype], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [outwareid], " arg_tb[cur_i].createsql_string += " [barcode], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutwaremx_mx_barcode" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempquote] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_quoteid] DEFAULT (0) FOR [quoteid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_quotecode] DEFAULT ('') FOR [quotecode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_cusid] DEFAULT (0) FOR [cusid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_assign_emp] DEFAULT ('') FOR [assign_emp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_relcode] DEFAULT ('') FOR [relcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_moneyname] DEFAULT ('') FOR [moneyname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_flag] DEFAULT (0) FOR [flag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_fiebrelcode] DEFAULT ('') FOR [fiebrelcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquote_ConfirmUser] DEFAULT ('') FOR [ConfirmUser] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempquote" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempquotemx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_quoteid] DEFAULT (0) FOR [quoteid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_mtrlid] DEFAULT (0) FOR [mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_mtrlcode] DEFAULT ('') FOR [mtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_mtrlname] DEFAULT ('') FOR [mtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_mtrlmode] DEFAULT ('') FOR [mtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_unit] DEFAULT ('') FOR [unit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_price] DEFAULT (0) FOR [price], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_rebate] DEFAULT (1) FOR [rebate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_qty] DEFAULT (0) FOR [qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_qty1] DEFAULT (0) FOR [qty1], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_mxdscrp] DEFAULT ('') FOR [mxdscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_status] DEFAULT ('') FOR [status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_woodcode] DEFAULT ('') FOR [woodcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempquotemx_pcode] DEFAULT ('') FOR [pcode] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempquotemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempspt_price_change] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_billid] DEFAULT (0) FOR [billid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_billcode] DEFAULT ('') FOR [billcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_inrep] DEFAULT ('') FOR [inrep], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_moneyname] DEFAULT ('') FOR [moneyname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_flag] DEFAULT (0) FOR [flag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_relquotecode] DEFAULT ('') FOR [relquotecode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_change_ConfirmUser] DEFAULT ('') FOR [ConfirmUser] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_change" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempspt_price_changemx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_billid] DEFAULT (0) FOR [billid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_mtrlid] DEFAULT (0) FOR [mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_sptmtrlcode] DEFAULT ('') FOR [sptmtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_sptmtrlname] DEFAULT ('') FOR [sptmtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_sptmtrlmode] DEFAULT ('') FOR [sptmtrlmode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_unit] DEFAULT ('') FOR [unit], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_price] DEFAULT (0) FOR [price], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_qty] DEFAULT (0) FOR [qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_qty1] DEFAULT (0) FOR [qty1], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempspt_price_changemx_dscrp] DEFAULT ('') FOR [dscrp] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_changemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_unit_def] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF__LJFIEB_un__sys_c__007103B4] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_unit_def" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempspt_price_changemx add status varchar(255) not null " arg_tb[cur_i].createsql_string += " constraint DF_LJFIEB_tempspt_price_changemx_status default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_changemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempspt_price_changemx add woodcode varchar(255) not null " arg_tb[cur_i].createsql_string += " constraint DF_LJFIEB_tempspt_price_changemx_woodcode default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_changemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempspt_price_changemx add pcode varchar(255) not null " arg_tb[cur_i].createsql_string += " constraint DF_LJFIEB_tempspt_price_changemx_pcode default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_changemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempspt_price_changemx add jgdscrp varchar(255) not null " arg_tb[cur_i].createsql_string += " constraint DF_LJFIEB_tempspt_price_changemx_jgdscrp default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempspt_price_changemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_color] ( " arg_tb[cur_i].createsql_string += " [colorid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [colorname] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_color_pcode] ( " arg_tb[cur_i].createsql_string += " [pcodeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_pcode" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_color_wood] ( " arg_tb[cur_i].createsql_string += " [woodcodeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_wood" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_color] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_color] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [colorid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_color_pcode] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_color_pcode] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [pcodeid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_pcode" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_color_wood] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_color_wood] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [woodcodeid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_wood" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_color] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_colorname] DEFAULT ('') FOR [colorname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_printid] DEFAULT ('') FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color" //cur_i++ arg_tb[cur_i].update_version = "5.0.130203" //arg_tb[cur_i].createsql_string += " CREATE UNIQUE INDEX [IX_LJFIEB_color] ON [dbo].[LJFIEB_color]([colorname]) ON [PRIMARY] " //arg_tb[cur_i].ifmx = 0 //arg_tb[cur_i].tbname = "LJFIEB_color" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_color_pcode] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_pcode_pcodeid] DEFAULT (0) FOR [pcodeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_pcode_pcode] DEFAULT ('') FOR [pcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_pcode_printid] DEFAULT ('') FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_pcode_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_pcode" //cur_i++ arg_tb[cur_i].update_version = "5.0.130203" //arg_tb[cur_i].createsql_string += " CREATE UNIQUE INDEX [IX_LJFIEB_color_pcode] ON [dbo].[LJFIEB_color_pcode]([pcode]) ON [PRIMARY] " //arg_tb[cur_i].ifmx = 0 //arg_tb[cur_i].tbname = "LJFIEB_color_pcode" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_color_wood] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_wood_woodcodeid] DEFAULT (0) FOR [woodcodeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_wood_woodcode] DEFAULT ('') FOR [woodcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_wood_printid] DEFAULT ('') FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_color_wood_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_wood" //cur_i++ arg_tb[cur_i].update_version = "5.0.130203" //arg_tb[cur_i].createsql_string += " CREATE UNIQUE INDEX [IX_LJFIEB_color_wood] ON [dbo].[LJFIEB_color_wood]([woodcode]) ON [PRIMARY] " //arg_tb[cur_i].ifmx = 0 //arg_tb[cur_i].tbname = "LJFIEB_color_wood" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " drop index LJFIEB_color.IX_LJFIEB_color " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " drop index LJFIEB_color_pcode.IX_LJFIEB_color_pcode " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_pcode" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " drop index LJFIEB_color_wood.IX_LJFIEB_color_wood " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_wood" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_email_letterpaper] ( " arg_tb[cur_i].createsql_string += " [paperid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ownerid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [papertype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [picData] [image] NULL , " arg_tb[cur_i].createsql_string += " [PicLen] [numeric](18, 0) NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [papername] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [style] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [model] [text] COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [lenDetail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [datatype] [int] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_letterpaper" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_email_letterpaper] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_email_letterpaper] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [paperid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_letterpaper" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += "ALTER TABLE [dbo].[u_email_letterpaper] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_email_letterpaper_ownerid] DEFAULT (0) FOR [ownerid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_email_letterpaper_type] DEFAULT (1) FOR [papertype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_email_letterpaper_opdate] DEFAULT ('1900-01-01 00:00:00') FOR [opdate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_email_letterpaper_style] DEFAULT (N'简约') FOR [style], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_email_letterpaper_datatype] DEFAULT (1) FOR [datatype] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_letterpaper" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += "CREATE TABLE [dbo].[U_email_signature] ( " arg_tb[cur_i].createsql_string += " [id] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ownerid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [signName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [signContent] [text] COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL " arg_tb[cur_i].createsql_string += ") ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "U_email_signature" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += "ALTER TABLE [dbo].[U_email_signature] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_U_email_signature] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [id] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "U_email_signature" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += "ALTER TABLE [dbo].[U_email_signature] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_U_email_signature_id] DEFAULT (0) FOR [id], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_U_email_signature_ownerid] DEFAULT (0) FOR [ownerid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_U_email_signature_signName] DEFAULT ('') FOR [signName], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_U_email_signature_signContent] DEFAULT ('') FOR [signContent] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "U_email_signature" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD repname varchar(255) NOT NULL CONSTRAINT DF_u_email_sendmx_repname DEFAULT '' " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += "CREATE TABLE [dbo].[LJFIEB_mtrlware] ( " arg_tb[cur_i].createsql_string += " [SerialNum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [storagename] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [status] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [woodcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [pcode] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [plancode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcuscode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [location] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [notauditnoallocqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += ") ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrlware" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrlware] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_mtrlware] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [SerialNum], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [mtrlwareid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrlware" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrlware] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_mtrlwareid] DEFAULT (0) FOR [mtrlwareid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_mtrlid] DEFAULT (0) FOR [mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_mtrlcode] DEFAULT ('') FOR [mtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_mtrlname] DEFAULT ('') FOR [mtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_storagename] DEFAULT ('') FOR [storagename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_status] DEFAULT ('') FOR [status], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_woodcode] DEFAULT ('') FOR [woodcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_pcode] DEFAULT ('') FOR [pcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_plancode] DEFAULT ('') FOR [plancode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_mtrlcuscode] DEFAULT ('') FOR [mtrlcuscode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_location] DEFAULT ('') FOR [location], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_noauditingqty] DEFAULT (0) FOR [notauditnoallocqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlware_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrlware" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_sys_post] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [CusCommID] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [postid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [edate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [areaname] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_sys_post" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_sys_post] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_sys_post] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [CusCommID], " arg_tb[cur_i].createsql_string += " [postid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_sys_post" cur_i++ arg_tb[cur_i].update_version = "5.0.130203" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_sys_post] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_sys_post_CusCommID] DEFAULT (0) FOR [CusCommID], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_sys_post_postid] DEFAULT (0) FOR [postid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_sys_post_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_sys_post_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_sys_post_areaname] DEFAULT ('') FOR [areaname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_sys_post_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_sys_post" end subroutine public subroutine uof_createtable_arr_20130204 (ref s_sys_create_table arg_tb[]);cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_reissue] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [reissueid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [reissuecode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cuscode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cusname] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reissuedate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [banktypename] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moneyname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reissueemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [itemcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [itemname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [auditingrep] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [auditingdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [type] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [flag] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [fiebrelcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [confirmtime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [confirmuser] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [relreissuecode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissue" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_reissuemx] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [reissueid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [expensescode] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [expensesname] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [qty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [amt] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [price] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [tax] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissuemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissue] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_reissue] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [reissueid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissue" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissuemx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_reissuemx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [reissueid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissuemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissue] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_reissueid] DEFAULT (0) FOR [reissueid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_reissuecode] DEFAULT ('') FOR [reissuecode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_cuscode] DEFAULT ('') FOR [cuscode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_cusname] DEFAULT ('') FOR [cusname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_banktypename] DEFAULT ('') FOR [banktypename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_moneyname] DEFAULT ('') FOR [moneyname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_relcode] DEFAULT ('') FOR [relcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_reissueemp] DEFAULT ('') FOR [reissueemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_itemcode] DEFAULT ('') FOR [itemcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_itemname] DEFAULT ('') FOR [itemname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_modemp] DEFAULT ('') FOR [modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_auditingrep] DEFAULT ('') FOR [auditingrep], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_type] DEFAULT (0) FOR [type], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_flag] DEFAULT (0) FOR [flag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_fiebrelcode] DEFAULT ('') FOR [fiebrelcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_confirmuser] DEFAULT ('') FOR [confirmuser], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissue_relreissuecode] DEFAULT ('') FOR [relreissuecode] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissue" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_reissuemx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_reissueid] DEFAULT (0) FOR [reissueid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_expensescode] DEFAULT ('') FOR [expensescode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_expensesname] DEFAULT ('') FOR [expensesname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_qty] DEFAULT (0) FOR [qty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_amt] DEFAULT (0) FOR [amt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_price] DEFAULT (0) FOR [price], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_tax] DEFAULT (0) FOR [tax], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_reissuemx_dscrp] DEFAULT ('') FOR [dscrp] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_reissuemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE u_email_msg ALTER COLUMN opemp char(255) " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_ljmail_fj] ( " arg_tb[cur_i].createsql_string += " [SerialNum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [msgid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [filename] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [fileblob] [image] NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_fj" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_ljmail_msg] ( " arg_tb[cur_i].createsql_string += " [SerialNum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [msgid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [boxid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendcomid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendcomname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sendempid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendempname] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sendflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [subject] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [htmlbody] [text] COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reltype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [relid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendtime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ljmail] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_ljmail_msgmx] ( " arg_tb[cur_i].createsql_string += " [SerialNum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [msgid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [comid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [comname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [empid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [empname] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reltype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [relid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ljmail] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_msgmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_ljmail_fj] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_ljmail_fj] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [SerialNum], " arg_tb[cur_i].createsql_string += " [msgid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_fj" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_ljmail_msg] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_ljmail_msg] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [SerialNum], " arg_tb[cur_i].createsql_string += " [msgid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_ljmail_msgmx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_ljmail_msgmx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [SerialNum], " arg_tb[cur_i].createsql_string += " [msgid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_msgmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_ljmail_fj] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_fj_filename] DEFAULT ('') FOR [filename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_fj_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_fj" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_ljmail_msg] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_boxid] DEFAULT (0) FOR [boxid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_sendcomid] DEFAULT (0) FOR [sendcomid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_sendcomname] DEFAULT ('') FOR [sendcomname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_sendempid] DEFAULT (0) FOR [sendempid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_sendempname] DEFAULT ('') FOR [sendempname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_sendflag] DEFAULT (0) FOR [sendflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_opdate] DEFAULT (getdate()) FOR [opdate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_modemp] DEFAULT ('') FOR [modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_subject] DEFAULT ('') FOR [subject], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_htmlbody] DEFAULT ('') FOR [htmlbody], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_reltype] DEFAULT (0) FOR [reltype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_relid] DEFAULT (0) FOR [relid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_ljmail] DEFAULT ('') FOR [ljmail], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msg_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_ljmail_msgmx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_comid] DEFAULT (0) FOR [comid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_comname] DEFAULT ('') FOR [comname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_empid] DEFAULT (0) FOR [empid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_empname] DEFAULT ('') FOR [empname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_reltype] DEFAULT (0) FOR [reltype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_relid] DEFAULT (0) FOR [relid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_ljmail] DEFAULT ('') FOR [ljmail], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_ljmail_msgmx_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_ljmail_msgmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_ljmail_fj] ( " arg_tb[cur_i].createsql_string += " [msgid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [filename] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [fileblob] [image] NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_fj" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_ljmail_msg] ( " arg_tb[cur_i].createsql_string += " [msgid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [boxid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendcomid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendcomname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sendempid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendempname] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sendflag] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [subject] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [htmlbody] [text] COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reltype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [relid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sendtime] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [ljmail] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[u_ljmail_msgmx] ( " arg_tb[cur_i].createsql_string += " [msgid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [comid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [comname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [empid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [empname] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [reltype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [relid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ljmail] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_msgmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_ljmail_fj] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_ljmail_fj] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [msgid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_fj" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_ljmail_msg] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_ljmail_msg] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [msgid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_ljmail_msgmx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_u_ljmail_msgmx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [msgid], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_msgmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_ljmail_fj] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_fj_filename] DEFAULT ('') FOR [filename] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_fj" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_ljmail_msg] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_boxid] DEFAULT (0) FOR [boxid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_sendcomid] DEFAULT (0) FOR [sendcomid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_sendcomname] DEFAULT ('') FOR [sendcomname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_sendempid] DEFAULT (0) FOR [sendempid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_sendempname] DEFAULT ('') FOR [sendempname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_sendflag] DEFAULT (0) FOR [sendflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_opdate] DEFAULT (getdate()) FOR [opdate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_modemp] DEFAULT ('') FOR [modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_subject] DEFAULT ('') FOR [subject], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_htmlbody] DEFAULT ('') FOR [htmlbody], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_reltype] DEFAULT (0) FOR [reltype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_relid] DEFAULT (0) FOR [relid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msg_ljmail] DEFAULT ('') FOR [ljmail] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[u_ljmail_msgmx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msgmx_comid] DEFAULT (0) FOR [comid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msgmx_comname] DEFAULT ('') FOR [comname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msgmx_empid] DEFAULT (0) FOR [empid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msgmx_empname] DEFAULT ('') FOR [empname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msgmx_reltype] DEFAULT (0) FOR [reltype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msgmx_relid] DEFAULT (0) FOR [relid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_u_ljmail_msgmx_ljmail] DEFAULT ('') FOR [ljmail] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_msgmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE LJFIEB_tempoutware ADD confirmuser char(10) NOT NULL CONSTRAINT DF_LJFIEB_tempoutware_confirmuser DEFAULT '' " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE LJFIEB_tempoutware ADD relreissuecode char(20) NOT NULL CONSTRAINT DF_LJFIEB_tempoutware_relreissuecode DEFAULT '' " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE LJFIEB_tempoutware ADD confirmtime datetime NULL " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[ros_cust] ( " arg_tb[cur_i].createsql_string += " [cusid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [cuscode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [name] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [custype] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [rep] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [tele] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [tele1] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [bank] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cunt] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [address] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [code] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [faxno] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [maxmtnum] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [pricelistid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [inuse] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cusareaid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [cusareaname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [areaname] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [email] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [givebackrate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [freight] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [freight_tele] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [upname] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [state] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [peoplenum] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mainmarket] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [saleamt] [decimal](18, 2) NOT NULL , " arg_tb[cur_i].createsql_string += " [nethttp] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [trade] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [corporation] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [grade] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [ifself] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [cuskind] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [simplename] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , " arg_tb[cur_i].createsql_string += " [viewdaynum] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [subid] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [tele_sms] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [banktypeid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [styleid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [moneyid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [auditemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [auditdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [rebate] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [transday] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [ifecomm] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [commcode] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [commsccode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[ros_cust_rep] ( " arg_tb[cur_i].createsql_string += " [repid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [cusid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [repname] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [duty] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sex] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [officetel] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [handtel] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [faxno] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [email] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [deptname] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [interest] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mainproduct] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [opdate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [opemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [moddate] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [modemp] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [qqcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [msncode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [address] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [Permissions] [text] COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [password] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [loginname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL , " arg_tb[cur_i].createsql_string += " [reptype] [tinyint] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust_rep" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[sys_func_pwr_eb] ( " arg_tb[cur_i].createsql_string += " [funcid] [int] IDENTITY (11, 1) NOT NULL , " arg_tb[cur_i].createsql_string += " [parentid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mainid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [functype] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [treename] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [menuname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [if_use] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sortflag] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ebtype] [tinyint] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "sys_func_pwr_eb" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[sys_func_pwr_eb] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_sys_func_pwr_eb] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [funcid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "sys_func_pwr_eb" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[ros_cust] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_cuscode] DEFAULT ('') FOR [cuscode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_name] DEFAULT ('') FOR [name], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_custype] DEFAULT ('') FOR [custype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep] DEFAULT ('') FOR [rep], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_tele] DEFAULT ('') FOR [tele], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_tele1] DEFAULT ('') FOR [tele1], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_bank] DEFAULT ('') FOR [bank], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_cunt] DEFAULT ('') FOR [cunt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_address] DEFAULT ('') FOR [address], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_code] DEFAULT ('') FOR [code], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_faxno] DEFAULT ('') FOR [faxno], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_maxmtnum] DEFAULT (0) FOR [maxmtnum], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_pricelistid] DEFAULT (0) FOR [pricelistid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_inuse] DEFAULT (1) FOR [inuse], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_cusareaid] DEFAULT (0) FOR [cusareaid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_cusareaname] DEFAULT ('') FOR [cusareaname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_areaname] DEFAULT ('') FOR [areaname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_email] DEFAULT ('') FOR [email], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_givebackrate] DEFAULT (0) FOR [givebackrate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_freight] DEFAULT ('') FOR [freight], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_freight_tele] DEFAULT ('') FOR [freight_tele], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_upname] DEFAULT ('') FOR [upname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_modemp] DEFAULT ('') FOR [modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_state] DEFAULT (1) FOR [state], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_peoplenum] DEFAULT (0) FOR [peoplenum], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_mainmarket] DEFAULT ('') FOR [mainmarket], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_saleamt] DEFAULT (0) FOR [saleamt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_nethttp] DEFAULT ('') FOR [nethttp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_trade] DEFAULT ('') FOR [trade], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_corporation] DEFAULT ('') FOR [corporation], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_grade] DEFAULT ('') FOR [grade], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_ifself] DEFAULT (0) FOR [ifself], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_cuskind] DEFAULT ('') FOR [cuskind], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_simplename] DEFAULT ('') FOR [simplename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_viewdaynum] DEFAULT (0) FOR [viewdaynum], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_subid] DEFAULT ('') FOR [subid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_tele_sms] DEFAULT ('') FOR [tele_sms], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_banktypeid] DEFAULT (0) FOR [banktypeid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_styleid] DEFAULT (0) FOR [styleid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_moneyid] DEFAULT (0) FOR [moneyid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_auditemp] DEFAULT ('') FOR [auditemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rebate] DEFAULT (1) FOR [rebate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_transday] DEFAULT (0) FOR [transday], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_ifecomm] DEFAULT (0) FOR [ifecomm], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_commcode] DEFAULT ('') FOR [commcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_commsccode] DEFAULT ('') FOR [commsccode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_ros_cust] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [cusid], " arg_tb[cur_i].createsql_string += " [cuscode], " arg_tb[cur_i].createsql_string += " [pricelistid], " arg_tb[cur_i].createsql_string += " [cusareaid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[ros_cust_rep] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_repid] DEFAULT (0) FOR [repid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_cusid] DEFAULT (0) FOR [cusid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_repname] DEFAULT ('') FOR [repname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_duty] DEFAULT ('') FOR [duty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_sex] DEFAULT ('') FOR [sex], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_officetel] DEFAULT ('') FOR [officetel], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_handtell] DEFAULT ('') FOR [handtel], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_faxno] DEFAULT ('') FOR [faxno], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_email] DEFAULT ('') FOR [email], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_deptname] DEFAULT ('') FOR [deptname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_interest] DEFAULT ('') FOR [interest], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_mainproduct] DEFAULT ('') FOR [mainproduct], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_opdate] DEFAULT (getdate()) FOR [opdate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_opemp] DEFAULT ('') FOR [opemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_moddate] DEFAULT (getdate()) FOR [moddate], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_modemp] DEFAULT ('') FOR [modemp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_qqcode] DEFAULT ('') FOR [qqcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_msncode] DEFAULT ('') FOR [msncode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_address] DEFAULT ('') FOR [address], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_Permissions] DEFAULT ('') FOR [Permissions], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_password] DEFAULT ('') FOR [password], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_loginname] DEFAULT ('') FOR [loginname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_reptype] DEFAULT (0) FOR [reptype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_ros_cust_rep] PRIMARY KEY NONCLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [repid], " arg_tb[cur_i].createsql_string += " [cusid], " arg_tb[cur_i].createsql_string += " [repname], " arg_tb[cur_i].createsql_string += " [loginname], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust_rep" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[sys_func_pwr_eb] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_parentid] DEFAULT (0) FOR [parentid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_mainid] DEFAULT (0) FOR [mainid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_functype] DEFAULT (0) FOR [functype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_treename] DEFAULT ('') FOR [treename], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_menuname] DEFAULT ('') FOR [menuname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_if_use] DEFAULT (0) FOR [if_use], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_sortflag] DEFAULT (0) FOR [sortflag], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_sys_func_pwr_eb_ebtype] DEFAULT (0) FOR [ebtype] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "sys_func_pwr_eb" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_mtrl_match] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode_spt] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode_self] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname_self] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlmode_self] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_match" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrl_match] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_mtrl_match] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [mtrlcode_spt] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_match" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrl_match] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrl_match_mtrlcode_spt] DEFAULT ('') FOR [mtrlcode_spt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrl_match_mtrlcode_self] DEFAULT ('') FOR [mtrlcode_self], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrl_match_mtrlname_self] DEFAULT ('') FOR [mtrlname_self], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrl_match_mtrlmode_self] DEFAULT ('') FOR [mtrlmode_self] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrl_match" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table u_email_sendmx add addtype varchar(255) not null CONSTRAINT DF_u_email_sendmx_addtype default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_mtrldef_code add pfstr varchar(1000) not null CONSTRAINT DF_LJFIEB_mtrldef_code_pfstr default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrldef_code" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table u_ljmail_msg add ifread tinyint not null CONSTRAINT DF_u_ljmail_msg_ifread default(0) " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_ljmail_msg" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_tempoutware_itemmx] ( " arg_tb[cur_i].createsql_string += " [scid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [itemid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [amt] [decimal](18, 5) NOT NULL , " arg_tb[cur_i].createsql_string += " [mxdscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [itemcode] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [itemname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [itemtype] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware_itemmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempoutware_itemmx] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_tempoutware_itemmx] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [scid], " arg_tb[cur_i].createsql_string += " [outwareid], " arg_tb[cur_i].createsql_string += " [printid], " arg_tb[cur_i].createsql_string += " [serialnum] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware_itemmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_tempoutware_itemmx] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_scid] DEFAULT (0) FOR [scid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_outwareid] DEFAULT (0) FOR [outwareid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_itemid] DEFAULT (0) FOR [itemid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_amt] DEFAULT (0) FOR [amt], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_mxdscrp] DEFAULT ('') FOR [mxdscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_itemcode] DEFAULT ('') FOR [itemcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_itemname] DEFAULT ('') FOR [itemname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_itemtype] DEFAULT ('') FOR [itemtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_tempoutware_itemmx_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware_itemmx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempoutware add carcode varchar(100) not null CONSTRAINT DF_LJFIEB_tempoutware_carcode default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempoutware" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_mtrlid_cusid] ( " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [cusid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrlid_cusid" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrlid_cusid] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_mtrlid_cusid] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [mtrlid], " arg_tb[cur_i].createsql_string += " [cusid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrlid_cusid" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_mtrlid_cusid] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlid_cusid_mtrlid] DEFAULT (0) FOR [mtrlid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlid_cusid_cusid] DEFAULT (0) FOR [cusid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_mtrlid_cusid_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_mtrlid_cusid" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[ros_cust_rep_CM] ( " arg_tb[cur_i].createsql_string += " [repid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [ljemail] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [username] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [cmtype] [tinyint] NOT NULL , " arg_tb[cur_i].createsql_string += " [dscrp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [serialnum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [sys_changetime] [datetime] NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust_rep_CM" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[ros_cust_rep_CM] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_ros_cust_rep_CM] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [repid], " arg_tb[cur_i].createsql_string += " [ljemail], " arg_tb[cur_i].createsql_string += " [serialnum], " arg_tb[cur_i].createsql_string += " [sys_changetime] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust_rep_CM" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[ros_cust_rep_CM] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_CM_repid] DEFAULT (0) FOR [repid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_CM_ljemail] DEFAULT ('') FOR [ljemail], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_CM_username] DEFAULT ('') FOR [username], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_CM_cmtype] DEFAULT (0) FOR [cmtype], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_CM_dscrp] DEFAULT ('') FOR [dscrp], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_ros_cust_rep_CM_sys_changetime] DEFAULT (getdate()) FOR [sys_changetime] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust_rep_CM" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_packet add cusid int not null CONSTRAINT DF_LJFIEB_packet_cusid default(0) " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_packet" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add dscrp2 varchar(250) not null CONSTRAINT DF_LJFIEB_tempbuyTask_dscrp2 default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add station_name char(30) not null CONSTRAINT DF_LJFIEB_tempbuyTask_station_name default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add station_tel char(50) not null CONSTRAINT DF_LJFIEB_tempbuyTask_station_tel default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add shouhuoren char(30) not null CONSTRAINT DF_LJFIEB_tempbuyTask_shouhuoren default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add shouhuoren_tel char(50) not null CONSTRAINT DF_LJFIEB_tempbuyTask_shouhuoren_tel default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add shouhuoren_address varchar(250) not null CONSTRAINT DF_LJFIEB_tempbuyTask_shouhuoren_address default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add childCusID int not null CONSTRAINT DF_LJFIEB_tempbuyTask_childCusID default(0) " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_color add gradestr varchar(255) not null CONSTRAINT DF_LJFIEB_color_gradestr default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_color_pcode add gradestr varchar(255) not null CONSTRAINT DF_u_LJFIEB_color_pcode_gradestr default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_pcode" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_color_wood add gradestr varchar(255) not null CONSTRAINT DF_LJFIEB_color_wood_gradestr default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_color_wood" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_configure_codemx add gradestr varchar(255) not null CONSTRAINT DF_LJFIEB_configure_codemx_gradestr default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_configure_codemx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTaskMx add spt_status varchar(255) not null CONSTRAINT DF_LJFIEB_tempbuyTaskMx_spt_status default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTaskMx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTaskMx add spt_woodcode varchar(255) not null CONSTRAINT DF_LJFIEB_tempbuyTaskMx_spt_woodcode default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTaskMx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTaskMx add spt_pcode varchar(255) not null CONSTRAINT DF_LJFIEB_tempbuyTaskMx_spt_pcode default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTaskMx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTaskMx add spt_dscrp varchar(255) not null CONSTRAINT DF_LJFIEB_tempbuyTaskMx_spt_dscrp default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTaskMx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add spt_dscrp varchar(255) not null CONSTRAINT DF_LJFIEB_tempbuyTask_spt_dscrp default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table LJFIEB_tempbuyTask add spt_dscrp2 varchar(255) not null CONSTRAINT DF_LJFIEB_tempbuyTask_spt_dscrp2 default('') " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_tempbuyTask" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " alter table ros_cust add ifsecaudit tinyint not null CONSTRAINT DF_ros_cust_ifsecaudit default(0) " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "ros_cust" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE LJFIEB_pztype_mx ADD gradestr varchar(255) NOT NULL CONSTRAINT DF_LJFIEB_pztype_mx_gradestr DEFAULT '' " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_pztype_mx" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_buytask_jd] ( " arg_tb[cur_i].createsql_string += " [SerialNum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [taskcode] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [orderqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [perfinishdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [acmpqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [saleoutqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareqty] [decimal](23, 10) NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_buytask_jd] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_buytask_jd] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [SerialNum], " arg_tb[cur_i].createsql_string += " [taskcode], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_buytask_jd] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_taskcode] DEFAULT ('') FOR [taskcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_mtrlcode] DEFAULT ('') FOR [mtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_mtrlname] DEFAULT ('') FOR [mtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_orderqty] DEFAULT (0) FOR [orderqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_acmpqty] DEFAULT (0) FOR [acmpqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_saleoutqty] DEFAULT (0) FOR [saleoutqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_outwareqty] DEFAULT (0) FOR [outwareqty] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " drop table [dbo].[LJFIEB_buytask_jd] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " CREATE TABLE [dbo].[LJFIEB_buytask_jd] ( " arg_tb[cur_i].createsql_string += " [SerialNum] [uniqueidentifier] NOT NULL , " arg_tb[cur_i].createsql_string += " [taskcode] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [printid] [int] NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [mtrlname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , " arg_tb[cur_i].createsql_string += " [orderqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [perfinishdate] [datetime] NULL , " arg_tb[cur_i].createsql_string += " [acmpqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [saleoutqty] [decimal](23, 10) NOT NULL , " arg_tb[cur_i].createsql_string += " [outwareqty] [decimal](23, 10) NOT NULL " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_buytask_jd] WITH NOCHECK ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [PK_LJFIEB_buytask_jd] PRIMARY KEY CLUSTERED " arg_tb[cur_i].createsql_string += " ( " arg_tb[cur_i].createsql_string += " [SerialNum], " arg_tb[cur_i].createsql_string += " [taskcode], " arg_tb[cur_i].createsql_string += " [printid] " arg_tb[cur_i].createsql_string += " ) ON [PRIMARY] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_buytask_jd" cur_i++ arg_tb[cur_i].update_version = "5.0.130204" arg_tb[cur_i].createsql_string += " ALTER TABLE [dbo].[LJFIEB_buytask_jd] ADD " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_taskcode] DEFAULT ('') FOR [taskcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_printid] DEFAULT (0) FOR [printid], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_mtrlcode] DEFAULT ('') FOR [mtrlcode], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_mtrlname] DEFAULT ('') FOR [mtrlname], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_orderqty] DEFAULT (0) FOR [orderqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_acmpqty] DEFAULT (0) FOR [acmpqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_saleoutqty] DEFAULT (0) FOR [saleoutqty], " arg_tb[cur_i].createsql_string += " CONSTRAINT [DF_LJFIEB_buytask_jd_outwareqty] DEFAULT (0) FOR [outwareqty] " arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "LJFIEB_buytask_jd" cur_i++//1 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "CREATE TABLE u_email_msg(~r~n" arg_tb[cur_i].createsql_string += "ID int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "boxid int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "mailid int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "mailaddress varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "subject varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "mailsize decimal(18, 5) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "textbody text NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "htmlbody text NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "orgdata image NULL,~r~n" arg_tb[cur_i].createsql_string += "senduser varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "sendaddress varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "sendOption tinyint NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "priority tinyint NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "senddate datetime NULL,~r~n" arg_tb[cur_i].createsql_string += "opdate datetime NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "opemp char(255) NULL,~r~n" arg_tb[cur_i].createsql_string += "revdate datetime NULL,~r~n" arg_tb[cur_i].createsql_string += "tuid varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "mailtype varchar(10) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "status varchar(10) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "CONSTRAINT PK_u_email_msg PRIMARY KEY CLUSTERED~r~n" arg_tb[cur_i].createsql_string += "(~r~n" arg_tb[cur_i].createsql_string += "ID ASC~r~n" arg_tb[cur_i].createsql_string += ")~r~n" arg_tb[cur_i].createsql_string += ")~r~n" cur_i++//2 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_boxid DEFAULT (0) FOR boxid~r~n" cur_i++//3 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_mailid DEFAULT (0) FOR mailid~r~n" cur_i++//4 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_mailaddress DEFAULT ('') FOR mailaddress~r~n" cur_i++//5 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_subject DEFAULT ('') FOR subject~r~n" cur_i++//6 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_mailsize DEFAULT (0) FOR mailsize~r~n" cur_i++//7 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_textbody DEFAULT ('') FOR textbody~r~n" cur_i++//8 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_htmlbody DEFAULT ('') FOR htmlbody~r~n" cur_i++//9 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_senduser DEFAULT ('') FOR senduser~r~n" cur_i++//10 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_sendaddress DEFAULT ('') FOR sendaddress~r~n" cur_i++//11 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_sendOption DEFAULT (0) FOR sendOption~r~n" cur_i++//12 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_priority DEFAULT (0) FOR priority~r~n" cur_i++//13 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_opdate DEFAULT (getdate()) FOR opdate~r~n" cur_i++//14 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_opemp DEFAULT ('') FOR opemp~r~n" cur_i++//15 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_tuid DEFAULT ('') FOR tuid~r~n" cur_i++//16 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_mailtype DEFAULT ('收件') FOR mailtype~r~n" cur_i++//17 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_msg" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_msg ADD CONSTRAINT DF_u_email_msg_status DEFAULT ('未读') FOR status~r~n" cur_i++//18 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "CREATE TABLE u_email_sendmx(~r~n" arg_tb[cur_i].createsql_string += "sendid int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "printid int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "reltype tinyint NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "relid int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "revaddress varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "revname varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "dscrp varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "status tinyint NOT NULL~r~n" arg_tb[cur_i].createsql_string += ")~r~n" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD repname varchar(255) NOT NULL CONSTRAINT DF_u_email_sendmx_repname DEFAULT ('')~r~n" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx DROP CONSTRAINT DF_u_email_sendmx_repname~r~n" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD addtype varchar(255) NOT NULL CONSTRAINT DF_u_email_sendmx_addtype DEFAULT ('')~r~n" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx DROP CONSTRAINT DF_u_email_sendmx_addtype~r~n" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT PK_u_email_sendmx PRIMARY KEY CLUSTERED~r~n" arg_tb[cur_i].createsql_string += "(~r~n" arg_tb[cur_i].createsql_string += "sendid ASC,~r~n" arg_tb[cur_i].createsql_string += "printid ASC~r~n" arg_tb[cur_i].createsql_string += ")~r~n" cur_i++//19 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_sendid DEFAULT (0) FOR sendid~r~n" cur_i++//20 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_printid DEFAULT (0) FOR printid~r~n" cur_i++//21 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_reltype DEFAULT (0) FOR reltype~r~n" cur_i++//22 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_relid DEFAULT (0) FOR relid~r~n" cur_i++//23 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_Recipient DEFAULT ('') FOR revaddress~r~n" cur_i++//24 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_revname DEFAULT ('') FOR revname~r~n" cur_i++//25 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_descrp DEFAULT ('') FOR dscrp~r~n" cur_i++//26 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_status DEFAULT (0) FOR status~r~n" cur_i++//27 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_repname DEFAULT ('') FOR repname~r~n" cur_i++//28 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_sendmx" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_sendmx ADD CONSTRAINT DF_u_email_sendmx_addtype DEFAULT ('') FOR addtype~r~n" cur_i++//29 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "CREATE TABLE u_email_fj(~r~n" arg_tb[cur_i].createsql_string += "fjid int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "fjtype tinyint NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "Relid int NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "filename varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "fileblob image NULL,~r~n" arg_tb[cur_i].createsql_string += "filesize decimal(18, 5) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "filetype varchar(255) NOT NULL,~r~n" arg_tb[cur_i].createsql_string += "CONSTRAINT PK_u_email_fj PRIMARY KEY CLUSTERED~r~n" arg_tb[cur_i].createsql_string += "(~r~n" arg_tb[cur_i].createsql_string += "fjid ASC~r~n" arg_tb[cur_i].createsql_string += ")~r~n" arg_tb[cur_i].createsql_string += ")~r~n" cur_i++//30 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_fj ADD CONSTRAINT DF_u_email_fj_fjid DEFAULT (0) FOR fjid~r~n" cur_i++//31 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_fj ADD CONSTRAINT DF_u_email_fj_fjtype DEFAULT (0) FOR fjtype~r~n" cur_i++//32 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_fj ADD CONSTRAINT DF_u_email_fj_Relid DEFAULT (0) FOR Relid~r~n" cur_i++//33 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_fj ADD CONSTRAINT DF_u_email_fj_filename DEFAULT ('') FOR filename~r~n" cur_i++//34 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_fj ADD CONSTRAINT DF_u_email_fj_filesize DEFAULT (0) FOR filesize~r~n" cur_i++//35 //20130606 // arg_tb[cur_i].update_version = "5.0.130219" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "ALTER TABLE u_email_fj ADD CONSTRAINT DF_u_email_fj_filetype DEFAULT ('') FOR filetype~r~n" cur_i++//36 //20130812 // arg_tb[cur_i].update_version = "5.0.130220" arg_tb[cur_i].ifmx = 0 arg_tb[cur_i].tbname = "u_email_fj" arg_tb[cur_i].createsql_string = "" arg_tb[cur_i].createsql_string += "alter table u_email_fj add cid varchar(255) not null CONSTRAINT DF_u_email_fj_cid default(0)~r~n" uof_createtable_arr_20130817(cur_i, arg_tb) end subroutine public subroutine uof_createtable_arr_demo (long i, ref s_sys_create_table arg_tb[]); //demo i++//*** //20130817 //arg_tb[i].update_version = "5.0.130208" //arg_tb[i].ifmx = 0 //arg_tb[i].tbname = "u_ljmail_box" //arg_tb[i].createsql_string = "" //arg_tb[i].createsql_string += "ALTER TABLE u_ljmail_box ADD CONSTRAINT DF_u_ljmail_box_boxname DEFAULT ('') FOR boxname~r~n" // //适当长度后,往下添加修改数据库代码, 看 uof_createtable_arr_demo(i, arg_tb) //uof_createtable_arr_*****(i, arg_tb) // return end subroutine public subroutine uof_createtable_arr_20130817 (long i, ref s_sys_create_table arg_tb[]); i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " CREATE TABLE LJFIEB_ComInfo( " arg_tb[i].createsql_string += " CusID uniqueidentifier NOT NULL, " arg_tb[i].createsql_string += " username nvarchar(50) NOT NULL, " arg_tb[i].createsql_string += " psw varchar(255) NOT NULL, " arg_tb[i].createsql_string += " tele varchar(30) NOT NULL, " arg_tb[i].createsql_string += " phone varchar(30) NOT NULL, " arg_tb[i].createsql_string += " address varchar(255) NOT NULL, " arg_tb[i].createsql_string += " comcode varchar(30) NOT NULL, " arg_tb[i].createsql_string += " userid int NOT NULL, " arg_tb[i].createsql_string += " usercode nvarchar(50) NOT NULL, " arg_tb[i].createsql_string += " uploading tinyint NOT NULL, " arg_tb[i].createsql_string += " auditflag tinyint NOT NULL, " arg_tb[i].createsql_string += " newpsw varchar(255) NOT NULL, " arg_tb[i].createsql_string += " ErrMsg varchar(2000) NOT NULL, " arg_tb[i].createsql_string += " CONSTRAINT PK_LJFIEB_ComInfo PRIMARY KEY CLUSTERED " arg_tb[i].createsql_string += " ( " arg_tb[i].createsql_string += " CusID ASC " arg_tb[i].createsql_string += " ) " arg_tb[i].createsql_string += " ) " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_CusID DEFAULT (newid()) FOR CusID " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_username DEFAULT ('') FOR username " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_psw DEFAULT ('') FOR psw " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_tele DEFAULT ('') FOR tele " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_phone DEFAULT ('') FOR phone " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_address DEFAULT ('') FOR address " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_comcode DEFAULT ('') FOR comcode " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_userid DEFAULT (0) FOR userid " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_usercode DEFAULT ('') FOR usercode " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_uploading DEFAULT (0) FOR uploading " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_auditflag DEFAULT (0) FOR auditflag " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_newpsw DEFAULT ('') FOR newpsw " i++ arg_tb[i].update_version = "5.0.130501" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_ComInfo" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " ALTER TABLE LJFIEB_ComInfo ADD CONSTRAINT DF_LJFIEB_ComInfo_ErrMsg DEFAULT ('') FOR ErrMsg " i++ arg_tb[i].update_version = "5.0.130805" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "u_email_msg" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " alter table u_email_msg add NTFlag tinyint CONSTRAINT DF_u_email_msg_NTFlag default(0) " i++ arg_tb[i].update_version = "5.0.130805" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "u_email_msg" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " alter table u_email_msg add NTName varchar(255) CONSTRAINT DF_u_email_msg_NTName default('') " i++ arg_tb[i].update_version = "5.0.130805" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "u_email_msg" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " alter table u_email_msg add NTMail varchar(255) CONSTRAINT DF_u_email_msg_NTMail default('') " i++ // 20131008 arg_tb[i].update_version = "5.0.130824" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_tempbuyTaskMx" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " alter table LJFIEB_tempbuyTaskMx add mtrlcode varchar(255) not null CONSTRAINT DF_LJFIEB_tempbuyTaskMx_mtrlcode default('') " i++ // 20131008 arg_tb[i].update_version = "5.0.130824" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_tempbuyTaskMx" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " alter table LJFIEB_tempbuyTaskMx add mtrlmode varchar(255) not null constraint DF_LJFIEB_tempbuyTaskMx_mtrlmode default('') " i++ // 20131008 arg_tb[i].update_version = "5.0.130824" arg_tb[i].ifmx = 0 arg_tb[i].tbname = "LJFIEB_tempbuyTaskMx" arg_tb[i].createsql_string += " " arg_tb[i].createsql_string += " alter table LJFIEB_tempbuyTaskMx add mtrlname varchar(255) not null constraint DF_LJFIEB_tempbuyTaskMx_mtrlname default('') " //适当长度后,往下添加修改数据库代码, 看 uof_createtable_arr_demo(i, arg_tb) //uof_createtable_arr_*****(i, arg_tb) // return end subroutine on uo_version_email.create call super::create TriggerEvent( this, "constructor" ) end on on uo_version_email.destroy TriggerEvent( this, "destructor" ) call super::destroy end on