📄 inc.asp
字号:
"[userID] int NOT NULL default 0" & _
")"
End If
Case "[guest_class]"
If IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [guest_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_guest_class PRIMARY KEY,"
Else
SQL = "CREATE TABLE [guest_class] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
End If
SQL = SQL &_
"[guest_class] varchar (255) NULL ," & _
"[guestNum] int NOT NULL default 0" & _
")"
Case "[link]"
If IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [link] ([id_link] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_link PRIMARY KEY,"
SQL = SQL &_
"[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,"
SQL = SQL &_
"[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 = 1 Then
SQL = "CREATE TABLE [list_book] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_book PRIMARY KEY,"
SQL = SQL &_
"[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_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,"
SQL = SQL &_
"[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 = 1 Then
SQL = "CREATE TABLE [list_class] ([list_classID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_class PRIMARY KEY,"
Else
SQL = "CREATE TABLE [list_class] ([list_classID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
End If
SQL = SQL &_
"[list_typeID] int NOT NULL default 0," & _
"[classinfo] text NULL," & _
"[list_classname] varchar (100) NULL " & _
")"
Case "[list_cook]"
If IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [list_cook] ([list_cookid] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_cook PRIMARY KEY,"
Else
SQL = "CREATE TABLE [list_cook] ([list_cookid] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
End If
SQL = SQL &_
"[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" & _
")"
Case "[list_type]"
If 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 = 1 Then
SQL = "CREATE TABLE [list_view] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_list_view PRIMARY KEY,"
SQL = SQL &_
"[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,"
SQL = SQL &_
"[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 = 1 Then
SQL = "CREATE TABLE [pay] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_pay PRIMARY KEY,"
Else
SQL = "CREATE TABLE [pay] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"
End If
SQL = SQL &_
"[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" & _
")"
Case "[news]"
If IsSqlDataBase = 1 Then
SQL = "CREATE TABLE [news] ([ID] int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_news PRIMARY KEY,"
SQL = SQL &_
"[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,"
SQL = SQL &_
"[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," & _
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -