Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------------
- --
- -- 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) CHARACTER SET utf8 NOT NULL,
- u_uname varchar(50) CHARACTER SET utf8 NOT NULL,
- u_lname varchar(50) CHARACTER SET utf8 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement