CREATE TABLE `ugm_contact` ( `sn` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'sn', `name` varchar(255) NOT NULL COMMENT '姓名', `tel` varchar(255) NOT NULL COMMENT '電話', `email` varchar(255) NOT NULL COMMENT '電子信箱', `contact` text NOT NULL COMMENT '聯絡內容', `date` int(10) unsigned NOT NULL COMMENT '聯絡日期', `ip` varchar(255) NOT NULL COMMENT 'ip', PRIMARY KEY (`sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ```