8-2 /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 '發布日',
  `ebook_content` text 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;

CREATE TABLE `tad_ebook_files_center` (
  `files_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '檔案流水號',
  `col_name` varchar(255) NOT NULL default '' COMMENT '欄位名稱',
  `col_sn` smallint(5) unsigned NOT NULL default 0 COMMENT '欄位編號',
  `sort` smallint(5) unsigned NOT NULL default 0 COMMENT '排序',
  `kind` enum('img','file') NOT NULL default 'img' COMMENT '檔案種類',
  `file_name` varchar(255) NOT NULL default '' COMMENT '檔案名稱',
  `file_type` varchar(255) NOT NULL default '' COMMENT '檔案類型',
  `file_size` int(10) unsigned NOT NULL default 0 COMMENT '檔案大小',
  `description` text NOT NULL COMMENT '檔案說明',
  `counter` mediumint(8) unsigned NOT NULL default 0 COMMENT '下載人次',
  `original_filename` varchar(255) NOT NULL default '' COMMENT '檔案名稱',
  `hash_filename` varchar(255) NOT NULL default '' COMMENT '加密檔案名稱',
  `sub_dir` varchar(255) NOT NULL default '' COMMENT '檔案子路徑',
  PRIMARY KEY (`files_sn`)
) ENGINE=MyISAM;