TXT Discuz.Web/upgrade/sqlscript/sqlserver/mall.txt

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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




CREATE TABLE [dnt_goods] (
	[goodsid] [int] IDENTITY (1, 1) NOT NULL ,
	[shopid] [int] NOT NULL ,
	[categoryid] [int] NOT NULL ,
	[parentcategorylist] [char] (300)  NOT NULL ,