📄 inc.asp
字号:
"[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_gxdate] smalldatetime NOT NULL default getdate()," & _
"[list_date] smalldatetime NOT NULL default getdate()," & _
"[yearhitstime] smalldatetime NOT NULL default getdate()," & _
"[monthhitstime] smalldatetime NOT NULL default getdate()," & _
"[weekdayhitstime] smalldatetime NOT NULL default getdate()," & _
"[dayhitstime] smalldatetime NOT NULL default getdate()," & _
"[yearjiantime] smalldatetime NOT NULL default getdate()," & _
"[monthjiantime] smalldatetime NOT NULL default getdate()," & _
"[weekdayjiantime] smalldatetime NOT NULL default getdate()," & _
"[list_Url] varchar (255) NULL ," & _
"[list_rar] varchar (255) NULL ," & _
"[list_umd] varchar (255) NULL ," & _
"[list_jar] varchar (255) NULL ," & _
"[dayjiantime] smalldatetime NOT NULL default getdate()," & _
"[newviewname] varchar (255) NULL ," & _
"[newview] text NULL " & _
")"
Else
SQL = "CREATE TABLE [list_book] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[list_gxdate] Date NOT NULL default now()," & _
"[list_date] Date NOT NULL default now()," & _
"[yearhitstime] Date NOT NULL default now()," & _
"[monthhitstime] Date NOT NULL default now()," & _
"[weekdayhitstime] Date NOT NULL default now()," & _
"[dayhitstime] Date NOT NULL default now()," & _
"[yearjiantime] Date NOT NULL default now()," & _
"[monthjiantime] Date NOT NULL default now()," & _
"[weekdayjiantime] Date NOT NULL default now()," & _
"[dayjiantime] Date NOT NULL default now()," & _
"[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," & _
"[list_Url] varchar (255) NULL ," & _
"[list_rar] varchar (255) NULL ," & _
"[list_umd] varchar (255) NULL ," & _
"[list_jar] varchar (255) NULL ," & _
"[newviewid] int NOT NULL default 0," & _
"[newviewname] varchar (255) NULL ," & _
"[newview] text NULL " & _
")"
End If
Case "[list_class]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE list_class (list_classID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"list_typeID int NOT NULL default 0," & _
"classinfo text NULL," & _
"list_classname varchar (100) NULL " & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [list_class] ([list_classID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_class PRIMARY KEY," &_
"[list_typeID] int NOT NULL default 0," & _
"[classinfo] text NULL," & _
"[list_classname] varchar (100) NULL " & _
")"
Else
SQL = "CREATE TABLE [list_class] ([list_classID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[list_typeID] int NOT NULL default 0," & _
"[classinfo] text NULL," & _
"[list_classname] varchar (100) NULL " & _
")"
End If
Case "[list_cook]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE list_cook (list_cookid int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"list_cookname varchar (255) NULL ," & _
"list_cookinfo text NULL," & _
"list_bookid int NOT NULL default 0," & _
"classid int NOT NULL default 0," & _
"list_userid int NOT NULL default 0," & _
"cook_viewid int NOT NULL default 0" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [list_cook] ([list_cookid] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_cook PRIMARY KEY," &_
"[list_cookname] varchar (255) NULL ," & _
"[list_cookinfo] text NULL," & _
"[list_bookid] int NOT NULL default 0," & _
"[classid] int NOT NULL default 0," & _
"[list_userid] int NOT NULL default 0," & _
"[cook_viewid] int NOT NULL default 0" & _
")"
Else
SQL = "CREATE TABLE [list_cook] ([list_cookid] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[list_cookname] varchar (255) NULL ," & _
"[list_cookinfo] text NULL," & _
"[list_bookid] int NOT NULL default 0," & _
"[classid] int NOT NULL default 0," & _
"[list_userid] int NOT NULL default 0," & _
"[cook_viewid] int NOT NULL default 0" & _
")"
End If
Case "[list_type]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE list_type (typeid int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"list_date timestamp NOT NULL default Now()," & _
"classinfo text NULL," & _
"list_tpye varchar (255) NULL " & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [list_type] ([typeid] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_type PRIMARY KEY," &_
"[list_date] smalldatetime NOT NULL default getdate()," & _
"[classinfo] text NULL," & _
"[list_tpye] varchar (255) NULL " & _
")"
Else
SQL = "CREATE TABLE [list_type] ([typeid] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
SQL = SQL &_
"[list_date] Date NOT NULL default now()," & _
"[classinfo] text NULL," & _
"[list_tpye] varchar (255) NULL " & _
")"
End If
Case "[list_view]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE list_view (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"view_date timestamp NOT NULL default Now()," & _
"view_type varchar(255) NOT NULL , "& _
"view_ok varchar(255) NULL , "& _
"list_cookid int NOT NULL default 0," & _
"view_id int NOT NULL default 0," & _
"view_lock int NOT NULL default 0," & _
"view_get int NOT NULL default 0," & _
"view_SaveToTXT int NOT NULL default 0," & _
"view_size int NOT NULL default 0," & _
"view_isvip int NOT NULL default 0," & _
"view_userid int NOT NULL default 0," & _
"view_showid int NOT NULL default 0," & _
"view_vips int NOT NULL default 0," & _
"ItemId int NOT NULL default 0," & _
"view_ok2 text NULL ," & _
"view_pic text NULL " & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [list_view] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_view PRIMARY KEY," &_
"[view_date] smalldatetime NOT NULL default getdate()," & _
"[view_type] varchar(255) NOT NULL , "& _
"[view_ok] varchar(255) NULL , "& _
"[list_cookid] int NOT NULL default 0," & _
"[view_id] int NOT NULL default 0," & _
"[view_lock] int NOT NULL default 0," & _
"[view_get] int NOT NULL default 0," & _
"[view_SaveToTXT] int NOT NULL default 0," & _
"[view_size] int NOT NULL default 0," & _
"[view_isvip] int NOT NULL default 0," & _
"[view_userid] int NOT NULL default 0," & _
"[view_showid] int NOT NULL default 0," & _
"[view_vips] int NOT NULL default 0," & _
"[ItemId] int NOT NULL default 0," & _
"[view_ok2] text NULL ," & _
"[view_pic] text NULL " & _
")"
Else
SQL = "CREATE TABLE [list_view] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[view_date] Date NOT NULL default now()," & _
"[view_type] varchar(255) NOT NULL , "& _
"[view_ok] varchar(255) NOT NULL , "& _
"[list_cookid] int NOT NULL default 0," & _
"[view_id] int NOT NULL default 0," & _
"[view_lock] int NOT NULL default 0," & _
"[view_get] int NOT NULL default 0," & _
"[view_SaveToTXT] int NOT NULL default 0," & _
"[view_size] int NOT NULL default 0," & _
"[view_isvip] int NOT NULL default 0," & _
"[view_userid] int NOT NULL default 0," & _
"[view_showid] int NOT NULL default 0," & _
"[view_vips] int NOT NULL default 0," & _
"[ItemId] int NOT NULL default 0," & _
"[view_ok2] text NULL ," & _
"[view_pic] text NULL " & _
")"
End If
Case "[pay]"
If IsSqlDataBase = 2 Then
SQL = "CREATE TABLE pay (ID int AUTO_INCREMENT NOT NULL PRIMARY KEY," &_
"pay varchar(2) NOT NULL , "& _
"payid varchar(50) NOT NULL , "& _
"paykey varchar(50) NOT NULL , "& _
"bank1 text NULL," & _
"bank2 text NULL," & _
"bank3 text NULL," & _
"bank4 text NULL," & _
"bank5 text NULL," & _
"bank6 text NULL," & _
"bank7 text NULL," & _
"bank8 text NULL," & _
"bank9 text NULL," & _
"bank10 text NULL," & _
"bank11 text NULL," & _
"bank12 text NULL," & _
"bank13 text NULL," & _
"bank14 text NULL," & _
"bank15 text NULL" & _
")"
ElseIf IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [pay] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_pay PRIMARY KEY," &_
"[pay] varchar(2) NOT NULL , "& _
"[payid] varchar(50) NOT NULL , "& _
"[paykey] varchar(50) NOT NULL , "& _
"[bank1] text NULL," & _
"[bank2] text NULL," & _
"[bank3] text NULL," & _
"[bank4] text NULL," & _
"[bank5] text NULL," & _
"[bank6] text NULL," & _
"[bank7] text NULL," & _
"[bank8] text NULL," & _
"[bank9] text NULL," & _
"[bank10] text NULL," & _
"[bank11] text NULL," & _
"[bank12] text NULL," & _
"[bank13] text NULL," & _
"[bank14] text NULL," & _
"[bank15] text NULL" & _
")"
Else
SQL = "CREATE TABLE [pay] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY," &_
"[pay] varchar(2) NOT NULL , "& _
"[payid] varchar(50) NOT NULL , "& _
"[paykey] varchar(50) NOT NULL , "& _
"[bank1] text NULL," & _
"[bank2] text NULL," & _
"[bank3] text NULL," & _
"[bank4] text NULL," & _
"[bank5] text NULL," & _
"[bank6] text NULL," & _
"[bank7] text NULL," & _
"[bank8] text NULL," & _
"[bank9] text NULL," & _
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -