· 9 years ago · Oct 15, 2016, 08:40 PM
1function GM.SQL:InitGamemodeTables()
2 self:LogMsg( "Initializing gamemode tables..." )
3
4 self:PooledQueryWrite( 1, [[CREATE TABLE IF NOT EXISTS `players` (
5 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
6 `steamid` VARCHAR(255) NOT NULL,
7 PRIMARY KEY (`id`),
8 INDEX `steamid` (`steamid`)
9 ) ENGINE=InnoDB;]] )
10
11 self:PooledQueryWrite( 2, [[CREATE TABLE IF NOT EXISTS `characters` (
12 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
13 `player_id` INT(10) UNSIGNED NOT NULL,
14 `first_name` VARCHAR(255) NOT NULL DEFAULT 'Minge',
15 `last_name` VARCHAR(255) NOT NULL DEFAULT 'Bag',
16 `sex` ENUM('male','female') NULL DEFAULT NULL,
17 `model` VARCHAR(255) NOT NULL,
18 `model_override` VARCHAR(255) NULL DEFAULT NULL,
19 `skin` SMALLINT NOT NULL DEFAULT 0,
20 `money_held` INT(10) UNSIGNED NOT NULL DEFAULT '0',
21 `money_bank` INT(10) UNSIGNED NOT NULL DEFAULT '0',
22 `vehicles` LONGTEXT NULL,
23 `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
24 PRIMARY KEY (`id`),
25 INDEX `player_id` (`player_id`),
26 INDEX `first_name_last_name` (`first_name`, `last_name`)
27 ) ENGINE=InnoDB;]] )
28
29 self:PooledQueryWrite( 3, [[CREATE TABLE IF NOT EXISTS `character_inventory` (
30 `character_id` INT(10) UNSIGNED NOT NULL,
31 `item_name` VARCHAR(255) NOT NULL,
32 `item_count` INT(10) UNSIGNED NOT NULL,
33 UNIQUE INDEX `character_id_item_name` (`character_id`, `item_name`),
34 INDEX `character_id` (`character_id`)
35 ) ENGINE=InnoDB;]] )
36
37 self:PooledQueryWrite( 4, [[CREATE TABLE IF NOT EXISTS `character_equipped` (
38 `character_id` INT(10) UNSIGNED NOT NULL,
39 `slot_name` VARCHAR(255) NOT NULL,
40 `item_name` VARCHAR(255) NOT NULL,
41 UNIQUE INDEX `character_id_slot_name` (`character_id`, `slot_name`),
42 INDEX `character_id` (`character_id`)
43 ) ENGINE=InnoDB;]] )
44
45 self:PooledQueryWrite( 5, [[CREATE TABLE IF NOT EXISTS `character_data_store` (
46 `character_id` INT(10) UNSIGNED NOT NULL,
47 `key` VARCHAR(255) NOT NULL,
48 `value` LONGTEXT NULL,
49 UNIQUE INDEX `character_id_key` (`character_id`, `key`),
50 INDEX `character_id` (`character_id`),
51 INDEX `key` (`key`)
52 ) ENGINE=InnoDB;]] )
53end