📄 inc.asp
字号:
"[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" & _
")"
End If
Case "[TXTadlist]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE TXTadlist (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"TXTadtime timestamp 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" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [TXTadlist] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_TXTadlist PRIMARY KEY," &_
"[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," &_
"[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 = 2 Then
SQL = "CREATE TABLE User_box (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"live_date timestamp 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" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [User_box] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_User_box PRIMARY KEY," &_
"[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," &_
"[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 = 2 Then
SQL = "CREATE TABLE Userinfo (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"ADDDate timestamp NOT NULL default Now()," & _
"LoginTime timestamp NOT NULL," & _
"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" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [Userinfo] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_Userinfo PRIMARY KEY," &_
"[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," &_
"[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 = 2 Then
SQL = "CREATE TABLE vote (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"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" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [vote] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_vote PRIMARY KEY," &_
"[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" & _
")"
Else
SQL = "CREATE TABLE [vote] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[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" & _
")"
End If
Case "[vote_class]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE vote_class (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"title varchar (255) NULL ," & _
"class int NOT NULL default 0," & _
"choice int NOT NULL default 0" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [vote_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_vote_class PRIMARY KEY," &_
"[title] varchar (255) NULL ," & _
"[class] int NOT NULL default 0," & _
"[choice] int NOT NULL default 0" & _
")"
Else
SQL = "CREATE TABLE [vote_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[title] varchar (255) NULL ," & _
"[class] int NOT NULL default 0," & _
"[choice] int NOT NULL default 0" & _
")"
End If
Case "[filetest]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE filetest (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"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" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [filetest] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_filetest PRIMARY KEY," &_
"[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" & _
")"
Else
SQL = "CREATE TABLE [filetest] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[fileurl_info] varchar (255) NULL ," & _
"[fileurl_name] va⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -