RhugiSAR

1-- CREATE SCHEMA pokertools;
2
3-- CREATE DATABASE poker_tools WITH OWNER postgres ENCODING 'UTF8' TABLESPACE = pg_default TEMPLATE template0;
4-- CREATE USER pokertools WITH PASSWORD 'kumpis_240' SUPERUSER;
5-- DROP SCHEMA IF EXISTS poker_tools CASCADE;
6CREATE SCHEMA poker_tools;
7
8CREATE TABLE poker_tools.tournament (
9                                        id SERIAL NOT NULL,
10                                        caption VARCHAR(500) NOT NULL,
11                                        level_time INTEGER NOT NULL,
12                                        buy_in NUMERIC(8, 2)
13);
14
15ALTER TABLE poker_tools.tournament ADD CONSTRAINT tournament_pkey PRIMARY KEY (id);