/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MariaDB
 Source Server Version : 100123
 Source Host           : localhost:3306
 Source Schema         : adopt

 Target Server Type    : MariaDB
 Target Server Version : 100123
 File Encoding         : 65001

 Date: 13/12/2022 19:53:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for addcai
-- ----------------------------
DROP TABLE IF EXISTS `addcai`;
CREATE TABLE `addcai`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL COMMENT '用户表id的外键',
  `caiId` int(11) NOT NULL COMMENT '宠物表id的外键',
  `adoptTime` date NOT NULL,
  `state` int(11) NULL DEFAULT 1 COMMENT '是否同意被领养 0 是不同意 1 还在审核 2 是同意',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk3`(`userId`) USING BTREE,
  INDEX `fk4`(`caiId`) USING BTREE,
  CONSTRAINT `fk3` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk4` FOREIGN KEY (`caiId`) REFERENCES `cai` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of addcai
-- ----------------------------
INSERT INTO `addcai` VALUES (1, 1, 1, '2019-08-21', 1);
INSERT INTO `addcai` VALUES (5, 2, 5, '2019-08-17', 0);
INSERT INTO `addcai` VALUES (13, 1, 5, '2019-09-01', 0);

-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员的名字',
  `adminPwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `realName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '真实的名字',
  `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话',
  `Email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `birthday` date NOT NULL,
  `sex` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'a.png',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES (1, '海猫络合物', 'yi123', '杨一', '13902193927', '2425902914@qq.com', '1993-09-10', '男', 'a1.png', '海猫络合物，简称海猫络合物');
INSERT INTO `admins` VALUES (2, '大伟哥', 'wemz123', '王二麻子', '14402193927', '2425902016@qq.com', '1994-09-12', '男', 'a2.png', '米哈游创始人，你坏事做尽啊');
INSERT INTO `admins` VALUES (3, '向日葵的花语', 'zs123', '张三', '14495893927', '2917902016@qq.com', '1994-10-12', '男', 'a3.png', '向日葵，为你生产额外阳光的经济作物，尝试尽可能多的种植吧。花费：50阳光耐久：300冷却时间：7.5s。有着很强的攻击性');
INSERT INTO `admins` VALUES (4, '陈睿', 'ls123', '李四', '14495893012', '2107902016@qq.com', '1994-06-09', '男', 'a4.png', '你所热爱的，就是你的金钱。');
INSERT INTO `admins` VALUES (5, '科比', 'ww123', '王五', '14495890112', '2992902016@qq.com', '1995-06-12', '女', 'a5.png', '科比，NBA球星，能力是闪电旋风劈。');
INSERT INTO `admins` VALUES (6, '催逝员', 'zl123', '赵六', '13195890112', '2992909126@qq.com', '1995-09-12', '男', 'a6.png', '鸡汤来了。诶，这这，这都菜都齐了，怎么还不吃呀。哎哟哟，王大队张。哎呀你这人就喜欢开玩笑。哎呀，快趁热吃吧，我不打扰，我走了，哈。司令，这鸡汤十分的珍贵，应该要同志们先喝。我这一个炊事员，这么能喝这鸡汤呢。');
INSERT INTO `admins` VALUES (7, '柯洁', 'sql1234', '孙七', '13195890081', '2992909823@qq.com', '1995-10-12', '男', 'a7.png', '柯洁，当代棋圣，酒罐王，擅长搞抽象。');
INSERT INTO `admins` VALUES (8, '东雪莲', '342', '342', '342', '342', '2019-08-20', '女', 'a8.png', '著名爱国主播，在日本留学，主播主打的就是爱国，狠狠注入爱国基因。');
INSERT INTO `admins` VALUES (9, '战狠昊京', '111', '卢卡', '15797959509', '2425549281@qq.com', '2019-08-05', '男', 'a9.png', '吴京的专属替身，能力是绳之以法，依托答辩等等。');
INSERT INTO `admins` VALUES (10, '矮人科技', '12345', '柯洁刀哥私生子', '12345657834', '2425549281@qq.com', '2019-08-05', '男', 'a10.png', '\r\n吾等被缩毛巾，体积小便携，发一包，放水中大，何掣之不坏，以拭足，拭面，拭口皆佳用，汝视开后若圆饼，放水中遇水变大，吸水甚强。既开，大加厚毛巾，卿视之岂挣都挣不坏，得毛不坠，用七八尽。何谓？于何处买？下小黄车，买五包送五包；乃作邮。\r\n\r\n');
INSERT INTO `admins` VALUES (12, '蔡徐坤', '12345', '鸡你太美', '15797959509', '2425549281@qq.com', '1990-01-30', '女', 'a12.png', '小黑子食不食油饼');
INSERT INTO `admins` VALUES (13, '李荣先辈', '6666', 'homo特有的', '15797959509', '2425549281@qq.com', '1990-01-30', '女', 'a13.png', '压力马斯内');
INSERT INTO `admins` VALUES (14, '贝尔', '1111', '孙悟空', '15797959509', '2425549281@qq.com', '1990-01-30', '女', 'a11.png', '号称孙悟空，无敌的存在！！');
INSERT INTO `admins` VALUES (15, '丁真', '6', '6', '15797959509', '2425549281@qq.com', '1990-01-30', '女', 'a14.png', '妈妈生的');

-- ----------------------------
-- Table structure for answer
-- ----------------------------
DROP TABLE IF EXISTS `answer`;
CREATE TABLE `answer`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NULL DEFAULT NULL,
  `replayId` int(11) NULL DEFAULT NULL,
  `commentId` int(11) NOT NULL,
  `answerTime` date NOT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk8`(`userId`) USING BTREE,
  INDEX `fk11`(`commentId`) USING BTREE,
  INDEX `fk10`(`replayId`) USING BTREE,
  CONSTRAINT `fk10` FOREIGN KEY (`replayId`) REFERENCES `answer` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk11` FOREIGN KEY (`commentId`) REFERENCES `comment` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk8` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of answer
-- ----------------------------
INSERT INTO `answer` VALUES (1, 2, NULL, 8, '2018-08-23', '666 ');
INSERT INTO `answer` VALUES (13, 34, NULL, 11, '2022-12-13', '6');

-- ----------------------------
-- Table structure for apply
-- ----------------------------
DROP TABLE IF EXISTS `apply`;
CREATE TABLE `apply`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `age` int(11) NOT NULL,
  `telephone` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `message` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `applyTime` date NOT NULL,
  `state` int(11) NULL DEFAULT 2,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of apply
-- ----------------------------
INSERT INTO `apply` VALUES (1, 'Wu Xin', '2425549281@qq.com', 24, '15797959509', '想打球', '2019-08-29', 1);
INSERT INTO `apply` VALUES (2, '张三丰', '2425549281@qq.com', 21, '15797959509', '当打球！！！！！', '2019-09-04', 2);
INSERT INTO `apply` VALUES (3, '4334', '4343', 4334, '4343', '434343', '2019-09-05', 2);
INSERT INTO `apply` VALUES (4, '公孙策', '2425549281@qq.com', 45, '15797959509', '我想保护流浪动物。', '2019-09-05', 1);
INSERT INTO `apply` VALUES (5, '公孙策', '2425549281@qq.com', 21, '15797959509', '6', '2022-12-10', 2);

-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `actionTime` date NOT NULL,
  `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `peoples` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `event` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of blog
-- ----------------------------
INSERT INTO `blog` VALUES (1, '2021-11-14', '上海市闵行区', '海猫络合物', '《明日方舟》主题咖啡厅-冬日特别补给点', '主题咖啡厅');
INSERT INTO `blog` VALUES (2, '2024-09-01', '浙江省杭州市', '柯洁', '柯洁禧运楼联动原神，摆平心态下下棋', '捷豹联动原神');
INSERT INTO `blog` VALUES (3, '2022-05-20', '日本东京', 'たかはら はいり', '东京的店位于4层，从3层的楼梯继续向上走就可以看到旁边贴满了主视觉图与各部队的插画。店内也四处都装点着插画。当然菜单更是丰盛。', 'HEAVEN BURNS RED');
INSERT INTO `blog` VALUES (4, '2022-03-10', '全国多处省会城市', '大伟哥，肯爷爷', '在《原神》主题门店购买指定套餐并对店员说出口令“异世相遇，尽享美味”，可得《原神》与肯德基联动款徽章1对。此外，自3月8日起至3月21日购买指定套餐可得“原神异世寻味礼”游戏兑换码1份。', '原神联动KFC');
INSERT INTO `blog` VALUES (5, '2014-03-10', '天津市', 'bilibili', '二次元的钱真好赚', '时光代理人联动蛋糕店');
INSERT INTO `blog` VALUES (6, '2014-05-10', '广州，上海等地', '未知', '无', '黑塔利亚联动餐厅');

-- ----------------------------
-- Table structure for cai
-- ----------------------------
DROP TABLE IF EXISTS `cai`;
CREATE TABLE `cai`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `caiName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '性别',
  `birthday` date NOT NULL,
  `caiType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '宠物类型',
  `pic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头像',
  `state` int(11) NOT NULL DEFAULT 1 COMMENT '现在的状态 0 没有申请领养 1 被申请领养 2 已经被领养',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of cai
-- ----------------------------
INSERT INTO `cai` VALUES (1, '金丝虾球', '上海', '2022-03-10', '原神', 'cai1_1.jpg,cai1_2.jpg,cai1_3.jpg', 1, '金丝虾球是用面丝、虾仁、香蕉搭配做出来的一道美食,外边看起来像烟花一般绚烂,吃起来口感也是特别棒');
INSERT INTO `cai` VALUES (5, '盐风城美食', '上海', '2021-11-21', '明日方舟', 'cai2-1.jpg,cai2-2.jpg', 0, '用美食来表现所爱的游戏也是个很有意思的事。');
INSERT INTO `cai` VALUES (6, '异世相遇套餐', '各地省会', '2022-03-20', '原神', 'cai3-3.jpg,cai3-4.jpg', 1, '这是您的二次元肥宅套餐，二刺猿真下头');

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NULL DEFAULT NULL,
  `adminsId` int(11) NULL DEFAULT NULL,
  `caiId` int(11) NULL DEFAULT NULL,
  `commentTime` date NOT NULL,
  `content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论的内容',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk1`(`userId`) USING BTREE,
  INDEX `fk2`(`caiId`) USING BTREE,
  INDEX `fk5`(`adminsId`) USING BTREE,
  CONSTRAINT `fk1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk2` FOREIGN KEY (`caiId`) REFERENCES `cai` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk5` FOREIGN KEY (`adminsId`) REFERENCES `admins` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES (8, 8, NULL, 5, '2019-08-22', '6');
INSERT INTO `comment` VALUES (11, 1, NULL, 5, '2019-08-30', '好好好。');
INSERT INTO `comment` VALUES (12, 1, NULL, 5, '2019-08-30', '关注永雏塔菲喵');

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test`  (
  `Time` date NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('2019-08-23');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
  `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `Email` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Email',
  `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `pic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 't0.jpg',
  `state` int(11) NULL DEFAULT 0 COMMENT '有无领养宠物的经历 0 是没有 1 是由',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '永雏塔菲', 'zsf123', '男', 100, '13809182091', '2425549281@qq.com', '湖北武当山', 't1.jpg', 1);
INSERT INTO `user` VALUES (2, '东雪莲', 'syq123', '男', 50, '13908457344', '2425549281@qq.com', '湖北武当山', 't2.jpg', 0);
INSERT INTO `user` VALUES (3, '马保国', 'ylz123', '男', 45, '13903827601', '2425549281@qq.com', '湖北武当山', 't3.jpg', 1);
INSERT INTO `user` VALUES (5, '老八', 'zm123', '女', 23, '13903810621', '2425549281@qq.com', '蒙古科尔沁', 't5.jpg', 1);
INSERT INTO `user` VALUES (8, '徐佳乐', 'yss123', '女', 35, '13123819301', '2425549281@qq.com', '光明顶', 't8.jpg', 0);
INSERT INTO `user` VALUES (17, '抽象', '4444', '女', 32, '15797959509', '2425549281@qq.com', '古墓', 't20.jpg', 0);
INSERT INTO `user` VALUES (33, '王宇', '525525', '1', 21, '15666285298', '2941004139@qq.com', '中洋和天下27号楼1单元401', 't17.jpg', 0);
INSERT INTO `user` VALUES (34, '抽象人生', '12345', '男', 21, '15797959509', '2425549281@qq.com', '中洋和天下27号楼1单元401', 't0.jpg', 0);

SET FOREIGN_KEY_CHECKS = 1;