XOOPS 模組開發
CREATE TABLE `tad_honor` (
`honor_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '流水號',
`honor_year` tinyint(3) unsigned NOT NULL COMMENT '學年度',
`honor_date` date NOT NULL COMMENT '日期',
`honor_students` varchar(255) NOT NULL COMMENT '得獎者',
`honor_descript` text NOT NULL COMMENT '得獎事項',
`honor_teachers` varchar(255) NOT NULL COMMENT '指導老師',
`honor_note` text NOT NULL COMMENT '備註',
`uid` mediumint(8) unsigned NOT NULL COMMENT '發布者',
PRIMARY KEY (`honor_sn`)
) ENGINE=MyISAM;