1041 XOOPS模組開發
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;