njwxkun
/
zz
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
zz/fenis_trip-2021-5-24.sql

443 lines
22 KiB
Raw Permalink Blame History Escape

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

/*
Navicat Premium Data Transfer
Source Server : 腾讯云测试
Source Server Type : MySQL
Source Server Version : 80024
Source Host : 1.116.136.247:3306
Source Schema : fenis_trip
Target Server Type : MySQL
Target Server Version : 80024
File Encoding : 65001
Date: 24/05/2021 15:23:49
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
`banner_id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'ID主键',
`banner_title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主题',
`banner_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '广告连接',
`banner_index` int(0) NOT NULL DEFAULT 0 COMMENT '索引',
`target_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '点击后跳转的目的链接',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`banner_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '广告表\r\n' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of banner
-- ----------------------------
-- ----------------------------
-- Table structure for hotel
-- ----------------------------
DROP TABLE IF EXISTS `hotel`;
CREATE TABLE `hotel` (
`hotel_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '酒店id',
`hotel_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '酒店名称',
`hotel_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '酒店logo',
`hotel_content` blob NOT NULL COMMENT '酒店内容',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`hotel_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '酒店表\r\n' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of hotel
-- ----------------------------
-- ----------------------------
-- Table structure for hotel_video
-- ----------------------------
DROP TABLE IF EXISTS `hotel_video`;
CREATE TABLE `hotel_video` (
`hotel_video_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频名称',
`video_introduce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频介绍',
`video_index` int(0) NULL DEFAULT NULL COMMENT '排序字段',
`video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源地址',
`hotel_id` int(10) UNSIGNED ZEROFILL NOT NULL COMMENT '酒店ID',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`hotel_video_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '酒店视频表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of hotel_video
-- ----------------------------
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`news_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '新闻id',
`news_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
`news_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题配图',
`news_content` blob NOT NULL COMMENT '新闻内容',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`news_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '新闻表\r\n' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of news
-- ----------------------------
-- ----------------------------
-- Table structure for news_tag
-- ----------------------------
DROP TABLE IF EXISTS `news_tag`;
CREATE TABLE `news_tag` (
`tag_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`tag_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类别名称',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`tag_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '新闻标签表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of news_tag
-- ----------------------------
-- ----------------------------
-- Table structure for news_tag_relax
-- ----------------------------
DROP TABLE IF EXISTS `news_tag_relax`;
CREATE TABLE `news_tag_relax` (
`news_tag_relax_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`tag_id` int(0) NULL DEFAULT NULL COMMENT '标签id',
`news_id` int(0) NULL DEFAULT NULL COMMENT '新闻id',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`news_tag_relax_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of news_tag_relax
-- ----------------------------
-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限名称',
`parent_id` int(0) NULL DEFAULT NULL COMMENT '父级id',
`level_id` int(0) NULL DEFAULT NULL COMMENT '层级id',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
`permissions_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由地址',
`sort` int(0) NULL DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of permissions
-- ----------------------------
-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_id` int(0) NOT NULL COMMENT '角色id',
`permission_id` int(0) NOT NULL COMMENT '权限id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of role_permission
-- ----------------------------
-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of roles
-- ----------------------------
-- ----------------------------
-- Table structure for scenery
-- ----------------------------
DROP TABLE IF EXISTS `scenery`;
CREATE TABLE `scenery` (
`scenery_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`scenery_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '景区名称',
`scenery_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '景点公告',
`scenery_index` int(0) NULL DEFAULT NULL COMMENT '景点排序',
`scenery_introduce` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '景点介绍',
`scenery_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '景点Logo',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
`start_time` bigint(0) NULL DEFAULT NULL COMMENT '开放时间',
`end_time` bigint(0) NULL DEFAULT NULL COMMENT '结束时间',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '官网',
`traffic` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交通',
PRIMARY KEY (`scenery_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '景点表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of scenery
-- ----------------------------
INSERT INTO `scenery` VALUES (1, '红山森林动物园', 'string', 0, '红毛猩猩是动物园的“镇园之宝”', 'string', 0, 0, 0, 0, '18530065188', 'string', '红山森林动物园/火车站北广场，距我5.7km');
INSERT INTO `scenery` VALUES (2, '南京总统府', 'string', 1, '见证六个世纪得历史变迁', 'string', 0, 0, 0, 0, '15039108221', 'string', '总统府/1912商圈，距我1.1km');
-- ----------------------------
-- Table structure for scenery_picture
-- ----------------------------
DROP TABLE IF EXISTS `scenery_picture`;
CREATE TABLE `scenery_picture` (
`scenery_picture_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`picture_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片名称',
`picture_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片地址',
`picture_introduce` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片介绍',
`picture_index` int(0) NULL DEFAULT NULL COMMENT '图片排序',
`scenery_id` int(0) NOT NULL COMMENT '景区id',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`scenery_picture_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '景点图片表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of scenery_picture
-- ----------------------------
-- ----------------------------
-- Table structure for scenery_tag
-- ----------------------------
DROP TABLE IF EXISTS `scenery_tag`;
CREATE TABLE `scenery_tag` (
`scenery_tag_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`tag_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '景区标签',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`scenery_tag_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '景点标签' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of scenery_tag
-- ----------------------------
-- ----------------------------
-- Table structure for scenery_tickets
-- ----------------------------
DROP TABLE IF EXISTS `scenery_tickets`;
CREATE TABLE `scenery_tickets` (
`scenery_ticket_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`tickets_type_id` int(0) NULL DEFAULT NULL COMMENT '景区门票类型',
`tickets_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门票名字',
`tickets_price` decimal(11, 2) NULL DEFAULT NULL COMMENT '门票价格',
`ticket_introduce` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '门票介绍',
`tickets_logo` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门票logo',
`scenery_id` int(0) NOT NULL COMMENT '景区id',
`ticket_sell_num` int(0) NULL DEFAULT NULL COMMENT '销售数量 ',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`scenery_ticket_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '景点门票表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of scenery_tickets
-- ----------------------------
INSERT INTO `scenery_tickets` VALUES (1, 1, '测试', 100.00, '测试', 'string', 1, 100, 1600000, 1600000);
INSERT INTO `scenery_tickets` VALUES (2, 1, '门票名称', 0.01, '门票介绍', '门票图片路径', 1, 0, NULL, NULL);
-- ----------------------------
-- Table structure for scenery_tickets_type
-- ----------------------------
DROP TABLE IF EXISTS `scenery_tickets_type`;
CREATE TABLE `scenery_tickets_type` (
`tickets_type_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`ticket_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门票类型名称',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`tickets_type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门票类型表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of scenery_tickets_type
-- ----------------------------
INSERT INTO `scenery_tickets_type` VALUES (1, '成人票', NULL, NULL);
INSERT INTO `scenery_tickets_type` VALUES (2, '儿童票', NULL, NULL);
-- ----------------------------
-- Table structure for scenery_video
-- ----------------------------
DROP TABLE IF EXISTS `scenery_video`;
CREATE TABLE `scenery_video` (
`scenery_video_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`video_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频名称',
`video_introduce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频介绍',
`video_index` int(0) NULL DEFAULT NULL COMMENT '排序字段',
`video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源地址',
`scenery_id` int(0) NOT NULL COMMENT '外键',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`scenery_video_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '景点视频表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of scenery_video
-- ----------------------------
-- ----------------------------
-- Table structure for user_order_detail
-- ----------------------------
DROP TABLE IF EXISTS `user_order_detail`;
CREATE TABLE `user_order_detail` (
`order_detail_id` int(0) NOT NULL COMMENT '主键id',
`order_id` int(0) NULL DEFAULT NULL COMMENT '订单id',
`scenery_ticket_id` int(0) NULL DEFAULT NULL COMMENT '门票id',
`num` int(0) NULL DEFAULT NULL COMMENT '购买数量',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`order_detail_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单详情表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_order_detail
-- ----------------------------
-- ----------------------------
-- Table structure for user_orders
-- ----------------------------
DROP TABLE IF EXISTS `user_orders`;
CREATE TABLE `user_orders` (
`orders_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`order_no` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
`user_id` int(0) NOT NULL COMMENT '用户id',
`body` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品介绍',
`subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单名称',
`total_amount` decimal(11, 2) NOT NULL COMMENT '订单总金额',
`order_status` int(0) NULL DEFAULT NULL COMMENT '订单状态',
`is_de` int(0) NULL DEFAULT NULL COMMENT '是否删除',
`ali_trade_no` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付宝交易号',
`wx_trade_no` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信交易号',
`user_invoices_id` int(0) NULL DEFAULT NULL COMMENT '发票id',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
`version` int(0) NULL DEFAULT NULL COMMENT '乐观锁',
PRIMARY KEY (`orders_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单表' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of user_orders
-- ----------------------------
-- ----------------------------
-- Table structure for user_shop
-- ----------------------------
DROP TABLE IF EXISTS `user_shop`;
CREATE TABLE `user_shop` (
`user_shop_id` int(0) NOT NULL COMMENT '主键',
`user_id` int(0) NULL DEFAULT NULL COMMENT '用户id',
`scenery_ticket_id` int(0) NULL DEFAULT NULL COMMENT '门票id',
`num` int(0) NULL DEFAULT NULL COMMENT '数量id',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`user_shop_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '购物车表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_shop
-- ----------------------------
-- ----------------------------
-- Table structure for user_tickets
-- ----------------------------
DROP TABLE IF EXISTS `user_tickets`;
CREATE TABLE `user_tickets` (
`user_tickets_id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`scenery_ticket_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门票id',
`tickets_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '票密码(保留)',
`tickets_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '票号',
`tickets_code` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '二维码地址',
`tickets_time` bigint(0) NULL DEFAULT NULL COMMENT '门票得有效期时间',
`user_id` int(0) NULL DEFAULT NULL COMMENT '用户id',
`is_use` tinyint(0) NOT NULL COMMENT '是否使用',
`used_time` bigint(0) NULL DEFAULT NULL COMMENT '使用时间戳',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
`version` int(0) NULL DEFAULT NULL COMMENT '乐观锁',
PRIMARY KEY (`user_tickets_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户门票' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_tickets
-- ----------------------------
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
`password` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
`user_logo` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
`nickname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '社区昵称',
`gender` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
`openid` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (10, NULL, NULL, NULL, NULL, NULL, 'owjUD5dEt9nxwbkI0rnhuBIXEeRM');
INSERT INTO `users` VALUES (11, NULL, NULL, NULL, NULL, NULL, 'o94Uw5N9fgp4FXrklZ5bEs0AW5-U');
INSERT INTO `users` VALUES (12, NULL, NULL, NULL, NULL, NULL, 'o94Uw5OuN_TH5jEbi2novb0w8rnM');
INSERT INTO `users` VALUES (14, NULL, NULL, NULL, NULL, NULL, 'o94Uw5NRI9Gy1-WIi2Ak2rsCEetE');
INSERT INTO `users` VALUES (15, NULL, NULL, NULL, NULL, NULL, 'o94Uw5AXcSNpHIITcftos9q_1Aig');
-- ----------------------------
-- Table structure for users_role
-- ----------------------------
DROP TABLE IF EXISTS `users_role`;
CREATE TABLE `users_role` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_id` int(0) NOT NULL COMMENT '角色信息',
`user_id` int(0) NOT NULL COMMENT '用户信息',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of users_role
-- ----------------------------
-- ----------------------------
-- Table structure for wifi
-- ----------------------------
DROP TABLE IF EXISTS `wifi`;
CREATE TABLE `wifi` (
`wifi_id` int(0) NOT NULL AUTO_INCREMENT,
`wifi_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'wifi跳转PORTAL',
`create_time` bigint(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`wifi_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'wifi接入portal地址表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wifi
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;
Reference in new issue View Git Blame Copy Permalink