:::
3. 模組管理後台結構
3-1 上課範例：tad0616.sql
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 ;
