[1011]XOOPS 2.5 模組開發
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 ;