代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50737
Source Host : localhost:3306
Source Database : gtp
Target Server Type : MYSQL
Target Server Version : 50737
File Encoding : 65001
Date: 2022-05-24 22:50:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', '123456');
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cate_name` varchar(255) DEFAULT NULL,
`cate_icon` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', 'DNF', 'http://localhost:8080/upload/fccb2375c57b4293b39d0657d64ff331-dnf.jpg');
INSERT INTO `category` VALUES ('2', '原神', 'http://localhost:8080/upload/0b407f50afea4234932fd294868ff880-yuanshen.jpg');
INSERT INTO `category` VALUES ('3', 'LOL', 'http://localhost:8080/upload/57e87528bd254a25b2e3776b7f888e43-lol.jpg');
INSERT INTO `category` VALUES ('4', '穿越火线', 'http://localhost:8080/upload/9dbec12cec4f48ebac76be66acc601b5-cf.jpg');
INSERT INTO `category` VALUES ('5', 'CSGO', 'http://localhost:8080/upload/67382bc569194219bbd81c8ffbe40134-csgo.jpg');
INSERT INTO `category` VALUES ('6', 'PUBG', 'http://localhost:8080/upload/5fccf607ee0a46d29c29969e5d9a9343-pubg.jpg');
INSERT INTO `category` VALUES ('13', '崩坏3', 'http://localhost:8080/upload/0cd8e03228804a898e19d52ebbd80858-女王.jpg');
INSERT INTO `category` VALUES ('14', '火影忍者', 'http://localhost:8080/upload/6e65ff96e0584add8d10c3d26f002b16-火影忍者图标.jpg');
INSERT INTO `category` VALUES ('15', 'QQ飞车', 'http://localhost:8080/upload/fcaebe0cf1a94a34807d0835588cdd8a-QQ飞车.jpg');
-- ----------------------------
-- Table structure for commodity
-- ----------------------------
DROP TABLE IF EXISTS `commodity`;
CREATE TABLE `commodity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`icon` varchar(255) DEFAULT NULL,
`price` double(10,2) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`category_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`purchaser_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of commodity
-- ----------------------------
INSERT INTO `commodity` VALUES ('1', '第一期稀有装扮', 'http://localhost:8080/upload/3f336431d39044719b80287ba1b86f86-第一期稀有装扮.jpg', '999.00', '1', '1', '1', 'dnf第一期稀有装扮', '2');
INSERT INTO `commodity` VALUES ('2', '原神账号', 'http://localhost:8080/upload/70c3209a160a4802b69d484b4ea54236-专武神里.jpg', '999.00', '2', '2', '1', '原神账号 专武神里', '2');
INSERT INTO `commodity` VALUES ('3', 'DNF账号', 'http://localhost:8080/upload/18de36ff0d384049bbc86dd5dccfa6bd-00ca124db6724202ac43b8b2fa87ee18-QQ图片20220430104840.jpg', '3999.00', '1', '1', '1', '双至尊红颜', '2');
INSERT INTO `commodity` VALUES ('4', 'M4A1皮肤女火神之炽焰', 'http://localhost:8080/upload/cfb851d445c949078e14f5a99a04bcb4-1d04dbedac384a7bbfeb7e3511096bde-@IMO_ZT8$7IY9DSCZF__DZX.jpg', '1655.00', '2', '5', '2', 'M4A1皮肤女火神之炽焰', '17');
INSERT INTO `commodity` VALUES ('5', 'M4A1二号玩家', 'http://localhost:8080/upload/d97db1fdb33a4daa9cafd30fe328b0c1-2fa3daf4bc064a329b0db139f491bc68-Iit8MbDTOYb551550f5f01ecf9d37a9d89a7480b205d.jpg', '1566.00', '2', '5', '3', 'M4A1皮肤二号玩家', '2');
INSERT INTO `commodity` VALUES ('6', '蝴蝶刀', 'http://localhost:8080/upload/468248a3ee944becaaa7d235b1b98ea9-8dbb3f024781462fb863e0d06f7015616.jpg', '4399.00', '1', '5', '1', '蝴蝶刀', '2');
INSERT INTO `commodity` VALUES ('7', '折刀', 'http://localhost:8080/upload/996701e4eabb4447a23c49db9d002a73-1d1266ab068b40dabfab89cb78646587-1861as6d1af.jpg', '2999.00', '1', '5', '2', '淬火折刀', '3');
INSERT INTO `commodity` VALUES ('8', '迎新春武器大礼包', 'http://localhost:8080/upload/407cc3f1e9544cb09c612b52f1186639-35dce8981d664a339d509f2228183133-736600eafa994ea49716c7d6a4c0be92.jpg', '87.00', '1', '6', '1', '迎新春武器大礼包', '2');
INSERT INTO `commodity` VALUES ('9', '奶妈三级buff称号', 'http://localhost:8080/upload/88a7e190c3fd4ce891e2c82a1181c23e-6be01e400b3f4717bb8e6d82f72d01ba-QQ图片20220430113012.jpg', '120.00', '1', '1', '1', '奶妈三级buff称号', '4');
INSERT INTO `commodity` VALUES ('10', '矛盾的结晶', 'http://localhost:8080/upload/817804f0cc41477eacf86f73be907130-00ca124db6724202ac43b8b2fa87ee18-QQ图片20220430104840.jpg', '1000.00', '1', '1', '2', '1块7个 一共7200块', '2');
INSERT INTO `commodity` VALUES ('11', '原神账号', 'http://localhost:8080/upload/4c3aad63b9fb4498821f6dc5ee506ca6-ua9RLO2geWpK4b268ededea7b8c22569ee9b4c2314cd.jpg', '688.00', '0', '2', '4', '元神账号', null);
INSERT INTO `commodity` VALUES ('12', '神里账号', 'http://localhost:8080/upload/8d08ba3957fe49bb84c2726886c7cb59-专武神里.jpg', '2000.00', '2', '2', '4', '123', '2');
INSERT INTO `commodity` VALUES ('20', '若梦奇谭稀有装扮', 'http://localhost:8080/upload/0e9bb724378a4a628c172ebbe28a8e9a-QQ图片20220509093132.jpg', '350.00', '1', '1', '1', '劳动节礼包至尊装扮', '2');
INSERT INTO `commodity` VALUES ('21', '精灵咏叹调宝物神秘礼盒', 'http://localhost:8080/upload/7d41d8c51786400b8f602efe10bffe54-QQ图片20220509094238.jpg', '500.00', '0', '1', '1', '100块3个 总共 15个', null);
INSERT INTO `commodity` VALUES ('22', '五一宠物', 'http://localhost:8080/upload/5ebaa5b1abf44849ad10bb770478279c-QQ图片20220509094413.jpg', '55.00', '2', '1', '1', '123', '2');
INSERT INTO `commodity` VALUES ('23', '五一至尊精灵', 'http://localhost:8080/upload/0acab504904e450095e6ef17c1627927-QQ图片20220509094433.jpg', '123.00', '1', '1', '1', '124', '2');
INSERT INTO `commodity` VALUES ('24', '金币', 'http://localhost:8080/upload/7572aca74b3e4d93a3167f81c67a08f1-QQ图片20220509094532.jpg', '280.00', '1', '1', '1', '比例1：60', '25');
INSERT INTO `commodity` VALUES ('27', '原神账号', 'http://localhost:8080/upload/45e94921e799442c9ec4b1099e71292e-qFscHvhG39Zv73c848b47e50d13b424a202d8b487cc3.jpg', '1111.00', '0', '2', '2', '原神专武 薙刀之稻光', null);
INSERT INTO `commodity` VALUES ('29', 'AK 野荷', 'http://localhost:8080/upload/ce511aab95b34050848110fd1826ece5-QQ图片20220524195530.jpg', '6666.00', '1', '5', '25', 'AK野荷皮肤 磨损0.01', '2');
INSERT INTO `commodity` VALUES ('31', '喧嚣杀戮', 'http://localhost:8080/upload/f5e390c50c1f42f1827311d8110ad447-QQ图片20220524195528.jpg', '2500.00', '0', '5', '25', '喧嚣杀戮', null);
INSERT INTO `commodity` VALUES ('32', 'USP脑洞大开', 'http://localhost:8080/upload/76234108da564900811c50e77cbcc22d-QQ图片20220524195526.jpg', '25.00', '0', '5', '25', '脑洞大开', null);
INSERT INTO `commodity` VALUES ('33', 'USP枪响人亡', 'http://localhost:8080/upload/2c2d369f2c084e34b54c51c811a8e21f-QQ图片20220524195524.jpg', '200.00', '0', '5', '25', '枪响人亡', null);
INSERT INTO `commodity` VALUES ('34', 'M4A4 Tooth Fairy', 'http://localhost:8080/upload/8db0f156aa3e46a4bd451ec16b9dab52-QQ图片20220524195522.jpg', '1666.00', '0', '5', '25', 'M4A4 Tooth Fairy', null);
INSERT INTO `commodity` VALUES ('35', 'AK皮肤', 'http://localhost:8080/upload/4b370c4eafac41ff8c74d0539fe9e77d-QQ图片20220524195519.jpg', '6666.00', '0', '5', '25', 'AK皮肤', null);
INSERT INTO `commodity` VALUES ('36', 'AWP永恒之枪', 'http://localhost:8080/upload/21149707da9642a297b7dc79d4823db1-QQ图片20220524195515.jpg', '5000.00', '0', '5', '25', 'AWP永恒之枪', null);
INSERT INTO `commodity` VALUES ('37', 'AWP血腥运动', 'http://localhost:8080/upload/feeea12cbb4c43feb95f24f68a24dd2c-QQ图片20220524195459.jpg', '1333.00', '0', '5', '25', 'AWP血腥运动', null);
INSERT INTO `commodity` VALUES ('38', 'AWP猫猫狗狗', 'http://localhost:8080/upload/d1455f2a38434886899d7db207d2918a-QQ图片20220524200358.jpg', '26.00', '2', '5', '2', 'AWP猫猫狗狗', '25');
INSERT INTO `commodity` VALUES ('39', '圣域炽天使', 'http://localhost:8080/upload/25313ce437234cb1878d30508c982e05-QQ图片20220524200637.jpg', '20000.00', '0', '15', '2', '2021年度T3首发', null);
INSERT INTO `commodity` VALUES ('40', '终极幻影', 'http://localhost:8080/upload/53a7eef8745742898e9f026bf90f7f30-QQ图片20220524200751.jpg', '20000.00', '0', '15', '2', '终极幻影', null);
INSERT INTO `commodity` VALUES ('41', '神谕天尊', 'http://localhost:8080/upload/06db63aa42bc435b8b14ba167dc5a30e-QQ图片20220524200810.jpg', '25000.00', '0', '15', '2', '神谕天尊', null);
INSERT INTO `commodity` VALUES ('42', '创世之神', 'http://localhost:8080/upload/783c5520861d46a0b77e996246fd3dd9-QQ图片20220524200838.jpg', '15000.00', '0', '15', '2', '创世之神', null);
INSERT INTO `commodity` VALUES ('43', '魔尊', 'http://localhost:8080/upload/6ea10c1a6e5b4231b9e977d1f8a1b698-QQ图片20220524200933.jpg', '19999.00', '0', '15', '2', '魔尊', null);
INSERT INTO `commodity` VALUES ('44', '幻神和各种皮肤音效四防角色', 'http://localhost:8080/upload/d474272f30e848518dbba9734769c616-QQ图片20220524201639.jpg', '1200.00', '0', '4', '2', '幻神和各种皮肤音效四防角色', null);
INSERT INTO `commodity` VALUES ('45', '幻神圣灵光耀雷霆王者', 'http://localhost:8080/upload/d0640bcca2c24455946a6926431df0c9-QQ图片20220524201755.jpg', '5688.00', '0', '4', '2', '幻神圣灵光耀雷霆王者', null);
INSERT INTO `commodity` VALUES ('46', '14阶单人125思南25玉满怪', 'http://localhost:8080/upload/487684ea52a64cf98f5ae57366cbbf5e-QQ图片20220524201853.jpg', '95.00', '0', '1', '2', '14阶单人125思南25玉满怪', null);
-- ----------------------------
-- Table structure for post
-- ----------------------------
DROP TABLE IF EXISTS `post`;
CREATE TABLE `post` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(255) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of post
-- ----------------------------
INSERT INTO `post` VALUES ('1', '求红十二死灵账号', '1', '0');
INSERT INTO `post` VALUES ('4', '求巨龙传说', '2', '1');
INSERT INTO `post` VALUES ('5', '求迈阿密手套', '2', '0');
INSERT INTO `post` VALUES ('6', '求崭新二西莫夫', '2', '0');
INSERT INTO `post` VALUES ('7', '求渐变大理石', '2', '1');
INSERT INTO `post` VALUES ('8', '求原神6命雷神账号', '2', '0');
INSERT INTO `post` VALUES ('9', '求12.0技工辟邪玉', '2', '0');
INSERT INTO `post` VALUES ('10', '求红十二剑帝账号', '3', '1');
INSERT INTO `post` VALUES ('11', '求6烈龙代购', '3', '0');
INSERT INTO `post` VALUES ('12', '求cf账号', '3', '0');
INSERT INTO `post` VALUES ('13', '求500+皮肤LOL账号', '3', '0');
INSERT INTO `post` VALUES ('14', '求多枪皮肤PUBG账号', '3', '0');
INSERT INTO `post` VALUES ('15', '求20固定三攻奶辟邪玉', '1', '0');
INSERT INTO `post` VALUES ('16', '求DNF跨二 2e金币', '2', '0');
INSERT INTO `post` VALUES ('17', '收50把增幅+13胚子', '4', '0');
INSERT INTO `post` VALUES ('18', '收20e金币', '4', '0');
INSERT INTO `post` VALUES ('19', '收DNF跨二金币', '2', '0');
INSERT INTO `post` VALUES ('20', '求LOL初始号', '2', '0');
INSERT INTO `post` VALUES ('21', 'QQ飞车网通区需要一辆S级赛车', '25', '0');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`birthday` varchar(255) DEFAULT NULL,
`gender` int(11) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', '123456', '2000-11-22', '1', '18603773890');
INSERT INTO `user` VALUES ('2', '123456', '123456', '1996-05-18', '0', '15515635810');
INSERT INTO `user` VALUES ('3', 'zhangsan', '123456', '2000-11-22', '0', '15515635810');
INSERT INTO `user` VALUES ('4', 'xbz', '123456', '2000-11-22', '1', '15515635810');
INSERT INTO `user` VALUES ('17', 'aaa', '123456', '2000-11-22', '1', '15515635810');
INSERT INTO `user` VALUES ('18', 'bbb', '123', '2000-11-22', '1', '15515635810');
INSERT INTO `user` VALUES ('19', 'ccc', '123456', '2000-11-15', '1', '15515635810');
INSERT INTO `user` VALUES ('20', '159', '123456', '2000-05-11', '1', '15515635810');
INSERT INTO `user` VALUES ('21', 'abc', '123', '1999-12-24', '1', '18603773890');
INSERT INTO `user` VALUES ('25', 'xiaojuzi', '123456', '2000-12-07', '0', '18603773890');
INSERT INTO `user` VALUES ('28', 'xiaochengzi', '123456', '1999-02-04', '0', '15515635810');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手