📄 inc_create_forum_sql7.asp
字号:
strSql = strSql & "M_MARSTATUS nvarchar (100) NULL CONSTRAINT " & strTablePrefix & "SnitzC0374 DEFAULT '' ,"
strSql = strSql & "M_LINK1 nvarchar (255) NULL CONSTRAINT " & strTablePrefix & "SnitzC0375 DEFAULT '' ,"
strSql = strSql & "M_LINK2 nvarchar (255) NULL CONSTRAINT " & strTablePrefix & "SnitzC0376 DEFAULT '' , "
strSql = strSql & "M_CITY nvarchar (100) NULL CONSTRAINT " & strTablePrefix & "SnitzC0377 DEFAULT '' , "
strSql = strSql & "M_STATE nvarchar (100) NULL CONSTRAINT " & strTablePrefix & "SnitzC0379 DEFAULT '' , "
strSql = strSql & "M_PHOTO_URL nvarchar (255) NULL CONSTRAINT " & strTablePrefix & "SnitzC0378 DEFAULT '' )"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "MODERATOR ( "
strSql = strSql & "MOD_ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "FORUM_ID int NULL , "
strSql = strSql & "MEMBER_ID int NULL , "
strSql = strSql & "MOD_TYPE smallint NULL )"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "REPLY ( "
strSql = strSql & "CAT_ID int NOT NULL , "
strSql = strSql & "FORUM_ID int NOT NULL , "
strSql = strSql & "TOPIC_ID int NOT NULL , "
strSql = strSql & "REPLY_ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "R_MAIL smallint NULL , "
strSql = strSql & "R_AUTHOR int NULL , "
strSql = strSql & "R_MESSAGE text NULL , "
strSql = strSql & "R_DATE nvarchar (50) NULL , "
strSql = strSql & "R_IP nvarchar (50) NULL ) "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "TOPICS ( "
strSql = strSql & "CAT_ID int NOT NULL , "
strSql = strSql & "FORUM_ID int NOT NULL , "
strSql = strSql & "TOPIC_ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "T_STATUS smallint NULL , "
strSql = strSql & "T_MAIL smallint NULL , "
strSql = strSql & "T_SUBJECT nvarchar (100) NULL , "
strSql = strSql & "T_MESSAGE text NULL , "
strSql = strSql & "T_AUTHOR int NULL , "
strSql = strSql & "T_REPLIES int NULL , "
strSql = strSql & "T_VIEW_COUNT int NULL , "
strSql = strSql & "T_LAST_POST nvarchar (50) NULL , "
strSql = strSql & "T_DATE nvarchar (50) NULL, "
strSql = strSql & "T_LAST_POSTER int NULL, "
strSql = strSql & "T_IP nvarchar (50) NULL, "
strSql = strSql & "T_LAST_POST_AUTHOR int NULL ) "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "TOTALS ( "
strSql = strSql & "COUNT_ID smallint NOT NULL , "
strSql = strSql & "P_COUNT int NULL , "
strSql = strSql & "T_COUNT int NULL , "
strSql = strSql & "U_COUNT int NULL ) "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "ALLOWED_MEMBERS ("
strSql = strSql & "MEMBER_ID INT NOT NULL, FORUM_ID INT NOT NULL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC373 PRIMARY KEY NONCLUSTERED (MEMBER_ID, FORUM_ID) ) "
my_Conn.Execute strSql
ChkDBInstall()
if (strDBType = "sqlserver") then
strSql = "ALTER TABLE " & strTablePrefix & "CATEGORY WITH NOCHECK ADD "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC1 DEFAULT 1 FOR CAT_STATUS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC2 PRIMARY KEY NONCLUSTERED "
strSql = strSql & " (CAT_ID)"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "CONFIG WITH NOCHECK ADD "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC021 DEFAULT '" & strNewVersion & "' FOR C_STRVERSION, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC3 DEFAULT 'Snitz Forums 2000' FOR C_STRFORUMTITLE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC031 DEFAULT '© 2000 Snitz Communications' FOR C_STRCOPYRIGHT, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC032 DEFAULT 'logo_snitz_forums_2000.gif' FOR C_STRTITLEIMAGE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC033 DEFAULT '../' FOR C_STRHOMEURL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC034 DEFAULT 'http://snitz.forum.com/forum/' FOR C_STRFORUMURL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC035 DEFAULT 'db' FOR C_STRAUTHTYPE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC036 DEFAULT 1 FOR C_STRSETCOOKIETOFORUM, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC4 DEFAULT 0 FOR C_STREMAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC5 DEFAULT 1 FOR C_STRUNIQUEEMAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC051 DEFAULT 'cdonts' FOR C_STRMAILMODE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC052 DEFAULT 'your.mailserver.com' FOR C_STRMAILSERVER, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC053 DEFAULT 'your.email@yourserver.com' FOR C_STRSENDER, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC054 DEFAULT 'mdy' FOR C_STRDATETYPE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC056 DEFAULT '24' FOR C_STRTIMETYPE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC057 DEFAULT '0' FOR C_STRTIMEADJUSTLOCATION, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC6 DEFAULT 0 FOR C_STRTIMEADJUST, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC7 DEFAULT 1 FOR C_STRMOVETOPICMODE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC8 DEFAULT 0 FOR C_STRPRIVATEFORUMS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC9 DEFAULT 1 FOR C_STRSHOWMODERATORS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC10 DEFAULT 0 FOR C_STRSHOWRANK, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC11 DEFAULT 0 FOR C_STRHIDEEMAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC12 DEFAULT 1 FOR C_STRIPLOGGING, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC13 DEFAULT 1 FOR C_STRALLOWFORUMCODE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC14 DEFAULT 0 FOR C_STRIMGINPOSTS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC15 DEFAULT 0 FOR C_STRALLOWHTML, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC16 DEFAULT 1 FOR C_STRSECUREADMIN, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC17 DEFAULT 0 FOR C_STRNOCOOKIES, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC18 DEFAULT 1 FOR C_STREDITEDBYDATE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC19 DEFAULT 1 FOR C_STRHOTTOPIC, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC20 DEFAULT 20 FOR C_INTHOTTOPICNUM, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC21 DEFAULT 1 FOR C_STRHOMEPAGE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC22 DEFAULT 1 FOR C_STRAIM, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC23 DEFAULT 1 FOR C_STRYAHOO, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC24 DEFAULT 1 FOR C_STRICQ, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC25 DEFAULT 1 FOR C_STRICONS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC26 DEFAULT 1 FOR C_STRGFXBUTTONS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC27 DEFAULT 1 FOR C_STRBADWORDFILTER, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0271 DEFAULT 'fuck|wank|shit|pussy|cunt' FOR C_STRBADWORDS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0272 DEFAULT '宋体, Arial, Helvetica' FOR C_STRDEFAULTFONTFACE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0273 DEFAULT '2' FOR C_STRDEFAULTFONTSIZE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0274 DEFAULT '4' FOR C_STRHEADERFONTSIZE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0275 DEFAULT '1' FOR C_STRFOOTERFONTSIZE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0276 DEFAULT 'white' FOR C_STRPAGEBGCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0277 DEFAULT 'midnightblue' FOR C_STRDEFAULTFONTCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0278 DEFAULT 'darkblue' FOR C_STRLINKCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0279 DEFAULT 'underline' FOR C_STRLINKTEXTDECORATION, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02710 DEFAULT 'blue' FOR C_STRVISITEDLINKCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02711 DEFAULT 'underline' FOR C_STRVISITEDTEXTDECORATION, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02712 DEFAULT 'red' FOR C_STRACTIVELINKCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02713 DEFAULT 'red' FOR C_STRHOVERFONTCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02714 DEFAULT 'underline' FOR C_STRHOVERTEXTDECORATION, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02715 DEFAULT 'midnightblue' FOR C_STRHEADCELLCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02716 DEFAULT 'mintcream' FOR C_STRHEADFONTCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02717 DEFAULT 'slateblue' FOR C_STRCATEGORYCELLCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02718 DEFAULT 'mintcream' FOR C_STRCATEGORYFONTCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02719 DEFAULT 'whitesmoke' FOR C_STRFORUMFIRSTCELLCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02720 DEFAULT 'whitesmoke' FOR C_STRFORUMCELLCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02721 DEFAULT 'gainsboro' FOR C_STRALTFORUMCELLCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02722 DEFAULT 'midnightblue' FOR C_STRFORUMFONTCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02723 DEFAULT 'darkblue' FOR C_STRFORUMLINKCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02724 DEFAULT 'black' FOR C_STRTABLEBORDERCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02725 DEFAULT 'navyblue' FOR C_STRPOPUPTABLECOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02726 DEFAULT 'black' FOR C_STRPOPUPBORDERCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02727 DEFAULT 'blue' FOR C_STRNEWFONTCOLOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02728 DEFAULT '100' FOR C_STRTOPICWIDTHLEFT, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC02729 DEFAULT '100%' FOR C_STRTOPICWIDTHRIGHT, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC28 DEFAULT 1 FOR C_STRTOPICNOWRAPLEFT, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC29 DEFAULT 0 FOR C_STRTOPICNOWRAPRIGHT, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC30 DEFAULT 'Administrator' FOR C_STRRANKADMIN, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0301 DEFAULT 'Moderator' FOR C_STRRANKMOD, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0302 DEFAULT 'Starting Member' FOR C_STRRANKLEVEL0, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0303 DEFAULT 'New Member' FOR C_STRRANKLEVEL1, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0304 DEFAULT 'Junior Member' FOR C_STRRANKLEVEL2, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0305 DEFAULT 'Average Member' FOR C_STRRANKLEVEL3, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0306 DEFAULT 'Senior Member' FOR C_STRRANKLEVEL4, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0307 DEFAULT 'Advanced Member' FOR C_STRRANKLEVEL5, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0308 DEFAULT 'gold' FOR C_STRRANKCOLORADMIN, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0309 DEFAULT 'silver' FOR C_STRRANKCOLORMOD, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC03010 DEFAULT 'bronze' FOR C_STRRANKCOLOR0, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC03011 DEFAULT 'bronze' FOR C_STRRANKCOLOR1, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC03012 DEFAULT 'bronze' FOR C_STRRANKCOLOR2, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC03013 DEFAULT 'bronze' FOR C_STRRANKCOLOR3, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC03014 DEFAULT 'bronze' FOR C_STRRANKCOLOR4, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC03015 DEFAULT 'bronze' FOR C_STRRANKCOLOR5, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC03016 DEFAULT 0 FOR C_INTRANKLEVEL0, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC31 DEFAULT 50 FOR C_INTRANKLEVEL1, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC32 DEFAULT 100 FOR C_INTRANKLEVEL2, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC33 DEFAULT 500 FOR C_INTRANKLEVEL3, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC34 DEFAULT 1000 FOR C_INTRANKLEVEL4, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC35 DEFAULT 2000 FOR C_INTRANKLEVEL5, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0361 DEFAULT 1 FOR C_STRSIGNATURES, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0362 DEFAULT 1 FOR C_STRSHOWSTATISTICS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0363 DEFAULT 1 FOR C_STRSHOWIMAGEPOWEREDBY, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0364 DEFAULT 1 FOR C_STRLOGONFORMAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0365 DEFAULT 1 FOR C_STRSHOWPAGING, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0366 DEFAULT 1 FOR C_STRSHOWTOPICNAV, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0367 DEFAULT 15 FOR C_STRPAGESIZE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC0368 DEFAULT 10 FOR C_STRPAGENUMBERSIZE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC37 PRIMARY KEY NONCLUSTERED "
strSql = strSql & "(CONFIG_ID)"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "CONFIG_NEW WITH NOCHECK ADD "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC38 PRIMARY KEY NONCLUSTERED "
strSql = strSql & " (ID)"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "FORUM WITH NOCHECK ADD "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC39 DEFAULT 0 FOR CAT_ID, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC40 DEFAULT 1 FOR F_STATUS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC41 DEFAULT 0 FOR F_MAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC42 DEFAULT 0 FOR F_TOPICS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC43 DEFAULT 0 FOR F_COUNT, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC44 DEFAULT '' FOR F_LAST_POST, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC45 DEFAULT 0 FOR F_PRIVATEFORUMS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC46 DEFAULT 0 FOR F_TYPE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC47 DEFAULT '000.000.000.000' FOR F_IP, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC48 PRIMARY KEY NONCLUSTERED "
strSql = strSql & "(CAT_ID, FORUM_ID )"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strMemberTablePrefix & "MEMBERS WITH NOCHECK ADD "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC49 DEFAULT 1 FOR M_STATUS, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC50 DEFAULT 1 FOR M_DEFAULT_VIEW, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC51 DEFAULT 1 FOR M_LEVEL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC52 DEFAULT '' FOR M_DATE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC53 DEFAULT 0 FOR M_SUBSCRIPTION, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC54 DEFAULT 0 FOR M_HIDE_EMAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC55 DEFAULT 1 FOR M_RECEIVE_EMAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC56 DEFAULT '000.000.000.000' FOR M_LAST_IP, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC57 DEFAULT '000.000.000.000' FOR M_IP, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC58 PRIMARY KEY NONCLUSTERED "
strSql = strSql & "(MEMBER_ID)"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "MODERATOR WITH NOCHECK ADD "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC59 DEFAULT 0 FOR FORUM_ID, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC60 DEFAULT 0 FOR MEMBER_ID, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC61 DEFAULT 0 FOR MOD_TYPE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC62 PRIMARY KEY NONCLUSTERED "
strSql = strSql & " (MOD_ID)"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "REPLY WITH NOCHECK ADD "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC63 DEFAULT 0 FOR CAT_ID, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC64 DEFAULT 0 FOR FORUM_ID, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC65 DEFAULT 0 FOR TOPIC_ID, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC66 DEFAULT 0 FOR R_MAIL, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC67 DEFAULT 0 FOR R_AUTHOR, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC68 DEFAULT '' FOR R_DATE, "
strSql = strSql & "CONSTRAINT " & strTablePrefix & "SnitzC69 DEFAULT '000.000.000.000' FOR R_IP, "
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -