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; ```