· 8 years ago · Jan 23, 2018, 11:48 PM
1
2--
3-- Database: `test`
4--
5
6-- --------------------------------------------------------
7
8--
9-- Table structure for table `block_logs`
10--
11
12CREATE TABLE IF NOT EXISTS `block_logs` (
13 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
14 `date` int(10) unsigned DEFAULT NULL,
15 `world_id` int(10) unsigned DEFAULT NULL,
16 `player_id` int(10) unsigned DEFAULT NULL,
17 `type` tinyint(3) unsigned DEFAULT NULL,
18 `x` int(11) DEFAULT NULL,
19 `y` smallint(6) DEFAULT NULL,
20 `z` int(11) DEFAULT NULL,
21 `block_id` smallint(6) DEFAULT NULL,
22 `block_data` tinyint(4) DEFAULT NULL,
23 PRIMARY KEY (`id`),
24 KEY `xyz` (`world_id`,`x`,`y`,`z`),
25 KEY `player_id` (`player_id`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
27
28-- --------------------------------------------------------
29
30--
31-- Table structure for table `chests`
32--
33
34CREATE TABLE IF NOT EXISTS `chests` (
35 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
36 `date` int(10) unsigned DEFAULT NULL,
37 `world_id` int(10) unsigned NOT NULL DEFAULT '0',
38 `player_id` int(10) unsigned DEFAULT NULL,
39 `x` int(11) NOT NULL DEFAULT '0',
40 `y` smallint(6) NOT NULL DEFAULT '0',
41 `z` int(11) NOT NULL DEFAULT '0',
42 `last_player_id` int(10) unsigned DEFAULT NULL,
43 PRIMARY KEY (`world_id`,`x`,`y`,`z`),
44 KEY `player_id` (`player_id`),
45 KEY `id` (`id`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `chest_access_logs`
52--
53
54CREATE TABLE IF NOT EXISTS `chest_access_logs` (
55 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
56 `date` int(10) unsigned DEFAULT NULL,
57 `player_id` int(10) unsigned DEFAULT NULL,
58 `chest_id` int(10) unsigned DEFAULT NULL,
59 PRIMARY KEY (`id`),
60 KEY `chest_id` (`chest_id`),
61 KEY `player_id` (`player_id`)
62) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
63
64-- --------------------------------------------------------
65
66--
67-- Table structure for table `chest_contents`
68--
69
70CREATE TABLE IF NOT EXISTS `chest_contents` (
71 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
72 `chest_id` int(10) unsigned DEFAULT NULL,
73 `slot_id` tinyint(3) unsigned DEFAULT NULL,
74 `item_id` smallint(5) unsigned DEFAULT NULL,
75 `item_durability` tinyint(3) unsigned DEFAULT NULL,
76 `item_count` tinyint(3) unsigned DEFAULT NULL,
77 PRIMARY KEY (`id`),
78 KEY `chest_id` (`chest_id`)
79) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `login_logs`
85--
86
87CREATE TABLE IF NOT EXISTS `login_logs` (
88 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
89 `date` int(10) unsigned DEFAULT NULL,
90 `world_id` int(10) unsigned DEFAULT NULL,
91 `player_id` int(10) unsigned DEFAULT NULL,
92 `ip` int(10) unsigned DEFAULT NULL,
93 `type` tinyint(3) unsigned DEFAULT NULL,
94 PRIMARY KEY (`id`),
95 KEY `player_id` (`player_id`)
96) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
97
98-- --------------------------------------------------------
99
100--
101-- Table structure for table `players`
102--
103
104CREATE TABLE IF NOT EXISTS `players` (
105 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
106 `date` int(10) unsigned DEFAULT NULL,
107 `name` varchar(32) NOT NULL DEFAULT '',
108 `last_ip` int(10) unsigned DEFAULT NULL,
109 `last_login` int(10) unsigned DEFAULT NULL,
110 PRIMARY KEY (`name`),
111 KEY `id` (`id`)
112) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
113
114-- --------------------------------------------------------
115
116--
117-- Table structure for table `worlds`
118--
119
120CREATE TABLE IF NOT EXISTS `worlds` (
121 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
122 `date` int(10) unsigned DEFAULT NULL,
123 `name` varchar(32) NOT NULL DEFAULT '',
124 PRIMARY KEY (`name`),
125 KEY `id` (`id`)
126) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;