TXT WebUI/AdminM/DBbak/step1-create.txt

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

--**************************************** create sql 语句 *******************************************

if exists (select * from sysobjects  where name = 'dt_article_albums')
drop table dt_article_albums
go
create table dt_article_albums
(
id    int  identity(1,1)  primary key,
article_id    int  ,
big_img    nvarchar(255)    ,
small_img    nvarchar(255)    ,
remark    nvarchar(500)    
)

if exists (select * from sysobjects  where name = 'dt_article_comment')
drop table dt_article_comment
go
create table dt_article_comment
(
id    int  identity(1,1)  primary key,
article_id    int  ,
user_id    int  ,
user_name    nvarchar(100)    ,
user_ip    nvarchar(255)    ,
content    ntext  ,
is_lock    tinyint  ,
add_time    datetime  ,
is_reply    tinyint  ,
reply_content    ntext  ,
reply_time    datetime  
)

if exists (select * from sysobjects  where name = 'dt_article_diggs')
drop table dt_article_diggs
go
create table dt_article_diggs
(
id    int  ,
digg_good    int  ,
digg_bad    int  
)

if exists (select * from sysobjects  where name = 'dt_mail_template')
drop table dt_mail_template
go
create table dt_mail_template
(
id    int  identity(1,1)  primary key,
title    nvarchar(100)    ,
call_index    nvarchar(50)    ,
maill_title    nvarchar(100)    ,
content    ntext  ,
is_sys    tinyint  
)

if exists (select * from sysobjects  where name = 'dt_payment')
drop table dt_payment
go
create table dt_payment
(