Mikel
[转载]dede二次开发文章类所关联的数据表 | www.ycyintao.com 官方博客.
我们在使用dedecms系统时,每添加一篇文章,系统要往三个表中插入数据,这三个表的结构如下索引表:arctiny(后台PHP插入数据时这是第一个表)CREATE TABLE `arctiny` ( `id` mediumint(8) unsig…
我们在使用dedecms系统时,每添加一篇文章,系统要往三个表中插入数据,这三个表的结构如下
索引表:arctiny(后台PHP插入数据时这是第一个表)
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=gb2312;
主表:archives(这个表存放了类别编号,关键词,标题,短标题,简介等信息)
CREATE TABLE `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(120) NOT NULL default ”,
`shorttitle` char(120) 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(100) 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`)
) TYPE=MyISAM;
附加表:addonarticle(这个表只用于对文章详细内容显示的数据)
CREATE TABLE `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`)
) TYPE=MyISAM DEFAULT CHARSET=gbk;
