zhuoka/tcg.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 微球
 Source Server Type    : MySQL
 Source Server Version : 50616
 Source Host           : rdsave1o67m1ido6gwp6public.mysql.rds.aliyuncs.com:3306
 Source Schema         : awesome_admin_v2

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

 Date: 07/08/2020 17:51:04
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for authority
-- ----------------------------
DROP TABLE IF EXISTS `authority`;
CREATE TABLE `authority`
(
    `name`        varchar(50) NOT NULL,
    `description` varchar(50) NOT NULL,
    PRIMARY KEY (`name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of authority
-- ----------------------------
BEGIN;
INSERT INTO `authority`
VALUES ('ROLE_ADMIN', '管理员');
INSERT INTO `authority`
VALUES ('ROLE_DEV', '开发者');
INSERT INTO `authority`
VALUES ('ROLE_USER', '普通用户');
COMMIT;

-- ----------------------------
-- Table structure for parent
-- ----------------------------
DROP TABLE IF EXISTS `parent`;
CREATE TABLE `parent`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `parent_name` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of parent
-- ----------------------------
BEGIN;
INSERT INTO `parent`
VALUES (2, '2019-12-25 11:17:02', 'system', '2019-12-25 11:17:02', 'system', '111');
INSERT INTO `parent`
VALUES (4, '2019-12-25 11:18:19', 'system', '2019-12-25 11:18:19', 'system', '111');
INSERT INTO `parent`
VALUES (6, '2019-12-25 14:50:49', 'system', '2019-12-25 14:50:49', 'system', '111');
COMMIT;
-- ----------------------------
-- Table structure for child
-- ----------------------------
DROP TABLE IF EXISTS `child`;
CREATE TABLE `child`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `child_name`  varchar(255) DEFAULT NULL,
    `parent_id`   bigint(20)   DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `FK7dag1cncltpyhoc2mbwka356h` (`parent_id`),
    CONSTRAINT `FK7dag1cncltpyhoc2mbwka356h` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of child
-- ----------------------------
BEGIN;
INSERT INTO `child`
VALUES (3, '2019-12-25 11:17:02', 'system', '2019-12-25 11:17:02', 'system', '222', 2);
INSERT INTO `child`
VALUES (5, '2019-12-25 11:18:19', 'system', '2019-12-25 11:18:19', 'system', '222', 4);
INSERT INTO `child`
VALUES (7, '2019-12-25 14:50:50', 'system', '2019-12-25 14:50:50', 'system', '222', 6);
COMMIT;

-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `name`        varchar(255) DEFAULT NULL,
    `remark`      varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for district
-- ----------------------------
DROP TABLE IF EXISTS `district`;
CREATE TABLE `district`
(
    `id`             bigint(20) NOT NULL,
    `created_at`     datetime     DEFAULT NULL,
    `created_by`     varchar(255) DEFAULT NULL,
    `modified_at`    datetime     DEFAULT NULL,
    `modified_by`    varchar(255) DEFAULT NULL,
    `full_name`      varchar(255) DEFAULT NULL,
    `lat`            double     NOT NULL,
    `leaf`           bit(1)     NOT NULL,
    `level`          int(11)    NOT NULL,
    `lng`            double     NOT NULL,
    `name`           varchar(255) DEFAULT NULL,
    `parent`         bigint(20)   DEFAULT NULL,
    `pinyin`         varchar(255) DEFAULT NULL,
    `child_count`    int(11)    NOT NULL,
    `city_code`      varchar(10)  DEFAULT NULL,
    `city_count`     int(11)    NOT NULL,
    `district_count` int(11)    NOT NULL,
    `street_count`   int(11)    NOT NULL,
    `del`            bit(1)     NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for guid_package
-- ----------------------------
DROP TABLE IF EXISTS `guid_package`;
CREATE TABLE `guid_package`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime       DEFAULT NULL,
    `created_by`  varchar(255)   DEFAULT NULL,
    `modified_at` datetime       DEFAULT NULL,
    `modified_by` varchar(255)   DEFAULT NULL,
    `name`        varchar(255)   DEFAULT NULL,
    `price`       decimal(10, 2) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for guide
-- ----------------------------
DROP TABLE IF EXISTS `guide`;
CREATE TABLE `guide`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `pic`         varchar(255) DEFAULT NULL,
    `sort`        int(11)    NOT NULL,
    `text`        text,
    `type`        varchar(255) DEFAULT NULL,
    `video`       varchar(255) DEFAULT NULL,
    `voice`       varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for hibernate_sequence
-- ----------------------------
DROP TABLE IF EXISTS `hibernate_sequence`;
CREATE TABLE `hibernate_sequence`
(
    `next_val` bigint(20) DEFAULT NULL
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of hibernate_sequence
-- ----------------------------
BEGIN;
INSERT INTO `hibernate_sequence`
VALUES (15);
INSERT INTO `hibernate_sequence`
VALUES (15);
INSERT INTO `hibernate_sequence`
VALUES (15);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `active`      bit(1)       DEFAULT NULL,
    `enabled`     bit(1)       DEFAULT NULL,
    `icon`        varchar(255) DEFAULT NULL,
    `name`        varchar(255) DEFAULT NULL,
    `parent`      bigint(20)   DEFAULT NULL,
    `path`        varchar(255) DEFAULT NULL,
    `root`        bit(1)       DEFAULT NULL,
    `sort`        int(11)      DEFAULT NULL,
    `category`    varchar(255) DEFAULT NULL,
    `del`         bit(1)     NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu`
VALUES (3, NULL, NULL, '2020-07-31 14:31:40', '管理员(1)', b'1', b'1', 'fas fa-desktop', '开发', 2, '', b'1', 4, '开发', b'0');
INSERT INTO `menu`
VALUES (4, NULL, NULL, '2020-07-31 14:31:51', '管理员(1)', b'1', b'1', 'fas fa-code', '代码生成', 3, '/genCodeList', b'0', 5,
        '开发', b'0');
INSERT INTO `menu`
VALUES (5, NULL, NULL, '2020-07-31 14:31:56', '管理员(1)', b'1', b'1', 'fas fa-bug', '接口调试', 3, '/api', b'0', 6, '开发',
        b'0');
INSERT INTO `menu`
VALUES (6, NULL, NULL, '2020-07-09 15:01:05', '管理员(1)', b'1', b'1', 'fas fa-user', '用户管理', 2, '/userList', b'1', 2,
        '用户', b'0');
INSERT INTO `menu`
VALUES (8, '2020-07-09 15:01:40', NULL, '2020-07-09 15:01:45', '管理员(1)', b'1', b'1', '', '菜单权限', 9, '/menuAuthority',
        b'0', 8, NULL, b'0');
INSERT INTO `menu`
VALUES (9, NULL, NULL, '2020-07-09 15:01:10', '管理员(1)', b'1', b'1', 'fas fa-cog', '配置', 2, '', b'1', 3, '系统', b'0');
INSERT INTO `menu`
VALUES (10, NULL, NULL, '2020-07-29 16:54:21', '管理员(1)', b'1', b'1', '', '菜单配置', 9, '/menus', b'0', 7, '系统', b'0');
INSERT INTO `menu`
VALUES (14, NULL, NULL, '2020-07-09 15:01:45', '管理员(1)', b'1', b'1', '', '参数配置', 9, '/sysConfigList', b'0', 9, '系统',
        b'0');
COMMIT;

-- ----------------------------
-- Table structure for menu_authority
-- ----------------------------
DROP TABLE IF EXISTS `menu_authority`;
CREATE TABLE `menu_authority`
(
    `menu_id`   bigint(20)  NOT NULL,
    `authority` varchar(50) NOT NULL,
    PRIMARY KEY (`menu_id`, `authority`),
    KEY `FKlj7sftrck7uk1kcjsy0doo56` (`authority`),
    CONSTRAINT `FK4hopjqfvkhdagmk110y1jk17q` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`),
    CONSTRAINT `FKlj7sftrck7uk1kcjsy0doo56` FOREIGN KEY (`authority`) REFERENCES `authority` (`name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of menu_authority
-- ----------------------------
BEGIN;
INSERT INTO `menu_authority`
VALUES (6, 'ROLE_ADMIN');
INSERT INTO `menu_authority`
VALUES (8, 'ROLE_ADMIN');
INSERT INTO `menu_authority`
VALUES (9, 'ROLE_ADMIN');
INSERT INTO `menu_authority`
VALUES (10, 'ROLE_ADMIN');
INSERT INTO `menu_authority`
VALUES (14, 'ROLE_ADMIN');
INSERT INTO `menu_authority`
VALUES (3, 'ROLE_DEV');
INSERT INTO `menu_authority`
VALUES (4, 'ROLE_DEV');
INSERT INTO `menu_authority`
VALUES (5, 'ROLE_DEV');
COMMIT;

-- ----------------------------
-- Table structure for scenic
-- ----------------------------
DROP TABLE IF EXISTS `scenic`;
CREATE TABLE `scenic`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `city_id`     bigint(20)   DEFAULT NULL,
    `name`        varchar(255) DEFAULT NULL,
    `pic`         varchar(255) DEFAULT NULL,
    `remark`      varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for scenic_spot
-- ----------------------------
DROP TABLE IF EXISTS `scenic_spot`;
CREATE TABLE `scenic_spot`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `city_id`     bigint(20)   DEFAULT NULL,
    `name`        varchar(255) DEFAULT NULL,
    `pic`         varchar(255) DEFAULT NULL,
    `remark`      varchar(255) DEFAULT NULL,
    `scenic_id`   bigint(20)   DEFAULT NULL,
    `x`           int(11)    NOT NULL,
    `y`           int(11)    NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sms_record
-- ----------------------------
DROP TABLE IF EXISTS `sms_record`;
CREATE TABLE `sms_record`
(
    `id`          bigint(20) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `code`        varchar(255) DEFAULT NULL,
    `expired`     bit(1)       DEFAULT NULL,
    `expires_at`  datetime     DEFAULT NULL,
    `phone`       varchar(255) DEFAULT NULL,
    `scope`       varchar(255) DEFAULT NULL,
    `session_id`  varchar(255) DEFAULT NULL,
    `del`         bit(1)     NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for spot
-- ----------------------------
DROP TABLE IF EXISTS `spot`;
CREATE TABLE `spot`
(
    `user_id`        bigint(20)  NOT NULL,
    `authority_name` varchar(50) NOT NULL,
    PRIMARY KEY (`user_id`, `authority_name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for spot_guid
-- ----------------------------
DROP TABLE IF EXISTS `spot_guid`;
CREATE TABLE `spot_guid`
(
    `spot_id` bigint(20) NOT NULL,
    `guid_id` bigint(20) NOT NULL,
    PRIMARY KEY (`spot_id`, `guid_id`),
    KEY `FKbftxye4brw7vfq05d7rv0mtca` (`guid_id`),
    CONSTRAINT `FK5xnrr1sk76u0xy3j15p6r96q9` FOREIGN KEY (`spot_id`) REFERENCES `scenic_spot` (`id`),
    CONSTRAINT `FKbftxye4brw7vfq05d7rv0mtca` FOREIGN KEY (`guid_id`) REFERENCES `guide` (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for super_user
-- ----------------------------
DROP TABLE IF EXISTS `super_user`;
CREATE TABLE `super_user`
(
    `id`          bigint(20)  NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `avatar`      varchar(255) DEFAULT NULL,
    `enabled`     bit(1)      NOT NULL,
    `nickname`    varchar(255) DEFAULT NULL,
    `password`    varchar(255) DEFAULT NULL,
    `phone`       varchar(255) DEFAULT NULL,
    `username`    varchar(50) NOT NULL,
    `del`         bit(1)      NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `UK_jfokkpxg19r117eil158ooo9d` (`username`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for super_user_authority
-- ----------------------------
DROP TABLE IF EXISTS `super_user_authority`;
CREATE TABLE `super_user_authority`
(
    `user_id`        bigint(20)  NOT NULL,
    `authority_name` varchar(50) NOT NULL,
    PRIMARY KEY (`user_id`, `authority_name`),
    KEY `FKxjxyodse6n0n00ewvoq8xv8` (`authority_name`),
    CONSTRAINT `FK7p0vq0b1vy9f0sqvgrdqw1q70` FOREIGN KEY (`user_id`) REFERENCES `super_user` (`id`),
    CONSTRAINT `FKxjxyodse6n0n00ewvoq8xv8` FOREIGN KEY (`authority_name`) REFERENCES `authority` (`name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`
(
    `name`        varchar(25) NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `type`        varchar(255) DEFAULT NULL,
    `value`       varchar(255) DEFAULT NULL,
    `del`         bit(1)      NOT NULL,
    PRIMARY KEY (`name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`
(
    `id`          bigint(20)  NOT NULL,
    `created_at`  datetime     DEFAULT NULL,
    `created_by`  varchar(255) DEFAULT NULL,
    `modified_at` datetime     DEFAULT NULL,
    `modified_by` varchar(255) DEFAULT NULL,
    `avatar`      varchar(255) DEFAULT NULL,
    `city`        varchar(255) DEFAULT NULL,
    `country`     varchar(255) DEFAULT NULL,
    `email`       varchar(255) DEFAULT NULL,
    `language`    varchar(255) DEFAULT NULL,
    `nickname`    varchar(255) DEFAULT NULL,
    `open_id`     varchar(255) DEFAULT NULL,
    `password`    varchar(255) DEFAULT NULL,
    `phone`       varchar(255) DEFAULT NULL,
    `province`    varchar(255) DEFAULT NULL,
    `sex`         varchar(255) DEFAULT NULL,
    `username`    varchar(50) NOT NULL,
    `del`         bit(1)      NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `UK_sb8bbouer5wak8vyiiy4pf2bx` (`username`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user`
VALUES (1, '2020-03-07 18:34:36', NULL, '2020-07-31 14:32:10', '管理员(1)',
        'https://zhumj.oss-cn-hangzhou.aliyuncs.com/image/user.jpg', NULL, NULL, NULL, NULL, '管理员', NULL,
        '$2a$10$ztJSpmth7fPgDK0I5stwnO59e5ht2copnDL8lyt2xif6lXBzk/ZdO', NULL, NULL, NULL, 'root', b'0');
COMMIT;

-- ----------------------------
-- Table structure for user_authority
-- ----------------------------
DROP TABLE IF EXISTS `user_authority`;
CREATE TABLE `user_authority`
(
    `user_id`        bigint(20)  NOT NULL,
    `authority_name` varchar(50) NOT NULL,
    PRIMARY KEY (`user_id`, `authority_name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- ----------------------------
-- Records of user_authority
-- ----------------------------
BEGIN;
INSERT INTO `user_authority`
VALUES (1, 'ROLE_ADMIN');
INSERT INTO `user_authority`
VALUES (1, 'ROLE_DEV');
INSERT INTO `user_authority`
VALUES (1, 'ROLE_USER');
INSERT INTO `user_authority`
VALUES (11, 'ROLE_USER');
INSERT INTO `user_authority`
VALUES (14, 'ROLE_ADMIN');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;