~~~[sql] CREATE TABLE `xi_admin` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用戶名', `password` char(32) NOT NULL DEFAULT '' COMMENT '密碼', `auth_key` varchar(32) DEFAULT NULL COMMENT '認證密鑰', `mobile` varchar(16) NOT NULL COMMENT '手機', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `mobile` (`mobile`), UNIQUE KEY `auth_key` (`auth_key`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='平臺用戶'; ~~~ ~~~[sql] CREATE TABLE `xi_admin_auth_assignment` ( `admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '平臺用戶ID', `role_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色ID', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', UNIQUE KEY `admin_id` (`admin_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='平臺權限分配'; ~~~ ~~~[sql] CREATE TABLE `xi_admin_auth_permission` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `menu_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '菜單ID', `title` varchar(32) NOT NULL DEFAULT '' COMMENT '標題', `module` varchar(64) NOT NULL DEFAULT '' COMMENT '模塊', `controller` varchar(64) NOT NULL DEFAULT '' COMMENT '控制器', `name` varchar(64) NOT NULL DEFAULT '' COMMENT '規則唯一標識', `condition` varchar(128) NOT NULL COMMENT '規則表達式', `icon` varchar(16) NOT NULL DEFAULT '' COMMENT '圖標', `sort` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_menu_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否菜單顯示', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='平臺權限條目'; ~~~ ~~~[sql] CREATE TABLE `xi_admin_auth_role` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名稱', `permissions` text CHARACTER SET utf8 NOT NULL COMMENT '權限', `description` varchar(128) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '描述', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='平臺權限角色'; ~~~ ~~~[sql] CREATE TABLE `xi_admin_menu` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父ID', `name` varchar(16) NOT NULL DEFAULT '' COMMENT '名稱', `module` varchar(32) NOT NULL DEFAULT '' COMMENT '模塊', `icon` varchar(32) NOT NULL COMMENT '圖標', `sort` tinyint(3) unsigned NOT NULL COMMENT '排序', `is_trash` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '刪除，0=>否，1=>是', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態，0=>禁用，1=>啟用', `created_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '創建時間', `updated_at` int(11) unsigned NOT NULL DEFAULT '1451577600' COMMENT '更新時間', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`parent_id`,`module`,`is_trash`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='平臺菜單'; ~~~