USE Ribolovacko_Drustvo; CREATE TABLE Grad ( GradID int PRIMARY KEY, Grad varchar(25), PozivniBroj VARCHAR(3), Postanskibroj int, BrojStanovnika int ); INSERT INTO grad (GradID, Grad, PozivniBroj, Postanskibroj, BrojStanovnika) VALUES (1, 'Kula', '025', 32523, 25400), (2, 'Zaječar', '034', 232523, 265400), (3, 'Novi Sad', '021', 232523, 265400), (4, 'Vlasotince', '021', 232523, 265400), (5, 'Užice', '021', 232523, 265400), (6, 'Pančevo', '021', 232523, 265400), (7, 'Apatin', '021', 232523, 265400), (8, 'Netin', '021', 232523, 265400), (9, 'Beograd', '021', 232523, 265400), (10, 'Subotica', '021', 232523, 265400), (11, 'Niš', '021', 232523, 265400), (12, 'Valjevo', '021', 232523, 265400), (13, 'Kraljevo', '021', 232523, 265400), (14, 'Bečej', '021', 232523, 265400), (15, 'Apatin', '021', 232523, 265400), (16, 'Paraćin', '021', 232523, 265400), (17, 'Vršac', '021', 232523, 265400), (18, 'Smederevo', '021', 232523, 265400), (19, 'Vrbas', '021', 232523, 265400), (20, 'Srbobran', '021', 232523, 265400); CREATE TABLE Jezero ( JezeroID int PRIMARY KEY, Naziv varchar(50), BrojLokacija int ); INSERT INTO Jezero (JezeroID, Naziv, BrojLokacija) VALUES (1, 'Rodicevo', 1), (2, 'Malocevo', 2), (3, 'Rajcevo', 3), (4, 'Zurida', 4), (5, 'Palicko Jezero', 16), (6, 'Ludosko Jezero', 10), (7, 'Krvavo Jezero', 11); CREATE TABLE Lokacija ( JezeroID int, RbrLokacije int, Naziv varchar(50), Beleske varchar(255), CONSTRAINT PK_Lokacija PRIMARY KEY (JezeroID, RbrLokacije), CONSTRAINT fk_lokacija_jezero FOREIGN KEY (JezeroID) REFERENCES Jezero(JezeroID) ); INSERT INTO Lokacija (JezeroID, RbrLokacije, Naziv, Beleske) VALUES (1, 1, 'Rodicevo', 'MnoDobro'), (2, 2, 'MONOGAO', 'MnogoDobro'), (3, 3, 'Rprfada', 'MnogoDobro'), (4, 4, 'Lldafa', 'MnogoDobro'); INSERT INTO Lokacija (JezeroID, RbrLokacije, Naziv, Beleske) VALUES (5, 5, 'Rodicevo', 'MnogoDobro'), (6, 6, 'MONOGAO', 'MnogoDobro'), (7, 7, 'Rprfada', 'MnogoDobro'); CREATE TABLE Pecaros ( PecarosID int PRIMARY KEY, Ime varchar(50), Prezime varchar(50), Adresa varchar(250), Telefon varchar(50), GradID int, CONSTRAINT fk_pecaros_grad FOREIGN KEY (GradID) REFERENCES Grad(GradID) ); INSERT INTO Pecaros (PecarosID, Ime, Prezime, Adresa, Telefon, GradID) VALUES (1, 'Uroš', 'Dačić', 'Cvetina 9', '074-761-7265', 2); INSERT INTO Pecaros (PecarosID, Ime, Prezime, Adresa, Telefon, GradID) VALUES (10, 'Aleksej', 'David', 'Cvetna 99', '034-261-0265', 2); INSERT INTO Pecaros (PecarosID, Ime, Prezime, Adresa, Telefon, GradID) VALUES (11, 'Nikola', 'Antić', 'Sremska 53', '035-114-8053', 3), (12, 'Pertar', 'Branković', 'Sremska 56', '061-842-5432', 4), (14, 'Đorđe', 'Dukić', 'Palih boraca 99', '052-385-2385', 5), (15, 'David', 'Danilović', 'Palih boraca 82', '097-123-3485', 6), (16, 'Luka', 'David', 'Bul.Nemanjića 28', '073-295-6665', 7), (17, 'Milan', 'Avramović', 'Sićevačka 45', '064-471-0667', 8), (18, 'Nikola', 'Erceg', 'Vazduhoplovačka 35', '049-987-5753', 9), (19, 'Tadija', 'Erdeljan', 'Branka Miljkovića 84', '092-426-613', 10), (20, 'Luka', 'Bogavac', 'Subotička 23', '053-321-3000', 11), (21, 'Uroš', 'Babić', 'Subotička 43', '076-988-3033', 12), (22, 'Kristijan', 'Antić', 'Lala 18', '076-988-3033', 13), (23, 'Nikola', 'Lovac', 'Marsala Tita 11', '016-246-5613', 14), (24, 'Teodor', 'Filipović', NULL, '073-194-899', 15), (25, 'Tadija', 'Hajdeman', 'Sremska 85', '018-628-1473', 16), (26, 'Milan', 'Pena', 'Bulevar AVNOJ-a 60', '061-1879-756', 17), (27, 'David', 'Erceg', 'Palih boraca 72', '081-137-7963', 18), (28, 'Leon', 'Branković', 'Palih boraca 14', '081-811-7776', 19), (29, 'Nikola', 'Antić', 'Marsala Tita 13', '016-988-3033', 20), (30, 'Nebojsa', 'Filipović', 'Grmecka 45', '023-118-3223', 2), (31, 'Jovan', 'Som', 'Vojvodjanska 52', '016-988-3033', 3), (32, 'Nikola', 'Lovac', 'Marsala Tita 11', '016-988-3033', 4), (33, 'Nebojsa', 'Osjek', 'Grmecka 23', '016-988-3033', 5), (34, 'Milan', 'Som', 'Vojvodjanska 52', '016-988-3033', 6), (35, 'Luka', 'Lovac', 'Marsala Tita 11', '016-988-3033', 7), (36, 'Tadija', 'Osjek', 'Grmecka 23', '016-988-3033', 8), (37, 'Đorđe', 'Som', 'Vojvodjanska 52', '016-988-3033', 9), (38, 'Petar', 'Lovac', 'Marsala Tita 11', '016-988-3033', 13), (39, 'Siniša', 'Osjek', 'Grmecka 23', '016-988-3033', 12), (40, 'Jovan', 'Babić', 'Vojvodjanska 56', '032-338-4453', 11); CREATE TABLE Vrsta_Ribe ( VrstaID int PRIMARY KEY , Naziv varchar(50), Opis varchar(250) ); INSERT INTO Vrsta_Ribe (VrstaID, Naziv, Opis) VALUES (1, 'Bodorka', 'Lezi u dubokim vodama i cesto '), (2, 'Bucov', 'Lovi po plicaku i csto je akti'), (3, 'Crvenrepka', 'Lako se peca i nalazi se blizu'), (4, 'Grgeč', 'Lezi u dubokim vodama i cesto '), (5, 'Linjak', 'Lovi po plicaku i csto je akti'), (6, 'Mladica', 'Lako se peca i nalazi se blizu'), (7, 'Šaran', 'Lezi u dubokim vodama i cesto '), (8, 'Štuka', 'Lovi po plicaku i csto je akti'), (9, 'Som', 'Lako se peca i nalazi se blizu'); CREATE TABLE Ulov ( PecarosID int, RbrUlova int, Datum date, Vreme time, VrstaID int, Tezina VARCHAR(25), JezeroID int, RbrLokacije int, CONSTRAINT PK_ul PRIMARY KEY (PecarosID, RbrUlova), CONSTRAINT fk_ulov_pecar FOREIGN KEY (PecarosID) REFERENCES Pecaros(PecarosID), CONSTRAINT fk_ulov_vrst FOREIGN KEY (VrstaID) REFERENCES Vrsta_Ribe(VrstaID), CONSTRAINT fk_ulov_lok FOREIGN KEY (JezeroID,RbrLokacije) REFERENCES Lokacija(JezeroID,RbrLokacije) ); INSERT INTO Ulov (PecarosID, RbrUlova, Datum, Vreme, VrstaID, Tezina, JezeroID, RbrLokacije) VALUES (10, 1, '2020-05-12', '23:00:00', 1, '20kg', 1, 1); INSERT INTO Ulov (PecarosID, RbrUlova, Datum, Vreme, VrstaID, Tezina, JezeroID, RbrLokacije) VALUES (11, 1, '2008-01-22', '15:00:00', 1, '15kg', 2, 2), (12, 1, '2008-10-12', '10:00:00', 2, '950g', 3, 3), (14, 1, '2008-08-02', '15:00:00', 3, '15kg', 5, 5), (15, 1, '2002-10-12', '10:00:00', 4, '950g', 6, 6), (16, 1, '2002-05-12', '23:00:00', 5, '20kg', 7, 7), (17, 1, '2002-08-22', '15:00:00', 6, '15kg', 1, 1), (18, 1, '2002-10-22', '10:00:00', 7, '950g', 1, 1), (19, 1, '2002-05-12', '23:00:00', 8, '20kg', 1, 1), (20, 1, '2002-08-22', '15:00:00', 9, '15kg', 2, 2), (21, 1, '2002-10-22', '10:00:00', 3, '950g', 2, 2), (22, 1, '2002-05-12', '23:00:00', 1, '20kg', 2, 2), (23, 1, '2002-08-22', '15:00:00', 2, '15kg', 2, 2), (24, 1, '2002-10-22', '10:00:00', 3, '950g', 3, 3), (25, 1, '2002-05-12', '23:00:00', 1, '20kg', 4, 4), (26, 1, '2003-05-12', '23:00:00', 1, '20kg', 3, 3), (27, 1, '2003-08-22', '15:00:00', 2, '15kg', 3, 3), (28, 1, '2003-10-22', '10:00:00', 3, '950g', 3, 3), (29, 1, '2003-05-12', '23:00:00', 4, '20kg', 3, 3), (30, 1, '2003-08-22', '15:00:00', 4, '15kg', 3, 3), (31, 1, '2004-10-22', '10:00:00', 4, '950g', 4, 4), (32, 1, '2004-05-12', '23:00:00', 4, '20kg', 4, 4), (33, 1, '2004-08-22', '15:00:00', 5, '15kg', 4, 4), (34, 1, '2004-10-22', '10:00:00', 5, '950g', 4, 4), (35, 1, '2004-05-12', '23:00:00', 5, '20kg', 4, 4), (36, 1, '2005-08-22', '15:00:00', 1, '15kg', 4, 4), (37, 1, '2005-10-22', '10:00:00', 1, '950g', 4, 4), (38, 1, '2005-05-12', '23:00:00', 1, '20kg', 4, 4), (39, 1, '2005-08-22', '15:00:00', 2, '15kg', 4, 4), (40, 1, '2005-10-22', '10:00:00', 3, '950g', 4, 4), (11, 2, '2005-08-22', '15:00:00', 4, '15kg', 2, 2), (12, 2, '2005-10-22', '10:00:00', 4, '950g', 3, 3), (14, 2, '2005-08-22', '15:00:00', 4, '15kg', 5, 5), (15, 2, '2005-10-22', '10:00:00', 4, '950g', 6, 6), (16, 2, '2005-05-12', '23:00:00', 5, '20kg', 7, 7), (17, 2, '2006-08-22', '15:00:00', 5, '15kg', 1, 1), (18, 2, '2006-10-22', '10:00:00', 5, '950g', 1, 1), (19, 2, '2006-05-12', '23:00:00', 5, '20kg', 1, 1), (20, 2, '2006-08-22', '15:00:00', 2, '15kg', 2, 2), (21, 2, '2006-10-22', '10:00:00', 3, '950g', 2, 2), (22, 2, '2006-05-12', '23:00:00', 1, '20kg', 2, 2), (23, 2, '2006-08-22', '15:00:00', 4, '15kg', 2, 2), (24, 2, '2006-10-22', '10:00:00', 4, '950g', 3, 3), (25, 2, '2006-05-12', '23:00:00', 1, '20kg', 4, 4), (26, 2, '2006-05-12', '23:00:00', 1, '20kg', 3, 3), (27, 2, '2007-08-22', '15:00:00', 1, '15kg', 3, 3), (28, 2, '2006-10-22', '10:00:00', 1, '950g', 3, 3), (29, 2, '2006-05-12', '23:00:00', 1, '20kg', 3, 3), (30, 2, '2006-08-22', '15:00:00', 1, '15kg', 3, 3), (31, 2, '2006-10-22', '10:00:00', 1, '950g', 4, 4), (32, 2, '2006-05-12', '23:00:00', 1, '20kg', 4, 4), (33, 2, '2006-08-22', '15:00:00', 2, '15kg', 4, 4), (34, 2, '2006-10-22', '10:00:00', 3, '950g', 4, 4), (35, 2, '2006-05-12', '23:00:00', 1, '20kg', 4, 4), (36, 2, '2020-08-22', '15:00:00', 2, '15kg', 4, 4), (37, 2, '2020-10-22', '10:00:00', 3, '950g', 4, 4), (38, 2, '2020-05-12', '23:00:00', 1, '20kg', 4, 4), (39, 2, '2020-08-22', '15:00:00', 2, '15kg', 4, 4), (40, 2, '2020-10-22', '10:00:00', 3, '950g', 4, 4), (11, 3, '2021-08-22', '15:00:00', 2, '15kg', 2, 2), (12, 3, '2021-10-22', '10:00:00', 3, '950g', 3, 3), (14, 3, '2021-08-22', '15:00:00', 2, '15kg', 5, 5), (15, 3, '2021-10-22', '10:00:00', 3, '950g', 6, 6), (16, 3, '2021-05-12', '23:00:00', 1, '20kg', 7, 7), (17, 3, '2021-08-22', '15:00:00', 2, '15kg', 1, 1), (18, 3, '2021-10-22', '10:00:00', 3, '950g', 1, 1), (19, 3, '2021-05-12', '23:00:00', 1, '20kg', 1, 1), (20, 3, '2021-08-22', '15:00:00', 2, '15kg', 2, 2), (21, 3, '2021-10-22', '10:00:00', 3, '950g', 2, 2), (22, 3, '2021-05-12', '23:00:00', 1, '20kg', 2, 2), (23, 3, '2021-08-22', '15:00:00', 2, '15kg', 2, 2), (24, 3, '2021-10-22', '10:00:00', 3, '950g', 3, 3), (25, 3, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (26, 3, '2021-05-12', '23:00:00', 1, '20kg', 3, 3), (27, 3, '2021-08-22', '15:00:00', 2, '15kg', 3, 3), (28, 3, '2021-10-22', '10:00:00', 3, '950g', 3, 3), (29, 3, '2021-05-12', '23:00:00', 1, '20kg', 3, 3), (30, 3, '2021-08-22', '15:00:00', 2, '15kg', 3, 3), (31, 3, '2021-10-22', '10:00:00', 3, '950g', 4, 4), (32, 3, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (33, 3, '2021-08-22', '15:00:00', 2, '15kg', 4, 4), (34, 3, '2021-10-22', '10:00:00', 3, '950g', 4, 4), (35, 3, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (36, 3, '2021-08-22', '15:00:00', 2, '15kg', 4, 4), (37, 3, '2021-10-22', '10:00:00', 3, '950g', 4, 4), (38, 3, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (39, 3, '2021-08-22', '15:00:00', 2, '15kg', 4, 4), (40, 3, '2021-10-22', '10:00:00', 3, '950g', 4, 4), (11, 4, '2021-08-22', '15:00:00', 2, '15kg', 2, 2), (12, 4, '2021-10-22', '10:00:00', 3, '950g', 3, 3), (14, 4, '2021-08-22', '15:00:00', 2, '15kg', 5, 5), (15, 4, '2021-10-22', '10:00:00', 3, '950g', 6, 6), (16, 4, '2021-05-12', '23:00:00', 1, '20kg', 7, 7), (17, 4, '2021-08-22', '15:00:00', 2, '15kg', 1, 1), (18, 4, '2021-10-22', '10:00:00', 3, '950g', 1, 1), (19, 4, '2021-05-12', '23:00:00', 1, '20kg', 1, 1), (20, 4, '2021-08-22', '15:00:00', 2, '15kg', 2, 2), (21, 4, '2021-10-22', '10:00:00', 3, '950g', 2, 2), (22, 4, '2021-05-12', '23:00:00', 1, '20kg', 2, 2), (23, 4, '2021-08-22', '15:00:00', 2, '15kg', 2, 2), (24, 4, '2021-10-22', '10:00:00', 3, '950g', 3, 3), (25, 4, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (26, 4, '2021-05-12', '23:00:00', 1, '20kg', 3, 3), (27, 4, '2021-08-22', '15:00:00', 2, '15kg', 3, 3), (28, 4, '2021-10-22', '10:00:00', 3, '950g', 3, 3), (29, 4, '2021-05-12', '23:00:00', 1, '20kg', 3, 3), (30, 4, '2021-08-22', '15:00:00', 2, '15kg', 3, 3), (31, 4, '2021-10-22', '10:00:00', 3, '950g', 4, 4), (32, 4, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (33, 4, '2021-08-22', '15:00:00', 2, '15kg', 4, 4), (34, 4, '2021-10-22', '10:00:00', 3, '950g', 4, 4), (35, 4, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (36, 4, '2021-08-22', '15:00:00', 2, '15kg', 4, 4), (37, 4, '2021-10-22', '10:00:00', 3, '950g', 4, 4), (38, 4, '2021-05-12', '23:00:00', 1, '20kg', 4, 4), (39, 4, '2021-08-22', '15:00:00', 1, '15kg', 4, 4), (40, 4, '2021-10-22', '10:00:00', 1, '950g', 4, 4), (11, 5, '2021-08-22', '15:00:00', 1, '15kg', 2, 2), (12, 5, '2021-10-22', '10:00:00', 1, '950g', 3, 3), (14, 5, '2022-08-22', '15:00:00', 1, '15kg', 5, 5), (15, 5, '2022-10-22', '10:00:00', 1, '950g', 6, 6), (16, 5, '2022-05-12', '23:00:00', 1, '20kg', 7, 7), (17, 5, '2022-08-22', '15:00:00', 1, '15kg', 1, 1), (18, 5, '2022-10-22', '10:00:00', 1, '950g', 1, 1), (19, 5, '2022-05-12', '23:00:00', 1, '20kg', 1, 1), (20, 5, '2022-08-22', '15:00:00', 2, '15kg', 2, 2), (21, 5, '2022-10-22', '10:00:00', 2, '950g', 2, 2), (22, 5, '2022-05-12', '23:00:00', 2, '20kg', 2, 2), (23, 5, '2022-08-22', '15:00:00', 2, '15kg', 2, 2), (24, 5, '2022-10-22', '10:00:00', 2, '950g', 3, 3), (25, 5, '2022-05-12', '23:00:00', 2, '20kg', 4, 4), (26, 5, '2022-05-12', '23:00:00', 2, '20kg', 3, 3), (27, 5, '2022-08-22', '15:00:00', 2, '15kg', 3, 3), (28, 5, '2022-10-22', '10:00:00', 2, '950g', 3, 3), (29, 5, '2022-05-12', '23:00:00', 2, '20kg', 3, 3), (30, 5, '2022-08-22', '15:00:00', 3, '15kg', 3, 3), (31, 5, '2022-10-22', '10:00:00', 3, '950g', 4, 4), (32, 5, '2022-05-12', '23:00:00', 3, '20kg', 4, 4), (33, 5, '2022-08-22', '15:00:00', 3, '15kg', 4, 4), (34, 5, '2022-10-22', '10:00:00', 3, '950g', 4, 4), (35, 5, '2022-05-12', '23:00:00', 3, '20kg', 4, 4), (36, 5, '2022-08-22', '15:00:00', 3, '15kg', 4, 4), (37, 5, '2022-10-22', '10:00:00', 3, '950g', 4, 4), (38, 5, '2022-05-12', '23:00:00', 3, '20kg', 4, 4), (39, 5, '2022-08-22', '15:00:00', 3, '15kg', 4, 4), (40, 5, '2022-10-22', '10:00:00', 7, '950g', 4, 4), (11, 6, '2022-08-22', '15:00:00', 7, '15kg', 2, 2), (12, 6, '2022-10-22', '10:00:00', 7, '950g', 3, 3), (14, 6, '2022-08-22', '15:00:00', 7, '15kg', 5, 5), (15, 6, '2022-10-22', '10:00:00', 7, '950g', 6, 6), (16, 6, '2022-05-12', '23:00:00', 7, '20kg', 7, 7), (17, 6, '2022-08-22', '15:00:00', 7, '15kg', 1, 1), (18, 6, '2022-10-22', '10:00:00', 7, '950g', 1, 1), (19, 6, '2022-05-12', '23:00:00', 7, '20kg', 1, 1), (20, 6, '2022-08-22', '15:00:00', 7, '15kg', 2, 2), (21, 6, '2022-10-22', '10:00:00', 6, '950g', 2, 2), (22, 6, '2022-05-12', '23:00:00', 6, '20kg', 2, 2), (23, 6, '2022-08-22', '15:00:00', 6, '15kg', 2, 2), (24, 6, '2022-10-22', '10:00:00', 6, '950g', 3, 3), (25, 6, '2022-05-12', '23:00:00', 6, '20kg', 4, 4), (26, 6, '2022-05-12', '23:00:00', 6, '20kg', 3, 3), (27, 6, '2022-08-22', '15:00:00', 6, '15kg', 3, 3), (28, 6, '2022-10-22', '10:00:00', 6, '950g', 3, 3), (29, 6, '2022-05-12', '23:00:00', 6, '20kg', 3, 3), (30, 6, '2022-08-22', '15:00:00', 6, '15kg', 3, 3), (31, 6, '2022-10-22', '10:00:00', 5, '950g', 4, 4), (32, 6, '2022-05-12', '23:00:00', 5, '20kg', 4, 4), (33, 6, '2022-08-22', '15:00:00', 5, '15kg', 4, 4), (34, 6, '2022-10-22', '10:00:00', 5, '950g', 4, 4), (35, 6, '2022-05-12', '23:00:00', 5, '20kg', 4, 4), (36, 6, '2022-08-22', '15:00:00', 5, '15kg', 4, 4), (37, 6, '2022-10-22', '10:00:00', 5, '950g', 4, 4), (38, 6, '2020-05-12', '23:00:00', 5, '20kg', 4, 4), (39, 6, '2022-08-22', '15:00:00', 5, '15kg', 4, 4), (40, 6, '2022-10-22', '10:00:00', 5, '950g', 4, 4), (11, 7, '2020-05-12', '23:00:00', 4, '20kg', 5, 5), (21, 7, '2022-08-22', '15:00:00', 4, '15kg', 5, 5), (31, 7, '2022-10-22', '10:00:00', 4, '950g', 5, 5), (12, 7, '2020-05-12', '23:00:00', 4, '20kg', 5, 5), (22, 7, '2022-08-22', '15:00:00', 4, '15kg', 6, 6), (32, 7, '2022-10-22', '10:00:00', 4, '950g', 6, 6), (14, 7, '2020-05-12', '23:00:00', 4, '20kg', 6, 6), (23, 7, '2022-08-22', '15:00:00', 4, '15kg', 6, 6), (34, 7, '2022-10-22', '10:00:00', 4, '950g', 7, 7), (25, 7, '2020-05-12', '23:00:00', 4, '20kg', 7, 7); INSERT INTO Ulov (PecarosID, RbrUlova, Datum, Vreme, VrstaID, Tezina, JezeroID, RbrLokacije) VALUES (1, 1, '2002-03-12', '23:00:00', 1, '20kg', 1, 1), (1, 2, '2002-03-12', '23:00:00', 1, '20kg', 1, 1), (1, 3, '2002-03-12', '23:00:00', 1, '20kg', 1, 1), (1, 4, '2002-03-12', '23:00:00', 1, '20kg', 1, 1), (1, 5, '2002-03-12', '23:00:00', 1, '20kg', 1, 1), (1, 6, '2002-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 7, '2002-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 8, '2003-03-12', '23:00:00', 1, '20kg', 1, 1), (1, 9, '2003-03-12', '23:00:00', 1, '20kg', 1, 1), (1, 10, '2003-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 11, '2003-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 12, '2003-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 13, '2003-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 14, '2003-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 15, '2003-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 16, '2004-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 17, '2004-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 18, '2004-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 19, '2004-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 20, '2004-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 21, '2005-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 22, '2005-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 23, '2005-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 24, '2005-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 25, '2005-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 26, '2005-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 27, '2005-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 28, '2005-05-12', '23:00:00', 1, '20kg', 1, 1), (1, 29, '2006-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 30, '2006-04-12', '23:00:00', 1, '20kg', 1, 1), (1, 31, '2006-04-11', '23:00:00', 1, '20kg', 1, 1), (1, 32, '2006-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 33, '2006-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 34, '2006-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 35, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 36, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 37, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 38, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 39, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 40, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 41, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 42, '2007-04-12', '23:00:00', 2, '20kg', 1, 1), (1, 43, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 44, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 45, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 46, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 47, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 48, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 49, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 50, '2008-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 51, '2009-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 52, '2009-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 53, '2009-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 54, '2009-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 55, '2009-05-12', '23:00:00', 2, '20kg', 1, 1), (1, 56, '2009-06-12', '23:00:00', 2, '20kg', 1, 1), (1, 57, '2009-06-12', '23:00:00', 2, '20kg', 1, 1), (1, 58, '2010-06-12', '23:00:00', 2, '20kg', 1, 1), (1, 59, '2010-06-12', '23:00:00', 2, '20kg', 1, 1), (1, 60, '2010-06-12', '23:00:00', 2, '20kg', 1, 1), (1, 61, '2010-06-12', '23:00:00', 2, '20kg', 1, 1), (1, 62, '2010-07-12', '23:00:00', 3, '20kg', 1, 1), (1, 63, '2010-07-12', '23:00:00', 3, '20kg', 1, 1), (1, 64, '2010-07-12', '23:00:00', 3, '20kg', 1, 1), (1, 65, '2010-07-12', '23:00:00', 3, '20kg', 1, 1), (1, 66, '2010-07-12', '23:00:00', 3, '20kg', 1, 1), (1, 67, '2010-07-12', '23:00:00', 3, '20kg', 1, 1), (1, 68, '2010-07-12', '23:00:00', 3, '20kg', 1, 1), (1, 69, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 70, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 80, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 81, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 82, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 83, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 84, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 85, '2011-08-12', '23:00:00', 3, '20kg', 1, 1), (1, 86, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 87, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 88, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 89, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 90, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 91, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 92, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 93, '2012-09-12', '23:00:00', 3, '20kg', 1, 1), (1, 94, '2013-10-12', '23:00:00', 3, '20kg', 1, 1), (1, 95, '2013-10-12', '23:00:00', 3, '20kg', 1, 1), (1, 96, '2013-10-12', '23:00:00', 3, '20kg', 1, 1), (1, 97, '2013-10-12', '23:00:00', 3, '20kg', 1, 1), (1, 98, '2013-10-12', '23:00:00', 3, '20kg', 1, 1), (1, 99, '2014-01-12', '23:00:00', 3, '20kg', 1, 1), (1, 100, '2014-01-12', '23:00:00', 3, '20kg', 1, 1), (1, 101, '2014-01-11', '23:00:00', 3, '20kg', 1, 1), (1, 111, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 112, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 113, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 114, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 115, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 116, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 117, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 118, '2014-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 119, '2015-02-12', '23:00:00', 4, '20kg', 1, 1), (1, 120, '2015-03-12', '23:00:00', 4, '20kg', 1, 1), (1, 121, '2015-03-12', '23:00:00', 4, '20kg', 1, 1), (1, 122, '2015-03-12', '23:00:00', 4, '20kg', 1, 1), (1, 123, '2015-03-12', '23:00:00', 4, '20kg', 1, 1), (1, 124, '2015-03-12', '23:00:00', 4, '20kg', 1, 1), (1, 125, '2015-03-12', '23:00:00', 4, '20kg', 1, 1), (1, 126, '2015-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 127, '2015-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 128, '2015-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 129, '2015-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 130, '2015-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 131, '2015-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 132, '2016-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 133, '2016-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 134, '2016-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 135, '2016-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 136, '2016-04-12', '23:00:00', 4, '20kg', 1, 1), (1, 137, '2016-05-12', '23:00:00', 4, '20kg', 1, 1), (1, 138, '2016-05-12', '23:00:00', 4, '20kg', 1, 1), (1, 139, '2016-05-12', '23:00:00', 4, '20kg', 1, 1), (1, 140, '2016-05-12', '23:00:00', 4, '20kg', 1, 1), (1, 141, '2016-05-11', '23:00:00', 4, '20kg', 1, 1), (1, 142, '2016-05-12', '23:00:00', 4, '20kg', 1, 1), (1, 143, '2016-05-11', '23:00:00', 4, '20kg', 1, 1), (1, 151, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 152, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 153, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 154, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 155, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 156, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 157, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 158, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 159, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 160, '2017-06-12', '23:00:00', 5, '20kg', 1, 1), (1, 161, '2017-07-12', '23:00:00', 5, '20kg', 1, 1), (1, 162, '2018-07-12', '23:00:00', 5, '20kg', 1, 1), (1, 163, '2018-07-12', '23:00:00', 5, '20kg', 1, 1), (1, 164, '2018-07-12', '23:00:00', 5, '20kg', 1, 1), (1, 165, '2018-07-12', '23:00:00', 5, '20kg', 1, 1), (1, 166, '2018-07-12', '23:00:00', 5, '20kg', 1, 1), (1, 167, '2018-07-12', '23:00:00', 5, '20kg', 1, 1), (1, 168, '2018-08-12', '23:00:00', 5, '20kg', 1, 1), (1, 169, '2018-08-12', '23:00:00', 5, '20kg', 1, 1), (1, 170, '2018-08-12', '23:00:00', 5, '20kg', 1, 1), (1, 171, '2018-08-12', '23:00:00', 5, '20kg', 1, 1), (1, 172, '2018-08-12', '23:00:00', 5, '20kg', 1, 1), (1, 173, '2018-08-12', '23:00:00', 5, '20kg', 1, 1), (1, 174, '2018-09-12', '23:00:00', 5, '20kg', 1, 1), (1, 175, '2018-09-12', '23:00:00', 5, '20kg', 1, 1), (1, 176, '2018-09-12', '23:00:00', 5, '20kg', 1, 1), (1, 177, '2019-09-12', '23:00:00', 5, '20kg', 1, 1), (1, 178, '2019-09-12', '23:00:00', 5, '20kg', 1, 1), (1, 179, '2018-09-12', '23:00:00', 7, '20kg', 1, 1), (1, 180, '2019-01-12', '23:00:00', 7, '20kg', 1, 1), (1, 145, '2019-01-12', '23:00:00', 7, '20kg', 1, 1), (1, 181, '2019-01-12', '23:00:00', 6, '20kg', 1, 1), (1, 182, '2019-01-12', '23:00:00', 6, '20kg', 1, 1), (1, 183, '2019-01-12', '23:00:00', 6, '20kg', 1, 1), (1, 184, '2019-01-12', '23:00:00', 6, '20kg', 1, 1), (1, 185, '2019-01-12', '23:00:00', 6, '20kg', 1, 1), (1, 186, '2019-01-12', '23:00:00', 6, '20kg', 1, 1), (1, 187, '2019-02-12', '23:00:00', 6, '20kg', 1, 1), (1, 188, '2019-02-12', '23:00:00', 6, '20kg', 1, 1), (1, 189, '2019-02-12', '23:00:00', 6, '20kg', 1, 1), (1, 190, '2019-02-12', '23:00:00', 6, '20kg', 1, 1), (1, 191, '2019-03-12', '23:00:00', 6, '20kg', 1, 1), (1, 192, '2019-03-12', '23:00:00', 6, '20kg', 1, 1), (1, 193, '2019-03-12', '23:00:00', 6, '20kg', 1, 1), (1, 194, '2019-03-12', '23:00:00', 6, '20kg', 1, 1), (1, 195, '2019-04-12', '23:00:00', 6, '20kg', 1, 1), (1, 196, '2019-04-12', '23:00:00', 6, '20kg', 1, 1), (1, 197, '2019-04-12', '23:00:00', 6, '20kg', 1, 1), (1, 198, '2019-04-12', '23:00:00', 6, '20kg', 1, 1), (1, 199, '2019-05-12', '23:00:00', 6, '20kg', 1, 1), (1, 200, '2019-05-12', '23:00:00', 6, '20kg', 1, 1), (1, 201, '2020-05-12', '23:00:00', 6, '20kg', 1, 1), (1, 202, '2020-06-12', '23:00:00', 6, '20kg', 1, 1), (1, 203, '2020-06-12', '23:00:00', 6, '20kg', 1, 1), (1, 204, '2020-06-12', '23:00:00', 6, '20kg', 1, 1), (1, 205, '2020-06-12', '23:00:00', 6, '20kg', 1, 1), (1, 206, '2020-07-12', '23:00:00', 6, '20kg', 1, 1), (1, 207, '2020-07-12', '23:00:00', 6, '20kg', 1, 1), (1, 208, '2020-07-12', '23:00:00', 6, '20kg', 1, 1), (1, 209, '2020-07-12', '23:00:00', 6, '20kg', 1, 1), (1, 210, '2020-08-12', '23:00:00', 6, '20kg', 1, 1), (1, 211, '2020-08-11', '23:00:00', 6, '20kg', 1, 1), (1, 212, '2020-08-12', '23:00:00', 6, '20kg', 1, 1), (1, 221, '2020-08-12', '23:00:00', 7, '20kg', 1, 1), (1, 222, '2020-07-12', '23:00:00', 7, '20kg', 1, 1), (1, 223, '2020-07-12', '23:00:00', 7, '20kg', 1, 1), (1, 224, '2020-07-12', '23:00:00', 7, '20kg', 1, 1), (1, 225, '2020-07-12', '23:00:00', 7, '20kg', 1, 1), (1, 226, '2020-06-12', '23:00:00', 7, '20kg', 1, 1), (1, 227, '2020-06-12', '23:00:00', 7, '20kg', 1, 1), (1, 228, '2020-06-12', '23:00:00', 7, '20kg', 1, 1), (1, 229, '2020-03-12', '23:00:00', 7, '20kg', 1, 1), (1, 230, '2020-03-12', '23:00:00', 7, '20kg', 1, 1), (1, 231, '2021-04-12', '23:00:00', 7, '20kg', 1, 1), (1, 232, '2021-04-12', '23:00:00', 7, '20kg', 1, 1), (1, 233, '2021-05-12', '23:00:00', 7, '20kg', 1, 1), (1, 240, '2021-01-11', '23:00:00', 7, '20kg', 1, 1), (1, 241, '2021-01-11', '23:00:00', 7, '20kg', 1, 1), (1, 242, '2021-02-10', '23:00:00', 7, '20kg', 1, 1), (1, 243, '2021-02-10', '23:00:00', 7, '20kg', 1, 1), (1, 244, '2021-02-10', '23:00:00', 7, '20kg', 1, 1), (1, 245, '2021-02-10', '23:00:00', 7, '20kg', 1, 1), (1, 246, '2021-03-10', '23:00:00', 7, '20kg', 1, 1), (1, 247, '2021-03-10', '23:00:00', 7, '20kg', 1, 1), (1, 248, '2021-03-10', '23:00:00', 7, '20kg', 1, 1), (1, 249, '2021-03-10', '23:00:00', 7, '20kg', 1, 1), (1, 250, '2021-04-14', '23:00:00', 7, '20kg', 1, 1), (1, 251, '2021-04-16', '23:00:00', 7, '20kg', 1, 1), (1, 252, '2021-04-16', '23:00:00', 7, '20kg', 1, 1), (1, 253, '2021-04-17', '23:00:00', 7, '20kg', 1, 1), (1, 254, '2021-05-18', '23:00:00', 7, '20kg', 1, 1), (1, 255, '2021-05-01', '23:00:00', 7, '20kg', 1, 1), (1, 256, '2021-05-02', '23:00:00', 7, '20kg', 1, 1), (1, 257, '2021-05-03', '23:00:00', 7, '20kg', 1, 1), (1, 258, '2021-05-04', '23:00:00', 7, '20kg', 1, 1), (1, 259, '2021-05-05', '23:00:00', 7, '20kg', 1, 1);