Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 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,
- s_isDiscounted smallint DEFAULT 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
- ) ;
- 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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement