[1002] PHP入門班
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;