企业网站管理系统数据库设计

文章表

create table `cb_article`(
`id` MEDIUMINT(8) UNSIGNED  AUTO_INCREMENT,
`type` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`title` VARCHAR(255) NOT NULL,
`content` TEXT,
`create_time` INT(10) UNSIGNED NOT NULL,
`hits` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;

管理员表

CREATE TABLE `cb_admin` (
  `aid` tinyint(2) unsigned NOT NULL AUTO_INCREMENT,
  `admin_name` varchar(30) NOT NULL,
  `admin_password` char(32) NOT NULL,
  `login_time` int(11) NOT NULL,
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

用户留言表

CREATE TABLE `cb_guestbook` (
  `gid` mediumint(8) unsigned NOT NULL A