9-1 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,
  `uid` smallint(5) unsigned 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;

CREATE TABLE `eznews_files` (
  `file_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `sn` smallint(5) unsigned NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_size` int(11) NOT NULL,
  `file_type` varchar(255) NOT NULL,
  `file_new_name` varchar(255) NOT NULL,
  PRIMARY KEY (`file_sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `eznews_users` (
  `uid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) NOT NULL,
  `passwd` varchar(255) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;