init.init.sql Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of yes-generator Show documentation
There is a newer version: 2.0.4
/*
 Navicat Premium Data Transfer

 Source Server         : 本地开发
 Source Server Type    : MySQL
 Source Server Version : 50739
 Source Host           : 192.168.1.15:3306
 Source Schema         : co_test

 Target Server Type    : MySQL
 Target Server Version : 50739
 File Encoding         : 65001

 Date: 22/11/2022 15:05:48
*/

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for yes_system_account
-- ----------------------------
DROP TABLE IF EXISTS `yes_system_account`;
CREATE TABLE `yes_system_account`
(
    `id`        bigint(20) UNSIGNED NOT NULL COMMENT '后台管理员表id ',
    `account`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
    `pwd`       char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci   NOT NULL COMMENT '密码',
    `real_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
    `status`    int(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态:1=有效 2=无效',
    `last_ip`   varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最后一次登录ip',
    `add_time`  datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
    `edit_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '最后一次登录时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX       `account`(`account`) USING BTREE,
    INDEX       `status`(`status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台管理员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yes_system_account
-- ----------------------------
INSERT INTO `yes_system_account`
VALUES (1, 'admin', '123456', '小区', 1, '127.0.0.1', '2022-11-21 11:00:21', '2022-11-21 21:47:01');

-- ----------------------------
-- Table structure for yes_system_menu
-- ----------------------------
DROP TABLE IF EXISTS `yes_system_menu`;
CREATE TABLE `yes_system_menu`
(
    `id`        bigint(20) unsigned NOT NULL,
    `pid`       bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
    `name`      varchar(100) DEFAULT NULL COMMENT '名称',
    `menu_type` varchar(2)   DEFAULT 'M' COMMENT '类型:M=目录 C=菜单 A=按钮',
    `icon`      varchar(255) DEFAULT NULL COMMENT 'icon',
    `component` varchar(200) DEFAULT NULL COMMENT '组件路径',
    `path`      varchar(100) DEFAULT NULL COMMENT '访问路径',
    `sort`      int(5) DEFAULT '99999' COMMENT '排序',
    `add_time`  datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `edit_time` datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统菜单表';
-- ----------------------------
-- Records of yes_system_menu
-- ----------------------------
INSERT INTO `yes_system_menu` VALUES (1645252881724903411, 1645252881724903422, '账号管理', 'C', NULL, '/system/account', '/system/account', 1, '2023-04-11 13:54:34', '2023-04-11 15:55:33');
INSERT INTO `yes_system_menu` VALUES (1645252881724903422, 0, '系统管理', 'M', NULL, '/system', '/system', 1, '2023-04-10 18:09:01', '2023-04-11 15:55:28');

SET FOREIGN_KEY_CHECKS = 1;