2-1 sql/mysql.sql

CREATE TABLE `tad_ebook` (
  `ebook_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '刊物流水號',
  `ebook_title` varchar(255) NOT NULL COMMENT '刊物主題',
  `ebook_post_date` date NOT NULL COMMENT '投稿截止日',
  `ebook_publish_date` date NOT NULL COMMENT '發布日',
  PRIMARY KEY (`ebook_sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `tad_ebook_page` (
  `page_sn` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章編號',
  `ebook_sn` smallint(6) unsigned NOT NULL COMMENT '刊物編號',
  `page_title` varchar(255) NOT NULL COMMENT '文章標題',
  `page_content` text NOT NULL COMMENT '文章內容',
  `page_author` varchar(255) NOT NULL COMMENT '作者',
  `uid` mediumint(8) unsigned NOT NULL COMMENT '使用者編號',
  `page_sort` smallint(5) unsigned NOT NULL COMMENT '文章順序',
  `page_status` enum('0','1') NOT NULL COMMENT '文章狀態',
  `page_post_time` datetime NOT NULL COMMENT '文章日期',
  `page_counter` mediumint(8) unsigned NOT NULL COMMENT '文章計數器',
  `page_tag` varchar(255) NOT NULL COMMENT '文章標籤',
  PRIMARY KEY (`page_sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;