织梦数据库结构

dede_addonarticle Field Type Extra P aid mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED body mediumtext Allow Null redirecturl varchar(255) templet varchar(30) userip char(15) Index Fields Extra typeid typeid dede_addonimages Field Type Extra P aid mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED pagestyle smallint(6) maxwidth smallint(6) imgurls text Allow Null row smallint(6) col smallint(6) isrm smallint(6) ddmaxwidth smallint(6) pagepicnum smallint(6) templet varchar(30) userip char(15) redirecturl varchar(255) body mediumtext Allow Null Index Fields Extra imagesMain typeid dede_addoninfos Field Type Extra P aid int(11) typeid int(11) channel smallint(6) arcrank smallint(6) mid mediumint(8) UNSIGNED click int(10) UNSIGNED title varchar(60) litpic varchar(60) userip varchar(15) senddate int(11) flag set('c','h','p','f','s','j','a','b') Allow Null lastpost int(10) UNSIGNED scores mediumint(8) goodpost mediumint(8) UNSIGNED badpost mediumint(8) UNSIGNED nativeplace smallint(5) UNSIGNED infotype char(20) body mediumtext Allow Null endtime int(11) tel varchar(50) email varchar(50) address varchar(100) linkman varchar(50) Index Fields Extra typeid typeid, nativeplace, infotype channel channel, arcrank, mid, click, title, litpic, senddate, flag, endtime 1 dede_addonshop Field Type Extra P aid mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED body mediumtext Allow Null price float trueprice float brand varchar(250) units varchar(250) templet varchar(30) userip char(15) redirecturl varchar(255) vocation char(20) infotype char(20) uptime int(11) Index Fields Extra typeid typeid dede_addonsoft Field Type Extra P aid mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED filetype varchar(10) language varchar(10) softtype varchar(10) accredit varchar(10) os varchar(30) softrank mediumint(8) UNSIGNED officialUrl varchar(30) officialDemo varchar(50) softsize varchar(10) softlinks text Allow Null introduce text Allow Null daccess smallint(5) needmoney smallint(5) templet varchar(30) userip char(15) redirecturl varchar(255) Index Fields Extra softMain typeid dede_addonspec Field Type Extra P aid mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED note text Allow Null templet varchar(30) userip char(15) redirecturl varchar(255) Index Fields Extra typeid typeid 2 dede_admin Field Type Extra P id int(10) UNSIGNED usertype float UNSIGNED Allow Null userid char(30) pwd char(32) uname char(20) tname char(30) email char(30) typeid text Allow Null logintime int(10) UNSIGNED loginip varchar(20) dede_admintype Field Type Extra P rank float typename varchar(30) system smallint(6) purviews text Allow Null dede_advancedsearch Field Type Extra mid int(11) maintable varchar(256) mainfields text Allow Null addontable varchar(256) Allow Null addonfields text Allow Null forms text Allow Null template varchar(256) Index Fields Extra mid mid Unique dede_arcatt Field Type Extra sortid smallint(6) P att char(10) attname char(30) dede_arccache Field Type Extra P md5hash char(32) uptime int(11) cachedata mediumtext Allow Null 3 dede_archives Field Type Extra P id mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED typeid2 varchar(90) sortrank int(10) UNSIGNED flag set('c','h','p','f','s','j','a','b') Allow Null ismake smallint(6) channel smallint(6) arcrank smallint(6) click mediumint(8) UNSIGNED money smallint(6) title char(60) shorttitle char(36) color char(7) writer char(20) source char(30) litpic char(100) pubdate int(10) UNSIGNED senddate int(10) UNSIGNED mid mediumint(8) UNSIGNED keywords char(30) lastpost int(10) UNSIGNED scores mediumint(8) goodpost mediumint(8) UNSIGNED badpost mediumint(8) UNSIGNED voteid mediumint(8) notpost tinyint(1) UNSIGNED description varchar(255) filename varchar(40) dutyadmin mediumint(8) UNSIGNED tackid int(10) mtype mediumint(8) UNSIGNED weight int(10) Index Fields Extra sortrank sortrank mainindex arcrank, typeid, channel, flag, mid lastpost lastpost, scores, goodpost, badpost, notpost dede_arcmulti Field Type Extra P id mediumint(8) UNSIGNED Auto Increment tagid char(60) uptime int(11) innertext varchar(255) pagesize int(11) arcids text ordersql varchar(255) Allow Null addfieldsSql varchar(255) Allow Null addfieldsSqlJoin varchar(255) Allow Null attstr text Allow Null dede_arcrank Field Type Extra P id smallint(5) UNSIGNED Auto Increment rank smallint(6) membername char(20) adminrank smallint(6) money smallint(8) UNSIGNED scores mediumint(8) purviews mediumtext Allow Null 4 dede_arctiny Field Type Extra P id mediumint(8) UNSIGNED Auto Increment typeid smallint(5) UNSIGNED typeid2 varchar(90) arcrank smallint(6) channel smallint(5) senddate int(10) UNSIGNED sortrank int(10) UNSIGNED mid mediumint(8) UNSIGNED Index Fields Extra sortrank sortrank dede_arctype Field Type Extra P id smallint(5) UNSIGNED Auto Increment reid smallint(5) UNSIGNED topid smallint(5) UNSIGNED sortrank smallint(5) UNSIGNED typename char(30) typedir char(60) isdefault smallint(6) defaultname char(15) issend smallint(6) channeltype smallint(6) Allow Null maxpage smallint(6) ispart smallint(6) corank smallint(6) tempindex char(50) templist char(50) temparticle char(50) namerule char(50) namerule2 char(50) modname char(20) description char(150) keywords varchar(60) seotitle varchar(80) moresite tinyint(1) UNSIGNED sitepath char(60) siteurl char(50) ishidden smallint(6) cross tinyint(1) crossid text Allow Null content text Allow Null smalltypes text Allow Null Index Fields Extra reid reid, isdefault, channeltype, ispart, corank, topid, ishidden sortrank sortrank dede_area Field Type Extra P id int(10) UNSIGNED Auto Increment name varchar(20) reid int(10) UNSIGNED disorder int(10) UNSIGNED 5 dede_channeltype Field Type Extra P id smallint(6) nid varchar(20) typename varchar(30) maintable varchar(50) addtable varchar(50) addcon varchar(30) mancon varchar(30) editcon varchar(30) useraddcon varchar(30) usermancon varchar(30) usereditcon varchar(30) fieldset text Allow Null listfields text Allow Null allfields text Allow Null issystem smallint(6) isshow smallint(6) issend smallint(6) arcsta smallint(6) usertype char(10) sendrank smallint(6) isdefault smallint(6) needdes tinyint(1) needpic tinyint(1) titlename varchar(20) onlyone smallint(6) dfcid smallint(5) UNSIGNED Index Fields Extra nid nid, isshow, arcsta, sendrank dede_co_htmls Field Type Extra P aid mediumint(8) UNSIGNED Auto Increment nid mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED title varchar(60) litpic varchar(100) url varchar(100) dtime int(10) UNSIGNED isdown tinyint(1) UNSIGNED isexport tinyint(1) result mediumtext Allow Null Index Fields Extra nid nid typeid typeid, title, url, dtime, isdown, isexport dede_co_mediaurls Field Type Extra nid mediumint(8) UNSIGNED hash char(32) tofile char(60) Index Fields Extra hash hash 6 dede_co_note Field Type Extra P nid mediumint(8) UNSIGNED Auto Increment channelid smallint(5) UNSIGNED notename varchar(50) sourcelang varchar(10) uptime int(10) UNSIGNED cotime int(10) UNSIGNED pnum smallint(5) UNSIGNED isok tinyint(1) UNSIGNED usemore tinyint(1) UNSIGNED listconfig text Allow Null itemconfig text Allow Null Index Fields Extra isok isok, channelid, cotime dede_co_onepage Field Type Extra P id int(11) Auto Increment url varchar(60) title varchar(60) issource smallint(6) lang varchar(10) rule text Allow Null Index Fields Extra url url dede_co_urls Field Type Extra P id int(10) UNSIGNED Auto Increment hash varchar(32) nid smallint(5) UNSIGNED dede_diyforms Field Type Extra P diyid int(10) UNSIGNED Auto Increment name varchar(50) posttemplate varchar(50) viewtemplate varchar(50) listtemplate varchar(50) table varchar(50) info text Allow Null public tinyint(1) dede_dl_log Field Type Extra P id mediumint(10) UNSIGNED Auto Increment ip char(16) lang char(6) dtype varchar(10) dltime int(10) UNSIGNED referrer varchar(255) user_agent varchar(255) Index Fields Extra dltime dltime dl_ip ip, dltime 7 dede_downloads Field Type Extra P hash char(32) id int(10) UNSIGNED downloads int(10) UNSIGNED dede_erradd Field Type Extra id int(10) UNSIGNED Auto Increment aid mediumint(8) UNSIGNED mid mediumint(8) UNSIGNED Allow Null title char(60) type smallint(6) errtxt mediumtext Allow Null oktxt mediumtext Allow Null sendtime int(10) UNSIGNED Index Fields Extra id id dede_feedback Field Type Extra P id int(10) UNSIGNED Auto Increment aid mediumint(8) UNSIGNED typeid smallint(5) UNSIGNED username char(20) arctitle varchar(60) ip char(15) ischeck smallint(6) dtime int(10) UNSIGNED mid mediumint(8) UNSIGNED bad mediumint(8) UNSIGNED good mediumint(8) UNSIGNED ftype set('feedback','good','bad') face smallint(5) UNSIGNED msg text Allow Null Index Fields Extra aid aid, ischeck, mid dede_flink Field Type Extra P id smallint(5) UNSIGNED Auto Increment sortrank smallint(6) url char(60) webname char(30) msg char(200) email char(50) logo char(60) dtime int(10) UNSIGNED typeid smallint(5) UNSIGNED ischeck smallint(6) dede_flinktype Field Type Extra P id mediumint(8) UNSIGNED Auto Increment typename varchar(50) 8 dede_freelist Field Type Extra P aid int(11) Auto Increment title varchar(50) namerule varchar(50) listdir varchar(60) defaultpage varchar(20) nodefault smallint(6) templet varchar(50) edtime int(11) maxpage smallint(5) UNSIGNED click int(11) listtag mediumtext Allow Null keywords varchar(100) description varchar(250) dede_homepageset Field Type Extra templet char(50) position char(30) showmod tinyint(2) dede_keywords Field Type Extra P aid mediumint(8) UNSIGNED Auto Increment keyword char(16) rank mediumint(8) UNSIGNED sta smallint(6) rpurl char(60) Index Fields Extra keyword keyword, rank, sta dede_log Field Type Extra P lid mediumint(8) UNSIGNED Auto Increment adminid smallint(8) UNSIGNED filename char(60) method char(10) query char(200) cip char(15) dtime int(10) UNSIGNED 9 dede_member Field Type Extra P mid mediumint(8) UNSIGNED Auto Increment mtype varchar(20) userid char(20) pwd char(32) uname char(36) sex enum('男','女','保密') rank smallint(5) UNSIGNED uptime int(11) exptime smallint(6) money mediumint(8) UNSIGNED email char(50) scores mediumint(8) UNSIGNED matt smallint(5) UNSIGNED spacesta smallint(6) face char(50) safequestion smallint(5) UNSIGNED safeanswer char(30) jointime int(10) UNSIGNED joinip char(16) logintime int(10) UNSIGNED loginip char(16) checkmail smallint(6) Index Fields Extra userid userid, sex logintime log