Java项目:宠物商城系统(java+Springboot+Maven+mybatis+Vue+mysql)

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50527 Source Host : localhost:3306 Source Database : pettrading Target Server Type : MYSQL Target Server Version : 50527 File Encoding : 65001 Date: 2021-09-09 21:46:11 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `address` -- ---------------------------- DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `aid` bigint(20) NOT NULL AUTO_INCREMENT, `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `uid` bigint(20) DEFAULT NULL, `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`aid`), KEY `FKt6huoueh6c1v1sjyi1n5qcn8o` (`uid`), KEY `FK5iqlpltdqtym3rd0wu1rv2qxj` (`address`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of address -- ---------------------------- INSERT INTO `address` VALUES ('1', '东莞理工学院', '11111111114', '16', '张三'); INSERT INTO `address` VALUES ('3', '东莞理工学院', '11111111111', '3', '张三'); INSERT INTO `address` VALUES ('4', '东莞理工学院', '11111111112', '4', '张三'); INSERT INTO `address` VALUES ('5', '东莞理工学院1', '11111111112', '4', '张三'); INSERT INTO `address` VALUES ('6', 'dgut', '11111111111', '3', '李四'); INSERT INTO `address` VALUES ('7', '等等', '15053170956', '17', '问问'); -- ---------------------------- -- Table structure for `bkind` -- ---------------------------- DROP TABLE IF EXISTS `bkind`; CREATE TABLE `bkind` ( `bkid` bigint(20) NOT NULL AUTO_INCREMENT, `bavatar` varchar(255) DEFAULT NULL, `bkindname` varchar(255) DEFAULT NULL, PRIMARY KEY (`bkid`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of bkind -- ---------------------------- INSERT INTO `bkind` VALUES ('1', null, '其他'); INSERT INTO `bkind` VALUES ('2', null, '狗'); INSERT INTO `bkind` VALUES ('3', null, '猫'); INSERT INTO `bkind` VALUES ('4', null, '鼠'); -- ---------------------------- -- Table structure for `contact` -- ---------------------------- DROP TABLE IF EXISTS `contact`; CREATE TABLE `contact` ( `cid` bigint(20) NOT NULL AUTO_INCREMENT, `fromuid` bigint(20) DEFAULT NULL, `touid` bigint(20) DEFAULT NULL, `noread` int(11) DEFAULT NULL, PRIMARY KEY (`cid`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of contact -- ---------------------------- INSERT INTO `contact` VALUES ('25', '17', '2', '0'); INSERT INTO `contact` VALUES ('26', '2', '17', '1'); -- ---------------------------- -- Table structure for `notice` -- ---------------------------- DROP TABLE IF EXISTS `notice`; CREATE TABLE `notice` ( `nid` bigint(20) NOT NULL AUTO_INCREMENT, `date` datetime DEFAULT NULL, `fromavatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `fromuid` bigint(20) DEFAULT NULL, `fromusername` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isread` int(11) DEFAULT NULL, `msg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `pid` bigint(20) DEFAULT NULL, `touid` bigint(20) DEFAULT NULL, `tousername` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `type` int(11) DEFAULT NULL, PRIMARY KEY (`nid`) ) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of notice -- ---------------------------- INSERT INTO `notice` VALUES ('81', '2021-09-09 21:33:45', 'defaultavatar/avatar1.jpeg', '17', null, '0', '我购买了你的宠物，点击前往查看', '5', '2', null, '1'); -- ---------------------------- -- Table structure for `pet` -- ---------------------------- DROP TABLE IF EXISTS `pet`; CREATE TABLE `pet` ( `pid` bigint(20) NOT NULL AUTO_INCREMENT, `petname` varchar(255) DEFAULT NULL, `sex` varchar(255) DEFAULT NULL, `uid` bigint(20) DEFAULT NULL, `age` int(11) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `bkid` bigint(20) DEFAULT NULL, `skid` bigint(20) DEFAULT NULL, `pk` int(11) DEFAULT NULL, `price` double DEFAULT NULL, `date` datetime DEFAULT NULL, PRIMARY KEY (`pid`), KEY `FKlo4y9rjiy8vi8nqwlfy2etqc2` (`bkid`), KEY `FKh8jp99159p7hg4a5qgl1n9jt8` (`skid`), KEY `FKmhyngo1n0y99d024j39medxii` (`uid`) ) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of pet -- ---------------------------- INSERT INTO `pet` VALUES ('5', '哈士奇', '男', '2', '5', '暂无', '2', '2', '1', '8000', '2020-03-12 07:07:23'); INSERT INTO `pet` VALUES ('4', '博美', '女', '2', '12', '暂无', '2', '5', '3', '1000', '2020-03-12 07:07:23'); INSERT INTO `pet` VALUES ('6', '狸花猫', '男', '3', '3', '暂无', '3', '16', '3', '2000', '2020-03-12 07:07:23'); INSERT INTO `pet` VALUES ('50', '兔子1', '男', '4', '1', '暂无', '1', '21', '0', '120', '2020-05-10 00:25:19'); INSERT INTO `pet` VALUES ('1', '金毛犬', '男', '1', '1', '暂无', '2', '3', '0', '8000', '2020-03-12 07:07:23'); INSERT INTO `pet` VALUES ('2', '贵宾犬', '女', '2', '2', '暂无', '2', '4', '0', '7000', '2020-03-12 07:07:23'); INSERT INTO `pet` VALUES ('3', '雪纳瑞', '男', '3', '1', '暂无', '2', '6', '1', '5000', '2020-03-12 07:07:23'); INSERT INTO `pet` VALUES ('13', '二哈', '女', '3', '1', '暂无', '2', '2', '3', '0', '2020-03-12 07:07:23'); INSERT INTO `pet` VALUES ('23', '二哈', '不限', '2', '-1', '暂无', '2', '2', '3', '-1', '2020-04-04 20:31:32'); INSERT INTO `pet` VALUES ('36', '布偶猫', '女', '4', '3', '诚意出售布偶猫\n价格好商量', '3', '14', '0', '8000', '2020-04-20 15:42:11'); INSERT INTO `pet` VALUES ('37', '仓鼠', '男', '4', '1', '暂无', '4', '17', '0', '500', '2020-04-20 16:34:30'); INSERT INTO `pet` VALUES ('38', '中国狸花猫', '男', '4', '2', '暂无', '3', '16', '0', '1000', '2020-04-20 16:39:02'); INSERT INTO `pet` VALUES ('39', '龙猫', '男', '4', '1', '低价出售', '4', '18', '0', '100', '2020-04-20 16:40:56'); INSERT INTO `pet` VALUES ('40', '柴犬', '男', '4', '12', '免费出售', '2', '23', '0', '0', '2020-04-20 16:47:14'); INSERT INTO `pet` VALUES ('41', '英国短毛猫', '男', '3', '2', '暂无', '3', '11', '0', '1000', '2020-04-20 23:51:07'); INSERT INTO `pet` VALUES ('46', '兔子', '不限', '1', '-1', '暂无', '1', '21', '3', '-1', '2020-05-09 12:44:34'); -- ---------------------------- -- Table structure for `petorder` -- ---------------------------- DROP TABLE IF EXISTS `petorder`; CREATE TABLE `petorder` ( `poid` bigint(20) NOT NULL AUTO_INCREMENT, `date` datetime DEFAULT NULL, `pid` bigint(20) DEFAULT NULL, `uid` bigint(20) DEFAULT NULL, `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `recipientname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `postatu` int(11) DEFAULT NULL, `puid` bigint(20) DEFAULT NULL, `price` double DEFAULT NULL, `newphone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `newaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `newrecipientname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`poid`), KEY `FKcvs0y4lmusnvlglnbkyr9d9ej` (`uid`), KEY `pid` (`pid`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of petorder -- ---------------------------- INSERT INTO `petorder` VALUES ('15', '2021-09-09 21:44:29', '5', '17', '等等', '15053170956', '问问', '4', '2', '8000', null, null, null); INSERT INTO `petorder` VALUES ('16', '2021-09-09 21:44:33', '3', '17', '等等', '15053170956'