/*
 Navicat Premium Data Transfer

 Source Server         : mute
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : pets

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

 Date: 13/07/2023 08:59:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for pet_appointment
-- ----------------------------
DROP TABLE IF EXISTS `pet_appointment`;
CREATE TABLE `pet_appointment`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pet_type` int NULL DEFAULT NULL,
  `pet_varieties` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '品种',
  `pet_hair` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '毛色',
  `pet_weight` int NULL DEFAULT NULL,
  `pet_age` int NULL DEFAULT NULL,
  `apply_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `service_type` int NULL DEFAULT NULL,
  `pet_store` int NULL DEFAULT NULL,
  `introduce` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` int NOT NULL COMMENT '预约状态 2：服务已完成',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_appointment
-- ----------------------------
INSERT INTO `pet_appointment` VALUES (1, '倩倩', '13888888888', 1, '阿拉斯加', '黑白色', 30, 2, '2023-07-06 17:31:41', 2, 1, '脾气不是很好，尤其是洗澡的时候老是乱蹦乱跳，你们洗的时候注意安全！', 1);
INSERT INTO `pet_appointment` VALUES (2, '大白', '15555555555', 2, '加菲猫', '橘黄色', 5, 2, '2023-07-06 17:31:41', 3, 2, '疫苗的第二针。', 1);
INSERT INTO `pet_appointment` VALUES (3, 'sheng', '18354139063', 1, '拉布拉多', '米白色', 30, 2, '2023-07-06 17:31:41', 2, 2, '脾气不太温柔，洗澡的时候注意一点安全。', 1);
INSERT INTO `pet_appointment` VALUES (4, 'sheng', '18354139063', 1, '萨摩', '白', 30, 3, '2023-07-06 17:31:41', 2, 3, '洗澡澡', 0);
INSERT INTO `pet_appointment` VALUES (5, 'sheng', '12345567890', 2, '橘猫', '橙色', 2, 2, '2023-07-06 17:31:41', 2, 3, '啦啦啦啦', 1);
INSERT INTO `pet_appointment` VALUES (6, 'sheng', '23123123123', 1, '二哈', '黑白', 3, 2, '2023-07-06 17:31:41', 2, 3, '啊实打实打算', 1);
INSERT INTO `pet_appointment` VALUES (7, 'sheng', '12345678900', 1, '阿拉斯加', '黄色', 40, 4, '2023-07-06 17:31:41', 4, 1, '', 0);
INSERT INTO `pet_appointment` VALUES (8, 'sheng', '12334444488', 2, '金毛', '白色', 24, 4, '2023-07-06 17:31:41', 3, 2, '', 1);
INSERT INTO `pet_appointment` VALUES (9, 'sheng', '16778678879', 1, '阿拉', '黄色', 4, 2, '2023-07-06 17:31:41', 3, 1, '', 2);
INSERT INTO `pet_appointment` VALUES (10, 'sheng', '15121725105', 2, '咖啡猫', '黄色', 2, 2, '2023-07-06 17:31:41', 4, 1, '', 0);
INSERT INTO `pet_appointment` VALUES (11, 'sheng', '19819069652', 2, '未知', '绿色', 1, 1, '2023-07-06 17:31:41', 4, 3, '', 0);
INSERT INTO `pet_appointment` VALUES (12, 'sheng', '19757576575', 2, '方法', '78', 8, 8, '2023-07-06 17:31:41', 1, 1, '', 0);
INSERT INTO `pet_appointment` VALUES (13, 'sheng', '17575757579', 2, '787', '8', 6, 1, '2023-07-07 07:43:41', 1, 3, '', 0);
INSERT INTO `pet_appointment` VALUES (14, 'sheng', '79797979787', 1, '67878', '8', 7, 5, '2023-07-14 07:55:31', 2, 1, '', 2);

-- ----------------------------
-- Table structure for pet_commodity
-- ----------------------------
DROP TABLE IF EXISTS `pet_commodity`;
CREATE TABLE `pet_commodity`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `price` double(20, 2) NULL DEFAULT NULL,
  `introduce` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `stock` int NULL DEFAULT NULL,
  `pet_type` int NULL DEFAULT NULL,
  `savepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT 0 COMMENT '商品上下架 0：下架 1：上架',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_commodity
-- ----------------------------
INSERT INTO `pet_commodity` VALUES (3, ' 伟嘉成猫猫粮', 39.00, '【“粮”爽一夏】均衡营养，三重呵护！超高性价比精选猫粮！店内部分产品领券满299减100！领券满199减60！', 168, 2, '/pics/cat2.jpg', 1);
INSERT INTO `pet_commodity` VALUES (5, '宝路成猫粮', 119.00, '【“粮”爽一夏】一袋补充，满贯营养！千万狗狗的选择！店内部分产品领券满299减100！领券满199减60！ 【会员】0元开卡立得200积分！享专属惊喜优惠', 0, 2, '/pics/cat2.jpg', 1);
INSERT INTO `pet_commodity` VALUES (6, 'WOWO猫粮', 200.00, '【品牌闪购进行中】到手179，王耀庆推荐猫粮，3种冻干4种肉，专治挑嘴；80%肉含量，满足猫咪食肉天性，立即抢购', 0, 2, '/pics/cat2.jpg', 1);
INSERT INTO `pet_commodity` VALUES (7, '大白猫粮', 300.00, '【“粮”爽一夏】一袋补充，满贯营养！千万狗狗的选择！店内部分产品领券满299减100！领券满199减60！ 【会员】0元开卡立得200积分！享专属惊喜优惠', 110, 2, '/pics/cat2.jpg', 1);
INSERT INTO `pet_commodity` VALUES (8, '拉条猫粮', 120.00, '【“粮”爽一夏】一袋补充，满贯营养！千万狗狗的选择！店内部分产品领券满299减100！领券满199减60！ 【会员】0元开卡立得200积分！享专属惊喜优惠', 254, 2, '/pics/cat2.jpg', 0);
INSERT INTO `pet_commodity` VALUES (9, '猫粮3', 243.00, '【“粮”爽一夏】一袋补充，满贯营养！千万狗狗的选择！店内部分产品领券满299减100！领券满199减60！ 【会员】0元开卡立得200积分！享专属惊喜优惠', 196, 2, '/pics/47fe9aa58caa4055ac41dc8e4d251829.jpeg', 0);
INSERT INTO `pet_commodity` VALUES (10, '猫粮4', 222.00, '【“粮”爽一夏】均衡营养，三重呵护！超高性价比精选猫粮！店内部分产品领券满299减100！领券满199减60！', 196, 2, '/pics/cat2.jpg', 0);
INSERT INTO `pet_commodity` VALUES (13, '好好吃的狗粮啊', 100.00, '不知道写啥', 7, 1, '/pics/dcef31fcfb754fba811a00a11088fc32.jpg', 0);
INSERT INTO `pet_commodity` VALUES (14, '大白狗粮', 300.00, '大白牌狗粮就是好 谁用谁知道', 80, 1, '/pics/ccd3b48fc194493caba0ff73c1ff0d7a.jpg', 0);
INSERT INTO `pet_commodity` VALUES (15, '狗粮', 100.00, '好吃的狗粮', 11, 1, '/pics/a0531e26acb141ea82e65f68236dbbed.jpg', 0);
INSERT INTO `pet_commodity` VALUES (16, '狗粮', 100.00, '好吃的狗粮', 12, 1, '/pics/e6d4eaf6e48549a2bd8fa61d1017d31e.jpg', 0);
INSERT INTO `pet_commodity` VALUES (17, '狗粮', 231.00, '哈哈哈', 28, 1, '/pics/387237bb5d4046c58eaa75a9d310225c.jpg', 1);
INSERT INTO `pet_commodity` VALUES (18, '狗粮', 343.00, '哈哈哈', 28, 1, '/pics/4365a0895779474ebb91572d33ceda95.jpg', 0);
INSERT INTO `pet_commodity` VALUES (24, '狗粮', 322.00, '哈哈哈', 15, 1, '/pics/3767130cad394e63bf85bec9872ea2f5.jpg', 0);

-- ----------------------------
-- Table structure for pet_commodity_img
-- ----------------------------
DROP TABLE IF EXISTS `pet_commodity_img`;
CREATE TABLE `pet_commodity_img`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `savepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `cid` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_commodity_img
-- ----------------------------
INSERT INTO `pet_commodity_img` VALUES (3, '/pics/de426a3f51544b20a0fe65b8d967d29b.jpg', 12);
INSERT INTO `pet_commodity_img` VALUES (19, '/pics/40070606a4984e4d9fe860e6c36c8c4c.jpeg', 7);
INSERT INTO `pet_commodity_img` VALUES (20, '/pics/2b1eb79434664b5f862b313f442523b9.jpeg', 9);
INSERT INTO `pet_commodity_img` VALUES (21, '/pics/e7e889706c0646c5b59dd273bf6f3e2c.jpeg', 10);

-- ----------------------------
-- Table structure for pet_dict
-- ----------------------------
DROP TABLE IF EXISTS `pet_dict`;
CREATE TABLE `pet_dict`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '组id',
  `dict_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '页面显示名称',
  `dict_value` int NOT NULL COMMENT '页面提交内容',
  `sort` tinyint NOT NULL COMMENT '排序字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_dict
-- ----------------------------
INSERT INTO `pet_dict` VALUES (15, 'pet_type', '宠物狗', 1, 1);
INSERT INTO `pet_dict` VALUES (16, 'pet_type', '宠物猫', 2, 2);
INSERT INTO `pet_dict` VALUES (17, 'pet_service', '美容', 1, 1);
INSERT INTO `pet_dict` VALUES (18, 'pet_service', '洗澡', 2, 2);
INSERT INTO `pet_dict` VALUES (19, 'pet_service', '疫苗', 3, 3);
INSERT INTO `pet_dict` VALUES (20, 'pet_service', '体检', 4, 4);
INSERT INTO `pet_dict` VALUES (21, 'pet_store', '才貌双犬(大明湖店)', 1, 5);
INSERT INTO `pet_dict` VALUES (22, 'pet_store', 'Q萌(馆驿街新区南门右转200m)', 2, 6);
INSERT INTO `pet_dict` VALUES (23, 'pet_store', '又见萌宠(新万达南侧50m)', 3, 7);

-- ----------------------------
-- Table structure for pet_marriage
-- ----------------------------
DROP TABLE IF EXISTS `pet_marriage`;
CREATE TABLE `pet_marriage`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户电话',
  `pet_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物名字',
  `pet_type` int NULL DEFAULT NULL COMMENT '宠物类型',
  `savepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物大头照',
  `pet_age` int NULL DEFAULT NULL COMMENT '宠物年龄',
  `status` int NULL DEFAULT NULL COMMENT '婚配状态',
  `pet_require` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '择偶要求',
  `publish_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_marriage
-- ----------------------------
INSERT INTO `pet_marriage` VALUES (24, 'sheng', '15121725105', '喵星人', 2, '/pics/0201e8403e974885ba8f0ed8abdf95fc.jpeg', 1, 1, '喜欢可爱的', '2023-07-06 17:27:04');
INSERT INTO `pet_marriage` VALUES (25, 'sheng', '15121725105', '旺财', 1, '/pics/d4b20ba885564407951f33e402c24f83.jpg', 2, 1, '喜欢好看的', '2023-07-06 17:27:08');
INSERT INTO `pet_marriage` VALUES (26, 'sheng', '19819069652', '旺旺', 1, '/pics/a49db42bb07c478db1fd673b703b8199.jpg', 1, 0, '喜欢凶的', '2023-07-06 17:27:11');
INSERT INTO `pet_marriage` VALUES (27, 'sheng', '7878788', '汪汪', 1, '/pics/b75bf08d21f44a92bfe68560fe6637db.jpg', 2, 0, '没有要求', '2023-07-06 17:27:14');
INSERT INTO `pet_marriage` VALUES (28, 'mute11', '19819069652', '金毛', 1, '/pics/c0cde3604c7b4549b5223fb60fa299e5.jpg', 2, 0, '喜欢帅的', '2023-07-12 10:23:16');

-- ----------------------------
-- Table structure for pet_marriage_img
-- ----------------------------
DROP TABLE IF EXISTS `pet_marriage_img`;
CREATE TABLE `pet_marriage_img`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `savepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mid` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_marriage_img
-- ----------------------------
INSERT INTO `pet_marriage_img` VALUES (1, '/pics/3bb70b262558470e9901107545cd6415.jpg', 1);
INSERT INTO `pet_marriage_img` VALUES (2, '/pics/3bb70b262558470e9901107545cd6415.jpg', 1);
INSERT INTO `pet_marriage_img` VALUES (3, '/pics/3bb70b262558470e9901107545cd6415.jpg', 1);
INSERT INTO `pet_marriage_img` VALUES (4, '/pics/3bb70b262558470e9901107545cd6415.jpg', 2);
INSERT INTO `pet_marriage_img` VALUES (5, '/pics/3bb70b262558470e9901107545cd6415.jpg', 2);
INSERT INTO `pet_marriage_img` VALUES (6, '/pics/3bb70b262558470e9901107545cd6415.jpg', 2);
INSERT INTO `pet_marriage_img` VALUES (7, '/pics/3bb70b262558470e9901107545cd6415.jpg', 3);
INSERT INTO `pet_marriage_img` VALUES (8, '/pics/3bb70b262558470e9901107545cd6415.jpg', 3);
INSERT INTO `pet_marriage_img` VALUES (9, '/pics/3bb70b262558470e9901107545cd6415.jpg', 3);
INSERT INTO `pet_marriage_img` VALUES (10, '/pics/b491b17f3a4742e3aaadbf40121ec35b.jpg', 7);
INSERT INTO `pet_marriage_img` VALUES (11, '/pics/3bb70b262558470e9901107545cd6415.jpg', 7);
INSERT INTO `pet_marriage_img` VALUES (12, '/pics/de426a3f51544b20a0fe65b8d967d29b.jpg', 7);
INSERT INTO `pet_marriage_img` VALUES (13, '/pics/31bcbea6f75940599379026d7002b859.jpg', 8);
INSERT INTO `pet_marriage_img` VALUES (14, '/pics/31bcbea6f75940599379026d7002b859.jpg', 9);
INSERT INTO `pet_marriage_img` VALUES (15, '/pics/f929237a417f46f88984c6e46ec8ead0.jpg', 24);
INSERT INTO `pet_marriage_img` VALUES (16, '/pics/d3714b7ede5b408ba0992184b08c0460.jpg', 25);
INSERT INTO `pet_marriage_img` VALUES (17, '/pics/c5735224c3e545b68deee0231984e2cb.jpg', 25);
INSERT INTO `pet_marriage_img` VALUES (18, '/pics/e786bf65b5f34afbb6c1b870d12a9cca.jpg', 25);
INSERT INTO `pet_marriage_img` VALUES (19, '/pics/a4943d9623c7451bad748a52e2763510.jpg', 26);
INSERT INTO `pet_marriage_img` VALUES (20, '/pics/4aef377013364e1cb0821b14d68eca4f.jpg', 26);
INSERT INTO `pet_marriage_img` VALUES (21, '/pics/b49bdbc8decf48888d12c794d63f8e54.jpg', 27);
INSERT INTO `pet_marriage_img` VALUES (22, '/pics/56f8a124dc1d47a4b5a08396ce91c59d.jpg', 28);

-- ----------------------------
-- Table structure for pet_mycar
-- ----------------------------
DROP TABLE IF EXISTS `pet_mycar`;
CREATE TABLE `pet_mycar`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `commodity_id` int NOT NULL,
  `num` int NOT NULL,
  `create_time` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 130 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_mycar
-- ----------------------------
INSERT INTO `pet_mycar` VALUES (3, 10, 3, 1, '2023-07-04 17:04:51');
INSERT INTO `pet_mycar` VALUES (128, 12, 5, 1, '2023-07-04 19:29:09');
INSERT INTO `pet_mycar` VALUES (130, 12, 17, 1, '2023-07-12 17:24:57');

-- ----------------------------
-- Table structure for pet_order
-- ----------------------------
DROP TABLE IF EXISTS `pet_order`;
CREATE TABLE `pet_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `commodity_id` int NOT NULL COMMENT '商品id',
  `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单编号',
  `commodity_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
  `commodity_num` int NOT NULL COMMENT '购买商品数量',
  `user_id` int NOT NULL COMMENT '用户id',
  `create_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '下单时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 108 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of pet_order
-- ----------------------------
INSERT INTO `pet_order` VALUES (1, 1, '493A68D15AC44177984FF59C37085F54', '明星猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (2, 1, '0C57EF68D7964DBA972833332C09392C', '明星猫粮', 90, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (3, 4, '4A9678B6775D48FCAC7C9F9321B7747F', '好吃的狗粮', 20, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (4, 7, 'FA815D3D9FC647F2A954A5A5955C8758', '猫粮1', 45, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (5, 6, '288FADEED00A4FE7B2D06E2E8E4FCE77', 'WOWO猫粮', 23, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (6, 5, '3E6C25FBEC044991BFB912B8417FFC28', '宝路成猫粮', 180, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (7, 4, '1F7A6889EA704FB9BAEE29AF9F5020CC', '好吃的狗粮', 34, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (8, 8, '828F3CE4EEDB4334916B43A98F8E9ABE', '拉条猫粮', 35, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (9, 1, '47216C7848094C14AF38237E54F126CD', '明星猫粮', 20, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (10, 1, 'FF3579F575DE4CDBB8038394BDAA3810', '明星猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (11, 3, '18A5D6FF668346B4BF4B376706C47051', ' 伟嘉成猫猫粮', 5, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (12, 7, '87482491936B4D4B937A7DB3BC07DD84', '大白猫粮', 4, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (13, 7, 'A4316CDFDE5145E88A0BDB51E2997428', '大白猫粮', 1, 12, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (14, 4, '31D766ED64D04C2CA335E2191CB970FD', '好吃的狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (15, 16, '9D575D1F4F084A3BB49E5F017CEC046C', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (16, 15, '13ED44548B1F4239A1D684F95CEF5184', '狗粮', 6, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (17, 8, 'E37F3A91E55D466B86E633B14ADE729A', '拉条猫粮', 3, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (18, 4, '401DFA8F245A42CDA466F43A65D58809', '好吃的狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (19, 16, 'E627CAA4E024480E8823BBC14DCEDCC1', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (34, 10, 'F8C674BCD765427C9A31F5D98B4F30DA', '猫粮4', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (35, 3, 'c0166ae86ca74942aa7048f1759c18a2', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (36, 3, 'aaf65bb1a7b14b6989b723d987253c4c', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (37, 5, '69046379493a41338dd6c46632fabc9d', '宝路成猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (38, 10, 'ae5fad8604694d6badf04223c4331d0f', '猫粮4', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (39, 3, 'b442e28eb4214d3db50d1bb122a70fd9', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (40, 3, 'c64a6622c1324073b671ab505b791b14', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (41, 3, '18E401ED0DC4494E9CC896CF1F745DA2', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (42, 13, 'FD5578530DAD4D0E8D910BB2347C9C14', '好好吃的狗粮啊', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (43, 3, '220F0B04E8464591AA13DD213BEF9FCF', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (44, 13, 'B60FC71952514AAD837FDE61A2A73A47', '好好吃的狗粮啊', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (45, 4, 'BE327D5C236B40EB8F7E8F93AE8F8F43', '好吃的狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (46, 8, '0D75BE4DD12D4D6898A9938357F7EFC9', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (47, 18, '9A1A4A9B14804E948F230291FF772652', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (48, 8, '6F63FA99CE294984B932B5E24F42CFDF', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (49, 18, '858D65D403284E6AAAAB94C24A7C0344', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (50, 3, '21957DFC75C343B69E85FE6CD5E1137D', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (51, 18, 'A878A0C9CE0E47D39C61D30E0C70C810', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (52, 3, 'E17520565C2342DF89326C32375C41E9', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (53, 18, '052FC1D4B30C405D8C8EC59300C5A3C2', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (54, 3, 'F0E02E1115A74ED3AA55029EEB4CD7C9', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (55, 3, '53D57B948759443A882A26886C317DEF', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (56, 3, 'B382DD6C4E1E48B088D7865406814240', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (57, 8, '365EECDA9AAD422EAFEE93C859F19387', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (58, 8, '48F11820F2664C8DA02B40B6D437A080', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (59, 8, '3F8B1530E28F490CA607459CC9D6AC4A', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (60, 8, 'FD240F713BF44B59B6031DB4973D2B21', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (61, 3, 'F092571A040A462F936A34D956699469', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (62, 18, '4327E1CAD29840738374875734ED5F09', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (63, 5, '5E63A42D000F4B71B2F5B4A7738DDFBC', '宝路成猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (64, 15, 'C5D66F4D4FE6477DA67DEB51DDE327B2', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (65, 17, 'D87C9C24A78E445FA79F6A7BC3A32C3D', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (66, 8, '956C7C7FE41544D1ABE84E36A3F9D7D3', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (67, 9, '965022A6D25846579F9997BF0AA7830B', '猫粮3', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (68, 16, 'F527554B915D4FEFA37B11C2A707713B', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (69, 16, 'CB12EC7255404D87B44A17265163DCCC', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (70, 17, '4432F24D8421452C868A00B18BE6D4C6', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (71, 3, '46BF6CB636904423915C88B2E4B82271', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (72, 14, '6279F55BCD3D42B7893E6D1C898E1B5D', '大白狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (73, 16, '6B06FBBA22DF495EBE01F65866EE6DC6', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (74, 17, '75AE6E6A959A4533BEB10A6379A48FCF', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (75, 24, 'E43DCBD935564D46A5986C3241D9972C', '狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (76, 4, '6BAC134D5F9645A7AEDE15EDDDAA4121', '好吃的狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (77, 8, '5009518F54934288858376A9B6EBBC2F', '拉条猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (78, 13, 'B192F9F5E3DC47A59A456569CD0677EC', '好好吃的狗粮啊', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (79, 14, '05761C138F5A4A40B3EECA9A71E86555', '大白狗粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (80, 3, '78C06CC2D88B464FA162DD6FE8439231', ' 伟嘉成猫猫粮', 1, 10, '0000-00-00 00:00:00');
INSERT INTO `pet_order` VALUES (81, 4, 'CD630FF5DD324786B6F7E568B80E5AFB', '好吃的狗粮', 1, 12, '2023-06-21 14:25:09');
INSERT INTO `pet_order` VALUES (82, 3, '487A3C3A84DE4FCCA161D52632334C57', ' 伟嘉成猫猫粮', 1, 12, '2023-06-21 14:25:41');
INSERT INTO `pet_order` VALUES (83, 4, 'A344F06CC454438EB3357A52863A4D92', '好吃的狗粮', 1, 12, '2023-06-21 15:53:45');
INSERT INTO `pet_order` VALUES (84, 14, '10A449C5F562472491AECBDAE8C168B0', '大白狗粮', 1, 12, '2023-06-21 15:53:54');
INSERT INTO `pet_order` VALUES (85, 3, 'E716D39AE88B44929CD3FF10A22868F7', ' 伟嘉成猫猫粮', 2, 12, '2023-06-21 15:55:44');
INSERT INTO `pet_order` VALUES (86, 24, '1BBF2139A47C431C8230B7A0A41AC656', '狗粮', 2, 12, '2023-06-21 15:55:44');
INSERT INTO `pet_order` VALUES (87, 18, '0231F729F37A4D2AA63653C1D77E0036', '狗粮', 1, 12, '2023-06-21 16:11:41');
INSERT INTO `pet_order` VALUES (88, 9, '57D66EB922D540F889FDA5A5973F37CB', '猫粮3', 1, 12, '2023-06-21 16:15:47');
INSERT INTO `pet_order` VALUES (89, 15, '37F266366ED846E5A74C317CCF59728F', '狗粮', 1, 12, '2023-06-21 16:15:47');
INSERT INTO `pet_order` VALUES (90, 24, '25F1613CE0FA478A9A04C12A64367CE8', '狗粮', 1, 12, '2023-06-21 16:15:47');
INSERT INTO `pet_order` VALUES (91, 14, '263741ADF9214818B3CE0313A3FF88D2', '大白狗粮', 2, 12, '2023-06-21 16:16:48');
INSERT INTO `pet_order` VALUES (92, 8, 'E1E7D61FE384493DB342191D9809E5EA', '拉条猫粮', 2, 12, '2023-06-21 16:17:26');
INSERT INTO `pet_order` VALUES (93, 17, 'C31697B5DD4E43B4AA8FDA6B5572DAD7', '狗粮', 2, 12, '2023-06-21 16:17:26');
INSERT INTO `pet_order` VALUES (94, 14, '55109549C83A42EC8572D3AE78A21C1D', '大白狗粮', 1, 12, '2023-06-24 10:59:31');
INSERT INTO `pet_order` VALUES (95, 14, '8EF450BABD834900BC38506F665D3DDE', '大白狗粮', 1, 42, '2023-06-24 16:43:28');
INSERT INTO `pet_order` VALUES (96, 14, '9B53A97D7BCE4652AF5996ACF591BC38', '大白狗粮', 1, 12, '2023-07-04 19:21:07');
INSERT INTO `pet_order` VALUES (97, 14, 'F9F184FF252446A6B6C39C7001F5C16F', '大白狗粮', 1, 12, '2023-07-04 19:21:12');
INSERT INTO `pet_order` VALUES (98, 14, '4641B7E1F3304D398B61B7F757955318', '大白狗粮', 1, 12, '2023-07-04 19:23:25');
INSERT INTO `pet_order` VALUES (99, 14, 'DCB9206C30E349A9A1A8341267A97382', '大白狗粮', 1, 12, '2023-07-04 19:23:53');
INSERT INTO `pet_order` VALUES (100, 14, '3670617B8DDD4F11997846AE6C5768D3', '大白狗粮', 1, 12, '2023-07-04 19:25:36');
INSERT INTO `pet_order` VALUES (101, 14, '48A3B30023814E9F945A78258F289B46', '大白狗粮', 1, 12, '2023-07-04 19:26:20');
INSERT INTO `pet_order` VALUES (102, 13, '25F9BCDB692A41A3B6D56B99EE74A7BC', '好好吃的狗粮啊', 1, 12, '2023-07-04 19:27:00');
INSERT INTO `pet_order` VALUES (103, 3, '9DBC9E2D47A94620AA2F1BF39B10C140', ' 伟嘉成猫猫粮', 1, 12, '2023-07-04 19:27:50');
INSERT INTO `pet_order` VALUES (104, 14, '495BD51C4CBE4FF6A091FA227ACD9830', '大白狗粮', 1, 12, '2023-07-04 19:27:50');
INSERT INTO `pet_order` VALUES (105, 3, '4CA2191789854BDF87ED20B0C6132637', ' 伟嘉成猫猫粮', 1, 12, '2023-07-04 19:28:29');
INSERT INTO `pet_order` VALUES (106, 14, '2FD3471F019A42EF99EF4D5C6DA21E09', '大白狗粮', 1, 12, '2023-07-04 19:28:29');
INSERT INTO `pet_order` VALUES (107, 10, 'FCF2DF5E51DE4AEE83B01176F426F1B5', '猫粮4', 1, 12, '2023-07-04 19:39:50');

-- ----------------------------
-- Table structure for pet_reply
-- ----------------------------
DROP TABLE IF EXISTS `pet_reply`;
CREATE TABLE `pet_reply`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `reply_user` int NOT NULL,
  `reply_content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pet_talke_id` int NOT NULL,
  `reply_time` date NOT NULL,
  `rname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '被回复人的名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_reply
-- ----------------------------
INSERT INTO `pet_reply` VALUES (12, 12, '哈哈哈，可以', 5, '2023-01-13', NULL);
INSERT INTO `pet_reply` VALUES (14, 12, '哈哈哈', 8, '2023-02-03', NULL);
INSERT INTO `pet_reply` VALUES (17, 12, '测试', 10, '2023-02-08', NULL);
INSERT INTO `pet_reply` VALUES (18, 12, 'hhh ', 10, '2023-02-08', NULL);
INSERT INTO `pet_reply` VALUES (19, 12, '哈哈哈', 11, '2023-02-10', NULL);
INSERT INTO `pet_reply` VALUES (20, 12, '是吗', 11, '2023-02-10', NULL);
INSERT INTO `pet_reply` VALUES (23, 10, '成功了吗？', 14, '2023-02-15', NULL);
INSERT INTO `pet_reply` VALUES (24, 12, '成功了呀 O(∩_∩)O哈哈~\n', 14, '2023-02-15', '倩倩');
INSERT INTO `pet_reply` VALUES (25, 12, '对的，你说话太狠了', 2, '2023-02-22', NULL);
INSERT INTO `pet_reply` VALUES (35, 12, '可能是需要个老伴了。', 1, '2023-04-17', NULL);
INSERT INTO `pet_reply` VALUES (36, 12, '没有呀', 2, '2023-04-17', 'sheng');
INSERT INTO `pet_reply` VALUES (37, 39, 'hh,是的', 2, '2023-05-22', NULL);
INSERT INTO `pet_reply` VALUES (38, 39, '哈哈', 2, '2023-05-22', 'sheng');
INSERT INTO `pet_reply` VALUES (39, 42, '测试成功了吗？', 18, '2023-06-24', NULL);
INSERT INTO `pet_reply` VALUES (40, 12, '成功了', 18, '2023-06-24', 'mute10');

-- ----------------------------
-- Table structure for pet_talke
-- ----------------------------
DROP TABLE IF EXISTS `pet_talke`;
CREATE TABLE `pet_talke`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `publish_time` datetime NOT NULL,
  `visiable` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_talke
-- ----------------------------
INSERT INTO `pet_talke` VALUES (1, 10, '我家的猫咪最近晚上老是叫，请问有猫友知道是什么情况吗？', '2022-01-13 19:30:45', 0);
INSERT INTO `pet_talke` VALUES (2, 10, '我家的二哈老是和我吵架，我不能说话，只要一说话他就在哪嗷嗷嗷的叫，难道是我说话太难听嘛~', '2022-01-13 19:30:45', 0);
INSERT INTO `pet_talke` VALUES (14, 12, '测试Post', '2023-02-15 11:09:46', 0);
INSERT INTO `pet_talke` VALUES (15, 12, '测试', '2023-02-15 11:10:02', 1);

-- ----------------------------
-- Table structure for pet_user
-- ----------------------------
DROP TABLE IF EXISTS `pet_user`;
CREATE TABLE `pet_user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `role` int NULL DEFAULT NULL,
  `sex` int NULL DEFAULT NULL,
  `age` int NULL DEFAULT NULL,
  `birth` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name_unique`(`user_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of pet_user
-- ----------------------------
INSERT INTO `pet_user` VALUES (10, 'psycho', '321a149b95e25317dc61c3bac6a78aec', '/pics/3d3d1ebb9c8f4eee84da0567fdc2574e.jpg', 1, 0, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (12, 'sheng', '$2a$10$fXOOmsVe3kcHr2tOJ9NumOnRVEFcNHULWOV6ZmYfQFtCGBgH84Nke', '/pics/474fc75a30ba43afad79a376dd911b05.jpg', 1, 1, 22, '1998-02-13', '15121725105', '2294407483@qq.com');
INSERT INTO `pet_user` VALUES (31, 'mute', '321a149b95e25317dc61c3bac6a78aec', '/pics/3d3d1ebb9c8f4eee84da0567fdc2574e.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (32, 'mute3', '202390d60cce0fa7c6f132390de678fa', '/pics/8dce8f59dbbf48b98e4d6a0348ce0c0d.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (33, 'mute4', '202390d60cce0fa7c6f132390de678fa', '/pics/ee4ca24c6d204af5a61c31bb832fdc2f.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (34, 'mute2', '321a149b95e25317dc61c3bac6a78aec', '/pics/4f5dd7afd6be4514a706c9d9d916affb.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (35, 'mute5', '321a149b95e25317dc61c3bac6a78aec', '/pics/ae006767ab104b91bdfa5c392dc425f1.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (38, '龙运明', '$2a$10$U2V3g7.BIytAt5m4EC6XCObKwEhFNGKFPYDFjtqi../DYn/6QN3rG', '/pics/4d95a18980e3438fbcac1ec8fcd8b9dc.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (39, '龙运明2', '$2a$10$4KlSb72NhaXtnw7AvAw1NeyDalyjkZmkNkp6QoVMtZj.JsQo.xApS', '/pics/5a623c4f28d14f7787cff1c8d4977eff.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (40, '龙运明3', '$2a$10$BLqi1yxDMBLszZw0aXhs0.UWPSuDBRF1WBIyDDNnrqt6n9kF4xVGi', '/pics/4d8a43b6874c41a2bd645a4f4f3f0fd3.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (41, '龙运明4', '$2a$10$vcFkx5bCwUjdxYC.wFW5VOlMjbNF2n/fM4FItP48b20twZtxRiCpq', '/pics/c9342e95f94b4b42ba27760331228ad2.jpg', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (42, 'mute10', '$2a$10$pWEpO7ic/PHhjca.IAYvteUSKmy3MiuC5Vj7febvxMCnbbmqQWSae', '/pics/0bcacaaf55f943f1b81095eaaf7c17d5.png', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pet_user` VALUES (43, 'mute11', '$2a$10$anaT8h1TJbX8tVI.rtrs1.9vuMUGFVhn9302sOuHa4EXZRha5oLdG', '/pics/36e6749baa6146169b584bc2c343995f.jpg', 0, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for pet_video
-- ----------------------------
DROP TABLE IF EXISTS `pet_video`;
CREATE TABLE `pet_video`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `savepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频路径',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频名称',
  `coverpath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频封面路径',
  `video_details` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频详情介绍',
  `userid` int NULL DEFAULT NULL COMMENT '视频作者',
  `publish_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of pet_video
-- ----------------------------
INSERT INTO `pet_video` VALUES (25, '/pics/cf2742ece7164d0585a4f33615f9c275.mp4', '搞笑的喵星人', '/pics/56248d6d5df1444e9d07c28ede6e29f3.jpeg', '哈哈哈', 12, '2023-02-15 19:32:16');
INSERT INTO `pet_video` VALUES (26, '/pics/8bb9ca9162c44837bf7c7104b6497ba8.mp4', '好可爱的喵', '/pics/06e68b4949f542e891f62d6fc422fb3b.jpeg', '哈哈哈哈', 31, '2023-02-27 19:17:02');

-- ----------------------------
-- Table structure for role_meum
-- ----------------------------
DROP TABLE IF EXISTS `role_meum`;
CREATE TABLE `role_meum`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `href` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pid` int NOT NULL,
  `roleid` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_meum
-- ----------------------------
INSERT INTO `role_meum` VALUES (1, 'href', '宠物商品', 'iconfont icon-chongwuyongpin', 0, 0);
INSERT INTO `role_meum` VALUES (2, '/commodity/cat', '宠物猫', 'iconfont icon-maomi', 1, 0);
INSERT INTO `role_meum` VALUES (3, '/commodity/dog', '宠物狗', 'iconfont icon-gou', 1, 0);
INSERT INTO `role_meum` VALUES (4, 'href', '宠物预约', 'iconfont icon-dianhuajianpantianchong', 0, 0);
INSERT INTO `role_meum` VALUES (5, '/applyAppointment', '预约申请', 'iconfont icon-baoming', 4, 0);
INSERT INTO `role_meum` VALUES (6, '/applyAppointmentList', '预约列表', 'iconfont icon-liebiao', 4, 1);
INSERT INTO `role_meum` VALUES (7, 'href', '宠物伴侣', 'iconfont icon-banlv', 0, 0);
INSERT INTO `role_meum` VALUES (8, '/addMarriage', '发布宠物信息', 'iconfont icon-fabu', 7, 0);
INSERT INTO `role_meum` VALUES (9, '/marriageList', '伴侣列表', 'iconfont icon-ren-duoren', 7, 0);
INSERT INTO `role_meum` VALUES (10, 'href', '商品管理', 'iconfont icon-shangpinguanli', 0, 1);
INSERT INTO `role_meum` VALUES (11, '/addCommodity', '添加商品', 'iconfont icon-shangpintianjia', 10, 1);
INSERT INTO `role_meum` VALUES (12, '/commodityList', '商品列表', 'iconfont icon-shangpinliebiao', 10, 1);
INSERT INTO `role_meum` VALUES (13, 'href', '用户授权', 'iconfont icon-yonghuquanxian', 0, 1);
INSERT INTO `role_meum` VALUES (14, '/userRole', '授权信息', 'el-icon-thumb', 13, 1);
INSERT INTO `role_meum` VALUES (15, '/Talk', '宠物论坛', 'iconfont icon-14', 0, 0);
INSERT INTO `role_meum` VALUES (16, '/myCar', '我的购物车', 'iconfont icon-gouwuchekong', 0, 0);
INSERT INTO `role_meum` VALUES (17, '/myOrder', '我的订单', 'iconfont icon-baoming', 0, 0);
INSERT INTO `role_meum` VALUES (18, '/video', '萌宠微视', 'iconfont icon-shipin', 0, 0);
INSERT INTO `role_meum` VALUES (19, '/statistics', '销售统计', 'iconfont icon-tongjibaobiao', 0, 0);

-- ----------------------------
-- Table structure for role_meum_copy1
-- ----------------------------
DROP TABLE IF EXISTS `role_meum_copy1`;
CREATE TABLE `role_meum_copy1`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `href` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pid` int NOT NULL,
  `roleid` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_meum_copy1
-- ----------------------------
INSERT INTO `role_meum_copy1` VALUES (1, 'href', '宠物商品', 'iconfont icon-chongwuyongpin', 0, 0);
INSERT INTO `role_meum_copy1` VALUES (2, '/commodityDetails/dog', '宠物狗', 'iconfont icon-gou', 1, 0);
INSERT INTO `role_meum_copy1` VALUES (3, '/commodityDetails/cat', '宠物猫', 'iconfont icon-maomi', 1, 0);
INSERT INTO `role_meum_copy1` VALUES (4, 'href', '宠物预约', 'iconfont icon-dianhuajianpantianchong', 0, 0);
INSERT INTO `role_meum_copy1` VALUES (5, '/applyAppointment', '预约申请', 'iconfont icon-baoming', 4, 0);
INSERT INTO `role_meum_copy1` VALUES (6, '/appointmentList', '预约列表', 'iconfont icon-liebiao', 4, 1);
INSERT INTO `role_meum_copy1` VALUES (7, 'href', '宠物伴侣', 'iconfont icon-banlv', 0, 0);
INSERT INTO `role_meum_copy1` VALUES (8, '/addMarriage', '发布宠物信息', 'iconfont icon-fabu', 7, 0);
INSERT INTO `role_meum_copy1` VALUES (9, '/marriageList', '伴侣列表', 'iconfont icon-ren-duoren', 7, 0);
INSERT INTO `role_meum_copy1` VALUES (10, 'href', '商品管理', 'iconfont icon-shangpinguanli', 0, 1);
INSERT INTO `role_meum_copy1` VALUES (11, '/addCommodity', '添加商品', 'iconfont icon-shangpintianjia', 10, 1);
INSERT INTO `role_meum_copy1` VALUES (12, '/commodityList', '商品列表', 'iconfont icon-shangpinliebiao', 10, 1);
INSERT INTO `role_meum_copy1` VALUES (13, '/talke', '宠物论坛', 'iconfont icon-14', 0, 0);
INSERT INTO `role_meum_copy1` VALUES (14, '/myCar', '我的购物车', 'iconfont icon-gouwuchekong', 0, 0);
INSERT INTO `role_meum_copy1` VALUES (15, '/userRole', '用户授权', 'iconfont icon-yonghuquanxian', 0, 1);
INSERT INTO `role_meum_copy1` VALUES (16, '/tongji', '销售统计', 'iconfont icon-tongjibaobiao', 0, 0);
INSERT INTO `role_meum_copy1` VALUES (17, '/petVideo', '萌宠微视', 'iconfont icon-shipin', 0, 0);

SET FOREIGN_KEY_CHECKS = 1;