-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `seat_database`
--

CREATE TABLE seat_database (
  s_id int NOT NULL,
  s_number int NOT NULL,
  showing_id int NOT NULL,
  reserved_by int DEFAULT NULL,
  s_isDiscounted smallint DEFAULT NULL
) ;

--
-- Zrzut danych tabeli `seat_database`
--


-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `showing_database`
--

CREATE TABLE showing_database (
  sh_id int NOT NULL,
  sh_date timestamp(0) NOT NULL,
  movie_id int NOT NULL,
  sh_price double precision NOT NULL
) ;

--
-- Zrzut danych tabeli `showing_database`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `user_database`
--

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

--
-- Zrzut danych tabeli `user_database`
--

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');

--
-- Indeksy dla zrzutów tabel
--

--
-- Indeksy dla tabeli `movie_database`
--
ALTER TABLE movie_database
  ADD PRIMARY KEY (m_id),
  ADD KEY `m_id` (m_id);

--
-- Indeksy dla tabeli `seat_database`
--
ALTER TABLE seat_database
  ADD PRIMARY KEY (s_id),
  ADD KEY `seat_database_ibfk_1` (showing_id);

--
-- Indeksy dla tabeli `showing_database`
--
ALTER TABLE showing_database
  ADD PRIMARY KEY (sh_id),
  ADD UNIQUE KEY `sh_id` (sh_id),
  ADD KEY `showing_database_ibfk_1` (movie_id);

--
-- Indeksy dla tabeli `user_database`
--
ALTER TABLE user_database
  ADD PRIMARY KEY (u_id),
  ADD UNIQUE KEY `u_id` (u_id),
  ADD UNIQUE KEY `u_uname` (u_uname),
  ADD UNIQUE KEY `u_email` (u_email),
  ADD UNIQUE KEY `u_phonenumber` (u_phonenumber);

--
-- AUTO_INCREMENT dla tabel zrzutów
--

--
-- AUTO_INCREMENT dla tabeli `movie_database`
--
ALTER TABLE movie_database
  MODIFY m_id cast(11 as int) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT dla tabeli `seat_database`
--
ALTER TABLE seat_database
  MODIFY s_id cast(11 as int) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4461;

--
-- AUTO_INCREMENT dla tabeli `showing_database`
--
ALTER TABLE showing_database
  MODIFY sh_id cast(11 as int) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT dla tabeli `user_database`
--
ALTER TABLE user_database
  MODIFY u_id cast(11 as int) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- Ograniczenia dla zrzutów tabel
--

--
-- Ograniczenia dla tabeli `seat_database`
--
ALTER TABLE seat_database
  ADD CONSTRAINT seat_database_ibfk_1 FOREIGN KEY (showing_id) REFERENCES showing_database (sh_id) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ograniczenia dla tabeli `showing_database`
--
ALTER TABLE showing_database
  ADD CONSTRAINT showing_database_ibfk_1 FOREIGN KEY (movie_id) REFERENCES movie_database (m_id) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;