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