-- install script for mazedb

-- clear the leftovers, ie. a brand new database
drop database if exists mazedb;
drop role if exists mazedb;

-- create the requested mazedb user and DB
create user mazedb createdb unencrypted password 's321851gper';
create database mazedb owner mazedb;

-- just in case make it superuser
alter  user mazedb with SUPERUSER;

-- connect to the database
\connect mazedb

CREATE TABLE games
(
   game_id SERIAL,        						-- Just primary key
   level_id character varying, 				-- The ID of the level, also a URL parameter
   level_number integer, 							-- On which level the game was saved
   level_type CHARACTER(1),           -- What type this game is: S, A, T
   created_at TIMESTAMP DEFAULT NOW(),-- When this game was created
   CONSTRAINT game_pk PRIMARY KEY (game_id)
)
WITH (
  OIDS = FALSE
)
;