CREATE TABLE player (
	num integer primary key autoincrement not null,
	name varchar(100) default '' not null,
	unique(name)
);

CREATE TABLE resource (
	num integer primary key autoincrement not null,
	name varchar(100) default '' not null,
	unique(name)
);

CREATE TABLE playerresource (
	player integer default 0 not null,
	resource integer default 0 not null,
	amount integer default 0,
	primary key(player, resource)
);