cosmos_back/db/init.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 第九空间-测试服-47.107.237.230
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : 47.107.237.230:53306
 Source Schema         : starepoch_test

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

 Date: 15/06/2022 15:24:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for activity
-- ----------------------------

CREATE TABLE `activity`  (
                             `id` bigint NOT NULL,
                             `created_at` datetime NULL DEFAULT NULL,
                             `created_by` varchar(255)  NULL DEFAULT NULL,
                             `del` bit(1) NOT NULL,
                             `modified_at` datetime NULL DEFAULT NULL,
                             `modified_by` varchar(255)  NULL DEFAULT NULL,
                             `cover` varchar(255)  NULL DEFAULT NULL,
                             `detail` text  NULL,
                             `name` varchar(255)  NULL DEFAULT NULL,
                             `project_id` int NOT NULL,
                             `content` text  NULL,
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity
-- ----------------------------

-- ----------------------------
-- Table structure for activity_collection
-- ----------------------------

CREATE TABLE `activity_collection`  (
                                        `id` bigint NOT NULL,
                                        `created_at` datetime NULL DEFAULT NULL,
                                        `created_by` varchar(255)  NULL DEFAULT NULL,
                                        `del` bit(1) NOT NULL,
                                        `modified_at` datetime NULL DEFAULT NULL,
                                        `modified_by` varchar(255)  NULL DEFAULT NULL,
                                        `award_collection_id` bigint NULL DEFAULT NULL,
                                        `award_collection_name` varchar(255)  NULL DEFAULT NULL,
                                        `collection_id` bigint NULL DEFAULT NULL,
                                        `collection_name` varchar(255)  NULL DEFAULT NULL,
                                        `name` varchar(255)  NULL DEFAULT NULL,
                                        `num` int NOT NULL,
                                        `pic` text  NULL,
                                        `stock` int NOT NULL,
                                        `total` int NOT NULL,
                                        `project_id` int NOT NULL,
                                        `end_time` datetime NULL DEFAULT NULL,
                                        `need_collected_num` int NULL DEFAULT NULL,
                                        `start_time` datetime NULL DEFAULT NULL,
                                        `type` int NULL DEFAULT NULL,
                                        PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity_collection
-- ----------------------------

-- ----------------------------
-- Table structure for activity_collection_info
-- ----------------------------

CREATE TABLE `activity_collection_info`  (
                                             `id` bigint NOT NULL,
                                             `created_at` datetime NULL DEFAULT NULL,
                                             `created_by` varchar(255)  NULL DEFAULT NULL,
                                             `del` bit(1) NOT NULL,
                                             `modified_at` datetime NULL DEFAULT NULL,
                                             `modified_by` varchar(255)  NULL DEFAULT NULL,
                                             `collection_id` bigint NULL DEFAULT NULL,
                                             `collection_name` varchar(255)  NULL DEFAULT NULL,
                                             `must_need_collected` bit(1) NULL DEFAULT NULL,
                                             `num` int NULL DEFAULT NULL,
                                             `activity_id` bigint NULL DEFAULT NULL,
                                             PRIMARY KEY (`id`) USING BTREE,
                                             INDEX `FK1v9a5r3gurk2erxvd49lv89u5`(`activity_id`) USING BTREE,
                                             CONSTRAINT `FK1v9a5r3gurk2erxvd49lv89u5` FOREIGN KEY (`activity_id`) REFERENCES `activity_collection` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity_collection_info
-- ----------------------------

-- ----------------------------
-- Table structure for activity_invite
-- ----------------------------

CREATE TABLE `activity_invite`  (
                                    `id` bigint NOT NULL,
                                    `created_at` datetime NULL DEFAULT NULL,
                                    `created_by` varchar(255)  NULL DEFAULT NULL,
                                    `del` bit(1) NOT NULL,
                                    `modified_at` datetime NULL DEFAULT NULL,
                                    `modified_by` varchar(255)  NULL DEFAULT NULL,
                                    `award_distribution_type` varchar(255)  NULL DEFAULT NULL,
                                    `by_invite_prize` text  NULL,
                                    `content` text  NULL,
                                    `invite_enddatetime` datetime NULL DEFAULT NULL,
                                    `invite_prize_list` text  NULL,
                                    `invite_startdatetime` datetime NULL DEFAULT NULL,
                                    `name` varchar(255)  NULL DEFAULT NULL,
                                    `phones` text  NULL,
                                    `poster` varchar(255)  NULL DEFAULT NULL,
                                    `prl` varchar(255)  NULL DEFAULT NULL,
                                    `project_id` int NOT NULL,
                                    `hold_collection_id` bigint NULL DEFAULT NULL,
                                    `inviter_qualifications` int NULL DEFAULT NULL,
                                    `hold_collection_ids` text  NULL,
                                    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of activity_invite
-- ----------------------------

-- ----------------------------
-- Table structure for activity_material
-- ----------------------------

CREATE TABLE `activity_material`  (
                                      `id` bigint NOT NULL,
                                      `created_at` datetime NULL DEFAULT NULL,
                                      `created_by` varchar(255)  NULL DEFAULT NULL,
                                      `del` bit(1) NOT NULL,
                                      `modified_at` datetime NULL DEFAULT NULL,
                                      `modified_by` varchar(255)  NULL DEFAULT NULL,
                                      `asset_id` bigint NULL DEFAULT NULL,
                                      `category` varchar(255)  NULL DEFAULT NULL,
                                      `collection_id` bigint NULL DEFAULT NULL,
                                      `name` varchar(255)  NULL DEFAULT NULL,
                                      `number` int NULL DEFAULT NULL,
                                      `order_id` bigint NULL DEFAULT NULL,
                                      `pic` text  NULL,
                                      PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity_material
-- ----------------------------

-- ----------------------------
-- Table structure for activity_order
-- ----------------------------

CREATE TABLE `activity_order`  (
                                   `id` bigint NOT NULL,
                                   `created_at` datetime NULL DEFAULT NULL,
                                   `created_by` varchar(255)  NULL DEFAULT NULL,
                                   `del` bit(1) NOT NULL,
                                   `modified_at` datetime NULL DEFAULT NULL,
                                   `modified_by` varchar(255)  NULL DEFAULT NULL,
                                   `activity_collection` varchar(255)  NULL DEFAULT NULL,
                                   `activity_collection_id` bigint NULL DEFAULT NULL,
                                   `phone` varchar(255)  NULL DEFAULT NULL,
                                   `user_id` bigint NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity_order
-- ----------------------------

-- ----------------------------
-- Table structure for activity_priority_document
-- ----------------------------

CREATE TABLE `activity_priority_document`  (
                                               `id` bigint NOT NULL,
                                               `created_at` datetime NULL DEFAULT NULL,
                                               `created_by` varchar(255)  NULL DEFAULT NULL,
                                               `del` bit(1) NOT NULL,
                                               `modified_at` datetime NULL DEFAULT NULL,
                                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                                               `advance_purchase_count` int NOT NULL,
                                               `advance_purchase_time` int NOT NULL,
                                               `collection_id` bigint NULL DEFAULT NULL,
                                               `collection_name` varchar(255)  NULL DEFAULT NULL,
                                               `name` varchar(255)  NULL DEFAULT NULL,
                                               `pic` text  NULL,
                                               `project_id` int NOT NULL,
                                               `item_id` int NULL DEFAULT NULL,
                                               `item_name` int NULL DEFAULT NULL,
                                               `minter_id` bigint NULL DEFAULT NULL,
                                               `overdue_time` datetime NULL DEFAULT NULL,
                                               `reset` bit(1) NOT NULL,
                                               `target_collection_id` bigint NULL DEFAULT NULL,
                                               `target_collection_id_list` text  NULL,
                                               `text` text  NULL,
                                               PRIMARY KEY (`id`) USING BTREE,
                                               INDEX `IDXh1jya5ssbfe165hmv9y5b69ae`(`minter_id`) USING BTREE,
                                               INDEX `IDX3v2etk7srccalesftyf5rfyq`(`reset`) USING BTREE,
                                               INDEX `IDXt764tmbb5k35ws8hn6mmu7wuu`(`collection_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity_priority_document
-- ----------------------------

-- ----------------------------
-- Table structure for activity_priority_document_detail
-- ----------------------------

CREATE TABLE `activity_priority_document_detail`  (
                                                      `id` bigint NOT NULL,
                                                      `created_at` datetime NULL DEFAULT NULL,
                                                      `created_by` varchar(255)  NULL DEFAULT NULL,
                                                      `del` bit(1) NOT NULL,
                                                      `modified_at` datetime NULL DEFAULT NULL,
                                                      `modified_by` varchar(255)  NULL DEFAULT NULL,
                                                      `advance_purchase_count` int NOT NULL,
                                                      `advance_purchase_time` int NOT NULL,
                                                      `asset_id` bigint NULL DEFAULT NULL,
                                                      `collection_id` bigint NULL DEFAULT NULL,
                                                      `disabled` bit(1) NOT NULL,
                                                      PRIMARY KEY (`id`) USING BTREE,
                                                      INDEX `IDXh3qt65qhxieeyk1o4mpe1fqxf`(`collection_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity_priority_document_detail
-- ----------------------------

-- ----------------------------
-- Table structure for activity_surprise_box
-- ----------------------------

CREATE TABLE `activity_surprise_box`  (
                                          `id` bigint NOT NULL,
                                          `created_at` datetime NULL DEFAULT NULL,
                                          `created_by` varchar(255)  NULL DEFAULT NULL,
                                          `del` bit(1) NOT NULL,
                                          `modified_at` datetime NULL DEFAULT NULL,
                                          `modified_by` varchar(255)  NULL DEFAULT NULL,
                                          `box_sum` int NULL DEFAULT NULL,
                                          `grant_count` int NULL DEFAULT NULL,
                                          `name` varchar(255)  NULL DEFAULT NULL,
                                          `project_id` int NOT NULL,
                                          `properties` text  NULL,
                                          PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of activity_surprise_box
-- ----------------------------

-- ----------------------------
-- Table structure for adapay_merchant
-- ----------------------------

CREATE TABLE `adapay_merchant`  (
                                    `id` bigint NOT NULL,
                                    `created_at` datetime NULL DEFAULT NULL,
                                    `created_by` varchar(255)  NULL DEFAULT NULL,
                                    `del` bit(1) NOT NULL,
                                    `modified_at` datetime NULL DEFAULT NULL,
                                    `modified_by` varchar(255)  NULL DEFAULT NULL,
                                    `api_key` varchar(255)  NULL DEFAULT NULL,
                                    `app_id` varchar(72)  NULL DEFAULT NULL,
                                    `mock_key` varchar(255)  NULL DEFAULT NULL,
                                    `name` varchar(72)  NULL DEFAULT NULL,
                                    `priv_key` text  NULL,
                                    `public_key` text  NULL,
                                    `selected` bit(1) NOT NULL,
                                    `status` varchar(255)  NULL DEFAULT NULL,
                                    `wx_app_id` varchar(255)  NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`) USING BTREE,
                                    UNIQUE INDEX `UK_t7m2745vm5owxivq45g6lmsut`(`app_id`) USING BTREE,
                                    UNIQUE INDEX `UK_226ho9bovclgwjf8pvuxdb04s`(`name`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of adapay_merchant
-- ----------------------------

-- ----------------------------
-- Table structure for air_drop
-- ----------------------------

CREATE TABLE `air_drop`  (
                             `id` bigint NOT NULL,
                             `created_at` datetime NULL DEFAULT NULL,
                             `created_by` varchar(255)  NULL DEFAULT NULL,
                             `del` bit(1) NOT NULL,
                             `modified_at` datetime NULL DEFAULT NULL,
                             `modified_by` varchar(255)  NULL DEFAULT NULL,
                             `collection_id` bigint NULL DEFAULT NULL,
                             `coupon_id` bigint NULL DEFAULT NULL,
                             `name` varchar(255)  NULL DEFAULT NULL,
                             `phone` text  NULL,
                             `remark` varchar(255)  NULL DEFAULT NULL,
                             `result` text  NULL,
                             `type` varchar(255)  NULL DEFAULT NULL,
                             `user_ids` text  NULL,
                             `project_id` int NOT NULL,
                             `drop_count` int NULL DEFAULT NULL,
                             `drop_price` decimal(10, 2) NULL DEFAULT NULL,
                             `operation` varchar(255)  NULL DEFAULT NULL,
                             `surprise_box_id` bigint NULL DEFAULT NULL,
                             PRIMARY KEY (`id`) USING BTREE,
                             INDEX `IDXf8xftc1c2yg8y5baijk0070rl`(`name`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of air_drop
-- ----------------------------

-- ----------------------------
-- Table structure for appointment
-- ----------------------------

CREATE TABLE `appointment`  (
                                `id` bigint NOT NULL,
                                `created_at` datetime NULL DEFAULT NULL,
                                `created_by` varchar(255)  NULL DEFAULT NULL,
                                `del` bit(1) NOT NULL,
                                `modified_at` datetime NULL DEFAULT NULL,
                                `modified_by` varchar(255)  NULL DEFAULT NULL,
                                `blind_box_id` bigint NULL DEFAULT NULL,
                                `user_id` bigint NULL DEFAULT NULL,
                                PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of appointment
-- ----------------------------

-- ----------------------------
-- Table structure for asset
-- ----------------------------

CREATE TABLE `asset`  (
                          `id` bigint NOT NULL,
                          `created_at` datetime NULL DEFAULT NULL,
                          `created_by` varchar(255)  NULL DEFAULT NULL,
                          `del` bit(1) NOT NULL,
                          `modified_at` datetime NULL DEFAULT NULL,
                          `modified_by` varchar(255)  NULL DEFAULT NULL,
                          `block_number` decimal(19, 2) NULL DEFAULT NULL,
                          `gas_used` decimal(19, 2) NULL DEFAULT NULL,
                          `ipfs_url` varchar(255)  NULL DEFAULT NULL,
                          `minter` varchar(255)  NULL DEFAULT NULL,
                          `minter_avatar` varchar(255)  NULL DEFAULT NULL,
                          `minter_id` bigint NULL DEFAULT NULL,
                          `name` varchar(255)  NULL DEFAULT NULL,
                          `order_id` bigint NULL DEFAULT NULL,
                          `out_order_id` bigint NULL DEFAULT NULL,
                          `out_tx_hash` varchar(255)  NULL DEFAULT NULL,
                          `pic` text  NULL,
                          `price` decimal(10, 2) NULL DEFAULT NULL,
                          `sell_price` decimal(10, 2) NULL DEFAULT NULL,
                          `status` varchar(255)  NULL DEFAULT NULL,
                          `token_id` varchar(255)  NULL DEFAULT NULL,
                          `tx_hash` varchar(255)  NULL DEFAULT NULL,
                          `user_id` bigint NULL DEFAULT NULL,
                          `properties` text  NULL,
                          `collection_id` bigint NULL DEFAULT NULL,
                          `number` int NOT NULL,
                          `owner_name` varchar(255)  NULL DEFAULT NULL,
                          `can_resale` bit(1) NOT NULL,
                          `detail` text  NULL,
                          `public_collection_id` bigint NULL DEFAULT NULL,
                          `public_show` bit(1) NOT NULL,
                          `royalties` int NOT NULL,
                          `service_charge` int NOT NULL,
                          `category` varchar(255)  NULL DEFAULT NULL,
                          `consignment` bit(1) NOT NULL,
                          `likes` int NOT NULL,
                          `owner` varchar(255)  NULL DEFAULT NULL,
                          `owner_avatar` varchar(255)  NULL DEFAULT NULL,
                          `owner_id` bigint NULL DEFAULT NULL,
                          `privileges` text  NULL,
                          `from_asset_id` bigint NULL DEFAULT NULL,
                          `chain_token_id` varchar(255)  NULL DEFAULT NULL,
                          `model3d` text  NULL,
                          `project_id` int NOT NULL,
                          `out_time` datetime NULL DEFAULT NULL,
                          `compose_name` varchar(255)  NULL DEFAULT NULL,
                          `blind_box_id` bigint NULL DEFAULT NULL,
                          `categories` varchar(255)  NULL DEFAULT NULL,
                          `variable_type` bit(1) NOT NULL,
                          PRIMARY KEY (`id`) USING BTREE,
                          INDEX `IDXn5os9jehi865ew1aw69c3n0gs`(`user_id`) USING BTREE,
                          INDEX `IDXqygqn7xpy21iotp7863h3440i`(`token_id`) USING BTREE,
                          INDEX `IDXl88c0btbqwdphcq6tkt1lvrf7`(`collection_id`) USING BTREE,
                          INDEX `IDXa9re3fexerlxmhcrccqn7xho8`(`minter_id`) USING BTREE,
                          INDEX `IDXi2s6wcjil5l6331nt3sk2sows`(`owner_id`) USING BTREE,
                          INDEX `asset_order_id_index`(`order_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of asset
-- ----------------------------

-- ----------------------------
-- Table structure for asset_sell_limit
-- ----------------------------

CREATE TABLE `asset_sell_limit`  (
                                     `id` bigint NOT NULL,
                                     `created_at` datetime NULL DEFAULT NULL,
                                     `created_by` varchar(255)  NULL DEFAULT NULL,
                                     `del` bit(1) NOT NULL,
                                     `modified_at` datetime NULL DEFAULT NULL,
                                     `modified_by` varchar(255)  NULL DEFAULT NULL,
                                     `collection_id` bigint NULL DEFAULT NULL,
                                     `collection_name` varchar(255)  NULL DEFAULT NULL,
                                     `expire_date_time` datetime NULL DEFAULT NULL,
                                     `expire_seconds` int NULL DEFAULT NULL,
                                     `min_price` decimal(19, 2) NULL DEFAULT NULL,
                                     `project_id` int NOT NULL,
                                     PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of asset_sell_limit
-- ----------------------------

-- ----------------------------
-- Table structure for authority
-- ----------------------------

CREATE TABLE `authority`  (
                              `name` varchar(50)  NOT NULL,
                              `description` varchar(50)  NOT NULL,
                              `hide` bit(1) NOT NULL,
                              PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of authority
-- ----------------------------
INSERT INTO `authority` VALUES ('ROLE_ADMIN', '高级管理员', b'0');
INSERT INTO `authority` VALUES ('ROLE_DEV', '开发者', b'0');
INSERT INTO `authority` VALUES ('ROLE_MINTER', '铸造者', b'0');
INSERT INTO `authority` VALUES ('ROLE_OPERATOR', '普通管理员', b'0');
INSERT INTO `authority` VALUES ('ROLE_USER', '普通用户', b'0');

-- ----------------------------
-- Table structure for award_activity_collection_info
-- ----------------------------

CREATE TABLE `award_activity_collection_info`  (
                                                   `id` bigint NOT NULL,
                                                   `created_at` datetime NULL DEFAULT NULL,
                                                   `created_by` varchar(255)  NULL DEFAULT NULL,
                                                   `del` bit(1) NOT NULL,
                                                   `modified_at` datetime NULL DEFAULT NULL,
                                                   `modified_by` varchar(255)  NULL DEFAULT NULL,
                                                   `activity_id` bigint NULL DEFAULT NULL,
                                                   `collection_id` bigint NULL DEFAULT NULL,
                                                   `collection_name` varchar(255)  NULL DEFAULT NULL,
                                                   `drop_type` int NOT NULL DEFAULT 0,
                                                   `exchange_num` int NOT NULL DEFAULT 1,
                                                   `num` int NULL DEFAULT NULL,
                                                   `stock` int NULL DEFAULT NULL,
                                                   PRIMARY KEY (`id`) USING BTREE,
                                                   INDEX `FKla58velkvjd4hcueqjjtgte50`(`activity_id`) USING BTREE,
                                                   CONSTRAINT `FKla58velkvjd4hcueqjjtgte50` FOREIGN KEY (`activity_id`) REFERENCES `activity_collection` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of award_activity_collection_info
-- ----------------------------

-- ----------------------------
-- Table structure for banner
-- ----------------------------

CREATE TABLE `banner`  (
                           `id` bigint NOT NULL,
                           `created_at` datetime NULL DEFAULT NULL,
                           `created_by` varchar(255)  NULL DEFAULT NULL,
                           `del` bit(1) NOT NULL,
                           `modified_at` datetime NULL DEFAULT NULL,
                           `modified_by` varchar(255)  NULL DEFAULT NULL,
                           `link` bit(1) NOT NULL,
                           `link_content` varchar(255)  NULL DEFAULT NULL,
                           `link_type` varchar(255)  NULL DEFAULT NULL,
                           `name` varchar(255)  NULL DEFAULT NULL,
                           `pic` varchar(255)  NULL DEFAULT NULL,
                           `remark` varchar(255)  NULL DEFAULT NULL,
                           `sort` int NOT NULL,
                           `type` varchar(255)  NULL DEFAULT NULL,
                           `project_id` int NOT NULL,
                           PRIMARY KEY (`id`) USING BTREE,
                           INDEX `IDXkah06yhlxm824q81ru3aomxic`(`type`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of banner
-- ----------------------------

-- ----------------------------
-- Table structure for blind_box_item
-- ----------------------------

CREATE TABLE `blind_box_item`  (
                                   `id` bigint NOT NULL,
                                   `created_at` datetime NULL DEFAULT NULL,
                                   `created_by` varchar(255)  NULL DEFAULT NULL,
                                   `del` bit(1) NOT NULL,
                                   `modified_at` datetime NULL DEFAULT NULL,
                                   `modified_by` varchar(255)  NULL DEFAULT NULL,
                                   `blind_box_id` bigint NULL DEFAULT NULL,
                                   `can_resale` bit(1) NOT NULL,
                                   `collection_id` bigint NULL DEFAULT NULL,
                                   `detail` text  NULL,
                                   `minter` varchar(255)  NULL DEFAULT NULL,
                                   `minter_avatar` varchar(255)  NULL DEFAULT NULL,
                                   `minter_id` bigint NULL DEFAULT NULL,
                                   `name` varchar(255)  NULL DEFAULT NULL,
                                   `pic` text  NULL,
                                   `price` decimal(10, 2) NULL DEFAULT NULL,
                                   `properties` text  NULL,
                                   `rare` bit(1) NOT NULL,
                                   `royalties` int NOT NULL,
                                   `sale` int NOT NULL,
                                   `service_charge` int NOT NULL,
                                   `stock` int NOT NULL,
                                   `total` int NOT NULL,
                                   `category` varchar(255)  NULL DEFAULT NULL,
                                   `privileges` text  NULL,
                                   `model3d` text  NULL,
                                   `project_id` int NOT NULL,
                                   `pic_pattern` varchar(255)  NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`) USING BTREE,
                                   INDEX `IDX2a0v9ix4r7xa0c9e0mysp8vcv`(`blind_box_id`) USING BTREE,
                                   INDEX `IDXpts7ljwe64og1h05ssm75ee9j`(`collection_id`) USING BTREE,
                                   INDEX `IDXsn5pqgm83nd6xmdrh7qujdri8`(`minter_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of blind_box_item
-- ----------------------------

-- ----------------------------
-- Table structure for blink_box
-- ----------------------------

CREATE TABLE `blink_box`  (
                              `id` bigint NOT NULL,
                              `created_at` datetime NULL DEFAULT NULL,
                              `created_by` varchar(255)  NULL DEFAULT NULL,
                              `del` bit(1) NOT NULL,
                              `modified_at` datetime NULL DEFAULT NULL,
                              `modified_by` varchar(255)  NULL DEFAULT NULL,
                              `detail` text  NULL,
                              `likes` int NOT NULL,
                              `minter` varchar(255)  NULL DEFAULT NULL,
                              `minter_avatar` varchar(255)  NULL DEFAULT NULL,
                              `minter_id` bigint NULL DEFAULT NULL,
                              `name` varchar(255)  NULL DEFAULT NULL,
                              `on_shelf` bit(1) NOT NULL,
                              `pics` text  NULL,
                              `price` decimal(10, 2) NULL DEFAULT NULL,
                              `properties` text  NULL,
                              `salable` bit(1) NOT NULL,
                              `sale` int NOT NULL,
                              `source` varchar(255)  NULL DEFAULT NULL,
                              `stock` int NOT NULL,
                              `type` varchar(255)  NULL DEFAULT NULL,
                              PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of blink_box
-- ----------------------------

-- ----------------------------
-- Table structure for child
-- ----------------------------

CREATE TABLE `child`  (
                          `id` bigint NOT NULL,
                          `created_at` datetime NULL DEFAULT NULL,
                          `created_by` varchar(255)  NULL DEFAULT NULL,
                          `modified_at` datetime NULL DEFAULT NULL,
                          `modified_by` varchar(255)  NULL DEFAULT NULL,
                          `child_name` varchar(255)  NULL DEFAULT NULL,
                          `parent_id` bigint NULL DEFAULT NULL,
                          PRIMARY KEY (`id`) USING BTREE,
                          INDEX `FK7dag1cncltpyhoc2mbwka356h`(`parent_id`) USING BTREE,
                          CONSTRAINT `FK7dag1cncltpyhoc2mbwka356h` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of child
-- ----------------------------

-- ----------------------------
-- Table structure for city
-- ----------------------------

CREATE TABLE `city`  (
                         `id` bigint NOT NULL,
                         `created_at` datetime NULL DEFAULT NULL,
                         `created_by` varchar(255)  NULL DEFAULT NULL,
                         `modified_at` datetime NULL DEFAULT NULL,
                         `modified_by` varchar(255)  NULL DEFAULT NULL,
                         `name` varchar(255)  NULL DEFAULT NULL,
                         `remark` varchar(255)  NULL DEFAULT NULL,
                         PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of city
-- ----------------------------

-- ----------------------------
-- Table structure for collection_category
-- ----------------------------

CREATE TABLE `collection_category`  (
                                        `id` bigint NOT NULL,
                                        `created_at` datetime NULL DEFAULT NULL,
                                        `created_by` varchar(255)  NULL DEFAULT NULL,
                                        `del` bit(1) NOT NULL,
                                        `modified_at` datetime NULL DEFAULT NULL,
                                        `modified_by` varchar(255)  NULL DEFAULT NULL,
                                        `name` varchar(255)  NULL DEFAULT NULL,
                                        `parent_id` bigint NULL DEFAULT NULL,
                                        `project_id` int NOT NULL,
                                        `sort` int NULL DEFAULT NULL,
                                        PRIMARY KEY (`id`) USING BTREE,
                                        INDEX `IDXkkey1va7wkboxpa3t9o04ke79`(`name`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of collection_category
-- ----------------------------

-- ----------------------------
-- Table structure for collection_info
-- ----------------------------

CREATE TABLE `collection_info`  (
                                    `id` bigint NOT NULL,
                                    `created_at` datetime NULL DEFAULT NULL,
                                    `created_by` varchar(255)  NULL DEFAULT NULL,
                                    `del` bit(1) NOT NULL,
                                    `modified_at` datetime NULL DEFAULT NULL,
                                    `modified_by` varchar(255)  NULL DEFAULT NULL,
                                    `detail` text  NULL,
                                    `likes` int NOT NULL,
                                    `minter` varchar(255)  NULL DEFAULT NULL,
                                    `minter_avatar` varchar(255)  NULL DEFAULT NULL,
                                    `minter_id` bigint NULL DEFAULT NULL,
                                    `name` varchar(255)  NULL DEFAULT NULL,
                                    `on_shelf` bit(1) NOT NULL,
                                    `pic` text  NULL,
                                    `price` decimal(10, 2) NULL DEFAULT NULL,
                                    `sale` int NOT NULL,
                                    `source` varchar(255)  NULL DEFAULT NULL,
                                    `stock` int NOT NULL,
                                    `type` varchar(255)  NULL DEFAULT NULL,
                                    `properties` text  NULL,
                                    `salable` bit(1) NOT NULL,
                                    `can_resale` bit(1) NOT NULL,
                                    `blind_box_id` bigint NULL DEFAULT NULL,
                                    `total` int NOT NULL,
                                    `royalties` int NOT NULL,
                                    `service_charge` int NOT NULL,
                                    `start_time` datetime NULL DEFAULT NULL,
                                    `owner` varchar(255)  NULL DEFAULT NULL,
                                    `owner_avatar` varchar(255)  NULL DEFAULT NULL,
                                    `owner_id` bigint NULL DEFAULT NULL,
                                    `category` varchar(255)  NULL DEFAULT NULL,
                                    `schedule_sale` bit(1) NOT NULL,
                                    `sort` int NOT NULL,
                                    `privileges` text  NULL,
                                    `asset_id` bigint NULL DEFAULT NULL,
                                    `current_number` int NULL DEFAULT NULL,
                                    `number` int NULL DEFAULT NULL,
                                    `original_price` decimal(19, 2) NULL DEFAULT NULL,
                                    `model3d` text  NULL,
                                    `project_id` int NOT NULL,
                                    `pic_pattern` varchar(255)  NULL DEFAULT NULL,
                                    `categories` varchar(255)  NULL DEFAULT NULL,
                                    `collection_category_id` bigint NULL DEFAULT NULL,
                                    `limit_buy_count` int NULL DEFAULT NULL,
                                    `variable_collection_id` bigint NULL DEFAULT NULL,
                                    `variable_type` bit(1) NOT NULL,
                                    PRIMARY KEY (`id`) USING BTREE,
                                    INDEX `IDXe68e3dajiefqmfc0jmvvt9l7g`(`type`, `source`) USING BTREE,
                                    INDEX `IDXemw5rwa38vgrskx1b166mveh3`(`minter_id`) USING BTREE,
                                    INDEX `IDX9cqxsb7x36cqj2cxu2l3kk77o`(`on_shelf`) USING BTREE,
                                    INDEX `IDXni57xpcx1cnw1mcfxks7kljcq`(`owner_id`) USING BTREE,
                                    INDEX `IDXjghwfjav02axd296ug2bbekxk`(`asset_id`) USING BTREE,
                                    INDEX `FKqmc45wlywxqeegk6f8v9kunhe`(`collection_category_id`) USING BTREE,
                                    CONSTRAINT `FKqmc45wlywxqeegk6f8v9kunhe` FOREIGN KEY (`collection_category_id`) REFERENCES `collection_category` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of collection_info
-- ----------------------------

-- ----------------------------
-- Table structure for commission_record
-- ----------------------------

CREATE TABLE `commission_record`  (
                                      `id` bigint NOT NULL,
                                      `created_at` datetime NULL DEFAULT NULL,
                                      `created_by` varchar(255)  NULL DEFAULT NULL,
                                      `del` bit(1) NOT NULL,
                                      `modified_at` datetime NULL DEFAULT NULL,
                                      `modified_by` varchar(255)  NULL DEFAULT NULL,
                                      `nickname` varchar(255)  NULL DEFAULT NULL,
                                      `order_id` bigint NULL DEFAULT NULL,
                                      `phone` varchar(255)  NULL DEFAULT NULL,
                                      `share_amount` decimal(19, 2) NULL DEFAULT NULL,
                                      `share_ratio` decimal(19, 2) NULL DEFAULT NULL,
                                      `total_price` decimal(19, 2) NULL DEFAULT NULL,
                                      `user_id` bigint NULL DEFAULT NULL,
                                      PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of commission_record
-- ----------------------------

-- ----------------------------
-- Table structure for coupon
-- ----------------------------

CREATE TABLE `coupon`  (
                           `id` bigint NOT NULL,
                           `created_at` datetime NULL DEFAULT NULL,
                           `created_by` varchar(255)  NULL DEFAULT NULL,
                           `del` bit(1) NOT NULL,
                           `modified_at` datetime NULL DEFAULT NULL,
                           `modified_by` varchar(255)  NULL DEFAULT NULL,
                           `collection_ids` text  NULL,
                           `expiration` datetime NULL DEFAULT NULL,
                           `limited` bit(1) NOT NULL,
                           `name` varchar(255)  NULL DEFAULT NULL,
                           `need_gas` bit(1) NOT NULL,
                           `remark` varchar(255)  NULL DEFAULT NULL,
                           `project_id` int NOT NULL,
                           PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of coupon
-- ----------------------------

-- ----------------------------
-- Table structure for district
-- ----------------------------

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

-- ----------------------------
-- Records of district
-- ----------------------------

-- ----------------------------
-- Table structure for div_money
-- ----------------------------

CREATE TABLE `div_money`  (
                              `id` bigint NOT NULL,
                              `created_at` datetime NULL DEFAULT NULL,
                              `created_by` varchar(255)  NULL DEFAULT NULL,
                              `del` bit(1) NOT NULL,
                              `modified_at` datetime NULL DEFAULT NULL,
                              `modified_by` varchar(255)  NULL DEFAULT NULL,
                              `amount` decimal(10, 2) NULL DEFAULT NULL,
                              `fee_flag` bit(1) NOT NULL,
                              `member_id` varchar(255)  NULL DEFAULT NULL,
                              `order_id` bigint NOT NULL,
                              `ratio` int NULL DEFAULT NULL,
                              `rest_amount` decimal(10, 2) NULL DEFAULT NULL,
                              `status` varchar(255)  NULL DEFAULT NULL,
                              `total_amount` decimal(10, 2) NULL DEFAULT NULL,
                              `user_id` bigint NULL DEFAULT NULL,
                              `process_time` datetime NULL DEFAULT NULL,
                              `transfer_money_id` bigint NULL DEFAULT NULL,
                              `transfer_result` varchar(255)  NULL DEFAULT NULL,
                              `order_amount` decimal(10, 2) NULL DEFAULT NULL,
                              `pay_platform` varchar(255)  NULL DEFAULT NULL,
                              `third_account_id` varchar(255)  NULL DEFAULT NULL,
                              `user_fund_account_id` bigint NULL DEFAULT NULL,
                              PRIMARY KEY (`id`) USING BTREE,
                              INDEX `IDXg84omvvl6eysqoi1i1l7n089f`(`user_id`) USING BTREE,
                              INDEX `IDXgi6jes62mg7i6hp7mw4e2j17y`(`order_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of div_money
-- ----------------------------

-- ----------------------------
-- Table structure for error_order
-- ----------------------------

CREATE TABLE `error_order`  (
                                `id` bigint NOT NULL,
                                `created_at` datetime NULL DEFAULT NULL,
                                `created_by` varchar(255)  NULL DEFAULT NULL,
                                `del` bit(1) NOT NULL,
                                `modified_at` datetime NULL DEFAULT NULL,
                                `modified_by` varchar(255)  NULL DEFAULT NULL,
                                `error_message` varchar(255)  NULL DEFAULT NULL,
                                `order_id` bigint NULL DEFAULT NULL,
                                `pay_method` int NULL DEFAULT NULL,
                                `transaction_id` varchar(255)  NULL DEFAULT NULL,
                                `type` varchar(255)  NULL DEFAULT NULL,
                                PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of error_order
-- ----------------------------

-- ----------------------------
-- Table structure for exception_log
-- ----------------------------

CREATE TABLE `exception_log`  (
                                  `id` bigint NOT NULL,
                                  `description` varchar(255)  NULL DEFAULT NULL,
                                  `message` longtext  NULL,
                                  `name` varchar(255)  NULL DEFAULT NULL,
                                  `req_ip` varchar(255)  NULL DEFAULT NULL,
                                  `req_method` varchar(255)  NULL DEFAULT NULL,
                                  `req_params` longtext  NULL,
                                  `req_url` varchar(255)  NULL DEFAULT NULL,
                                  `resp` longtext  NULL,
                                  `stack_trace` longtext  NULL,
                                  `time` datetime NULL DEFAULT NULL,
                                  `type` varchar(255)  NULL DEFAULT NULL,
                                  `user_id` varchar(255)  NULL DEFAULT NULL,
                                  `username` varchar(255)  NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of exception_log
-- ----------------------------

-- ----------------------------
-- Table structure for follow
-- ----------------------------

CREATE TABLE `follow`  (
                           `id` bigint NOT NULL,
                           `created_at` datetime NULL DEFAULT NULL,
                           `created_by` varchar(255)  NULL DEFAULT NULL,
                           `del` bit(1) NOT NULL,
                           `modified_at` datetime NULL DEFAULT NULL,
                           `modified_by` varchar(255)  NULL DEFAULT NULL,
                           `follow_user_id` bigint NULL DEFAULT NULL,
                           `user_id` bigint NULL DEFAULT NULL,
                           PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of follow
-- ----------------------------

-- ----------------------------
-- Table structure for gift_order
-- ----------------------------

CREATE TABLE `gift_order`  (
                               `id` bigint NOT NULL,
                               `created_at` datetime NULL DEFAULT NULL,
                               `created_by` varchar(255)  NULL DEFAULT NULL,
                               `del` bit(1) NOT NULL,
                               `modified_at` datetime NULL DEFAULT NULL,
                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                               `asset_id` bigint NULL DEFAULT NULL,
                               `block_number` decimal(19, 2) NULL DEFAULT NULL,
                               `cancel_time` datetime NULL DEFAULT NULL,
                               `gas_price` decimal(10, 2) NULL DEFAULT NULL,
                               `gas_used` decimal(19, 2) NULL DEFAULT NULL,
                               `pay_method` varchar(255)  NULL DEFAULT NULL,
                               `pay_time` datetime NULL DEFAULT NULL,
                               `status` int NULL DEFAULT NULL,
                               `to_user_id` bigint NULL DEFAULT NULL,
                               `transaction_id` varchar(255)  NULL DEFAULT NULL,
                               `tx_hash` varchar(255)  NULL DEFAULT NULL,
                               `user_id` bigint NULL DEFAULT NULL,
                               `collection_id` bigint NULL DEFAULT NULL,
                               `name` varchar(255)  NULL DEFAULT NULL,
                               `project_id` int NOT NULL,
                               `order_no` varchar(255)  NULL DEFAULT NULL,
                               `ip` varchar(255)  NULL DEFAULT NULL,
                               PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of gift_order
-- ----------------------------

-- ----------------------------
-- Table structure for guid_package
-- ----------------------------

CREATE TABLE `guid_package`  (
                                 `id` bigint NOT NULL,
                                 `created_at` datetime NULL DEFAULT NULL,
                                 `created_by` varchar(255)  NULL DEFAULT NULL,
                                 `modified_at` datetime NULL DEFAULT NULL,
                                 `modified_by` varchar(255)  NULL DEFAULT NULL,
                                 `name` varchar(255)  NULL DEFAULT NULL,
                                 `price` decimal(10, 2) NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of guid_package
-- ----------------------------

-- ----------------------------
-- Table structure for guide
-- ----------------------------

CREATE TABLE `guide`  (
                          `id` bigint NOT NULL,
                          `created_at` datetime NULL DEFAULT NULL,
                          `created_by` varchar(255)  NULL DEFAULT NULL,
                          `modified_at` datetime NULL DEFAULT NULL,
                          `modified_by` varchar(255)  NULL DEFAULT NULL,
                          `pic` varchar(255)  NULL DEFAULT NULL,
                          `sort` int NOT NULL,
                          `text` text  NULL,
                          `type` varchar(255)  NULL DEFAULT NULL,
                          `video` varchar(255)  NULL DEFAULT NULL,
                          `voice` varchar(255)  NULL DEFAULT NULL,
                          PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of guide
-- ----------------------------

-- ----------------------------
-- Table structure for hibernate_sequence
-- ----------------------------

CREATE TABLE `hibernate_sequence`  (
    `next_val` bigint NULL DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of hibernate_sequence
-- ----------------------------
INSERT INTO `hibernate_sequence` VALUES (2910579);
INSERT INTO `hibernate_sequence` VALUES (2910579);
INSERT INTO `hibernate_sequence` VALUES (2910579);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);
INSERT INTO `hibernate_sequence` VALUES (1);

-- ----------------------------
-- Table structure for identity_auth
-- ----------------------------

CREATE TABLE `identity_auth`  (
                                  `id` bigint NOT NULL,
                                  `created_at` datetime NULL DEFAULT NULL,
                                  `created_by` varchar(255)  NULL DEFAULT NULL,
                                  `del` bit(1) NOT NULL,
                                  `modified_at` datetime NULL DEFAULT NULL,
                                  `modified_by` varchar(255)  NULL DEFAULT NULL,
                                  `email` varchar(255)  NULL DEFAULT NULL,
                                  `id_back` varchar(255)  NULL DEFAULT NULL,
                                  `id_front` varchar(255)  NULL DEFAULT NULL,
                                  `id_no` varchar(255)  NULL DEFAULT NULL,
                                  `phone` varchar(255)  NULL DEFAULT NULL,
                                  `real_name` varchar(255)  NULL DEFAULT NULL,
                                  `status` varchar(255)  NULL DEFAULT NULL,
                                  `user_id` bigint NULL DEFAULT NULL,
                                  `org` bit(1) NOT NULL,
                                  `org_license` varchar(255)  NULL DEFAULT NULL,
                                  `org_license_expire` varchar(255)  NULL DEFAULT NULL,
                                  `org_name` varchar(255)  NULL DEFAULT NULL,
                                  `org_no` varchar(255)  NULL DEFAULT NULL,
                                  `id_end_date` date NULL DEFAULT NULL,
                                  `id_start_date` date NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`) USING BTREE,
                                  INDEX `idx_userid`(`user_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of identity_auth
-- ----------------------------

-- ----------------------------
-- Table structure for invite
-- ----------------------------

CREATE TABLE `invite`  (
                           `id` bigint NOT NULL,
                           `created_at` datetime NULL DEFAULT NULL,
                           `created_by` varchar(255)  NULL DEFAULT NULL,
                           `del` bit(1) NOT NULL,
                           `modified_at` datetime NULL DEFAULT NULL,
                           `modified_by` varchar(255)  NULL DEFAULT NULL,
                           `code` varchar(255)  NULL DEFAULT NULL,
                           `invite_num` int NOT NULL,
                           `name` varchar(255)  NULL DEFAULT NULL,
                           `phone` varchar(255)  NULL DEFAULT NULL,
                           `remark` varchar(255)  NULL DEFAULT NULL,
                           PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of invite
-- ----------------------------

-- ----------------------------
-- Table structure for invite_date
-- ----------------------------

CREATE TABLE `invite_date`  (
                                `id` bigint NOT NULL,
                                `created_at` datetime NULL DEFAULT NULL,
                                `created_by` varchar(255)  NULL DEFAULT NULL,
                                `del` bit(1) NOT NULL,
                                `modified_at` datetime NULL DEFAULT NULL,
                                `modified_by` varchar(255)  NULL DEFAULT NULL,
                                `activity_id` bigint NULL DEFAULT NULL,
                                `air_drop_award` int NOT NULL,
                                `automatic_rewards` bit(1) NOT NULL,
                                `by_invite_prize` text  NULL,
                                `invite_prize_list` text  NULL,
                                `invitee_user_id` bigint NULL DEFAULT NULL,
                                `inviter_phone` varchar(255)  NULL DEFAULT NULL,
                                `inviter_user_id` bigint NULL DEFAULT NULL,
                                `name` varchar(255)  NULL DEFAULT NULL,
                                `remark` varchar(255)  NULL DEFAULT NULL,
                                `status` int NOT NULL,
                                PRIMARY KEY (`id`) USING BTREE,
                                INDEX `IDXshlxc528pkxkcpvepnvctbe5h`(`activity_id`) USING BTREE,
                                INDEX `IDX4pn4g9thbds7f312pmvn1be4t`(`inviter_user_id`) USING BTREE,
                                INDEX `IDXcn9grsrdjmjdu9sqde5rne80h`(`automatic_rewards`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of invite_date
-- ----------------------------

-- ----------------------------
-- Table structure for like_info
-- ----------------------------

CREATE TABLE `like_info`  (
                              `id` bigint NOT NULL,
                              `created_at` datetime NULL DEFAULT NULL,
                              `created_by` varchar(255)  NULL DEFAULT NULL,
                              `del` bit(1) NOT NULL,
                              `modified_at` datetime NULL DEFAULT NULL,
                              `modified_by` varchar(255)  NULL DEFAULT NULL,
                              `collection_id` bigint NULL DEFAULT NULL,
                              `user_id` bigint NULL DEFAULT NULL,
                              PRIMARY KEY (`id`) USING BTREE,
                              INDEX `IDXpca5elfm2bntg0a7n6wtk09uk`(`user_id`) USING BTREE,
                              INDEX `IDXosauimvwrf686ni346rsvllur`(`collection_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of like_info
-- ----------------------------

-- ----------------------------
-- Table structure for login_log
-- ----------------------------

CREATE TABLE `login_log`  (
                              `id` bigint NOT NULL,
                              `created_at` datetime NULL DEFAULT NULL,
                              `created_by` varchar(255)  NULL DEFAULT NULL,
                              `del` bit(1) NOT NULL,
                              `modified_at` datetime NULL DEFAULT NULL,
                              `modified_by` varchar(255)  NULL DEFAULT NULL,
                              `browser` varchar(255)  NULL DEFAULT NULL,
                              `client_type` varchar(255)  NULL DEFAULT NULL,
                              `ip_address` varchar(255)  NULL DEFAULT NULL,
                              `login_success` bit(1) NOT NULL,
                              `login_time` datetime NULL DEFAULT NULL,
                              `login_type` varchar(255)  NULL DEFAULT NULL,
                              `os` varchar(255)  NULL DEFAULT NULL,
                              `phone` varchar(255)  NULL DEFAULT NULL,
                              `user_id` bigint NULL DEFAULT NULL,
                              PRIMARY KEY (`id`) USING BTREE,
                              INDEX `IDXt9ufvgoi0e1n92n695khl0p2c`(`user_id`) USING BTREE,
                              INDEX `IDXq9e7sxajk53cm6yap2riknj5s`(`phone`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of login_log
-- ----------------------------

-- ----------------------------
-- Table structure for menu
-- ----------------------------

CREATE TABLE `menu`  (
                         `id` bigint NOT NULL,
                         `created_at` datetime NULL DEFAULT NULL,
                         `created_by` varchar(255)  NULL DEFAULT NULL,
                         `modified_at` datetime NULL DEFAULT NULL,
                         `modified_by` varchar(255)  NULL DEFAULT NULL,
                         `active` bit(1) NULL DEFAULT NULL,
                         `enabled` bit(1) NULL DEFAULT NULL,
                         `icon` varchar(255)  NULL DEFAULT NULL,
                         `name` varchar(255)  NULL DEFAULT NULL,
                         `parent` bigint NULL DEFAULT NULL,
                         `path` varchar(255)  NULL DEFAULT NULL,
                         `root` bit(1) NULL DEFAULT NULL,
                         `sort` int NULL DEFAULT NULL,
                         `category` varchar(255)  NULL DEFAULT NULL,
                         `del` bit(1) NOT NULL,
                         PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (3, NULL, NULL, '2021-10-29 14:30:29', '管理员01(724)', b'0', b'1', 'fas fa-desktop', '开发', 2, '', b'1', 15, '开发', 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, '2022-05-07 13:58:20', 'guangsheng(2645288)', b'1', b'1', 'fas fa-user', '用户管理', 2, '', b'1', 14, '用户', 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, '2022-05-07 14:09:12', 'guangsheng(2645288)', b'1', b'1', 'fas fa-cog', '配置', 2, '', b'1', 63, '系统', 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');
INSERT INTO `menu` VALUES (16, '2021-10-11 11:10:36', NULL, '2022-05-07 13:56:57', 'guangsheng(2645288)', b'0', NULL, 'fas fa-gift', '藏品管理', NULL, '/collectionList', b'1', 3, '', b'0');
INSERT INTO `menu` VALUES (17, '2021-10-11 11:13:02', NULL, '2022-05-07 14:09:24', 'guangsheng(2645288)', b'1', NULL, 'fas fa-bars', '订单管理', NULL, '', b'1', 4, NULL, b'0');
INSERT INTO `menu` VALUES (18, '2021-10-11 11:22:18', NULL, '2022-05-07 13:58:35', 'guangsheng(2645288)', b'0', NULL, 'fas fa-hammer', '铸造者', NULL, '/minterList', b'1', 13, '', b'0');
INSERT INTO `menu` VALUES (31, '2021-10-13 10:07:58', NULL, '2022-05-07 13:58:40', 'guangsheng(2645288)', b'0', NULL, 'fas fa-address-card', '实名审核', NULL, '/identityAuthList', b'1', 19, NULL, b'0');
INSERT INTO `menu` VALUES (52, '2021-10-14 16:48:39', NULL, '2022-05-07 14:07:29', 'guangsheng(2645288)', b'0', NULL, 'fas fa-images', '轮播图', NULL, '/bannerList', b'1', 20, NULL, b'0');
INSERT INTO `menu` VALUES (197, '2021-10-21 11:06:24', NULL, '2022-05-07 13:57:02', 'guangsheng(2645288)', b'0', NULL, 'fas fa-box-open', '盲盒', NULL, '/blindBoxList', b'1', 10, '', b'0');
INSERT INTO `menu` VALUES (875, '2021-10-29 14:31:18', '管理员01(724)', '2021-10-29 14:31:18', '管理员01(724)', b'1', NULL, '', '账号管理', 9, '/adminList', b'0', 16, NULL, b'0');
INSERT INTO `menu` VALUES (937, '2021-11-01 13:25:17', NULL, '2021-11-11 15:49:49', '管理员(1)', b'0', NULL, 'fas fa-bars', '普通管理员', NULL, '', b'1', 17, NULL, b'0');
INSERT INTO `menu` VALUES (1083, '2021-11-02 15:25:23', '管理员01(724)', '2021-11-02 15:25:23', '管理员01(724)', b'1', NULL, '', '特权配置', 9, '/privilegeOptionList', b'0', 18, NULL, b'0');
INSERT INTO `menu` VALUES (1582, '2021-11-11 15:49:34', NULL, '2021-11-11 15:50:24', '管理员(1)', b'0', NULL, 'fas fa-parachute-box', '空投', NULL, '/airDropList', b'1', 14, NULL, b'0');
INSERT INTO `menu` VALUES (1583, '2021-11-11 15:51:05', NULL, '2022-05-07 13:57:06', 'guangsheng(2645288)', b'0', NULL, 'fas fa-parachute-box', '空投', NULL, '/airDropList', b'1', 11, NULL, b'0');
INSERT INTO `menu` VALUES (1597, '2021-11-11 18:06:10', NULL, '2022-05-07 13:57:09', 'guangsheng(2645288)', b'0', NULL, 'fas fa-sticky-note', '兑换券', NULL, '/couponList', b'1', 12, '', b'0');
INSERT INTO `menu` VALUES (4396, '2021-11-19 21:04:28', NULL, '2022-05-07 14:06:22', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '分销统计', NULL, '/commissionRecordList', b'1', 21, NULL, b'0');
INSERT INTO `menu` VALUES (4614, '2021-11-23 14:41:27', NULL, '2022-05-07 14:07:34', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '首页推荐', NULL, '/recommendList', b'1', 22, NULL, b'0');
INSERT INTO `menu` VALUES (81707, '2022-01-20 09:42:36', NULL, '2022-05-07 13:59:44', 'guangsheng(2645288)', b'1', NULL, 'fas fa-bars', '活动管理', NULL, '', b'1', 23, NULL, b'0');
INSERT INTO `menu` VALUES (571073, '2022-01-26 17:54:12', NULL, '2022-01-26 17:55:09', '管理员(79227)', b'0', NULL, '', '官方订单', 17, '/orderList', b'0', 24, NULL, b'0');
INSERT INTO `menu` VALUES (571076, '2022-01-26 17:54:27', NULL, '2022-01-26 17:55:12', '管理员(79227)', b'0', NULL, '', '二手订单', 17, '/orderUsedList', b'0', 25, NULL, b'0');
INSERT INTO `menu` VALUES (571082, '2022-01-26 17:54:49', NULL, '2022-01-26 17:55:14', '管理员(79227)', b'0', NULL, '', '转赠订单', 17, '/giftOrderList', b'0', 26, NULL, b'0');
INSERT INTO `menu` VALUES (571217, '2022-01-26 18:05:41', NULL, '2022-01-27 10:01:00', '管理员(79227)', b'1', NULL, '', '官方订单', 17, '/orderList', b'0', 27, NULL, b'0');
INSERT INTO `menu` VALUES (571220, '2022-01-26 18:06:05', NULL, '2022-01-27 10:01:04', '管理员(79227)', b'1', NULL, '', '二手订单', 17, '/orderUsedList', b'0', 28, NULL, b'0');
INSERT INTO `menu` VALUES (571225, '2022-01-26 18:06:32', NULL, '2022-01-26 18:08:40', '管理员(79227)', b'1', NULL, '', '转赠订单', 17, '/giftOrderList', b'0', 29, NULL, b'0');
INSERT INTO `menu` VALUES (1234589, '2022-03-02 12:07:32', 'admin(1866)', '2022-03-02 12:07:32', 'admin(1866)', b'1', NULL, '', '支付通道配置', 9, '/adapayMerchantList', b'0', 30, NULL, b'0');
INSERT INTO `menu` VALUES (2020975, '2022-03-25 19:14:02', NULL, '2022-05-07 14:00:58', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '收集活动', NULL, '/activityCollectionList', b'1', 31, NULL, b'0');
INSERT INTO `menu` VALUES (2644274, '2022-04-26 21:18:34', NULL, '2022-05-07 14:06:14', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '支付信息记录', NULL, '/paymentInfoList', b'1', 38, NULL, b'0');
INSERT INTO `menu` VALUES (2644275, '2022-04-26 21:19:00', NULL, '2022-05-07 14:06:16', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '分账信息记录', NULL, '/divMoneyList', b'1', 40, NULL, b'0');
INSERT INTO `menu` VALUES (2644321, '2022-04-27 17:46:26', NULL, '2022-05-07 14:04:19', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '优先购', NULL, '', b'1', 34, NULL, b'0');
INSERT INTO `menu` VALUES (2644322, '2022-04-27 17:46:47', '管理员(1)', '2022-04-27 17:46:47', '管理员(1)', b'1', NULL, '', '活动配置', 2644321, '/preemptionList', b'0', 35, NULL, b'0');
INSERT INTO `menu` VALUES (2644323, '2022-04-27 17:47:04', '管理员(1)', '2022-04-27 17:47:04', '管理员(1)', b'1', NULL, '', '白名单', 2644321, '/preemptionWhiteList', b'0', 36, NULL, b'0');
INSERT INTO `menu` VALUES (2644438, '2022-04-28 10:55:58', '管理员(1)', '2022-04-28 10:55:58', '管理员(1)', b'1', NULL, '', '项目管理', 9, '/projectList', b'0', 37, NULL, b'0');
INSERT INTO `menu` VALUES (2644682, '2022-04-28 21:51:35', NULL, '2022-05-07 14:09:34', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '项目管理', NULL, '/projectList', b'1', 32, NULL, b'0');
INSERT INTO `menu` VALUES (2644683, '2022-04-28 21:52:45', NULL, '2022-04-28 21:53:43', 'bx(2644677)', b'0', NULL, 'fas fa-bars', '项目管理', NULL, '/projectList', b'1', 39, NULL, b'0');
INSERT INTO `menu` VALUES (2646022, '2022-05-05 18:08:30', NULL, '2022-05-07 14:06:18', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '资产售卖限制', NULL, '/assetSellLimitList', b'1', 41, NULL, b'0');
INSERT INTO `menu` VALUES (2646112, '2022-05-06 14:50:22', NULL, '2022-05-07 14:04:13', 'guangsheng(2645288)', b'0', NULL, 'fas fa-bars', '惊喜盒子', NULL, '', b'1', 33, NULL, b'0');
INSERT INTO `menu` VALUES (2646113, '2022-05-06 14:55:18', NULL, '2022-05-06 15:01:50', 'guangsheng(2645288)', b'1', NULL, '', '活动配置', 2646112, '/surpriseBoxList', b'0', 42, NULL, b'0');
INSERT INTO `menu` VALUES (2646180, '2022-05-07 13:18:11', 'guangsheng(2645288)', '2022-05-07 13:18:11', 'guangsheng(2645288)', b'1', NULL, '', '中奖名单', 2646112, '/supBoxList', b'0', 43, NULL, b'0');
INSERT INTO `menu` VALUES (2646250, '2022-05-07 13:54:06', NULL, '2022-05-07 13:54:57', 'guangsheng(2645288)', b'1', NULL, 'fas fa-bars', '藏品管理', NULL, '', b'1', 2, NULL, b'0');
INSERT INTO `menu` VALUES (2646251, '2022-05-07 13:55:19', NULL, '2022-05-24 16:15:14', 'a*01(2644858)', b'1', NULL, '', '藏品', 2646250, '/collectionList', b'0', 45, NULL, b'0');
INSERT INTO `menu` VALUES (2646252, '2022-05-07 13:55:34', NULL, '2022-05-24 16:15:14', 'a*01(2644858)', b'1', NULL, '', '盲盒', 2646250, '/blindBoxList', b'0', 46, NULL, b'0');
INSERT INTO `menu` VALUES (2646253, '2022-05-07 13:55:58', 'guangsheng(2645288)', '2022-05-07 13:55:58', 'guangsheng(2645288)', b'1', NULL, '', '空投', 2646250, '/airDropList', b'0', 47, NULL, b'0');
INSERT INTO `menu` VALUES (2646254, '2022-05-07 13:56:10', 'guangsheng(2645288)', '2022-05-07 13:56:10', 'guangsheng(2645288)', b'1', NULL, '', '兑换卷', 2646250, 'couponList', b'0', 48, NULL, b'0');
INSERT INTO `menu` VALUES (2646255, '2022-05-07 13:57:38', 'guangsheng(2645288)', '2022-05-07 13:57:38', 'guangsheng(2645288)', b'1', NULL, '', '铸造者', 6, '/minterList', b'0', 49, NULL, b'0');
INSERT INTO `menu` VALUES (2646256, '2022-05-07 13:57:54', 'guangsheng(2645288)', '2022-05-07 13:57:54', 'guangsheng(2645288)', b'1', NULL, '', '实名审核', 6, '/identityAuthList', b'0', 50, NULL, b'0');
INSERT INTO `menu` VALUES (2646257, '2022-05-07 13:58:10', 'guangsheng(2645288)', '2022-05-07 13:58:10', 'guangsheng(2645288)', b'1', NULL, '', '用户', 6, '/userList', b'0', 51, NULL, b'0');
INSERT INTO `menu` VALUES (2646258, '2022-05-07 13:59:32', NULL, '2022-05-13 18:11:07', '*(2647152)', b'1', NULL, '', '邀请管理', 81707, '/inviteList', b'0', 53, NULL, b'0');
INSERT INTO `menu` VALUES (2646259, '2022-05-07 13:59:58', NULL, '2022-05-13 18:11:06', '*(2647152)', b'1', NULL, '', '收集活动', 81707, '/activityCollectionList', b'0', 54, NULL, b'0');
INSERT INTO `menu` VALUES (2646260, '2022-05-07 14:01:08', NULL, '2022-05-13 18:11:04', '*(2647152)', b'1', NULL, '', '优先购', 81707, '/preemptionList', b'0', 55, NULL, b'0');
INSERT INTO `menu` VALUES (2646261, '2022-05-07 14:01:13', NULL, '2022-05-13 18:11:03', '*(2647152)', b'1', NULL, '', '惊喜盒子', 81707, '/surpriseBoxList', b'0', 56, NULL, b'0');
INSERT INTO `menu` VALUES (2646262, '2022-05-07 14:02:34', NULL, '2022-05-13 18:11:01', '*(2647152)', b'1', NULL, '', '中奖名单', 81707, '/supBoxList', b'0', 57, NULL, b'0');
INSERT INTO `menu` VALUES (2646263, '2022-05-07 14:04:07', NULL, '2022-05-13 18:11:00', '*(2647152)', b'1', NULL, '', '白名单', 81707, '/preemptionWhiteList', b'0', 68, NULL, b'0');
INSERT INTO `menu` VALUES (2646264, '2022-05-07 14:04:31', NULL, '2022-05-07 14:09:10', 'guangsheng(2645288)', b'1', NULL, 'fas fa-bars', '统计管理', NULL, '', b'1', 44, NULL, b'0');
INSERT INTO `menu` VALUES (2646265, '2022-05-07 14:04:50', NULL, '2022-06-08 13:57:05', 'oujihong(2644265)', b'1', NULL, '', '分销统计', 2646264, '/commissionRecordList', b'0', 60, NULL, b'0');
INSERT INTO `menu` VALUES (2646266, '2022-05-07 14:05:15', NULL, '2022-06-08 13:57:02', 'oujihong(2644265)', b'1', NULL, '', '支付信息记录', 2646264, '/paymentInfoList', b'0', 61, NULL, b'0');
INSERT INTO `menu` VALUES (2646267, '2022-05-07 14:05:54', NULL, '2022-06-08 13:56:58', 'oujihong(2644265)', b'1', NULL, '', '分账信息记录', 2646264, '/divMoneyList', b'0', 62, NULL, b'0');
INSERT INTO `menu` VALUES (2646268, '2022-05-07 14:06:10', NULL, '2022-06-08 13:57:05', 'oujihong(2644265)', b'1', NULL, '', '资产售卖限制', 2646264, '/assetSellLimitList', b'0', 59, NULL, b'0');
INSERT INTO `menu` VALUES (2646269, '2022-05-07 14:06:39', NULL, '2022-05-07 14:09:12', 'guangsheng(2645288)', b'1', NULL, 'fas fa-bars', '首页管理', NULL, '', b'1', 58, NULL, b'0');
INSERT INTO `menu` VALUES (2646270, '2022-05-07 14:06:56', 'guangsheng(2645288)', '2022-05-07 14:06:56', 'guangsheng(2645288)', b'1', NULL, '', '轮播图', 2646269, '/bannerList', b'0', 64, NULL, b'0');
INSERT INTO `menu` VALUES (2646271, '2022-05-07 14:07:10', 'guangsheng(2645288)', '2022-05-07 14:07:10', 'guangsheng(2645288)', b'1', NULL, '', '首页推荐', 2646269, '/recommendList', b'0', 65, NULL, b'0');
INSERT INTO `menu` VALUES (2646272, '2022-05-07 14:15:02', 'guangsheng(2645288)', '2022-05-07 14:15:02', 'guangsheng(2645288)', b'1', NULL, '', '银行卡', 6, '/cardInfoList', b'0', 66, NULL, b'0');
INSERT INTO `menu` VALUES (2646945, '2022-05-09 15:18:05', 'guangsheng(2645288)', '2022-05-09 15:18:05', 'guangsheng(2645288)', b'1', NULL, '', '分类', 2646250, '/collectionClassList', b'0', 67, NULL, b'0');
INSERT INTO `menu` VALUES (2647375, '2022-05-13 18:10:43', NULL, '2022-05-13 18:11:07', '*(2647152)', b'1', NULL, '', '邀请有礼', 81707, '/invitationList', b'0', 52, NULL, b'0');
INSERT INTO `menu` VALUES (2855588, '2022-05-18 19:30:26', '*(2647152)', '2022-05-18 19:30:26', '*(2647152)', b'1', NULL, '', '活动公告', 81707, '/activityList', b'0', 69, NULL, b'0');
INSERT INTO `menu` VALUES (2865564, '2022-05-27 16:04:34', 'oujihong(2644265)', '2022-05-27 16:04:34', 'oujihong(2644265)', b'1', NULL, '', '资产', 6, '/assetList', b'0', 70, NULL, b'0');
INSERT INTO `menu` VALUES (2905582, '2022-06-05 13:39:52', NULL, '2022-06-05 13:40:11', 'oujihong(2644265)', b'1', NULL, '', '转账记录', 2646264, 'transferMoneyInfoList', b'0', 71, NULL, b'0');
INSERT INTO `menu` VALUES (2905671, '2022-06-08 13:56:30', 'oujihong(2644265)', '2022-06-08 13:56:30', 'oujihong(2644265)', b'1', NULL, '', '充值记录', 2646264, '/rechargeOrderList', b'0', 72, NULL, b'0');
INSERT INTO `menu` VALUES (2905672, '2022-06-08 13:56:51', 'oujihong(2644265)', '2022-06-08 13:56:51', 'oujihong(2644265)', b'1', NULL, '', '提现记录', 2646264, '/withdrawApplyList', b'0', 73, NULL, b'0');

-- ----------------------------
-- Table structure for menu_authority
-- ----------------------------

CREATE TABLE `menu_authority`  (
                                   `menu_id` bigint NOT NULL,
                                   `authority` varchar(50)  NOT NULL,
                                   PRIMARY KEY (`menu_id`, `authority`) USING BTREE,
                                   INDEX `FKlj7sftrck7uk1kcjsy0doo56`(`authority`) USING BTREE,
                                   CONSTRAINT `FK4hopjqfvkhdagmk110y1jk17q` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
                                   CONSTRAINT `FKlj7sftrck7uk1kcjsy0doo56` FOREIGN KEY (`authority`) REFERENCES `authority` (`name`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of menu_authority
-- ----------------------------
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 (16, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (17, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (18, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (31, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (52, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (197, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (875, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (1083, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (1583, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (1597, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (4396, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (4614, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (81707, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (571073, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (571076, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (571082, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (571217, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (571220, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (571225, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (1234589, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2020975, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644274, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644275, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644321, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644322, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644323, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644438, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644682, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2644683, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646022, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646112, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646113, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646180, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646250, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646251, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646252, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646253, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646254, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646255, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646256, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646257, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646258, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646259, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646260, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646261, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646262, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646263, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646264, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646265, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646266, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646267, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646268, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646269, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646270, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646271, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646272, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2646945, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2647375, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2855588, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2865564, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2905582, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2905671, 'ROLE_ADMIN');
INSERT INTO `menu_authority` VALUES (2905672, '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');
INSERT INTO `menu_authority` VALUES (6, 'ROLE_OPERATOR');
INSERT INTO `menu_authority` VALUES (17, 'ROLE_OPERATOR');
INSERT INTO `menu_authority` VALUES (52, 'ROLE_OPERATOR');
INSERT INTO `menu_authority` VALUES (4614, 'ROLE_OPERATOR');
INSERT INTO `menu_authority` VALUES (571217, 'ROLE_OPERATOR');
INSERT INTO `menu_authority` VALUES (571220, 'ROLE_OPERATOR');
INSERT INTO `menu_authority` VALUES (571225, 'ROLE_OPERATOR');

-- ----------------------------
-- Table structure for operation_log
-- ----------------------------

CREATE TABLE `operation_log`  (
                                  `id` bigint NOT NULL,
                                  `description` varchar(255)  NULL DEFAULT NULL,
                                  `name` varchar(255)  NULL DEFAULT NULL,
                                  `req_ip` varchar(255)  NULL DEFAULT NULL,
                                  `req_method` varchar(255)  NULL DEFAULT NULL,
                                  `req_params` longtext  NULL,
                                  `req_url` varchar(255)  NULL DEFAULT NULL,
                                  `resp` longtext  NULL,
                                  `time` datetime NULL DEFAULT NULL,
                                  `type` varchar(255)  NULL DEFAULT NULL,
                                  `user_id` varchar(255)  NULL DEFAULT NULL,
                                  `username` varchar(255)  NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of operation_log
-- ----------------------------

-- ----------------------------
-- Table structure for order_info
-- ----------------------------

CREATE TABLE `order_info`  (
                               `id` bigint NOT NULL,
                               `created_at` datetime NULL DEFAULT NULL,
                               `created_by` varchar(255)  NULL DEFAULT NULL,
                               `del` bit(1) NOT NULL,
                               `modified_at` datetime NULL DEFAULT NULL,
                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                               `collection_id` bigint NULL DEFAULT NULL,
                               `gas_price` decimal(10, 2) NULL DEFAULT NULL,
                               `minter` varchar(255)  NULL DEFAULT NULL,
                               `minter_avatar` varchar(255)  NULL DEFAULT NULL,
                               `minter_id` bigint NULL DEFAULT NULL,
                               `name` varchar(255)  NULL DEFAULT NULL,
                               `pay_method` varchar(255)  NULL DEFAULT NULL,
                               `pay_time` datetime NULL DEFAULT NULL,
                               `pic` text  NULL,
                               `price` decimal(10, 2) NULL DEFAULT NULL,
                               `qty` int NOT NULL,
                               `status` varchar(255)  NULL DEFAULT NULL,
                               `total_price` decimal(10, 2) NULL DEFAULT NULL,
                               `transaction_id` varchar(255)  NULL DEFAULT NULL,
                               `tx_hash` varchar(255)  NULL DEFAULT NULL,
                               `user_id` bigint NULL DEFAULT NULL,
                               `address` varchar(255)  NULL DEFAULT NULL,
                               `contact_name` varchar(255)  NULL DEFAULT NULL,
                               `contact_phone` varchar(255)  NULL DEFAULT NULL,
                               `block_number` decimal(19, 2) NULL DEFAULT NULL,
                               `gas_used` decimal(19, 2) NULL DEFAULT NULL,
                               `properties` text  NULL,
                               `type` varchar(255)  NULL DEFAULT NULL,
                               `cancel_time` datetime NULL DEFAULT NULL,
                               `can_resale` bit(1) NOT NULL,
                               `detail` text  NULL,
                               `royalties` int NOT NULL,
                               `service_charge` int NOT NULL,
                               `category` varchar(255)  NULL DEFAULT NULL,
                               `asset_id` bigint NULL DEFAULT NULL,
                               `coupon_id` bigint NULL DEFAULT NULL,
                               `hide` bit(1) NOT NULL,
                               `invitor` bigint NULL DEFAULT NULL,
                               `privileges` text  NULL,
                               `win_collection_id` bigint NULL DEFAULT NULL,
                               `opened` bit(1) NOT NULL,
                               `project_id` int NOT NULL,
                               `source` varchar(255)  NULL DEFAULT NULL,
                               `order_no` varchar(255)  NULL DEFAULT NULL,
                               `ip` varchar(255)  NULL DEFAULT NULL,
                               `user_ware_house_id` bigint NULL DEFAULT NULL,
                               PRIMARY KEY (`id`) USING BTREE,
                               INDEX `IDX1eq7bqam0q1soixs07jckkwp4`(`user_id`) USING BTREE,
                               INDEX `IDXgag51j8ohmkek0ju4yvhnlwpo`(`status`) USING BTREE,
                               INDEX `IDX73e2rlkehwu4hy76kgy6gaa8h`(`asset_id`) USING BTREE,
                               INDEX `IDXj83h0tyxn0dl6ub5sh7496m8m`(`collection_id`) USING BTREE,
                               INDEX `IDX44qcfxauygckv35hagn5jrqds`(`transaction_id`) USING BTREE,
                               INDEX `IDXa3hnh7m7ke6b7p5g3hspr5ynx`(`minter_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of order_info
-- ----------------------------

-- ----------------------------
-- Table structure for parent
-- ----------------------------

CREATE TABLE `parent`  (
                           `id` bigint NOT NULL,
                           `created_at` datetime NULL DEFAULT NULL,
                           `created_by` varchar(255)  NULL DEFAULT NULL,
                           `modified_at` datetime NULL DEFAULT NULL,
                           `modified_by` varchar(255)  NULL DEFAULT NULL,
                           `parent_name` varchar(255)  NULL DEFAULT NULL,
                           PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of parent
-- ----------------------------

-- ----------------------------
-- Table structure for payment_info
-- ----------------------------

CREATE TABLE `payment_info`  (
                                 `id` bigint NOT NULL,
                                 `created_at` datetime NULL DEFAULT NULL,
                                 `created_by` varchar(255)  NULL DEFAULT NULL,
                                 `del` bit(1) NOT NULL,
                                 `modified_at` datetime NULL DEFAULT NULL,
                                 `modified_by` varchar(255)  NULL DEFAULT NULL,
                                 `gift_order_id` bigint NULL DEFAULT NULL,
                                 `goods_title` varchar(255)  NULL DEFAULT NULL,
                                 `merchant_name` varchar(255)  NULL DEFAULT NULL,
                                 `notify_time` datetime NULL DEFAULT NULL,
                                 `notify_url` varchar(500)  NULL DEFAULT NULL,
                                 `order_id` bigint NULL DEFAULT NULL,
                                 `order_no` varchar(255)  NULL DEFAULT NULL,
                                 `pay_amt` varchar(255)  NULL DEFAULT NULL,
                                 `pay_channel` varchar(255)  NULL DEFAULT NULL,
                                 `pay_method` varchar(255)  NULL DEFAULT NULL,
                                 `status` varchar(255)  NULL DEFAULT NULL,
                                 `time_expire` varchar(255)  NULL DEFAULT NULL,
                                 `user_id` bigint NULL DEFAULT NULL,
                                 `pay_platform` varchar(255)  NULL DEFAULT NULL,
                                 `transaction_id` varchar(255)  NULL DEFAULT NULL,
                                 `apply_refund_time` datetime NULL DEFAULT NULL,
                                 `pay_time` datetime NULL DEFAULT NULL,
                                 `project_id` int NULL DEFAULT NULL,
                                 `refund_no` varchar(255)  NULL DEFAULT NULL,
                                 `refund_reason` varchar(255)  NULL DEFAULT NULL,
                                 `refund_time` datetime NULL DEFAULT NULL,
                                 `third_pay_no` varchar(255)  NULL DEFAULT NULL,
                                 `token` varchar(255)  NULL DEFAULT NULL,
                                 `user_bank_card_id` bigint NULL DEFAULT NULL,
                                 `user_fund_account_id` bigint NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`) USING BTREE,
                                 UNIQUE INDEX `UK2q5usiexs07x8np55d83srnlh`(`order_no`) USING BTREE,
                                 INDEX `IDXqreu0jsolb8hwej2ffjsnwi1`(`order_id`) USING BTREE,
                                 INDEX `IDXb6bvv3fhne61weixp3i0847f`(`gift_order_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of payment_info
-- ----------------------------

-- ----------------------------
-- Table structure for privilege_option
-- ----------------------------

CREATE TABLE `privilege_option`  (
                                     `id` bigint NOT NULL,
                                     `created_at` datetime NULL DEFAULT NULL,
                                     `created_by` varchar(255)  NULL DEFAULT NULL,
                                     `del` bit(1) NOT NULL,
                                     `modified_at` datetime NULL DEFAULT NULL,
                                     `modified_by` varchar(255)  NULL DEFAULT NULL,
                                     `description` varchar(255)  NULL DEFAULT NULL,
                                     `icon` text  NULL,
                                     `name` varchar(255)  NULL DEFAULT NULL,
                                     `once` bit(1) NOT NULL,
                                     `refresh_on_transfer` bit(1) NOT NULL,
                                     `type` varchar(255)  NULL DEFAULT NULL,
                                     PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of privilege_option
-- ----------------------------
INSERT INTO `privilege_option` VALUES (1089, '2021-11-02 16:57:07', '管理员01(724)', b'0', '2021-11-12 14:52:24', '管理员(1)', '该特权将证明购买者拥有该作品版权使用权利', 'https://cosmoscdn.9space.vip/image/2021-11-12-14-51-44tXFJdJCy.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-51-49ZqLbgbvh.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-52-10sqevVZup.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-52-22BANGuzNs.png', '版权权利', b'0', b'0', 'text');
INSERT INTO `privilege_option` VALUES (1090, '2021-11-02 16:57:32', '管理员01(724)', b'1', '2021-11-09 14:55:30', '管理员(1)', '里面藏有创作者填写的隐藏内容，持有者才能打开查看', 'https://cosmoscdn.9space.vip/image/2021-11-02-16-57-31irTscxGK.svg', '加密空间', b'1', b'0', 'text');
INSERT INTO `privilege_option` VALUES (1353, '2021-11-09 15:15:33', '管理员(1)', b'0', '2022-02-18 17:38:39', '第九空间01(4156)', '该作品拥有唯一的二维码，创作者扫描二维码，可使用该作品作为门票', 'https://cosmoscdn.9space.vip/image/2021-11-13-13-10-56AoDRBMfD.png,https://cosmoscdn.9space.vip/image/2021-11-13-13-11-03mHToTmka.png,https://cosmoscdn.9space.vip/image/2021-11-13-13-11-47sVlqzMPG.png,https://cosmoscdn.9space.vip/image/2021-11-13-13-11-51oCFdTSGA.png', '票务', b'0', b'1', 'qrcode');
INSERT INTO `privilege_option` VALUES (1354, '2021-11-09 15:19:14', '管理员(1)', b'0', '2021-11-13 13:12:02', '管理员(1)', '通过该验证码可在第三方平台进行该作品的校验和使用', 'https://cosmoscdn.9space.vip/image/2021-11-13-13-10-17Sbbzdymi.png,https://cosmoscdn.9space.vip/image/2021-11-13-13-10-27lxvvrVop.png,https://cosmoscdn.9space.vip/image/2021-11-13-13-10-38bWorEEYN.png,https://cosmoscdn.9space.vip/image/2021-11-13-13-12-00oFNIbIEn.png', '兑换锁链', b'0', b'0', 'code');
INSERT INTO `privilege_option` VALUES (1356, '2021-11-09 15:23:12', '管理员(1)', b'0', '2022-02-18 17:33:52', '第九空间01(4156)', '可在铸造商店进行实物铸造', 'https://cosmoscdn.9space.vip/image/2021-11-12-14-48-02FtoZIkUR.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-48-08YNhvXfpn.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-48-15NrAlwUTe.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-52-28dTxxSaLF.png', '铸造', b'0', b'1', 'exchange');
INSERT INTO `privilege_option` VALUES (1864, '2021-11-12 14:18:19', '管理员(1)', b'0', '2022-02-18 17:38:47', '第九空间01(4156)', '里面藏有创作者填写的隐藏内容，持有者才能打开查看', 'https://cosmoscdn.9space.vip/image/2021-11-12-14-52-51sSJoYQJK.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-53-00oFTSogIR.png,https://cosmoscdn.9space.vip/image/2021-11-12-14-53-16IygUxQHY.png', '悄悄话', b'0', b'1', 'text');

-- ----------------------------
-- Table structure for project
-- ----------------------------

CREATE TABLE `project`  (
                            `id` bigint NOT NULL,
                            `created_at` datetime NULL DEFAULT NULL,
                            `created_by` varchar(255)  NULL DEFAULT NULL,
                            `del` bit(1) NOT NULL,
                            `modified_at` datetime NULL DEFAULT NULL,
                            `modified_by` varchar(255)  NULL DEFAULT NULL,
                            `ch_name` varchar(255)  NULL DEFAULT NULL,
                            `en_name` varchar(255)  NULL DEFAULT NULL,
                            `front_addr` varchar(255)  NULL DEFAULT NULL,
                            `user_prefix` varchar(255)  NULL DEFAULT NULL,
                            PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of project
-- ----------------------------

-- ----------------------------
-- Table structure for real_name_log
-- ----------------------------

CREATE TABLE `real_name_log`  (
                                  `id` bigint NOT NULL,
                                  `created_at` datetime NULL DEFAULT NULL,
                                  `created_by` varchar(255)  NULL DEFAULT NULL,
                                  `del` bit(1) NOT NULL,
                                  `modified_at` datetime NULL DEFAULT NULL,
                                  `modified_by` varchar(255)  NULL DEFAULT NULL,
                                  `card_no` varchar(255)  NULL DEFAULT NULL,
                                  `change_user_id` bigint NULL DEFAULT NULL,
                                  `change_user_name` varchar(255)  NULL DEFAULT NULL,
                                  `content` varchar(255)  NULL DEFAULT NULL,
                                  `id_no` varchar(255)  NULL DEFAULT NULL,
                                  `operate_type` varchar(255)  NULL DEFAULT NULL,
                                  `operator_id` bigint NULL DEFAULT NULL,
                                  `operator_ip` varchar(255)  NULL DEFAULT NULL,
                                  `operator_name` varchar(255)  NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of real_name_log
-- ----------------------------

-- ----------------------------
-- Table structure for recharge_order
-- ----------------------------

CREATE TABLE `recharge_order`  (
                                   `id` bigint NOT NULL,
                                   `created_at` datetime NULL DEFAULT NULL,
                                   `created_by` varchar(255)  NULL DEFAULT NULL,
                                   `del` bit(1) NOT NULL,
                                   `modified_at` datetime NULL DEFAULT NULL,
                                   `modified_by` varchar(255)  NULL DEFAULT NULL,
                                   `amount` decimal(19, 2) NULL DEFAULT NULL,
                                   `bank_name` varchar(255)  NULL DEFAULT NULL,
                                   `bank_no` varchar(255)  NULL DEFAULT NULL,
                                   `fee_amt` decimal(19, 2) NULL DEFAULT NULL,
                                   `finish_time` datetime NULL DEFAULT NULL,
                                   `front_url` varchar(255)  NULL DEFAULT NULL,
                                   `jump_url` varchar(255)  NULL DEFAULT NULL,
                                   `notify_time` datetime NULL DEFAULT NULL,
                                   `notify_url` varchar(255)  NULL DEFAULT NULL,
                                   `order_amount` decimal(19, 2) NULL DEFAULT NULL,
                                   `order_no` varchar(255)  NULL DEFAULT NULL,
                                   `pay_platform` varchar(255)  NULL DEFAULT NULL,
                                   `pay_tool` varchar(255)  NULL DEFAULT NULL,
                                   `pay_voucher` text  NULL,
                                   `related_card_no` varchar(255)  NULL DEFAULT NULL,
                                   `result` varchar(255)  NULL DEFAULT NULL,
                                   `status` varchar(255)  NULL DEFAULT NULL,
                                   `title` varchar(255)  NULL DEFAULT NULL,
                                   `token` varchar(255)  NULL DEFAULT NULL,
                                   `transaction_id` varchar(255)  NULL DEFAULT NULL,
                                   `user_bank_card_id` bigint NULL DEFAULT NULL,
                                   `user_fee_amt` decimal(19, 2) NULL DEFAULT NULL,
                                   `user_fund_account_id` bigint NULL DEFAULT NULL,
                                   `user_id` bigint NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`) USING BTREE,
                                   INDEX `IDX92atlqe1b36w7q8h4tr2tv9pf`(`user_id`) USING BTREE,
                                   INDEX `IDXak1eviphbfufs6rve91nvivbf`(`order_no`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of recharge_order
-- ----------------------------

-- ----------------------------
-- Table structure for recommend
-- ----------------------------

CREATE TABLE `recommend`  (
                              `id` bigint NOT NULL,
                              `created_at` datetime NULL DEFAULT NULL,
                              `created_by` varchar(255)  NULL DEFAULT NULL,
                              `del` bit(1) NOT NULL,
                              `modified_at` datetime NULL DEFAULT NULL,
                              `modified_by` varchar(255)  NULL DEFAULT NULL,
                              `collection_id` bigint NULL DEFAULT NULL,
                              `name` varchar(255)  NULL DEFAULT NULL,
                              `sort` int NOT NULL,
                              `type` varchar(255)  NULL DEFAULT NULL,
                              `pic` varchar(255)  NULL DEFAULT NULL,
                              `project_id` int NOT NULL,
                              PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of recommend
-- ----------------------------

-- ----------------------------
-- Table structure for scenic
-- ----------------------------

CREATE TABLE `scenic`  (
                           `id` bigint NOT NULL,
                           `created_at` datetime NULL DEFAULT NULL,
                           `created_by` varchar(255)  NULL DEFAULT NULL,
                           `modified_at` datetime NULL DEFAULT NULL,
                           `modified_by` varchar(255)  NULL DEFAULT NULL,
                           `city_id` bigint NULL DEFAULT NULL,
                           `name` varchar(255)  NULL DEFAULT NULL,
                           `pic` varchar(255)  NULL DEFAULT NULL,
                           `remark` varchar(255)  NULL DEFAULT NULL,
                           PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of scenic
-- ----------------------------

-- ----------------------------
-- Table structure for scenic_spot
-- ----------------------------

CREATE TABLE `scenic_spot`  (
                                `id` bigint NOT NULL,
                                `created_at` datetime NULL DEFAULT NULL,
                                `created_by` varchar(255)  NULL DEFAULT NULL,
                                `modified_at` datetime NULL DEFAULT NULL,
                                `modified_by` varchar(255)  NULL DEFAULT NULL,
                                `city_id` bigint NULL DEFAULT NULL,
                                `name` varchar(255)  NULL DEFAULT NULL,
                                `pic` varchar(255)  NULL DEFAULT NULL,
                                `remark` varchar(255)  NULL DEFAULT NULL,
                                `scenic_id` bigint NULL DEFAULT NULL,
                                `x` int NOT NULL,
                                `y` int NOT NULL,
                                PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of scenic_spot
-- ----------------------------

-- ----------------------------
-- Table structure for sms_record
-- ----------------------------

CREATE TABLE `sms_record`  (
                               `id` bigint NOT NULL,
                               `created_at` datetime NULL DEFAULT NULL,
                               `created_by` varchar(255)  NULL DEFAULT NULL,
                               `modified_at` datetime NULL DEFAULT NULL,
                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                               `code` varchar(255)  NULL DEFAULT NULL,
                               `expired` bit(1) NULL DEFAULT NULL,
                               `expires_at` datetime NULL DEFAULT NULL,
                               `phone` varchar(255)  NULL DEFAULT NULL,
                               `scope` varchar(255)  NULL DEFAULT NULL,
                               `session_id` varchar(255)  NULL DEFAULT NULL,
                               `del` bit(1) NOT NULL,
                               PRIMARY KEY (`id`) USING BTREE,
                               INDEX `IDX15i12q4gifq8a8kil7l2bjlty`(`phone`) USING BTREE,
                               INDEX `IDX4gr4ycik1fopjfw6rpg22oluj`(`expires_at`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of sms_record
-- ----------------------------

-- ----------------------------
-- Table structure for spot
-- ----------------------------

CREATE TABLE `spot`  (
                         `user_id` bigint NOT NULL,
                         `authority_name` varchar(50)  NOT NULL,
                         PRIMARY KEY (`user_id`, `authority_name`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of spot
-- ----------------------------

-- ----------------------------
-- Table structure for spot_guid
-- ----------------------------

CREATE TABLE `spot_guid`  (
                              `spot_id` bigint NOT NULL,
                              `guid_id` bigint NOT NULL,
                              PRIMARY KEY (`spot_id`, `guid_id`) USING BTREE,
                              INDEX `FKbftxye4brw7vfq05d7rv0mtca`(`guid_id`) USING BTREE,
                              CONSTRAINT `FK5xnrr1sk76u0xy3j15p6r96q9` FOREIGN KEY (`spot_id`) REFERENCES `scenic_spot` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
                              CONSTRAINT `FKbftxye4brw7vfq05d7rv0mtca` FOREIGN KEY (`guid_id`) REFERENCES `guide` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of spot_guid
-- ----------------------------

-- ----------------------------
-- Table structure for super_user
-- ----------------------------

CREATE TABLE `super_user`  (
                               `id` bigint NOT NULL,
                               `created_at` datetime NULL DEFAULT NULL,
                               `created_by` varchar(255)  NULL DEFAULT NULL,
                               `modified_at` datetime NULL DEFAULT NULL,
                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                               `avatar` varchar(255)  NULL DEFAULT NULL,
                               `enabled` bit(1) NOT NULL,
                               `nickname` varchar(255)  NULL DEFAULT NULL,
                               `password` varchar(255)  NULL DEFAULT NULL,
                               `phone` varchar(255)  NULL DEFAULT NULL,
                               `username` varchar(50)  NOT NULL,
                               `del` bit(1) NOT NULL,
                               PRIMARY KEY (`id`) USING BTREE,
                               UNIQUE INDEX `UK_jfokkpxg19r117eil158ooo9d`(`username`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of super_user
-- ----------------------------

-- ----------------------------
-- Table structure for super_user_authority
-- ----------------------------

CREATE TABLE `super_user_authority`  (
                                         `user_id` bigint NOT NULL,
                                         `authority_name` varchar(50)  NOT NULL,
                                         PRIMARY KEY (`user_id`, `authority_name`) USING BTREE,
                                         INDEX `FKxjxyodse6n0n00ewvoq8xv8`(`authority_name`) USING BTREE,
                                         CONSTRAINT `FK7p0vq0b1vy9f0sqvgrdqw1q70` FOREIGN KEY (`user_id`) REFERENCES `super_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
                                         CONSTRAINT `FKxjxyodse6n0n00ewvoq8xv8` FOREIGN KEY (`authority_name`) REFERENCES `authority` (`name`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of super_user_authority
-- ----------------------------

-- ----------------------------
-- Table structure for surprise_box_log
-- ----------------------------

CREATE TABLE `surprise_box_log`  (
                                     `id` bigint NOT NULL,
                                     `created_at` datetime NULL DEFAULT NULL,
                                     `created_by` varchar(255)  NULL DEFAULT NULL,
                                     `del` bit(1) NOT NULL,
                                     `modified_at` datetime NULL DEFAULT NULL,
                                     `modified_by` varchar(255)  NULL DEFAULT NULL,
                                     `collection_id` bigint NULL DEFAULT NULL,
                                     `name` varchar(255)  NULL DEFAULT NULL,
                                     `phone` varchar(255)  NULL DEFAULT NULL,
                                     `pic_url` text  NULL,
                                     `project_id` int NOT NULL,
                                     `remarks` varchar(255)  NULL DEFAULT NULL,
                                     `shipments` bit(1) NOT NULL,
                                     `type` int NULL DEFAULT NULL,
                                     `user_id` bigint NULL DEFAULT NULL,
                                     PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of surprise_box_log
-- ----------------------------

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------

CREATE TABLE `sys_config`  (
                               `name` varchar(25)  NOT NULL,
                               `created_at` datetime NULL DEFAULT NULL,
                               `created_by` varchar(255)  NULL DEFAULT NULL,
                               `modified_at` datetime NULL DEFAULT NULL,
                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                               `description` varchar(255)  NULL DEFAULT NULL,
                               `type` varchar(255)  NULL DEFAULT NULL,
                               `value` varchar(255)  NULL DEFAULT NULL,
                               `del` bit(1) NOT NULL,
                               `option_map` text  NULL,
                               PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES ('9th_customer_group', '2021-11-23 19:12:54', NULL, '2022-04-19 11:15:54', 'Meng(66637)', '第九空间客服群', 'FILE', 'https://cosmoscdn.9space.vip/image/2022-04-19-11-15-53ceRGzcIa.jpg', b'0', NULL);
INSERT INTO `sys_config` VALUES ('asset_shelf_check', '2022-04-29 15:51:19', 'system', '2022-04-29 15:51:19', 'system', '二手交易藏品上架检查', 'STRING', '', b'0', NULL);
INSERT INTO `sys_config` VALUES ('asset_shelf_price_limit', '2022-05-24 17:36:51', 'system', '2022-05-24 17:36:51', 'system', '资产上架价格限制', 'NUMBER', '50000', b'0', NULL);
INSERT INTO `sys_config` VALUES ('authcode_expiration_time', '2022-06-02 10:43:55', 'system', '2022-06-02 10:43:55', 'system', '图形验证码过期时间（秒）', 'NUMBER', '120', b'0', NULL);
INSERT INTO `sys_config` VALUES ('bank_card_can_be_bound', '2022-05-13 14:34:06', 'system', '2022-05-13 14:34:06', 'system', '同一个银行卡可以绑定的次数', 'NUMBER', '3', b'0', NULL);
INSERT INTO `sys_config` VALUES ('binding_bank_card_switch', '2022-05-19 18:45:43', NULL, '2022-05-27 20:45:18', '管理员-梁大官人(2645290)', '汇付绑定银行卡开关', 'BOOLEAN', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('black_user_id', NULL, NULL, '2022-05-20 17:22:12', '管理员(1)', '黑洞账户', 'NUMBER', '1', b'0', NULL);
INSERT INTO `sys_config` VALUES ('by_invite_collection', '2022-05-07 15:38:15', NULL, '2022-05-11 15:35:17', '芳慧(2647154)', '邀请获得空投惊喜盒子ID（被邀请人）', 'NUMBER', '2647172', b'0', NULL);
INSERT INTO `sys_config` VALUES ('consume_data', '2022-06-02 21:39:58', 'system', '2022-06-02 21:39:58', 'system', '活动消费排行榜需要补全的数据（与手机号对应）', 'STRING', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('consume_phone', '2022-06-02 21:39:58', 'system', '2022-06-02 21:39:58', 'system', '活动消费排行榜需要补全数据的手机号（多号用逗号隔开）', 'STRING', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('cosmos_customer_group', '2022-01-24 13:52:43', NULL, '2022-04-06 11:12:51', '第九空间01(4156)', 'cosmos客服群', 'FILE', 'https://cosmoscdn.9space.vip/image/2022-04-06-11-12-49KeUUAyqc.jpg', b'0', NULL);
INSERT INTO `sys_config` VALUES ('days_four_element_count', '2022-05-03 15:35:18', NULL, '2022-05-09 10:10:01', 'li(2644644)', '用户每天银行卡实名认证次数', 'NUMBER', '10', b'0', NULL);
INSERT INTO `sys_config` VALUES ('default_avatar', '2022-05-03 19:53:15', 'system', '2022-05-03 19:53:15', 'system', '用户默认头像', 'STRING', 'https://cosmoscdn.9space.vip/image/2021-11-26-18-49-04fkFHRAhM.jpg', b'0', NULL);
INSERT INTO `sys_config` VALUES ('enable_wx_lite', '2021-12-09 20:37:12', NULL, '2021-12-13 20:43:05', '管理员(1)', '使用小程序支付', 'BOOLEAN', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('enable_wx_pub', '2021-12-09 20:37:12', NULL, '2021-12-10 10:19:31', 'admin(1866)', '使用公众号支付', 'BOOLEAN', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('false_data', '2022-05-30 17:14:47', NULL, '2022-05-30 17:22:32', 'oujihong(2644265)', '邀请排行榜假数据（与手机号一一对应）', 'STRING', '300,500', b'0', NULL);
INSERT INTO `sys_config` VALUES ('false_data_phone_number', '2022-05-30 17:14:47', NULL, '2022-05-30 17:22:15', 'oujihong(2644265)', '邀请排行榜需要造假数据的手机号（多号用逗号隔开）', 'STRING', '13680830210,13143745202', b'0', NULL);
INSERT INTO `sys_config` VALUES ('four_element_switch', '2022-05-03 15:35:18', NULL, '2022-05-23 18:09:55', 'yang(2644733)', '银行卡实名认证四要素开关', 'BOOLEAN', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('gas_fee', '2021-10-21 17:34:34', NULL, '2022-04-27 20:31:37', 'zhangxiaoyu(2644324)', 'gas费', 'NUMBER', '0.01', b'0', NULL);
INSERT INTO `sys_config` VALUES ('gift_gas_fee', '2021-12-08 21:04:49', NULL, '2022-04-29 16:02:47', '管理员(1)', '转赠gas费', 'NUMBER', '0.01', b'0', NULL);
INSERT INTO `sys_config` VALUES ('gift_pay_switch', '2022-04-26 18:14:50', 'system', '2022-04-26 18:14:50', 'system', '转赠支付开关', 'BOOLEAN', '1', b'0', NULL);
INSERT INTO `sys_config` VALUES ('hold_days', '2021-12-16 01:38:51', NULL, '2022-03-22 12:32:50', 'xiong(1243003)', '持有满几天可销售', 'NUMBER', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('invite_collection', '2022-04-27 15:59:10', NULL, '2022-05-10 11:06:40', 'zhangxiaoyu(2644324)', '邀请获得空投藏品ID', 'NUMBER', '-1', b'0', NULL);
INSERT INTO `sys_config` VALUES ('invite_enddatetime', '2022-04-27 15:59:10', NULL, '2022-05-12 18:32:59', '芳慧(2647154)', '邀请活动结束时间', 'DATETIME', '2022-05-13 13:21:39', b'0', NULL);
INSERT INTO `sys_config` VALUES ('invite_num', '2022-04-27 15:59:10', NULL, '2022-05-10 11:06:57', 'zhangxiaoyu(2644324)', '邀请人数', 'NUMBER', '-1', b'0', NULL);
INSERT INTO `sys_config` VALUES ('invite_startdatetime', '2022-04-27 15:59:10', NULL, '2022-05-12 18:32:16', '芳慧(2647154)', '邀请活动开始时间', 'DATETIME', '2022-05-12 13:21:27', b'0', NULL);
INSERT INTO `sys_config` VALUES ('lock_order_count_interval', '2022-05-20 15:22:43', 'system', '2022-05-20 15:22:43', 'system', '统计锁单次数周期', 'NUMBER', '24', b'0', NULL);
INSERT INTO `sys_config` VALUES ('lock_order_limit_number', '2022-05-17 17:14:32', NULL, '2022-05-27 14:51:25', 'oujihong(2644265)', '锁单上限次数', 'NUMBER', '200', b'0', NULL);
INSERT INTO `sys_config` VALUES ('lock_order_punish_time', '2022-05-17 17:14:33', NULL, '2022-05-17 20:20:13', 'test01(2644237)', '超过锁单上限禁止购买时间', 'NUMBER', '5', b'0', NULL);
INSERT INTO `sys_config` VALUES ('member_prefix', '2022-06-07 14:45:55', 'system', '2022-06-07 14:45:55', 'system', '第三方账户会员ID前缀（多个平台隔离）', 'STRING', '9th_', b'0', NULL);
INSERT INTO `sys_config` VALUES ('order_expire_interval', '2022-05-12 21:57:07', 'system', '2022-05-12 21:57:07', 'system', '订单失效时间间隔（分钟）', 'NUMBER', '3', b'0', NULL);
INSERT INTO `sys_config` VALUES ('pay_platform', '2022-04-07 21:32:54', NULL, '2022-06-14 18:08:27', 'oujihong(2644265)', '默认的支付平台', 'LIST', 'NOTPAY_PLATFORM', b'0', '{\"adapayPlatform\":\"汇付支付\",\"customPlatform\":\"官方支付宝\",\"sandpayPlatform\":\"杉德支付\",\"ikudotpayPlatform\":\"酷点支付\",\"sumpayPlatform\":\"商盟支付\",\"payeasenetPlatform\":\"首信易支付\",\"NOTPAY_PLATFORM\":\"--关闭通道--\"}');
INSERT INTO `sys_config` VALUES ('picture_compression', '2022-06-14 14:33:59', NULL, '2022-06-14 14:41:47', 'oujihong(2644265)', '图片压缩开关', 'BOOLEAN', '1', b'0', NULL);
INSERT INTO `sys_config` VALUES ('prefix', '2022-04-27 15:59:10', NULL, '2022-04-28 13:26:34', '汤卓威(2644442)', '用户名前缀', 'STRING', '时光街_', b'0', NULL);
INSERT INTO `sys_config` VALUES ('ranking_end_time', '2022-05-24 16:08:53', 'system', '2022-05-24 16:08:53', 'system', '成交量排行榜活动结束时间', 'DATETIME', '2022-05-24 20:10:36', b'0', NULL);
INSERT INTO `sys_config` VALUES ('ranking_start_time', '2022-05-24 16:08:53', 'system', '2022-05-24 16:08:53', 'system', '成交量排行榜活动开始时间', 'DATETIME', '2022-03-21 11:10:36', b'0', NULL);
INSERT INTO `sys_config` VALUES ('registered_number', '2022-05-12 18:30:05', NULL, '2022-06-14 16:30:32', '芳慧(2864293)', '同一个身份证可注册账号个数', 'NUMBER', '5', b'0', NULL);
INSERT INTO `sys_config` VALUES ('second_hand_pay_platform', '2022-04-26 18:14:49', NULL, '2022-06-14 18:01:30', 'oujihong(2644265)', '二手交易的支付平台', 'LIST', 'NOTPAY_PLATFORM', b'0', '{\"adapayPlatform\":\"汇付支付\",\"customPlatform\":\"官方支付宝\",\"sandpayPlatform\":\"杉德支付\",\"ikudotpayPlatform\":\"酷点支付\",\"sumpayPlatform\":\"商盟支付\",\"payeasenetPlatform\":\"首信易支付\",\"NOTPAY_PLATFORM\":\"--关闭通道--\"}');
INSERT INTO `sys_config` VALUES ('share_ratio', '2021-11-19 19:59:46', NULL, '2021-12-08 14:12:21', '管理员(1)', '默认分享分成比例(%)', 'NUMBER', '0', b'0', NULL);
INSERT INTO `sys_config` VALUES ('tester_user_id', '2022-05-18 13:50:42', 'system', '2022-05-18 13:50:42', 'system', '测试人员ID', 'NUMBER', '1', b'0', NULL);
INSERT INTO `sys_config` VALUES ('test_named_collectionId', '2022-05-05 21:41:01', NULL, '2022-05-06 12:16:16', '管理员(1)', '指定藏品,多藏品逗号隔开', 'STRING', '2644609', b'0', NULL);
INSERT INTO `sys_config` VALUES ('test_named_user', '2022-05-05 21:41:01', NULL, '2022-05-06 12:17:22', '管理员(1)', '指定用户ID,多藏品逗号隔开', 'STRING', '2644964,1', b'0', NULL);
INSERT INTO `sys_config` VALUES ('wallet_free_tips', '2022-06-13 20:52:38', 'system', '2022-06-13 20:52:38', 'system', '钱包免费提示信息', 'STRING', '', b'0', NULL);
INSERT INTO `sys_config` VALUES ('wx_mp_switch', '2022-05-06 23:08:17', 'system', '2022-05-06 23:08:17', 'system', '微信公众号调用开关', 'BOOLEAN', '0', b'0', NULL);

-- ----------------------------
-- Table structure for system_info_log
-- ----------------------------

CREATE TABLE `system_info_log`  (
                                    `id` bigint NOT NULL,
                                    `created_at` datetime NULL DEFAULT NULL,
                                    `created_by` varchar(255)  NULL DEFAULT NULL,
                                    `del` bit(1) NOT NULL,
                                    `modified_at` datetime NULL DEFAULT NULL,
                                    `modified_by` varchar(255)  NULL DEFAULT NULL,
                                    `bank_pay_num` decimal(19, 2) NULL DEFAULT NULL,
                                    `closing_wallet_num` int NULL DEFAULT NULL,
                                    `day_recharge_num` decimal(19, 2) NULL DEFAULT NULL,
                                    `day_withdraw_num` decimal(19, 2) NULL DEFAULT NULL,
                                    `log_date` date NULL DEFAULT NULL,
                                    `open_wallet_num` int NULL DEFAULT NULL,
                                    `register_num` int NULL DEFAULT NULL,
                                    `total_open_wallet_num` int NULL DEFAULT NULL,
                                    `wallet_pay_num` decimal(19, 2) NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of system_info_log
-- ----------------------------

-- ----------------------------
-- Table structure for test_class
-- ----------------------------

CREATE TABLE `test_class`  (
                               `id` bigint NOT NULL,
                               `created_at` datetime NULL DEFAULT NULL,
                               `created_by` varchar(255)  NULL DEFAULT NULL,
                               `del` bit(1) NOT NULL,
                               `modified_at` datetime NULL DEFAULT NULL,
                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                               `name` varchar(255)  NULL DEFAULT NULL,
                               PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of test_class
-- ----------------------------

-- ----------------------------
-- Table structure for token_history
-- ----------------------------

CREATE TABLE `token_history`  (
                                  `id` bigint NOT NULL,
                                  `created_at` datetime NULL DEFAULT NULL,
                                  `created_by` varchar(255)  NULL DEFAULT NULL,
                                  `del` bit(1) NOT NULL,
                                  `modified_at` datetime NULL DEFAULT NULL,
                                  `modified_by` varchar(255)  NULL DEFAULT NULL,
                                  `from_avatar` varchar(255)  NULL DEFAULT NULL,
                                  `from_user` varchar(255)  NULL DEFAULT NULL,
                                  `from_user_id` bigint NULL DEFAULT NULL,
                                  `operation` varchar(255)  NULL DEFAULT NULL,
                                  `price` decimal(10, 2) NULL DEFAULT NULL,
                                  `to_avatar` varchar(255)  NULL DEFAULT NULL,
                                  `to_user` varchar(255)  NULL DEFAULT NULL,
                                  `to_user_id` bigint NULL DEFAULT NULL,
                                  `token_id` varchar(255)  NULL DEFAULT NULL,
                                  `project_id` int NOT NULL,
                                  `asset_id` bigint NULL DEFAULT NULL,
                                  `order_id` bigint NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`) USING BTREE,
                                  INDEX `IDXg00s1821w2wm8w73ajmsscau1`(`token_id`) USING BTREE,
                                  INDEX `idx_touserid`(`to_user_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of token_history
-- ----------------------------

-- ----------------------------
-- Table structure for transfer_money_info
-- ----------------------------

CREATE TABLE `transfer_money_info`  (
                                        `id` bigint NOT NULL,
                                        `created_at` datetime NULL DEFAULT NULL,
                                        `created_by` varchar(255)  NULL DEFAULT NULL,
                                        `del` bit(1) NOT NULL,
                                        `modified_at` datetime NULL DEFAULT NULL,
                                        `modified_by` varchar(255)  NULL DEFAULT NULL,
                                        `account_name` varchar(255)  NULL DEFAULT NULL,
                                        `account_no` varchar(255)  NULL DEFAULT NULL,
                                        `account_type` varchar(255)  NULL DEFAULT NULL,
                                        `amount` decimal(10, 2) NULL DEFAULT NULL,
                                        `status` varchar(255)  NULL DEFAULT NULL,
                                        `to_user_id` bigint NULL DEFAULT NULL,
                                        `trade_no` varchar(255)  NULL DEFAULT NULL,
                                        `transaction_id` varchar(255)  NULL DEFAULT NULL,
                                        `transfer_date` varchar(255)  NULL DEFAULT NULL,
                                        `transfer_method` varchar(255)  NULL DEFAULT NULL,
                                        `transfer_order_id` varchar(255)  NULL DEFAULT NULL,
                                        `batch_no` varchar(255)  NULL DEFAULT NULL,
                                        `div_money_id` bigint NULL DEFAULT NULL,
                                        `pay_platform` varchar(255)  NULL DEFAULT NULL,
                                        `reason` varchar(255)  NULL DEFAULT NULL,
                                        `result` varchar(255)  NULL DEFAULT NULL,
                                        `third_account_id` varchar(255)  NULL DEFAULT NULL,
                                        PRIMARY KEY (`id`) USING BTREE,
                                        UNIQUE INDEX `UK4gakcpqh0h1gx30y6r4jx64tb`(`trade_no`) USING BTREE,
                                        INDEX `IDXmdibsak5hvvrxcogb11akci76`(`to_user_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of transfer_money_info
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------

CREATE TABLE `user`  (
                         `id` bigint NOT NULL,
                         `created_at` datetime NULL DEFAULT NULL,
                         `created_by` varchar(255)  NULL DEFAULT NULL,
                         `modified_at` datetime NULL DEFAULT NULL,
                         `modified_by` varchar(255)  NULL DEFAULT NULL,
                         `avatar` varchar(255)  NULL DEFAULT NULL,
                         `city` varchar(255)  NULL DEFAULT NULL,
                         `country` varchar(255)  NULL DEFAULT NULL,
                         `email` varchar(255)  NULL DEFAULT NULL,
                         `language` varchar(255)  NULL DEFAULT NULL,
                         `nickname` varchar(255)  NULL DEFAULT NULL,
                         `open_id` varchar(255)  NULL DEFAULT NULL,
                         `password` varchar(255)  NULL DEFAULT NULL,
                         `phone` varchar(255)  NULL DEFAULT NULL,
                         `province` varchar(255)  NULL DEFAULT NULL,
                         `sex` varchar(255)  NULL DEFAULT NULL,
                         `username` varchar(50)  NOT NULL,
                         `del` bit(1) NOT NULL,
                         `bg` varchar(255)  NULL DEFAULT NULL,
                         `followers` int NOT NULL,
                         `follows` int NOT NULL,
                         `intro` text  NULL,
                         `auth_status` varchar(255)  NULL DEFAULT NULL,
                         `real_name` varchar(255)  NULL DEFAULT NULL,
                         `kms_id` varchar(255)  NULL DEFAULT NULL,
                         `nft_account` varchar(255)  NULL DEFAULT NULL,
                         `public_key` varchar(255)  NULL DEFAULT NULL,
                         `sales` int NOT NULL,
                         `trade_code` varchar(255)  NULL DEFAULT NULL,
                         `admin` bit(1) NOT NULL,
                         `share_ratio` decimal(10, 2) NULL DEFAULT NULL,
                         `auth_id` bigint NULL DEFAULT NULL,
                         `member_id` varchar(255)  NULL DEFAULT NULL,
                         `settle_account_id` varchar(255)  NULL DEFAULT NULL,
                         `invite_code` varchar(255)  NULL DEFAULT NULL,
                         `invitor_name` varchar(255)  NULL DEFAULT NULL,
                         `invitor_phone` varchar(255)  NULL DEFAULT NULL,
                         `minter_project_id` int NOT NULL,
                         `invitor` bigint NULL DEFAULT NULL,
                         `invite_num` int NULL DEFAULT 0,
                         `invite_air_drop` int NULL DEFAULT 0,
                         `bank_card` bit(1) NOT NULL,
                         PRIMARY KEY (`id`) USING BTREE,
                         UNIQUE INDEX `UK_sb8bbouer5wak8vyiiy4pf2bx`(`username`) USING BTREE,
                         UNIQUE INDEX `UKc5b5fqpocs0w2o3h8goc90e8c`(`member_id`) USING BTREE,
                         INDEX `IDX589idila9li6a4arw1t8ht1gx`(`phone`) USING BTREE,
                         INDEX `IDXc9pp9de8b7qmvluu50p6i46c7`(`admin`) USING BTREE,
                         INDEX `IDXhtotek3rtv2axspgd9outw1cx`(`invitor`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user 默认密码123654abc
-- ----------------------------
INSERT INTO `user` VALUES (1, '2020-03-07 18:34:36', NULL, '2022-06-15 15:05:20', '管理员(1)', 'https://cosmoscdn.9space.vip/image/artist.jpg', NULL, NULL, NULL, NULL, '管理员', NULL, '$2a$10$7njcGSDIvYuXKBQeAib8QuRmCxapTMMG/B3.qfUtBWgsDHQfvA91K', NULL, NULL, NULL, 'admin', b'0', NULL, 0, 0, NULL, 'SUCCESS', NULL, NULL, NULL, NULL, 0, NULL, b'1', 5.00, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, b'0');

-- ----------------------------
-- Table structure for user_address
-- ----------------------------

CREATE TABLE `user_address`  (
                                 `id` bigint NOT NULL,
                                 `created_at` datetime NULL DEFAULT NULL,
                                 `created_by` varchar(255)  NULL DEFAULT NULL,
                                 `del` bit(1) NOT NULL,
                                 `modified_at` datetime NULL DEFAULT NULL,
                                 `modified_by` varchar(255)  NULL DEFAULT NULL,
                                 `address` varchar(255)  NULL DEFAULT NULL,
                                 `city_id` varchar(255)  NULL DEFAULT NULL,
                                 `city_name` varchar(255)  NULL DEFAULT NULL,
                                 `def` bit(1) NOT NULL,
                                 `district_id` bigint NULL DEFAULT NULL,
                                 `district_name` varchar(255)  NULL DEFAULT NULL,
                                 `name` varchar(255)  NULL DEFAULT NULL,
                                 `phone` varchar(255)  NULL DEFAULT NULL,
                                 `province_id` bigint NULL DEFAULT NULL,
                                 `province_name` varchar(255)  NULL DEFAULT NULL,
                                 `user_id` bigint NULL DEFAULT NULL,
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_address
-- ----------------------------

-- ----------------------------
-- Table structure for user_authority
-- ----------------------------

CREATE TABLE `user_authority`  (
                                   `user_id` bigint NOT NULL,
                                   `authority_name` varchar(50)  NOT NULL,
                                   PRIMARY KEY (`user_id`, `authority_name`) USING BTREE,
                                   INDEX `idx_authorityname`(`authority_name`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_authority
-- ----------------------------
INSERT INTO `user_authority` VALUES (1, 'ROLE_ADMIN');


-- ----------------------------
-- Table structure for user_bank_card
-- ----------------------------

CREATE TABLE `user_bank_card`  (
                                   `id` bigint NOT NULL,
                                   `created_at` datetime NULL DEFAULT NULL,
                                   `created_by` varchar(255)  NULL DEFAULT NULL,
                                   `del` bit(1) NOT NULL,
                                   `modified_at` datetime NULL DEFAULT NULL,
                                   `modified_by` varchar(255)  NULL DEFAULT NULL,
                                   `bank` varchar(255)  NULL DEFAULT NULL,
                                   `bank_name` varchar(255)  NULL DEFAULT NULL,
                                   `bank_no` varchar(255)  NULL DEFAULT NULL,
                                   `card_type` varchar(255)  NULL DEFAULT NULL,
                                   `card_type_desc` varchar(255)  NULL DEFAULT NULL,
                                   `user_id` bigint NULL DEFAULT NULL,
                                   `phone` varchar(255)  NULL DEFAULT NULL,
                                   `id_no` varchar(255)  NULL DEFAULT NULL,
                                   `real_name` varchar(255)  NULL DEFAULT NULL,
                                   `pay_platform` varchar(255)  NULL DEFAULT NULL,
                                   `bind_order_no` varchar(255)  NULL DEFAULT NULL,
                                   `third_account_id` varchar(255)  NULL DEFAULT NULL,
                                   `third_bank_id` varchar(255)  NULL DEFAULT NULL,
                                   `token` varchar(255)  NULL DEFAULT NULL,
                                   `unbind_order_no` varchar(255)  NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`) USING BTREE,
                                   UNIQUE INDEX `UK32pokndfety4yl5talcj81fqd`(`bind_order_no`) USING BTREE,
                                   UNIQUE INDEX `UKaq28ndgn3ackirsqwoe0vs5q9`(`unbind_order_no`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_bank_card
-- ----------------------------

-- ----------------------------
-- Table structure for user_coupon
-- ----------------------------

CREATE TABLE `user_coupon`  (
                                `id` bigint NOT NULL,
                                `created_at` datetime NULL DEFAULT NULL,
                                `created_by` varchar(255)  NULL DEFAULT NULL,
                                `del` bit(1) NOT NULL,
                                `modified_at` datetime NULL DEFAULT NULL,
                                `modified_by` varchar(255)  NULL DEFAULT NULL,
                                `collection_ids` text  NULL,
                                `coupon_id` bigint NULL DEFAULT NULL,
                                `expiration` datetime NULL DEFAULT NULL,
                                `limited` bit(1) NOT NULL,
                                `name` varchar(255)  NULL DEFAULT NULL,
                                `need_gas` bit(1) NOT NULL,
                                `remark` varchar(255)  NULL DEFAULT NULL,
                                `use_time` datetime NULL DEFAULT NULL,
                                `used` bit(1) NOT NULL,
                                `user_id` bigint NULL DEFAULT NULL,
                                `project_id` int NOT NULL,
                                PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_coupon
-- ----------------------------

-- ----------------------------
-- Table structure for user_fund_account
-- ----------------------------

CREATE TABLE `user_fund_account`  (
                                      `id` bigint NOT NULL,
                                      `created_at` datetime NULL DEFAULT NULL,
                                      `created_by` varchar(255)  NULL DEFAULT NULL,
                                      `del` bit(1) NOT NULL,
                                      `modified_at` datetime NULL DEFAULT NULL,
                                      `modified_by` varchar(255)  NULL DEFAULT NULL,
                                      `account_name` varchar(255)  NULL DEFAULT NULL,
                                      `account_no` varchar(255)  NULL DEFAULT NULL,
                                      `account_type` int NULL DEFAULT NULL,
                                      `primary_flag` bit(1) NOT NULL,
                                      `user_id` bigint NULL DEFAULT NULL,
                                      `account_error` varchar(255)  NULL DEFAULT NULL,
                                      `account_status` varchar(255)  NULL DEFAULT NULL,
                                      `apply_time` datetime NULL DEFAULT NULL,
                                      `cancel_time` datetime NULL DEFAULT NULL,
                                      `gateway_url` varchar(255)  NULL DEFAULT NULL,
                                      `notify_time` datetime NULL DEFAULT NULL,
                                      `order_no` varchar(255)  NULL DEFAULT NULL,
                                      `register_phone` varchar(255)  NULL DEFAULT NULL,
                                      `third_bank_id` varchar(255)  NULL DEFAULT NULL,
                                      `third_bank_no` varchar(255)  NULL DEFAULT NULL,
                                      `third_user_id` varchar(255)  NULL DEFAULT NULL,
                                      `token` varchar(255)  NULL DEFAULT NULL,
                                      `user_bank_card_id` bigint NULL DEFAULT NULL,
                                      PRIMARY KEY (`id`) USING BTREE,
                                      UNIQUE INDEX `UKh4qaf1er9y2o8c56biv04l7i4`(`user_id`, `account_type`) USING BTREE,
                                      UNIQUE INDEX `UKbvvdcin4b42eud8986s82j32c`(`order_no`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_fund_account
-- ----------------------------

-- ----------------------------
-- Table structure for user_fund_change_log
-- ----------------------------

CREATE TABLE `user_fund_change_log`  (
                                         `id` bigint NOT NULL,
                                         `created_at` datetime NULL DEFAULT NULL,
                                         `created_by` varchar(255)  NULL DEFAULT NULL,
                                         `del` bit(1) NOT NULL,
                                         `modified_at` datetime NULL DEFAULT NULL,
                                         `modified_by` varchar(255)  NULL DEFAULT NULL,
                                         `amount` decimal(19, 2) NULL DEFAULT NULL,
                                         `change_type` varchar(255)  NULL DEFAULT NULL,
                                         `description` varchar(255)  NULL DEFAULT NULL,
                                         `finish_time` datetime NULL DEFAULT NULL,
                                         `order_no` varchar(255)  NULL DEFAULT NULL,
                                         `order_time` datetime NULL DEFAULT NULL,
                                         `status` varchar(255)  NULL DEFAULT NULL,
                                         `user_fund_account_id` bigint NULL DEFAULT NULL,
                                         `user_id` bigint NULL DEFAULT NULL,
                                         PRIMARY KEY (`id`) USING BTREE,
                                         INDEX `IDXq5lnsfc0dx6oitvn15y58eu5k`(`user_id`) USING BTREE,
                                         INDEX `IDXe2e5d84e45cfoqlg4gr5hkea`(`order_no`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_fund_change_log
-- ----------------------------

-- ----------------------------
-- Table structure for user_token
-- ----------------------------

CREATE TABLE `user_token`  (
                               `id` bigint NOT NULL,
                               `created_at` datetime NULL DEFAULT NULL,
                               `created_by` varchar(255)  NULL DEFAULT NULL,
                               `del` bit(1) NOT NULL,
                               `modified_at` datetime NULL DEFAULT NULL,
                               `modified_by` varchar(255)  NULL DEFAULT NULL,
                               `token` varchar(255)  NULL DEFAULT NULL,
                               `user_id` bigint NULL DEFAULT NULL,
                               PRIMARY KEY (`id`) USING BTREE,
                               INDEX `IDX6dm5bsjbr1sablsdk0lk66oap`(`user_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_token
-- ----------------------------

-- ----------------------------
-- Table structure for user_ware_house
-- ----------------------------

CREATE TABLE `user_ware_house`  (
                                    `id` bigint NOT NULL,
                                    `created_at` datetime NULL DEFAULT NULL,
                                    `created_by` varchar(255)  NULL DEFAULT NULL,
                                    `del` bit(1) NOT NULL,
                                    `modified_at` datetime NULL DEFAULT NULL,
                                    `modified_by` varchar(255)  NULL DEFAULT NULL,
                                    `item_id` int NULL DEFAULT NULL,
                                    `item_name` varchar(255)  NULL DEFAULT NULL,
                                    `activity_priority_document_id` bigint NULL DEFAULT NULL,
                                    `advance_purchase_count` int NOT NULL,
                                    `advance_purchase_time` int NOT NULL,
                                    `asset_id` bigint NULL DEFAULT NULL,
                                    `disabled` bit(1) NOT NULL,
                                    `minter_id` bigint NULL DEFAULT NULL,
                                    `name` varchar(255)  NULL DEFAULT NULL,
                                    `overdue_time` datetime NULL DEFAULT NULL,
                                    `phone` varchar(255)  NULL DEFAULT NULL,
                                    `project_id` int NOT NULL,
                                    `target_collection_id` bigint NULL DEFAULT NULL,
                                    `target_collection_id_list` text  NULL,
                                    `text` varchar(255)  NULL DEFAULT NULL,
                                    `user_id` bigint NULL DEFAULT NULL,
                                    PRIMARY KEY (`id`) USING BTREE,
                                    INDEX `IDXm4xypqxvrbnpb7ndy4epadi1s`(`user_id`) USING BTREE,
                                    INDEX `IDX6n4nxr0a5jcfgunvxac151dk0`(`item_name`) USING BTREE,
                                    INDEX `IDX3nwmjd7wmd5naiu3uv0p7y6v5`(`item_id`) USING BTREE,
                                    INDEX `IDXrdg8wnrps48qslmhregj3bf8n`(`asset_id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of user_ware_house
-- ----------------------------

-- ----------------------------
-- Table structure for withdraw_apply
-- ----------------------------

CREATE TABLE `withdraw_apply`  (
                                   `id` bigint NOT NULL,
                                   `created_at` datetime NULL DEFAULT NULL,
                                   `created_by` varchar(255)  NULL DEFAULT NULL,
                                   `del` bit(1) NOT NULL,
                                   `modified_at` datetime NULL DEFAULT NULL,
                                   `modified_by` varchar(255)  NULL DEFAULT NULL,
                                   `amount` decimal(19, 2) NULL DEFAULT NULL,
                                   `auth_way` varchar(255)  NULL DEFAULT NULL,
                                   `bank_name` varchar(255)  NULL DEFAULT NULL,
                                   `bank_no` varchar(255)  NULL DEFAULT NULL,
                                   `fee_amt` decimal(19, 2) NULL DEFAULT NULL,
                                   `finish_time` datetime NULL DEFAULT NULL,
                                   `front_url` varchar(255)  NULL DEFAULT NULL,
                                   `jump_url` varchar(255)  NULL DEFAULT NULL,
                                   `notify_time` datetime NULL DEFAULT NULL,
                                   `notify_url` varchar(255)  NULL DEFAULT NULL,
                                   `order_amount` decimal(19, 2) NULL DEFAULT NULL,
                                   `order_no` varchar(255)  NULL DEFAULT NULL,
                                   `pay_platform` varchar(255)  NULL DEFAULT NULL,
                                   `related_card_no` varchar(255)  NULL DEFAULT NULL,
                                   `result` varchar(255)  NULL DEFAULT NULL,
                                   `status` varchar(255)  NULL DEFAULT NULL,
                                   `title` varchar(255)  NULL DEFAULT NULL,
                                   `token` varchar(255)  NULL DEFAULT NULL,
                                   `transaction_id` varchar(255)  NULL DEFAULT NULL,
                                   `user_bank_card_id` bigint NULL DEFAULT NULL,
                                   `user_fee_amt` decimal(19, 2) NULL DEFAULT NULL,
                                   `user_fund_account_id` bigint NULL DEFAULT NULL,
                                   `user_id` bigint NULL DEFAULT NULL,
                                   PRIMARY KEY (`id`) USING BTREE,
                                   INDEX `IDXqoekq1jkrchw3har5rc4jlyye`(`user_id`) USING BTREE,
                                   INDEX `IDXhnx0c67tcocbtjq1nsvmpypce`(`order_no`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 ;

-- ----------------------------
-- Records of withdraw_apply
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;