118 lines
27 KiB
MySQL
118 lines
27 KiB
MySQL
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `wa_admin_roles` (
|
||
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
|
|
`role_id` int(11) NOT NULL COMMENT '角色id',
|
||
|
|
`admin_id` int(11) NOT NULL COMMENT '管理员id',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `role_admin_id` (`role_id`,`admin_id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员角色表';
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `wa_admins` (
|
||
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
|
|
`username` varchar(32) NOT NULL COMMENT '用户名',
|
||
|
|
`nickname` varchar(40) NOT NULL COMMENT '昵称',
|
||
|
|
`password` varchar(255) NOT NULL COMMENT '密码',
|
||
|
|
`avatar` varchar(255) DEFAULT '/app/admin/avatar.png' COMMENT '头像',
|
||
|
|
`email` varchar(100) DEFAULT NULL COMMENT '邮箱',
|
||
|
|
`mobile` varchar(16) DEFAULT NULL COMMENT '手机',
|
||
|
|
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
|
||
|
|
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
|
||
|
|
`login_at` datetime DEFAULT NULL COMMENT '登录时间',
|
||
|
|
`status` tinyint(4) DEFAULT NULL COMMENT '禁用',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `username` (`username`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员表';
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `wa_options` (
|
||
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`name` varchar(255) NOT NULL COMMENT '键',
|
||
|
|
`value` longtext NOT NULL COMMENT '值',
|
||
|
|
`created_at` datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '创建时间',
|
||
|
|
`updated_at` datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '更新时间',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='选项表';
|
||
|
|
|
||
|
|
|
||
|
|
LOCK TABLES `wa_options` WRITE;
|
||
|
|
INSERT INTO `wa_options` VALUES (1,'system_config','{\"logo\":{\"title\":\"Webman Admin\",\"image\":\"\\/app\\/admin\\/admin\\/images\\/logo.png\"},\"menu\":{\"data\":\"\\/app\\/admin\\/rule\\/get\",\"method\":\"GET\",\"accordion\":true,\"collapse\":false,\"control\":false,\"controlWidth\":500,\"select\":\"0\",\"async\":true},\"tab\":{\"enable\":true,\"keepState\":true,\"preload\":false,\"session\":true,\"max\":\"30\",\"index\":{\"id\":\"0\",\"href\":\"\\/app\\/admin\\/index\\/dashboard\",\"title\":\"\\u4eea\\u8868\\u76d8\"}},\"theme\":{\"defaultColor\":\"2\",\"defaultMenu\":\"light-theme\",\"defaultHeader\":\"light-theme\",\"allowCustom\":true,\"banner\":false},\"colors\":[{\"id\":\"1\",\"color\":\"#36b368\",\"second\":\"#f0f9eb\"},{\"id\":\"2\",\"color\":\"#2d8cf0\",\"second\":\"#ecf5ff\"},{\"id\":\"3\",\"color\":\"#f6ad55\",\"second\":\"#fdf6ec\"},{\"id\":\"4\",\"color\":\"#f56c6c\",\"second\":\"#fef0f0\"},{\"id\":\"5\",\"color\":\"#3963bc\",\"second\":\"#ecf5ff\"}],\"other\":{\"keepLoad\":\"500\",\"autoHead\":false,\"footer\":false},\"header\":{\"message\":false}}','2022-12-05 14:49:01','2022-12-08 20:20:28'),(2,'table_form_schema_wa_users','{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false},\"username\":{\"field\":\"username\",\"_field_id\":\"1\",\"comment\":\"用户名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"nickname\":{\"field\":\"nickname\",\"_field_id\":\"2\",\"comment\":\"昵称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"password\":{\"field\":\"password\",\"_field_id\":\"3\",\"comment\":\"密码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"sex\":{\"field\":\"sex\",\"_field_id\":\"4\",\"comment\":\"性别\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/dict\\/get\\/sex\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"5\",\"comment\":\"头像\",\"control\":\"uploadImage\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/avatar\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"email\":{\"field\":\"email\",\"_field_id\":\"6\",\"comment\":\"邮箱\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"mobile\":{\"field\":\"mobile\",\"_field_id\":\"7\",\"comment\":\"手机\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"level\":{\"field\":\"level\",\"_field_id\":\"8\",\"comment\":\"等级\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"birthday\":{\"field\":\"birthday\",\"_field_id\":\"9\",\"comment\":\"生日\",\"control\":\"datePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"money\":{\"field\":\"money\",\"_field_id\":\"10\",\"comment\":\"余额(元)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"score\":{\"field\":\"score\",\"_field_id\":\"11\",\"comment\":\"积分\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"last_time\":{\"field\":\"last_time\",\"_field_id\":\"12\",\"comment\":\
|
||
|
|
UNLOCK TABLES;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `wa_roles` (
|
||
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
|
|
`name` varchar(80) NOT NULL COMMENT '角色组',
|
||
|
|
`rules` text COMMENT '权限',
|
||
|
|
`created_at` datetime NOT NULL COMMENT '创建时间',
|
||
|
|
`updated_at` datetime NOT NULL COMMENT '更新时间',
|
||
|
|
`pid` int(10) unsigned DEFAULT NULL COMMENT '父级',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理员角色';
|
||
|
|
|
||
|
|
LOCK TABLES `wa_roles` WRITE;
|
||
|
|
INSERT INTO `wa_roles` VALUES (1,'超级管理员','*','2022-08-13 16:15:01','2022-12-23 12:05:07',NULL);
|
||
|
|
UNLOCK TABLES;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `wa_rules` (
|
||
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
|
|
`title` varchar(255) NOT NULL COMMENT '标题',
|
||
|
|
`icon` varchar(255) DEFAULT NULL COMMENT '图标',
|
||
|
|
`key` varchar(255) NOT NULL COMMENT '标识',
|
||
|
|
`pid` int(10) unsigned DEFAULT '0' COMMENT '上级菜单',
|
||
|
|
`created_at` datetime NOT NULL COMMENT '创建时间',
|
||
|
|
`updated_at` datetime NOT NULL COMMENT '更新时间',
|
||
|
|
`href` varchar(255) DEFAULT NULL COMMENT 'url',
|
||
|
|
`type` int(11) NOT NULL DEFAULT '1' COMMENT '类型',
|
||
|
|
`weight` int(11) DEFAULT '0' COMMENT '排序',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='权限规则';
|
||
|
|
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `wa_uploads` (
|
||
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
|
|
`name` varchar(128) NOT NULL COMMENT '名称',
|
||
|
|
`url` varchar(255) NOT NULL COMMENT '文件',
|
||
|
|
`admin_id` int(11) DEFAULT NULL COMMENT '管理员',
|
||
|
|
`file_size` int(11) NOT NULL COMMENT '文件大小',
|
||
|
|
`mime_type` varchar(255) NOT NULL COMMENT 'mime类型',
|
||
|
|
`image_width` int(11) DEFAULT NULL COMMENT '图片宽度',
|
||
|
|
`image_height` int(11) DEFAULT NULL COMMENT '图片高度',
|
||
|
|
`ext` varchar(128) NOT NULL COMMENT '扩展名',
|
||
|
|
`storage` varchar(255) NOT NULL DEFAULT 'local' COMMENT '存储位置',
|
||
|
|
`created_at` date DEFAULT NULL COMMENT '上传时间',
|
||
|
|
`category` varchar(128) DEFAULT NULL COMMENT '类别',
|
||
|
|
`updated_at` date DEFAULT NULL COMMENT '更新时间',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `category` (`category`),
|
||
|
|
KEY `admin_id` (`admin_id`),
|
||
|
|
KEY `name` (`name`),
|
||
|
|
KEY `ext` (`ext`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='附件';
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `wa_users` (
|
||
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
|
|
`username` varchar(32) NOT NULL COMMENT '用户名',
|
||
|
|
`nickname` varchar(40) NOT NULL COMMENT '昵称',
|
||
|
|
`password` varchar(255) NOT NULL COMMENT '密码',
|
||
|
|
`sex` enum('0','1') NOT NULL DEFAULT '1' COMMENT '性别',
|
||
|
|
`avatar` varchar(255) DEFAULT NULL COMMENT '头像',
|
||
|
|
`email` varchar(128) DEFAULT NULL COMMENT '邮箱',
|
||
|
|
`mobile` varchar(16) DEFAULT NULL COMMENT '手机',
|
||
|
|
`level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '等级',
|
||
|
|
`birthday` date DEFAULT NULL COMMENT '生日',
|
||
|
|
`money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额(元)',
|
||
|
|
`score` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
|
||
|
|
`last_time` datetime DEFAULT NULL COMMENT '登录时间',
|
||
|
|
`last_ip` varchar(50) DEFAULT NULL COMMENT '登录ip',
|
||
|
|
`join_time` datetime DEFAULT NULL COMMENT '注册时间',
|
||
|
|
`join_ip` varchar(50) DEFAULT NULL COMMENT '注册ip',
|
||
|
|
`token` varchar(50) DEFAULT NULL COMMENT 'token',
|
||
|
|
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
|
||
|
|
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
|
||
|
|
`role` int(11) NOT NULL DEFAULT '1' COMMENT '角色',
|
||
|
|
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '禁用',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `username` (`username`),
|
||
|
|
KEY `join_time` (`join_time`),
|
||
|
|
KEY `mobile` (`mobile`),
|
||
|
|
KEY `email` (`email`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户表';
|