7-6 eznews.sql

CREATE TABLE `eznews` (
  `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cate_sn` smallint(5) unsigned NOT NULL,
  `news_title` varchar(255) NOT NULL,
  `news_content` longtext NOT NULL,
  `ip` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `post_time` datetime NOT NULL,
  `status` varchar(255) NOT NULL,
  `counter` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `eznews_cate` (
  `cate_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cate_title` varchar(255) NOT NULL,
  PRIMARY KEY (`cate_sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;