CREATE TABLE `ugm_system` ( `sn` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'sn', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '表單名稱', `kind` varchar(255) NOT NULL DEFAULT 'system' COMMENT '類別', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '標題', `value` text COMMENT '值', `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述', `formtype` varchar(255) NOT NULL DEFAULT '' COMMENT '表單型態', `valuetype` varchar(255) NOT NULL DEFAULT '' COMMENT '值的型態', `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `enable` enum('1','0') NOT NULL DEFAULT '1' COMMENT '狀態', PRIMARY KEY (`sn`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ```