inc.asp

功能介绍： 一、会员功能模块 1、站内短信发布(设计中) 2、书架收藏夹 3、发表评论(功能不完善) 4、申请作家(与添书员整合) 5、申请添书员(与作家整合) 6、申请更新员

				"[Ntype] int NOT NULL default 0," & _
				"[Isbook] int NOT NULL default 0" & _
				")"
			End If
		Case "[Siti_Setup]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [Siti_Setup] (" 
			Else
				SQL = "CREATE TABLE [Siti_Setup] ("
			End If
			SQL = SQL &_
					"[Sitename] varchar(50) NOT NULL , "& _
					"[Siteurl] varchar(100) NOT NULL , "& _
					"[SiteSystemPath] varchar(255) NOT NULL , "& _
					"[WebmasterName] varchar(50) NOT NULL , "& _
					"[WebmasterEmail] varchar(100) NOT NULL , "& _
					"[Sitelogo] varchar(255) NOT NULL , "& _
					"[WebQQ] varchar(50) NOT NULL," & _
					"[keywords] text NULL," & _
					"[Description] text NULL," & _
					"[Copyright] text NULL," & _
					"[SiteLock] int NOT NULL default 0," & _
					"[SiteLockcontent] text NULL," & _
					"[WebUser] int NOT NULL default 0," & _
					"[WebUserLOCKNum] int NOT NULL default 0," & _
					"[WebUserLOGLOCKNum] int NOT NULL default 0," & _
					"[WebUserLOCK] int NOT NULL default 0," & _
					"[WebADDArticleLOCK] int NOT NULL default 0," & _
					"[WebGXUser] int NOT NULL default 0," & _
					"[WebGXUserLOCKNum] int NOT NULL default 0," & _
					"[WebGXUserLOCK] int NOT NULL default 0," & _
					"[WebGXbookLOCK] int NOT NULL default 0," & _
					"[WebAuthor] int NOT NULL default 0," & _
					"[WebAuthorLOCKNum] int NOT NULL default 0," & _
					"[WebAuthorLOGLOCKNum] int NOT NULL default 0," & _
					"[WebAuthorLOCK] int NOT NULL default 0," & _
					"[WebADDbookLOCK] int NOT NULL default 0," & _
					"[UserpassLOGLOCKNum] int NOT NULL default 0," & _
					"[Webpinglun] int NOT NULL default 0," & _
					"[WebpinglunLOCKNum] int NOT NULL default 0," & _
					"[WebpinglunLOCK] int NOT NULL default 0," & _
					"[CommentSize] int NOT NULL default 0," & _
					"[Commenttime] int NOT NULL default 0," & _
					"[viewsizeNum] int NOT NULL default 0," & _
					"[ArticlesizeNum] int NOT NULL default 0," & _
					"[CommenttoPoint] int NOT NULL default 0," & _
					"[CommentdelPoint] int NOT NULL default 0," & _
					"[CommentPoint] int NOT NULL default 0," & _
					"[VoteCount] int NOT NULL default 0," & _
					"[AcVoteCount] int NOT NULL default 0," & _
					"[userloginPoint] int NOT NULL default 0," & _
					"[userbookjieadd] int NOT NULL default 0," & _
					"[authorbookjieadd] int NOT NULL default 0," & _
					"[authorbookadd] int NOT NULL default 0," & _
					"[VIPbooklost] int NOT NULL default 0," & _
					"[AcdCount] int NOT NULL default 0," & _
					"[userarticleCount] int NOT NULL default 0," & _
					"[PointtoAcdCount] int NOT NULL default 0," & _
					"[PointtoVoteCount] int NOT NULL default 0," & _
					"[PointtoVotessCount] int NOT NULL default 0," & _
					"[Pointtoboxnum] int NOT NULL default 0," & _
					"[Pointtomessenge] int NOT NULL default 0," & _
					"[Pointtomene] int NOT NULL default 0," & _
					"[OpenInhtml] int NOT NULL default 0," & _
					"[SaveToTXT] int NOT NULL default 0," & _
					"[makehtml] int NOT NULL default 0," & _
					"[htmlphem] int NOT NULL default 0," & _
					"[OpenInJS] int NOT NULL default 0," & _
					"[makeJS] int NOT NULL default 0," & _
					"[TXTToJs] int NOT NULL default 0," & _
					"[AuthorFaceMaxFileSize] int NOT NULL default 0," & _
					"[BookFaceMaxFileSize] int NOT NULL default 0," & _
					"[BookviewMaxFileSize] int NOT NULL default 0," & _
					"[ArticleViewMaxFileSize] int NOT NULL default 0," & _
					"[MaxFileSize] int NOT NULL default 0," & _
					"[WebAllowFile] int NOT NULL default 0," & _
					"[authorAllowFile] int NOT NULL default 0," & _
					"[GXUserAllowFile] int NOT NULL default 0," & _
					"[UserAllowFile] int NOT NULL default 0," & _
					"[UserVoteCount] int NOT NULL default 0," & _
					"[UserAcdCount] int NOT NULL default 0," & _
					"[Userboxnum] int NOT NULL default 0," & _
					"[netboxnum] int NOT NULL default 0," & _
					"[Usermessenge] int NOT NULL default 0," & _
					"[UserroomVote] int NOT NULL default 0," & _
					"[authorregwritmax] int NOT NULL default 0," & _
					"[authorregwritmix] int NOT NULL default 0," & _
					"[GXUserwritmax] int NOT NULL default 0," & _
					"[GXUserwritmix] int NOT NULL default 0," & _
					"[CnEndRadbgcolor] int NOT NULL default 0," & _
					"[CnEndRadfontface] int NOT NULL default 0," & _
					"[CnEndRadfontcolor] int NOT NULL default 0," & _
					"[CnEndRadfontsize] int NOT NULL default 0," & _
					"[CnEndRad] int NOT NULL default 0," & _
					"[AllowFileExtStr] text NULL," & _
					"[locksql] text NULL," & _
					"[lockComment] text NULL" & _
				")"
		Case "[TXTadlist]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [TXTadlist] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_TXTadlist PRIMARY KEY,"
			SQL = SQL &_
				"[TXTadtime] smalldatetime NOT NULL default getdate()," & _
				"[TXTadname] varchar (255) NULL ," & _
				"[TXTadurl] text NULL," & _
				"[TXTaddj] int NOT NULL default 0," & _
				"[TXTadLock] int NOT NULL default 0," & _
				"[TXTadred] int NOT NULL default 0," & _
				"[Exitdj] int NOT NULL default 0," & _
				"[ExitDate] int NOT NULL default 0" & _
				")"
			Else
				SQL = "CREATE TABLE [TXTadlist] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
			SQL = SQL &_
				"[TXTadtime] date NOT NULL default now()," & _
				"[TXTadname] varchar (255) NULL ," & _
				"[TXTadurl] text NULL," & _
				"[TXTaddj] int NOT NULL default 0," & _
				"[TXTadLock] int NOT NULL default 0," & _
				"[TXTadred] int NOT NULL default 0," & _
				"[Exitdj] int NOT NULL default 0," & _
				"[ExitDate] int NOT NULL default 0" & _
				")"
			End If
		Case "[User_box]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [User_box] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_User_box PRIMARY KEY,"
			SQL = SQL &_
				"[live_date] smalldatetime NOT NULL default getdate()," & _
				"[UserID] int NOT NULL default 0," & _
				"[list_bookid] int NOT NULL default 0," & _
				"[list_viewid] int NOT NULL default 0," & _
				"[Box_name] varchar (255) NULL ," & _
				"[Box_Url] text NULL," & _
				"[Box_class] int NOT NULL default 0" & _
				")"
			Else
				SQL = "CREATE TABLE [User_box] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
			SQL = SQL &_
				"[live_date] date NOT NULL default now()," & _
				"[UserID] int NOT NULL default 0," & _
				"[list_bookid] int NOT NULL default 0," & _
				"[list_viewid] int NOT NULL default 0," & _
				"[Box_name] varchar (255) NULL ," & _
				"[Box_Url] text NULL," & _
				"[Box_class] int NOT NULL default 0" & _
				")"
			End If
		Case "[Userinfo]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [Userinfo] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_Userinfo PRIMARY KEY,"
			SQL = SQL &_
				"[ADDDate] smalldatetime NOT NULL default getdate()," & _
				"[LoginTime] smalldatetime NOT NULL default getdate()," & _
				"[UserName] varchar (50) NULL ," & _
				"[Password] varchar (50) NULL ," & _
				"[Question1] varchar (255) NULL ," & _
				"[Question2] varchar (255) NULL ," & _
				"[Answer1] varchar (255) NULL ," & _
				"[Answer2] varchar (255) NULL ," & _
				"[Email] varchar (200) NULL ," & _
				"[NAME] varchar (50) NULL ," & _
				"[sex] varchar (50) NULL ," & _
				"[tel] varchar (50) NULL ," & _
				"[QQ] varchar (50) NULL ," & _
				"[MSN] varchar (200) NULL ," & _
				"[address] varchar (255) NULL ," & _
				"[zip] varchar (50) NULL ," & _
				"[Homepage] varchar (200) NULL ," & _
				"[LoginIP] varchar (200) NULL ," & _
				"[GO_GXuserAnswer] text NULL ," & _
				"[LoginTimes] int NOT NULL default 0," & _
				"[userAcdCount] int NOT NULL default 0," & _
				"[AcdCount] int NOT NULL default 0," & _
				"[VoteCount] int NOT NULL default 0," & _
				"[userVoteCount] int NOT NULL default 0," & _
				"[userCount] int NOT NULL default 0," & _
				"[userroomVote] int NOT NULL default 0," & _
				"[userroomVoteCount] int NOT NULL default 0," & _
				"[userroomCount] int NOT NULL default 0," & _
				"[UserPoint] int NOT NULL default 0," & _
				"[UserGrade] int NOT NULL default 0," & _
				"[UserLevel] int NOT NULL default 0," & _
				"[Usermene] int NOT NULL default 0," & _
				"[IsVipUser] int NOT NULL default 0," & _
				"[LockUser] int NOT NULL default 0," & _
				"[AuthorID] int NOT NULL default 0," & _
				"[GOauthor] int NOT NULL default 0," & _
				"[GOGXuserLock] int NOT NULL default 0," & _
				"[GOGXuser] int NOT NULL default 0," & _
				"[GO_GXuser] int NOT NULL default 0," & _
				"[userboxnum] int NOT NULL default 0," & _
				"[boxnum] int NOT NULL default 0," & _
				"[usermessenge] int NOT NULL default 0," & _
				"[messenge] int NOT NULL default 0," & _
				"[Lockpinglun] int NOT NULL default 0" & _
				")"
			Else
				SQL = "CREATE TABLE [Userinfo] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
			SQL = SQL &_
				"[ADDDate] date NOT NULL default now()," & _
				"[LoginTime] date NOT NULL default now()," & _
				"[UserName] varchar (50) NULL ," & _
				"[Password] varchar (50) NULL ," & _
				"[Question1] varchar (255) NULL ," & _
				"[Question2] varchar (255) NULL ," & _
				"[Answer1] varchar (255) NULL ," & _
				"[Answer2] varchar (255) NULL ," & _
				"[Email] varchar (200) NULL ," & _
				"[NAME] varchar (50) NULL ," & _
				"[sex] varchar (50) NULL ," & _
				"[tel] varchar (50) NULL ," & _
				"[QQ] varchar (50) NULL ," & _
				"[MSN] varchar (200) NULL ," & _
				"[address] varchar (255) NULL ," & _
				"[zip] varchar (50) NULL ," & _
				"[Homepage] varchar (200) NULL ," & _
				"[LoginIP] varchar (200) NULL ," & _
				"[GO_GXuserAnswer] text NULL ," & _
				"[LoginTimes] int NOT NULL default 0," & _
				"[userAcdCount] int NOT NULL default 0," & _
				"[AcdCount] int NOT NULL default 0," & _
				"[VoteCount] int NOT NULL default 0," & _
				"[userVoteCount] int NOT NULL default 0," & _
				"[userCount] int NOT NULL default 0," & _
				"[userroomVote] int NOT NULL default 0," & _
				"[userroomVoteCount] int NOT NULL default 0," & _
				"[userroomCount] int NOT NULL default 0," & _
				"[UserPoint] int NOT NULL default 0," & _
				"[UserGrade] int NOT NULL default 0," & _
				"[UserLevel] int NOT NULL default 0," & _
				"[Usermene] int NOT NULL default 0," & _
				"[IsVipUser] int NOT NULL default 0," & _
				"[LockUser] int NOT NULL default 0," & _
				"[AuthorID] int NOT NULL default 0," & _
				"[GOauthor] int NOT NULL default 0," & _
				"[GOGXuserLock] int NOT NULL default 0," & _
				"[GOGXuser] int NOT NULL default 0," & _
				"[GO_GXuser] int NOT NULL default 0," & _
				"[userboxnum] int NOT NULL default 0," & _
				"[boxnum] int NOT NULL default 0," & _
				"[usermessenge] int NOT NULL default 0," & _
				"[messenge] int NOT NULL default 0," & _
				"[Lockpinglun] int NOT NULL default 0" & _
				")"
			End If
		Case "[vote]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [vote] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_vote PRIMARY KEY,"
			Else
				SQL = "CREATE TABLE [vote] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
			End If
			SQL = SQL &_
				"[vote_name] varchar (255) NULL ," & _
				"[vote_title] int NOT NULL default 0," & _
				"[vote_class] int NOT NULL default 0," & _
				"[num] int NOT NULL default 0" & _
				")"
		Case "[vote_class]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [vote_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_vote_class PRIMARY KEY,"
			Else
				SQL = "CREATE TABLE [vote_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
			End If
			SQL = SQL &_
				"[title] varchar (255) NULL ," & _
				"[class] int NOT NULL default 0," & _
				"[choice] int NOT NULL default 0" & _
				")"
		Case "[filetest]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [filetest] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_filetest PRIMARY KEY,"
			Else
				SQL = "CREATE TABLE [filetest] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
			End If
			SQL = SQL &_
				"[fileurl_info] varchar (255) NULL ," & _
				"[fileurl_name] varchar (255) NULL ," & _
				"[fileurl_path] varchar (255) NULL ," & _
				"[fileurl_user] varchar (255) NULL ," & _
				"[fileurl_Types] varchar (50) NULL ," & _
				"[fileurl_fileID] int NULL default 0," & _
				"[fileurl_class] int NULL default 0," & _
				"[fileurl_lock] int NULL default 0," & _
				"[fileurl_nofile] int NULL default 0," & _
				"[fileurl_nolink] int NULL default 0," & _
				"[fileurl_size] int NULL default 0" & _
				")"
		Case "[link_class]"
			If IsSqlDataBase = 1 Then
				SQL = "CREATE TABLE [link_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_link_class PRIMARY KEY,"
			Else
				SQL = "CREATE TABLE [link_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
			End If
			SQL = SQL &_
				"[link_class] varchar (255) NULL ," & _
				"[link_info] text NULL ," & _
				"[linkNum] int NULL default 0" & _
				")"
	End Select
	Conn.Execute(SQL)
	If Err.Number <> 0 Then
		Call InnerHtml("UpdateInfo","新建 " & TableName & " 表错误，原因" & Err.Description & "操作,跳过.")
		Err.Clear()
	Else
		Call InnerHtml("UpdateInfo","新建 " & TableName & " 表成功。")
	End If
End Sub
%>