線上書籍

Home

[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;