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
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
修复的问题: 删除用户组后,组别显示为游客的问题 精华帖重复加分 审核贴通过后积分和帖数出错 删帖时积分规则没有以版块积分设置优先 管理员删帖重复扣分 图片轮显无数据时JS错 添加广告提示结束时间不对的问题 IE6下排序和筛选按钮无效 IE6下“只看楼主”等按钮被隐藏 回复xxx楼没有显示楼号 编辑老帖子附件失效 私密论坛UI的问题 登录页tab键顺序 编辑器中已有附件的标记问题 普通上传重复添加附件的问题 后台添加用户组失败 编辑器中附件阅读权限不统一 回帖时批量上传的问题 编辑器中插入的图片显示为红叉 下载附件扣分无效 点击引用时,无法载入编辑器 帖子所有分页都加入“载入所有图片”的链接 版块图标导致换行 开启图片后加载,帖子翻页后没有“全部加载”的链接 改进及新功能: 后台添加设置,允许用户删除自己帖子的期限 精华帖重复加分 趋势统计(站长可查看论坛每日发帖数,访问数等,且可设置哪些用户组可查看) 后台导航改进 showtopic页UI的问题 统计 广告 聚合的展示顺序 编辑器中阅读权限统一改为选择用户组 提示上次未使用的附件,把忽略改为删除 改进图片附件的排版 热点、排行改进:用户和版块的提取条件增加按时间范围获取数据 后台增加设置:是否允许切换宽/窄屏和默认使用宽/窄屏
资源推荐
资源详情
资源评论
收起资源包目录
Discuz!NT 3.5.2正式版源码 (2000个子文件)
usergrouppowersetting.ascx 6KB
ajaxtopicinfo.ascx 4KB
ajaxspaceinfo.ascx 3KB
ajaxspacepostinfo.ascx 3KB
ajaxalbumlist.ascx 3KB
ajaxphotoinfo.ascx 2KB
onlineeditor.ascx 2KB
forumstree.ascx 2KB
shortcutmenu.ascx 2KB
textarearesize.ascx 2KB
ajaxpostinfo.ascx 801B
pageinfo.ascx 576B
dropdownpost.ascx 262B
AddTopictype.ascx 187B
searchfunction.ascx 174B
searchuser.ascx 166B
favoritefunction.ascx 157B
synclocalcache.ashx 74B
Album.asmx 97B
UploadAvatar.asmx 78B
MixObjects.asmx 75B
showtopic.aspx 222KB
showforum.aspx 189KB
posttopic.aspx 164KB
postreply.aspx 155KB
modcp.aspx 150KB
editpost.aspx 145KB
showdebate.aspx 113KB
showbonus.aspx 111KB
website.aspx 103KB
forumindex.aspx 91KB
topicadmin.aspx 84KB
register.aspx 79KB
stats.aspx 76KB
usercp.aspx 71KB
usercpprofile.aspx 70KB
search.aspx 69KB
referrer.aspx 69KB
usercppostpm.aspx 68KB
tags.aspx 66KB
userinfo.aspx 65KB
buytopic.aspx 59KB
showtopiclist.aspx 59KB
usercpshowpm.aspx 59KB
login.aspx 56KB
usercpsentbox.aspx 55KB
usercpdraftbox.aspx 55KB
usercpinbox.aspx 55KB
usercpcreditsbuy.aspx 55KB
invite.aspx 54KB
usercpcreditspay.aspx 53KB
usercpnewpassword.aspx 53KB
usercpsubscribe.aspx 53KB
usercpcreditstransfer.aspx 52KB
getpassword.aspx 52KB
usercppreference.aspx 52KB
usercpnotice.aspx 52KB
usercpannouncepm.aspx 51KB
usercpignorelist.aspx 51KB
myposts.aspx 50KB
usercpcreditspayinlog.aspx 50KB
usercpcreaditstransferlog.aspx 50KB
mytopics.aspx 50KB
usercpcreditspayoutlog.aspx 50KB
myattachment.aspx 50KB
useradmin.aspx 48KB
attachment.aspx 47KB
showuser.aspx 46KB
help.aspx 46KB
getip.aspx 46KB
setnewpassword.aspx 45KB
misc.aspx 43KB
showratelist.aspx 43KB
onlineuser.aspx 42KB
showtemplate.aspx 42KB
favorites.aspx 41KB
delpost.aspx 41KB
forumsearch.aspx 39KB
announcement.aspx 37KB
poll.aspx 37KB
activationuser.aspx 35KB
logout.aspx 35KB
forumlist.aspx 31KB
forum_editforums.aspx 27KB
global_uiandshowstyle.aspx 25KB
mall_goodscategoriesmanage.aspx 25KB
global_addadvs.aspx 24KB
global_editadvs.aspx 24KB
managerbody.aspx 22KB
global_registerandvisit.aspx 22KB
global_edituser.aspx 21KB
global_scoreset.aspx 21KB
forum_editmall.aspx 20KB
forum_option.aspx 20KB
forum_forumhot.aspx 19KB
help.aspx 18KB
global_addadminusergroup.aspx 17KB
global_safecontrol.aspx 17KB
global_editusergroup.aspx 17KB
global_editadminusergroup.aspx 17KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
- 文痞2018-12-05谢谢楼主分享,分享
- tulei20062014-06-19这个资源不太好找啊,资源本身还不错。
- feng2757797042011-10-21部署后版本好像有点低, 有高点的版本么。 ?
- dancky573592013-01-14嗯,可以用...
一禅(OneZen)
- 粉丝: 866
- 资源: 36
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功