

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