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;