www.gusucode.com > 大气广告设计类企业公司网站织梦模板源码程序 > 大气广告设计类企业公司网站织梦模板/data/backupdata/tables_struct_58fc368816df44e6.txt
DROP TABLE IF EXISTS `dede_addcase`; CREATE TABLE `dede_addcase` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `redirecturl` varchar(255) NOT NULL default '', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `language` varchar(250) NOT NULL default '', `vocation` smallint(5) unsigned NOT NULL default '0', `website` varchar(250) NOT NULL default '', `body` mediumtext, PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_addonarticle`; CREATE TABLE `dede_addonarticle` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `body` mediumtext, `redirecturl` varchar(255) NOT NULL default '', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_addonarticle17`; CREATE TABLE `dede_addonarticle17` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `body` mediumtext, `redirecturl` varchar(255) NOT NULL default '', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `price` varchar(250) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_addonimages`; CREATE TABLE `dede_addonimages` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `pagestyle` smallint(6) NOT NULL default '1', `maxwidth` smallint(6) NOT NULL default '600', `imgurls` text, `row` smallint(6) NOT NULL default '0', `col` smallint(6) NOT NULL default '0', `isrm` smallint(6) NOT NULL default '0', `ddmaxwidth` smallint(6) NOT NULL default '200', `pagepicnum` smallint(6) NOT NULL default '12', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `redirecturl` varchar(255) NOT NULL default '', `body` mediumtext, PRIMARY KEY (`aid`), KEY `imagesMain` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_addoninfos`; CREATE TABLE `dede_addoninfos` ( `aid` int(11) NOT NULL default '0', `typeid` int(11) NOT NULL default '0', `channel` smallint(6) NOT NULL default '0', `arcrank` smallint(6) NOT NULL default '0', `mid` mediumint(8) unsigned NOT NULL default '0', `click` int(10) unsigned NOT NULL default '0', `title` varchar(60) NOT NULL default '', `litpic` varchar(60) NOT NULL default '', `userip` varchar(15) NOT NULL default ' ', `senddate` int(11) NOT NULL default '0', `flag` set('c','h','p','f','s','j','a','b') default NULL, `lastpost` int(10) unsigned NOT NULL default '0', `scores` mediumint(8) NOT NULL default '0', `goodpost` mediumint(8) unsigned NOT NULL default '0', `badpost` mediumint(8) unsigned NOT NULL default '0', `nativeplace` smallint(5) unsigned NOT NULL default '0', `infotype` char(20) NOT NULL default '0', `body` mediumtext, `endtime` int(11) NOT NULL default '0', `tel` varchar(50) NOT NULL default '', `email` varchar(50) NOT NULL default '', `address` varchar(100) NOT NULL default '', `linkman` varchar(50) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`,`nativeplace`,`infotype`), KEY `channel` (`channel`,`arcrank`,`mid`,`click`,`title`,`litpic`,`senddate`,`flag`,`endtime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_addonmovie`; CREATE TABLE `dede_addonmovie` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `body` mediumtext, `redirecturl` varchar(255) NOT NULL default '', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `authors` mediumtext, `areas` varchar(60) NOT NULL default '', `murls` mediumtext, PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_addonshop`; CREATE TABLE `dede_addonshop` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `body` mediumtext, `price` float NOT NULL default '0', `trueprice` float NOT NULL default '0', `brand` varchar(250) NOT NULL default '', `units` varchar(250) NOT NULL default '', `templet` varchar(30) NOT NULL, `userip` char(15) NOT NULL, `redirecturl` varchar(255) NOT NULL, `vocation` char(20) NOT NULL default '0', `infotype` char(20) NOT NULL default '0', `uptime` int(11) NOT NULL default '0', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_addonsoft`; CREATE TABLE `dede_addonsoft` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `filetype` varchar(10) NOT NULL default '', `language` varchar(10) NOT NULL default '', `softtype` varchar(10) NOT NULL default '', `accredit` varchar(10) NOT NULL default '', `os` varchar(30) NOT NULL default '', `softrank` mediumint(8) unsigned NOT NULL default '0', `officialUrl` varchar(30) NOT NULL default '', `officialDemo` varchar(50) NOT NULL default '', `softsize` varchar(10) NOT NULL default '', `softlinks` text, `introduce` text, `daccess` smallint(5) NOT NULL default '0', `needmoney` smallint(5) NOT NULL default '0', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `redirecturl` varchar(255) NOT NULL default '', PRIMARY KEY (`aid`), KEY `softMain` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_addonspec`; CREATE TABLE `dede_addonspec` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `note` text, `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `redirecturl` varchar(255) NOT NULL default '', PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_admin`; CREATE TABLE `dede_admin` ( `id` int(10) unsigned NOT NULL, `usertype` float unsigned default '0', `userid` char(30) NOT NULL default '', `pwd` char(32) NOT NULL default '', `uname` char(20) NOT NULL default '', `tname` char(30) NOT NULL default '', `email` char(30) NOT NULL default '', `typeid` text, `logintime` int(10) unsigned NOT NULL default '0', `loginip` varchar(20) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_admintype`; CREATE TABLE `dede_admintype` ( `rank` float NOT NULL default '1', `typename` varchar(30) NOT NULL default '', `system` smallint(6) NOT NULL default '0', `purviews` text, PRIMARY KEY (`rank`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_advancedsearch`; CREATE TABLE `dede_advancedsearch` ( `mid` int(11) NOT NULL, `maintable` varchar(256) NOT NULL default '', `mainfields` text, `addontable` varchar(256) default NULL, `addonfields` text, `forms` text, `template` varchar(256) NOT NULL default '', UNIQUE KEY `mid` (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_arcatt`; CREATE TABLE `dede_arcatt` ( `sortid` smallint(6) NOT NULL default '0', `att` char(10) NOT NULL default '', `attname` char(30) NOT NULL default '', PRIMARY KEY (`att`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_arccache`; CREATE TABLE `dede_arccache` ( `md5hash` char(32) NOT NULL default '', `uptime` int(11) NOT NULL default '0', `cachedata` mediumtext, PRIMARY KEY (`md5hash`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_archives`; CREATE TABLE `dede_archives` ( `id` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `typeid2` varchar(90) NOT NULL default '0', `sortrank` int(10) unsigned NOT NULL default '0', `flag` set('c','h','p','f','s','j','a','b') default NULL, `ismake` smallint(6) NOT NULL default '0', `channel` smallint(6) NOT NULL default '1', `arcrank` smallint(6) NOT NULL default '0', `click` mediumint(8) unsigned NOT NULL default '0', `money` smallint(6) NOT NULL default '0', `title` char(60) NOT NULL default '', `shorttitle` char(36) NOT NULL default '', `color` char(7) NOT NULL default '', `writer` char(20) NOT NULL default '', `source` char(30) NOT NULL default '', `litpic` char(100) NOT NULL default '', `pubdate` int(10) unsigned NOT NULL default '0', `senddate` int(10) unsigned NOT NULL default '0', `mid` mediumint(8) unsigned NOT NULL default '0', `keywords` char(30) NOT NULL default '', `lastpost` int(10) unsigned NOT NULL default '0', `scores` mediumint(8) NOT NULL default '0', `goodpost` mediumint(8) unsigned NOT NULL default '0', `badpost` mediumint(8) unsigned NOT NULL default '0', `voteid` mediumint(8) NOT NULL, `notpost` tinyint(1) unsigned NOT NULL default '0', `description` varchar(255) NOT NULL default '', `filename` varchar(40) NOT NULL default '', `dutyadmin` mediumint(8) unsigned NOT NULL default '0', `tackid` int(10) NOT NULL default '0', `mtype` mediumint(8) unsigned NOT NULL default '0', `weight` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `sortrank` (`sortrank`), KEY `mainindex` (`arcrank`,`typeid`,`channel`,`flag`,`mid`), KEY `lastpost` (`lastpost`,`scores`,`goodpost`,`badpost`,`notpost`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_arcmulti`; CREATE TABLE `dede_arcmulti` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `tagid` char(60) NOT NULL default '', `uptime` int(11) NOT NULL default '0', `innertext` varchar(255) NOT NULL default '', `pagesize` int(11) NOT NULL default '0', `arcids` text NOT NULL, `ordersql` varchar(255) default NULL, `addfieldsSql` varchar(255) default NULL, `addfieldsSqlJoin` varchar(255) default NULL, `attstr` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_arcrank`; CREATE TABLE `dede_arcrank` ( `id` smallint(5) unsigned NOT NULL auto_increment, `rank` smallint(6) NOT NULL default '0', `membername` char(20) NOT NULL default '', `adminrank` smallint(6) NOT NULL default '0', `money` smallint(8) unsigned NOT NULL default '500', `scores` mediumint(8) NOT NULL default '0', `purviews` mediumtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_arctiny`; CREATE TABLE `dede_arctiny` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `typeid` smallint(5) unsigned NOT NULL default '0', `typeid2` varchar(90) NOT NULL default '0', `arcrank` smallint(6) NOT NULL default '0', `channel` smallint(5) NOT NULL default '1', `senddate` int(10) unsigned NOT NULL default '0', `sortrank` int(10) unsigned NOT NULL default '0', `mid` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `sortrank` (`sortrank`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_arctype`; CREATE TABLE `dede_arctype` ( `id` smallint(5) unsigned NOT NULL auto_increment, `reid` smallint(5) unsigned NOT NULL default '0', `topid` smallint(5) unsigned NOT NULL default '0', `sortrank` smallint(5) unsigned NOT NULL default '50', `typename` char(30) NOT NULL default '', `typedir` char(60) NOT NULL default '', `isdefault` smallint(6) NOT NULL default '0', `defaultname` char(15) NOT NULL default 'index.html', `issend` smallint(6) NOT NULL default '0', `channeltype` smallint(6) default '1', `maxpage` smallint(6) NOT NULL default '-1', `ispart` smallint(6) NOT NULL default '0', `corank` smallint(6) NOT NULL default '0', `tempindex` char(50) NOT NULL default '', `templist` char(50) NOT NULL default '', `temparticle` char(50) NOT NULL default '', `namerule` char(50) NOT NULL default '', `namerule2` char(50) NOT NULL default '', `modname` char(20) NOT NULL default '', `description` char(150) NOT NULL default '', `keywords` varchar(60) NOT NULL default '', `seotitle` varchar(80) NOT NULL default '', `moresite` tinyint(1) unsigned NOT NULL default '0', `sitepath` char(60) NOT NULL default '', `siteurl` char(50) NOT NULL default '', `ishidden` smallint(6) NOT NULL default '0', `cross` tinyint(1) NOT NULL default '0', `crossid` text, `content` text, `smalltypes` text, PRIMARY KEY (`id`), KEY `reid` (`reid`,`isdefault`,`channeltype`,`ispart`,`corank`,`topid`,`ishidden`), KEY `sortrank` (`sortrank`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_area`; CREATE TABLE `dede_area` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `reid` int(10) unsigned NOT NULL default '0', `disorder` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_baoming`; CREATE TABLE `dede_baoming` ( `id` int(50) NOT NULL auto_increment, `name` varchar(20) NOT NULL, `sex` varchar(3) NOT NULL, `maileaddr` varchar(80) NOT NULL, `hometel` varchar(15) NOT NULL, `qq` varchar(15) NOT NULL, `email` varchar(50) NOT NULL, `time` int(15) NOT NULL, `luqu` int(1) NOT NULL default '0', `zhuanye` varchar(50) NOT NULL, `beizhu` text NOT NULL, `ip` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_channeltype`; CREATE TABLE `dede_channeltype` ( `id` smallint(6) NOT NULL default '0', `nid` varchar(20) NOT NULL default '', `typename` varchar(30) NOT NULL default '', `maintable` varchar(50) NOT NULL default 'dede_archives', `addtable` varchar(50) NOT NULL default '', `addcon` varchar(30) NOT NULL default '', `mancon` varchar(30) NOT NULL default '', `editcon` varchar(30) NOT NULL default '', `useraddcon` varchar(30) NOT NULL default '', `usermancon` varchar(30) NOT NULL default '', `usereditcon` varchar(30) NOT NULL default '', `fieldset` text, `listfields` text, `allfields` text, `issystem` smallint(6) NOT NULL default '0', `isshow` smallint(6) NOT NULL default '1', `issend` smallint(6) NOT NULL default '0', `arcsta` smallint(6) NOT NULL default '-1', `usertype` char(10) NOT NULL default '', `sendrank` smallint(6) NOT NULL default '10', `isdefault` smallint(6) NOT NULL default '0', `needdes` tinyint(1) NOT NULL default '1', `needpic` tinyint(1) NOT NULL default '1', `titlename` varchar(20) NOT NULL default '标题', `onlyone` smallint(6) NOT NULL default '0', `dfcid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `nid` (`nid`,`isshow`,`arcsta`,`sendrank`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_co_htmls`; CREATE TABLE `dede_co_htmls` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `nid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `title` varchar(60) NOT NULL default '', `litpic` varchar(100) NOT NULL default '', `url` varchar(100) NOT NULL default '', `dtime` int(10) unsigned NOT NULL default '0', `isdown` tinyint(1) unsigned NOT NULL default '0', `isexport` tinyint(1) NOT NULL default '0', `result` mediumtext, PRIMARY KEY (`aid`), KEY `nid` (`nid`), KEY `typeid` (`typeid`,`title`,`url`,`dtime`,`isdown`,`isexport`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_co_mediaurls`; CREATE TABLE `dede_co_mediaurls` ( `nid` mediumint(8) unsigned NOT NULL default '0', `hash` char(32) NOT NULL default '', `tofile` char(60) NOT NULL default '', KEY `hash` (`hash`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_co_note`; CREATE TABLE `dede_co_note` ( `nid` mediumint(8) unsigned NOT NULL auto_increment, `channelid` smallint(5) unsigned NOT NULL default '0', `notename` varchar(50) NOT NULL default '', `sourcelang` varchar(10) NOT NULL default 'gb2312', `uptime` int(10) unsigned NOT NULL default '0', `cotime` int(10) unsigned NOT NULL default '0', `pnum` smallint(5) unsigned NOT NULL default '0', `isok` tinyint(1) unsigned NOT NULL default '0', `usemore` tinyint(1) unsigned NOT NULL default '0', `listconfig` text, `itemconfig` text, PRIMARY KEY (`nid`), KEY `isok` (`isok`,`channelid`,`cotime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_co_onepage`; CREATE TABLE `dede_co_onepage` ( `id` int(11) NOT NULL auto_increment, `url` varchar(60) NOT NULL default '', `title` varchar(60) NOT NULL default '', `issource` smallint(6) NOT NULL default '1', `lang` varchar(10) NOT NULL default 'gb2312', `rule` text, PRIMARY KEY (`id`), KEY `url` (`url`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_co_urls`; CREATE TABLE `dede_co_urls` ( `id` int(10) unsigned NOT NULL auto_increment, `hash` varchar(32) NOT NULL default '', `nid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_code`; CREATE TABLE `dede_code` ( `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `body` mediumtext, `redirecturl` varchar(255) NOT NULL default '', `templet` varchar(30) NOT NULL default '', `userip` char(15) NOT NULL default '', `preview` varchar(250) NOT NULL default '', `download` varchar(250) NOT NULL default '', `comp` varchar(250) NOT NULL default '', `supplement` mediumtext, PRIMARY KEY (`aid`), KEY `typeid` (`typeid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_diyform1`; CREATE TABLE `dede_diyform1` ( `id` int(10) unsigned NOT NULL auto_increment, `ifcheck` tinyint(1) NOT NULL default '0', `liuyan_name` varchar(250) NOT NULL default '', `liuyan_dianhua` varchar(250) NOT NULL default '', `liuyan_youxiang` varchar(250) NOT NULL default '', `liuyan_wangzhi` varchar(250) NOT NULL default '', `liuyan_gongsi` varchar(250) NOT NULL default '', `liuyan_neirong` mediumtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_diyform2`; CREATE TABLE `dede_diyform2` ( `id` int(10) unsigned NOT NULL auto_increment, `ifcheck` tinyint(1) NOT NULL default '0', `name` varchar(250) NOT NULL default '', `email` varchar(250) NOT NULL default '', `subject` varchar(250) NOT NULL default '', `content` mediumtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_diyform_dp`; CREATE TABLE `dede_diyform_dp` ( `id` int(10) unsigned NOT NULL auto_increment, `ifcheck` tinyint(1) NOT NULL default '0', `krname` varchar(250) NOT NULL default '', `diqu` varchar(250) NOT NULL default '', `dianhua` varchar(250) NOT NULL default '', `pingjia` mediumtext, `jingdian` mediumtext, `ganxie` mediumtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_diyforms`; CREATE TABLE `dede_diyforms` ( `diyid` int(10) unsigned NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `posttemplate` varchar(50) NOT NULL, `viewtemplate` varchar(50) NOT NULL, `listtemplate` varchar(50) NOT NULL, `table` varchar(50) NOT NULL default '', `info` text, `public` tinyint(1) NOT NULL default '1', PRIMARY KEY (`diyid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_dl_log`; CREATE TABLE `dede_dl_log` ( `id` mediumint(10) unsigned NOT NULL auto_increment, `ip` char(16) NOT NULL, `lang` char(6) NOT NULL, `dtype` varchar(10) NOT NULL, `dltime` int(10) unsigned NOT NULL default '0', `referrer` varchar(255) NOT NULL default '', `user_agent` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `dltime` (`dltime`), KEY `dl_ip` (`ip`,`dltime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_downloads`; CREATE TABLE `dede_downloads` ( `hash` char(32) NOT NULL, `id` int(10) unsigned NOT NULL default '0', `downloads` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`hash`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_erradd`; CREATE TABLE `dede_erradd` ( `id` int(10) unsigned NOT NULL auto_increment, `aid` mediumint(8) unsigned NOT NULL, `mid` mediumint(8) unsigned default NULL, `title` char(60) NOT NULL default '', `type` smallint(6) NOT NULL default '0', `errtxt` mediumtext, `oktxt` mediumtext, `sendtime` int(10) unsigned NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_feedback`; CREATE TABLE `dede_feedback` ( `id` int(10) unsigned NOT NULL auto_increment, `aid` mediumint(8) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `username` char(20) NOT NULL default '', `arctitle` varchar(60) NOT NULL default '', `ip` char(15) NOT NULL default '', `ischeck` smallint(6) NOT NULL default '0', `dtime` int(10) unsigned NOT NULL default '0', `mid` mediumint(8) unsigned NOT NULL default '0', `bad` mediumint(8) unsigned NOT NULL default '0', `good` mediumint(8) unsigned NOT NULL default '0', `ftype` set('feedback','good','bad') NOT NULL default 'feedback', `face` smallint(5) unsigned NOT NULL default '0', `msg` text, PRIMARY KEY (`id`), KEY `aid` (`aid`,`ischeck`,`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_flink`; CREATE TABLE `dede_flink` ( `id` smallint(5) unsigned NOT NULL auto_increment, `sortrank` smallint(6) NOT NULL default '0', `url` char(60) NOT NULL default '', `webname` char(30) NOT NULL default '', `msg` char(200) NOT NULL default '', `email` char(50) NOT NULL default '', `logo` char(60) NOT NULL default '', `dtime` int(10) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `ischeck` smallint(6) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_flinktype`; CREATE TABLE `dede_flinktype` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `typename` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_freelist`; CREATE TABLE `dede_freelist` ( `aid` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL default '', `namerule` varchar(50) NOT NULL default '', `listdir` varchar(60) NOT NULL default '', `defaultpage` varchar(20) NOT NULL default '', `nodefault` smallint(6) NOT NULL default '0', `templet` varchar(50) NOT NULL default '', `edtime` int(11) NOT NULL default '0', `maxpage` smallint(5) unsigned NOT NULL default '100', `click` int(11) NOT NULL default '1', `listtag` mediumtext, `keywords` varchar(100) NOT NULL default '', `description` varchar(250) NOT NULL default '', PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_group_guestbook`; CREATE TABLE `dede_group_guestbook` ( `bid` int(11) unsigned NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `uname` char(15) NOT NULL default '', `userid` int(11) unsigned NOT NULL default '0', `gid` int(11) unsigned NOT NULL default '0', `stime` int(10) unsigned NOT NULL default '0', `message` text NOT NULL, `ip` varchar(15) NOT NULL default '', PRIMARY KEY (`bid`), KEY `userid` (`userid`,`gid`), KEY `sitme` (`stime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_group_notice`; CREATE TABLE `dede_group_notice` ( `id` smallint(6) unsigned NOT NULL auto_increment, `uname` char(15) NOT NULL default '', `userid` int(11) unsigned NOT NULL default '0', `title` varchar(80) NOT NULL default '', `notice` text NOT NULL, `stime` int(10) unsigned NOT NULL default '0', `gid` mediumint(8) unsigned NOT NULL default '0', `ip` varchar(15) NOT NULL default '', PRIMARY KEY (`id`), KEY `stime` (`stime`), KEY `userid` (`userid`), KEY `gid` (`gid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_group_posts`; CREATE TABLE `dede_group_posts` ( `pid` int(10) unsigned NOT NULL auto_increment, `gid` smallint(6) unsigned NOT NULL default '0', `tid` mediumint(8) unsigned NOT NULL default '0', `first` tinyint(1) NOT NULL default '0', `author` char(15) NOT NULL default '', `subject` varchar(80) NOT NULL default '', `dateline` int(10) unsigned NOT NULL default '0', `message` mediumtext NOT NULL, `useip` varchar(15) NOT NULL default '', `anonymous` tinyint(1) unsigned NOT NULL default '0', `status` tinyint(1) unsigned NOT NULL default '0', `authorid` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`pid`), KEY `gid` (`gid`,`tid`,`author`), KEY `dateline` (`dateline`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_group_smalltypes`; CREATE TABLE `dede_group_smalltypes` ( `id` smallint(6) unsigned NOT NULL auto_increment, `gid` int(10) unsigned NOT NULL default '0', `userid` int(11) unsigned NOT NULL default '0', `name` char(15) NOT NULL, `disorder` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `disorder` (`disorder`), KEY `userid` (`userid`,`gid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_group_threads`; CREATE TABLE `dede_group_threads` ( `tid` mediumint(8) unsigned NOT NULL auto_increment, `gid` smallint(6) unsigned NOT NULL default '0', `smalltype` smallint(6) unsigned NOT NULL default '0', `subject` char(80) NOT NULL default '', `displayorder` tinyint(1) unsigned NOT NULL default '0', `author` char(15) NOT NULL default '', `authorid` mediumint(8) unsigned NOT NULL default '0', `views` int(10) unsigned NOT NULL default '0', `dateline` int(10) unsigned NOT NULL default '0', `lastpost` int(10) unsigned NOT NULL default '0', `lastposter` char(15) NOT NULL default '', `replies` mediumint(8) unsigned NOT NULL default '0', `digest` tinyint(1) unsigned NOT NULL default '0', `closed` mediumint(8) NOT NULL default '0', PRIMARY KEY (`tid`), KEY `digest` (`digest`), KEY `authorid` (`authorid`,`dateline`), KEY `displayorder` (`gid`,`lastpost`,`displayorder`,`smalltype`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_group_user`; CREATE TABLE `dede_group_user` ( `id` int(11) unsigned NOT NULL auto_increment, `uid` int(11) unsigned NOT NULL default '0', `username` varchar(15) NOT NULL default '', `gid` int(11) unsigned NOT NULL default '0', `posts` int(10) unsigned NOT NULL default '0', `replies` int(10) unsigned NOT NULL default '0', `jointime` int(10) unsigned NOT NULL default '0', `isjoin` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `uid` (`uid`,`gid`), KEY `jointime` (`jointime`), KEY `posts` (`posts`), KEY `replies` (`replies`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_groups`; CREATE TABLE `dede_groups` ( `groupid` int(10) unsigned NOT NULL auto_increment, `groupname` varchar(75) NOT NULL default '', `des` text, `groupimg` varchar(200) NOT NULL default '0', `rootstoreid` int(10) unsigned NOT NULL default '0', `storeid` int(10) unsigned NOT NULL default '0', `smalltype` text, `uid` int(10) unsigned NOT NULL default '0', `creater` char(15) NOT NULL default '', `ismaster` text, `issystem` tinyint(1) unsigned NOT NULL default '0', `isindex` tinyint(1) unsigned NOT NULL default '0', `ishidden` tinyint(1) unsigned NOT NULL default '0', `hits` int(13) unsigned NOT NULL default '0', `threads` int(13) unsigned NOT NULL default '0', `members` int(13) unsigned NOT NULL default '0', `stime` int(10) unsigned NOT NULL default '0', `theme` char(20) NOT NULL default 'default', PRIMARY KEY (`groupid`), KEY `uid` (`uid`), KEY `stime` (`stime`), KEY `storeid` (`storeid`,`rootstoreid`), KEY `hits` (`hits`), KEY `threads` (`threads`,`members`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_guestbook`; CREATE TABLE `dede_guestbook` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `title` varchar(60) NOT NULL default '', `tid` mediumint(8) NOT NULL default '0', `mid` mediumint(8) unsigned default '0', `posttime` int(10) unsigned NOT NULL default '0', `uname` varchar(30) NOT NULL default '', `email` varchar(50) NOT NULL default '', `homepage` varchar(50) NOT NULL default '', `qq` varchar(15) NOT NULL default '', `face` varchar(10) NOT NULL default '', `ip` varchar(20) NOT NULL default '', `dtime` int(10) unsigned NOT NULL default '0', `ischeck` smallint(6) NOT NULL default '1', `msg` text, PRIMARY KEY (`id`), KEY `ischeck` (`ischeck`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_homepageset`; CREATE TABLE `dede_homepageset` ( `templet` char(50) NOT NULL default '', `position` char(30) NOT NULL default '', `showmod` tinyint(2) NOT NULL default '1' ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_keywords`; CREATE TABLE `dede_keywords` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `keyword` char(16) NOT NULL default '', `rank` mediumint(8) unsigned NOT NULL default '0', `sta` smallint(6) NOT NULL default '1', `rpurl` char(60) NOT NULL default '', PRIMARY KEY (`aid`), KEY `keyword` (`keyword`,`rank`,`sta`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_kwavc`; CREATE TABLE `dede_kwavc` ( `id` int(10) NOT NULL auto_increment, `siteurl` varchar(50) default NULL, `typeid` int(3) default NULL, `title` varchar(200) default NULL, `writer` varchar(200) default NULL, `source` varchar(200) default NULL, `content` varchar(200) default NULL, `page` varchar(200) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_kwavcdata`; CREATE TABLE `dede_kwavcdata` ( `id` int(10) NOT NULL auto_increment, `tid` int(10) default NULL, `url` varchar(200) default NULL, `finish` tinyint(1) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_kwcache`; CREATE TABLE `dede_kwcache` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `nid` smallint(5) unsigned NOT NULL, `url` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_kwhash`; CREATE TABLE `dede_kwhash` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `hash` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_kwkeyword`; CREATE TABLE `dede_kwkeyword` ( `nid` mediumint(8) unsigned NOT NULL auto_increment, `typeid` smallint(5) unsigned NOT NULL, `keyword` text, `type` tinyint(1) unsigned NOT NULL default '0', `isclose` tinyint(1) unsigned NOT NULL default '0', `pn` smallint(5) unsigned NOT NULL default '0', `update` int(15) unsigned NOT NULL default '0', PRIMARY KEY (`nid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_kwpic`; CREATE TABLE `dede_kwpic` ( `id` int(11) NOT NULL auto_increment, `aid` int(11) default NULL, `image` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_log`; CREATE TABLE `dede_log` ( `lid` mediumint(8) unsigned NOT NULL auto_increment, `adminid` smallint(8) unsigned NOT NULL default '0', `filename` char(60) NOT NULL default '', `method` char(10) NOT NULL default '', `query` char(200) NOT NULL default '', `cip` char(15) NOT NULL default '', `dtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`lid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_mail_order`; CREATE TABLE `dede_mail_order` ( `mid` mediumint(8) NOT NULL, `typeid` smallint(5) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_mail_title`; CREATE TABLE `dede_mail_title` ( `id` mediumint(8) NOT NULL auto_increment, `period` int(10) NOT NULL, `typeid` smallint(5) NOT NULL, `title` char(200) character set gbk NOT NULL, `content` mediumtext character set gbk NOT NULL, `addtime` int(10) NOT NULL, `sendtime` int(10) NOT NULL, `writer` char(20) character set gbk NOT NULL, `mid` mediumint(8) NOT NULL, `state` tinyint(1) NOT NULL default '0', `count` smallint(6) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_mail_type`; CREATE TABLE `dede_mail_type` ( `id` smallint(5) NOT NULL auto_increment, `typename` char(60) character set gbk NOT NULL, `description` varchar(100) character set gbk default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_member`; CREATE TABLE `dede_member` ( `mid` mediumint(8) unsigned NOT NULL auto_increment, `mtype` varchar(20) NOT NULL default '个人', `userid` char(20) NOT NULL default '', `pwd` char(32) NOT NULL default '', `uname` char(36) NOT NULL default '', `sex` enum('男','女','保密') NOT NULL default '保密', `rank` smallint(5) unsigned NOT NULL default '0', `uptime` int(11) NOT NULL default '0', `exptime` smallint(6) NOT NULL default '0', `money` mediumint(8) unsigned NOT NULL default '0', `email` char(50) NOT NULL default '', `scores` mediumint(8) unsigned NOT NULL default '0', `matt` smallint(5) unsigned NOT NULL default '0', `spacesta` smallint(6) NOT NULL default '0', `face` char(50) NOT NULL default '', `safequestion` smallint(5) unsigned NOT NULL default '0', `safeanswer` char(30) NOT NULL default '', `jointime` int(10) unsigned NOT NULL default '0', `joinip` char(16) NOT NULL default '', `logintime` int(10) unsigned NOT NULL default '0', `loginip` char(16) NOT NULL default '', `checkmail` smallint(6) NOT NULL default '-1', PRIMARY KEY (`mid`), KEY `userid` (`userid`,`sex`), KEY `logintime` (`logintime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_company`; CREATE TABLE `dede_member_company` ( `mid` mediumint(8) NOT NULL auto_increment, `company` varchar(36) NOT NULL default '', `product` varchar(50) NOT NULL default '', `place` smallint(5) unsigned NOT NULL default '0', `vocation` smallint(5) unsigned NOT NULL default '0', `cosize` smallint(5) unsigned NOT NULL default '0', `tel` varchar(30) NOT NULL default '', `fax` varchar(30) NOT NULL default '', `linkman` varchar(20) NOT NULL default '', `address` varchar(50) NOT NULL default '', `mobile` varchar(30) NOT NULL default '', `email` varchar(50) NOT NULL default '', `url` varchar(50) NOT NULL default '', `uptime` int(10) unsigned NOT NULL default '0', `checked` tinyint(1) unsigned NOT NULL default '0', `introduce` text, `comface` varchar(255) NOT NULL default '', PRIMARY KEY (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_feed`; CREATE TABLE `dede_member_feed` ( `fid` mediumint(8) unsigned NOT NULL auto_increment, `mid` smallint(8) unsigned NOT NULL default '0', `userid` char(20) NOT NULL default '', `uname` char(36) NOT NULL default '', `type` char(20) character set gb2312 NOT NULL default '0', `aid` mediumint(8) NOT NULL default '0', `dtime` int(10) unsigned NOT NULL default '0', `title` char(253) NOT NULL, `note` char(200) NOT NULL default '', `ischeck` smallint(6) NOT NULL, PRIMARY KEY (`fid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_flink`; CREATE TABLE `dede_member_flink` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `mid` mediumint(8) unsigned NOT NULL default '0', `title` varchar(30) NOT NULL default '', `url` varchar(100) NOT NULL default '', PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_friends`; CREATE TABLE `dede_member_friends` ( `id` int(10) unsigned NOT NULL auto_increment, `fid` mediumint(8) unsigned NOT NULL default '0', `floginid` char(20) NOT NULL default '', `funame` char(36) NOT NULL default '', `mid` mediumint(8) NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', `ftype` tinyint(4) NOT NULL default '0', `groupid` int(8) NOT NULL default '1', `description` varchar(200) default NULL, PRIMARY KEY (`id`), KEY `fid` (`fid`,`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_group`; CREATE TABLE `dede_member_group` ( `id` int(10) NOT NULL auto_increment, `groupname` varchar(50) NOT NULL, `mid` int(8) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_guestbook`; CREATE TABLE `dede_member_guestbook` ( `aid` int(10) unsigned NOT NULL auto_increment, `mid` mediumint(8) unsigned NOT NULL default '0', `gid` varchar(20) NOT NULL default '0', `title` varchar(60) NOT NULL default '', `uname` varchar(50) NOT NULL default '', `email` varchar(50) NOT NULL default '', `qq` varchar(50) NOT NULL default '', `tel` varchar(50) NOT NULL default '', `ip` varchar(20) NOT NULL default '', `dtime` int(10) unsigned NOT NULL default '0', `msg` text, PRIMARY KEY (`aid`), KEY `mid` (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_model`; CREATE TABLE `dede_member_model` ( `id` int(10) NOT NULL auto_increment, `name` varchar(20) NOT NULL, `table` varchar(30) NOT NULL, `description` varchar(50) NOT NULL, `state` int(2) NOT NULL default '0', `issystem` int(2) NOT NULL default '0', `info` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_msg`; CREATE TABLE `dede_member_msg` ( `id` int(10) unsigned NOT NULL auto_increment, `mid` mediumint(8) unsigned NOT NULL default '0', `userid` char(20) NOT NULL default '', `ip` char(15) NOT NULL default '', `ischeck` smallint(6) NOT NULL default '0', `dtime` int(10) unsigned NOT NULL default '0', `msg` text, PRIMARY KEY (`id`), KEY `id` (`ischeck`,`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_operation`; CREATE TABLE `dede_member_operation` ( `aid` int(11) NOT NULL auto_increment, `buyid` varchar(80) NOT NULL default '', `pname` varchar(50) NOT NULL default '', `product` varchar(10) NOT NULL default '', `money` int(11) NOT NULL default '0', `mtime` int(11) NOT NULL default '0', `pid` int(11) NOT NULL default '0', `mid` int(11) NOT NULL default '0', `sta` int(11) NOT NULL default '0', `oldinfo` varchar(200) NOT NULL default '', PRIMARY KEY (`aid`), KEY `buyid` (`buyid`), KEY `pid` (`pid`,`mid`,`sta`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_person`; CREATE TABLE `dede_member_person` ( `mid` mediumint(8) unsigned NOT NULL default '0', `onlynet` tinyint(1) unsigned NOT NULL default '1', `sex` enum('男','女','保密') NOT NULL default '男', `uname` char(30) NOT NULL default '', `qq` char(12) NOT NULL default '', `msn` char(50) NOT NULL default '', `tel` varchar(15) NOT NULL default '', `mobile` varchar(15) NOT NULL default '', `place` smallint(5) unsigned NOT NULL default '0', `oldplace` smallint(5) unsigned NOT NULL default '0', `birthday` date NOT NULL default '1980-01-01', `star` smallint(6) unsigned NOT NULL default '1', `income` smallint(6) NOT NULL default '0', `education` smallint(6) NOT NULL default '0', `height` smallint(5) unsigned NOT NULL default '160', `bodytype` smallint(6) NOT NULL default '0', `blood` smallint(6) NOT NULL default '0', `vocation` smallint(6) NOT NULL default '0', `smoke` smallint(6) NOT NULL default '0', `marital` smallint(6) NOT NULL default '0', `house` smallint(6) NOT NULL default '0', `drink` smallint(6) NOT NULL default '0', `datingtype` smallint(6) NOT NULL default '0', `language` set('普通话','上海话','广东话','英语','日语','韩语','法语','意大利语','德语','西班牙语','俄语','阿拉伯语') default NULL, `nature` set('性格外向','性格内向','活泼开朗','豪放不羁','患得患失','冲动','幽默','稳重','轻浮','沉默寡言','多愁善感','时喜时悲','附庸风雅','能说会道','坚强','脆弱','幼稚','成熟','快言快语','损人利己','狡猾善变','交际广泛','优柔寡断','自私','真诚','独立','依赖','难以琢磨','悲观消极','郁郁寡欢','胆小怕事','乐观向上','任性','自负','自卑','拜金','温柔体贴','小心翼翼','暴力倾向','逆来顺受','不拘小节','暴躁','倔强','豪爽','害羞','婆婆妈妈','敢做敢当','助人为乐','耿直','虚伪','孤僻','老实','守旧','敏感','迟钝','婆婆妈妈','武断','果断','刻薄') default NULL, `lovemsg` varchar(100) NOT NULL default '', `address` varchar(50) NOT NULL default '', `uptime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_pms`; CREATE TABLE `dede_member_pms` ( `id` int(10) unsigned NOT NULL auto_increment, `floginid` varchar(20) NOT NULL default '', `fromid` mediumint(8) unsigned NOT NULL default '0', `toid` mediumint(8) unsigned NOT NULL default '0', `tologinid` char(20) NOT NULL default '', `folder` enum('inbox','outbox') default 'inbox', `subject` varchar(60) NOT NULL default '', `sendtime` int(10) unsigned NOT NULL default '0', `writetime` int(10) unsigned NOT NULL default '0', `hasview` tinyint(1) unsigned NOT NULL default '0', `isadmin` tinyint(1) NOT NULL default '0', `message` text, PRIMARY KEY (`id`), KEY `sendtime` (`sendtime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_snsmsg`; CREATE TABLE `dede_member_snsmsg` ( `id` int(10) unsigned NOT NULL auto_increment, `mid` mediumint(8) unsigned NOT NULL default '0', `userid` varchar(20) NOT NULL, `sendtime` int(10) unsigned NOT NULL default '0', `msg` varchar(250) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_space`; CREATE TABLE `dede_member_space` ( `mid` mediumint(8) unsigned NOT NULL default '0', `pagesize` smallint(5) unsigned NOT NULL default '10', `matt` smallint(6) NOT NULL default '0', `spacename` varchar(50) NOT NULL default '', `spacelogo` varchar(50) NOT NULL default '', `spacestyle` varchar(20) NOT NULL default '', `sign` varchar(100) NOT NULL default '没签名', `spacenews` text, PRIMARY KEY (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_stow`; CREATE TABLE `dede_member_stow` ( `id` int(10) unsigned NOT NULL auto_increment, `mid` mediumint(8) unsigned NOT NULL default '0', `aid` mediumint(8) unsigned NOT NULL default '0', `title` char(60) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `type` varchar(10) default NULL, PRIMARY KEY (`id`), KEY `uid` (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_stowtype`; CREATE TABLE `dede_member_stowtype` ( `stowname` varchar(30) NOT NULL, `indexname` varchar(30) NOT NULL, `indexurl` varchar(50) NOT NULL, PRIMARY KEY (`stowname`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_tj`; CREATE TABLE `dede_member_tj` ( `mid` mediumint(8) NOT NULL auto_increment, `article` smallint(5) unsigned NOT NULL default '0', `album` smallint(5) unsigned NOT NULL default '0', `archives` smallint(5) unsigned NOT NULL default '0', `homecount` int(10) unsigned NOT NULL default '0', `pagecount` int(10) unsigned NOT NULL default '0', `feedback` mediumint(8) unsigned NOT NULL default '0', `friend` smallint(5) unsigned NOT NULL default '0', `stow` smallint(5) unsigned NOT NULL default '0', `soft` int(10) NOT NULL default '0', `info` int(10) NOT NULL default '0', `shop` int(10) NOT NULL default '0', PRIMARY KEY (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_type`; CREATE TABLE `dede_member_type` ( `aid` int(11) NOT NULL auto_increment, `rank` int(11) NOT NULL default '0', `pname` varchar(50) NOT NULL default '', `money` int(11) NOT NULL default '0', `exptime` int(11) NOT NULL default '30', PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_member_vhistory`; CREATE TABLE `dede_member_vhistory` ( `id` int(10) NOT NULL auto_increment, `mid` mediumint(8) unsigned NOT NULL default '0', `loginid` char(20) NOT NULL default '', `vid` mediumint(8) unsigned NOT NULL default '0', `vloginid` char(20) NOT NULL default '', `count` smallint(5) unsigned NOT NULL default '0', `vip` char(15) NOT NULL default '', `vtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `vtime` (`vtime`), KEY `mid` (`mid`,`vid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_moneycard_record`; CREATE TABLE `dede_moneycard_record` ( `aid` int(11) NOT NULL auto_increment, `ctid` int(11) NOT NULL default '0', `cardid` varchar(50) NOT NULL default '', `uid` int(11) NOT NULL default '0', `isexp` smallint(6) NOT NULL default '0', `mtime` int(11) NOT NULL default '0', `utime` int(11) NOT NULL default '0', `money` int(11) NOT NULL default '0', `num` int(11) NOT NULL default '0', PRIMARY KEY (`aid`), KEY `ctid` (`ctid`), KEY `cardid` (`cardid`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_moneycard_type`; CREATE TABLE `dede_moneycard_type` ( `tid` int(11) NOT NULL auto_increment, `num` int(11) NOT NULL default '500', `money` int(11) NOT NULL default '50', `pname` varchar(50) NOT NULL default '', PRIMARY KEY (`tid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_mtypes`; CREATE TABLE `dede_mtypes` ( `mtypeid` mediumint(8) unsigned NOT NULL auto_increment, `mtypename` char(40) NOT NULL, `channelid` smallint(6) NOT NULL default '1', `mid` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`mtypeid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_multiserv_config`; CREATE TABLE `dede_multiserv_config` ( `remoteuploads` smallint(6) NOT NULL default '0', `remoteupUrl` text NOT NULL, `rminfo` text, `servinfo` mediumtext, PRIMARY KEY (`remoteuploads`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_myad`; CREATE TABLE `dede_myad` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `clsid` smallint(5) NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `tagname` varchar(30) NOT NULL default '', `adname` varchar(60) NOT NULL default '', `timeset` smallint(6) NOT NULL default '0', `starttime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', `normbody` text, `expbody` text, PRIMARY KEY (`aid`), KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_myadtype`; CREATE TABLE `dede_myadtype` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `typename` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_mynews`; CREATE TABLE `dede_mynews` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `typeid` smallint(5) unsigned NOT NULL default '0', `title` varchar(60) NOT NULL default '', `writer` varchar(20) NOT NULL default '', `senddate` int(10) unsigned NOT NULL default '0', `body` text, PRIMARY KEY (`aid`), KEY `senddate` (`typeid`,`senddate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_mytag`; CREATE TABLE `dede_mytag` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `typeid` smallint(5) unsigned NOT NULL default '0', `tagname` varchar(30) NOT NULL default '', `timeset` smallint(6) NOT NULL default '0', `starttime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', `normbody` text, `expbody` text, PRIMARY KEY (`aid`), KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_nic_ratings`; CREATE TABLE `dede_nic_ratings` ( `id` varchar(11) NOT NULL default '', `total_votes` int(11) NOT NULL default '0', `total_value` int(11) NOT NULL default '0', `star_votes` int(10) NOT NULL default '0', `star_value` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `dede_nic_star_score`; CREATE TABLE `dede_nic_star_score` ( `id` int(11) NOT NULL auto_increment, `aid` int(11) NOT NULL default '0', `score` char(3) NOT NULL default '50', `ip` varchar(20) NOT NULL default '', PRIMARY KEY (`id`), KEY `aid` (`aid`), KEY `ip` (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `dede_payment`; CREATE TABLE `dede_payment` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `code` varchar(20) NOT NULL default '', `name` varchar(120) NOT NULL default '', `fee` varchar(10) NOT NULL default '0', `description` text NOT NULL, `rank` tinyint(3) unsigned NOT NULL default '0', `config` text NOT NULL, `enabled` tinyint(1) unsigned NOT NULL default '0', `cod` tinyint(1) unsigned NOT NULL default '0', `online` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_pinglog`; CREATE TABLE `dede_pinglog` ( `aid` int(11) NOT NULL auto_increment, `uptime` int(11) default NULL, `status` tinyint(1) default NULL, PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_plugins_config`; CREATE TABLE `dede_plugins_config` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `value` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_plus`; CREATE TABLE `dede_plus` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `plusname` varchar(30) NOT NULL default '', `menustring` varchar(200) NOT NULL default '', `mainurl` varchar(50) NOT NULL default '', `writer` varchar(30) NOT NULL default '', `isshow` smallint(6) NOT NULL default '1', `filelist` text, PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_plus_changyan_importids`; CREATE TABLE `dede_plus_changyan_importids` ( `id` int(10) NOT NULL auto_increment, `aid` int(10) default '0', `feedback_id` int(12) default '0', PRIMARY KEY (`id`), UNIQUE KEY `feedback_id` (`feedback_id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_plus_changyan_insertids`; CREATE TABLE `dede_plus_changyan_insertids` ( `id` int(10) NOT NULL auto_increment, `aid` int(10) default '0', `comment_id` int(12) default '0', PRIMARY KEY (`id`), UNIQUE KEY `comment_id` (`comment_id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_plus_changyan_setting`; CREATE TABLE `dede_plus_changyan_setting` ( `skey` varchar(255) NOT NULL default '', `svalue` text NOT NULL, `stime` int(10) NOT NULL, PRIMARY KEY (`skey`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_purview`; CREATE TABLE `dede_purview` ( `mid` mediumint(8) default '0', `typeid` smallint(5) default '0', `rank` smallint(6) default NULL, `pkey` varchar(30) character set latin1 NOT NULL, `pvalue` text NOT NULL, KEY `pkey` USING BTREE (`pkey`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_pwd_tmp`; CREATE TABLE `dede_pwd_tmp` ( `mid` mediumint(8) NOT NULL, `membername` char(16) NOT NULL default '', `pwd` char(32) NOT NULL default '', `mailtime` int(10) NOT NULL default '0', PRIMARY KEY (`mid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_ratings`; CREATE TABLE `dede_ratings` ( `id` varchar(11) NOT NULL, `total_votes` int(11) NOT NULL default '0', `total_value` int(11) NOT NULL default '0', `used_ips` longtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_scores`; CREATE TABLE `dede_scores` ( `id` int(11) unsigned NOT NULL auto_increment, `titles` char(15) NOT NULL, `icon` smallint(6) unsigned default '0', `integral` int(10) NOT NULL default '0', `isdefault` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `integral` (`integral`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_search_cache`; CREATE TABLE `dede_search_cache` ( `hash` char(32) NOT NULL, `lasttime` int(10) unsigned NOT NULL default '0', `rsnum` mediumint(8) unsigned NOT NULL default '0', `ids` mediumtext, PRIMARY KEY (`hash`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_search_keywords`; CREATE TABLE `dede_search_keywords` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `keyword` char(30) NOT NULL default '', `spwords` char(50) NOT NULL default '', `count` mediumint(8) unsigned NOT NULL default '1', `result` mediumint(8) unsigned NOT NULL default '0', `lasttime` int(10) unsigned NOT NULL default '0', `channelid` smallint(5) unsigned NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_sgpage`; CREATE TABLE `dede_sgpage` ( `aid` smallint(5) unsigned NOT NULL auto_increment, `title` varchar(60) NOT NULL default '', `ismake` smallint(6) NOT NULL default '1', `filename` varchar(60) NOT NULL default '', `keywords` varchar(30) NOT NULL default '', `template` varchar(30) NOT NULL default '', `likeid` varchar(20) NOT NULL default '', `description` varchar(250) NOT NULL default '', `uptime` int(10) unsigned NOT NULL default '0', `body` mediumtext, PRIMARY KEY (`aid`), KEY `ismake` (`ismake`,`uptime`), KEY `likeid` (`likeid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_shops_delivery`; CREATE TABLE `dede_shops_delivery` ( `pid` int(10) unsigned NOT NULL auto_increment, `dname` char(80) NOT NULL, `price` float(13,2) NOT NULL default '0.00', `des` char(255) default NULL, `orders` int(10) NOT NULL default '0', PRIMARY KEY (`pid`), KEY `orders` (`orders`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_shops_orders`; CREATE TABLE `dede_shops_orders` ( `oid` varchar(80) NOT NULL, `userid` int(10) NOT NULL, `pid` int(10) NOT NULL default '0', `paytype` tinyint(2) NOT NULL default '1', `cartcount` int(10) NOT NULL default '0', `dprice` float(13,2) NOT NULL default '0.00', `price` float(13,2) NOT NULL default '0.00', `priceCount` float(13,2) NOT NULL, `state` tinyint(1) NOT NULL default '0', `ip` char(15) NOT NULL default '', `stime` int(10) NOT NULL default '0', KEY `stime` (`stime`), KEY `userid` (`userid`), KEY `oid` (`oid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_shops_paytype`; CREATE TABLE `dede_shops_paytype` ( `pid` int(10) NOT NULL auto_increment, `paytype` varchar(20) NOT NULL, `des` text, PRIMARY KEY (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_shops_products`; CREATE TABLE `dede_shops_products` ( `aid` mediumint(8) NOT NULL default '0', `oid` varchar(80) NOT NULL default '', `userid` int(10) NOT NULL, `title` varchar(80) NOT NULL default '', `price` float(13,2) NOT NULL default '0.00', `buynum` int(10) NOT NULL default '9', KEY `oid` (`oid`), KEY `userid` (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_shops_userinfo`; CREATE TABLE `dede_shops_userinfo` ( `userid` int(10) NOT NULL, `oid` varchar(80) NOT NULL default '', `consignee` char(15) NOT NULL default '', `address` varchar(255) NOT NULL default '', `zip` int(10) NOT NULL default '0', `tel` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `des` varchar(255) NOT NULL default '', KEY `oid` (`oid`), KEY `userid` (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_softconfig`; CREATE TABLE `dede_softconfig` ( `downtype` smallint(6) NOT NULL default '0', `ismoresite` smallint(6) NOT NULL default '0', `gotojump` smallint(6) NOT NULL default '0', `islocal` smallint(5) unsigned NOT NULL default '1', `sites` text, `downmsg` text, `moresitedo` smallint(5) unsigned NOT NULL default '1', `dfrank` smallint(5) unsigned NOT NULL default '0', `dfywboy` smallint(5) unsigned NOT NULL default '0', `argrange` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`downtype`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_sphinx`; CREATE TABLE `dede_sphinx` ( `countid` int(11) unsigned NOT NULL, `maxaid` int(11) unsigned NOT NULL, PRIMARY KEY (`countid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_stepselect`; CREATE TABLE `dede_stepselect` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `itemname` char(30) default NULL, `egroup` char(20) default NULL, `issign` tinyint(1) unsigned default '0', `issystem` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_store_groups`; CREATE TABLE `dede_store_groups` ( `storeid` mediumint(8) unsigned NOT NULL auto_increment, `storename` char(20) NOT NULL default '', `tops` mediumint(8) unsigned NOT NULL default '0', `orders` smallint(6) unsigned NOT NULL default '0', `nums` int(13) unsigned NOT NULL default '0', PRIMARY KEY (`storeid`), KEY `orders` (`orders`,`tops`), KEY `nums` (`nums`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `dede_sys_enum`; CREATE TABLE `dede_sys_enum` ( `id` smallint(5) unsigned NOT NULL auto_increment, `ename` char(30) NOT NULL default '', `evalue` char(20) NOT NULL default '0', `egroup` char(20) NOT NULL default '', `disorder` smallint(5) unsigned NOT NULL default '0', `issign` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_sys_module`; CREATE TABLE `dede_sys_module` ( `id` int(11) NOT NULL auto_increment, `hashcode` char(32) NOT NULL default '', `modname` varchar(30) NOT NULL default '', `indexname` varchar(20) NOT NULL default '', `indexurl` varchar(30) NOT NULL default '', `ismember` tinyint(4) NOT NULL default '1', `menustring` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_sys_set`; CREATE TABLE `dede_sys_set` ( `id` smallint(5) unsigned NOT NULL auto_increment, `sname` char(20) NOT NULL default '', `items` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_sys_task`; CREATE TABLE `dede_sys_task` ( `id` int(10) unsigned NOT NULL auto_increment, `taskname` varchar(50) NOT NULL, `dourl` varchar(100) NOT NULL, `islock` tinyint(1) unsigned NOT NULL default '0', `runtype` tinyint(1) unsigned NOT NULL default '0', `runtime` varchar(10) default '0000', `starttime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', `freq` tinyint(2) unsigned NOT NULL default '0', `lastrun` int(10) unsigned NOT NULL default '0', `description` varchar(250) NOT NULL, `parameter` text, `settime` int(10) unsigned NOT NULL default '0', `sta` enum('运行','成功','失败') default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_sysconfig`; CREATE TABLE `dede_sysconfig` ( `aid` smallint(8) unsigned NOT NULL default '0', `varname` varchar(20) NOT NULL default '', `info` varchar(100) NOT NULL default '', `groupid` smallint(6) NOT NULL default '1', `type` varchar(10) NOT NULL default 'string', `value` text, PRIMARY KEY (`varname`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_tagindex`; CREATE TABLE `dede_tagindex` ( `id` int(10) unsigned NOT NULL auto_increment, `tag` char(12) NOT NULL default '', `typeid` smallint(5) unsigned NOT NULL default '0', `count` int(10) unsigned NOT NULL default '0', `total` int(10) unsigned NOT NULL default '0', `weekcc` int(10) unsigned NOT NULL default '0', `monthcc` int(10) unsigned NOT NULL default '0', `weekup` int(10) unsigned NOT NULL default '0', `monthup` int(10) unsigned NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_taglist`; CREATE TABLE `dede_taglist` ( `tid` int(10) unsigned NOT NULL default '0', `aid` int(10) unsigned NOT NULL default '0', `arcrank` smallint(6) NOT NULL default '0', `typeid` smallint(5) unsigned NOT NULL default '0', `tag` varchar(12) NOT NULL default '', PRIMARY KEY (`tid`,`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_uploads`; CREATE TABLE `dede_uploads` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `arcid` mediumint(8) unsigned NOT NULL default '0', `title` char(60) NOT NULL default '', `url` char(80) NOT NULL default '', `mediatype` smallint(6) NOT NULL default '1', `width` char(10) NOT NULL default '', `height` char(10) NOT NULL default '', `playtime` char(10) NOT NULL default '', `filesize` mediumint(8) unsigned NOT NULL default '0', `uptime` int(10) unsigned NOT NULL default '0', `mid` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`aid`), KEY `memberid` (`mid`), KEY `arcid` (`arcid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_verifies`; CREATE TABLE `dede_verifies` ( `nameid` char(32) NOT NULL default '', `cthash` varchar(32) NOT NULL default '', `method` enum('local','official') NOT NULL default 'official', `filename` varchar(254) NOT NULL default '', PRIMARY KEY (`nameid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_vote`; CREATE TABLE `dede_vote` ( `aid` mediumint(8) unsigned NOT NULL auto_increment, `votename` varchar(50) NOT NULL default '', `starttime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', `totalcount` mediumint(8) unsigned NOT NULL default '0', `ismore` tinyint(6) NOT NULL default '0', `isallow` tinyint(6) NOT NULL default '0', `view` tinyint(6) NOT NULL default '0', `spec` int(20) unsigned NOT NULL default '0', `isenable` tinyint(6) NOT NULL default '0', `votenote` text, PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_vote_member`; CREATE TABLE `dede_vote_member` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `voteid` int(10) unsigned NOT NULL default '0', `userid` varchar(50) NOT NULL default '', `uptime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; DROP TABLE IF EXISTS `dede_yuyue`; CREATE TABLE `dede_yuyue` ( `id` int(50) NOT NULL auto_increment, `name` varchar(20) NOT NULL, `sex` varchar(3) NOT NULL, `age` varchar(15) NOT NULL, `date` date NOT NULL, `time` varchar(10) NOT NULL, `address` varchar(80) NOT NULL, `hometel` varchar(15) NOT NULL, `email` varchar(50) NOT NULL, `ill` text NOT NULL, `state` int(1) NOT NULL default '0', `ip` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;