7CEaNzVi

1CREATE TABLE IF NOT EXISTS players_permissions(
2    i BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3    username VARCHAR(16) NOT NULL,
4    permission VARCHAR(255) NOT NULL,
5
6    -- Indexes
7    UNIQUE (username, permission),
8    INDEX (username)
9)
10
11CREATE TABLE IF NOT EXISTS players (
12    username VARCHAR(16) NOT NULL PRIMARY KEY,
13    groupID VARCHAR(16) NULL DEFAULT NULL,
14    prefix VARCHAR(255) NULL DEFAULT NULL,
15    suffix VARCHAR(255) NULL DEFAULT NULL,
16
17    -- Indexes
18    INDEX (groupID)
19)
20
21
22SELECT username, groupID, prefix, suffix, username FROM players
23SELECT username, permission FROM players_permissions ORDER BY i ASC
24
25DELETE FROM players WHERE username = ? LIMIT 1
26INSERT INTO players(username, groupID) VALUES(?, ?) ON DUPLICATE KEY UPDATE groupID = ?
27INSERT INTO players(username, prefix) VALUES(?, ?) ON DUPLICATE KEY UPDATE prefix = ?
28INSERT INTO players(username, suffix) VALUES(?, ?) ON DUPLICATE KEY UPDATE suffix = ?