📄 inc_create_forum_sql6.asp
字号:
<%
'########## Snitz Forums 2000 Version 3.1 SR4 ####################
'# #
'# 汉化修改: 资源搜罗站 #
'# 电子邮件: cgier@21cn.com #
'# 主页地址: http://www.sdsea.com #
'# http://www.99ss.net #
'# http://www.cdown.net #
'# http://www.wzdown.com #
'# http://www.13888.net #
'# 论坛地址:http://ubb.yesky.net #
'# 最后修改日期: 2001/03/12 中文版本：Version 3.1 SR4 #
'#################################################################
'# 原始来源 #
'# Snitz Forums 2000 Version 3.1 SR4 #
'# Copyright 2000 http://forum.snitz.com - All Rights Reserved #
'#################################################################
'#【版权声明】 #
'# #
'# 本软体为共享软体(shareware)提供个人网站免费使用，请勿非法修改,#
'# 转载，散播，或用于其他图利行为，并请勿删除版权声明。 #
'# 如果您的网站正式起用了这个脚本，请您通知我们，以便我们能够知晓#
'# 如果可能，请在您的网站做上我们的链接，希望能给予合作。谢谢！ #
'#################################################################
'# 请您尊重我们的劳动和版权，不要删除以上的版权声明部分，谢谢合作#
'# 如有任何问题请到我们的论坛告诉我们 #
'#################################################################
my_Conn.Errors.Clear
on error resume next
strSql = "CREATE TABLE " & strTablePrefix & "CATEGORY ( "
strSql = strSql & "CAT_ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "CAT_STATUS smallint NULL , "
strSql = strSql & "CAT_NAME varchar (100) NULL , )"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "CONFIG ("
strSql = strSql & "CONFIG_ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "C_STRVERSION varchar (50) NULL , "
strSql = strSql & "C_STRFORUMTITLE varchar (255) NULL , "
strSql = strSql & "C_STRCOPYRIGHT varchar (50) NULL , "
strSql = strSql & "C_STRTITLEIMAGE varchar (255) NULL , "
strSql = strSql & "C_STRHOMEURL varchar (255) NULL , "
strSql = strSql & "C_STRFORUMURL varchar (255) NULL , "
strSql = strSql & "C_STRAUTHTYPE varchar (50) NULL , "
strSql = strSql & "C_STREMAIL smallint NULL , "
strSql = strSql & "C_STRUNIQUEEMAIL smallint NULL , "
strSql = strSql & "C_STRMAILMODE varchar (100) NULL , "
strSql = strSql & "C_STRMAILSERVER varchar (255) NULL , "
strSql = strSql & "C_STRSENDER varchar (255) NULL , "
strSql = strSql & "C_STRSETCOOKIETOFORUM smallint NULL , "
strSql = strSql & "C_STRDATETYPE varchar (50) NULL , "
strSql = strSql & "C_STRTIMETYPE varchar (50) NULL , "
strSql = strSql & "C_STRTIMEADJUSTLOCATION varchar (50) NULL , "
strSql = strSql & "C_STRTIMEADJUST int NULL , "
strSql = strSql & "C_STRMOVETOPICMODE smallint NULL , "
strSql = strSql & "C_STRPRIVATEFORUMS smallint NULL , "
strSql = strSql & "C_STRSHOWMODERATORS smallint NULL , "
strSql = strSql & "C_STRSHOWRANK smallint NULL , "
strSql = strSql & "C_STRHIDEEMAIL smallint NULL , "
strSql = strSql & "C_STRIPLOGGING smallint NULL , "
strSql = strSql & "C_STRALLOWFORUMCODE smallint NULL ) "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "CONFIG WITH NOCHECK ADD "
strSql = strSql & "C_STRIMGINPOSTS smallint NULL , "
strSql = strSql & "C_STRALLOWHTML smallint NULL , "
strSql = strSql & "C_STRSECUREADMIN smallint NULL , "
strSql = strSql & "C_STRNOCOOKIES smallint NULL , "
strSql = strSql & "C_STREDITEDBYDATE smallint NULL , "
strSql = strSql & "C_STRHOTTOPIC smallint NULL , "
strSql = strSql & "C_INTHOTTOPICNUM int NULL , "
strSql = strSql & "C_STRHOMEPAGE smallint NULL , "
strSql = strSql & "C_STRAIM smallint NULL , "
strSql = strSql & "C_STRYAHOO smallint NULL , "
strSql = strSql & "C_STRICQ smallint NULL , "
strSql = strSql & "C_STRICONS smallint NULL , "
strSql = strSql & "C_STRGFXBUTTONS smallint NULL , "
strSql = strSql & "C_STRBADWORDFILTER smallint NULL , "
strSql = strSql & "C_STRBADWORDS varchar (255) NULL , "
strSql = strSql & "C_STRDEFAULTFONTFACE varchar (255) NULL , "
strSql = strSql & "C_STRDEFAULTFONTSIZE varchar (50) NULL , "
strSql = strSql & "C_STRHEADERFONTSIZE varchar (50) NULL , "
strSql = strSql & "C_STRFOOTERFONTSIZE varchar (50) NULL , "
strSql = strSql & "C_STRPAGEBGCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRDEFAULTFONTCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRLINKCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRLINKTEXTDECORATION varchar (50) NULL , "
strSql = strSql & "C_STRVISITEDLINKCOLOR varchar (50) NULL "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "CONFIG WITH NOCHECK ADD "
strSql = strSql & "C_STRVISITEDTEXTDECORATION varchar (50) NULL , "
strSql = strSql & "C_STRACTIVELINKCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRHOVERFONTCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRHOVERTEXTDECORATION varchar (50) NULL , "
strSql = strSql & "C_STRHEADCELLCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRHEADFONTCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRCATEGORYCELLCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRCATEGORYFONTCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRFORUMFIRSTCELLCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRFORUMCELLCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRALTFORUMCELLCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRFORUMFONTCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRFORUMLINKCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRTABLEBORDERCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRPOPUPTABLECOLOR varchar (50) NULL , "
strSql = strSql & "C_STRPOPUPBORDERCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRNEWFONTCOLOR varchar (50) NULL , "
strSql = strSql & "C_STRTOPICWIDTHLEFT varchar (10) NULL , "
strSql = strSql & "C_STRTOPICNOWRAPLEFT smallint NULL , "
strSql = strSql & "C_STRTOPICWIDTHRIGHT varchar (10) NULL , "
strSql = strSql & "C_STRTOPICNOWRAPRIGHT smallint NULL , "
strSql = strSql & "C_STRRANKADMIN varchar (50) NULL , "
strSql = strSql & "C_STRRANKMOD varchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL0 varchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL1 varchar (50) NULL "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "CONFIG WITH NOCHECK ADD "
strSql = strSql & "C_STRRANKLEVEL2 varchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL3 varchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL4 varchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL5 varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLORADMIN varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLORMOD varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR0 varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR1 varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR2 varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR3 varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR4 varchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR5 varchar (50) NULL , "
strSql = strSql & "C_INTRANKLEVEL0 smallint NULL , "
strSql = strSql & "C_INTRANKLEVEL1 smallint NULL , "
strSql = strSql & "C_INTRANKLEVEL2 smallint NULL , "
strSql = strSql & "C_INTRANKLEVEL3 smallint NULL , "
strSql = strSql & "C_INTRANKLEVEL4 smallint NULL , "
strSql = strSql & "C_INTRANKLEVEL5 smallint NULL , "
strSql = strSql & "C_STRSIGNATURES smallint NULL, "
strSql = strSql & "C_STRSHOWSTATISTICS smallint NULL, "
strSql = strSql & "C_STRSHOWIMAGEPOWEREDBY smallint NULL, "
strSql = strSql & "C_STRLOGONFORMAIL smallint NULL, "
strSql = strSql & "C_STRSHOWPAGING smallint NULL, "
strSql = strSql & "C_STRSHOWTOPICNAV smallint NULL, "
strSql = strSql & "C_STRPAGESIZE smallint NULL, "
strSql = strSql & "C_STRPAGENUMBERSIZE smallint NULL "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "ALTER TABLE " & strTablePrefix & "CONFIG WITH NOCHECK ADD "
strSql = strSql & "C_STRFULLNAME smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1000 DEFAULT 0, "
strSql = strSql & "C_STRPICTURE smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1001 DEFAULT 0, "
strSql = strSql & "C_STRSEX smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1002 DEFAULT 0, "
strSql = strSql & "C_STRCITY smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1003 DEFAULT 0, "
strSql = strSql & "C_STRSTATE smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1004 DEFAULT 0, "
strSql = strSql & "C_STRAGE smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1005 DEFAULT 0, "
strSql = strSql & "C_STRCOUNTRY smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1006 DEFAULT 0, "
strSql = strSql & "C_STROCCUPATION smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1007 DEFAULT 0, "
strSql = strSql & "C_STRBIO smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1008 DEFAULT 0, "
strSql = strSql & "C_STRHOBBIES smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1009 DEFAULT 0, "
strSql = strSql & "C_STRLNEWS smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1010 DEFAULT 0, "
strSql = strSql & "C_STRQUOTE smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1011 DEFAULT 0, "
strSql = strSql & "C_STRMARSTATUS smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1012 DEFAULT 0, "
strSql = strSql & "C_STRFAVLINKS smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1013 DEFAULT 1, "
strSql = strSql & "C_STRRECENTTOPICS smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1014 DEFAULT 0, "
strSql = strSql & "C_STRAUTOLOGON smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1015 DEFAULT 0, "
strSql = strSql & "C_STRNTGROUPS smallint NULL CONSTRAINT " & strTablePrefix & "SnitzC1016 DEFAULT 0"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "CONFIG_NEW ( "
strSql = strSql & "ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "C_VARIABLE varchar (255) NULL , "
strSql = strSql & "C_VALUE varchar (255) NULL )"
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strTablePrefix & "FORUM ( "
strSql = strSql & "CAT_ID int NOT NULL , "
strSql = strSql & "FORUM_ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "F_STATUS smallint NULL , "
strSql = strSql & "F_MAIL smallint NULL , "
strSql = strSql & "F_SUBJECT varchar (100) NULL , "
strSql = strSql & "F_URL varchar (255) NULL , "
strSql = strSql & "F_DESCRIPTION varchar (255) NULL , "
strSql = strSql & "F_TOPICS int NULL , "
strSql = strSql & "F_COUNT int NULL , "
strSql = strSql & "F_LAST_POST varchar (50) NULL , "
strSql = strSql & "F_PASSWORD_NEW varchar (255) NULL , "
strSql = strSql & "F_USERLIST varchar (255) NULL , "
strSql = strSql & "F_PRIVATEFORUMS int NULL , "
strSql = strSql & "F_TYPE smallint NULL , "
strSql = strSql & "F_IP varchar (50) NULL, "
strSql = strSql & "F_LAST_POST_AUTHOR int NULL ) "
my_Conn.Execute strSql
ChkDBInstall()
strSql = "CREATE TABLE " & strMemberTablePrefix & "MEMBERS ( "
strSql = strSql & "MEMBER_ID int IDENTITY (1, 1) NOT NULL , "
strSql = strSql & "M_STATUS smallint NULL , "
strSql = strSql & "M_NAME varchar (75) NULL , "
strSql = strSql & "M_USERNAME varchar (150) NULL , "
strSql = strSql & "M_PASSWORD varchar (25) NULL , "
strSql = strSql & "M_EMAIL varchar (50) NULL , "
strSql = strSql & "M_COUNTRY varchar (20) NULL , "
strSql = strSql & "M_HOMEPAGE varchar (50) NULL , "
strSql = strSql & "M_SIG varchar (255) NULL , "
strSql = strSql & "M_DEFAULT_VIEW int NULL , "
strSql = strSql & "M_LEVEL smallint NULL , "
strSql = strSql & "M_AIM varchar (150) NULL , "
strSql = strSql & "M_YAHOO varchar (150) NULL , "
strSql = strSql & "M_ICQ varchar (150) NULL , "
strSql = strSql & "M_POSTS int NULL , "
strSql = strSql & "M_DATE varchar (50) NULL , "
strSql = strSql & "M_LASTHEREDATE varchar (50) NULL , "
strSql = strSql & "M_LASTPOSTDATE varchar (50) NULL , "
strSql = strSql & "M_TITLE varchar (50) NULL , "
strSql = strSql & "M_SUBSCRIPTION smallint NULL , "
strSql = strSql & "M_HIDE_EMAIL smallint NULL , "
strSql = strSql & "M_RECEIVE_EMAIL smallint NULL , "
strSql = strSql & "M_LAST_IP varchar (50) NULL , "
strSql = strSql & "M_IP varchar (50) NULL , "
strSql = strSql & "M_FIRSTNAME varchar (100) NULL CONSTRAINT " & strTablePrefix & "SnitzC0369 DEFAULT '' ,"
strSql = strSql & "M_LASTNAME varchar (100) NULL CONSTRAINT " & strTablePrefix & "SnitzC0370 DEFAULT '' ,"
strSql = strSql & "M_OCCUPATION varchar (255) NULL CONSTRAINT " & strTablePrefix & "SnitzC0371 DEFAULT '' ,"
strSql = strSql & "M_SEX varchar (50) NULL CONSTRAINT " & strTablePrefix & "SnitzC0372 DEFAULT '' , "
strSql = strSql & "M_AGE varchar (10) NULL CONSTRAINT " & strTablePrefix & "SnitzC0373 DEFAULT '' , "
strSql = strSql & "M_HOBBIES text NULL , "
strSql = strSql & "M_LNEWS text NULL , "
strSql = strSql & "M_QUOTE text NULL , "
strSql = strSql & "M_BIO text NULL , "
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -