:::

7-11 /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;

 


:::

搜尋

QR Code 區塊

https%3A%2F%2Ftad0616.net%2Fmodules%2Ftad_book3%2Fpage.php%3Ftbdsn%3D1167%26tbsn%3D37

書籍目錄

展開 | 闔起

線上使用者

68人線上 (26人在瀏覽線上書籍)

會員: 0

訪客: 68

更多…