install.asp

闻名一时的bbsxp超快论坛系统现在放出最新版2008版本给希望装论坛的朋友借鉴安装调试

	"RoleID int Default 0 NOT NULL ,"&_
	"PermissionView int Default 1 NOT NULL ,"&_
	"PermissionRead int Default 1 NOT NULL ,"&_
	"PermissionPost int Default 1 NOT NULL ,"&_
	"PermissionReply int Default 1 NOT NULL ,"&_
	"PermissionEdit int Default 1 NOT NULL ,"&_
	"PermissionDelete int Default 0 NOT NULL ,"&_
	"PermissionCreatePoll int Default 1 NOT NULL ,"&_
	"PermissionVote int Default 1 NOT NULL ,"&_
	"PermissionAttachment int Default 1 NOT NULL ,"&_
	"PermissionManage int Default 0 NOT NULL "&_
	")"
	InstallExecute(sql)
	
	Sql="CREATE TABLE ["&TablePrefix&"Forums] ("&_
	"ForumID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"GroupID int Default 0 NOT NULL ,"&_
	"ParentID int Default 0 NOT NULL ,"&_
	"SortOrder int Default 1 NOT NULL ,"&_
	"ForumName nvarchar(255) ,"&_
	"Moderated nvarchar(255) ,"&_
	"TotalCategorys nvarchar(255) ,"&_
	"ForumDescription nvarchar(255) ,"&_
	"TodayPosts int Default 0 ,"&_
	"TotalThreads int Default 0 ,"&_
	"TotalPosts int Default 0 ,"&_
	"ForumUrl nvarchar(255) ,"&_
	"IsActive int Default 1 ,"&_
	"MostRecentThreadID int Default 0 ,"&_
	"MostRecentPostSubject nvarchar(255) ,"&_
	"MostRecentPostAuthor nvarchar(50) ,"&_
	"MostRecentPostDate datetime Default "&SqlNowString&" ,"&_
	"ForumRules ntext ,"&_
	"ModerateNewThread int Default 0 ,"&_
	"ModerateNewPost int Default 0 ,"&_
	"DateCreated datetime Default "&SqlNowString&""&_
	")"
	InstallExecute(sql)
	
	Sql="CREATE TABLE ["&TablePrefix&"Groups] ("&_
	"GroupID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"GroupName nvarchar(255) ,"&_
	"SortOrder int Default 1 NOT NULL ,"&_
	"GroupDescription ntext ,"&_
	"ForumColumns int Default 0 NOT NULL ,"&_
	"Moderated nvarchar(255) "&_
	")"
	InstallExecute(sql)
	
	Sql="CREATE TABLE ["&TablePrefix&"Links] ("&_
	"LinkID int IDENTITY (1, 1) NOT NULL ,"&_
	"Name nvarchar(255) ,"&_
	"URL nvarchar(255) ,"&_
	"Logo nvarchar(255) ,"&_
	"Intro nvarchar(255) ,"&_
	"SortOrder int Default 1 "&_
	")"
	InstallExecute(sql)
	

	
	
	
	Sql="CREATE TABLE ["&TablePrefix&"PostAttachments] ("&_
	"UpFileID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"UserName nvarchar(50) NOT NULL ,"&_
	"FileName nvarchar(255) NOT NULL ,"&_
	"FileData image NULL ,"&_
	"ContentType nvarchar(255) NOT NULL ,"&_
	"FilePath nvarchar(255) NULL ,"&_
	"ContentSize int Default 0 NOT NULL ,"&_
	"PostID int Default 0 ,"&_
	"Description nvarchar(255) NULL ,"&_
	"Created datetime Default "&SqlNowString&" NOT NULL"&_
	")"
	InstallExecute(sql)
	
	Sql="CREATE TABLE ["&TablePrefix&"PostEditNotes] ("&_
	"EditNoteID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"PostID int Default 0 NOT NULL ,"&_
	"EditNotes nvarchar(255) NULL"&_
	")"
	InstallExecute(sql)
	
	Sql="CREATE TABLE ["&TablePrefix&"PostTags] ("&_
	"TagID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"TagName nvarchar(255) NOT NULL ,"&_
	"IsEnabled int Default 1 NOT NULL ,"&_
	"TotalPosts int Default 0 NOT NULL ,"&_
	"MostRecentPostDate datetime Default "&SqlNowString&" NOT NULL , "&_
	"DateCreated datetime Default "&SqlNowString&" NOT NULL"&_
	")"
	InstallExecute(sql)
	
	Sql="CREATE TABLE ["&TablePrefix&"PostInTags] ("&_
	"TagID int Default 0 NOT NULL ,"&_
	"PostID int Default 0 NOT NULL"&_
	")"
	InstallExecute(sql)
	
	Sql="CREATE TABLE ["&TablePrefix&"Posts] ("&_
	"PostID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"ThreadID int Default 0 ,"&_
	"ParentID int Default 0 ,"&_
	"PostAuthor nvarchar(50) ,"&_
	"Subject nvarchar(255) ,"&_
	"Body ntext ,"&_
	"IPAddress nvarchar(50) ,"&_
	"Visible int Default 1 ,"&_
	"PostDate datetime Default "&SqlNowString&" NOT NULL "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"PrivateMessages] ("&_
	"MessageID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"SenderUserName nvarchar(50) ,"&_
	"RecipientUserName nvarchar(50) ,"&_
	"Subject nvarchar(255) ,"&_
	"Body ntext ,"&_
	"IsRead int Default 0 ,"&_
	"IsRecipientDelete int Default 0 ,"&_
	"IsSenderDelete int Default 0 ,"&_
	"CreateTime datetime Default "&SqlNowString&" NOT NULL "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"Ranks] ("&_
	"RankID int IDENTITY (1, 1) NOT NULL ,"&_
	"RoleID int Default 0 ,"&_
	"RankName nvarchar(255) ,"&_
	"PostingCountMin int Default 0 "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"Reputation] ("&_
	"ReputationID int IDENTITY (1, 1) NOT NULL ,"&_
	"Reputation int Default 0 NOT NULL ,"&_
	"CommentFor nvarchar(50) NOT NULL ,"&_
	"CommentBy nvarchar(50) NOT NULL ,"&_
	"Comment ntext ,"&_
	"IPAddress nvarchar(50) ,"&_
	"DateCreated datetime Default "&SqlNowString&" NOT NULL "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"Roles] ("&_
	"RoleID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"Name nvarchar(255) NOT NULL ,"&_
	"Description nvarchar(255) ,"&_
	"RoleMaxFileSize int Default 0 ,"&_
	"RoleMaxPostAttachmentsSize int Default 0 "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"SiteSettings] ("&_
	"SiteSettingsXML ntext ,"&_
	"CreateUserAgreement ntext ,"&_
	"GenericHeader ntext ,"&_
	"GenericTop ntext ,"&_
	"GenericBottom ntext ,"&_
	"BestOnline int Default 0 ,"&_
	"BestOnlineTime datetime Default "&SqlNowString&" NOT NULL ,"&_
	"AdminNotes ntext ,"&_
	"BBSxpVersion nvarchar(50) "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"Statistics] ("&_
	"DaysUsers int Default 0 ,"&_
	"DaysPosts int Default 0 ,"&_
	"DaysTopics int Default 0 ,"&_
	"TotalUsers int Default 0 ,"&_
	"TotalPosts int Default 0 ,"&_
	"TotalTopics int Default 0 ,"&_
	"NewestUserName nvarchar(50) ,"&_
	"DateCreated datetime Default "&SqlNowString&" NOT NULL "&_	
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"Subscriptions] ("&_
	"SubscriptionID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"ThreadID int Default 0 ,"&_
	"UserName nvarchar(50) NOT NULL ,"&_
	"Email nvarchar(255) NOT NULL ,"&_
	"SubscriptionDate datetime Default "&SqlNowString&" NOT NULL "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"ThreadRating] ("&_
	"UserName nvarchar(50) NOT NULL ,"&_
	"ThreadID int Default 0 ,"&_
	"Rating int Default 0 ,"&_
	"DateCreated datetime Default "&SqlNowString&" NOT NULL "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"Threads] ("&_
	"ThreadID int IDENTITY (1, 1) PRIMARY KEY NOT NULL ,"&_
	"ForumID int Default 0 ,"&_
	"ThreadEmoticonID int Default 0 ,"&_
	"ThreadStyle nvarchar(255) ,"&_
	"Topic nvarchar(255) ,"&_
	"Category nvarchar(255) ,"&_
	"Description nvarchar(255) ,"&_
	"PostAuthor nvarchar(50) ,"&_
	"LastName nvarchar(50) ,"&_
	"PostTime datetime Default "&SqlNowString&" NOT NULL ,"&_
	"LastTime datetime Default "&SqlNowString&" NOT NULL ,"&_
	"LastViewedDate datetime Default "&SqlNowString&" NOT NULL ,"&_
	"IsGood int Default 0 ,"&_
	"ThreadTop int Default 0 ,"&_
	"StickyDate datetime Default "&SqlNowString&" NOT NULL ,"&_
	"IsLocked int Default 0 ,"&_
	"Visible int Default 1 ,"&_
	"HiddenCount int Default 0 ,"&_
	"DeletedCount int Default 0 ,"&_
	"IsVote int Default 0 ,"&_
	"TotalViews int Default 0 ,"&_
	"TotalReplies int Default 0 ,"&_
	"RatingSum int Default 0 ,"&_
	"TotalRatings int Default 0 ,"&_
	"ThreadStatus int Default 0 "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"UserActivation] ("&_
	"ActivationKey nvarchar(50) NOT NULL ,"&_
	"UserName nvarchar(50) ,"&_
	"Email nvarchar(255) ,"&_
	"DateCreated datetime Default "&SqlNowString&" NOT NULL "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"UserOnline] ("&_
	"ForumID int Default 0 ,"&_
	"SessionID nvarchar(255) ,"&_
	"UserName nvarchar(50) ,"&_
	"IPAddress nvarchar(50) ,"&_
	"IsInvisible int Default 0 ,"&_
	"ForumName nvarchar(255) ,"&_
	"ThreadID int Default 0 ,"&_
	"Topic nvarchar(255) ,"&_
	"ComeTime datetime Default "&SqlNowString&" NOT NULL ,"&_
	"LastTime datetime Default "&SqlNowString&" NOT NULL "&_
	")"
	InstallExecute(sql)

	Sql="CREATE TABLE ["&TablePrefix&"Users] ("&_
	"UserID int IDENTITY (1, 1) NOT NULL ,"&_
	"UserName nvarchar(50) PRIMARY KEY NOT NULL ,"&_
	"UserPassword nvarchar(50) NOT NULL ,"&_
	"UserSex int Default 0 ,"&_
	"UserRoleID int Default 3 NOT NULL ,"&_
	"UserAccountStatus int Default 1 ,"&_
	"ModerationLevel int Default 0 ,"&_
	"UserEmail nvarchar(255) NOT NULL ,"&_
	"PasswordQuestion nvarchar(255) ,"&_
	"PasswordAnswer nvarchar(255) ,"&_
	"WebAddress nvarchar(255) ,"&_
	"WebLog nvarchar(255) ,"&_
	"WebGallery nvarchar(255) ,"&_
	"UserRank nvarchar(255) ,"&_
	"Birthday datetime ,"&_
	"NewMessage int Default 0 ,"&_
	"TotalPosts int Default 0 ,"&_
	"UserMoney int Default 0 ,"&_
	"Experience int Default 0 ,"&_
	"UserFaceUrl nvarchar(255) ,"&_
	"UserRegisterIP nvarchar(50) ,"&_
	"UserActivityIP nvarchar(50) ,"&_
	"UserRegisterTime datetime Default "&SqlNowString&" NOT NULL ,"&_
	"UserPostTime datetime Default "&SqlNowString&" NOT NULL ,"&_
	"UserActivityTime datetime Default "&SqlNowString&" NOT NULL ,"&_
	"ReferrerName nvarchar(50) ,"&_
	"RealName nvarchar(50) ,"&_
	"Occupation nvarchar(255) ,"&_
	"Address nvarchar(255) ,"&_
	"QQ nvarchar(255) ,"&_
	"ICQ nvarchar(255) ,"&_
	"AIM nvarchar(255) ,"&_
	"MSN nvarchar(255) ,"&_
	"Yahoo nvarchar(255) ,"&_
	"Skype nvarchar(255) ,"&_
	"Interests nvarchar(255) ,"&_
	"UserMate nvarchar(50) ,"&_
	"UserTitle nvarchar(255) ,"&_
	"Reputation int Default 0 ,"&_
	"UserActivityDay int Default 0 ,"&_
	"BankMoney int Default 0 ,"&_