singcms数据表设计
1、后台管理员用户表
CREATE TABLE `cms_admin` (
`admin_id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`lastloginip` varchar(15) DEFAULT '0',
`lastlogintime` int(10) unsigned DEFAULT '0',
`email` varchar(40) DEFAULT '',
`realname` varchar(50) NOT NULL DEFAULT '',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`admin_id`),
KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
2、菜单表
CREATE TABLE `cms_menu` (
`menu_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(40) NOT NULL DEFAULT '',
`parentid` smallint(6) NOT NULL DEFAULT '0',
`m` varchar(20) NOT NULL DEFAULT '',
`c` varchar(20) NOT NULL DEFAULT '',
`f` varchar(20) NOT NULL DEFAULT '',
`data` varchar(100) NOT NULL DEFAULT '',
`listorder` smallint(6) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`menu_id`),
KEY `listorder` (`listorder`),
KEY `parentid` (`parentid`),
KEY `module` (`m`,`c`,`f`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
3、文章表
CREATE TABLE `cms_news` (
`news_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`catid` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(80) NOT NULL DEFAULT '',
`small_title` varchar(30) NOT NULL DEFAULT '',
`title_font_color` varchar(250) DEFAULT NULL COMMENT '标题颜色',
`thumb` varchar(100) NOT NULL DEFAULT '',
`keywords` char(40) NOT NULL DEFAULT '',
`description` varchar(250) NOT NULL COMMENT '文章描述',
`posids` varchar(250) NOT NULL DEFAULT '',
`listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`copyfrom` varchar(250) DEFAULT NULL COMMENT '来源',
`username` char(20) NOT NULL,
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
`update_time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`news_id`),
KEY `status` (`status`,`listorder`,`news_id`),
KEY `listorder` (`catid`,`status`,`listorder`,`news_id`),
KEY `catid` (`catid`,`status`,`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
4、文章内容表
CREATE TABLE `cms_news_content` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`news_id` mediumint(8) unsigned NOT NULL,
`content` mediumtext NOT NULL,
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
`update_time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
5、推荐位表:
CREATE TABLE `cms_position` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` char(30) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '1',
`description` char(100) DEFAULT NULL,
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
`update_time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
6、推荐位内容表
CREATE TABLE `cms_position_content` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`position_id` int(5) unsigned NOT NULL,
`title` varchar(30) NOT NULL DEFAULT '',
`thumb` varchar(100) NOT NULL DEFAULT '',
`url` varchar(100) DEFAULT NULL,
`news_id` mediumint(8) unsigned NOT NULL,
`listorder` tinyint(3) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`create_time` int(10) unsigned NOT NULL DEFAULT '0',
`update_time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `position_id` (`position_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;