/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 80031
Source Host : localhost:3306
Source Database : tanweiguanli
Target Server Type : MYSQL
Target Server Version : 80031
File Encoding : 65001
Date: 2023-08-05 23:29:45
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COMMENT='配置文件';
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('1', 'picture1', 'http://localhost:8080/gongchengcailiao/upload/1614999756013.jpg');
INSERT INTO `config` VALUES ('2', 'picture2', 'http://localhost:8080/gongchengcailiao/upload/1614999769770.jpg');
INSERT INTO `config` VALUES ('3', 'picture3', 'http://localhost:8080/gongchengcailiao/upload/1614999778981.jpg');
INSERT INTO `config` VALUES ('6', 'homepage', null);
-- ----------------------------
-- Table structure for dictionary
-- ----------------------------
DROP TABLE IF EXISTS `dictionary`;
CREATE TABLE `dictionary` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`dic_code` varchar(200) DEFAULT NULL COMMENT '字段',
`dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',
`code_index` tinyint DEFAULT NULL COMMENT '编码',
`index_name` varchar(200) DEFAULT NULL COMMENT '编码名字',
`super_types` int DEFAULT NULL COMMENT '父字段id',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COMMENT='字典表';
-- ----------------------------
-- Records of dictionary
-- ----------------------------
INSERT INTO `dictionary` VALUES ('1', 'sex_types', '性别', '1', '男', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('2', 'sex_types', '性别', '2', '女', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('3', 'news_types', '公告类型名称', '1', '公告类型1', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('4', 'news_types', '公告类型名称', '2', '公告类型2', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('5', 'taanwei_types', '摊位类型', '1', '临时', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('6', 'taanwei_types', '摊位类型', '2', '固定', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('7', 'zhuangtai_types', '摊位状态', '1', '不空闲', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('8', 'zhuangtai_types', '摊位状态', '2', '空闲', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('9', 'shenqing_types', '申请类型', '1', '申请摊位', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('10', 'shenqing_types', '申请类型', '2', '升级摊位', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('11', 'quyu_types', '摊位区域名称', '1', '蔬菜区', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('12', 'quyu_types', '摊位区域名称', '2', '肉类区', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('13', 'quyu_types', '摊位区域名称', '3', '海鲜区', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('14', 'shenhe_types', '审核状态', '1', '未审核', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('15', 'shenhe_types', '审核状态', '2', '通过', null, '2023-05-06 19:39:56');
INSERT INTO `dictionary` VALUES ('16', 'shenhe_types', '审核状态', '3', '拒绝', null, '2023-05-06 19:39:57');
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`news_name` varchar(200) DEFAULT NULL COMMENT '公告名称 Search111 ',
`news_types` int DEFAULT NULL COMMENT '公告类型 Search111 ',
`news_photo` varchar(200) DEFAULT NULL COMMENT '公告图片',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '公告时间',
`news_content` text COMMENT '公告详情',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COMMENT='公告';
-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('1', '公告1', '1', 'http://localhost:8080/tanweiguanli/file/download?fileName=1620356612371.jpg', '2023-05-07 11:03:36', '公告详情1\r\n', '2023-05-07 11:03:36');
INSERT INTO `news` VALUES ('2', '公告2', '2', 'http://localhost:8080/tanweiguanli/file/download?fileName=1620356621726.jpg', '2023-05-07 11:03:43', '公告详情2\r\n', '2023-05-07 11:03:43');
-- ----------------------------
-- Table structure for shenqing
-- ----------------------------
DROP TABLE IF EXISTS `shenqing`;
CREATE TABLE `shenqing` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`yonghu_id` int DEFAULT NULL COMMENT '申请用户',
`taanwei_id` int DEFAULT NULL COMMENT '申请摊位',
`shenhe_types` int DEFAULT NULL COMMENT '审核状态 Search111',
`shenqing_types` int DEFAULT NULL COMMENT '申请类型 Search111',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '申请时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COMMENT='摊位申请';
-- ----------------------------
-- Records of shenqing
-- ----------------------------
INSERT INTO `shenqing` VALUES ('5', '1', '3', '2', '1', '2023-05-07 11:05:21', '2023-05-07 11:05:21');
INSERT INTO `shenqing` VALUES ('6', '1', '2', '3', '1', '2023-05-07 11:05:24', '2023-05-07 11:05:24');
INSERT INTO `shenqing` VALUES ('7', '1', '1', '2', '1', '2023-05-07 11:05:26', '2023-05-07 11:05:26');
INSERT INTO `shenqing` VALUES ('11', '1', '3', '2', '2', '2023-05-07 11:15:22', '2023-05-07 11:15:22');
INSERT INTO `shenqing` VALUES ('12', '1', '2', '2', '1', '2023-08-05 23:16:04', '2023-08-05 23:16:04');
INSERT INTO `shenqing` VALUES ('13', '1', '4', '1', '1', '2023-08-05 23:24:00', '2023-08-05 23:24:00');
-- ----------------------------
-- Table structure for taanwei
-- ----------------------------
DROP TABLE IF EXISTS `taanwei`;
CREATE TABLE `taanwei` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`taanwei_name` varchar(200) DEFAULT NULL COMMENT '摊位编号 ',
`taanwei_types` int DEFAULT NULL COMMENT '摊位类型 Search111',
`zhuangtai_types` int DEFAULT NULL COMMENT '摊位状态 Search111',
`quyu_types` int DEFAULT NULL COMMENT '摊位区域 Search111',
`taanwei_content` text COMMENT '详情信息',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COMMENT='摊位信息';
-- ----------------------------
-- Records of taanwei
-- ----------------------------
INSERT INTO `taanwei` VALUES ('1', '001', '2', '1', '3', '详情信息1\r\n', '2023-05-06 21:20:01');
INSERT INTO `taanwei` VALUES ('2', '002', '1', '1', '2', '详情信息2\r\n', '2023-05-07 10:57:05');
INSERT INTO `taanwei` VALUES ('3', '003', '2', '1', '1', '详情信息3\r\n', '2023-05-07 11:02:28');
INSERT INTO `taanwei` VALUES ('4', '004', '2', '2', '3', '位置非常好\r\n', '2023-08-05 23:21:31');
-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
`id` bigint