text: DROP TABLE IF EXISTS Account;
  CREATE TABLE IF NOT EXISTS Account
  (
  AccountNumber                   INT             NOT NULL    UNIQUE  AUTO_INCREMENT,
  UserName                        VARCHAR (25)    NOT NULL    UNIQUE,
  Password                        VARCHAR (100)   NOT NULL,
  Email                           VARCHAR (80)    NOT NULL,
  Admin                           TINYINT         NOT NULL    DEFAULT 0,
  PRIMARY KEY (AccountNumber)
  );
  
  INSERT INTO `Account` (`AccountNumber`, `UserName`, `Password`, `Email`, `Admin`) VALUES
  (1, 'Admin', 'test', 'deh8c7@mst.edu', 1),
  (2, 'NoAdmin', 'test', 'deh8c7@mst.edu', 0),
  (3, 'NewTestGuy1', 'test1', 'dtwoms@gmail.com', 0),
  (4, 'NewTestGuy2', 'test2', 'dtwoms@gmail.com', 0),
  (5, 'TestGuy3', 'test3', 'dtwoms@gmail.com', 0),
  (6, 'NewTestGuy4', 'test4', 'dtwoms@gmail.com', 0),
  (7, 'NewTestGuy5', 'test5', 'dtwoms@gmail.com', 0),
  (8, 'NewTestGuy8', 'test8', 'dtwoms@gmail.com', 0),
  (9, 'NewTestGuy9', 'test9', 'dtwoms@gmail.com', 0),
  (10, 'NewTestGuy10', 'test10', 'dtwoms@gmail.com', 0),
  (11, 'NewTestGuy11', 'test11', 'dtwoms@gmail.com', 0),
  (12, 'NewTestGuy12', 'test12', 'dtwoms@gmail.com', 0),
  (13, 'NewTestGuy13', 'test13', 'dtwoms@gmail.com', 0),
  (14, 'Efsie', '123456', 'gws4g2@mst.edu', 0),
  (15, 'Yourthewinner', 'testding', 'datc5b@mst.edu', 0),
  (16, 'ActionMan', 'test', 'deh8c7@mst.edu', 0),
  (17, 'AdventureMan', 'test', 'deh8c7@mst.edu', 0),
  (18, 'ActionAdventureMan', 'test', 'deh8c7@mst.edu', 0),
  (19, 'DrivingMan', 'test', 'deh8c7@mst.edu', 0),
  (20, 'RPGMan', 'test', 'deh8c7@mst.edu', 0),
  (21, 'SimMan', 'test', 'deh8c7@mst.edu', 0),
  (22, 'SportMan', 'test', 'deh8c7@mst.edu', 0),
  (23, 'StratMan', 'test', 'deh8c7@mst.edu', 0),
  (24, 'PuzzleMan', 'test', 'deh8c7@mst.edu', 0),
  (25, 'ShooterMan', 'test', 'deh8c7@mst.edu', 0),
  (26, 'RhythmMan', 'test', 'deh8c7@mst.edu', 0),
  (27, 'PartyMan', 'test', 'deh8c7@mst.edu', 0),
  (28, 'PlatformerMan', 'test', 'deh8c7@mst.edu', 0),
  (29, 'ComedyMan', 'test', 'deh8c7@mst.edu', 0),
  (30, 'CAndGMan', 'test', 'deh8c7@mst.edu', 0),
  (31, 'DramaMan', 'test', 'deh8c7@mst.edu', 0),
  (32, 'EAndHMan', 'test', 'deh8c7@mst.edu', 0),
  (33, 'FantasyMan', 'test', 'deh8c7@mst.edu', 0),
  (34, 'HorrorMan', 'test', 'deh8c7@mst.edu', 0),
  (35, 'MAndDMan', 'test', 'deh8c7@mst.edu', 0),
  (36, 'MysteryMan', 'test', 'deh8c7@mst.edu', 0),
  (37, 'SciFiMan', 'test', 'deh8c7@mst.edu', 0),
  (38, 'WarMan', 'test', 'deh8c7@mst.edu', 0),
  (39, 'WesternMan', 'test', 'deh8c7@mst.edu', 0),
  (40, 'William', '12345', 'willy@ghost.mov', 0),
  (41, 'SilentThunder', 'mypwd', 'joafyb@mail.mst.edu', 0),
  (42, 'Michael', '123456', 'mtvn83@mst.edu', 0),
  (43, 'j', 'p', 'jadvxd@mst.edu', 0),
  (44, 'TestFinal', 'test', 'dtwoms@gmail.com', 0),
  (45, 'Joe', 'test', 'datc5b@mst.edu', 0),
  (46, 'NewTestGuy14', 'test', 'deh8c7@mst.edu', 0);
  
  DROP TABLE IF EXISTS UserGameRatings;
  CREATE TABLE IF NOT EXISTS UserGameRatings
  (
  AccountNumber                           INT                 NOT NULL,
  GameURI                                 VARCHAR (255)       NOT NULL,
  Rating                                  DOUBLE              NOT NULL,
  Comment                                 TEXT,
  PRIMARY KEY (AccountNumber, GameURI),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE,
  FOREIGN KEY (GameURI) REFERENCES GameList (GameURI) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  INSERT INTO `UserGameRatings` (`AccountNumber`, `GameURI`, `Rating`, `Comment`) VALUES
  (13, 'testURI1', 10, 'this game was super duper!'),
  (13, 'testURI2', 1, 'This game was not so good.'),
  (13, 'BitTripCore', 3, 'yo dog'),
  (44, 'BitTripFate', 3, 'Love it!'),
  (45, 'BitTripRunner', 5, 'This game was mediocre!!!!!!!!');
  
  DROP TABLE IF EXISTS GameGenreQuestionnaire;
  CREATE TABLE IF NOT EXISTS GameGenreQuestionnaire
  (
  AccountNumber                   INT                 NOT NULL        UNIQUE,
  action                          TINYINT             NOT NULL        DEFAULT 5,
  adventure                       TINYINT             NOT NULL        DEFAULT 5,
  actionAdventure                 TINYINT             NOT NULL        DEFAULT 5,
  driving                         TINYINT             NOT NULL        DEFAULT 5,
  rpg                             TINYINT             NOT NULL        DEFAULT 5,
  simulation                      TINYINT             NOT NULL        DEFAULT 5,
  sports                          TINYINT             NOT NULL        DEFAULT 5,
  strategy                        TINYINT             NOT NULL        DEFAULT 5,
  puzzle                          TINYINT             NOT NULL        DEFAULT 5,
  shooter                         TINYINT             NOT NULL        DEFAULT 5,
  rhythm                          TINYINT             NOT NULL        DEFAULT 5,
  party                           TINYINT             NOT NULL        DEFAULT 5,
  platformer                      TINYINT             NOT NULL        DEFAULT 5,
  PRIMARY KEY (AccountNumber),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE
  );
  
  INSERT INTO `GameGenreQuestionnaire` (`AccountNumber`, `action`, `adventure`, `actionAdventure`, `driving`, `rpg`, `simulation`, `sports`, `strategy`, `puzzle`, `shooter`, `rhythm`, `party`, `platformer`) VALUES
  (3, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (4, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (7, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (8, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (9, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (11, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (12, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (13, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (14, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (15, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (39, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (38, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (37, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (36, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (35, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (34, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (33, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (32, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (31, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (30, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (29, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (28, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10),
  (27, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5),
  (26, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5),
  (25, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5),
  (24, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5),
  (23, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5),
  (22, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5),
  (21, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5, 5),
  (20, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5, 5, 5),
  (19, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (18, 10, 10, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (17, 5, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (16, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (2, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (1, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (40, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 5, 5, 5),
  (41, 8, 8, 8, 4, 9, 4, 4, 10, 5, 9, 5, 5, 5),
  (42, 8, 8, 8, 7, 5, 10, 6, 5, 5, 7, 5, 4, 10),
  (43, 7, 8, 9, 1, 10, 3, 1, 9, 7, 3, 1, 1, 8),
  (44, 1, 1, 1, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (45, 9, 9, 9, 5, 9, 5, 5, 5, 9, 5, 5, 5, 5),
  (46, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5);
  
  DROP TABLE IF EXISTS GameSubGenreQuestionnaire;
  CREATE TABLE IF NOT EXISTS GameSubGenreQuestionnaire
  (
  AccountNumber               INT             NOT NULL        UNIQUE,
  fighting                    TINYINT         NOT NULL        DEFAULT 5,
  driving                     TINYINT         NOT NULL        DEFAULT 5,
  wrpg                        TINYINT         NOT NULL        DEFAULT 5,
  jrpg                        TINYINT         NOT NULL        DEFAULT 5,
  baseball                    TINYINT         NOT NULL        DEFAULT 5,
  basketball                  TINYINT         NOT NULL        DEFAULT 5,
  golf                        TINYINT         NOT NULL        DEFAULT 5,
  boxing                      TINYINT         NOT NULL        DEFAULT 5,
  mma                         TINYINT         NOT NULL        DEFAULT 5,
  wrestling                   TINYINT         NOT NULL        DEFAULT 5,
  football                    TINYINT         NOT NULL        DEFAULT 5,
  hockey                      TINYINT         NOT NULL        DEFAULT 5,
  miscellaneous               TINYINT         NOT NULL        DEFAULT 5,
  realTime                    TINYINT         NOT NULL        DEFAULT 5,
  turnBased                   TINYINT         NOT NULL        DEFAULT 5,
  dancing                     TINYINT         NOT NULL        DEFAULT 5,
  singing                     TINYINT         NOT NULL        DEFAULT 5,
  instruments                 TINYINT         NOT NULL        DEFAULT 5,
  fps                         TINYINT         NOT NULL        DEFAULT 5,
  tps                         TINYINT         NOT NULL        DEFAULT 5,
  shmup                       TINYINT         NOT NULL        DEFAULT 5,
  railShooter                 TINYINT         NOT NULL        DEFAULT 5,
  trivia                      TINYINT         NOT NULL        DEFAULT 5,
  PRIMARY KEY (AccountNumber),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE
  );
  
  INSERT INTO `GameSubGenreQuestionnaire` (`AccountNumber`, `fighting`, `driving`, `wrpg`, `jrpg`, `baseball`, `basketball`, `golf`, `boxing`, `mma`, `wrestling`, `football`, `hockey`, `miscellaneous`, `realTime`, `turnBased`, `dancing`, `singing`, `instruments`, `fps`, `tps`, `shmup`, `railShooter`, `trivia`) VALUES
  (3, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (4, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (7, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (8, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (9, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (11, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (12, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (13, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (14, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (15, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (1, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (2, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (16, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (17, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (18, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (19, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (20, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (21, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (22, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (23, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (24, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (25, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (26, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (27, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (28, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (29, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (30, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (31, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (32, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (33, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (34, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (35, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (36, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (37, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (38, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (39, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (40, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (41, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (42, 5, 7, 9, 7, 4, 7, 6, 5, 5, 6, 6, 3, 4, 6, 6, 5, 4, 7, 5, 8, 7, 6, 6),
  (43, 5, 1, 7, 8, 1, 1, 1, 1, 1, 1, 1, 1, 1, 8, 8, 1, 1, 7, 6, 7, 2, 2, 1),
  (44, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (45, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (46, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5);
  
  DROP TABLE IF EXISTS TheatricalGenreQuestionnaire;
  CREATE TABLE IF NOT EXISTS TheatricalGenreQuestionnaire
  (
  AccountNumber                   INT             NOT NULL        UNIQUE,
  action                          TINYINT         NOT NULL        DEFAULT 5,
  adventure                       TINYINT         NOT NULL        DEFAULT 5,
  comedy                          TINYINT         NOT NULL        DEFAULT 5,
  crimeAndGangster                TINYINT         NOT NULL        DEFAULT 5,
  drama                           TINYINT         NOT NULL        DEFAULT 5,
  epicsAndHistorical              TINYINT         NOT NULL        DEFAULT 5,
  fantasy                         TINYINT         NOT NULL        DEFAULT 5,
  horror                          TINYINT         NOT NULL        DEFAULT 5,
  musicAndDancing                 TINYINT         NOT NULL        DEFAULT 5,
  mystery                         TINYINT         NOT NULL        DEFAULT 5,
  sciFi                           TINYINT         NOT NULL        DEFAULT 5,
  war                             TINYINT         NOT NULL        DEFAULT 5,
  western                         TINYINT         NOT NULL        DEFAULT 5,
  PRIMARY KEY (AccountNumber),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE
  );
  
  INSERT INTO `TheatricalGenreQuestionnaire` (`AccountNumber`, `action`, `adventure`, `comedy`, `crimeAndGangster`, `drama`, `epicsAndHistorical`, `fantasy`, `horror`, `musicAndDancing`, `mystery`, `sciFi`, `war`, `western`) VALUES
  (3, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (4, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (6, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (7, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (8, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (9, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (11, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (12, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (13, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (14, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (15, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (39, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10),
  (38, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5),
  (37, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5),
  (19, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (18, 10, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (17, 5, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (16, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (2, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (20, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (21, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (22, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (23, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (24, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (25, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (26, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (27, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (28, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (29, 5, 5, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (30, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (31, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5, 5, 5),
  (32, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5, 5),
  (33, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5, 5),
  (1, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (34, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5, 5),
  (35, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5, 5),
  (36, 5, 5, 5, 5, 5, 5, 5, 5, 5, 10, 5, 5, 5),
  (40, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (41, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (42, 7, 7, 9, 8, 8, 6, 6, 4, 3, 8, 7, 7, 6),
  (43, 7, 7, 1, 8, 6, 1, 9, 8, 1, 9, 9, 1, 3),
  (44, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (45, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5),
  (46, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5);
  
  DROP TABLE IF EXISTS TheatricalSubGenreQuestionnaire;
  CREATE TABLE IF NOT EXISTS TheatricalSubGenreQuestionnaire
  (
  AccountNumber                   INT                 NOT NULL        UNIQUE,
  wwii                            TINYINT             NOT NULL        DEFAULT 5,
  postApocalyptic                 TINYINT             NOT NULL        DEFAULT 5,
  PRIMARY KEY (AccountNumber),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE
  );
  
  INSERT INTO `TheatricalSubGenreQuestionnaire` (`AccountNumber`, `wwii`, `postApocalyptic`) VALUES
  (3, 5, 5),
  (4, 5, 5),
  (5, 5, 5),
  (6, 5, 5),
  (7, 5, 5),
  (8, 5, 5),
  (9, 5, 5),
  (10, 5, 5),
  (11, 5, 5),
  (12, 5, 5),
  (13, 1, 1),
  (14, 5, 5),
  (15, 5, 5),
  (1, 5, 5),
  (2, 5, 5),
  (16, 5, 5),
  (17, 5, 5),
  (18, 5, 5),
  (19, 5, 5),
  (20, 5, 5),
  (21, 5, 5),
  (22, 5, 5),
  (23, 5, 5),
  (24, 5, 5),
  (25, 5, 5),
  (26, 5, 5),
  (27, 5, 5),
  (28, 5, 5),
  (29, 5, 5),
  (30, 5, 5),
  (31, 5, 5),
  (32, 5, 5),
  (33, 5, 5),
  (34, 5, 5),
  (35, 5, 5),
  (36, 5, 5),
  (37, 5, 5),
  (38, 5, 5),
  (39, 5, 5),
  (40, 5, 5),
  (41, 5, 5),
  (42, 8, 7),
  (43, 1, 10),
  (44, 5, 5),
  (45, 5, 5),
  (46, 5, 5);
  
  
  DROP TABLE IF EXISTS GlobalGameRatings;
  CREATE TABLE IF NOT EXISTS GlobalGameRatings
  (
  GameURI                 VARCHAR (255)           NOT NULL        UNIQUE,
  RatingAverage           FLOAT                   NOT NULL,
  NumberOfRatings         INT                     NOT NULL,
  PRIMARY KEY (GameURI),
  FOREIGN KEY (GameURI) REFERENCES GameList (GameURI) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  DROP TABLE IF EXISTS UserCurrentGamesPlaying;
  CREATE TABLE IF NOT EXISTS UserCurrentGamesPlaying
  (
  AccountNumber           INT                     NOT NULL,
  GameURI                 VARCHAR (255)           NOT NULL,
  PRIMARY KEY (AccountNumber, GameURI),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE,
  FOREIGN KEY (GameURI) REFERENCES GameList (GameURI) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  DROP TABLE IF EXISTS GameConsolesList;
  CREATE TABLE IF NOT EXISTS GameConsolesList
  (
  Console                 VARCHAR(255)            NOT NULL        UNIQUE,
  PRIMARY KEY (Console)
  );
  
  INSERT INTO `GameConsolesList`
  (`Console`)
  VALUES
  ('3DO'),
  ('3DS'),
  ('accountNumber'),
  ('actionGamemaster'),
  ('actionMax'),
  ('amiga'),
  ('amigaCD32'),
  ('amstradGX4000'),
  ('apeXtreme'),
  ('aPFImaginationMachine'),
  ('appleIIgs'),
  ('applePippin'),
  ('arc'),
  ('arcade'),
  ('atari2600'),
  ('atari2600Jr'),
  ('atari2700'),
  ('atari5100'),
  ('atari5200'),
  ('atari7800'),
  ('atariFlashback'),
  ('atariFlashback2'),
  ('atariJaguar'),
  ('atariJaguarCD'),
  ('atariJaguarII'),
  ('atariLynx'),
  ('atariST'),
  ('ballyAstrocade'),
  ('c64DirectToTV'),
  ('casioLoopy'),
  ('cdi'),
  ('channelFSystemII'),
  ('colecoTelstar'),
  ('colecoVision'),
  ('commodore64'),
  ('commodore64GS'),
  ('commodoreCDTV'),
  ('commodoreMAXMachine'),
  ('creatiVision'),
  ('dreamcast'),
  ('dos'),
  ('emersonArcadia2001'),
  ('entexAdventureVision'),
  ('epochCassetteVision'),
  ('evoPhaseOne'),
  ('fairchildChannelF'),
  ('fantasticFourTVGame'),
  ('fcTwin'),
  ('fmTownsMarty'),
  ('gameAndWatch'),
  ('gameBoy'),
  ('gameBoyAdvance'),
  ('gameBoyAdvanceSP'),
  ('gameBoyAdvanceSPMarkII'),
  ('gameBoyColor'),
  ('gameBoyMicro'),
  ('gameBoyPocket'),
  ('gameKing'),
  ('gameSystem'),
  ('gameWave'),
  ('gba'),
  ('gbc'),
  ('gcn'),
  ('generationNEX'),
  ('gizmondo'),
  ('gp2x'),
  ('gp2xwiz'),
  ('gp32'),
  ('intellivision'),
  ('intellivisionII'),
  ('intertonVC4000'),
  ('iOS'),
  ('iPodTouch'),
  ('iQuePlayer'),
  ('kinect'),
  ('konixMultisystem'),
  ('l600'),
  ('macOS'),
  ('magnavoxOdyssey'),
  ('magnavoxOdyssey2'),
  ('mattelHyperScan'),
  ('memorexVIS'),
  ('mi2'),
  ('microvision'),
  ('msx'),
  ('n64'),
  ('nds'),
  ('neoGeo'),
  ('neoGeoCD'),
  ('neoGeoCDZ'),
  ('neoGeoPocket'),
  ('neoGeoPocketColor'),
  ('netYaroze'),
  ('nes'),
  ('nGage'),
  ('nGageQD'),
  ('nintendo64'),
  ('nintendo64DD'),
  ('nintendoDS'),
  ('nintendoDSi'),
  ('nintendoDSiXL'),
  ('nintendoDSLite'),
  ('nintendoEntertainmentSystem'),
  ('nintendoGameCube'),
  ('nuon'),
  ('onLive'),
  ('panasonicM2'),
  ('panasonicQ'),
  ('pandora'),
  ('pc'),
  ('pcdl'),
  ('pcEngine'),
  ('pcfx'),
  ('phantom'),
  ('philipsOdyssey'),
  ('pioneerLaserActive'),
  ('playCable'),
  ('playdia'),
  ('playPal'),
  ('playStation'),
  ('playStation2'),
  ('playStation2Slimline'),
  ('playStation3'),
  ('playStation3Slim'),
  ('playStationPortable'),
  ('playStationPortableLite'),
  ('playStationPortableSlim'),
  ('pocketPC'),
  ('pocketStation'),
  ('pokemonMini'),
  ('pong'),
  ('pspgo'),
  ('psx'),
  ('ps1'),
  ('ps2'),
  ('ps3'),
  ('psn'),
  ('psOne'),
  ('pv1000'),
  ('qGameBoyPlayer'),
  ('rcaStudioII'),
  ('rdiHalcyon'),
  ('rumbleStation'),
  ('rzone'),
  ('segaCD'),
  ('segaGameGear'),
  ('segaGenesis'),
  ('segaGenesis3'),
  ('segaGenesis32X'),
  ('segaGenesisII'),
  ('segaMasterSystem'),
  ('segaMasterSystemII'),
  ('segaMasterSystemIII'),
  ('segaMegaDriveII'),
  ('segaNomad'),
  ('segaSaturn'),
  ('segaSG1000'),
  ('segaSG1000II'),
  ('sharpNintendoTelevision'),
  ('snes'),
  ('snescd'),
  ('spaceInvaders'),
  ('superACan'),
  ('superCassetteVision'),
  ('superGameBoy'),
  ('superGameBoy2'),
  ('supergameVG3000'),
  ('superGrafx'),
  ('superNintendoEntertainmentSystem'),
  ('superTVBoy'),
  ('supervision'),
  ('swanCrystal'),
  ('tapwaveZodiac'),
  ('theWondermega'),
  ('turboDuo'),
  ('turboExpress'),
  ('turboGrafx16'),
  ('turboGrafxCD'),
  ('tvBoy'),
  ('tvBoy2'),
  ('vectrex'),
  ('videoEntertainmentSystem'),
  ('virtualBoy'),
  ('vSmile'),
  ('wii'),
  ('wiiVC'),
  ('wiiWare'),
  ('wonderSwan'),
  ('wonderSwanColor'),
  ('xaviXPortGamingConsole'),
  ('xbla'),
  ('xbox'),
  ('xbox360'),
  ('xbox360Slim'),
  ('zeebo'),
  ('zone40'),
  ('zuneHD');
  
  DROP TABLE IF EXISTS UserGameConsoles;
  CREATE TABLE IF NOT EXISTS UserGameConsoles
  (
  AccountNumber           INT                 NOT NULL,
  Console                 VARCHAR (255)       NOT NULL,
  PRIMARY KEY (AccountNumber, Console),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE,
  FOREIGN KEY (Console) REFERENCES GameConsolesList (Console) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  DROP TABLE IF EXISTS UserProfileGenres;
  CREATE TABLE IF NOT EXISTS UserProfileGenres
  (
  AccountNumber           INT                 NOT NULL,
  Genre                   VARCHAR (15)        NOT NULL        DEFAULT 'DEFAULT',
  Score                   FLOAT               NOT NULL        DEFAULT 5,
  NumberRatings           INT                 NOT NULL        DEFAULT 0,
  PRIMARY KEY (AccountNumber, Genre),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE
  );
  
  INSERT INTO `UserProfileGenres` (`AccountNumber`, `Genre`, `Score`, `NumberRatings`) VALUES
  (3, '', 5, 0),
  (4, '', 5, 0),
  (5, '', 5, 0),
  (6, '', 5, 0),
  (7, 'action', 5, 0),
  (7, 'adventure', 5, 0),
  (7, 'actionAdventure', 5, 0),
  (7, 'driving', 5, 0),
  (7, 'rpg', 5, 0),
  (7, 'simulation', 5, 0),
  (7, 'sports', 5, 0),
  (7, 'strategy', 5, 0),
  (7, 'puzzle', 5, 0),
  (7, 'shooter', 5, 0),
  (7, 'rhythm', 5, 0),
  (7, 'party', 5, 0),
  (7, 'fighting', 5, 0),
  (7, 'wrpg', 5, 0),
  (7, 'jrpg', 5, 0),
  (7, 'baseball', 5, 0),
  (7, 'basketball', 5, 0),
  (7, 'golf', 5, 0),
  (7, 'boxing', 5, 0),
  (7, 'mma', 5, 0),
  (7, 'wrestling', 5, 0),
  (7, 'football', 5, 0),
  (7, 'hockey', 5, 0),
  (7, 'miscellaneous', 5, 0),
  (7, 'realTime', 5, 0),
  (7, 'turnBased', 5, 0),
  (7, 'dancing', 5, 0),
  (7, 'singing', 5, 0),
  (7, 'instruments', 5, 0),
  (7, 'fps', 5, 0),
  (7, 'tps', 5, 0),
  (7, 'shmup', 5, 0),
  (7, 'railShooter', 5, 0),
  (7, 'trivia', 5, 0),
  (7, '', 5, 0),
  (8, 'action', 5, 0),
  (8, 'adventure', 5, 0),
  (8, 'actionAdventure', 5, 0),
  (8, 'driving', 5, 0),
  (8, 'rpg', 5, 0),
  (8, 'simulation', 5, 0),
  (8, 'sports', 5, 0),
  (8, 'strategy', 5, 0),
  (8, 'puzzle', 5, 0),
  (8, 'shooter', 5, 0),
  (8, 'rhythm', 5, 0),
  (8, 'party', 5, 0),
  (8, 'fighting', 5, 0),
  (8, 'wrpg', 5, 0),
  (8, 'jrpg', 5, 0),
  (8, 'baseball', 5, 0),
  (8, 'basketball', 5, 0),
  (8, 'golf', 5, 0),
  (8, 'boxing', 5, 0),
  (8, 'mma', 5, 0),
  (8, 'wrestling', 5, 0),
  (8, 'football', 5, 0),
  (8, 'hockey', 5, 0),
  (8, 'miscellaneous', 5, 0),
  (8, 'realTime', 5, 0),
  (8, 'turnBased', 5, 0),
  (8, 'dancing', 5, 0),
  (8, 'singing', 5, 0),
  (8, 'instruments', 5, 0),
  (8, 'fps', 5, 0),
  (8, 'tps', 5, 0),
  (8, 'shmup', 5, 0),
  (8, 'railShooter', 5, 0),
  (8, 'trivia', 5, 0),
  (8, 'a', 5, 0),
  (8, 'r', 5, 0),
  (9, 'action', 5, 0),
  (9, 'adventure', 5, 0),
  (9, 'actionAdventure', 5, 0),
  (9, 'driving', 5, 0),
  (9, 'rpg', 5, 0),
  (9, 'simulation', 5, 0),
  (9, 'sports', 5, 0),
  (9, 'strategy', 5, 0),
  (9, 'puzzle', 5, 0),
  (9, 'shooter', 5, 0),
  (9, 'rhythm', 5, 0),
  (9, 'party', 5, 0),
  (9, 'fighting', 5, 0),
  (9, 'wrpg', 5, 0),
  (9, 'jrpg', 5, 0),
  (9, 'baseball', 5, 0),
  (9, 'basketball', 5, 0),
  (9, 'golf', 5, 0),
  (9, 'boxing', 5, 0),
  (9, 'mma', 5, 0),
  (9, 'wrestling', 5, 0),
  (9, 'football', 5, 0),
  (9, 'hockey', 5, 0),
  (9, 'miscellaneous', 5, 0),
  (9, 'realTime', 5, 0),
  (9, 'turnBased', 5, 0),
  (9, 'dancing', 5, 0),
  (9, 'singing', 5, 0),
  (9, 'instruments', 5, 0),
  (9, 'fps', 5, 0),
  (9, 'tps', 5, 0),
  (9, 'shmup', 5, 0),
  (9, 'railShooter', 5, 0),
  (9, 'trivia', 5, 0),
  (9, '', 5, 0),
  (10, 'action', 5, 0),
  (10, 'adventure', 5, 0),
  (10, 'actionAdventure', 5, 0),
  (10, 'driving', 5, 0),
  (10, 'rpg', 5, 0),
  (10, 'simulation', 5, 0),
  (10, 'sports', 5, 0),
  (10, 'strategy', 5, 0),
  (10, 'puzzle', 5, 0),
  (10, 'shooter', 5, 0),
  (10, 'rhythm', 5, 0),
  (10, 'party', 5, 0),
  (10, 'fighting', 5, 0),
  (10, 'wrpg', 5, 0),
  (10, 'jrpg', 5, 0),
  (10, 'baseball', 5, 0),
  (10, 'basketball', 5, 0),
  (10, 'golf', 5, 0),
  (10, 'boxing', 5, 0),
  (10, 'mma', 5, 0),
  (10, 'wrestling', 5, 0),
  (10, 'football', 5, 0),
  (10, 'hockey', 5, 0),
  (10, 'miscellaneous', 5, 0),
  (10, 'realTime', 5, 0),
  (10, 'turnBased', 5, 0),
  (10, 'dancing', 5, 0),
  (10, 'singing', 5, 0),
  (10, 'instruments', 5, 0),
  (10, 'fps', 5, 0),
  (10, 'tps', 5, 0),
  (10, 'shmup', 5, 0),
  (10, 'railShooter', 5, 0),
  (10, 'trivia', 5, 0),
  (11, 'action', 5, 0),
  (11, 'adventure', 5, 0),
  (11, 'actionAdventure', 5, 0),
  (11, 'driving', 5, 0),
  (11, 'rpg', 5, 0),
  (11, 'simulation', 5, 0),
  (11, 'sports', 5, 0),
  (11, 'strategy', 5, 0),
  (11, 'puzzle', 5, 0),
  (11, 'shooter', 5, 0),
  (11, 'rhythm', 5, 0),
  (11, 'party', 5, 0),
  (11, 'fighting', 5, 0),
  (11, 'wrpg', 5, 0),
  (11, 'jrpg', 5, 0),
  (11, 'baseball', 5, 0),
  (11, 'basketball', 5, 0),
  (11, 'golf', 5, 0),
  (11, 'boxing', 5, 0),
  (11, 'mma', 5, 0),
  (11, 'wrestling', 5, 0),
  (11, 'football', 5, 0),
  (11, 'hockey', 5, 0),
  (11, 'miscellaneous', 5, 0),
  (11, 'realTime', 5, 0),
  (11, 'turnBased', 5, 0),
  (11, 'dancing', 5, 0),
  (11, 'singing', 5, 0),
  (11, 'instruments', 5, 0),
  (11, 'fps', 5, 0),
  (11, 'tps', 5, 0),
  (11, 'shmup', 5, 0),
  (11, 'railShooter', 5, 0),
  (11, 'trivia', 5, 0),
  (12, 'action', 5, 0),
  (12, 'adventure', 5, 0),
  (12, 'actionAdventure', 5, 0),
  (12, 'driving', 5, 0),
  (12, 'rpg', 5, 0),
  (12, 'simulation', 5, 0),
  (12, 'sports', 5, 0),
  (12, 'strategy', 5, 0),
  (12, 'puzzle', 5, 0),
  (12, 'shooter', 5, 0),
  (12, 'rhythm', 5, 0),
  (12, 'party', 5, 0),
  (12, 'fighting', 5, 0),
  (12, 'wrpg', 5, 0),
  (12, 'jrpg', 5, 0),
  (12, 'baseball', 5, 0),
  (12, 'basketball', 5, 0),
  (12, 'golf', 5, 0),
  (12, 'boxing', 5, 0),
  (12, 'mma', 5, 0),
  (12, 'wrestling', 5, 0),
  (12, 'football', 5, 0),
  (12, 'hockey', 5, 0),
  (12, 'miscellaneous', 5, 0),
  (12, 'realTime', 5, 0),
  (12, 'turnBased', 5, 0),
  (12, 'dancing', 5, 0),
  (12, 'singing', 5, 0),
  (12, 'instruments', 5, 0),
  (12, 'fps', 5, 0),
  (12, 'tps', 5, 0),
  (12, 'shmup', 5, 0),
  (12, 'railShooter', 5, 0),
  (12, 'trivia', 5, 0),
  (13, 'action', 5, 0),
  (13, 'adventure', 5, 0),
  (13, 'actionAdventure', 5, 0),
  (13, 'driving', 5, 0),
  (13, 'rpg', 5, 0),
  (13, 'simulation', 5, 0),
  (13, 'sports', 5, 0),
  (13, 'strategy', 5, 0),
  (13, 'puzzle', 5, 0),
  (13, 'shooter', 5, 0),
  (13, 'rhythm', 5, 0),
  (13, 'party', 5, 0),
  (13, 'fighting', 5, 0),
  (13, 'wrpg', 5, 0),
  (13, 'jrpg', 5, 0),
  (13, 'baseball', 5, 0),
  (13, 'basketball', 5, 0),
  (13, 'golf', 5, 0),
  (13, 'boxing', 5, 0),
  (13, 'mma', 5, 0),
  (13, 'wrestling', 5, 0),
  (13, 'football', 5, 0),
  (13, 'hockey', 5, 0),
  (13, 'miscellaneous', 5, 0),
  (13, 'realTime', 5, 0),
  (13, 'turnBased', 5, 0),
  (13, 'dancing', 5, 0),
  (13, 'singing', 5, 0),
  (13, 'instruments', 5, 0),
  (13, 'fps', 5, 0),
  (13, 'tps', 5, 0),
  (13, 'shmup', 5, 0),
  (13, 'railShooter', 5, 0),
  (13, 'trivia', 5, 0),
  (14, 'action', 5, 0),
  (14, 'adventure', 5, 0),
  (14, 'actionAdventure', 5, 0),
  (14, 'driving', 5, 0),
  (14, 'rpg', 5, 0),
  (14, 'simulation', 5, 0),
  (14, 'sports', 5, 0),
  (14, 'strategy', 5, 0),
  (14, 'puzzle', 5, 0),
  (14, 'shooter', 5, 0),
  (14, 'rhythm', 5, 0),
  (14, 'party', 5, 0),
  (14, 'fighting', 5, 0),
  (14, 'wrpg', 5, 0),
  (14, 'jrpg', 5, 0),
  (14, 'baseball', 5, 0),
  (14, 'basketball', 5, 0),
  (14, 'golf', 5, 0),
  (14, 'boxing', 5, 0),
  (14, 'mma', 5, 0),
  (14, 'wrestling', 5, 0),
  (14, 'football', 5, 0),
  (14, 'hockey', 5, 0),
  (14, 'miscellaneous', 5, 0),
  (14, 'realTime', 5, 0),
  (14, 'turnBased', 5, 0),
  (14, 'dancing', 5, 0),
  (14, 'singing', 5, 0),
  (14, 'instruments', 5, 0),
  (14, 'fps', 5, 0),
  (14, 'tps', 5, 0),
  (14, 'shmup', 5, 0),
  (14, 'railShooter', 5, 0),
  (14, 'trivia', 5, 0),
  (15, 'action', 5, 0),
  (15, 'adventure', 5, 0),
  (15, 'actionAdventure', 5, 0),
  (15, 'driving', 5, 0),
  (15, 'rpg', 5, 0),
  (15, 'simulation', 5, 0),
  (15, 'sports', 5, 0),
  (15, 'strategy', 5, 0),
  (15, 'puzzle', 5, 0),
  (15, 'shooter', 5, 0),
  (15, 'rhythm', 5, 0),
  (15, 'party', 5, 0),
  (15, 'fighting', 5, 0),
  (15, 'wrpg', 5, 0),
  (15, 'jrpg', 5, 0),
  (15, 'baseball', 5, 0),
  (15, 'basketball', 5, 0),
  (15, 'golf', 5, 0),
  (15, 'boxing', 5, 0),
  (15, 'mma', 5, 0),
  (15, 'wrestling', 5, 0),
  (15, 'football', 5, 0),
  (15, 'hockey', 5, 0),
  (15, 'miscellaneous', 5, 0),
  (15, 'realTime', 5, 0),
  (15, 'turnBased', 5, 0),
  (15, 'dancing', 5, 0),
  (15, 'singing', 5, 0),
  (15, 'instruments', 5, 0),
  (15, 'fps', 5, 0),
  (15, 'tps', 5, 0),
  (15, 'shmup', 5, 0),
  (15, 'railShooter', 5, 0),
  (15, 'trivia', 5, 0),
  (40, 'action', 5, 0),
  (40, 'adventure', 5, 0),
  (40, 'actionAdventure', 5, 0),
  (40, 'driving', 5, 0),
  (40, 'rpg', 5, 0),
  (40, 'simulation', 5, 0),
  (40, 'sports', 5, 0),
  (40, 'strategy', 5, 0),
  (40, 'puzzle', 5, 0),
  (40, 'shooter', 5, 0),
  (40, 'rhythm', 5, 0),
  (40, 'party', 5, 0),
  (40, 'fighting', 5, 0),
  (40, 'wrpg', 5, 0),
  (40, 'jrpg', 5, 0),
  (40, 'baseball', 5, 0),
  (40, 'basketball', 5, 0),
  (40, 'golf', 5, 0),
  (40, 'boxing', 5, 0),
  (40, 'mma', 5, 0),
  (40, 'wrestling', 5, 0),
  (40, 'football', 5, 0),
  (40, 'hockey', 5, 0),
  (40, 'miscellaneous', 5, 0),
  (40, 'realTime', 5, 0),
  (40, 'turnBased', 5, 0),
  (40, 'dancing', 5, 0),
  (40, 'singing', 5, 0),
  (40, 'instruments', 5, 0),
  (40, 'fps', 5, 0),
  (40, 'tps', 5, 0),
  (40, 'shmup', 5, 0),
  (40, 'railShooter', 5, 0),
  (40, 'trivia', 5, 0),
  (41, 'action', 5, 0),
  (41, 'adventure', 5, 0),
  (41, 'actionAdventure', 5, 0),
  (41, 'driving', 5, 0),
  (41, 'rpg', 5, 0),
  (41, 'simulation', 5, 0),
  (41, 'sports', 5, 0),
  (41, 'strategy', 5, 0),
  (41, 'puzzle', 5, 0),
  (41, 'shooter', 5, 0),
  (41, 'rhythm', 5, 0),
  (41, 'party', 5, 0),
  (41, 'fighting', 5, 0),
  (41, 'wrpg', 5, 0),
  (41, 'jrpg', 5, 0),
  (41, 'baseball', 5, 0),
  (41, 'basketball', 5, 0),
  (41, 'golf', 5, 0),
  (41, 'boxing', 5, 0),
  (41, 'mma', 5, 0),
  (41, 'wrestling', 5, 0),
  (41, 'football', 5, 0),
  (41, 'hockey', 5, 0),
  (41, 'miscellaneous', 5, 0),
  (41, 'realTime', 5, 0),
  (41, 'turnBased', 5, 0),
  (41, 'dancing', 5, 0),
  (41, 'singing', 5, 0),
  (41, 'instruments', 5, 0),
  (41, 'fps', 5, 0),
  (41, 'tps', 5, 0),
  (41, 'shmup', 5, 0),
  (41, 'railShooter', 5, 0),
  (41, 'trivia', 5, 0),
  (42, 'action', 5, 0),
  (42, 'adventure', 5, 0),
  (42, 'actionAdventure', 5, 0),
  (42, 'driving', 5, 0),
  (42, 'rpg', 5, 0),
  (42, 'simulation', 5, 0),
  (42, 'sports', 5, 0),
  (42, 'strategy', 5, 0),
  (42, 'puzzle', 5, 0),
  (42, 'shooter', 5, 0),
  (42, 'rhythm', 5, 0),
  (42, 'party', 5, 0),
  (42, 'fighting', 5, 0),
  (42, 'wrpg', 5, 0),
  (42, 'jrpg', 5, 0),
  (42, 'baseball', 5, 0),
  (42, 'basketball', 5, 0),
  (42, 'golf', 5, 0),
  (42, 'boxing', 5, 0),
  (42, 'mma', 5, 0),
  (42, 'wrestling', 5, 0),
  (42, 'football', 5, 0),
  (42, 'hockey', 5, 0),
  (42, 'miscellaneous', 5, 0),
  (42, 'realTime', 5, 0),
  (42, 'turnBased', 5, 0),
  (42, 'dancing', 5, 0),
  (42, 'singing', 5, 0),
  (42, 'instruments', 5, 0),
  (42, 'fps', 5, 0),
  (42, 'tps', 5, 0),
  (42, 'shmup', 5, 0),
  (42, 'railShooter', 5, 0),
  (42, 'trivia', 5, 0),
  (43, 'action', 5, 0),
  (43, 'adventure', 5, 0),
  (43, 'actionAdventure', 5, 0),
  (43, 'driving', 5, 0),
  (43, 'rpg', 5, 0),
  (43, 'simulation', 5, 0),
  (43, 'sports', 5, 0),
  (43, 'strategy', 5, 0),
  (43, 'puzzle', 5, 0),
  (43, 'shooter', 5, 0),
  (43, 'rhythm', 5, 0),
  (43, 'party', 5, 0),
  (43, 'fighting', 5, 0),
  (43, 'wrpg', 5, 0),
  (43, 'jrpg', 5, 0),
  (43, 'baseball', 5, 0),
  (43, 'basketball', 5, 0),
  (43, 'golf', 5, 0),
  (43, 'boxing', 5, 0),
  (43, 'mma', 5, 0),
  (43, 'wrestling', 5, 0),
  (43, 'football', 5, 0),
  (43, 'hockey', 5, 0),
  (43, 'miscellaneous', 5, 0),
  (43, 'realTime', 5, 0),
  (43, 'turnBased', 5, 0),
  (43, 'dancing', 5, 0),
  (43, 'singing', 5, 0),
  (43, 'instruments', 5, 0),
  (43, 'fps', 5, 0),
  (43, 'tps', 5, 0),
  (43, 'shmup', 5, 0),
  (43, 'railShooter', 5, 0),
  (43, 'trivia', 5, 0),
  (44, 'action', 5, 0),
  (44, 'adventure', 5, 0),
  (44, 'actionAdventure', 5, 0),
  (44, 'driving', 5, 0),
  (44, 'rpg', 5, 0),
  (44, 'simulation', 5, 0),
  (44, 'sports', 5, 0),
  (44, 'strategy', 5, 0),
  (44, 'puzzle', 5, 0),
  (44, 'shooter', 5, 0),
  (44, 'rhythm', 5, 0),
  (44, 'party', 5, 0),
  (44, 'fighting', 5, 0),
  (44, 'wrpg', 5, 0),
  (44, 'jrpg', 5, 0),
  (44, 'baseball', 5, 0),
  (44, 'basketball', 5, 0),
  (44, 'golf', 5, 0),
  (44, 'boxing', 5, 0),
  (44, 'mma', 5, 0),
  (44, 'wrestling', 5, 0),
  (44, 'football', 5, 0),
  (44, 'hockey', 5, 0),
  (44, 'miscellaneous', 5, 0),
  (44, 'realTime', 5, 0),
  (44, 'turnBased', 5, 0),
  (44, 'dancing', 5, 0),
  (44, 'singing', 5, 0),
  (44, 'instruments', 5, 0),
  (44, 'fps', 5, 0),
  (44, 'tps', 5, 0),
  (44, 'shmup', 5, 0),
  (44, 'railShooter', 5, 0),
  (44, 'trivia', 5, 0),
  (45, 'action', 5, 0),
  (45, 'adventure', 5, 0),
  (45, 'actionAdventure', 5, 0),
  (45, 'driving', 5, 0),
  (45, 'rpg', 5, 0),
  (45, 'simulation', 5, 0),
  (45, 'sports', 5, 0),
  (45, 'strategy', 5, 0),
  (45, 'puzzle', 5, 0),
  (45, 'shooter', 5, 0),
  (45, 'rhythm', 5, 0),
  (45, 'party', 5, 0),
  (45, 'fighting', 5, 0),
  (45, 'wrpg', 5, 0),
  (45, 'jrpg', 5, 0),
  (45, 'baseball', 5, 0),
  (45, 'basketball', 5, 0),
  (45, 'golf', 5, 0),
  (45, 'boxing', 5, 0),
  (45, 'mma', 5, 0),
  (45, 'wrestling', 5, 0),
  (45, 'football', 5, 0),
  (45, 'hockey', 5, 0),
  (45, 'miscellaneous', 5, 0),
  (45, 'realTime', 5, 0),
  (45, 'turnBased', 5, 0),
  (45, 'dancing', 5, 0),
  (45, 'singing', 5, 0),
  (45, 'instruments', 5, 0),
  (45, 'fps', 5, 0),
  (45, 'tps', 5, 0),
  (45, 'shmup', 5, 0),
  (45, 'railShooter', 5, 0),
  (45, 'trivia', 5, 0),
  (46, 'action', 5, 0),
  (46, 'adventure', 5, 0),
  (46, 'actionAdventure', 5, 0),
  (46, 'driving', 5, 0),
  (46, 'rpg', 5, 0),
  (46, 'simulation', 5, 0),
  (46, 'sports', 5, 0),
  (46, 'strategy', 5, 0),
  (46, 'puzzle', 5, 0),
  (46, 'shooter', 5, 0),
  (46, 'rhythm', 5, 0),
  (46, 'party', 5, 0),
  (46, 'fighting', 5, 0),
  (46, 'wrpg', 5, 0),
  (46, 'jrpg', 5, 0),
  (46, 'baseball', 5, 0),
  (46, 'basketball', 5, 0),
  (46, 'golf', 5, 0),
  (46, 'boxing', 5, 0),
  (46, 'mma', 5, 0),
  (46, 'wrestling', 5, 0),
  (46, 'football', 5, 0),
  (46, 'hockey', 5, 0),
  (46, 'miscellaneous', 5, 0),
  (46, 'realTime', 5, 0),
  (46, 'turnBased', 5, 0),
  (46, 'dancing', 5, 0),
  (46, 'singing', 5, 0),
  (46, 'instruments', 5, 0),
  (46, 'fps', 5, 0),
  (46, 'tps', 5, 0),
  (46, 'shmup', 5, 0),
  (46, 'railShooter', 5, 0),
  (46, 'trivia', 5, 0);
  
  DROP TABLE IF EXISTS UserProfileTheatricalGenres;
  CREATE TABLE IF NOT EXISTS UserProfileTheatricalGenres
  (
  AccountNumber           INT                 NOT NULL,
  Genre                   VARCHAR (25)        NOT NULL        DEFAULT 'DEFAULT',
  Score                   FLOAT               NOT NULL        DEFAULT 5,
  NumberRatings           INT                 NOT NULL        DEFAULT 0,
  PRIMARY KEY (AccountNumber, Genre),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE
  );
  
  INSERT INTO `UserProfileTheatricalGenres` (`AccountNumber`, `Genre`, `Score`, `NumberRatings`) VALUES
  (10, '', 5, 0),
  (11, '', 5, 0),
  (12, 'action', 5, 0),
  (12, 'adventure', 5, 0),
  (12, 'comedy', 5, 0),
  (12, 'crimeAndGangster', 5, 0),
  (12, 'drama', 5, 0),
  (12, 'epicsAndHistorical', 5, 0),
  (12, 'fantasy', 5, 0),
  (12, 'horror', 5, 0),
  (12, 'musicAndDancing', 5, 0),
  (12, 'mystery', 5, 0),
  (12, 'sciFi', 5, 0),
  (12, 'war', 5, 0),
  (12, 'western', 5, 0),
  (12, 'wwii', 5, 0),
  (12, 'postApocalyptic', 5, 0),
  (13, 'action', 5, 0),
  (13, 'adventure', 5, 0),
  (13, 'comedy', 5, 0),
  (13, 'crimeAndGangster', 5, 0),
  (13, 'drama', 5, 0),
  (13, 'epicsAndHistorical', 5, 0),
  (13, 'fantasy', 5, 0),
  (13, 'horror', 5, 0),
  (13, 'musicAndDancing', 5, 0),
  (13, 'mystery', 5, 0),
  (13, 'sciFi', 5, 0),
  (13, 'war', 5, 0),
  (13, 'western', 5, 0),
  (13, 'wwii', 5, 0),
  (13, 'postApocalyptic', 5, 0),
  (14, 'action', 5, 0),
  (14, 'adventure', 5, 0),
  (14, 'comedy', 5, 0),
  (14, 'crimeAndGangster', 5, 0),
  (14, 'drama', 5, 0),
  (14, 'epicsAndHistorical', 5, 0),
  (14, 'fantasy', 5, 0),
  (14, 'horror', 5, 0),
  (14, 'musicAndDancing', 5, 0),
  (14, 'mystery', 5, 0),
  (14, 'sciFi', 5, 0),
  (14, 'war', 5, 0),
  (14, 'western', 5, 0),
  (14, 'wwii', 5, 0),
  (14, 'postApocalyptic', 5, 0),
  (15, 'action', 5, 0),
  (15, 'adventure', 5, 0),
  (15, 'comedy', 5, 0),
  (15, 'crimeAndGangster', 5, 0),
  (15, 'drama', 5, 0),
  (15, 'epicsAndHistorical', 5, 0),
  (15, 'fantasy', 5, 0),
  (15, 'horror', 5, 0),
  (15, 'musicAndDancing', 5, 0),
  (15, 'mystery', 5, 0),
  (15, 'sciFi', 5, 0),
  (15, 'war', 5, 0),
  (15, 'western', 5, 0),
  (15, 'wwii', 5, 0),
  (15, 'postApocalyptic', 5, 0),
  (40, 'action', 5, 0),
  (40, 'adventure', 5, 0),
  (40, 'comedy', 5, 0),
  (40, 'crimeAndGangster', 5, 0),
  (40, 'drama', 5, 0),
  (40, 'epicsAndHistorical', 5, 0),
  (40, 'fantasy', 5, 0),
  (40, 'horror', 5, 0),
  (40, 'musicAndDancing', 5, 0),
  (40, 'mystery', 5, 0),
  (40, 'sciFi', 5, 0),
  (40, 'war', 5, 0),
  (40, 'western', 5, 0),
  (40, 'wwii', 5, 0),
  (40, 'postApocalyptic', 5, 0),
  (41, 'action', 5, 0),
  (41, 'adventure', 5, 0),
  (41, 'comedy', 5, 0),
  (41, 'crimeAndGangster', 5, 0),
  (41, 'drama', 5, 0),
  (41, 'epicsAndHistorical', 5, 0),
  (41, 'fantasy', 5, 0),
  (41, 'horror', 5, 0),
  (41, 'musicAndDancing', 5, 0),
  (41, 'mystery', 5, 0),
  (41, 'sciFi', 5, 0),
  (41, 'war', 5, 0),
  (41, 'western', 5, 0),
  (41, 'wwii', 5, 0),
  (41, 'postApocalyptic', 5, 0),
  (42, 'action', 5, 0),
  (42, 'adventure', 5, 0),
  (42, 'comedy', 5, 0),
  (42, 'crimeAndGangster', 5, 0),
  (42, 'drama', 5, 0),
  (42, 'epicsAndHistorical', 5, 0),
  (42, 'fantasy', 5, 0),
  (42, 'horror', 5, 0),
  (42, 'musicAndDancing', 5, 0),
  (42, 'mystery', 5, 0),
  (42, 'sciFi', 5, 0),
  (42, 'war', 5, 0),
  (42, 'western', 5, 0),
  (42, 'wwii', 5, 0),
  (42, 'postApocalyptic', 5, 0),
  (43, 'action', 5, 0),
  (43, 'adventure', 5, 0),
  (43, 'comedy', 5, 0),
  (43, 'crimeAndGangster', 5, 0),
  (43, 'drama', 5, 0),
  (43, 'epicsAndHistorical', 5, 0),
  (43, 'fantasy', 5, 0),
  (43, 'horror', 5, 0),
  (43, 'musicAndDancing', 5, 0),
  (43, 'mystery', 5, 0),
  (43, 'sciFi', 5, 0),
  (43, 'war', 5, 0),
  (43, 'western', 5, 0),
  (43, 'wwii', 5, 0),
  (43, 'postApocalyptic', 5, 0),
  (44, 'action', 5, 0),
  (44, 'adventure', 5, 0),
  (44, 'comedy', 5, 0),
  (44, 'crimeAndGangster', 5, 0),
  (44, 'drama', 5, 0),
  (44, 'epicsAndHistorical', 5, 0),
  (44, 'fantasy', 5, 0),
  (44, 'horror', 5, 0),
  (44, 'musicAndDancing', 5, 0),
  (44, 'mystery', 5, 0),
  (44, 'sciFi', 5, 0),
  (44, 'war', 5, 0),
  (44, 'western', 5, 0),
  (44, 'wwii', 5, 0),
  (44, 'postApocalyptic', 5, 0),
  (45, 'action', 5, 0),
  (45, 'adventure', 5, 0),
  (45, 'comedy', 5, 0),
  (45, 'crimeAndGangster', 5, 0),
  (45, 'drama', 5, 0),
  (45, 'epicsAndHistorical', 5, 0),
  (45, 'fantasy', 5, 0),
  (45, 'horror', 5, 0),
  (45, 'musicAndDancing', 5, 0),
  (45, 'mystery', 5, 0),
  (45, 'sciFi', 5, 0),
  (45, 'war', 5, 0),
  (45, 'western', 5, 0),
  (45, 'wwii', 5, 0),
  (45, 'postApocalyptic', 5, 0),
  (46, 'action', 5, 0),
  (46, 'adventure', 5, 0),
  (46, 'comedy', 5, 0),
  (46, 'crimeAndGangster', 5, 0),
  (46, 'drama', 5, 0),
  (46, 'epicsAndHistorical', 5, 0),
  (46, 'fantasy', 5, 0),
  (46, 'horror', 5, 0),
  (46, 'musicAndDancing', 5, 0),
  (46, 'mystery', 5, 0),
  (46, 'sciFi', 5, 0),
  (46, 'war', 5, 0),
  (46, 'western', 5, 0),
  (46, 'wwii', 5, 0),
  (46, 'postApocalyptic', 5, 0);
  
  DROP TABLE IF EXISTS UserProfileAttributes;
  CREATE TABLE IF NOT EXISTS UserProfileAttributes
  (
  AccountNumber               INT                 NOT NULL,
  Attribute                   VARCHAR (30)        NOT NULL        DEFAULT 'DEFAULT',
  Score                       FLOAT               NOT NULL        DEFAULT 5,
  NumberRatings               INT                 NOT NULL        DEFAULT 0,
  PRIMARY KEY (AccountNumber, Attribute),
  FOREIGN KEY (AccountNumber) REFERENCES Account (AccountNumber) ON DELETE CASCADE
  );
  
  INSERT INTO `UserProfileAttributes` (`AccountNumber`, `Attribute`, `Score`, `NumberRatings`) VALUES
  (13, 'rendered2D', 5, 0),
  (13, 'rendered3D', 5, 0),
  (13, 'played2D', 5, 0),
  (13, 'played3D', 5, 0),
  (13, 'played4D', 5, 0),
  (13, 'alignment', 5, 0),
  (13, 'zombies', 5, 0),
  (13, 'dragons', 5, 0),
  (13, 'elves', 5, 0),
  (13, 'warlocks', 5, 0),
  (13, 'ghosts', 5, 0),
  (13, 'vampires', 5, 0),
  (13, 'werewolves', 5, 0),
  (13, 'mummies', 5, 0),
  (13, 'trolls', 5, 0),
  (13, 'madScientists', 5, 0),
  (13, 'robots', 5, 0),
  (13, 'aliens', 5, 0),
  (13, 'armedForces', 5, 0),
  (13, 'terrorists', 5, 0),
  (13, 'nazis', 5, 0),
  (13, 'ninjas', 5, 0),
  (13, 'samurai', 5, 0),
  (13, 'pirates', 5, 0),
  (13, 'superheroes', 5, 0),
  (13, 'supervillains', 5, 0),
  (13, 'lasers', 5, 0),
  (13, 'laserGuns', 5, 0),
  (13, 'laserSwords', 5, 0),
  (13, 'swords', 5, 0),
  (13, 'guns', 5, 0),
  (13, 'grinding', 5, 0),
  (13, 'cooking', 5, 0),
  (13, 'casual', 5, 0),
  (13, 'miniGames', 5, 0),
  (13, 'collection', 5, 0),
  (13, 'horses', 5, 0),
  (13, 'pets', 5, 0),
  (13, 'userGeneratedContent', 5, 0),
  (13, 'timeSensitive', 5, 0),
  (13, 'scary', 5, 0),
  (13, 'survival', 5, 0),
  (13, 'multiplayer', 5, 0),
  (13, 'mmo', 5, 0),
  (13, 'online', 5, 0),
  (13, 'cooperative', 5, 0),
  (13, 'sandbox', 5, 0),
  (13, 'crafting', 5, 0),
  (14, 'rendered2D', 5, 0),
  (14, 'rendered3D', 5, 0),
  (14, 'played2D', 5, 0),
  (14, 'played3D', 5, 0),
  (14, 'played4D', 5, 0),
  (14, 'alignment', 5, 0),
  (14, 'zombies', 5, 0),
  (14, 'dragons', 5, 0),
  (14, 'elves', 5, 0),
  (14, 'warlocks', 5, 0),
  (14, 'ghosts', 5, 0),
  (14, 'vampires', 5, 0),
  (14, 'werewolves', 5, 0),
  (14, 'mummies', 5, 0),
  (14, 'trolls', 5, 0),
  (14, 'madScientists', 5, 0),
  (14, 'robots', 5, 0),
  (14, 'aliens', 5, 0),
  (14, 'armedForces', 5, 0),
  (14, 'terrorists', 5, 0),
  (14, 'nazis', 5, 0),
  (14, 'ninjas', 5, 0),
  (14, 'samurai', 5, 0),
  (14, 'pirates', 5, 0),
  (14, 'superheroes', 5, 0),
  (14, 'supervillains', 5, 0),
  (14, 'lasers', 5, 0),
  (14, 'laserGuns', 5, 0),
  (14, 'laserSwords', 5, 0),
  (14, 'swords', 5, 0),
  (14, 'guns', 5, 0),
  (14, 'grinding', 5, 0),
  (14, 'cooking', 5, 0),
  (14, 'casual', 5, 0),
  (14, 'miniGames', 5, 0),
  (14, 'collection', 5, 0),
  (14, 'horses', 5, 0),
  (14, 'pets', 5, 0),
  (14, 'userGeneratedContent', 5, 0),
  (14, 'timeSensitive', 5, 0),
  (14, 'scary', 5, 0),
  (14, 'survival', 5, 0),
  (14, 'multiplayer', 5, 0),
  (14, 'mmo', 5, 0),
  (14, 'online', 5, 0),
  (14, 'cooperative', 5, 0),
  (14, 'sandbox', 5, 0),
  (14, 'crafting', 5, 0),
  (15, 'rendered2D', 5, 0),
  (15, 'rendered3D', 5, 0),
  (15, 'played2D', 5, 0),
  (15, 'played3D', 5, 0),
  (15, 'played4D', 5, 0),
  (15, 'alignment', 5, 0),
  (15, 'zombies', 5, 0),
  (15, 'dragons', 5, 0),
  (15, 'elves', 5, 0),
  (15, 'warlocks', 5, 0),
  (15, 'ghosts', 5, 0),
  (15, 'vampires', 5, 0),
  (15, 'werewolves', 5, 0),
  (15, 'mummies', 5, 0),
  (15, 'trolls', 5, 0),
  (15, 'madScientists', 5, 0),
  (15, 'robots', 5, 0),
  (15, 'aliens', 5, 0),
  (15, 'armedForces', 5, 0),
  (15, 'terrorists', 5, 0),
  (15, 'nazis', 5, 0),
  (15, 'ninjas', 5, 0),
  (15, 'samurai', 5, 0),
  (15, 'pirates', 5, 0),
  (15, 'superheroes', 5, 0),
  (15, 'supervillains', 5, 0),
  (15, 'lasers', 5, 0),
  (15, 'laserGuns', 5, 0),
  (15, 'laserSwords', 5, 0),
  (15, 'swords', 5, 0),
  (15, 'guns', 5, 0),
  (15, 'grinding', 5, 0),
  (15, 'cooking', 5, 0),
  (15, 'casual', 5, 0),
  (15, 'miniGames', 5, 0),
  (15, 'collection', 5, 0),
  (15, 'horses', 5, 0),
  (15, 'pets', 5, 0),
  (15, 'userGeneratedContent', 5, 0),
  (15, 'timeSensitive', 5, 0),
  (15, 'scary', 5, 0),
  (15, 'survival', 5, 0),
  (15, 'multiplayer', 5, 0),
  (15, 'mmo', 5, 0),
  (15, 'online', 5, 0),
  (15, 'cooperative', 5, 0),
  (15, 'sandbox', 5, 0),
  (15, 'crafting', 5, 0),
  (40, 'rendered2D', 5, 0),
  (40, 'rendered3D', 5, 0),
  (40, 'played2D', 5, 0),
  (40, 'played3D', 5, 0),
  (40, 'played4D', 5, 0),
  (40, 'alignment', 5, 0),
  (40, 'zombies', 5, 0),
  (40, 'dragons', 5, 0),
  (40, 'elves', 5, 0),
  (40, 'warlocks', 5, 0),
  (40, 'ghosts', 5, 0),
  (40, 'vampires', 5, 0),
  (40, 'werewolves', 5, 0),
  (40, 'mummies', 5, 0),
  (40, 'trolls', 5, 0),
  (40, 'madScientists', 5, 0),
  (40, 'robots', 5, 0),
  (40, 'aliens', 5, 0),
  (40, 'armedForces', 5, 0),
  (40, 'terrorists', 5, 0),
  (40, 'nazis', 5, 0),
  (40, 'ninjas', 5, 0),
  (40, 'samurai', 5, 0),
  (40, 'pirates', 5, 0),
  (40, 'superheroes', 5, 0),
  (40, 'supervillains', 5, 0),
  (40, 'lasers', 5, 0),
  (40, 'laserGuns', 5, 0),
  (40, 'laserSwords', 5, 0),
  (40, 'swords', 5, 0),
  (40, 'guns', 5, 0),
  (40, 'grinding', 5, 0),
  (40, 'cooking', 5, 0),
  (40, 'casual', 5, 0),
  (40, 'miniGames', 5, 0),
  (40, 'collection', 5, 0),
  (40, 'horses', 5, 0),
  (40, 'pets', 5, 0),
  (40, 'userGeneratedContent', 5, 0),
  (40, 'timeSensitive', 5, 0),
  (40, 'scary', 5, 0),
  (40, 'survival', 5, 0),
  (40, 'multiplayer', 5, 0),
  (40, 'mmo', 5, 0),
  (40, 'online', 5, 0),
  (40, 'cooperative', 5, 0),
  (40, 'sandbox', 5, 0),
  (40, 'crafting', 5, 0),
  (41, 'rendered2D', 5, 0),
  (41, 'rendered3D', 5, 0),
  (41, 'played2D', 5, 0),
  (41, 'played3D', 5, 0),
  (41, 'played4D', 5, 0),
  (41, 'alignment', 5, 0),
  (41, 'zombies', 5, 0),
  (41, 'dragons', 5, 0),
  (41, 'elves', 5, 0),
  (41, 'warlocks', 5, 0),
  (41, 'ghosts', 5, 0),
  (41, 'vampires', 5, 0),
  (41, 'werewolves', 5, 0),
  (41, 'mummies', 5, 0),
  (41, 'trolls', 5, 0),
  (41, 'madScientists', 5, 0),
  (41, 'robots', 5, 0),
  (41, 'aliens', 5, 0),
  (41, 'armedForces', 5, 0),
  (41, 'terrorists', 5, 0),
  (41, 'nazis', 5, 0),
  (41, 'ninjas', 5, 0),
  (41, 'samurai', 5, 0),
  (41, 'pirates', 5, 0),
  (41, 'superheroes', 5, 0),
  (41, 'supervillains', 5, 0),
  (41, 'lasers', 5, 0),
  (41, 'laserGuns', 5, 0),
  (41, 'laserSwords', 5, 0),
  (41, 'swords', 5, 0),
  (41, 'guns', 5, 0),
  (41, 'grinding', 5, 0),
  (41, 'cooking', 5, 0),
  (41, 'casual', 5, 0),
  (41, 'miniGames', 5, 0),
  (41, 'collection', 5, 0),
  (41, 'horses', 5, 0),
  (41, 'pets', 5, 0),
  (41, 'userGeneratedContent', 5, 0),
  (41, 'timeSensitive', 5, 0),
  (41, 'scary', 5, 0),
  (41, 'survival', 5, 0),
  (41, 'multiplayer', 5, 0),
  (41, 'mmo', 5, 0),
  (41, 'online', 5, 0),
  (41, 'cooperative', 5, 0),
  (41, 'sandbox', 5, 0),
  (41, 'crafting', 5, 0),
  (42, 'rendered2D', 5, 0),
  (42, 'rendered3D', 5, 0),
  (42, 'played2D', 5, 0),
  (42, 'played3D', 5, 0),
  (42, 'played4D', 5, 0),
  (42, 'alignment', 5, 0),
  (42, 'zombies', 5, 0),
  (42, 'dragons', 5, 0),
  (42, 'elves', 5, 0),
  (42, 'warlocks', 5, 0),
  (42, 'ghosts', 5, 0),
  (42, 'vampires', 5, 0),
  (42, 'werewolves', 5, 0),
  (42, 'mummies', 5, 0),
  (42, 'trolls', 5, 0),
  (42, 'madScientists', 5, 0),
  (42, 'robots', 5, 0),
  (42, 'aliens', 5, 0),
  (42, 'armedForces', 5, 0),
  (42, 'terrorists', 5, 0),
  (42, 'nazis', 5, 0),
  (42, 'ninjas', 5, 0),
  (42, 'samurai', 5, 0),
  (42, 'pirates', 5, 0),
  (42, 'superheroes', 5, 0),
  (42, 'supervillains', 5, 0),
  (42, 'lasers', 5, 0),
  (42, 'laserGuns', 5, 0),
  (42, 'laserSwords', 5, 0),
  (42, 'swords', 5, 0),
  (42, 'guns', 5, 0),
  (42, 'grinding', 5, 0),
  (42, 'cooking', 5, 0),
  (42, 'casual', 5, 0),
  (42, 'miniGames', 5, 0),
  (42, 'collection', 5, 0),
  (42, 'horses', 5, 0),
  (42, 'pets', 5, 0),
  (42, 'userGeneratedContent', 5, 0),
  (42, 'timeSensitive', 5, 0),
  (42, 'scary', 5, 0),
  (42, 'survival', 5, 0),
  (42, 'multiplayer', 5, 0),
  (42, 'mmo', 5, 0),
  (42, 'online', 5, 0),
  (42, 'cooperative', 5, 0),
  (42, 'sandbox', 5, 0),
  (42, 'crafting', 5, 0),
  (43, 'rendered2D', 5, 0),
  (43, 'rendered3D', 5, 0),
  (43, 'played2D', 5, 0),
  (43, 'played3D', 5, 0),
  (43, 'played4D', 5, 0),
  (43, 'alignment', 5, 0),
  (43, 'zombies', 5, 0),
  (43, 'dragons', 5, 0),
  (43, 'elves', 5, 0),
  (43, 'warlocks', 5, 0),
  (43, 'ghosts', 5, 0),
  (43, 'vampires', 5, 0),
  (43, 'werewolves', 5, 0),
  (43, 'mummies', 5, 0),
  (43, 'trolls', 5, 0),
  (43, 'madScientists', 5, 0),
  (43, 'robots', 5, 0),
  (43, 'aliens', 5, 0),
  (43, 'armedForces', 5, 0),
  (43, 'terrorists', 5, 0),
  (43, 'nazis', 5, 0),
  (43, 'ninjas', 5, 0),
  (43, 'samurai', 5, 0),
  (43, 'pirates', 5, 0),
  (43, 'superheroes', 5, 0),
  (43, 'supervillains', 5, 0),
  (43, 'lasers', 5, 0),
  (43, 'laserGuns', 5, 0),
  (43, 'laserSwords', 5, 0),
  (43, 'swords', 5, 0),
  (43, 'guns', 5, 0),
  (43, 'grinding', 5, 0),
  (43, 'cooking', 5, 0),
  (43, 'casual', 5, 0),
  (43, 'miniGames', 5, 0),
  (43, 'collection', 5, 0),
  (43, 'horses', 5, 0),
  (43, 'pets', 5, 0),
  (43, 'userGeneratedContent', 5, 0),
  (43, 'timeSensitive', 5, 0),
  (43, 'scary', 5, 0),
  (43, 'survival', 5, 0),
  (43, 'multiplayer', 5, 0),
  (43, 'mmo', 5, 0),
  (43, 'online', 5, 0),
  (43, 'cooperative', 5, 0),
  (43, 'sandbox', 5, 0),
  (43, 'crafting', 5, 0),
  (44, 'rendered2D', 5, 0),
  (44, 'rendered3D', 5, 0),
  (44, 'played2D', 5, 0),
  (44, 'played3D', 5, 0),
  (44, 'played4D', 5, 0),
  (44, 'alignment', 5, 0),
  (44, 'zombies', 5, 0),
  (44, 'dragons', 5, 0),
  (44, 'elves', 5, 0),
  (44, 'warlocks', 5, 0),
  (44, 'ghosts', 5, 0),
  (44, 'vampires', 5, 0),
  (44, 'werewolves', 5, 0),
  (44, 'mummies', 5, 0),
  (44, 'trolls', 5, 0),
  (44, 'madScientists', 5, 0),
  (44, 'robots', 5, 0),
  (44, 'aliens', 5, 0),
  (44, 'armedForces', 5, 0),
  (44, 'terrorists', 5, 0),
  (44, 'nazis', 5, 0),
  (44, 'ninjas', 5, 0),
  (44, 'samurai', 5, 0),
  (44, 'pirates', 5, 0),
  (44, 'superheroes', 5, 0),
  (44, 'supervillains', 5, 0),
  (44, 'lasers', 5, 0),
  (44, 'laserGuns', 5, 0),
  (44, 'laserSwords', 5, 0),
  (44, 'swords', 5, 0),
  (44, 'guns', 5, 0),
  (44, 'grinding', 5, 0),
  (44, 'cooking', 5, 0),
  (44, 'casual', 5, 0),
  (44, 'miniGames', 5, 0),
  (44, 'collection', 5, 0),
  (44, 'horses', 5, 0),
  (44, 'pets', 5, 0),
  (44, 'userGeneratedContent', 5, 0),
  (44, 'timeSensitive', 5, 0),
  (44, 'scary', 5, 0),
  (44, 'survival', 5, 0),
  (44, 'multiplayer', 5, 0),
  (44, 'mmo', 5, 0),
  (44, 'online', 5, 0),
  (44, 'cooperative', 5, 0),
  (44, 'sandbox', 5, 0),
  (44, 'crafting', 5, 0),
  (45, 'rendered2D', 5, 0),
  (45, 'rendered3D', 5, 0),
  (45, 'played2D', 5, 0),
  (45, 'played3D', 5, 0),
  (45, 'played4D', 5, 0),
  (45, 'alignment', 5, 0),
  (45, 'zombies', 5, 0),
  (45, 'dragons', 5, 0),
  (45, 'elves', 5, 0),
  (45, 'warlocks', 5, 0),
  (45, 'ghosts', 5, 0),
  (45, 'vampires', 5, 0),
  (45, 'werewolves', 5, 0),
  (45, 'mummies', 5, 0),
  (45, 'trolls', 5, 0),
  (45, 'madScientists', 5, 0),
  (45, 'robots', 5, 0),
  (45, 'aliens', 5, 0),
  (45, 'armedForces', 5, 0),
  (45, 'terrorists', 5, 0),
  (45, 'nazis', 5, 0),
  (45, 'ninjas', 5, 0),
  (45, 'samurai', 5, 0),
  (45, 'pirates', 5, 0),
  (45, 'superheroes', 5, 0),
  (45, 'supervillains', 5, 0),
  (45, 'lasers', 5, 0),
  (45, 'laserGuns', 5, 0),
  (45, 'laserSwords', 5, 0),
  (45, 'swords', 5, 0),
  (45, 'guns', 5, 0),
  (45, 'grinding', 5, 0),
  (45, 'cooking', 5, 0),
  (45, 'casual', 5, 0),
  (45, 'miniGames', 5, 0),
  (45, 'collection', 5, 0),
  (45, 'horses', 5, 0),
  (45, 'pets', 5, 0),
  (45, 'userGeneratedContent', 5, 0),
  (45, 'timeSensitive', 5, 0),
  (45, 'scary', 5, 0),
  (45, 'survival', 5, 0),
  (45, 'multiplayer', 5, 0),
  (45, 'mmo', 5, 0),
  (45, 'online', 5, 0),
  (45, 'cooperative', 5, 0),
  (45, 'sandbox', 5, 0),
  (45, 'crafting', 5, 0),
  (46, 'rendered2D', 5, 0),
  (46, 'rendered3D', 5, 0),
  (46, 'played2D', 5, 0),
  (46, 'played3D', 5, 0),
  (46, 'played4D', 5, 0),
  (46, 'alignment', 5, 0),
  (46, 'zombies', 5, 0),
  (46, 'dragons', 5, 0),
  (46, 'elves', 5, 0),
  (46, 'warlocks', 5, 0),
  (46, 'ghosts', 5, 0),
  (46, 'vampires', 5, 0),
  (46, 'werewolves', 5, 0),
  (46, 'mummies', 5, 0),
  (46, 'trolls', 5, 0),
  (46, 'madScientists', 5, 0),
  (46, 'robots', 5, 0),
  (46, 'aliens', 5, 0),
  (46, 'armedForces', 5, 0),
  (46, 'terrorists', 5, 0),
  (46, 'nazis', 5, 0),
  (46, 'ninjas', 5, 0),
  (46, 'samurai', 5, 0),
  (46, 'pirates', 5, 0),
  (46, 'superheroes', 5, 0),
  (46, 'supervillains', 5, 0),
  (46, 'lasers', 5, 0),
  (46, 'laserGuns', 5, 0),
  (46, 'laserSwords', 5, 0),
  (46, 'swords', 5, 0),
  (46, 'guns', 5, 0),
  (46, 'grinding', 5, 0),
  (46, 'cooking', 5, 0),
  (46, 'casual', 5, 0),
  (46, 'miniGames', 5, 0),
  (46, 'collection', 5, 0),
  (46, 'horses', 5, 0),
  (46, 'pets', 5, 0),
  (46, 'userGeneratedContent', 5, 0),
  (46, 'timeSensitive', 5, 0),
  (46, 'scary', 5, 0),
  (46, 'survival', 5, 0),
  (46, 'multiplayer', 5, 0),
  (46, 'mmo', 5, 0),
  (46, 'online', 5, 0),
  (46, 'cooperative', 5, 0),
  (46, 'sandbox', 5, 0),
  (46, 'crafting', 5, 0);
  
  DROP TABLE IF EXISTS GameList;
  CREATE TABLE IF NOT EXISTS GameList
  (
  GameURI                 VARCHAR(255)        NOT NULL        UNIQUE,
  PRIMARY KEY (GameURI)
  );
  
  INSERT INTO `GameList`
  (`GameURI`)
  VALUES
  ('theLegendOfZelda'),
  ('gradius3'),
  ('goldenSunTheLostAge'),
  ('bitTripBeat'),
  ('bitTripCore'),
  ('bitTripVoid'),
  ('bitTripRunner'),
  ('bitTripFate'),
  ('sonicAdventure2Battle'),
  ('picross3D'),
  ('starFox64'),
  ('metroidPrime'),
  ('starcraft'),
  ('massEffect'),
  ('callOfDuty4ModernWarfare'),
  ('dragonAgeOrigins'),
  ('kingdomHearts'),
  ('finalFantasyX'),
  ('advanceWars'),
  ('fireEmblemPathOfRadiance'),
  ('assassinsCreed2'),
  ('theLegendOfZeldaOcarinaOfTime'),
  ('superMetroid'),
  ('castlevaniaSymphonyOfTheNight'),
  ('shadowComplex'),
  ('lifeAndDeath'),
  ('dejaVu'),
  ('themeHospital'),
  ('minecraft'),
  ('retroGameChallenge'),
  ('traumaCenter'),
  ('phoenixWrightAceAttorney'),
  ('granTurismo4'),
  ('guildWars'),
  ('leagueofLegends'),
  ('ffxi'),
  ('dukeNukem3D'),
  ('redFaction'),
  ('teamFortress2'),
  ('diablo2'),
  ('demonsSoul'),
  ('unrealTournament3'),
  ('untoldLegendsDarkKingdom'),
  ('theOrangeBox'),
  ('lair');
  
  DROP TABLE IF EXISTS GameGenres;
  CREATE TABLE IF NOT EXISTS GameGenres
  (
  GameURI             VARCHAR(255)        NOT NULL,
  Genre               VARCHAR(30)         NOT NULL        DEFAULT 'DEFAULT',
  PRIMARY KEY (GameURI, Genre),
  FOREIGN KEY (GameURI) REFERENCES GameList (GameURI) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  INSERT INTO `GameGenres` (`GameURI`, `Genre`) VALUES
  ('theLegendOfZelda', 'action'),
  ('theLegendOfZelda', 'adventure'),
  ('gradius3', 'shmup'),
  ('goldenSunTheLostAge', 'jrpg'),
  ('bitTripBeat', 'rhythm'),
  ('bitTripBeat', 'action'),
  ('bitTripCore', 'rhythm'),
  ('bitTripVoid', 'rhythm'),
  ('bitTripVoid', 'shmup'),
  ('bitTripRunner', 'rhythm'),
  ('bitTripRunner', 'platformer'),
  ('bitTripFate', 'railShoot'),
  ('bitTripFate', 'rhythm'),
  ('sonicAdventure2Battle', 'action'),
  ('sonicAdventure2Battle', 'tps'),
  ('sonicAdventure2Battle', 'platformer'),
  ('sonicAdventure2Battle', 'driving'),
  ('picross3D', 'puzzle'),
  ('starFox64', 'railShoot'),
  ('metroidPrime', 'fps'),
  ('metroidPrime', 'platformer'),
  ('starcraft', 'rts'),
  ('massEffect', 'shooter'),
  ('massEffect', 'wrpg'),
  ('callOfDuty4ModernWarfare', 'fps'),
  ('dragonAgeOrigins', 'wrpg'),
  ('kingdomHearts', 'jrpg'),
  ('finalFantasyX', 'jrpg'),
  ('advanceWars', 'turnBased'),
  ('fireEmblemPathOfRadiance', 'turnBased'),
  ('fireEmblemPathOfRadiance', 'rpg'),
  ('assassinsCreed2', 'action'),
  ('assassinsCreed2', 'adventure'),
  ('theLegendOfZeldaOcarinaOfTime', 'action'),
  ('theLegendOfZeldaOcarinaOfTime', 'adventure'),
  ('superMetroid', 'action'),
  ('superMetroid', 'adventure'),
  ('superMetroid', 'platformer'),
  ('castlevaniaSymphonyOfTheNight', 'action'),
  ('castlevaniaSymphonyOfTheNight', 'adventure'),
  ('castlevaniaSymphonyOfTheNight', 'platformer'),
  ('shadowComplex', 'action'),
  ('shadowComplex', 'adventure'),
  ('shadowComplex', 'platformer'),
  ('lifeAndDeath', 'simulation'),
  ('dejaVu', 'adventure'),
  ('dejaVu', 'puzzle'),
  ('themeHospital', 'simulation'),
  ('minecraft', 'action'),
  ('minecraft', 'adventure'),
  ('retroGameChallenge', 'action'),
  ('retroGameChallenge', 'adventure'),
  ('retroGameChallenge', 'rpg'),
  ('retroGameChallenge', 'sports'),
  ('retroGameChallenge', 'shooter'),
  ('retroGameChallenge', 'platformer'),
  ('traumaCenter', 'simulation'),
  ('phoenixWrightAceAttorney', 'adventure'),
  ('granTurismo4', 'driving'),
  ('granTurismo4', 'simulation'),
  ('guildWars', 'adventure'),
  ('guildWars', 'rpg'),
  ('guildWars', 'rts'),
  ('leagueofLegends', 'action'),
  ('leagueofLegends', 'rpg'),
  ('leagueofLegends', 'rts'),
  ('ffxi', 'action'),
  ('ffxi', 'rpg'),
  ('dukeNukem3D', 'action'),
  ('dukeNukem3D', 'fps'),
  ('redFaction', 'action'),
  ('redFaction', 'fps'),
  ('teamFortress2', 'fps'),
  ('diablo2', 'action'),
  ('diablo2', 'rpg'),
  ('demonsSoul', 'action'),
  ('demonsSoul', 'rpg'),
  ('unrealTournament3', 'fps'),
  ('untoldLegendsDarkKingdom', 'rpg'),
  ('theOrangeBox', 'fps'),
  ('lair', 'rpg'),
  ('lair', 'action');
  
  DROP TABLE IF EXISTS GameTheatricalGenres;
  CREATE TABLE IF NOT EXISTS GameTheatricalGenres
  (
  GameURI             VARCHAR(255)        NOT NULL,
  Genre               VARCHAR(30)         NOT NULL        DEFAULT 'DEFAULT',
  PRIMARY KEY (GameURI, Genre),
  FOREIGN KEY (GameURI) REFERENCES GameList (GameURI) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  INSERT INTO `GameTheatricalGenres` (`GameURI`, `Genre`) VALUES
  ('theLegendOfZelda', 'fantasy'),
  ('gradius3', 'sciFi'),
  ('goldenSunTheLostAge', 'fantasy'),
  ('bitTripBeat', 'sciFi'),
  ('bitTripCore', 'sciFi'),
  ('bitTripVoid', 'sciFi'),
  ('bitTripRunner', 'sciFi'),
  ('bitTripFate', 'sciFi'),
  ('sonicAdventure2Battle', 'sciFi'),
  ('sonicAdventure2Battle', 'fantasy'),
  ('picross3D', 'sciFi'),
  ('starFox64', 'sciFi'),
  ('metroidPrime', 'sciFi'),
  ('starcraft', 'sciFi'),
  ('massEffect', 'sciFi'),
  ('callOfDuty4ModernWarfare', 'action'),
  ('dragonAgeOrigins', 'fantasy'),
  ('kingdomHearts', 'fantasy'),
  ('finalFantasyX', 'fantasy'),
  ('finalFantasyX', 'sciFi'),
  ('advanceWars', 'action'),
  ('fireEmblemPathOfRadiance', 'fantasy'),
  ('assassinsCreed2', 'sciFi'),
  ('theLegendOfZeldaOcarinaOfTime', 'fantasy'),
  ('superMetroid', 'sciFi'),
  ('castlevaniaSymphonyOfTheNight', 'fantasy'),
  ('shadowComplex', 'war'),
  ('lifeAndDeath', 'fantasy'),
  ('dejaVu', 'mystery'),
  ('themeHospital', 'fantasy'),
  ('minecraft', 'fantasy'),
  ('retroGameChallenge', 'sciFi'),
  ('retroGameChallenge', 'fantasy'),
  ('traumaCenter', 'fantasy'),
  ('phoenixWrightAceAttorney', 'fantasy'),
  ('granTurismo4', 'fantasy'),
  ('guildWars', 'fantasy'),
  ('leagueofLegends', 'fantasy'),
  ('ffxi', 'fantasy'),
  ('dukeNukem3D', 'postApocalyptic'),
  ('redFaction', 'sciFi'),
  ('teamFortress2', 'fantasy'),
  ('diablo2', 'fantasy'),
  ('demonsSoul', 'fantasy'),
  ('unrealTournament3', 'fantasy'),
  ('untoldLegendsDarkKingdom', 'fantasy'),
  ('theOrangeBox', 'fantasy'),
  ('lair', 'fantasy');
  
  DROP TABLE IF EXISTS GameAttributes;
  CREATE TABLE IF NOT EXISTS GameAttributes
  (
  GameURI             VARCHAR(255)        NOT NULL,
  Attribute           VARCHAR(30)         NOT NULL        DEFAULT 'DEFAULT',
  PRIMARY KEY (GameURI, Attribute),
  FOREIGN KEY (GameURI) REFERENCES GameList (GameURI) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  INSERT INTO `GameAttributes` (`GameURI`, `Attribute`) VALUES
  ('theLegendOfZelda', 'played2D'),
  ('theLegendOfZelda', 'rendered2D'),
  ('theLegendOfZelda', 'ghosts'),
  ('theLegendOfZelda', 'elves'),
  ('theLegendOfZelda', 'warlocks'),
  ('theLegendOfZelda', 'link'),
  ('theLegendOfZelda', 'swords'),
  ('theLegendOfZelda', 'collection'),
  ('gradius3', 'played2D'),
  ('gradius3', 'rendered2D'),
  ('gradius3', 'robots'),
  ('gradius3', 'vicViper'),
  ('gradius3', 'lasers'),
  ('goldenSunTheLostAge', 'played2D'),
  ('goldenSunTheLostAge', 'rendered2D'),
  ('goldenSunTheLostAge', 'crafting'),
  ('goldenSunTheLostAge', 'multiplayer'),
  ('goldenSunTheLostAge', 'zombies'),
  ('goldenSunTheLostAge', 'dragons'),
  ('goldenSunTheLostAge', 'ghosts'),
  ('goldenSunTheLostAge', 'vampires'),
  ('goldenSunTheLostAge', 'werewolves'),
  ('goldenSunTheLostAge', 'ninjas'),
  ('goldenSunTheLostAge', 'samurai'),
  ('goldenSunTheLostAge', 'pirates'),
  ('goldenSunTheLostAge', 'trolls'),
  ('goldenSunTheLostAge', 'elves'),
  ('goldenSunTheLostAge', 'warlocks'),
  ('goldenSunTheLostAge', 'grinding'),
  ('goldenSunTheLostAge', 'swords'),
  ('goldenSunTheLostAge', 'collection'),
  ('bitTripBeat', 'played2D'),
  ('bitTripBeat', 'rendered2D'),
  ('bitTripBeat', 'multiplayer'),
  ('bitTripBeat', 'cooperative'),
  ('bitTripBeat', 'lasers'),
  ('bitTripCore', 'played2D'),
  ('bitTripCore', 'rendered2D'),
  ('bitTripCore', 'multiplayer'),
  ('bitTripCore', 'cooperative'),
  ('bitTripCore', 'lasers'),
  ('bitTripVoid', 'played2D'),
  ('bitTripVoid', 'rendered2D'),
  ('bitTripVoid', 'multiplayer'),
  ('bitTripVoid', 'cooperative'),
  ('bitTripRunner', 'played2D'),
  ('bitTripRunner', 'rendered2D'),
  ('bitTripRunner', 'robots'),
  ('bitTripRunner', 'collection'),
  ('bitTripFate', 'rendered2D'),
  ('bitTripFate', 'played2D'),
  ('bitTripFate', 'robots'),
  ('bitTripFate', 'collection'),
  ('bitTripFate', 'lasers'),
  ('sonicAdventure2Battle', 'played3D'),
  ('sonicAdventure2Battle', 'rendered3D'),
  ('sonicAdventure2Battle', 'robots'),
  ('sonicAdventure2Battle', 'multiplayer'),
  ('sonicAdventure2Battle', 'madScientist'),
  ('sonicAdventure2Battle', 'aliens'),
  ('sonicAdventure2Battle', 'timeSensitive'),
  ('sonicAdventure2Battle', 'sonic'),
  ('sonicAdventure2Battle', 'lasers'),
  ('sonicAdventure2Battle', 'miniGames'),
  ('sonicAdventure2Battle', 'collection'),
  ('sonicAdventure2Battle', 'pets'),
  ('picross3D', 'played3D'),
  ('picross3D', 'rendered3D'),
  ('picross3D', 'timeSensitive'),
  ('picross3D', 'collection'),
  ('picross3D', 'userGeneratedContent'),
  ('picross3D', 'casual'),
  ('starFox64', 'played3D'),
  ('starFox64', 'rendered3D'),
  ('starFox64', 'multiplayer'),
  ('starFox64', 'terrorist'),
  ('starFox64', 'robots'),
  ('starFox64', 'aliens'),
  ('starFox64', 'foxMcCloud'),
  ('starFox64', 'lasers'),
  ('metroidPrime', 'played3D'),
  ('metroidPrime', 'rendered3D'),
  ('metroidPrime', 'aliens'),
  ('metroidPrime', 'pirates'),
  ('metroidPrime', 'samus'),
  ('metroidPrime', 'lasers'),
  ('metroidPrime', 'collection'),
  ('starcraft', 'played2D'),
  ('starcraft', 'rendered2D'),
  ('starcraft', 'aliens'),
  ('starcraft', 'lasers'),
  ('starcraft', 'robots'),
  ('starcraft', 'online'),
  ('starcraft', 'multiplayer'),
  ('massEffect', 'played3D'),
  ('massEffect', 'rendered3D'),
  ('massEffect', 'aliens'),
  ('massEffect', 'robots'),
  ('massEffect', 'alignment'),
  ('massEffect', 'lasers'),
  ('massEffect', 'guns'),
  ('callOfDuty4ModernWarfare', 'played3D'),
  ('callOfDuty4ModernWarfare', 'rendered3D'),
  ('callOfDuty4ModernWarfare', 'online'),
  ('callOfDuty4ModernWarfare', 'multiplayer'),
  ('callOfDuty4ModernWarfare', 'guns'),
  ('dragonAgeOrigins', 'played3D'),
  ('dragonAgeOrigins', 'rendered3D'),
  ('dragonAgeOrigins', 'swords'),
  ('dragonAgeOrigins', 'elves'),
  ('dragonAgeOrigins', 'trolls'),
  ('dragonAgeOrigins', 'warlocks'),
  ('dragonAgeOrigins', 'dragons'),
  ('dragonAgeOrigins', 'alignment'),
  ('kingdomHearts', 'played3D'),
  ('kingdomHearts', 'rendered3D'),
  ('kingdomHearts', 'collection'),
  ('finalFantasyX', 'played3D'),
  ('finalFantasyX', 'rendered3D'),
  ('finalFantasyX', 'swords'),
  ('finalFantasyX', 'collection'),
  ('advanceWars', 'played2D'),
  ('advanceWars', 'rendered2D'),
  ('advanceWars', 'multiplayer'),
  ('fireEmblemPathOfRadiance', 'played3D'),
  ('fireEmblemPathOfRadiance', 'rendered3D'),
  ('fireEmblemPathOfRadiance', 'collection'),
  ('fireEmblemPathOfRadiance', 'swords'),
  ('assassinsCreed2', 'played3D'),
  ('assassinsCreed2', 'rendered3D'),
  ('assassinsCreed2', 'collection'),
  ('assassinsCreed2', 'swords'),
  ('theLegendOfZeldaOcarinaOfTime', 'played3D'),
  ('theLegendOfZeldaOcarinaOfTime', 'rendered3D'),
  ('theLegendOfZeldaOcarinaOfTime', 'swords'),
  ('theLegendOfZeldaOcarinaOfTime', 'elves'),
  ('theLegendOfZeldaOcarinaOfTime', 'warlocks'),
  ('theLegendOfZeldaOcarinaOfTime', 'ghosts'),
  ('theLegendOfZeldaOcarinaOfTime', 'horses'),
  ('theLegendOfZeldaOcarinaOfTime', 'collection'),
  ('theLegendOfZeldaOcarinaOfTime', 'miniGames'),
  ('superMetroid', 'played2D'),
  ('superMetroid', 'rendered2D'),
  ('superMetroid', 'robots'),
  ('superMetroid', 'aliens'),
  ('superMetroid', 'samus'),
  ('superMetroid', 'laserGuns'),
  ('superMetroid', 'collection'),
  ('superMetroid', 'timeSensitive'),
  ('castlevaniaSymphonyOfTheNight', 'played2D'),
  ('castlevaniaSymphonyOfTheNight', 'rendered2D'),
  ('castlevaniaSymphonyOfTheNight', 'zombies'),
  ('castlevaniaSymphonyOfTheNight', 'ghosts'),
  ('castlevaniaSymphonyOfTheNight', 'vampires'),
  ('castlevaniaSymphonyOfTheNight', 'mummies'),
  ('castlevaniaSymphonyOfTheNight', 'werewolves'),
  ('castlevaniaSymphonyOfTheNight', 'swords'),
  ('castlevaniaSymphonyOfTheNight', 'collection'),
  ('shadowComplex', 'played3D'),
  ('shadowComplex', 'rendered3D'),
  ('shadowComplex', 'robots'),
  ('shadowComplex', 'terrorist'),
  ('shadowComplex', 'laserGuns'),
  ('shadowComplex', 'guns'),
  ('shadowComplex', 'collection'),
  ('lifeAndDeath', 'played2D'),
  ('lifeAndDeath', 'rendered2D'),
  ('lifeAndDeath', 'timeSensitive'),
  ('dejaVu', 'played2D'),
  ('dejaVu', 'rendered2D'),
  ('dejaVu', 'guns'),
  ('dejaVu', 'collection'),
  ('themeHospital', 'played2D'),
  ('themeHospital', 'rendered2D'),
  ('themeHospital', 'timeSensitive'),
  ('themeHospital', 'mulit'),
  ('minecraft', 'played3D'),
  ('minecraft', 'rendered3D'),
  ('minecraft', 'zombies'),
  ('minecraft', 'ghosts'),
  ('minecraft', 'swords'),
  ('minecraft', 'cooking'),
  ('minecraft', 'timeSensitive'),
  ('minecraft', 'scary'),
  ('minecraft', 'survival'),
  ('minecraft', 'sandboxity'),
  ('minecraft', 'crafting'),
  ('retroGameChallenge', 'played2D'),
  ('retroGameChallenge', 'rendered2D'),
  ('retroGameChallenge', 'warlocks'),
  ('traumaCenter', 'played3D'),
  ('traumaCenter', 'rendered3D'),
  ('traumaCenter', 'madScientist'),
  ('phoenixWrightAceAttorney', 'played2D'),
  ('phoenixWrightAceAttorney', 'rendered2D'),
  ('phoenixWrightAceAttorney', 'terrorist'),
  ('phoenixWrightAceAttorney', 'collection'),
  ('phoenixWrightAceAttorney', 'guns'),
  ('granTurismo4', 'timeSensitive'),
  ('granTurismo4', 'grinding'),
  ('guildWars', 'mmo'),
  ('guildWars', 'grinding'),
  ('guildWars', 'swords'),
  ('guildWars', 'trolls'),
  ('guildWars', 'dragons'),
  ('guildWars', 'cooperative'),
  ('guildWars', 'online'),
  ('guildWars', 'multiplayer'),
  ('guildWars', 'crafting'),
  ('leagueofLegends', 'mmo'),
  ('leagueofLegends', 'swords'),
  ('leagueofLegends', 'dragons'),
  ('leagueofLegends', 'cooperative'),
  ('leagueofLegends', 'online'),
  ('leagueofLegends', 'multiplayer'),
  ('leagueofLegends', 'crafting'),
  ('ffxi', 'mm'),
  ('ffxi', 'swords'),
  ('ffxi', 'dragons'),
  ('ffxi', 'ghosts'),
  ('ffxi', 'zombies'),
  ('ffxi', 'cooperative'),
  ('ffxi', 'online'),
  ('ffxi', 'multiplayer'),
  ('ffxi', 'crafting'),
  ('dukeNukem3D', 'aliens'),
  ('dukeNukem3D', 'guns'),
  ('dukeNukem3D', 'laserGuns'),
  ('redFaction', 'aliens'),
  ('redFaction', 'guns'),
  ('redFaction', 'laserGuns'),
  ('teamFortress2', 'guns'),
  ('teamFortress2', 'online'),
  ('teamFortress2', 'multiplayer'),
  ('teamFortress2', 'casual'),
  ('teamFortress2', 'crafting'),
  ('diablo2', 'online'),
  ('diablo2', 'multiplayer'),
  ('diablo2', 'crafting'),
  ('diablo2', 'ghosts'),
  ('diablo2', 'zombies'),
  ('diablo2', 'swords'),
  ('diablo2', 'grinding'),
  ('demonsSoul', 'played3D'),
  ('demonsSoul', 'rendered3D'),
  ('demonsSoul', 'dragons'),
  ('demonsSoul', 'swords'),
  ('demonsSoul', 'online'),
  ('demonsSoul', 'multiplayer'),
  ('demonsSoul', 'cooperative'),
  ('demonsSoul', 'crafting'),
  ('demonsSoul', 'grinding'),
  ('demonsSoul', 'ninjas'),
  ('unrealTournament3', 'played3D'),
  ('unrealTournament3', 'rendered3D'),
  ('unrealTournament3', 'aliens'),
  ('unrealTournament3', 'robots'),
  ('unrealTournament3', 'guns'),
  ('unrealTournament3', 'multiplayer'),
  ('unrealTournament3', 'online'),
  ('unrealTournament3', 'cooperative'),
  ('untoldLegendsDarkKingdom', 'played3D'),
  ('untoldLegendsDarkKingdom', 'rendered3D'),
  ('untoldLegendsDarkKingdom', 'dragons'),
  ('untoldLegendsDarkKingdom', 'elves'),
  ('untoldLegendsDarkKingdom', 'trolls'),
  ('untoldLegendsDarkKingdom', 'swords'),
  ('untoldLegendsDarkKingdom', 'collection'),
  ('untoldLegendsDarkKingdom', 'multiplayer'),
  ('untoldLegendsDarkKingdom', 'cooperative'),
  ('theOrangeBox', 'played3D'),
  ('theOrangeBox', 'rendered3D'),
  ('theOrangeBox', 'guns'),
  ('theOrangeBox', 'multiplayer'),
  ('theOrangeBox', 'cooperative'),
  ('lair', 'played3D'),
  ('lair', 'rendered3D'),
  ('lair', 'dragons'),
  ('lair', 'swords'),
  ('lair', 'timeSensitive');
  
  DROP TABLE IF EXISTS GamePlatforms;
  CREATE TABLE IF NOT EXISTS GamePlatforms
  (
  GameURI             VARCHAR(255)        NOT NULL,
  Platform            VARCHAR(30)         NOT NULL        DEFAULT 'DEFAULT',
  PRIMARY KEY (GameURI, Platform),
  FOREIGN KEY (GameURI) REFERENCES GameList (GameURI) ON DELETE CASCADE ON UPDATE CASCADE
  );
  
  INSERT INTO `GamePlatforms` (`GameURI`, `Platform`) VALUES
  ('theLegendOfZelda', 'nes'),
  ('theLegendOfZelda', 'gba'),
  ('theLegendOfZelda', 'wiiVC'),
  ('gradius3', 'snes'),
  ('gradius3', 'arc'),
  ('gradius3', 'wiiVC'),
  ('gradius3', 'ps2'),
  ('goldenSunTheLostAge', 'gba'),
  ('bitTripBeat', 'wiiWare'),
  ('bitTripBeat', 'iOS'),
  ('bitTripBeat', 'pcdl'),
  ('bitTripCore', 'wiiWare'),
  ('bitTripVoid', 'wiiWare'),
  ('bitTripRunner', 'wiiWare'),
  ('bitTripFate', 'wiiWare'),
  ('sonicAdventure2Battle', 'gcn'),
  ('picross3D', 'nds'),
  ('starFox64', 'n64'),
  ('metroidPrime', 'gcn'),
  ('starcraft', 'pc'),
  ('massEffect', 'pc'),
  ('massEffect', 'xbox360'),
  ('callOfDuty4ModernWarfare', 'pc'),
  ('callOfDuty4ModernWarfare', 'xbox360'),
  ('callOfDuty4ModernWarfare', 'ps3'),
  ('dragonAgeOrigins', 'pc'),
  ('dragonAgeOrigins', 'xbox360'),
  ('dragonAgeOrigins', 'ps3'),
  ('kingdomHearts', 'ps2'),
  ('finalFantasyX', 'ps2'),
  ('advanceWars', 'gba'),
  ('fireEmblemPathOfRadiance', 'gcn'),
  ('assassinsCreed2', 'pc'),
  ('assassinsCreed2', 'xbox360'),
  ('assassinsCreed2', 'ps3'),
  ('theLegendOfZeldaOcarinaOfTime', 'n64'),
  ('theLegendOfZeldaOcarinaOfTime', 'gcn'),
  ('theLegendOfZeldaOcarinaOfTime', '3DS'),
  ('theLegendOfZeldaOcarinaOfTime', 'wiiVC'),
  ('superMetroid', 'snes'),
  ('superMetroid', 'wiiVC'),
  ('castlevaniaSymphonyOfTheNight', 'ps1'),
  ('castlevaniaSymphonyOfTheNight', 'xbla'),
  ('castlevaniaSymphonyOfTheNight', 'psn'),
  ('shadowComplex', 'xbla'),
  ('lifeAndDeath', 'macOS'),
  ('lifeAndDeath', 'dos'),
  ('lifeAndDeath', 'amiga'),
  ('lifeAndDeath', 'atariST'),
  ('lifeAndDeath', 'appleIIgs'),
  ('dejaVu', 'amiga'),
  ('dejaVu', 'appleIIgs'),
  ('dejaVu', 'atariST'),
  ('dejaVu', 'commodore64'),
  ('dejaVu', 'gbc'),
  ('dejaVu', 'macOS'),
  ('dejaVu', 'nes'),
  ('dejaVu', 'pc'),
  ('dejaVu', 'pocketPC'),
  ('themeHospital', 'pc'),
  ('themeHospital', 'ps1'),
  ('themeHospital', 'psn'),
  ('minecraft', 'pc'),
  ('minecraft', 'macOS'),
  ('retroGameChallenge', 'nds'),
  ('traumaCenter', 'nds'),
  ('phoenixWrightAceAttorney', 'nds'),
  ('granTurismo4', 'ps2'),
  ('guildWars', 'pc'),
  ('leagueofLegends', 'pc'),
  ('ffxi', 'pc'),
  ('ffxi', 'ps2'),
  ('ffxi', 'xbox360'),
  ('dukeNukem3D', 'pc'),
  ('redFaction', 'ps2'),
  ('redFaction', 'pc'),
  ('redFaction', 'nGage'),
  ('teamFortress2', 'pc'),
  ('diablo2', 'pc'),
  ('demonsSoul', 'ps3'),
  ('unrealTournament3', 'pc'),
  ('unrealTournament3', 'ps3'),
  ('unrealTournament3', 'xbox360'),
  ('untoldLegendsDarkKingdom', 'ps3'),
  ('theOrangeBox', 'pc'),
  ('theOrangeBox', 'ps3'),
  ('theOrangeBox', 'xbox360'),
  ('lair', 'ps3');
  