database.txt

create database exeplore;
use exeplore

create table users(user_id int not null unique auto_increment,
roll_number varchar(255) not null unique,
password varchar(255) not null,
first_name varchar(255) not null,
last_name varchar(255) not null,
phone_number varchar(13) not null,
initial_login int(13) not null default 0,
primary key(user_id));

create table game_features(game_id int not null unique auto_increment,
game_name varchar(255) not null unique,
game_high_score int not null,
primary key(game_id));

create table games (s_id int not null unique auto_increment,
game_id int not null,
user_id int not null,
high_score int not null,
foreign key(user_id) references users(user_id),
foreign key(game_id) references game_features(game_id));

insert into game_features(game_name, game_high_score) values("Hurdles", "0");
insert into game_features(game_name, game_high_score) values("2048", "0");
insert into game_features(game_name, game_high_score) values("Breakout", "0");
insert into game_features(game_name, game_high_score) values("Delta Masters", "0");
insert into game_features(game_name, game_high_score) values("Bubble Trouble", "0");
insert into game_features(game_name, game_high_score) values("Escape The Gravity", "0");
insert into game_features(game_name, game_high_score) values("Pic Puzzle", "0");