CREATE TABLE SPACESHIP(
	SHIP_ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name varchar(100) NOT NULL,
	fire_power int,
	health int,
	shield int,
	speed int,
	starter_ship tinyint(1)
);

CREATE TABLE PLAYER(
	PLAYER_ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
	money int,
	USED_SHIP_ID int NOT NULL,
	next_level int NOT NULL,
	FOREIGN KEY fk_shipID(USED_SHIP_ID)
	REFERENCES SPACESHIP(SHIP_ID)
);

CREATE TABLE OWNED_SHIPS(
	PLAYER_ID int NOT NULL,
	SHIP_ID int NOT NULL,
	FOREIGN KEY fk_playerid(PLAYER_ID)
	REFERENCES PLAYER(PLAYER_ID),
	FOREIGN KEY fk_shipID(SHIP_ID)
	REFERENCES SPACESHIP(SHIP_ID)
);