CREATE TABLE player
(
	username	CHAR(20)	not null,
	firstName	CHAR(20)	not null,
	lastName	CHAR(20)	not null,
	tokens		BIGINT		not null	default 0,
	password	CHAR(20)	not null,
	primary key (username)
);

CREATE TABLE bet
(
	id		BIGINT		not null,
	type		ENUM ('winner', 'podium')	not null,
	competition	CHAR(50)	not null	REFERENCES competition (name) ,
	player		CHAR(20)	not null	REFERENCES player (username),
	amount		BIGINT		not null	CHECK >0,
	successful	BIT				default Null,
	first		BIGINT		not null	REFERENCES participant (id),
	second		BIGINT		REFERENCES participant (id),
	third		BIGINT		REFERENCES participant (id),
	primary key (id)
);



____________________________________________________


input
CREATE TABLE player
(
	username	CHAR(20)	not null,
	firstName	CHAR(20)	not null,
	lastName	CHAR(20)	not null,
	tokens		BIGINT    not null,
	password	CHAR(20)	not null,
	primary key (username)
);

CREATE TYPE betType AS ENUM ('winner', 'podium');


CREATE TABLE bet
(
	id            BIGINT              not null,
	type          betType             not null,
	competition	  CHAR(50)	          not null,
	player		    CHAR(20)	          not null,
	amount		    BIGINT		          not null,
	successful	  BIT                 default null,
	first		      BIGINT              not null,
	second		    BIGINT		          ,
	third		      BIGINT              ,
	primary key (id)
);


SELECT * FROM player;