📄 inc_create_forum_sql7.asp

📁 一个不错的ASP论坛源码
💻 ASP
📖 第 1 页 / 共 4 页
字号:
12 3 4 下一页
<%
'########## 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  nvarchar (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 nvarchar (50) NULL , "
strSql = strSql & "C_STRFORUMTITLE nvarchar (255) NULL , "
strSql = strSql & "C_STRCOPYRIGHT nvarchar (50) NULL , "
strSql = strSql & "C_STRTITLEIMAGE nvarchar (255) NULL , "
strSql = strSql & "C_STRHOMEURL nvarchar (255) NULL , "
strSql = strSql & "C_STRFORUMURL nvarchar (255) NULL , "
strSql = strSql & "C_STRAUTHTYPE nvarchar (50) NULL , "
strSql = strSql & "C_STREMAIL smallint NULL , "
strSql = strSql & "C_STRUNIQUEEMAIL smallint NULL , "
strSql = strSql & "C_STRMAILMODE nvarchar (100) NULL , "
strSql = strSql & "C_STRMAILSERVER nvarchar (255) NULL , "
strSql = strSql & "C_STRSENDER nvarchar (255) NULL , "
strSql = strSql & "C_STRSETCOOKIETOFORUM smallint NULL , "
strSql = strSql & "C_STRDATETYPE nvarchar (50) NULL , "
strSql = strSql & "C_STRTIMETYPE nvarchar (50) NULL , "
strSql = strSql & "C_STRTIMEADJUSTLOCATION nvarchar (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 nvarchar (255) NULL , "
strSql = strSql & "C_STRDEFAULTFONTFACE nvarchar (255) NULL , "
strSql = strSql & "C_STRDEFAULTFONTSIZE nvarchar (50) NULL , "
strSql = strSql & "C_STRHEADERFONTSIZE nvarchar (50) NULL , "
strSql = strSql & "C_STRFOOTERFONTSIZE nvarchar (50) NULL , "
strSql = strSql & "C_STRPAGEBGCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRDEFAULTFONTCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRLINKCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRLINKTEXTDECORATION nvarchar (50) NULL , "
strSql = strSql & "C_STRVISITEDLINKCOLOR nvarchar (50) NULL "

my_Conn.Execute strSql
ChkDBInstall()

strSql = "ALTER TABLE " & strTablePrefix & "CONFIG WITH NOCHECK ADD "
strSql = strSql & "C_STRVISITEDTEXTDECORATION nvarchar (50) NULL , "
strSql = strSql & "C_STRACTIVELINKCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRHOVERFONTCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRHOVERTEXTDECORATION nvarchar (50) NULL , "
strSql = strSql & "C_STRHEADCELLCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRHEADFONTCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRCATEGORYCELLCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRCATEGORYFONTCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRFORUMFIRSTCELLCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRFORUMCELLCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRALTFORUMCELLCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRFORUMFONTCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRFORUMLINKCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRTABLEBORDERCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRPOPUPTABLECOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRPOPUPBORDERCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRNEWFONTCOLOR nvarchar (50) NULL , "
strSql = strSql & "C_STRTOPICWIDTHLEFT nvarchar (10) NULL , "
strSql = strSql & "C_STRTOPICNOWRAPLEFT smallint NULL , "
strSql = strSql & "C_STRTOPICWIDTHRIGHT nvarchar (10) NULL , "
strSql = strSql & "C_STRTOPICNOWRAPRIGHT smallint NULL , "
strSql = strSql & "C_STRRANKADMIN nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKMOD nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL0 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL1 nvarchar (50) NULL  "

my_Conn.Execute strSql
ChkDBInstall()

strSql = "ALTER TABLE " & strTablePrefix & "CONFIG WITH NOCHECK ADD "
strSql = strSql & "C_STRRANKLEVEL2 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL3 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL4 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKLEVEL5 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLORADMIN nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLORMOD nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR0 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR1 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR2 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR3 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR4 nvarchar (50) NULL , "
strSql = strSql & "C_STRRANKCOLOR5 nvarchar (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 nvarchar (255) NULL , "
strSql = strSql & "C_VALUE nvarchar (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 nvarchar (100) NULL , "
strSql = strSql & "F_URL nvarchar (255) NULL , "
strSql = strSql & "F_DESCRIPTION nvarchar (255) NULL , "
strSql = strSql & "F_TOPICS int NULL , "
strSql = strSql & "F_COUNT int NULL , "
strSql = strSql & "F_LAST_POST nvarchar (50) NULL , "
strSql = strSql & "F_PASSWORD_NEW nvarchar (255) NULL , "
strSql = strSql & "F_USERLIST nvarchar (255) NULL , "
strSql = strSql & "F_PRIVATEFORUMS int NULL , "
strSql = strSql & "F_TYPE smallint NULL , "
strSql = strSql & "F_IP nvarchar (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 nvarchar (75) NULL , "
strSql = strSql & "M_USERNAME nvarchar (150) NULL , "
strSql = strSql & "M_PASSWORD nvarchar (25) NULL , "
strSql = strSql & "M_EMAIL nvarchar (50) NULL , "
strSql = strSql & "M_COUNTRY nvarchar (20) NULL , "
strSql = strSql & "M_HOMEPAGE nvarchar (50) NULL , "
strSql = strSql & "M_SIG nvarchar (255) NULL , "
strSql = strSql & "M_DEFAULT_VIEW int NULL , "
strSql = strSql & "M_LEVEL smallint NULL , "
strSql = strSql & "M_AIM nvarchar (150) NULL , "
strSql = strSql & "M_YAHOO nvarchar (150) NULL , "
strSql = strSql & "M_ICQ nvarchar (150) NULL , "
strSql = strSql & "M_POSTS int NULL , "
strSql = strSql & "M_DATE nvarchar (50) NULL , "
strSql = strSql & "M_LASTHEREDATE nvarchar (50) NULL , "
strSql = strSql & "M_LASTPOSTDATE nvarchar (50) NULL , "
strSql = strSql & "M_TITLE nvarchar (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 nvarchar (50) NULL , "
strSql = strSql & "M_IP nvarchar (50) NULL , "
strSql = strSql & "M_FIRSTNAME nvarchar (100) NULL CONSTRAINT " & strTablePrefix & "SnitzC0369 DEFAULT '' ,"
strSql = strSql & "M_LASTNAME nvarchar (100) NULL CONSTRAINT " & strTablePrefix & "SnitzC0370 DEFAULT '' ,"
strSql = strSql & "M_OCCUPATION nvarchar (255) NULL CONSTRAINT " & strTablePrefix & "SnitzC0371 DEFAULT '' ,"
strSql = strSql & "M_SEX nvarchar (50) NULL CONSTRAINT " & strTablePrefix & "SnitzC0372 DEFAULT '' , "
strSql = strSql & "M_AGE nvarchar (10) NULL CONSTRAINT " & strTablePrefix & "SnitzC0373 DEFAULT '' , "
strSql = strSql & "M_HOBBIES NTEXT NULL , "
strSql = strSql & "M_LNEWS NTEXT NULL , "
strSql = strSql & "M_QUOTE NTEXT NULL , "
strSql = strSql & "M_BIO NTEXT NULL , "
12 3 4 下一页
💿 文件大小 916 K
👤 上传用户 qingriwanxia
📂 所属分类书籍源码
🏷️ 相关标签

#ASP #论坛 #源码
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -