SsSkJX5C

1CREATE TABLE IF NOT EXISTS aftermath.Game_Users( 
2			 id BIGINT(20) NOT NULL, 
3			 userId BIGINT(20) NOT NULL, 
4			 PRIMARY KEY(id)) 
5			 ENGINE = INNODB, 
6			 CHARACTER SET utf8mb4, 
7			 COLLATE utf8mb4_general_ci; 
8
9		 ALTER TABLE aftermath.Game_Users 
10			 ADD CONSTRAINT FK_game_users_userId FOREIGN KEY IF NOT EXISTS(userId) 
11			 REFERENCES aftermath.Users(id); 
12
13			 CREATE TABLE IF NOT EXISTS aftermath.Game_Characters( 
14				 id BIGINT(20) NOT NULL AUTO_INCREMENT, 
15				 characterName VARCHAR(255) NOT NULL, 
16				 userId BIGINT(20) DEFAULT NULL, 
17				 deleted TINYINT(1) DEFAULT 0, 
18				 createdAt TIMESTAMP NULL DEFAULT NULL, 
19				 updatedAt TIMESTAMP NULL DEFAULT NULL, 
20				 PRIMARY KEY(id)) 
21			 ENGINE = INNODB, 
22			 CHARACTER SET utf8mb4, 
23			 COLLATE utf8mb4_general_ci; 
24
25		 ALTER TABLE aftermath.Game_Characters 
26			 ADD CONSTRAINT FK_game_characters_userId FOREIGN KEY IF NOT EXISTS(userId) 
27			 REFERENCES aftermath.Game_Users(id) ON DELETE SET NULL; 
28
29			 CREATE TABLE IF NOT EXISTS aftermath.Game_Ships( 
30				 id BIGINT(20) NOT NULL AUTO_INCREMENT, 
31				 base INT(11) UNSIGNED DEFAULT NULL, 
32				 shipHash INT(11) UNSIGNED DEFAULT NULL, 
33				 flString VARCHAR(255) DEFAULT NULL, 
34				 PRIMARY KEY(id)) 
35			 ENGINE = INNODB, 
36			 CHARACTER SET utf8mb4, 
37			 COLLATE utf8mb4_general_ci; 
38
39		 CREATE TABLE IF NOT EXISTS aftermath.Game_Ship_Equipments( 
40			 id BIGINT(20) NOT NULL AUTO_INCREMENT, 
41			 dunno SMALLINT(6) UNSIGNED DEFAULT NULL, 
42			 hardpointId SMALLINT(6) UNSIGNED DEFAULT NULL, 
43			 archId INT(11) UNSIGNED DEFAULT NULL, 
44			 cacheString VARCHAR(255) DEFAULT NULL, 
45			 mounted TINYINT(1) DEFAULT NULL, 
46			 health FLOAT DEFAULT NULL, 
47			 count INT(11) UNSIGNED DEFAULT NULL, 
48			 mission TINYINT(1) DEFAULT NULL, 
49			 owner INT(11) UNSIGNED DEFAULT NULL, 
50			 shipId BIGINT(20) DEFAULT NULL, 
51			 PRIMARY KEY(id)) 
52			 ENGINE = INNODB, 
53			 CHARACTER SET utf8mb4, 
54			 COLLATE utf8mb4_general_ci; 
55
56		 ALTER TABLE aftermath.Game_Ship_Equipments 
57			 ADD CONSTRAINT FK_game_ship_equipment_shipId FOREIGN KEY IF NOT EXISTS(shipId) 
58			 REFERENCES aftermath.Game_Ships(id) ON DELETE NO ACTION; 
59
60		 CREATE TABLE IF NOT EXISTS aftermath.Game_Character_Ships( 
61			 characterId BIGINT(20) NOT NULL, 
62			 shipId BIGINT(20) NOT NULL, 
63			 PRIMARY KEY(characterId, shipId)) 
64			 ENGINE = INNODB, 
65			 CHARACTER SET utf8mb4, 
66			 COLLATE utf8mb4_general_ci; 
67
68		 ALTER TABLE aftermath.Game_Character_Ships 
69			 ADD CONSTRAINT FK_game_character_ships_characterId FOREIGN KEY IF NOT EXISTS(characterId) 
70			 REFERENCES aftermath.Game_Characters(id) ON DELETE NO ACTION; 
71
72		 ALTER TABLE aftermath.Game_Character_Ships 
73			 ADD CONSTRAINT FK_game_character_ships_shipId FOREIGN KEY IF NOT EXISTS(shipId) 
74			 REFERENCES aftermath.Game_Ships(id) ON DELETE NO ACTION;