📄 inc.asp
字号:
"[bank10] text NULL," & _
"[bank11] text NULL," & _
"[bank12] text NULL," & _
"[bank13] text NULL," & _
"[bank14] text NULL," & _
"[bank15] text NULL" & _
")"
End If
Case "[news]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE news (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"txttime timestamp NOT NULL default Now()," & _
"username varchar (255) NULL ," & _
"txttitle varchar (255) NULL ," & _
"txtcontent text NULL ," & _
"Ar_userid int NOT NULL default 0," & _
"hits int NOT NULL default 0," & _
"Istop int NOT NULL default 0," & _
"Iscontent int NOT NULL default 0," & _
"Islink int NOT NULL default 0," & _
"Ntype int NOT NULL default 0," & _
"Isbook int NOT NULL default 0" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [news] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_news PRIMARY KEY," &_
"[txttime] smalldatetime NOT NULL default getdate()," & _
"[username] varchar (255) NULL ," & _
"[txttitle] varchar (255) NULL ," & _
"[txtcontent] text NULL ," & _
"[Ar_userid] int NOT NULL default 0," & _
"[hits] int NOT NULL default 0," & _
"[Istop] int NOT NULL default 0," & _
"[Iscontent] int NOT NULL default 0," & _
"[Islink] int NOT NULL default 0," & _
"[Ntype] int NOT NULL default 0," & _
"[Isbook] int NOT NULL default 0" & _
")"
Else
SQL = "CREATE TABLE [news] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[txttime] date NOT NULL default now()," & _
"[username] varchar (255) NULL ," & _
"[txttitle] varchar (255) NULL ," & _
"[txtcontent] text NULL ," & _
"[Ar_userid] int NOT NULL default 0," & _
"[hits] int NOT NULL default 0," & _
"[Istop] int NOT NULL default 0," & _
"[Iscontent] int NOT NULL default 0," & _
"[Islink] int NOT NULL default 0," & _
"[Ntype] int NOT NULL default 0," & _
"[Isbook] int NOT NULL default 0" & _
")"
End If
Case "[Siti_Setup]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE Siti_Setup (" &_
"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" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [Siti_Setup] (" &_
"[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" & _
")"
Else
SQL = "CREATE TABLE [Siti_Setup] (" &_
"[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," & _
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -