master

分支 (1)

管理

管理

master

game-account-trading-platform-demo
/
gats.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50743 (5.7.43-log)
 Source Host           : localhost:3306
 Source Schema         : gats

 Target Server Type    : MySQL
 Target Server Version : 50743 (5.7.43-log)
 File Encoding         : 65001

 Date: 11/10/2023 13:46:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order`  (
  `id` int(11) NOT NULL COMMENT '订单id',
  `buyer_id` int(11) NULL DEFAULT NULL COMMENT '买方id',
  `seller_id` int(11) NULL DEFAULT NULL COMMENT '卖方id',
  `create_time` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '订单创建时间',
  `sellacc_id` int(11) NULL DEFAULT NULL COMMENT '出售的账号相关信息id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order
-- ----------------------------

-- ----------------------------
-- Table structure for sellacc
-- ----------------------------
DROP TABLE IF EXISTS `sellacc`;
CREATE TABLE `sellacc`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '账号信息id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键词',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
  `price` int(11) NULL DEFAULT NULL COMMENT '价格',
  `is_sell` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未出售' COMMENT '是否售出',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '发布者id',
  `buyuser_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '购买者',
  `receipt_time` datetime NULL DEFAULT NULL COMMENT '收货时间',
  `qq_number` bigint(20) NULL DEFAULT NULL COMMENT 'qq账号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sellacc
-- ----------------------------
INSERT INTO `sellacc` VALUES (1, 'CSGO皮肤', 'CSGO', '<p>Test</p>', 100, '待发货', '2023-09-17 13:33:32', 3, 5, NULL, NULL);
INSERT INTO `sellacc` VALUES (2, '原神 自抽号388个纠缠之缘', '原神', '<p>原神 自抽号<strong>388</strong>个纠缠之缘 便宜出售</p>', 99, '已出售', '2023-09-17 13:40:25', 3, 5, '2023-09-22 21:04:39', NULL);
INSERT INTO `sellacc` VALUES (3, '原神-5神全收集加专武', '原神', '<p>原神-<span style=\"color: rgb(235, 144, 58);\">5神</span>全收集加<span style=\"color: rgb(235, 144, 58);\">专武</span></p>', 90, '已出售', '2023-09-17 13:42:50', 5, 3, '2023-09-18 21:05:23', NULL);
INSERT INTO `sellacc` VALUES (4, '1111', '绝地求生', '<p>1111</p>', 1111, '未出售', '2023-09-17 20:34:15', 3, NULL, NULL, NULL);
INSERT INTO `sellacc` VALUES (5, 'test1', '王者荣耀', '<p>test1</p>', 112, '未出售', '2023-09-18 12:28:54', 3, NULL, NULL, NULL);
INSERT INTO `sellacc` VALUES (6, 'Test11', 'COD', '<h1><strong>as</strong><span style=\"background-color: rgb(66, 144, 247);\"><strong>dasddasd</strong></span><strong>d</strong><em><strong>dd</strong></em></h1><p>sasdasd</p><p><span style=\"color: rgb(235, 144, 58);\">asdadsada</span></p>', 111, '未出售', '2023-09-21 11:38:34', 5, NULL, NULL, NULL);
INSERT INTO `sellacc` VALUES (7, 'APEX英雄 全传家宝收集 s9-s14赛季通讯证皮肤', 'APEX英雄', '<p>如题</p>', 2000, '待发货', '2023-10-07 16:05:18', 3, 5, '2023-10-08 21:13:52', 514530275);
INSERT INTO `sellacc` VALUES (8, '原神双若水 便宜出售', '原神', '<p><img src=\"http://localhost:9090/files/getfile/1358cf2f13294d169e9a78a1c0326b69\" alt=\"\" data-href=\"\" style=\"width: 500.00px;height: 344.14px;\"/></p><p><br></p><p><br></p>', 65, '已出售', '2023-10-07 22:17:27', 3, 7, '2023-10-08 20:45:54', 514530275);
INSERT INTO `sellacc` VALUES (9, '测试联系他功能', '坦克世界', '<p>测试联系他功能</p>', 111, '已出售', '2023-10-08 11:53:29', 5, 3, '2023-10-08 21:40:04', 2445408174);
INSERT INTO `sellacc` VALUES (10, '测试发布功能', '我的世界', '<p><img src=\"http://localhost:9090/files/getfile/ce86022e31424c8598ad88a2e70d3f11\" alt=\"\" data-href=\"\" style=\"\"/></p><p>1121212123123</p>', 123, '未出售', '2023-10-08 20:31:49', 3, NULL, NULL, 64125645);
INSERT INTO `sellacc` VALUES (11, '测试发布功能111', '原神', '<p><img src=\"http://localhost:9090/files/getfile/c92b92ae3847435c8d6872c771d4a65d\" alt=\"\" data-href=\"\" style=\"width: 576.00px;height: 319.72px;\"/></p><h2>啊是大多数<em>对的</em></h2><p><br></p>', 222, '未出售', '2023-10-08 21:41:49', 5, NULL, NULL, 646125645);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮箱',
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '用户身份',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'http://localhost:9090/files/getfile/default' COMMENT '头像',
  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (3, 'user', 'user', '64612564@qq.com', '测试用户', '男', '2023-09-16 14:34:18', '普通用户', 'http://localhost:9090/files/getfile/4e63568291c94558a06f6a2c9b6d2d10', 88);
INSERT INTO `user` VALUES (4, 'admin', 'admin', 'admin@qq.com', 'admin', '男', '2023-09-16 14:35:13', '管理员', 'http://localhost:9090/files/getfile/1ecb3ff948c94dd7830c9f88384b5329', 20);
INSERT INTO `user` VALUES (5, 'user1', 'user1', 'user1@qq.com', '测试用户2', '男', '2023-09-18 16:56:33', '普通用户', 'http://localhost:9090/files/getfile/aa58f453c0a842629283f40a9f6ecaaf', 25);
INSERT INTO `user` VALUES (6, 'user2', 'user2', 'user2@qq.com', '测试用户3', '男', '2023-09-18 17:46:26', '普通用户', 'http://localhost:9090/files/getfile/default', 22);

SET FOREIGN_KEY_CHECKS = 1;