數據表 · PHP筆記

[TOC] ### fa_auth_rule.sql 節點表 ``` SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for fa_auth_rule -- ---------------------------- DROP TABLE IF EXISTS `fa_auth_rule`; CREATE TABLE `fa_auth_rule` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` enum('menu','file') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'file' COMMENT 'menu為菜單,file為權限節點', `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '規則名稱', `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '規則名稱', `icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '圖標', `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '規則URL', `condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '條件', `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '備注', `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否為菜單', `menutype` enum('addtabs','blank','dialog','ajax') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜單類型', `extend` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '擴展屬性', `py` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '拼音首字母', `pinyin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '拼音', `createtime` int(10) DEFAULT NULL COMMENT '創建時間', `updatetime` int(10) DEFAULT NULL COMMENT '更新時間', `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '權重', `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '狀態', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) USING BTREE, KEY `pid` (`pid`), KEY `weigh` (`weigh`) ) ENGINE=InnoDB AUTO_INCREMENT=258 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='節點表'; ``` ### fa_auth_group.sql 分組表 ``` SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for fa_auth_group -- ---------------------------- DROP TABLE IF EXISTS `fa_auth_group`; CREATE TABLE `fa_auth_group` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父組別', `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '組名', `rules` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '規則ID', `createtime` int(10) DEFAULT NULL COMMENT '創建時間', `updatetime` int(10) DEFAULT NULL COMMENT '更新時間', `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '狀態', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分組表'; ``` ### fa_auth_group_access.sql 權限分組映射表 ``` SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for fa_auth_group_access -- ---------------------------- DROP TABLE IF EXISTS `fa_auth_group_access`; CREATE TABLE `fa_auth_group_access` ( `uid` int(10) unsigned NOT NULL COMMENT '會員ID', `group_id` int(10) unsigned NOT NULL COMMENT '級別ID', UNIQUE KEY `uid_group_id` (`uid`,`group_id`), KEY `uid` (`uid`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='權限分組映射表'; -- ---------------------------- -- Records of fa_auth_group_access -- ---------------------------- INSERT INTO `fa_auth_group_access` VALUES ('1', '1'); ```