📄 inc.asp
字号:
"[author_resume] text NULL ," & _
"[author_logins] int NOT NULL default 0," & _
"[author_lock] int NOT NULL default 0," & _
"[author_bookji] int NOT NULL default 0," & _
"[author_addpost] int NOT NULL default 0," & _
"[author_UserID] int NOT NULL default 0," & _
"[author_maney] int NOT NULL default 0" & _
")"
Else
SQL = "CREATE TABLE [Author] ([Author_ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[author_ADDDate] date NOT NULL default now()," & _
"[author_logDate] date NOT NULL default now()," & _
"[author_UserName] varchar (50) NULL ," & _
"[author_Password] varchar (50) NULL ," & _
"[author_Name] varchar (50) NULL ," & _
"[author_TrueName] varchar (50) NULL ," & _
"[author_sex] varchar (50) NULL ," & _
"[author_Email] varchar (200) NULL ," & _
"[author_face] varchar (200) NULL ," & _
"[author_address] varchar (255) NULL ," & _
"[author_zhengjian] varchar (200) NULL ," & _
"[author_tel] varchar (50) NULL ," & _
"[author_zip] varchar (50) NULL ," & _
"[author_ICQ] varchar (50) NULL ," & _
"[author_QQ] varchar (50) NULL ," & _
"[author_MSN] varchar (200) NULL ," & _
"[author_writing] text NULL ," & _
"[author_resume] text NULL ," & _
"[author_logins] int NOT NULL default 0," & _
"[author_lock] int NOT NULL default 0," & _
"[author_bookji] int NOT NULL default 0," & _
"[author_addpost] int NOT NULL default 0," & _
"[author_UserID] int NOT NULL default 0," & _
"[author_maney] int NOT NULL default 0" & _
")"
End If
Case "[Comment]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE Comment (CommentID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"WriteTime timestamp NOT NULL default Now()," & _
"ReplyTime timestamp NOT NULL," & _
"type_ID int NOT NULL default 0," & _
"UserName varchar (50) NULL ," & _
"Content text NULL," & _
"ReplyName varchar (255) NULL ," & _
"ReplyContent text NULL ," & _
"Commenttype int NOT NULL default 0," & _
"IsGood int NOT NULL default 0," & _
"IsTop int NOT NULL default 0," & _
"IsLock int NOT NULL default 0," & _
"User_ID int NOT NULL default 0" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [Comment] ([CommentID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_Comment PRIMARY KEY," &_
"[WriteTime] smalldatetime NOT NULL default getdate()," & _
"[ReplyTime] smalldatetime NOT NULL default getdate()," & _
"[type_ID] int NOT NULL default 0," & _
"[UserName] varchar (50) NULL ," & _
"[Content] text NULL," & _
"[ReplyName] varchar (255) NULL ," & _
"[ReplyContent] text NULL ," & _
"[Commenttype] int NOT NULL default 0," & _
"[IsGood] int NOT NULL default 0," & _
"[IsTop] int NOT NULL default 0," & _
"[IsLock] int NOT NULL default 0," & _
"[User_ID] int NOT NULL default 0" & _
")"
Else
SQL = "CREATE TABLE [Comment] ([CommentID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[WriteTime] date NOT NULL default now()," & _
"[ReplyTime] date NOT NULL default now()," & _
"[type_ID] int NOT NULL default 0," & _
"[UserName] varchar (50) NULL ," & _
"[Content] text NULL ," & _
"[ReplyName] varchar (255) NULL ," & _
"[ReplyContent] text NULL ," & _
"[Commenttype] int NOT NULL default 0," & _
"[IsGood] int NOT NULL default 0," & _
"[IsTop] int NOT NULL default 0," & _
"[IsLock] int NOT NULL default 0," & _
"[User_ID] int NOT NULL default 0" & _
")"
End If
Case "[Duanxin]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE Duanxin (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"dateandtime timestamp NOT NULL default Now()," & _
"content varchar (255) NULL," & _
"tj int NOT NULL default 0," & _
"yd int NOT NULL default 0," & _
"nickname varchar (50) NULL ," & _
"custom varchar (50) NULL " & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [Duanxin] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_Duanxin PRIMARY KEY," &_
"[dateandtime] smalldatetime NOT NULL default getdate()," & _
"[content] varchar (255) NULL," & _
"[tj] int NOT NULL default 0," & _
"[yd] int NOT NULL default 0," & _
"[nickname] varchar (50) NULL ," & _
"[custom] varchar (50) NULL " & _
")"
Else
SQL = "CREATE TABLE [Duanxin] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[dateandtime] date NOT NULL default now()," & _
"[content] varchar (255) NULL," & _
"[tj] int NOT NULL default 0," & _
"[yd] int NOT NULL default 0," & _
"[nickname] varchar (50) NULL ," & _
"[custom] varchar (50) NULL " & _
")"
End If
Case "[siti_Duanxin]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE siti_Duanxin (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"dateandtime timestamp NOT NULL default Now()," & _
"content varchar (255) NULL," & _
"sitis int NOT NULL default 0," & _
"yd int NOT NULL default 0," & _
"nickname varchar (50) NULL ," & _
"custom varchar (50) NULL " & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [siti_Duanxin] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_siti_Duanxin PRIMARY KEY," &_
"[dateandtime] smalldatetime NOT NULL default getdate()," & _
"[content] varchar (255) NULL," & _
"[sitis] int NOT NULL default 0," & _
"[yd] int NOT NULL default 0," & _
"[nickname] varchar (50) NULL ," & _
"[custom] varchar (50) NULL " & _
")"
Else
SQL = "CREATE TABLE [siti_Duanxin] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[dateandtime] date NOT NULL default now()," & _
"[content] varchar (255) NULL," & _
"[sitis] int NOT NULL default 0," & _
"[yd] int NOT NULL default 0," & _
"[nickname] varchar (50) NULL ," & _
"[custom] varchar (50) NULL " & _
")"
End If
Case "[guest]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE guest (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"date timestamp NOT NULL default Now()," & _
"time timestamp NOT NULL," & _
"title varchar (255) NULL ," & _
"content text NULL ," & _
"reply text NULL ," & _
"classid int NOT NULL default 0," & _
"userID int NOT NULL default 0" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [guest] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_guest PRIMARY KEY," &_
"[date] smalldatetime NOT NULL default getdate()," & _
"[time] smalldatetime NOT NULL default getdate()," & _
"[title] varchar (255) NULL ," & _
"[content] text NULL ," & _
"[reply] text NULL ," & _
"[classid] int NOT NULL default 0," & _
"[userID] int NOT NULL default 0" & _
")"
Else
SQL = "CREATE TABLE [guest] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[date] date NOT NULL default now()," & _
"[time] date NOT NULL default now()," & _
"[title] varchar (255) NULL ," & _
"[content] text NULL ," & _
"[reply] text NULL ," & _
"[classid] int NOT NULL default 0," & _
"[userID] int NOT NULL default 0" & _
")"
End If
Case "[guest_class]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE guest_class (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"guest_class varchar (255) NULL ," & _
"guestNum int NOT NULL default 0" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [guest_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_guest_class PRIMARY KEY," &_
"[guest_class] varchar (255) NULL ," & _
"[guestNum] int NOT NULL default 0" & _
")"
Else
SQL = "CREATE TABLE [guest_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[guest_class] varchar (255) NULL ," & _
"[guestNum] int NOT NULL default 0" & _
")"
End If
Case "[link]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE link (id_link int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"time_link timestamp NOT NULL default Now()," & _
"name_link varchar (255) NULL ," & _
"web_link varchar (255) NULL ," & _
"logo_link varchar (255) NULL ," & _
"content_link text NULL ," & _
"good_link int NOT NULL default 0," & _
"hits_link int NOT NULL default 0," & _
"ok_link int NOT NULL default 0," & _
"class_link int NOT NULL default 0," & _
"link_class int NOT NULL default 0," & _
"password_link varchar (255) NULL " & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [link] ([id_link] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_link PRIMARY KEY," &_
"[time_link] smalldatetime NOT NULL default getdate()," & _
"[name_link] varchar (255) NULL ," & _
"[web_link] varchar (255) NULL ," & _
"[logo_link] varchar (255) NULL ," & _
"[content_link] text NULL ," & _
"[good_link] int NOT NULL default 0," & _
"[hits_link] int NOT NULL default 0," & _
"[ok_link] int NOT NULL default 0," & _
"[class_link] int NOT NULL default 0," & _
"[link_class] int NOT NULL default 0," & _
"[password_link] varchar (255) NULL " & _
")"
Else
SQL = "CREATE TABLE [link] ([id_link] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[time_link] date NOT NULL default now()," & _
"[name_link] varchar (255) NULL ," & _
"[web_link] varchar (255) NULL ," & _
"[logo_link] varchar (255) NULL ," & _
"[content_link] text NULL ," & _
"[good_link] int NOT NULL default 0," & _
"[hits_link] int NOT NULL default 0," & _
"[ok_link] int NOT NULL default 0," & _
"[class_link] int NOT NULL default 0," & _
"[link_class] int NOT NULL default 0," & _
"[password_link] varchar (255) NULL" & _
")"
End If
Case "[list_book]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE list_book (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"list_name varchar (255) NULL ," & _
"list_user varchar (255) NULL ," & _
"laiyuan varchar (255) NULL ," & _
"list_qianyue varchar (255) NULL ," & _
"list_abc varchar (2) NULL ," & _
"list_key text NULL ," & _
"IsgoVipAnswer text NULL ," & _
"list_pic text NULL ," & _
"list_all text NULL ," & _
"list_news text NULL ," & _
"list_class int NOT NULL default 0," & _
"list_lei int NOT NULL default 0," & _
"list_tai int NOT NULL default 0," & _
"list_id int NOT NULL default 0," & _
"ItemId int NOT NULL default 0," & _
"list_hit int NOT NULL default 0," & _
"list_yhit int NOT NULL default 0," & _
"list_mhit int NOT NULL default 0," & _
"list_zhit int NOT NULL default 0," & _
"list_dhit int NOT NULL default 0," & _
"list_jian int NOT NULL default 0," & _
"list_yjian int NOT NULL default 0," & _
"list_mjian int NOT NULL default 0," & _
"list_zjian int NOT NULL default 0," & _
"list_djian int NOT NULL default 0," & _
"list_cang int NOT NULL default 0," & _
"list_sftai int NOT NULL default 0," & _
"IsVip int NOT NULL default 0," & _
"IsgoVip int NOT NULL default 0," & _
"vip_bookid int NOT NULL default 0," & _
"IsGood int NOT NULL default 0," & _
"Islist_good int NOT NULL default 0," & _
"Isweb_good int NOT NULL default 0," & _
"Lock_book int NOT NULL default 0," & _
"Lock_lun int NOT NULL default 0," & _
"list_size int NOT NULL default 0," & _
"list_userid int NOT NULL default 0," & _
"list_Authorid int NOT NULL default 0," & _
"list_Adminid int NOT NULL default 0," & _
"listvv_good int NOT NULL default 0," & _
"isuserread int NOT NULL default 0," & _
"userreadMoney int NOT NULL default 0," & _
"newviewid int NOT NULL default 0," & _
"list_date timestamp NOT NULL default Now()," & _
"list_gxdate timestamp NOT NULL," & _
"yearhitstime timestamp NOT NULL," & _
"monthhitstime timestamp NOT NULL," & _
"weekdayhitstime timestamp NOT NULL," & _
"dayhitstime timestamp NOT NULL," & _
"yearjiantime timestamp NOT NULL," & _
"monthjiantime timestamp NOT NULL," & _
"weekdayjiantime timestamp NOT NULL," & _
"dayjiantime timestamp NOT NULL," & _
"list_Url varchar (255) NULL ," & _
"list_rar varchar (255) NULL ," & _
"list_umd varchar (255) NULL ," & _
"list_jar varchar (255) NULL ," & _
"newviewname varchar (255) NULL ," & _
"newview text NULL " & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [list_book] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_book PRIMARY KEY," &_
"[list_name] varchar (255) NULL ," & _
"[list_user] varchar (255) NULL ," & _
"[laiyuan] varchar (255) NULL ," & _
"[list_qianyue] varchar (255) NULL ," & _
"[list_abc] varchar (2) NULL ," & _
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -