dtd9EdkB

1CREATE TABLE IF NOT EXISTS `{TABLE_ACCOUNT}` (
2    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3    `playername` VARCHAR(255) NOT NULL,
4    `password` CHAR(255) NOT NULL,
5    `email` VARCHAR(100) NULL,
6    `registerdate` DATETIME NULL,
7    `registerip` CHAR(15) NULL,
8    `lastlogindate` DATETIME NULL,
9    `lastloginip` CHAR(15) NULL,
10    `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
11    PRIMARY KEY(`id`)
12);
13
14CREATE TABLE IF NOT EXISTS `{TABLE_SESSION}` (
15    `accountid` INT UNSIGNED NOT NULL,
16    `host` CHAR(15) NOT NULL,
17    `logintime` DATETIME NOT NULL,
18    PRIMARY KEY(`accountid`),
19    FOREIGN KEY (`accountid`) REFERENCES `{TABLE_ACCOUNT}`(`id`) ON DELETE CASCADE
20);
21
22CREATE TABLE IF NOT EXISTS `{TABLE_LOCATION}` (
23    `worldname` VARCHAR(255) NOT NULL,
24    `x` DOUBLE NOT NULL,
25    `y` DOUBLE NOT NULL,
26    `z` DOUBLE NOT NULL,
27    `yaw` FLOAT NOT NULL,
28    `pitch` FLOAT NOT NULL,
29    PRIMARY KEY(`worldname`)
30);
31
32CREATE TABLE IF NOT EXISTS `{TABLE_STRIKE}` (
33    `host` CHAR(15) NOT NULL,
34    `bantime` DATETIME NOT NULL,
35    PRIMARY KEY(`host`)
36);
37
38CREATE TABLE IF NOT EXISTS `{TABLE_INVENTORY}` (
39    `playername` VARCHAR(255) NOT NULL,
40    `itemid` TEXT NOT NULL,
41    `amount` TEXT NOT NULL,
42    `durability` TEXT NOT NULL,
43    PRIMARY KEY (`playername`)
44);