11-3 上課範例：tad0616.sql

CREATE TABLE `tncomu_article` (
  `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `stud_name` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `post_time` datetime NOT NULL,
  `enable` enum('0','1') NOT NULL,
  `class_sn` smallint(5) unsigned NOT NULL,
  `mode` enum('文字','圖片') NOT NULL,
  `text_passwd` varchar(255) NOT NULL,
  `counter` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE `tncomu_class` (
  `class_sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '班級編號（流水號）',
  `seme` varchar(255) NOT NULL COMMENT '學期學年',
  `subject` varchar(255) NOT NULL COMMENT '所屬學程',
  `class_name` varchar(255) NOT NULL COMMENT '班級名稱',
  `teacher` varchar(255) NOT NULL COMMENT '老師名稱',
  `passwd` varchar(255) NOT NULL COMMENT '密碼',
  `access` enum('0','1') DEFAULT NULL COMMENT '是否開放填寫',
  PRIMARY KEY (`class_sn`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;