text: news数据表设计
  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;
  
  
  
  