CREATE TABLE `snews` ( `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號', `focus` tinyint(2) unsigned NOT NULL COMMENT '精選', `topic_sn` tinyint(2) unsigned NOT NULL COMMENT '類別編號', `sort` tinyint(5) unsigned NOT NULL COMMENT '排序', `title` varchar(300) NOT NULL, `content` text NOT NULL, `username` varchar(65) NOT NULL, `create_time` datetime NOT NULL, `update_time` datetime NOT NULL, `uid` mediumint(8) unsigned NOT NULL COMMENT '使用者編號', PRIMARY KEY (`sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `snews_topic` ( `topic_sn` mediumint(9) NOT NULL AUTO_INCREMENT COMMENT '類別編號', `topic_title` varchar(255) NOT NULL COMMENT '類別或主題名稱', `topic_type` varchar(10) NOT NULL COMMENT '種類', `topic_description` text NOT NULL COMMENT '說明', `topic_status` enum('投稿中','當期','有效','已關閉') NOT NULL COMMENT '主題狀態', `username` varchar(65) NOT NULL COMMENT '建立者', `uid` mediumint(8) unsigned NOT NULL COMMENT '使用者編號', PRIMARY KEY (`topic_sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ```
進階搜尋
559人線上 (204人在瀏覽線上書籍)
會員: 0
訪客: 559