CREATE TABLE `ugm_prod` ( `sn` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'prod_sn', `kind` smallint(5) unsigned NOT NULL COMMENT '分類', `title` varchar(255) NOT NULL COMMENT '名稱', `summary` text NOT NULL COMMENT '摘要', `content` text NOT NULL COMMENT '內容', `price` int(10) unsigned NOT NULL COMMENT '價格', `enable` enum('1','0') NOT NULL DEFAULT '1' COMMENT '狀態', `date` int(10) unsigned NOT NULL COMMENT '建立日期', `sort` smallint(5) unsigned NOT NULL COMMENT '排序', `counter` int(10) unsigned NOT NULL COMMENT '人氣', PRIMARY KEY (`sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ```