代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : 180.76.119.18
Source Server Version : 50529
Source Host : localhost:3306
Source Database : animal
Target Server Type : MYSQL
Target Server Version : 50529
File Encoding : 65001
Date: 2020-11-16 20:34:10
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`sex` varchar(255) DEFAULT '女',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('3', '1', '1', 'http://127.0.0.1:3000/public/img/admin/admin/1605343434611-QQ图片20191009222016.jpg', '男');
-- ----------------------------
-- Table structure for `collection`
-- ----------------------------
DROP TABLE IF EXISTS `collection`;
CREATE TABLE `collection` (
`collectionId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`rticleaId` int(11) NOT NULL,
PRIMARY KEY (`collectionId`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of collection
-- ----------------------------
INSERT INTO `collection` VALUES ('1', '41', '1');
INSERT INTO `collection` VALUES ('2', '37', '1');
INSERT INTO `collection` VALUES ('3', '37', '1');
-- ----------------------------
-- Table structure for `info`
-- ----------------------------
DROP TABLE IF EXISTS `info`;
CREATE TABLE `info` (
`infoId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) DEFAULT NULL,
`infoTitle` varchar(255) DEFAULT NULL,
`infoComm` varchar(255) DEFAULT NULL,
`infoImgList` varchar(9999) DEFAULT NULL,
`infoReceive` varchar(255) DEFAULT NULL,
`infoAddress` varchar(255) DEFAULT NULL,
`infoDewo` varchar(255) DEFAULT NULL,
`infoSterilization` varchar(255) DEFAULT NULL,
`infoSpecies` varchar(255) DEFAULT NULL,
`infoVaccines` varchar(255) DEFAULT NULL,
`infoType` varchar(255) DEFAULT NULL,
`infoTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`infoId`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of info
-- ----------------------------
INSERT INTO `info` VALUES ('1', '33', '111', '11', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1605194030235-gu-feng03.jpg\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1605194030238-gu-feng05.jpg\"]', '来我家取', '北京市', '0', '1', '狗狗', '1', '0', '2020-11-14 15:56:53');
INSERT INTO `info` VALUES ('5', '37', '测试', '测试测试测试测试测试测试', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1605194030235-gu-feng03.jpg\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1605194030238-gu-feng05.jpg\"]', '来我家', '上海', '1', '1', '狗狗', '1', '0', '2020-11-15 21:43:42');
INSERT INTO `info` VALUES ('6', '37', 'hhhh', 'aasaaaaaaaaaaaaaaaaaaaaa', '[\"http://127.0.0.1:3000/public/img/admin/1605447970723-发布 (1) (1).png\",\"http://127.0.0.1:3000/public/img/admin/1605447970753-发布 (1).png\"]', '来我家', '上海', '2', '0', '狗狗', '1', '0', '2020-11-15 21:46:19');
INSERT INTO `info` VALUES ('11', '41', '12312', '123123', '[\"http://127.0.0.1:3000/public/img/admin/1605450325640-发布 (1) (1).png\",\"http://127.0.0.1:3000/public/img/admin/1605450325885-发布 (1).png\"]', null, '未知', null, null, null, null, '1', '2020-11-15 22:25:28');
INSERT INTO `info` VALUES ('10', '41', '2312', '3123', '[\"http://127.0.0.1:3000/public/img/admin/1605449891649-发布 (1) (1).png\",\"http://127.0.0.1:3000/public/img/admin/1605449891720-发布 (1).png\"]', '来我家', '未知', '1', '1', '狗狗', '1', '0', '2020-11-15 22:24:44');
INSERT INTO `info` VALUES ('12', '41', '3123', '123', '[\"http://127.0.0.1:3000/public/img/admin/1605450342226-QQ图片20191009222016.jpg\"]', null, '未知', null, null, null, null, '2', '2020-11-15 22:25:43');
INSERT INTO `info` VALUES ('13', '37', '测试', '傻逼', '[\"http://127.0.0.1:3000/public/img/admin/1605528737634-发布 (1) (1).png\",\"http://127.0.0.1:3000/public/img/admin/1605528737882-发布 (1).png\"]', null, '未知', null, null, null, null, '1', '2020-11-16 20:14:22');
INSERT INTO `info` VALUES ('14', '37', '213123', '12321', '[\"http://127.0.0.1:3000/public/img/admin/1605528872272-发布 (1) (1).png\",\"http://127.0.0.1:3000/public/img/admin/1605528872303-发布 (1).png\"]', '来我家', '未知', '1', '1', '狗狗', '1', '0', '2020-11-16 20:16:12');
INSERT INTO `info` VALUES ('15', '37', '23123', '12312', '[\"http://127.0.0.1:3000/public/img/admin/1605528998004-405.jpg\"]', '来我家', '未知', '1', '1', '狗狗', '1', '0', '2020-11-16 20:16:40');
INSERT INTO `info` VALUES ('16', '37', '你好', '213123', '[\"http://127.0.0.1:3000/public/img/admin/1605529261952-203.jpg\",\"http://127.0.0.1:3000/public/img/admin/1605529262182-304.jpg\"]', null, '未知', null, null, null, null, '1', '2020-11-16 20:21:06');
-- ----------------------------
-- Table structure for `infocomm`
-- ----------------------------
DROP TABLE IF EXISTS `infocomm`;
CREATE TABLE `infocomm` (
`infoCommId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`infoId` int(11) DEFAULT NULL,
`comm` varchar(255) DEFAULT NULL,
`time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`infoCommId`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of infocomm
-- ----------------------------
INSERT INTO `infocomm` VALUES ('1', '41', '2', '你好', '2020-11-15 20:05:39');
INSERT INTO `infocomm` VALUES ('2', '41', '2', '不好', '2020-11-15 20:05:40');
INSERT INTO `infocomm` VALUES ('3', '41', '2', 'hello', '2020-11-15 20:05:41');
INSERT INTO `infocomm` VALUES ('4', '41', '1', '嘿嘿', '2020-11-15 16:44:12');
INSERT INTO `infocomm` VALUES ('5', '41', '1', '掘金', '2020-11-15 16:47:20');
INSERT INTO `infocomm` VALUES ('6', '41', '1', 'xxx', '2020-11-15 16:48:26');
INSERT INTO `infocomm` VALUES ('7', '37', '1', '嘿嘿', '2020-11-15 18:49:36');
INSERT INTO `infocomm` VALUES ('8', '37', '1', '23123', '2020-11-15 18:55:49');
INSERT INTO `infocomm` VALUES ('9', '41', '5', '测试', '2020-11-15 21:43:51');
INSERT INTO `infocomm` VALUES ('10', '41', '5', '嘿嘿', '2020-11-15 21:43:58');
INSERT INTO `infocomm` VALUES ('11', '41', '12', '123123', '2020-11-15 22:25:58');
-- ----------------------------
-- Table structure for `knowcomm`
-- ----------------------------
DROP TABLE IF EXISTS `knowcomm`;
CREATE TABLE `knowcomm` (
`infoCommId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`rticleaId` int(11) DEFAULT NULL,
`comm` varchar(255) DEFAULT NULL,
`time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`infoCommId`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of knowcomm
-- ----------------------------
INSERT INTO `knowcomm` VALUES ('1', '41', '2', '你好', '2020-11-15 19:31:18');
INSERT INTO `knowcomm` VALUES ('2', '41', '2', '不好', '2020-11-15 19:31:18');
INSERT INTO `knowcomm` VALUES ('3', '41', '2', 'hello', '2020-11-15 19:31:18');
INSERT INTO `knowcomm` VALUES ('4', '41', '2', '嘿嘿', '2020-11-15 19:31:19');
INSERT INTO `knowcomm` VALUES ('5', '41', '2', '掘金', '2020-11-15 19:31:20');
INSERT INTO `knowcomm` VALUES ('6', '41', '2', 'xxx', '2020-11-15 19:31:20');
INSERT INTO `knowcomm` VALUES ('7', '37', '2', '嘿嘿', '2020-11-15 19:31:22');
INSERT INTO `knowcomm` VALUES ('8', '37', '1', '23123', '2020-11-15 18:55:49');
INSERT INTO `knowcomm` VALUES ('9', '41', '1', 'sss', '2020-11-15 19:34:46');
INSERT INTO `knowcomm` VALUES ('10', '41', '5', '111', '2020-11-15 22:24:57');
-- ----------------------------
-- Table structure for `praise`
-- ----------------------------
DROP TABLE IF EXISTS `praise`;
CREATE TABLE `praise` (
`praiseId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) NOT NULL,
`infoId` int(11) NOT NULL,
PRIMARY KEY (`praiseId`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of praise
-- ----------------------------
INSERT INTO `praise` VALUES ('34', '41', '1');
INSERT INTO `praise` VALUES ('35', '37', '6');
-- ----------------------------
-- Table structure for `rticlea`
-- ----------------------------
DROP TABLE IF EXISTS `rticlea`;
CREATE TABLE `rticlea` (
`rticleaId` int(11) NOT NULL AUTO_INCREMENT,
`adminId` int(11) DEFAULT NULL,
`rticleaTitle` varchar(255) DEFAULT NULL,
`rticleaComm` varchar(255) DEFAULT NULL,
`rticleaImgList` varchar(9999) DEFAULT NULL,
`rticleaTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`rticleaRead` int(11) DEFAULT '0',
PRIMARY KEY (`rticleaId`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of rticlea
-- ----------------------------
INSERT INTO `rticlea` VALUES ('1', '3', '111', '111111111', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1605194030235-gu-feng03.jpg\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1605194030238-gu-feng05.jpg\"]', '2020-02-10 21:10:23', '49');
INSERT INTO `rticlea` VALUES ('5', '3', '12312', '123123', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1605450095832-QQ图片20200410141935.png\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1605450095838-QQ图片20200410142003.png\"]', '2020-11-15 22:21:26', '0');
-- ----------------------------
-- Table structure for `sensitives`
-- ----------------------------
DROP TABLE IF EXISTS `sensitives`;
CREATE TABLE `sensitives` (
`sensitiveId` int(11) NOT NULL AUTO_INCREMENT,
`sensitiveTag` varchar(255) NOT NULL,
PRIMARY KEY (`sensitiveId`),
UNIQUE KEY `sensitive` (`sensitiveTag`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sensitives
-- ----------------------------
INSERT INTO `sensitives` VALUES ('16', '傻子');
INSERT INTO `sensitives` VALUES ('15', '傻逼');
-- ----------------------------
-- Table structure for `swiper`
-- ----------------------------
DROP TABLE IF EXISTS `swiper`;
CREATE TABLE `swiper` (
`swiperId` int(11) NOT NULL AUTO_INCREMENT,
`swiperurl` varchar(255) NOT NULL,
`swiperIndex` int(11) DEFAULT '0',
`swipertime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`swiperId`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of swiper
-- ----------------------------
INSERT INTO `swiper` VALUES ('25', 'http://127.0.0.1:3000/public/img/user/swiper/1605188625664-304.jpg', '24', '2020-11-14 14:07:08');
INSERT INTO `swiper` VALUES ('23', 'http://127.0.0.1:3000/public/img/user/swiper/1605188625625-102.jpg', '22', '2020-11-14 16:44:13');
INSERT INTO `swiper` VALUES ('22', 'http://127.0.0.1:3000/public/img/user/swiper/1605188625620-8bc8bb14-b2cd-4282-87cb-ba360dc0d8f0.jpg', '23', '2020-11-14 16:44:13');
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(255) DEFAULT NULL,
`userPhone` varchar(255) DEFAULT NULL,
`userPass` varchar(255) DEFAULT NULL,
`userUrl` varchar(255) DEFAULT NULL,
`userSex` varchar(255) DEFAULT NULL,
`userTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`userId`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('34', '李白', '13589656365', '123456', null, '0', '2020-11-15 00:28:58');
INSERT INTO `user` VALUES ('38', '人数', '16898987878', '123456', null, '女', '2020-11-15 00:32:41');
INSERT INTO `user` VALUES ('37', '杜甫', '13665659875', '123456', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '女', '2020-11-15 18:52:30');
INSERT INTO `user` VALUES ('4', '李白', null, null, 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', '2019-12-26 12:24:47');
INSERT INTO `user` VALUES ('5', '李白', null, null, 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', '2019-12-29 12:24:50');
INSERT INTO `user` VALUES ('6', '李白', null, null, 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', '2019-12-25 12:24:52');
INSERT INTO `user` VALUES ('39', '杜甫', '13540678171', '123456', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '女', '2020-11-15 18:50:58');
INSERT INTO `user` VALUES ('41', '韵达', '15378203267', '123456', 'http://127.0.0.1:3000/public/img/admin/1605373597765-1605373597749.jpeg', '女', '2020-11-15 01:06:39');
INSERT INTO `user` VALUES ('10', '李白', null, null, null, '男', '2019-12-31 12:25:00');
INSERT INTO `user` VALUES ('13', '李白', null, null, null, '男', '2019-12-25 12:25:03');
INSERT INTO `user` VALUES ('17', '李白', null, null, null, '男', '2019-12-17 12:25:26');
INSERT INTO `user` VALUES ('18', '李白', null, null, null, '男', '2019-12-04 12:25:09');
INSERT INTO `user` VALUES ('19', '李白', null, null, null, '男', '2019-12-22 12:25:12');
INSERT INTO `user` VALUES ('20', '李白', null, null, null, '男', '2019-12-17 12:25:15');
INSERT INTO `user` VALUES ('21', '李白', null, null, null, '男', '2019-12-12 12:25:18');
INSERT INTO `user` VALUES ('22', '李白', null, null, null, '男', '2019-12-29 12:25:20');
INSERT INTO `user` VALUES ('31', '。。', null, null, 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', '2020-11-12 21:49:28');
INSERT INTO `user` VALUES ('32', '1024', null, null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/arlSoIh2szwic8rsFjfQh7Vq3gffFo7yTOV79heY1fPeYAZsDFvM3wAC6ocLf5G2kRHCoWzAq2KfYcrPxbicW5vg/132', '未知', '2020-10-28 13:17:18');
INSERT INTO `user` VALUES ('33', '1024', null, null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/arlSoIh2szwic8rsFjfQh7Vq3gffFo7yTOV79heY1fPeYAZsDFvM3wAC6ocLf5G2kRHCoWzAq2KfYcrPxbicW5vg/132', '未知', '2020-10-28 13:17:59');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手