Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create database wiezienie_fox_river;
- use wiezienie_fox_river;
- create table dane_wieznia(
- id_wieznia int primary key,
- imie_wieznia varchar(20),
- nazwisko_wieznia varchar(20),
- plec varchar(20),
- data_urodzenia date,
- data_przybycia date,
- data_zakonczenia_wyroku date
- );
- insert into dane_wieznia(id_wieznia,imie_wieznia,nazwisko_wieznia,plec,data_urodzenia,data_przybycia, data_zakonczenia_wyroku)
- values
- ('001','Michael','Trocky','M','1988-09-13','2005-10-23','2015-01-23'),
- ('002','Artur','Szypyr','M','1999-04-25','2018-04-15','2023-04-15'),
- ('003','Kacper','Sywruk','M','2000-01-23','2018-12-01','2023-12-01'),
- ('004','Fernando','Alonzo','M','1987-01-11','2000-07-13','2005-07-13'),
- ('005','Sara','Tumadredy','K','1995-02-27','2013-03-08','2018-03-08'),
- ('006','Wiktoria','Mazur','K','1990-09-15','2005-09-15','2020-09-15'),
- ('007','Bartosz','Paduch','M','1992-06-23','2013-05-01','2032-05-01'),
- ('008','Michal','Rychlik','M','1979-01-31','2000-11-20','2015-11-20'),
- ('009','Krzysztof','Killer','M','1979-01-31','2013-03-17','2018-03-17'),
- ('010','Dawid','Mazur','M','1997-09-22','2018-07-23','2026-07-23'),
- ('011','Monika','Kampinska','K','1987-09-11','2019-04-22','2023-04-22'),
- ('012','Ida','Mack','K','1970-07-07','2000-03-30','2015-03-30'),
- ('013','Mateusz','Azyk','M','1999-05-21','2019-05-15','2025-05-15'),
- ('014','Magdalena','Kowalska','K','1996-09-17','2009-06-21','2019-06-21'),
- ('015','Julia','Niska','K','1988-04-10','2009-08-12','2019-08-12'),
- ('016','Karolina','Kracz','K','1969-05-21','1999-09-22','2015-09-22'),
- ('017','Maja','Bach','K','1979-04-27','2000-04-20','2015-04-20'),
- ('018','Kuba','Klakowak','M','1975-03-12','2005-04-11','2015-04-11'),
- ('019','Magdalena','Nima','K','1976-02-29','2013-08-25','2018-03-25'),
- ('020','Kamil','Boken','M','1987-11-17','2007-07-07','2017-08-07'),
- ('021','Michalina','Bozium','K','1987-05-11','2000-06-25','2010-06-25'),
- ('022','Dariusz','Gloska','M','1976-06-11','2013-04-20','2023-04-20'),
- ('023','Magdalena','Macioszke','K','1976-02-29','2013-03-25','2023-03-25'),
- ('024','Maciek','Bogil','M','1980-05-11','1990-01-01','2009-01-01'),
- ('025','Kacper','Gonil','M','1995-02-15','2018-02-07','2028-02-07'),
- ('026','Julia','Masno','K','1978-07-19','1995-11-17','2010-11-17'),
- ('027','Grzegorz','Nijak','M','1991-04-01','2009-05-07','2019-05-07'),
- ('028','Josh','Gibon','M','1985-07-19','2000-11-17','2019-11-17'),
- ('029','Michal','Karnas','M','1995-01-07','2015-04-07','2025-04-07'),
- ('030','Mikolaj','Swiety','M','1970-04-16','2000-06-22','2000-07-22');
- create table widzenia(
- id_widzenia int primary key,
- data_widzenia datetime,
- id_wieznia int,
- nazwisko_wieznia varchar(20),
- nazwisko_odwiedzajacego varchar(20)
- );
- insert into widzenia(id_widzenia,data_widzenia,id_wieznia,nazwisko_wieznia,nazwisko_odwiedzajacego)
- values
- ('501','2009-08-20 12:30','015','Niska','Goska'),
- ('502','1999-09-30 11:00','016','Kracz','Mazur'),
- ('503','1990-01-10 15:00','024','Bogil','Kowalski'),
- ('504','2005-09-25 12:30','006','Mazur','Mikolajczuk'),
- ('505','1999-10-30 13:00','016','Kracz','Mazur'),
- ('506','1970-04-09 11:00','012','Mack','Benko'),
- ('507','2000-07-23 12:30','004','Alonzo','Bogun'),
- ('508','2009-09-20 11:00','015','Niska','Goska'),
- ('509','1999-11-29 12:00','016','Kracz','Mazur'),
- ('510','2005-10-25 12:00','006','Mazur','Herb'),
- ('511','2000-08-23 12:30','004','Alonzo','Martinez'),
- ('512','2000-11-27 16:00','028','Gibon','Martinez'),
- ('513','2009-10-20 12:00','015','Niska','Goska'),
- ('514','1999-12-22 11:00','016','Kracz','Mazur'),
- ('515','1999-11-29 12:30','016','Kracz','Mazur'),
- ('516','2018-03-07 12:00','016','Gonil','Gonil'),
- ('517','2018-03-07 12:00','016','Gonil','Gonil'),
- ('518','2009-11-20 15:30','015','Niska','Goska'),
- ('519','2000-01-01 13:30','016','Kracz','Mazur'),
- ('520','1990-02-10 12:30','024','Bogil','Kowalski'),
- ('521','2005-10-25 12:00','006','Mazur','Mikolajczuk'),
- ('522','2000-02-01 12:00','016','Kracz','Mazur'),
- ('523','1970-05-09 10:00','012','Mack','Benko'),
- ('524','2000-08-23 11:30','004','Alonzo','Bogun'),
- ('525','2009-12-01 13:00','015','Niska','Goska'),
- ('526','2000-03-20 12:30','016','Kracz','Mazur'),
- ('527','2005-11-25 16:30','006','Mazur','Herb'),
- ('528','2000-09-23 12:00','004','Alonzo','Martinez'),
- ('529','2000-12-27 15:00','028','Gibon','Martinez'),
- ('530','2009-12-20 13:30','015','Niska','Goska');
- create table pracownicy(
- id_pracownika int,
- imie_pracownika varchar(20),
- nazwisko_pracownika varchar(20),
- typ_zmiany varchar(20),
- primary key(id_pracownika)
- );
- insert into pracownicy(id_pracownika,imie_pracownika,nazwisko_pracownika,typ_zmiany)
- values
- ('001','Wieslawa','Warchak','Straznik'),
- ('002','Brajanek','Paczosek','Straznik'),
- ('003','Mirek','Pacza','Straznik'),
- ('004','Arturina','Szpryt','Straznik'),
- ('005','Brajan','Paczosa','Straznik'),
- ('006','Bozena','Nowotyminska','Straznik'),
- ('007','Komieslaw','Dariel','Sprzatacz'),
- ('008','Zdzislaw','Maczywoda','Elektryk'),
- ('009','Choleslaw','Chleb','Sprzatacz'),
- ('010','Boleslaw','Grachamka','Konserwator'),
- ('011','Miloslaw','Dorytos','Kucharz'),
- ('012','Waclaw','Lewus','Kucharz'),
- ('013','Marcin','Prawus','Elektryk'),
- ('014','Andrzej','Bomba','Sprzatacz'),
- ('015','Jakub','Kubiak','Konserwator'),
- ('016','Pawel','Albrychowicz','Hydraulik'),
- ('017','Piotr','Trzepacz','Konserwator'),
- ('018','Czeslaw','Petarda','Hydraulik'),
- ('019','Artur','Skur','Doktor'),
- ('020','Eryk','Czyk','Doktor'),
- ('021','Maryk','Byk','Hydraulik'),
- ('022','Radoslaw','Lokiec','Elektryk'),
- ('023','Kamil','Poziomka','Kucharz'),
- ('024','Mihael','Jegany','Elektryk'),
- ('025','Yumi','Jaglana','Kucharz'),
- ('026','Tomasz','Kasza','Kucharz'),
- ('027','Zdzislaw','Miesien','Sprzatacz'),
- ('028','Mariusz','Pudzianowski','Doktor'),
- ('029','Wladyslaw','Bartoimadlo','Doktor'),
- ('030','Maryk','Polamiecz','Sprzatacz');
- create table zakwaterowanie(
- nr_zakwaterowania varchar(20),
- nr_celi varchar(20),
- nazwisko_wieznia varchar(20),
- nazwisko_wspolwieznia varchar(20),
- id_bloku varchar(3),
- id_wieznia int,
- primary key(nr_zakwaterowania),
- foreign key(id_wieznia) REFERENCES dane_wieznia(id_wieznia)
- );
- insert into zakwaterowanie(nr_zakwaterowania,nr_celi,nazwisko_wieznia,nazwisko_wspolwieznia,id_bloku,id_wieznia)
- values
- ('z101','A201','Trocky','Szypyr','A','001'),
- ('z102','A201','Szypyr','Trocky','A','002'),
- ('z103','A202','Sywruk','Alonzo','A','003'),
- ('z104','A202','Alonzo','Sywruk','A','004'),
- ('z105','A203','Tumadredy','Mazur','B','005'),
- ('z106','A203','Mazur','Tumadredy','B','006'),
- ('z107','A204','Paduch','puste','A','007'),
- ('z108','A205','Rychlik','puste','A','008'),
- ('z109','A206','Killer','Mazur','A','009'),
- ('z110','A206','Mazur','Killer','A','010'),
- ('z111','A207','Kampinska','Mack','B','011'),
- ('z112','A207','Mack','Kampinska','B','012'),
- ('z113','A208','Azyk','puste','A','013'),
- ('z114','A208','Kowalska','Niska','B','014'),
- ('z115','A208','Niska','Kowalska','B','015'),
- ('z116','A209','Kracz','puste','B','016'),
- ('z117','A210','Bach','puste','B','017'),
- ('z118','A211','Klakowak','puste','A','018'),
- ('z119','A212','Nima','Bozium','B','019'),
- ('z120','A213','Boken','Gloska','A','020'),
- ('z121','A212','Bozium','Nima','B','021'),
- ('z122','A213','Gloska','Boken','A','022'),
- ('z123','A213','Nima','Bogil','B','023'),
- ('z124','A214','Bogil','puste','A','024'),
- ('z125','A215','Gonil','puste','A','025'),
- ('z126','A216','Masno','puste','B','026'),
- ('z127','A217','Nijak','Gibon','A','027'),
- ('z128','A217','Gibon','Nijak','A','028'),
- ('z129','A218','Karnas','Swiety','A','029'),
- ('z130','A218','Swiety','Karnas','A','030');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement