# Auth 認證 ## auth_group表 ~~~ DROP TABLE IF EXISTS `jz_auth_group`; CREATE TABLE `jz_auth_group` ( `id` mediumint(8) UNSIGNED NOT NULL, `title` char(100) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '1', `rules` char(80) NOT NULL DEFAULT '', `icon` varchar(31) NOT NULL DEFAULT '', `sort` tinyint(4) NOT NULL, `create_time` int(11) NOT NULL DEFAULT '0', `update_time` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ~~~ ## auth_rule表 ~~~ DROP TABLE IF EXISTS `jz_auth_rule`; CREATE TABLE `jz_auth_rule` ( `id` mediumint(8) UNSIGNED NOT NULL, `name` char(80) NOT NULL DEFAULT '', `title` char(20) NOT NULL DEFAULT '', `type` tinyint(1) NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL DEFAULT '1', `condition` char(100) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ~~~ ## auth_group_access表 ~~~ DROP TABLE IF EXISTS `jz_auth_group_access`; CREATE TABLE `jz_auth_group_access` ( `uid` mediumint(8) UNSIGNED NOT NULL, `group_id` mediumint(8) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ~~~ > 修改 auth_group 表添加了icon 和create_time update_time 其他地方無修改