上課範例：tad0616.sql

:::

[1011]XOOPS 2.5 模組開發

3-1 上課範例：tad0616.sql

01CREATE TABLE `tad_notes` (
02  `note_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
03  `cate_sn` smallint(5) unsigned NOT NULL,
04  `note_title` varchar(255) NOT NULL,
05  `note_content` mediumtext NOT NULL,
06  `note_date` datetime NOT NULL,
07  `note_public` enum('1','0') NOT NULL,
08  `note_count` smallint(5) unsigned NOT NULL,
09  `uid` smallint(5) unsigned NOT NULL,
10  `note_sort` smallint(5) unsigned NOT NULL,
11  PRIMARY KEY (`note_sn`)
12) ENGINE=MyISAM ;
13 
14CREATE TABLE `tad_note_cate` (
15  `cate_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
16  `cate_title` varchar(255) NOT NULL,
17  `cate_sort` smallint(5) unsigned NOT NULL,
18  `cate_enable` enum('1','0') NOT NULL,
19  `cate_count` smallint(5) unsigned NOT NULL,
20  PRIMARY KEY (`cate_sn`)
21) ENGINE=MyISAM ;