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 ,
[shopcategorylist] [char] (300) NOT NULL ,
[recommend] [tinyint] NOT NULL ,
[discount] [tinyint] NOT NULL ,
[selleruid] [int] NOT NULL ,
[seller] [nchar] (20) NOT NULL ,
[account] [nchar] (50) NOT NULL ,
[title] [nchar] (60) NOT NULL ,
[magic] [int] NOT NULL ,
[price] [decimal](18, 2) NOT NULL ,
[amount] [smallint] NOT NULL ,
[quality] [tinyint] NOT NULL ,
[lid] [int] NOT NULL ,
[locus] [nchar] (20) NOT NULL ,
[transport] [tinyint] NOT NULL ,
[ordinaryfee] [decimal](18, 2) NOT NULL ,
[expressfee] [decimal](18, 2) NOT NULL ,
[emsfee] [decimal](18, 2) NOT NULL ,
[itemtype] [tinyint] NOT NULL ,
[dateline] [datetime] NOT NULL ,
[expiration] [datetime] NOT NULL ,
[lastbuyer] [nchar] (10) NOT NULL ,
[lasttrade] [datetime] NOT NULL ,
[lastupdate] [datetime] NOT NULL ,
[totalitems] [smallint] NOT NULL ,
[tradesum] [decimal](18, 2) NOT NULL ,
[closed] [tinyint] NOT NULL ,
[aid] [int] NOT NULL ,
[goodspic] [nchar] (100) NOT NULL ,
[displayorder] [int] NOT NULL ,
[costprice] [decimal](18, 2) NOT NULL ,
[invoice] [tinyint] NOT NULL ,
[repair] [smallint] NOT NULL ,
[message] [ntext] NOT NULL ,
[otherlink] [nchar] (250) NOT NULL ,
[readperm] [int] NOT NULL ,
[tradetype] [tinyint] NOT NULL ,
[viewcount] [int] NOT NULL ,
[invisible] [int] NOT NULL ,
[smileyoff] [int] NOT NULL ,
[bbcodeoff] [int] NOT NULL ,
[parseurloff] [int] NOT NULL ,
[highlight] [varchar] (500) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;
CREATE TABLE [dnt_goodsattachments] (
[aid] [int] IDENTITY (1, 1) NOT NULL ,
[uid] [int] NOT NULL ,
[goodsid] [int] NOT NULL ,
[categoryid] [int] NOT NULL ,
[postdatetime] [datetime] NOT NULL ,
[readperm] [int] NOT NULL ,
[filename] [nchar] (100) NOT NULL ,
[description] [nchar] (100) NOT NULL ,
[filetype] [nchar] (50) NOT NULL ,
[filesize] [int] NOT NULL ,
[attachment] [nchar] (100) NOT NULL
) ON [PRIMARY]
;
CREATE TABLE [dnt_goodscategories] (
[categoryid] [int] IDENTITY (1, 1) NOT NULL ,
[parentid] [int] NOT NULL ,
[layer] [smallint] NOT NULL ,
[parentidlist] [char] (300) NOT NULL ,
[displayorder] [int] NOT NULL ,
[categoryname] [nchar] (50) NOT NULL ,
[haschild] [bit] NOT NULL ,
[fid] [int] NOT NULL ,
[pathlist] [nchar] (3000) NOT NULL ,
[goodscount] [int] NOT NULL
) ON [PRIMARY]
;
CREATE TABLE [dnt_goodscreditrules] (
[id] [int] NOT NULL ,
[lowerlimit] [int] NOT NULL ,
[upperlimit] [int] NOT NULL ,
[sellericon] [varchar] (20) NULL ,
[buyericon] [varchar] (20) NULL
) ON [PRIMARY]
;
CREATE TABLE [dnt_goodsleavewords] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[goodsid] [int] NOT NULL ,
[tradelogid] [int] NOT NULL ,
[isbuyer] [tinyint] NOT NULL ,
[uid] [int] NOT NULL ,
[username] [nchar] (20) NOT NULL ,
[message] [nchar] (200) NOT NULL ,
[invisible] [int] NOT NULL ,
[ip] [nvarchar] (15) NOT NULL ,
[usesig] [int] NOT NULL ,
[htmlon] [int] NOT NULL ,
[smileyoff] [int] NOT NULL ,
[parseurloff] [int] NOT NULL ,
[bbcodeoff] [int] NOT NULL ,
[postdatetime] [datetime] NOT NULL
) ON [PRIMARY]
;
CREATE TABLE [dnt_goodsrates] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[goodstradelogid] [int] NOT NULL ,
[message] [nchar] (200) NOT NULL ,
[explain] [nchar] (200) NOT NULL ,
[ip] [nvarchar] (15) NOT NULL ,
[uid] [int] NOT NULL ,
[uidtype] [tinyint] NOT NULL ,
[username] [nchar] (20) NOT NULL ,
[ratetouid] [int] NOT NULL ,
[ratetousername] [nchar] (20) NOT NULL ,
[postdatetime] [datetime] NOT NULL ,
[goodsid] [int] NOT NULL ,
[goodstitle] [nchar] (60) NOT NULL ,
[price] [decimal](18, 2) NOT NULL ,
[ratetype] [tinyint] NOT NULL
) ON [PRIMARY]
;
CREATE TABLE [dnt_goodstags] (
[tagid] [int] NOT NULL ,
[goodsid] [int] NOT NULL
) ON [PRIMARY]
;
CREATE TABLE [dnt_goodstradelogs] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[goodsid] [int] NOT NULL ,
[orderid] [varchar] (50) NOT NULL ,
[tradeno] [varchar] (50) NOT NULL ,
[subject] [nchar] (60) NOT NULL ,
[price] [decimal](18, 2) NOT NULL ,
[quality] [tinyint] NOT NULL ,
[categoryid] [int] NOT NULL ,
[number] [smallint] NOT NULL ,
[tax] [decimal](18, 2) NOT NULL ,
[locus] [varchar] (50) NOT NULL ,
[sellerid] [int] NOT NULL ,
[seller] [nchar] (20) NOT NULL ,
[selleraccount] [varchar] (50) NOT NULL ,
[buyerid] [int] NOT NULL ,
[buyer] [nchar] (20) NOT NULL ,
[buyercontact] [nchar] (100) NOT NULL ,
[buyercredit] [smallint] NOT NULL ,
[buyermsg] [nchar] (100) NOT NULL ,
[status] [tinyint] NOT NULL ,
[lastupdate] [datetime] NOT NULL ,
[offline] [tinyint] NOT NULL ,
[buyername] [nchar] (20) NOT NULL ,
[buyerzip] [varchar] (50) NOT NULL ,
[buyerphone] [varchar] (50) NOT NULL ,
[buyermobile] [varchar] (50) NOT NULL ,
[transport] [tinyint] NOT NULL ,
[transportfee] [decimal](18, 2) NOT NULL ,
[transportpay] [tinyint] NOT NULL ,
[tradesum] [decimal](18, 2) NOT NULL ,
[baseprice] [decimal](18, 2) NOT NULL ,
[discount] [tinyint] NOT NULL ,
[ratestatus] [tinyint] NOT NULL ,
[message] [ntext] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;
CREATE TABLE [dnt_goodsusercredits] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[uid] [int] NOT NULL ,
[oneweek] [int] NOT NULL ,
[onemonth] [int] NOT NULL ,
[sixmonth] [int] NOT NULL ,
[sixmonthago] [int] NOT NULL ,
[ratefrom] [tinyint] NOT NULL ,
[ratetype] [tinyint] NOT NULL
) ON [PRIMARY]
;
CREATE TABLE [dnt_shopcategories] (
[categoryid] [int] IDENTITY (1, 1) NOT NULL ,
[parentid] [int] NOT NULL ,
[parentidlist] [char] (300) NOT NULL ,
[layer] [int] NOT NULL ,
[childcount] [int] NOT NULL
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
Discuz!NT 3.1版本功能亮点十足,安装、升级流程全面改善,产品安装升级更加轻松。系统改进包括聚合、用户、积分、转发等几个方面。全新的聚合首页系统,可直接聚合社区焦点内容作为首页,提升社区用户体验、改进了搜索引擎收录效果。改进后的会员系统不仅支持邀请注册功能,同时支持在游客发帖时,帖子页面直接显示游客所在地,例如在北京的用户发布时直接显示为北京地区用户。在网友阅读帖子主题时,头像下方显示项目和头像弹出层显示项目可以后台自定义,更加方便社区的管理运营。全新的积分系统新增了动画提示效果,积分功能预置支付宝充值,可为论坛运营创收提供有利的条件。转发功能的推出,方便用户将内容分享到各大门户和社交网站(SNS),更加有利于论坛推广。 Discuz!NT具有安全、高效、易用等特点,产品开放源代码下载三年的时间,受到了国内众多ASP.net项目用户的欢迎,成为国内ASP.net社区论坛产品的标杆。Discuz!NT 3.1版本全面支持Windows server 2008 R2系统,并且支持集成模式。免费为商业用户提供64位编译版本。Discuz!NT 3.1版本为项目用户专门开发了负载均衡、数据库读写分离、分布式缓存和检测工具一系列套件,为超大型社区建设提供了完美的技术解决方案。
资源推荐
资源详情
资源评论
收起资源包目录
Discuz!NT 3.1正式版源码 (4754个子文件)
ajaxviewuserpost.ascx 6KB
usergrouppowersetting.ascx 5KB
ajaxuserbloglist.ascx 5KB
ajaxuserspacecommentlist.ascx 4KB
ajaxtopicinfo.ascx 4KB
ajaxsubmitcomment.ascx 3KB
ajaxspaceinfo.ascx 3KB
ajaxspacepostinfo.ascx 3KB
ajaxalbumlist.ascx 3KB
ajaxphotoinfo.ascx 2KB
uploadfile.ascx 2KB
ajaxuseralbums.ascx 2KB
forumstree.ascx 2KB
fronttop.ascx 2KB
ajaxuserbloglistbydate.ascx 2KB
shortcutmenu.ascx 2KB
textarearesize.ascx 2KB
onlineeditor.ascx 1KB
ajaxtopnewcomment.ascx 1KB
ajaxtopnewpost.ascx 1KB
ajaxspacelink.ascx 1011B
ajaxspaceconfigstatic.ascx 992B
frontleftnavmenu.ascx 841B
ajaxpostinfo.ascx 801B
spacecalendar.ascx 686B
pageinfo.ascx 576B
dropdownpost.ascx 262B
frontbottom.ascx 222B
AddTopictype.ascx 187B
searchfunction.ascx 174B
searchuser.ascx 166B
favoritefunction.ascx 157B
MetaBlog.ashx 74B
UploadAvatar.asmx 78B
MixObjects.asmx 75B
posttopic.aspx 155KB
showtopic.aspx 146KB
postreply.aspx 144KB
editpost.aspx 141KB
showforum.aspx 140KB
editgoods.aspx 116KB
modcp.aspx 113KB
showbonus.aspx 112KB
postgoods.aspx 100KB
showdebate.aspx 96KB
website.aspx 88KB
usercpmygoods.aspx 73KB
topicadmin.aspx 72KB
search.aspx 68KB
showgoodslist.aspx 67KB
showgoods.aspx 64KB
forumindex.aspx 63KB
stats.aspx 62KB
offlinetrade.aspx 62KB
register.aspx 60KB
usercp.aspx 59KB
usercppostpm.aspx 57KB
showtopiclist.aspx 53KB
usercpshopgoodsmanage.aspx 53KB
tags.aspx 52KB
usercpprofile.aspx 50KB
onlinetrade.aspx 49KB
usercpcreditspay.aspx 48KB
usercpspacephotoadd.aspx 47KB
usercpshowpm.aspx 47KB
userinfo.aspx 46KB
usercpspaceset.aspx 46KB
goodsadmin.aspx 45KB
invite.aspx 45KB
usercpspacemanagealbum.aspx 45KB
buytopic.aspx 44KB
usercpinbox.aspx 44KB
usercpsentbox.aspx 44KB
usercpdraftbox.aspx 44KB
usercpspaceeditblog.aspx 44KB
usercpshopcategory.aspx 44KB
usercpspacemanagephoto.aspx 43KB
usercpspacepostblog.aspx 43KB
usercpshoplink.aspx 43KB
usercpnewpassword.aspx 42KB
login.aspx 42KB
spaceindex.aspx 41KB
showphoto.aspx 41KB
usercpshopconfig.aspx 41KB
usercpcreditstransfer.aspx 40KB
buygoods.aspx 40KB
usercpnotice.aspx 40KB
usercpspacemanageattachment.aspx 40KB
usercppreference.aspx 40KB
useradmin.aspx 40KB
usercpspacemanageblog.aspx 40KB
usercpspacemanagecategory.aspx 40KB
usercpsubscribe.aspx 40KB
usercpspacelinklist.aspx 40KB
usercpspacecomment.aspx 39KB
usercpannouncepm.aspx 39KB
usercpspacecategoryedit.aspx 39KB
usercpspacelinkedit.aspx 39KB
getpassword.aspx 39KB
usercpspacecategoryadd.aspx 39KB
共 4754 条
- 1
- 2
- 3
- 4
- 5
- 6
- 48
资源评论
- 风清阳10242014-06-26这是个不错的资源,代码可以使用,就是缺少数据库
Interlude
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- GVC-全球价值链参与地位指数,基于ICIO表,(Wang等 2017a)计算方法
- 易语言ADS指纹浏览器管理工具
- 易语言奇易模块5.3.6
- cad定制家具平面图工具-(FG)门板覆盖柜体
- asp.net 原生js代码及HTML实现多文件分片上传功能(自定义上传文件大小、文件上传类型)
- whl@pip install pyaudio ERROR: Failed building wheel for pyaudio
- Constantsfd密钥和权限集合.kt
- 基于Java的财务报销管理系统后端开发源码
- 基于Python核心技术的cola项目设计源码介绍
- 基于Python及多语言集成的TSDT软件过程改进设计源码
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功