DROP TABLE IF EXISTS killers;

CREATE TABLE killers (

id INTEGER PRIMARY KEY,

death_id INTEGER NOT NULL,

final_hit BOOLEAN NOT NULL

DEFAULT 'FALSE',

unjustified BOOLEAN NOT NULL

DEFAULT 'FALSE',

war BIGINT NOT NULL

DEFAULT '0',

FOREIGN KEY ( death_id ) REFERENCES player_deaths ( id ) 

);

DROP TABLE IF EXISTS player_deaths;

CREATE TABLE player_deaths (

id INTEGER PRIMARY KEY,

player_id INTEGER NOT NULL,

date INTEGER NOT NULL,

level INTEGER NOT NULL,

FOREIGN KEY ( player_id ) REFERENCES players ( id ) 

);

DROP TABLE IF EXISTS player_killers;

CREATE TABLE player_killers (

kill_id INTEGER NOT NULL,

player_id INTEGER NOT NULL,

FOREIGN KEY ( kill_id ) REFERENCES killers ( id ),

FOREIGN KEY ( player_id ) REFERENCES players ( id ) 

);