Discuz.Web/install/sqlscript/sqlserver/setup1.sql

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

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

if exists (select * from sysobjects where id = object_id(N'[catchsoftstatics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [catchsoftstatics]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_locations]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_locations]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_paymentlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_paymentlog]
;


if exists (select * from sysobjects where id = object_id(N'[dnt_admingroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_admingroups]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_adminvisitlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_adminvisitlog]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_advertisements]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_advertisements]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_announcements]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_announcements]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_attachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_attachments]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_attachtypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_attachtypes]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_bbcodes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_bbcodes]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_bonuslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_bonuslog]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_creditslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_creditslog]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_debatediggs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_debatediggs]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_debates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_debates]
;

if exists (select * from sysobjects where id = object_id(N'[dnt_failedlogins]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_failedlogins]
;