7-2-6 ugm_prod

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;