CREATE TABLE movie_database (
  m_id SERIAL NOT NULL PRIMARY KEY,
  m_title varchar(50) NOT NULL,
  m_description text NOT NULL,
  m_length int NOT NULL,
  m_image mediumblob NOT NULL,
  m_genre varchar(20) NOT NULL
) ;

CREATE TABLE showing_database (
  sh_id SERIAL NOT NULL PRIMARY KEY,
  sh_date timestamp(0) NOT NULL,
  movie_id int NOT NULL REFERENCES movie_database(m_id),
  sh_price double precision NOT NULL
) ;


CREATE TABLE user_database (
  u_id SERIAL NOT NULL PRIMARY KEY,
  u_fname varchar(50)  NOT NULL,
  u_uname varchar(50)  NOT NULL UNIQUE,
  u_lname varchar(50)  NOT NULL,
  u_pass varchar(42) NOT NULL,
  u_bdate date NOT NULL,
  u_phonenumber int NOT NULL UNIQUE,
  u_email varchar(30) NOT NULL UNIQUE
) ;

CREATE TABLE seat_database (
  s_id SERIAL NOT NULL PRIMARY KEY,
  s_number int NOT NULL,
  showing_id int NOT NULL REFERENCES showing_database(sh_id),
  reserved_by int DEFAULT NULL REFERENCES user_database(u_id),
  s_isDiscounted smallint DEFAULT NULL
) ;





INSERT INTO user_database (u_id, u_fname, u_uname, u_lname, u_pass, u_bdate, u_phonenumber, u_email) VALUES
(1, 'Pawełe', 'vespi', 'Krzyżak', '*998345F3F3AAF4911BB09FE177BDAC58823E3E46', '2018-12-22', 123123321, 'vvv@interia.pl'),
(49, 'Dd', 'krzysiekjarecki', 'Dd', '*15E088F1E7080F04E84E9CD0FA3A6FCC70F86C63', '1990-02-15', 531412312, 'emailfajny@onet.eu'),
(51, 'Deded', 'dede', 'Dedede', '*E91C566E1D4F2603031C2AB5E2932E4AA1377DBC', '2004-02-13', 333333333, 'vvvvv@lelele.pl'),
(52, 'Szymon', 'Moortan', 'Leniart', '*2958ADF59D0219305B98A50377FA3147775766E1', '1999-02-12', 123123123, 'asd@gmail.com'),
(54, 'Szymon', 'szymek', 'Leniart', '*2958ADF59D0219305B98A50377FA3147775766E1', '2001-02-09', 123123125, '123@gmail.com'),
(55, 'Pwl', 'vespi2', 'Ll', '*998345F3F3AAF4911BB09FE177BDAC58823E3E46', '2000-12-13', 532342342, 'vv@onet.eu'),
(57, 'Dsa', 'Dominik', 'Das', '123123', '2019-03-08', 534941497, '312@o2.pl'),
(58, 'A', 'xyz', 'A', 'aaabbbb', '2019-10-17', 123456789, 'aa@aa.pl'),
(59, 'A', 'aaa', 'A', 'qqqqqq', '2019-10-03', 1, 'a@a.pl'),
(61, 'Ja', 'krzysiekjarecki123', 'Ty', '*B3D3AC56C2D918CD7FF7830BB1605CDBBF1AA1B8', '2002-02-08', 502131231, 'vivivi@gmail.com');