CREATE TABLE PLAYER(
PLAYER_ID INTEGER PRIMARY KEY AUTO_INCREMENT,
USERNAME VARCHAR(30));

INSERT INTO PLAYER (USERNAME) VALUES('Hanley'),('Aristos'),('Jonah'),('Erimentha'),('Maximus'),('Darwin');

CREATE TABLE OBJECT(
OBJECT_ID INTEGER PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(30));

INSERT INTO OBJECT (NAME) VALUES('Shovel'),('Hammer'),('Disks'),('Shoes'),('Gun');

CREATE TABLE INVENTORY(
PLAYER_ID INTEGER NOT NULL,
OBJECT_ID INTEGER NOT NULL,
NB_ITEMS INTEGER DEFAULT 0,
PRIMARY KEY (PLAYER_ID,OBJECT_ID));

INSERT INTO INVENTORY(PLAYER_ID,OBJECT_ID,NB_ITEMS)
VALUES(1,1,2),(2,1,1),(2,2,1),(3,3,3),(3,1,2),(4,4,2),(4,2,1);

CREATE TABLE SMALL_A(
NAME CHAR(1) PRIMARY KEY);

INSERT INTO SMALL_A VALUES('A'),('B'),('C');

CREATE TABLE SMALL_B(
NAME INTEGER PRIMARY KEY);

INSERT INTO SMALL_B VALUES(1),(2),(3),(4);