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_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_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_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_diyform1`;
CREATE TABLE `dede_diyform1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ifcheck` tinyint(1) NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
`keshi` enum('女性不孕','妇科整形','月经疾病','子宫疾病','宫颈疾病','乳腺疾病','外阴疾病','其他妇科疾病') DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
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_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_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_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_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_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_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_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` (`pkey`) USING BTREE
) 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_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_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;
相关推荐
标题与描述均提到了“dede织梦数据库字段详解”，这主要涉及到的是织梦CMS（Content Management System）系统中的数据库结构与字段解释。织梦CMS是一款基于PHP和MySQL技术构建的内容管理系统，广泛应用于网站建设和...
织梦内容管理系统（DedeCMS）是一款广泛使用的开源CMS，其数据库设计涵盖了多个核心功能模块，包括文章管理、图片管理、信息分类、产品展示、问答系统等。通过对这些数据库表的分析，我们可以深入理解织梦系统的数据...
本文将深入解析织梦数据库中的一些关键表及其字段信息，这对于数据库开发人员和进行织梦二次开发的程序员来说是非常重要的参考资料。 1. **dede_addonarticle** 表：这是一个附加文章表，主要用于存储一些特殊类型...
响应式新媒体运营资讯类网站前端模板下载，含有dedecms织梦系统安装的方法步骤，以及织梦数据库还原的教程。可以进行2次开发。 响应式新媒体运营资讯类网站前端模板下载，含有dedecms织梦系统安装的方法步骤，以及...
3. **映射字段**：将Excel中的列与织梦数据库中的字段对应起来，确保数据能正确插入到正确的数据库表和字段。 4. **连接数据库**：使用PHP的PDO或mysqli扩展建立与织梦数据库的连接。 5. **构建SQL语句**：根据...
NULL 博文链接：https://onestopweb.iteye.com/blog/2325863
### 织梦CMS数据库表和字段说明手册 #### 一、引言 织梦CMS（Content Management System）是一款广泛应用于网站建设的内容管理系统。它通过一系列预设的模板样式和功能插件，帮助用户快速搭建和管理网站。对于深入...
然后，根据工具提供的说明进行操作，通常是运行文件并输入相关数据库信息，如数据库名、用户名、密码以及表前缀等，以连接到你的织梦数据库。 在成功连接数据库后，工具会引导你进行管理员账号的选择或输入，接着...
一旦导入成功，用户可以通过设置采集任务，定期或手动执行数据抓取，填充到织梦数据库中。 ##### 2. 站长新闻模块采集示例 给定的描述中提到“A5网站长新闻模块”，这可能是指从A5创业网等站长资讯网站自动抓取新闻...
5. **保存策略**：采集到的内容需要按照一定的规则保存到织梦数据库中。你可以指定新建文章、更新已有文章或者按照某些条件归档。 6. **定时任务**：为了自动化采集过程，可以设置定时任务（Cron Job）来定期运行...
1. **数据库操作**：由于织梦系统的用户信息存储在数据库中，所以最直接的方法是直接操作数据库。打开phpMyAdmin或其它数据库管理工具，找到织梦安装时创建的数据库，定位到`dede_admin`表。在这个表中，找到对应的...
6. `mycity`和`dede`：这两个可能是目录名，其中`mycity`可能包含了与城市分站相关的文件或数据库结构，而`dede`通常是织梦CMS默认的后台管理目录。 7. `include`：这是织梦系统中常用的目录，通常用来存放自定义的...
4. **执行SQL查询**：根据构建的SQL语句，织梦系统会向数据库发起查询，利用数据库的JOIN、WHERE等子句实现条件的联合。如果条件较多，可能需要用到AND、OR等逻辑运算符来组合不同条件。 5. **返回查询结果**：查询...
织梦CMS（DedeCMS）是一款广泛使用的开源内容管理系统，它允许用户方便地创建和管理网站内容。在织梦系统中，文章中的图片如果缺少`alt`属性，可能会影响搜索引擎对网站的理解和用户的浏览体验。本文将深入探讨如何...
图片信息（如名称、路径、栏目等）会被存储在数据库中，因此程序需要有效地与织梦的数据库进行交互，保证数据的准确性和完整性。 9. **性能优化**： 在处理大量图片上传时，程序应考虑性能优化，比如使用队列处理...
对于开发者来说，理解和修改织梦的多选功能不仅能提升其在织梦系统的操作熟练度，也能锻炼对前后端交互、数据库查询和用户交互设计的综合能力。 总之，织梦多选功能修改是一个涉及到前端交互、后端处理和数据库...
3. 使用数据库管理工具连接到织梦的数据库，执行SQL查询来定位并修改`pubdate`字段的值，将其设置为特定年份的时间。 4. 如果没有直接的后台编辑功能，可能需要通过织梦的API或自定义PHP脚本来批量修改多篇文章的...