String createTableGame = "create table Game ("
+ "game_id int unsigned not null auto_increment, "
+ "publisher_id int unsigned, "
+ "developer_id int unsigned, "
+ "genre_id int unsigned, "
+ "game_name varchar(100), "
+ "nr_of_players int, "
+ "online_game char(1), "
+ "monthly_fee decimal(5,2), "
+ "release_date varchar(30), "
+ "description varchar(200), "
+ "primary key (game_id), "
+ "index (publisher_id), "
+ "constraint pubid_to_compid_fk foreign key Game(publisher_id) references Company(company_id) on delete set null on update cascade, "
+ "index (developer_id), "
+ "constraint devid_to_compid_fk foreign key Game(developer_id) references Company(company_id) on delete set null on update cascade, "
+ "index (genre_id), "
+ "constraint genid_to_genid_fk foreign key Game(genre_id) references Genre(genre_id) on delete set null on update cascade"
+ ") ENGINE=INNODB;";
String createTableArticle = "create table Article ("
+ "URL varchar(200), "
+ "game_id int unsigned not null, "
+ "title varchar(50), "
+ "author varchar(30), "
+ "rating varchar(30), "
+ "source varchar(30), "
+ "primary key(URL, game_id), "
+ "index (game_id), "
+ "constraint art_to_gam_fk foreign key Article(game_id) references Game(game_id) on delete cascade on update cascade"
+ ") ENGINE=INNODB;";
String createTableCompany = "create table Company ("
+ "company_id int unsigned not null auto_increment, "
+ "company_name varchar(30), " + "country varchar(30), "
+ "primary key (company_id), " + "index (company_id)"
+ ") ENGINE=INNODB;";
String createTableGenre = "create table Genre ("
+ "genre_id int unsigned not null auto_increment, "
+ "genre_name varchar(50), " + "primary key (genre_id), "
+ "index (genre_id)" + ") ENGINE=INNODB;";