player-prefs

1
CREATE TABLE IF NOT EXISTS `pp_players` (
2
  `id` int(11) NOT NULL AUTO_INCREMENT,
3
  `authid` varchar(36) NOT NULL,
4
  PRIMARY KEY (`id`),
5
  UNIQUE KEY (`authid`)
6
) CHARACTER SET utf8 COLLATE utf8_general_ci;
7

8
CREATE TABLE IF NOT EXISTS `pp_keys` (
9
  `id` int(11) NOT NULL AUTO_INCREMENT,
10
  `key` varchar(64) NOT NULL,
11
  `default_value` varchar(255) NOT NULL,
12
  PRIMARY KEY (`id`),
13
  UNIQUE KEY (`key`)
14
) CHARACTER SET utf8 COLLATE utf8_general_ci;
15

16
CREATE TABLE IF NOT EXISTS `pp_preferences` (
17
  `player_id` int(11) NOT NULL,
18
  `key_id` int(11) NOT NULL,
19
  `value` varchar(255) NOT NULL,
20
  PRIMARY KEY (`player_id`, `key_id`),
21

22
  FOREIGN KEY (`player_id`)
23
    REFERENCES `pp_players`(`id`)
24
    ON UPDATE CASCADE ON DELETE CASCADE,
25

26
  FOREIGN KEY (`key_id`)
27
    REFERENCES `pp_keys`(`id`)
28
    ON UPDATE CASCADE ON DELETE CASCADE
29
) CHARACTER SET utf8 COLLATE utf8_general_ci;
30