CREATE TABLE `tad_notes` ( `note_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cate_sn` smallint(5) unsigned NOT NULL, `note_title` varchar(255) NOT NULL, `note_content` mediumtext NOT NULL, `note_date` datetime NOT NULL, `note_public` enum('1','0') NOT NULL, `note_count` smallint(5) unsigned NOT NULL, `uid` smallint(5) unsigned NOT NULL, `note_sort` smallint(5) unsigned NOT NULL, PRIMARY KEY (`note_sn`) ) ENGINE=MyISAM ; CREATE TABLE `tad_note_cate` ( `cate_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cate_title` varchar(255) NOT NULL, `cate_sort` smallint(5) unsigned NOT NULL, `cate_enable` enum('1','0') NOT NULL, `cate_count` smallint(5) unsigned NOT NULL, PRIMARY KEY (`cate_sn`) ) ENGINE=MyISAM ; ```
進階搜尋
50人線上 (15人在瀏覽線上書籍)
會員: 0
訪客: 50