線上書籍

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;