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;