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;