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; ```
進階搜尋
64人線上 (11人在瀏覽線上書籍)
會員: 0
訪客: 64