18-3 sql/mysql.sql

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;