Title1

Title2

Title3

7-2-5 ugm_kind


CREATE TABLE `ugm_kind` (
  `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'sn',
  `ofsn` smallint(5) unsigned NOT NULL COMMENT '父類別',
  `kind` varchar(255) NOT NULL DEFAULT 'nav_home' COMMENT '分類',
  `title` varchar(255) NOT NULL COMMENT '標題',
  `sort` smallint(5) unsigned NOT NULL COMMENT '排序',
  `enable` enum('1','0') NOT NULL DEFAULT '1' COMMENT '狀態',
  `url` varchar(255) NOT NULL COMMENT '網址',
  `target` enum('1','0') NOT NULL DEFAULT '0' COMMENT '外連',
  `col_sn` int(10) unsigned NOT NULL COMMENT 'col_sn',
  `content` text NOT NULL COMMENT '內容',
  PRIMARY KEY (`sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;