JLQPiFqz

1-- Adminer 4.7.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `mc_log`;
9CREATE TABLE `mc_log` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `username` varchar(32) DEFAULT NULL,
12  `operation` varchar(32) DEFAULT NULL,
13  `date` timestamp NULL DEFAULT current_timestamp(),
14  `server` varchar(32) DEFAULT NULL,
15  `found_stacks` mediumtext DEFAULT NULL,
16  `found_money` bigint(20) DEFAULT NULL,
17  `lost_stacks` mediumtext DEFAULT NULL,
18  `lost_money` bigint(20) DEFAULT NULL,
19  `coords` varchar(32) DEFAULT NULL,
20  `additional` mediumtext DEFAULT NULL,
21  `currency` varchar(32) DEFAULT NULL,
22  PRIMARY KEY (`id`),
23  KEY `username` (`username`),
24  KEY `operation` (`operation`),
25  KEY `date` (`date`),
26  KEY `server` (`server`),
27  KEY `currency` (`currency`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29
30
31DROP TABLE IF EXISTS `mc_prices`;
32CREATE TABLE `mc_prices` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `item_id` int(11) NOT NULL,
35  `stack_size` int(11) NOT NULL,
36  `nbt_json` text NOT NULL,
37  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
38  `price` bigint(20) NOT NULL,
39  `seller` varchar(32) NOT NULL,
40  `buyer` varchar(32) NOT NULL,
41  `method` enum('auction','trade') NOT NULL,
42  PRIMARY KEY (`id`),
43  KEY `date` (`date`),
44  KEY `item_id` (`item_id`),
45  KEY `method` (`method`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8;
47
48
49DROP TABLE IF EXISTS `tradepacks`;
50CREATE TABLE `tradepacks` (
51  `id` int(11) NOT NULL AUTO_INCREMENT,
52  `sold_at` datetime DEFAULT NULL,
53  `seller` varchar(64) DEFAULT NULL,
54  `sold_location` varchar(128) DEFAULT NULL,
55  `npc_coords` varchar(32) DEFAULT NULL,
56  `delivery_duration` bigint(20) DEFAULT NULL,
57  `sold_price` bigint(20) DEFAULT NULL,
58  `tradepack_owner` varchar(64) DEFAULT NULL,
59  `created_at` datetime DEFAULT NULL,
60  `created_location` varchar(128) DEFAULT NULL,
61  `created_coords` varchar(32) DEFAULT NULL,
62  `item_id` int(11) DEFAULT NULL,
63  `base_price` int(11) DEFAULT NULL,
64  PRIMARY KEY (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=utf8;
66
67
68-- 2019-10-08 16:32:31