/* 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;