[GestionImmo]

Hi, Mathieu Hopmann and me developed an application based on magritte, pier and mysql. This application stores data in a mysql database. It allows the user to manage lease in flats with owners, town, building... You can just read the source code or configure everything to run it. If you just want to read the code, load 'Mysql Driver' from SqueakMap and GestionImmo from SqueakSource (http://www.squeaksource.com/GestionImmo). To make this application run, configure those things : 1) Install 'Mysql Driver' from SqueakMap 2) Install GestionImmo from SqueakSource http://www.squeaksource.com/GestionImmo 3) Create a new mysql database and load the two attached files 4) Because of a problem with Mysql Driver, if your mysql server is greater or equal to 4.1you should read http://dev.mysql.com/doc/refman/5.0/en/old-client.html 5) Define this new globals with your information : GIUser := 'username'. GIPasswd := 'password'. GIHost := 'localhost'. GIDataBase := 'databaseName'. GIPort := 3306. 6) Execute this : GISeasideInit initializePages. 7) Open your browser on : http://localhost:8080/seaside/pier/GestionImmo If you have any problem send me as many mails as you feel necessary. -- Damien CREATE TABLE TOWN ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL UNIQUE, PRIMARY KEY (Id) ); CREATE TABLE DISTRICT ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL UNIQUE, Town INT NOT NULL, PRIMARY KEY (Id), FOREIGN KEY (Town) REFERENCES TOWN(Id) ); CREATE TABLE BLOCK ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL UNIQUE, Address VARCHAR(30) NOT NULL, District INT NOT NULL, Build_date DATE NOT NULL, Repair_date DATE, Annual_rental_charges INT NOT NULL, Monthly_charges INT NOT NULL, PRIMARY KEY (Id), FOREIGN KEY (District) REFERENCES DISTRICT(Id) ); CREATE TABLE PERSON ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL, Firstname VARCHAR(20) NOT NULL, Birthday DATE NOT NULL, Phone_number VARCHAR(15), Address VARCHAR(30), Town INT, PRIMARY KEY (Id), FOREIGN KEY (Town) REFERENCES TOWN(Id) ); CREATE TABLE FLAT_TYPE ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL UNIQUE, PRIMARY KEY (Id) ); CREATE TABLE STATE ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL UNIQUE, PRIMARY KEY (Id) ); CREATE TABLE FLAT ( Id INT AUTO_INCREMENT, Number INT NOT NULL, Block INT NOT NULL, Type INT NOT NULL, Surface INT NOT NULL, State INT NOT NULL, Owner INT NOT NULL, Repair_date DATE, PRIMARY KEY (Id), FOREIGN KEY (Block) REFERENCES BLOCK(Id), FOREIGN KEY (Type) REFERENCES FLAT_TYPE(Id), FOREIGN KEY (State) REFERENCES STATE(Id), FOREIGN KEY (Owner) REFERENCES PERSON(Id), UNIQUE KEY (Number, Block) ); CREATE TABLE LEASE ( Id INT AUTO_INCREMENT, Flat INT NOT NULL, Monthly_charges INT NOT NULL, Signature_date DATE NOT NULL, Start_date DATE NOT NULL, End_date DATE NOT NULL, Bail INT NOT NULL, PRIMARY KEY (Id), FOREIGN KEY (Flat) REFERENCES FLAT(Id) ); CREATE TABLE LESSEE ( Person INT, PRIMARY KEY (Person), FOREIGN KEY (Person) REFERENCES PERSON(Id) ); CREATE TABLE RENTING ( Lessee INT, Lease INT, PRIMARY KEY (Lessee,Lease), FOREIGN KEY (Lessee) REFERENCES LESSEE(Person), FOREIGN KEY (Lease) REFERENCES LEASE(Id) ); CREATE TABLE PROFESSIONAL_FIELD ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL UNIQUE, PRIMARY KEY (Id) ); CREATE TABLE PROFESSIONAL_SITUATION ( Id INT AUTO_INCREMENT, Name VARCHAR(20) NOT NULL UNIQUE, PRIMARY KEY (Id) ); CREATE TABLE SIGNATORY ( Person INT, Prof_situation INT NOT NULL, Prof_field INT NOT NULL, Income INT NOT NULL, PRIMARY KEY (Person), FOREIGN KEY (Person) REFERENCES PERSON(Id), FOREIGN KEY (Prof_situation) REFERENCES PROFESSIONAL_SITUATION(Id), FOREIGN KEY (Prof_field) REFERENCES PROFESSIONAL_FIELD(Id) ); CREATE TABLE SIGNATURE ( Lease INT NOT NULL, Signatory INT NOT NULL, PRIMARY KEY (Lease,Signatory), FOREIGN KEY (Lease) REFERENCES LEASE(Id), FOREIGN KEY (Signatory) REFERENCES Signatory(Person) ); CREATE TABLE PAYMENT ( Id INT AUTO_INCREMENT, Lease INT NOT NULL, Date DATE NOT NULL, PRIMARY KEY (Id), FOREIGN KEY (Lease) REFERENCES LEASE(Id) ); -- -- Contenu de la table `LEASE` -- INSERT INTO `LEASE` VALUES (1, 3, 899, '2005-01-12', '2005-02-01', '2008-02-01', 2000); INSERT INTO `LEASE` VALUES (2, 4, 950, '2005-02-01', '2005-02-02', '2011-02-02', 2000); INSERT INTO `LEASE` VALUES (3, 1, 300, '2000-12-25', '2001-01-01', '2007-01-01', 600); INSERT INTO `LEASE` VALUES (4, 1, 250, '1995-05-26', '1995-06-01', '2000-06-01', 1000); INSERT INTO `LEASE` VALUES (5, 2, 350, '2001-07-31', '2001-08-15', '2010-08-15', 700); INSERT INTO `LEASE` VALUES (6, 5, 783, '2002-07-08', '2002-09-15', '2005-09-15', 1500); INSERT INTO `LEASE` VALUES (7, 6, 299, '2004-03-10', '2004-03-15', '2010-03-15', 600); INSERT INTO `LEASE` VALUES (8, 7, 314, '1999-09-13', '1999-10-01', '2008-10-01', 630); INSERT INTO `LEASE` VALUES (9, 8, 321, '2005-01-27', '2005-02-01', '2011-02-01', 650); INSERT INTO `LEASE` VALUES (10, 9, 488, '2000-12-21', '2001-01-01', '2004-01-01', 999); INSERT INTO `LEASE` VALUES (11, 10, 342, '2002-05-23', '2002-06-15', '2006-06-15', 685); INSERT INTO `LEASE` VALUES (12, 11, 432, '2000-09-12', '2000-09-15', '2003-09-15', 900); INSERT INTO `LEASE` VALUES (13, 12, 291, '2005-03-25', '2005-04-01', '2014-04-01', 600); INSERT INTO `LEASE` VALUES (14, 13, 798, '2004-08-23', '2004-09-15', '2010-09-15', 1500); INSERT INTO `LEASE` VALUES (15, 14, 452, '2003-06-25', '2003-07-01', '2006-07-01', 999); INSERT INTO `LEASE` VALUES (16, 15, 199, '2000-10-11', '2000-11-15', '2006-11-15', 410); INSERT INTO `LEASE` VALUES (17, 16, 755, '2003-01-12', '2003-02-01', '2012-02-01', 1650); INSERT INTO `LEASE` VALUES (18, 17, 975, '2004-11-05', '2004-11-15', '2007-11-15', 1999); INSERT INTO `LEASE` VALUES (19, 18, 1199, '2005-03-30', '2005-04-15', '2014-04-15', 2399); INSERT INTO `LEASE` VALUES (20, 19, 990, '2004-02-20', '2004-03-01', '2013-03-01', 1899); INSERT INTO `LEASE` VALUES (21, 20, 799, '2001-05-11', '2001-06-15', '2007-06-15', 1650); INSERT INTO `LEASE` VALUES (22, 21, 1290, '2005-10-23', '2005-11-01', '2008-11-01', 2305); INSERT INTO `LEASE` VALUES (23, 15, 155, '1992-06-30', '1992-07-01', '2000-07-01', 299); INSERT INTO `LEASE` VALUES (38, 1, 123, '2016-02-28', '2016-03-12', '2021-03-12', 321); INSERT INTO `LEASE` VALUES (39, 30, 1200, '2005-01-12', '2005-01-20', '2011-01-20', 5000); INSERT INTO `LEASE` VALUES (40, 29, 2000, '2005-03-31', '2005-03-31', '2011-03-31', 6500); -- -- Contenu de la table `PROFESSIONAL_FIELD` -- INSERT INTO `PROFESSIONAL_FIELD` VALUES (1, 'Agriculture'); INSERT INTO `PROFESSIONAL_FIELD` VALUES (2, 'Education'); INSERT INTO `PROFESSIONAL_FIELD` VALUES (3, 'Computer Science'); INSERT INTO `PROFESSIONAL_FIELD` VALUES (4, 'Bakery'); INSERT INTO `PROFESSIONAL_FIELD` VALUES (5, 'Music'); -- -- Contenu de la table `STATE` -- INSERT INTO `STATE` VALUES (1, 'decayed'); INSERT INTO `STATE` VALUES (2, 'to be renovated'); INSERT INTO `STATE` VALUES (3, 'good'); INSERT INTO `STATE` VALUES (4, 'new'); -- -- Contenu de la table `BLOCK` -- INSERT INTO `BLOCK` VALUES (3, 'Andromede', 'street des rapaces', 5, '1960-10-31', '1998-05-28', 157000, 65); INSERT INTO `BLOCK` VALUES (4, 'Aigle', 'street des rapaces', 5, '2001-06-10', NULL, 110000, 83); INSERT INTO `BLOCK` VALUES (5, 'Bouvier', '12 allee Gustave Fauves', 6, '1960-08-12', '2005-09-10', 174300, 65); INSERT INTO `BLOCK` VALUES (6, 'Cassiopee', '32 avenue B. Rongeur', 3, '2004-01-31', NULL, 75350, 100); INSERT INTO `BLOCK` VALUES (7, 'Gemini', '44 avenue du Cap', 6, '1979-03-18', '1992-05-21', 99284, 88); INSERT INTO `BLOCK` VALUES (8, 'Centaurus', '375 avenue du Cap', 6, '1982-12-08', '2001-02-11', 102081, 111); INSERT INTO `BLOCK` VALUES (9, 'Phoenix', '51 boulevard Damien Frelon', 3, '1965-04-12', '1989-08-24', 99321, 98); INSERT INTO `BLOCK` VALUES (10, 'Virgo', '64 avenue B. Rongeur', 3, '1992-04-06', NULL, 59272, 71); INSERT INTO `BLOCK` VALUES (11, 'Tucana', '71 street des Heritiers', 2, '1994-02-21', '2000-03-01', 224781, 239); INSERT INTO `BLOCK` VALUES (12, 'Vela', '2 avenue B. Gates', 2, '1999-12-30', NULL, 201753, 199); INSERT INTO `BLOCK` VALUES (13, 'Pegaze', 'street des miliardaires', 7, '2002-01-10', '2005-06-23', 500000, 750); -- -- Contenu de la table `LESSEE` -- INSERT INTO `LESSEE` VALUES (1); INSERT INTO `LESSEE` VALUES (2); INSERT INTO `LESSEE` VALUES (4); INSERT INTO `LESSEE` VALUES (5); INSERT INTO `LESSEE` VALUES (6); INSERT INTO `LESSEE` VALUES (7); INSERT INTO `LESSEE` VALUES (8); INSERT INTO `LESSEE` VALUES (10); INSERT INTO `LESSEE` VALUES (11); INSERT INTO `LESSEE` VALUES (12); INSERT INTO `LESSEE` VALUES (13); INSERT INTO `LESSEE` VALUES (14); INSERT INTO `LESSEE` VALUES (17); INSERT INTO `LESSEE` VALUES (19); INSERT INTO `LESSEE` VALUES (20); INSERT INTO `LESSEE` VALUES (21); INSERT INTO `LESSEE` VALUES (22); -- -- Contenu de la table `RENTING` -- INSERT INTO `RENTING` VALUES (1, 1); INSERT INTO `RENTING` VALUES (1, 2); INSERT INTO `RENTING` VALUES (1, 7); INSERT INTO `RENTING` VALUES (1, 39); INSERT INTO `RENTING` VALUES (2, 2); INSERT INTO `RENTING` VALUES (2, 18); INSERT INTO `RENTING` VALUES (2, 40); INSERT INTO `RENTING` VALUES (4, 3); INSERT INTO `RENTING` VALUES (4, 22); INSERT INTO `RENTING` VALUES (5, 4); INSERT INTO `RENTING` VALUES (5, 21); INSERT INTO `RENTING` VALUES (6, 3); INSERT INTO `RENTING` VALUES (6, 22); INSERT INTO `RENTING` VALUES (6, 38); INSERT INTO `RENTING` VALUES (7, 17); INSERT INTO `RENTING` VALUES (7, 19); INSERT INTO `RENTING` VALUES (8, 11); INSERT INTO `RENTING` VALUES (10, 1); INSERT INTO `RENTING` VALUES (10, 5); INSERT INTO `RENTING` VALUES (10, 13); INSERT INTO `RENTING` VALUES (11, 6); INSERT INTO `RENTING` VALUES (11, 14); INSERT INTO `RENTING` VALUES (12, 2); INSERT INTO `RENTING` VALUES (12, 15); INSERT INTO `RENTING` VALUES (13, 7); INSERT INTO `RENTING` VALUES (13, 16); INSERT INTO `RENTING` VALUES (14, 8); INSERT INTO `RENTING` VALUES (17, 9); INSERT INTO `RENTING` VALUES (19, 10); INSERT INTO `RENTING` VALUES (20, 20); INSERT INTO `RENTING` VALUES (21, 20); INSERT INTO `RENTING` VALUES (22, 20); -- -- Contenu de la table `FLAT` -- INSERT INTO `FLAT` VALUES (1, 1, 3, 2, 50, 1, 1, '1995-05-12'); INSERT INTO `FLAT` VALUES (2, 2, 3, 2, 55, 2, 1, '1995-06-11'); INSERT INTO `FLAT` VALUES (3, 1, 6, 4, 85, 4, 7, NULL); INSERT INTO `FLAT` VALUES (4, 2, 6, 5, 102, 4, 9, NULL); INSERT INTO `FLAT` VALUES (5, 3, 6, 4, 79, 3, 1, NULL); INSERT INTO `FLAT` VALUES (6, 101, 4, 1, 25, 3, 16, NULL); INSERT INTO `FLAT` VALUES (7, 102, 4, 1, 30, 3, 16, NULL); INSERT INTO `FLAT` VALUES (8, 1, 5, 6, 28, 4, 7, '2005-09-19'); INSERT INTO `FLAT` VALUES (9, 2, 5, 3, 63, 2, 9, '1984-07-08'); INSERT INTO `FLAT` VALUES (10, 101, 7, 2, 35, 3, 3, '1994-11-16'); INSERT INTO `FLAT` VALUES (11, 201, 7, 3, 44, 1, 3, '1988-07-03'); INSERT INTO `FLAT` VALUES (12, 101, 8, 6, 19, 3, 9, '1999-01-22'); INSERT INTO `FLAT` VALUES (13, 102, 8, 4, 72, 4, 16, '2005-04-30'); INSERT INTO `FLAT` VALUES (14, 1, 9, 3, 57, 1, 7, '1989-09-11'); INSERT INTO `FLAT` VALUES (15, 2, 9, 1, 16, 2, 7, '1978-02-21'); INSERT INTO `FLAT` VALUES (16, 201, 10, 4, 69, 3, 15, NULL); INSERT INTO `FLAT` VALUES (17, 202, 10, 5, 89, 4, 15, '2004-10-12'); INSERT INTO `FLAT` VALUES (18, 101, 11, 5, 105, 4, 18, '2004-05-31'); INSERT INTO `FLAT` VALUES (19, 102, 11, 5, 99, 4, 18, '2003-03-02'); INSERT INTO `FLAT` VALUES (20, 1, 12, 6, 71, 3, 1, NULL); INSERT INTO `FLAT` VALUES (21, 2, 12, 5, 122, 3, 3, NULL); INSERT INTO `FLAT` VALUES (28, 666, 12, 6, 666, 1, 1, NULL); INSERT INTO `FLAT` VALUES (29, 1003, 13, 5, 90, 4, 3, '2005-02-02'); INSERT INTO `FLAT` VALUES (30, 1002, 13, 5, 70, 4, 3, '2005-01-31'); -- -- Contenu de la table `PAYMENT` -- INSERT INTO `PAYMENT` VALUES (843, 1, '2005-02-09'); INSERT INTO `PAYMENT` VALUES (7, 1, '2005-03-09'); INSERT INTO `PAYMENT` VALUES (8, 1, '2005-04-10'); INSERT INTO `PAYMENT` VALUES (9, 1, '2005-05-08'); INSERT INTO `PAYMENT` VALUES (10, 1, '2005-06-08'); INSERT INTO `PAYMENT` VALUES (11, 1, '2005-07-07'); INSERT INTO `PAYMENT` VALUES (12, 1, '2005-08-07'); INSERT INTO `PAYMENT` VALUES (13, 1, '2005-09-05'); INSERT INTO `PAYMENT` VALUES (14, 1, '2005-10-05'); INSERT INTO `PAYMENT` VALUES (15, 1, '2005-11-04'); INSERT INTO `PAYMENT` VALUES (16, 2, '2005-02-02'); INSERT INTO `PAYMENT` VALUES (17, 2, '2005-03-01'); INSERT INTO `PAYMENT` VALUES (18, 2, '2005-04-01'); INSERT INTO `PAYMENT` VALUES (19, 2, '2005-05-09'); INSERT INTO `PAYMENT` VALUES (20, 2, '2005-06-10'); INSERT INTO `PAYMENT` VALUES (21, 2, '2005-07-08'); INSERT INTO `PAYMENT` VALUES (22, 2, '2005-08-08'); INSERT INTO `PAYMENT` VALUES (23, 2, '2005-09-07'); INSERT INTO `PAYMENT` VALUES (24, 2, '2005-10-05'); INSERT INTO `PAYMENT` VALUES (25, 2, '2005-11-06'); INSERT INTO `PAYMENT` VALUES (26, 3, '2001-01-09'); INSERT INTO `PAYMENT` VALUES (27, 3, '2001-02-09'); INSERT INTO `PAYMENT` VALUES (28, 3, '2001-03-08'); INSERT INTO `PAYMENT` VALUES (29, 3, '2001-04-08'); INSERT INTO `PAYMENT` VALUES (30, 3, '2001-05-06'); INSERT INTO `PAYMENT` VALUES (31, 3, '2001-06-06'); INSERT INTO `PAYMENT` VALUES (32, 3, '2001-07-05'); INSERT INTO `PAYMENT` VALUES (33, 3, '2001-08-05'); INSERT INTO `PAYMENT` VALUES (34, 3, '2001-09-05'); INSERT INTO `PAYMENT` VALUES (35, 3, '2001-10-04'); INSERT INTO `PAYMENT` VALUES (36, 3, '2001-11-04'); INSERT INTO `PAYMENT` VALUES (37, 3, '2001-12-02'); INSERT INTO `PAYMENT` VALUES (38, 3, '2002-01-03'); INSERT INTO `PAYMENT` VALUES (39, 3, '2002-02-01'); INSERT INTO `PAYMENT` VALUES (40, 3, '2002-03-01'); INSERT INTO `PAYMENT` VALUES (41, 3, '2002-04-10'); INSERT INTO `PAYMENT` VALUES (42, 3, '2002-05-10'); INSERT INTO `PAYMENT` VALUES (43, 3, '2002-06-08'); INSERT INTO `PAYMENT` VALUES (44, 3, '2002-07-08'); INSERT INTO `PAYMENT` VALUES (45, 3, '2002-08-07'); INSERT INTO `PAYMENT` VALUES (46, 3, '2002-09-07'); INSERT INTO `PAYMENT` VALUES (47, 3, '2002-10-05'); INSERT INTO `PAYMENT` VALUES (48, 3, '2002-11-06'); INSERT INTO `PAYMENT` VALUES (49, 3, '2002-12-04'); INSERT INTO `PAYMENT` VALUES (50, 3, '2003-01-03'); INSERT INTO `PAYMENT` VALUES (51, 3, '2003-02-03'); INSERT INTO `PAYMENT` VALUES (52, 3, '2003-03-01'); INSERT INTO `PAYMENT` VALUES (53, 3, '2003-04-02'); INSERT INTO `PAYMENT` VALUES (54, 3, '2003-05-10'); INSERT INTO `PAYMENT` VALUES (55, 3, '2003-06-10'); INSERT INTO `PAYMENT` VALUES (56, 3, '2003-07-08'); INSERT INTO `PAYMENT` VALUES (57, 3, '2003-08-09'); INSERT INTO `PAYMENT` VALUES (58, 3, '2003-09-07'); INSERT INTO `PAYMENT` VALUES (59, 3, '2003-10-07'); INSERT INTO `PAYMENT` VALUES (60, 3, '2003-11-06'); INSERT INTO `PAYMENT` VALUES (61, 3, '2003-12-06'); INSERT INTO `PAYMENT` VALUES (62, 3, '2004-01-04'); INSERT INTO `PAYMENT` VALUES (63, 3, '2004-02-05'); INSERT INTO `PAYMENT` VALUES (64, 3, '2004-03-03'); INSERT INTO `PAYMENT` VALUES (65, 3, '2004-04-03'); INSERT INTO `PAYMENT` VALUES (66, 3, '2004-05-02'); INSERT INTO `PAYMENT` VALUES (67, 3, '2004-06-02'); INSERT INTO `PAYMENT` VALUES (68, 3, '2004-07-02'); INSERT INTO `PAYMENT` VALUES (69, 3, '2004-08-10'); INSERT INTO `PAYMENT` VALUES (70, 3, '2004-09-01'); INSERT INTO `PAYMENT` VALUES (71, 3, '2004-10-09'); INSERT INTO `PAYMENT` VALUES (72, 3, '2004-11-09'); INSERT INTO `PAYMENT` VALUES (73, 3, '2004-12-08'); INSERT INTO `PAYMENT` VALUES (74, 3, '2005-01-08'); INSERT INTO `PAYMENT` VALUES (75, 3, '2005-02-06'); INSERT INTO `PAYMENT` VALUES (76, 3, '2005-03-07'); INSERT INTO `PAYMENT` VALUES (77, 3, '2005-04-05'); INSERT INTO `PAYMENT` VALUES (78, 3, '2005-05-05'); INSERT INTO `PAYMENT` VALUES (79, 3, '2005-06-03'); INSERT INTO `PAYMENT` VALUES (80, 3, '2005-07-04'); INSERT INTO `PAYMENT` VALUES (81, 3, '2005-08-02'); INSERT INTO `PAYMENT` VALUES (82, 3, '2005-09-02'); INSERT INTO `PAYMENT` VALUES (83, 3, '2005-10-01'); INSERT INTO `PAYMENT` VALUES (85, 4, '1995-06-08'); INSERT INTO `PAYMENT` VALUES (86, 4, '1995-07-06'); INSERT INTO `PAYMENT` VALUES (87, 4, '1995-08-07'); INSERT INTO `PAYMENT` VALUES (88, 4, '1995-09-05'); INSERT INTO `PAYMENT` VALUES (89, 4, '1995-10-05'); INSERT INTO `PAYMENT` VALUES (90, 4, '1995-11-04'); INSERT INTO `PAYMENT` VALUES (91, 4, '1995-12-04'); INSERT INTO `PAYMENT` VALUES (92, 4, '1996-01-02'); INSERT INTO `PAYMENT` VALUES (93, 4, '1996-02-03'); INSERT INTO `PAYMENT` VALUES (94, 4, '1996-03-01'); INSERT INTO `PAYMENT` VALUES (95, 4, '1996-04-01'); INSERT INTO `PAYMENT` VALUES (96, 4, '1996-05-09'); INSERT INTO `PAYMENT` VALUES (97, 4, '1996-06-10'); INSERT INTO `PAYMENT` VALUES (98, 4, '1996-07-08'); INSERT INTO `PAYMENT` VALUES (99, 4, '1996-08-08'); INSERT INTO `PAYMENT` VALUES (100, 4, '1996-09-07'); INSERT INTO `PAYMENT` VALUES (101, 4, '1996-10-07'); INSERT INTO `PAYMENT` VALUES (102, 4, '1996-11-05'); INSERT INTO `PAYMENT` VALUES (103, 4, '1996-12-06'); INSERT INTO `PAYMENT` VALUES (104, 4, '1997-01-04'); INSERT INTO `PAYMENT` VALUES (105, 4, '1997-02-04'); INSERT INTO `PAYMENT` VALUES (106, 4, '1997-03-03'); INSERT INTO `PAYMENT` VALUES (107, 4, '1997-04-03'); INSERT INTO `PAYMENT` VALUES (108, 4, '1997-05-01'); INSERT INTO `PAYMENT` VALUES (109, 4, '1997-06-10'); INSERT INTO `PAYMENT` VALUES (110, 4, '1997-07-10'); INSERT INTO `PAYMENT` VALUES (111, 4, '1997-08-10'); INSERT INTO `PAYMENT` VALUES (112, 4, '1997-09-09'); INSERT INTO `PAYMENT` VALUES (113, 4, '1997-10-09'); INSERT INTO `PAYMENT` VALUES (114, 4, '1997-11-07'); INSERT INTO `PAYMENT` VALUES (115, 4, '1997-12-08'); INSERT INTO `PAYMENT` VALUES (116, 4, '1998-01-06'); INSERT INTO `PAYMENT` VALUES (117, 4, '1998-02-06'); INSERT INTO `PAYMENT` VALUES (118, 4, '1998-03-04'); INSERT INTO `PAYMENT` VALUES (119, 4, '1998-04-05'); INSERT INTO `PAYMENT` VALUES (120, 4, '1998-05-03'); INSERT INTO `PAYMENT` VALUES (121, 4, '1998-06-03'); INSERT INTO `PAYMENT` VALUES (122, 4, '1998-07-02'); INSERT INTO `PAYMENT` VALUES (123, 4, '1998-08-02'); INSERT INTO `PAYMENT` VALUES (124, 4, '1998-09-10'); INSERT INTO `PAYMENT` VALUES (125, 4, '1998-10-01'); INSERT INTO `PAYMENT` VALUES (126, 4, '1998-11-09'); INSERT INTO `PAYMENT` VALUES (127, 4, '1998-12-09'); INSERT INTO `PAYMENT` VALUES (128, 4, '1999-01-08'); INSERT INTO `PAYMENT` VALUES (129, 4, '1999-02-08'); INSERT INTO `PAYMENT` VALUES (130, 4, '1999-03-06'); INSERT INTO `PAYMENT` VALUES (131, 4, '1999-04-06'); INSERT INTO `PAYMENT` VALUES (132, 4, '1999-05-05'); INSERT INTO `PAYMENT` VALUES (133, 4, '1999-06-05'); INSERT INTO `PAYMENT` VALUES (134, 4, '1999-07-03'); INSERT INTO `PAYMENT` VALUES (135, 4, '1999-08-04'); INSERT INTO `PAYMENT` VALUES (136, 4, '1999-09-02'); INSERT INTO `PAYMENT` VALUES (137, 4, '1999-10-02'); INSERT INTO `PAYMENT` VALUES (138, 4, '1999-11-01'); INSERT INTO `PAYMENT` VALUES (139, 4, '1999-12-01'); INSERT INTO `PAYMENT` VALUES (140, 4, '2000-01-09'); INSERT INTO `PAYMENT` VALUES (141, 4, '2000-02-10'); INSERT INTO `PAYMENT` VALUES (142, 4, '2000-03-08'); INSERT INTO `PAYMENT` VALUES (143, 4, '2000-04-08'); INSERT INTO `PAYMENT` VALUES (158, 5, '2001-09-09'); INSERT INTO `PAYMENT` VALUES (159, 5, '2001-10-08'); INSERT INTO `PAYMENT` VALUES (160, 5, '2001-11-08'); INSERT INTO `PAYMENT` VALUES (161, 5, '2001-12-06'); INSERT INTO `PAYMENT` VALUES (162, 5, '2002-01-07'); INSERT INTO `PAYMENT` VALUES (163, 5, '2002-02-05'); INSERT INTO `PAYMENT` VALUES (164, 5, '2002-03-05'); INSERT INTO `PAYMENT` VALUES (165, 5, '2002-04-04'); INSERT INTO `PAYMENT` VALUES (166, 5, '2002-05-04'); INSERT INTO `PAYMENT` VALUES (167, 5, '2002-06-02'); INSERT INTO `PAYMENT` VALUES (168, 5, '2002-07-03'); INSERT INTO `PAYMENT` VALUES (169, 5, '2002-08-03'); INSERT INTO `PAYMENT` VALUES (170, 5, '2002-09-01'); INSERT INTO `PAYMENT` VALUES (171, 5, '2002-10-01'); INSERT INTO `PAYMENT` VALUES (172, 5, '2002-11-10'); INSERT INTO `PAYMENT` VALUES (173, 5, '2002-12-10'); INSERT INTO `PAYMENT` VALUES (174, 5, '2003-01-08'); INSERT INTO `PAYMENT` VALUES (175, 5, '2003-02-09'); INSERT INTO `PAYMENT` VALUES (176, 5, '2003-03-07'); INSERT INTO `PAYMENT` VALUES (177, 5, '2003-04-07'); INSERT INTO `PAYMENT` VALUES (178, 5, '2003-05-06'); INSERT INTO `PAYMENT` VALUES (179, 5, '2003-06-06'); INSERT INTO `PAYMENT` VALUES (180, 5, '2003-07-04'); INSERT INTO `PAYMENT` VALUES (181, 5, '2003-08-04'); INSERT INTO `PAYMENT` VALUES (182, 5, '2003-09-03'); INSERT INTO `PAYMENT` VALUES (183, 5, '2003-10-03'); INSERT INTO `PAYMENT` VALUES (184, 5, '2003-11-01'); INSERT INTO `PAYMENT` VALUES (185, 5, '2003-12-02'); INSERT INTO `PAYMENT` VALUES (186, 5, '2004-01-10'); INSERT INTO `PAYMENT` VALUES (187, 5, '2004-02-10'); INSERT INTO `PAYMENT` VALUES (188, 5, '2004-03-09'); INSERT INTO `PAYMENT` VALUES (189, 5, '2004-04-09'); INSERT INTO `PAYMENT` VALUES (190, 5, '2004-05-07'); INSERT INTO `PAYMENT` VALUES (191, 5, '2004-06-08'); INSERT INTO `PAYMENT` VALUES (192, 5, '2004-07-06'); INSERT INTO `PAYMENT` VALUES (193, 5, '2004-08-06'); INSERT INTO `PAYMENT` VALUES (194, 5, '2004-09-04'); INSERT INTO `PAYMENT` VALUES (195, 5, '2004-10-05'); INSERT INTO `PAYMENT` VALUES (196, 5, '2004-11-03'); INSERT INTO `PAYMENT` VALUES (197, 5, '2004-12-03'); INSERT INTO `PAYMENT` VALUES (198, 5, '2005-01-02'); INSERT INTO `PAYMENT` VALUES (199, 5, '2005-02-02'); INSERT INTO `PAYMENT` VALUES (200, 5, '2005-03-10'); INSERT INTO `PAYMENT` VALUES (201, 5, '2005-04-01'); INSERT INTO `PAYMENT` VALUES (202, 5, '2005-05-09'); INSERT INTO `PAYMENT` VALUES (203, 5, '2005-06-09'); INSERT INTO `PAYMENT` VALUES (204, 5, '2005-07-10'); INSERT INTO `PAYMENT` VALUES (205, 5, '2005-08-08'); INSERT INTO `PAYMENT` VALUES (206, 5, '2005-09-08'); INSERT INTO `PAYMENT` VALUES (207, 5, '2005-10-06'); INSERT INTO `PAYMENT` VALUES (841, 6, '2005-09-03'); INSERT INTO `PAYMENT` VALUES (209, 6, '2002-10-05'); INSERT INTO `PAYMENT` VALUES (210, 6, '2002-11-05'); INSERT INTO `PAYMENT` VALUES (211, 6, '2002-12-04'); INSERT INTO `PAYMENT` VALUES (212, 6, '2003-01-04'); INSERT INTO `PAYMENT` VALUES (213, 6, '2003-02-02'); INSERT INTO `PAYMENT` VALUES (214, 6, '2003-03-03'); INSERT INTO `PAYMENT` VALUES (215, 6, '2003-04-01'); INSERT INTO `PAYMENT` VALUES (216, 6, '2003-05-01'); INSERT INTO `PAYMENT` VALUES (217, 6, '2003-06-09'); INSERT INTO `PAYMENT` VALUES (218, 6, '2003-07-10'); INSERT INTO `PAYMENT` VALUES (219, 6, '2003-08-08'); INSERT INTO `PAYMENT` VALUES (220, 6, '2003-09-08'); INSERT INTO `PAYMENT` VALUES (221, 6, '2003-10-07'); INSERT INTO `PAYMENT` VALUES (222, 6, '2003-11-07'); INSERT INTO `PAYMENT` VALUES (223, 6, '2003-12-05'); INSERT INTO `PAYMENT` VALUES (224, 6, '2004-01-06'); INSERT INTO `PAYMENT` VALUES (225, 6, '2004-02-04'); INSERT INTO `PAYMENT` VALUES (226, 6, '2004-03-04'); INSERT INTO `PAYMENT` VALUES (227, 6, '2004-04-01'); INSERT INTO `PAYMENT` VALUES (228, 6, '2004-05-01'); INSERT INTO `PAYMENT` VALUES (229, 6, '2004-06-10'); INSERT INTO `PAYMENT` VALUES (230, 6, '2004-07-10'); INSERT INTO `PAYMENT` VALUES (231, 6, '2004-08-08'); INSERT INTO `PAYMENT` VALUES (232, 6, '2004-09-09'); INSERT INTO `PAYMENT` VALUES (233, 6, '2004-10-09'); INSERT INTO `PAYMENT` VALUES (234, 6, '2004-11-07'); INSERT INTO `PAYMENT` VALUES (235, 6, '2004-12-08'); INSERT INTO `PAYMENT` VALUES (236, 6, '2005-01-06'); INSERT INTO `PAYMENT` VALUES (237, 6, '2005-02-06'); INSERT INTO `PAYMENT` VALUES (238, 6, '2005-03-05'); INSERT INTO `PAYMENT` VALUES (239, 6, '2005-04-05'); INSERT INTO `PAYMENT` VALUES (240, 6, '2005-05-03'); INSERT INTO `PAYMENT` VALUES (241, 6, '2005-06-03'); INSERT INTO `PAYMENT` VALUES (242, 6, '2005-07-02'); INSERT INTO `PAYMENT` VALUES (243, 6, '2005-08-02'); INSERT INTO `PAYMENT` VALUES (420, 11, '2003-06-02'); INSERT INTO `PAYMENT` VALUES (247, 7, '2004-04-07'); INSERT INTO `PAYMENT` VALUES (248, 7, '2004-05-08'); INSERT INTO `PAYMENT` VALUES (249, 7, '2004-06-06'); INSERT INTO `PAYMENT` VALUES (250, 7, '2004-07-06'); INSERT INTO `PAYMENT` VALUES (251, 7, '2004-08-05'); INSERT INTO `PAYMENT` VALUES (252, 7, '2004-09-05'); INSERT INTO `PAYMENT` VALUES (253, 7, '2004-10-03'); INSERT INTO `PAYMENT` VALUES (254, 7, '2004-11-04'); INSERT INTO `PAYMENT` VALUES (255, 7, '2004-12-02'); INSERT INTO `PAYMENT` VALUES (256, 7, '2005-01-02'); INSERT INTO `PAYMENT` VALUES (257, 7, '2005-02-01'); INSERT INTO `PAYMENT` VALUES (258, 7, '2005-03-01'); INSERT INTO `PAYMENT` VALUES (259, 7, '2005-04-09'); INSERT INTO `PAYMENT` VALUES (260, 7, '2005-05-09'); INSERT INTO `PAYMENT` VALUES (261, 7, '2005-06-08'); INSERT INTO `PAYMENT` VALUES (262, 7, '2005-07-08'); INSERT INTO `PAYMENT` VALUES (263, 7, '2005-08-05'); INSERT INTO `PAYMENT` VALUES (264, 7, '2005-09-05'); INSERT INTO `PAYMENT` VALUES (265, 7, '2005-10-04'); INSERT INTO `PAYMENT` VALUES (266, 8, '1999-10-07'); INSERT INTO `PAYMENT` VALUES (267, 8, '1999-11-06'); INSERT INTO `PAYMENT` VALUES (268, 8, '1999-12-06'); INSERT INTO `PAYMENT` VALUES (269, 8, '2000-01-04'); INSERT INTO `PAYMENT` VALUES (270, 8, '2000-02-05'); INSERT INTO `PAYMENT` VALUES (271, 8, '2000-03-03'); INSERT INTO `PAYMENT` VALUES (272, 8, '2000-04-03'); INSERT INTO `PAYMENT` VALUES (273, 8, '2000-05-01'); INSERT INTO `PAYMENT` VALUES (274, 8, '2000-06-02'); INSERT INTO `PAYMENT` VALUES (275, 8, '2000-07-10'); INSERT INTO `PAYMENT` VALUES (276, 8, '2000-08-10'); INSERT INTO `PAYMENT` VALUES (277, 8, '2000-09-09'); INSERT INTO `PAYMENT` VALUES (278, 8, '2000-10-09'); INSERT INTO `PAYMENT` VALUES (279, 8, '2000-11-07'); INSERT INTO `PAYMENT` VALUES (280, 8, '2000-12-08'); INSERT INTO `PAYMENT` VALUES (281, 8, '2001-01-06'); INSERT INTO `PAYMENT` VALUES (282, 8, '2001-02-06'); INSERT INTO `PAYMENT` VALUES (283, 8, '2001-03-05'); INSERT INTO `PAYMENT` VALUES (284, 8, '2001-04-03'); INSERT INTO `PAYMENT` VALUES (285, 8, '2001-05-04'); INSERT INTO `PAYMENT` VALUES (286, 8, '2001-06-02'); INSERT INTO `PAYMENT` VALUES (287, 8, '2001-07-02'); INSERT INTO `PAYMENT` VALUES (288, 8, '2001-08-01'); INSERT INTO `PAYMENT` VALUES (289, 8, '2001-09-01'); INSERT INTO `PAYMENT` VALUES (290, 8, '2001-10-09'); INSERT INTO `PAYMENT` VALUES (291, 8, '2001-11-10'); INSERT INTO `PAYMENT` VALUES (292, 8, '2001-12-08'); INSERT INTO `PAYMENT` VALUES (293, 8, '2002-01-08'); INSERT INTO `PAYMENT` VALUES (294, 8, '2002-02-07'); INSERT INTO `PAYMENT` VALUES (295, 8, '2002-03-07'); INSERT INTO `PAYMENT` VALUES (296, 8, '2002-04-05'); INSERT INTO `PAYMENT` VALUES (297, 8, '2002-05-05'); INSERT INTO `PAYMENT` VALUES (298, 8, '2002-06-04'); INSERT INTO `PAYMENT` VALUES (299, 8, '2002-07-04'); INSERT INTO `PAYMENT` VALUES (300, 8, '2002-08-02'); INSERT INTO `PAYMENT` VALUES (301, 8, '2002-09-03'); INSERT INTO `PAYMENT` VALUES (302, 8, '2002-10-01'); INSERT INTO `PAYMENT` VALUES (303, 8, '2002-11-01'); INSERT INTO `PAYMENT` VALUES (304, 8, '2002-12-10'); INSERT INTO `PAYMENT` VALUES (305, 8, '2003-01-10'); INSERT INTO `PAYMENT` VALUES (306, 8, '2003-02-08'); INSERT INTO `PAYMENT` VALUES (307, 8, '2003-03-09'); INSERT INTO `PAYMENT` VALUES (308, 8, '2003-04-07'); INSERT INTO `PAYMENT` VALUES (309, 8, '2003-05-07'); INSERT INTO `PAYMENT` VALUES (310, 8, '2003-06-05'); INSERT INTO `PAYMENT` VALUES (311, 8, '2003-07-06'); INSERT INTO `PAYMENT` VALUES (312, 8, '2003-08-04'); INSERT INTO `PAYMENT` VALUES (313, 8, '2003-09-04'); INSERT INTO `PAYMENT` VALUES (314, 8, '2003-10-03'); INSERT INTO `PAYMENT` VALUES (315, 8, '2003-11-03'); INSERT INTO `PAYMENT` VALUES (316, 8, '2003-12-01'); INSERT INTO `PAYMENT` VALUES (317, 8, '2004-01-02'); INSERT INTO `PAYMENT` VALUES (318, 8, '2004-02-02'); INSERT INTO `PAYMENT` VALUES (319, 8, '2004-03-10'); INSERT INTO `PAYMENT` VALUES (320, 8, '2004-04-10'); INSERT INTO `PAYMENT` VALUES (321, 8, '2004-05-09'); INSERT INTO `PAYMENT` VALUES (322, 8, '2004-06-09'); INSERT INTO `PAYMENT` VALUES (323, 8, '2004-07-07'); INSERT INTO `PAYMENT` VALUES (324, 8, '2004-08-08'); INSERT INTO `PAYMENT` VALUES (325, 8, '2004-09-06'); INSERT INTO `PAYMENT` VALUES (326, 8, '2004-10-06'); INSERT INTO `PAYMENT` VALUES (327, 8, '2004-11-05'); INSERT INTO `PAYMENT` VALUES (328, 8, '2004-12-05'); INSERT INTO `PAYMENT` VALUES (329, 8, '2005-01-03'); INSERT INTO `PAYMENT` VALUES (330, 8, '2005-02-04'); INSERT INTO `PAYMENT` VALUES (331, 8, '2005-03-02'); INSERT INTO `PAYMENT` VALUES (332, 8, '2005-04-02'); INSERT INTO `PAYMENT` VALUES (333, 8, '2005-05-10'); INSERT INTO `PAYMENT` VALUES (334, 8, '2005-06-01'); INSERT INTO `PAYMENT` VALUES (335, 8, '2005-07-09'); INSERT INTO `PAYMENT` VALUES (336, 8, '2005-08-09'); INSERT INTO `PAYMENT` VALUES (337, 8, '2005-09-08'); INSERT INTO `PAYMENT` VALUES (338, 8, '2005-10-08'); INSERT INTO `PAYMENT` VALUES (339, 8, '2005-11-06'); INSERT INTO `PAYMENT` VALUES (340, 9, '2005-02-08'); INSERT INTO `PAYMENT` VALUES (341, 9, '2005-03-06'); INSERT INTO `PAYMENT` VALUES (342, 9, '2005-04-06'); INSERT INTO `PAYMENT` VALUES (343, 9, '2005-05-05'); INSERT INTO `PAYMENT` VALUES (344, 9, '2005-06-05'); INSERT INTO `PAYMENT` VALUES (345, 9, '2005-07-03'); INSERT INTO `PAYMENT` VALUES (346, 9, '2005-08-04'); INSERT INTO `PAYMENT` VALUES (347, 9, '2005-09-02'); INSERT INTO `PAYMENT` VALUES (348, 9, '2005-10-02'); INSERT INTO `PAYMENT` VALUES (349, 10, '2001-01-10'); INSERT INTO `PAYMENT` VALUES (350, 10, '2001-02-08'); INSERT INTO `PAYMENT` VALUES (351, 10, '2001-03-08'); INSERT INTO `PAYMENT` VALUES (352, 10, '2001-04-09'); INSERT INTO `PAYMENT` VALUES (353, 10, '2001-05-07'); INSERT INTO `PAYMENT` VALUES (354, 10, '2001-06-07'); INSERT INTO `PAYMENT` VALUES (355, 10, '2001-07-06'); INSERT INTO `PAYMENT` VALUES (356, 10, '2001-08-06'); INSERT INTO `PAYMENT` VALUES (357, 10, '2001-09-04'); INSERT INTO `PAYMENT` VALUES (358, 10, '2001-10-05'); INSERT INTO `PAYMENT` VALUES (359, 10, '2001-11-03'); INSERT INTO `PAYMENT` VALUES (360, 10, '2001-12-03'); INSERT INTO `PAYMENT` VALUES (361, 10, '2002-01-01'); INSERT INTO `PAYMENT` VALUES (362, 10, '2002-02-02'); INSERT INTO `PAYMENT` VALUES (363, 10, '2002-03-10'); INSERT INTO `PAYMENT` VALUES (364, 10, '2002-04-10'); INSERT INTO `PAYMENT` VALUES (365, 10, '2002-05-09'); INSERT INTO `PAYMENT` VALUES (366, 10, '2002-06-09'); INSERT INTO `PAYMENT` VALUES (367, 10, '2002-07-07'); INSERT INTO `PAYMENT` VALUES (368, 10, '2002-08-08'); INSERT INTO `PAYMENT` VALUES (369, 10, '2002-09-06'); INSERT INTO `PAYMENT` VALUES (370, 10, '2002-10-06'); INSERT INTO `PAYMENT` VALUES (371, 10, '2002-11-05'); INSERT INTO `PAYMENT` VALUES (372, 10, '2002-12-05'); INSERT INTO `PAYMENT` VALUES (373, 10, '2003-01-03'); INSERT INTO `PAYMENT` VALUES (374, 10, '2003-02-03'); INSERT INTO `PAYMENT` VALUES (375, 10, '2003-03-02'); INSERT INTO `PAYMENT` VALUES (376, 10, '2003-04-02'); INSERT INTO `PAYMENT` VALUES (377, 10, '2003-05-10'); INSERT INTO `PAYMENT` VALUES (378, 10, '2003-06-01'); INSERT INTO `PAYMENT` VALUES (379, 10, '2003-07-09'); INSERT INTO `PAYMENT` VALUES (380, 10, '2003-08-09'); INSERT INTO `PAYMENT` VALUES (381, 10, '2003-09-08'); INSERT INTO `PAYMENT` VALUES (382, 10, '2003-10-08'); INSERT INTO `PAYMENT` VALUES (383, 10, '2003-11-06'); INSERT INTO `PAYMENT` VALUES (384, 10, '2003-12-07'); INSERT INTO `PAYMENT` VALUES (419, 11, '2003-05-02'); INSERT INTO `PAYMENT` VALUES (418, 11, '2003-04-04'); INSERT INTO `PAYMENT` VALUES (417, 11, '2003-03-03'); INSERT INTO `PAYMENT` VALUES (416, 11, '2003-02-05'); INSERT INTO `PAYMENT` VALUES (415, 11, '2003-01-05'); INSERT INTO `PAYMENT` VALUES (414, 11, '2002-12-06'); INSERT INTO `PAYMENT` VALUES (413, 11, '2002-11-06'); INSERT INTO `PAYMENT` VALUES (412, 11, '2002-10-08'); INSERT INTO `PAYMENT` VALUES (411, 11, '2002-09-08'); INSERT INTO `PAYMENT` VALUES (410, 11, '2002-08-09'); INSERT INTO `PAYMENT` VALUES (409, 11, '2002-07-09'); INSERT INTO `PAYMENT` VALUES (421, 11, '2003-07-01'); INSERT INTO `PAYMENT` VALUES (422, 11, '2003-08-01'); INSERT INTO `PAYMENT` VALUES (423, 11, '2003-09-09'); INSERT INTO `PAYMENT` VALUES (424, 11, '2003-10-10'); INSERT INTO `PAYMENT` VALUES (425, 11, '2003-11-08'); INSERT INTO `PAYMENT` VALUES (426, 11, '2003-12-08'); INSERT INTO `PAYMENT` VALUES (427, 11, '2004-01-05'); INSERT INTO `PAYMENT` VALUES (428, 11, '2004-02-05'); INSERT INTO `PAYMENT` VALUES (429, 11, '2004-03-04'); INSERT INTO `PAYMENT` VALUES (430, 11, '2004-04-04'); INSERT INTO `PAYMENT` VALUES (431, 11, '2004-05-02'); INSERT INTO `PAYMENT` VALUES (432, 11, '2004-06-03'); INSERT INTO `PAYMENT` VALUES (433, 11, '2004-07-01'); INSERT INTO `PAYMENT` VALUES (434, 11, '2004-08-01'); INSERT INTO `PAYMENT` VALUES (435, 11, '2004-09-10'); INSERT INTO `PAYMENT` VALUES (436, 11, '2004-10-10'); INSERT INTO `PAYMENT` VALUES (437, 11, '2004-11-08'); INSERT INTO `PAYMENT` VALUES (438, 11, '2004-12-08'); INSERT INTO `PAYMENT` VALUES (439, 11, '2005-01-09'); INSERT INTO `PAYMENT` VALUES (440, 11, '2005-02-07'); INSERT INTO `PAYMENT` VALUES (441, 11, '2005-03-07'); INSERT INTO `PAYMENT` VALUES (442, 11, '2005-04-06'); INSERT INTO `PAYMENT` VALUES (443, 11, '2005-05-06'); INSERT INTO `PAYMENT` VALUES (444, 11, '2005-06-04'); INSERT INTO `PAYMENT` VALUES (445, 11, '2005-07-05'); INSERT INTO `PAYMENT` VALUES (446, 11, '2005-08-03'); INSERT INTO `PAYMENT` VALUES (447, 11, '2005-09-03'); INSERT INTO `PAYMENT` VALUES (448, 11, '2005-10-02'); INSERT INTO `PAYMENT` VALUES (842, 12, '2003-09-09'); INSERT INTO `PAYMENT` VALUES (450, 12, '2000-10-01'); INSERT INTO `PAYMENT` VALUES (451, 12, '2000-11-09'); INSERT INTO `PAYMENT` VALUES (452, 12, '2000-12-09'); INSERT INTO `PAYMENT` VALUES (453, 12, '2001-01-08'); INSERT INTO `PAYMENT` VALUES (454, 12, '2001-02-08'); INSERT INTO `PAYMENT` VALUES (455, 12, '2001-03-08'); INSERT INTO `PAYMENT` VALUES (456, 12, '2001-04-07'); INSERT INTO `PAYMENT` VALUES (457, 12, '2001-05-07'); INSERT INTO `PAYMENT` VALUES (458, 12, '2001-06-05'); INSERT INTO `PAYMENT` VALUES (459, 12, '2001-07-05'); INSERT INTO `PAYMENT` VALUES (460, 12, '2001-08-04'); INSERT INTO `PAYMENT` VALUES (461, 12, '2001-09-04'); INSERT INTO `PAYMENT` VALUES (462, 12, '2001-10-02'); INSERT INTO `PAYMENT` VALUES (463, 12, '2001-11-03'); INSERT INTO `PAYMENT` VALUES (464, 12, '2001-12-01'); INSERT INTO `PAYMENT` VALUES (465, 12, '2002-01-01'); INSERT INTO `PAYMENT` VALUES (466, 12, '2002-02-10'); INSERT INTO `PAYMENT` VALUES (467, 12, '2002-03-10'); INSERT INTO `PAYMENT` VALUES (468, 12, '2002-04-08'); INSERT INTO `PAYMENT` VALUES (469, 12, '2002-05-08'); INSERT INTO `PAYMENT` VALUES (470, 12, '2002-06-07'); INSERT INTO `PAYMENT` VALUES (471, 12, '2002-07-07'); INSERT INTO `PAYMENT` VALUES (472, 12, '2002-08-05'); INSERT INTO `PAYMENT` VALUES (473, 12, '2002-09-06'); INSERT INTO `PAYMENT` VALUES (474, 12, '2002-10-04'); INSERT INTO `PAYMENT` VALUES (475, 12, '2002-11-03'); INSERT INTO `PAYMENT` VALUES (476, 12, '2002-12-01'); INSERT INTO `PAYMENT` VALUES (477, 12, '2003-01-02'); INSERT INTO `PAYMENT` VALUES (478, 12, '2003-02-10'); INSERT INTO `PAYMENT` VALUES (479, 12, '2003-03-10'); INSERT INTO `PAYMENT` VALUES (480, 12, '2003-04-08'); INSERT INTO `PAYMENT` VALUES (481, 12, '2003-05-09'); INSERT INTO `PAYMENT` VALUES (482, 12, '2003-06-07'); INSERT INTO `PAYMENT` VALUES (483, 12, '2003-07-07'); INSERT INTO `PAYMENT` VALUES (484, 12, '2003-08-06'); INSERT INTO `PAYMENT` VALUES (485, 13, '2005-04-09'); INSERT INTO `PAYMENT` VALUES (486, 13, '2005-05-09'); INSERT INTO `PAYMENT` VALUES (487, 13, '2005-06-07'); INSERT INTO `PAYMENT` VALUES (488, 13, '2005-07-08'); INSERT INTO `PAYMENT` VALUES (489, 13, '2005-08-06'); INSERT INTO `PAYMENT` VALUES (490, 13, '2005-09-06'); INSERT INTO `PAYMENT` VALUES (491, 13, '2005-10-05'); INSERT INTO `PAYMENT` VALUES (492, 13, '2005-11-05'); INSERT INTO `PAYMENT` VALUES (494, 14, '2004-10-08'); INSERT INTO `PAYMENT` VALUES (495, 14, '2004-11-07'); INSERT INTO `PAYMENT` VALUES (496, 14, '2004-12-07'); INSERT INTO `PAYMENT` VALUES (497, 14, '2005-01-05'); INSERT INTO `PAYMENT` VALUES (498, 14, '2005-02-06'); INSERT INTO `PAYMENT` VALUES (499, 14, '2005-03-04'); INSERT INTO `PAYMENT` VALUES (500, 14, '2005-04-04'); INSERT INTO `PAYMENT` VALUES (501, 14, '2005-05-02'); INSERT INTO `PAYMENT` VALUES (502, 14, '2005-06-03'); INSERT INTO `PAYMENT` VALUES (503, 14, '2005-07-01'); INSERT INTO `PAYMENT` VALUES (504, 14, '2005-08-01'); INSERT INTO `PAYMENT` VALUES (505, 14, '2005-09-10'); INSERT INTO `PAYMENT` VALUES (506, 14, '2005-10-10'); INSERT INTO `PAYMENT` VALUES (507, 15, '2003-07-09'); INSERT INTO `PAYMENT` VALUES (508, 15, '2003-08-09'); INSERT INTO `PAYMENT` VALUES (509, 15, '2003-09-07'); INSERT INTO `PAYMENT` VALUES (510, 15, '2003-10-08'); INSERT INTO `PAYMENT` VALUES (511, 15, '2003-11-06'); INSERT INTO `PAYMENT` VALUES (512, 15, '2003-12-06'); INSERT INTO `PAYMENT` VALUES (513, 15, '2004-01-05'); INSERT INTO `PAYMENT` VALUES (514, 15, '2004-02-05'); INSERT INTO `PAYMENT` VALUES (515, 15, '2004-03-03'); INSERT INTO `PAYMENT` VALUES (516, 15, '2004-04-03'); INSERT INTO `PAYMENT` VALUES (517, 15, '2004-05-02'); INSERT INTO `PAYMENT` VALUES (518, 15, '2004-06-02'); INSERT INTO `PAYMENT` VALUES (519, 15, '2004-07-10'); INSERT INTO `PAYMENT` VALUES (520, 15, '2004-08-01'); INSERT INTO `PAYMENT` VALUES (521, 15, '2004-09-09'); INSERT INTO `PAYMENT` VALUES (522, 15, '2004-10-09'); INSERT INTO `PAYMENT` VALUES (523, 15, '2004-11-08'); INSERT INTO `PAYMENT` VALUES (524, 15, '2004-12-08'); INSERT INTO `PAYMENT` VALUES (525, 15, '2005-01-06'); INSERT INTO `PAYMENT` VALUES (526, 15, '2005-02-06'); INSERT INTO `PAYMENT` VALUES (527, 15, '2005-03-05'); INSERT INTO `PAYMENT` VALUES (528, 15, '2005-04-05'); INSERT INTO `PAYMENT` VALUES (529, 15, '2005-05-03'); INSERT INTO `PAYMENT` VALUES (530, 15, '2005-06-02'); INSERT INTO `PAYMENT` VALUES (531, 15, '2005-07-01'); INSERT INTO `PAYMENT` VALUES (532, 15, '2005-08-01'); INSERT INTO `PAYMENT` VALUES (533, 15, '2005-09-09'); INSERT INTO `PAYMENT` VALUES (534, 15, '2005-10-08'); INSERT INTO `PAYMENT` VALUES (535, 15, '2005-11-08'); INSERT INTO `PAYMENT` VALUES (537, 16, '2000-12-10'); INSERT INTO `PAYMENT` VALUES (538, 16, '2001-01-10'); INSERT INTO `PAYMENT` VALUES (539, 16, '2001-02-01'); INSERT INTO `PAYMENT` VALUES (540, 16, '2001-03-09'); INSERT INTO `PAYMENT` VALUES (541, 16, '2001-04-09'); INSERT INTO `PAYMENT` VALUES (542, 16, '2001-05-07'); INSERT INTO `PAYMENT` VALUES (543, 16, '2001-06-08'); INSERT INTO `PAYMENT` VALUES (544, 16, '2001-07-06'); INSERT INTO `PAYMENT` VALUES (545, 16, '2001-08-06'); INSERT INTO `PAYMENT` VALUES (546, 16, '2001-09-05'); INSERT INTO `PAYMENT` VALUES (547, 16, '2001-10-05'); INSERT INTO `PAYMENT` VALUES (548, 16, '2001-11-03'); INSERT INTO `PAYMENT` VALUES (549, 16, '2001-12-04'); INSERT INTO `PAYMENT` VALUES (550, 16, '2002-01-02'); INSERT INTO `PAYMENT` VALUES (551, 16, '2002-02-02'); INSERT INTO `PAYMENT` VALUES (552, 16, '2002-03-01'); INSERT INTO `PAYMENT` VALUES (553, 16, '2002-04-01'); INSERT INTO `PAYMENT` VALUES (554, 16, '2002-05-09'); INSERT INTO `PAYMENT` VALUES (555, 16, '2002-06-09'); INSERT INTO `PAYMENT` VALUES (556, 16, '2002-07-08'); INSERT INTO `PAYMENT` VALUES (557, 16, '2002-08-08'); INSERT INTO `PAYMENT` VALUES (558, 16, '2002-09-06'); INSERT INTO `PAYMENT` VALUES (559, 16, '2002-10-05'); INSERT INTO `PAYMENT` VALUES (560, 16, '2002-11-05'); INSERT INTO `PAYMENT` VALUES (561, 16, '2002-12-04'); INSERT INTO `PAYMENT` VALUES (562, 16, '2003-01-04'); INSERT INTO `PAYMENT` VALUES (563, 16, '2003-02-02'); INSERT INTO `PAYMENT` VALUES (564, 16, '2003-03-03'); INSERT INTO `PAYMENT` VALUES (565, 16, '2003-04-01'); INSERT INTO `PAYMENT` VALUES (566, 16, '2003-05-01'); INSERT INTO `PAYMENT` VALUES (567, 16, '2003-06-09'); INSERT INTO `PAYMENT` VALUES (568, 16, '2003-07-10'); INSERT INTO `PAYMENT` VALUES (569, 16, '2003-08-08'); INSERT INTO `PAYMENT` VALUES (570, 16, '2003-09-08'); INSERT INTO `PAYMENT` VALUES (571, 16, '2003-10-07'); INSERT INTO `PAYMENT` VALUES (572, 16, '2003-11-07'); INSERT INTO `PAYMENT` VALUES (573, 16, '2003-12-05'); INSERT INTO `PAYMENT` VALUES (574, 16, '2004-01-06'); INSERT INTO `PAYMENT` VALUES (575, 16, '2004-02-06'); INSERT INTO `PAYMENT` VALUES (576, 16, '2004-03-04'); INSERT INTO `PAYMENT` VALUES (577, 16, '2004-04-04'); INSERT INTO `PAYMENT` VALUES (578, 16, '2004-05-03'); INSERT INTO `PAYMENT` VALUES (579, 16, '2004-06-03'); INSERT INTO `PAYMENT` VALUES (580, 16, '2004-07-01'); INSERT INTO `PAYMENT` VALUES (581, 16, '2004-08-02'); INSERT INTO `PAYMENT` VALUES (582, 16, '2004-09-10'); INSERT INTO `PAYMENT` VALUES (583, 16, '2004-10-10'); INSERT INTO `PAYMENT` VALUES (584, 16, '2004-11-09'); INSERT INTO `PAYMENT` VALUES (585, 16, '2004-12-09'); INSERT INTO `PAYMENT` VALUES (586, 16, '2005-01-07'); INSERT INTO `PAYMENT` VALUES (587, 16, '2005-02-08'); INSERT INTO `PAYMENT` VALUES (588, 16, '2005-03-06'); INSERT INTO `PAYMENT` VALUES (589, 16, '2005-04-06'); INSERT INTO `PAYMENT` VALUES (590, 16, '2005-05-04'); INSERT INTO `PAYMENT` VALUES (591, 16, '2005-06-05'); INSERT INTO `PAYMENT` VALUES (592, 16, '2005-07-03'); INSERT INTO `PAYMENT` VALUES (593, 16, '2005-08-03'); INSERT INTO `PAYMENT` VALUES (595, 16, '2005-10-02'); INSERT INTO `PAYMENT` VALUES (596, 17, '2003-02-05'); INSERT INTO `PAYMENT` VALUES (597, 17, '2003-03-04'); INSERT INTO `PAYMENT` VALUES (598, 17, '2003-04-04'); INSERT INTO `PAYMENT` VALUES (599, 17, '2003-05-02'); INSERT INTO `PAYMENT` VALUES (600, 17, '2003-06-02'); INSERT INTO `PAYMENT` VALUES (601, 17, '2003-07-01'); INSERT INTO `PAYMENT` VALUES (602, 17, '2003-08-01'); INSERT INTO `PAYMENT` VALUES (603, 17, '2003-09-09'); INSERT INTO `PAYMENT` VALUES (604, 17, '2003-10-10'); INSERT INTO `PAYMENT` VALUES (605, 17, '2003-11-10'); INSERT INTO `PAYMENT` VALUES (606, 17, '2003-12-08'); INSERT INTO `PAYMENT` VALUES (607, 17, '2004-01-09'); INSERT INTO `PAYMENT` VALUES (608, 17, '2004-02-07'); INSERT INTO `PAYMENT` VALUES (609, 17, '2004-03-07'); INSERT INTO `PAYMENT` VALUES (610, 17, '2004-04-06'); INSERT INTO `PAYMENT` VALUES (611, 17, '2004-05-06'); INSERT INTO `PAYMENT` VALUES (612, 17, '2004-06-04'); INSERT INTO `PAYMENT` VALUES (613, 17, '2004-07-04'); INSERT INTO `PAYMENT` VALUES (614, 17, '2004-08-03'); INSERT INTO `PAYMENT` VALUES (615, 17, '2004-09-03'); INSERT INTO `PAYMENT` VALUES (616, 17, '2004-10-01'); INSERT INTO `PAYMENT` VALUES (617, 17, '2004-11-02'); INSERT INTO `PAYMENT` VALUES (618, 17, '2004-12-10'); INSERT INTO `PAYMENT` VALUES (619, 17, '2005-01-10'); INSERT INTO `PAYMENT` VALUES (620, 17, '2005-02-09'); INSERT INTO `PAYMENT` VALUES (621, 17, '2005-03-08'); INSERT INTO `PAYMENT` VALUES (622, 17, '2005-04-06'); INSERT INTO `PAYMENT` VALUES (623, 17, '2005-05-06'); INSERT INTO `PAYMENT` VALUES (624, 17, '2005-06-04'); INSERT INTO `PAYMENT` VALUES (625, 17, '2005-07-05'); INSERT INTO `PAYMENT` VALUES (626, 17, '2005-08-03'); INSERT INTO `PAYMENT` VALUES (627, 17, '2005-09-03'); INSERT INTO `PAYMENT` VALUES (628, 17, '2005-10-02'); INSERT INTO `PAYMENT` VALUES (629, 17, '2005-11-02'); INSERT INTO `PAYMENT` VALUES (631, 18, '2004-12-03'); INSERT INTO `PAYMENT` VALUES (632, 18, '2005-01-03'); INSERT INTO `PAYMENT` VALUES (633, 18, '2005-02-02'); INSERT INTO `PAYMENT` VALUES (634, 18, '2005-03-02'); INSERT INTO `PAYMENT` VALUES (635, 18, '2005-04-10'); INSERT INTO `PAYMENT` VALUES (636, 18, '2005-05-10'); INSERT INTO `PAYMENT` VALUES (637, 18, '2005-06-09'); INSERT INTO `PAYMENT` VALUES (638, 18, '2005-07-09'); INSERT INTO `PAYMENT` VALUES (639, 18, '2005-08-07'); INSERT INTO `PAYMENT` VALUES (640, 18, '2005-09-08'); INSERT INTO `PAYMENT` VALUES (641, 18, '2005-10-06'); INSERT INTO `PAYMENT` VALUES (643, 19, '2005-05-10'); INSERT INTO `PAYMENT` VALUES (644, 19, '2005-06-10'); INSERT INTO `PAYMENT` VALUES (645, 19, '2005-07-08'); INSERT INTO `PAYMENT` VALUES (646, 19, '2005-08-09'); INSERT INTO `PAYMENT` VALUES (647, 19, '2005-09-07'); INSERT INTO `PAYMENT` VALUES (648, 19, '2005-10-07'); INSERT INTO `PAYMENT` VALUES (649, 20, '2004-03-09'); INSERT INTO `PAYMENT` VALUES (650, 20, '2004-04-08'); INSERT INTO `PAYMENT` VALUES (651, 20, '2004-05-08'); INSERT INTO `PAYMENT` VALUES (652, 20, '2004-06-08'); INSERT INTO `PAYMENT` VALUES (653, 20, '2004-07-07'); INSERT INTO `PAYMENT` VALUES (654, 20, '2004-08-07'); INSERT INTO `PAYMENT` VALUES (655, 20, '2004-09-05'); INSERT INTO `PAYMENT` VALUES (656, 20, '2004-10-05'); INSERT INTO `PAYMENT` VALUES (657, 20, '2004-11-04'); INSERT INTO `PAYMENT` VALUES (658, 20, '2004-12-04'); INSERT INTO `PAYMENT` VALUES (659, 20, '2005-01-02'); INSERT INTO `PAYMENT` VALUES (660, 20, '2005-02-03'); INSERT INTO `PAYMENT` VALUES (661, 20, '2005-03-01'); INSERT INTO `PAYMENT` VALUES (662, 20, '2005-04-01'); INSERT INTO `PAYMENT` VALUES (663, 20, '2005-05-10'); INSERT INTO `PAYMENT` VALUES (664, 20, '2005-06-10'); INSERT INTO `PAYMENT` VALUES (665, 20, '2005-07-08'); INSERT INTO `PAYMENT` VALUES (666, 20, '2005-08-09'); INSERT INTO `PAYMENT` VALUES (667, 20, '2005-09-07'); INSERT INTO `PAYMENT` VALUES (668, 20, '2005-10-07'); INSERT INTO `PAYMENT` VALUES (669, 20, '2005-11-05'); INSERT INTO `PAYMENT` VALUES (671, 21, '2001-07-01'); INSERT INTO `PAYMENT` VALUES (672, 21, '2001-08-09'); INSERT INTO `PAYMENT` VALUES (673, 21, '2001-09-09'); INSERT INTO `PAYMENT` VALUES (674, 21, '2001-10-07'); INSERT INTO `PAYMENT` VALUES (675, 21, '2001-11-08'); INSERT INTO `PAYMENT` VALUES (676, 21, '2001-12-06'); INSERT INTO `PAYMENT` VALUES (677, 21, '2002-01-06'); INSERT INTO `PAYMENT` VALUES (678, 21, '2002-02-05'); INSERT INTO `PAYMENT` VALUES (679, 21, '2002-03-05'); INSERT INTO `PAYMENT` VALUES (680, 21, '2002-04-03'); INSERT INTO `PAYMENT` VALUES (681, 21, '2002-05-04'); INSERT INTO `PAYMENT` VALUES (682, 21, '2002-06-02'); INSERT INTO `PAYMENT` VALUES (683, 21, '2002-07-02'); INSERT INTO `PAYMENT` VALUES (684, 21, '2002-08-01'); INSERT INTO `PAYMENT` VALUES (685, 21, '2002-09-01'); INSERT INTO `PAYMENT` VALUES (686, 21, '2002-10-09'); INSERT INTO `PAYMENT` VALUES (687, 21, '2002-11-09'); INSERT INTO `PAYMENT` VALUES (688, 21, '2002-12-08'); INSERT INTO `PAYMENT` VALUES (689, 21, '2003-01-08'); INSERT INTO `PAYMENT` VALUES (690, 21, '2003-02-06'); INSERT INTO `PAYMENT` VALUES (691, 21, '2003-03-07'); INSERT INTO `PAYMENT` VALUES (692, 21, '2003-04-05'); INSERT INTO `PAYMENT` VALUES (693, 21, '2003-05-05'); INSERT INTO `PAYMENT` VALUES (694, 21, '2003-06-06'); INSERT INTO `PAYMENT` VALUES (695, 21, '2003-07-04'); INSERT INTO `PAYMENT` VALUES (696, 21, '2003-08-03'); INSERT INTO `PAYMENT` VALUES (697, 21, '2003-09-01'); INSERT INTO `PAYMENT` VALUES (698, 21, '2003-10-01'); INSERT INTO `PAYMENT` VALUES (699, 21, '2003-11-10'); INSERT INTO `PAYMENT` VALUES (700, 21, '2003-12-10'); INSERT INTO `PAYMENT` VALUES (701, 21, '2004-01-08'); INSERT INTO `PAYMENT` VALUES (702, 21, '2004-02-09'); INSERT INTO `PAYMENT` VALUES (703, 21, '2004-03-07'); INSERT INTO `PAYMENT` VALUES (704, 21, '2004-04-07'); INSERT INTO `PAYMENT` VALUES (705, 21, '2004-05-06'); INSERT INTO `PAYMENT` VALUES (706, 21, '2004-06-06'); INSERT INTO `PAYMENT` VALUES (707, 21, '2004-07-04'); INSERT INTO `PAYMENT` VALUES (708, 21, '2004-08-05'); INSERT INTO `PAYMENT` VALUES (709, 21, '2004-09-03'); INSERT INTO `PAYMENT` VALUES (710, 21, '2004-10-03'); INSERT INTO `PAYMENT` VALUES (711, 21, '2004-11-01'); INSERT INTO `PAYMENT` VALUES (712, 21, '2004-12-02'); INSERT INTO `PAYMENT` VALUES (713, 21, '2005-01-10'); INSERT INTO `PAYMENT` VALUES (714, 21, '2005-02-10'); INSERT INTO `PAYMENT` VALUES (715, 21, '2005-03-09'); INSERT INTO `PAYMENT` VALUES (716, 21, '2005-04-09'); INSERT INTO `PAYMENT` VALUES (717, 21, '2005-05-07'); INSERT INTO `PAYMENT` VALUES (718, 21, '2005-06-08'); INSERT INTO `PAYMENT` VALUES (719, 21, '2005-07-06'); INSERT INTO `PAYMENT` VALUES (720, 21, '2005-08-06'); INSERT INTO `PAYMENT` VALUES (721, 21, '2005-09-04'); INSERT INTO `PAYMENT` VALUES (722, 21, '2005-10-05'); INSERT INTO `PAYMENT` VALUES (723, 22, '2005-11-10'); INSERT INTO `PAYMENT` VALUES (724, 23, '1992-07-01'); INSERT INTO `PAYMENT` VALUES (725, 23, '1992-08-01'); INSERT INTO `PAYMENT` VALUES (726, 23, '1992-09-02'); INSERT INTO `PAYMENT` VALUES (727, 23, '1992-10-10'); INSERT INTO `PAYMENT` VALUES (728, 23, '1992-11-10'); INSERT INTO `PAYMENT` VALUES (729, 23, '1992-12-09'); INSERT INTO `PAYMENT` VALUES (730, 23, '1993-01-09'); INSERT INTO `PAYMENT` VALUES (731, 23, '1993-02-07'); INSERT INTO `PAYMENT` VALUES (732, 23, '1993-03-08'); INSERT INTO `PAYMENT` VALUES (733, 23, '1993-04-06'); INSERT INTO `PAYMENT` VALUES (734, 23, '1993-05-06'); INSERT INTO `PAYMENT` VALUES (735, 23, '1993-06-05'); INSERT INTO `PAYMENT` VALUES (736, 23, '1993-07-05'); INSERT INTO `PAYMENT` VALUES (737, 23, '1993-08-03'); INSERT INTO `PAYMENT` VALUES (738, 23, '1993-09-03'); INSERT INTO `PAYMENT` VALUES (739, 23, '1993-10-02'); INSERT INTO `PAYMENT` VALUES (740, 23, '1993-11-02'); INSERT INTO `PAYMENT` VALUES (741, 23, '1993-12-10'); INSERT INTO `PAYMENT` VALUES (742, 23, '1994-01-01'); INSERT INTO `PAYMENT` VALUES (743, 23, '1994-02-09'); INSERT INTO `PAYMENT` VALUES (744, 23, '1994-03-09'); INSERT INTO `PAYMENT` VALUES (745, 23, '1994-04-08'); INSERT INTO `PAYMENT` VALUES (746, 23, '1994-05-08'); INSERT INTO `PAYMENT` VALUES (747, 23, '1994-06-06'); INSERT INTO `PAYMENT` VALUES (748, 23, '1994-07-07'); INSERT INTO `PAYMENT` VALUES (749, 23, '1994-08-05'); INSERT INTO `PAYMENT` VALUES (750, 23, '1994-09-05'); INSERT INTO `PAYMENT` VALUES (751, 23, '1994-10-03'); INSERT INTO `PAYMENT` VALUES (752, 23, '1994-11-02'); INSERT INTO `PAYMENT` VALUES (753, 23, '1994-12-01'); INSERT INTO `PAYMENT` VALUES (754, 23, '1995-01-01'); INSERT INTO `PAYMENT` VALUES (755, 23, '1995-02-09'); INSERT INTO `PAYMENT` VALUES (756, 23, '1995-03-10'); INSERT INTO `PAYMENT` VALUES (757, 23, '1995-04-08'); INSERT INTO `PAYMENT` VALUES (758, 23, '1995-05-08'); INSERT INTO `PAYMENT` VALUES (759, 23, '1995-06-09'); INSERT INTO `PAYMENT` VALUES (760, 23, '1995-07-07'); INSERT INTO `PAYMENT` VALUES (761, 23, '1995-08-07'); INSERT INTO `PAYMENT` VALUES (762, 23, '1995-09-05'); INSERT INTO `PAYMENT` VALUES (763, 23, '1995-10-06'); INSERT INTO `PAYMENT` VALUES (764, 23, '1995-11-04'); INSERT INTO `PAYMENT` VALUES (765, 23, '1995-12-04'); INSERT INTO `PAYMENT` VALUES (766, 23, '1996-01-03'); INSERT INTO `PAYMENT` VALUES (767, 23, '1996-02-03'); INSERT INTO `PAYMENT` VALUES (768, 23, '1996-03-01'); INSERT INTO `PAYMENT` VALUES (769, 23, '1996-04-02'); INSERT INTO `PAYMENT` VALUES (770, 23, '1996-05-10'); INSERT INTO `PAYMENT` VALUES (771, 23, '1996-06-10'); INSERT INTO `PAYMENT` VALUES (772, 23, '1996-07-08'); INSERT INTO `PAYMENT` VALUES (773, 23, '1996-08-09'); INSERT INTO `PAYMENT` VALUES (774, 23, '1996-09-07'); INSERT INTO `PAYMENT` VALUES (775, 23, '1996-10-07'); INSERT INTO `PAYMENT` VALUES (776, 23, '1996-11-06'); INSERT INTO `PAYMENT` VALUES (777, 23, '1996-12-06'); INSERT INTO `PAYMENT` VALUES (778, 23, '1997-01-04'); INSERT INTO `PAYMENT` VALUES (779, 23, '1997-02-05'); INSERT INTO `PAYMENT` VALUES (780, 23, '1997-03-03'); INSERT INTO `PAYMENT` VALUES (781, 23, '1997-04-03'); INSERT INTO `PAYMENT` VALUES (782, 23, '1997-05-02'); INSERT INTO `PAYMENT` VALUES (783, 23, '1997-06-02'); INSERT INTO `PAYMENT` VALUES (784, 23, '1997-07-10'); INSERT INTO `PAYMENT` VALUES (785, 23, '1997-08-10'); INSERT INTO `PAYMENT` VALUES (786, 23, '1997-09-09'); INSERT INTO `PAYMENT` VALUES (787, 23, '1997-10-09'); INSERT INTO `PAYMENT` VALUES (788, 23, '1997-11-07'); INSERT INTO `PAYMENT` VALUES (789, 23, '1997-12-08'); INSERT INTO `PAYMENT` VALUES (790, 23, '1998-01-06'); INSERT INTO `PAYMENT` VALUES (791, 23, '1998-02-06'); INSERT INTO `PAYMENT` VALUES (792, 23, '1998-03-05'); INSERT INTO `PAYMENT` VALUES (793, 23, '1998-04-05'); INSERT INTO `PAYMENT` VALUES (794, 23, '1998-05-03'); INSERT INTO `PAYMENT` VALUES (795, 23, '1998-06-04'); INSERT INTO `PAYMENT` VALUES (796, 23, '1998-07-04'); INSERT INTO `PAYMENT` VALUES (797, 23, '1998-08-02'); INSERT INTO `PAYMENT` VALUES (798, 23, '1998-09-02'); INSERT INTO `PAYMENT` VALUES (799, 23, '1998-10-01'); INSERT INTO `PAYMENT` VALUES (800, 23, '1998-11-01'); INSERT INTO `PAYMENT` VALUES (801, 23, '1998-12-09'); INSERT INTO `PAYMENT` VALUES (802, 23, '1999-01-10'); INSERT INTO `PAYMENT` VALUES (803, 23, '1999-02-08'); INSERT INTO `PAYMENT` VALUES (804, 23, '1999-03-08'); INSERT INTO `PAYMENT` VALUES (805, 23, '1999-04-07'); INSERT INTO `PAYMENT` VALUES (806, 23, '1999-05-07'); INSERT INTO `PAYMENT` VALUES (807, 23, '1999-06-05'); INSERT INTO `PAYMENT` VALUES (808, 23, '1999-07-06'); INSERT INTO `PAYMENT` VALUES (809, 23, '1999-08-04'); INSERT INTO `PAYMENT` VALUES (810, 23, '1999-09-04'); INSERT INTO `PAYMENT` VALUES (811, 23, '1999-10-02'); INSERT INTO `PAYMENT` VALUES (812, 23, '1999-11-03'); INSERT INTO `PAYMENT` VALUES (813, 23, '1999-12-01'); INSERT INTO `PAYMENT` VALUES (814, 23, '2000-01-01'); INSERT INTO `PAYMENT` VALUES (815, 23, '2000-02-10'); INSERT INTO `PAYMENT` VALUES (816, 23, '2000-03-10'); INSERT INTO `PAYMENT` VALUES (817, 23, '2000-04-08'); INSERT INTO `PAYMENT` VALUES (818, 23, '2000-05-09'); INSERT INTO `PAYMENT` VALUES (819, 23, '2000-06-07'); INSERT INTO `PAYMENT` VALUES (832, 5, '2005-11-08'); INSERT INTO `PAYMENT` VALUES (833, 7, '2005-11-01'); INSERT INTO `PAYMENT` VALUES (834, 9, '2005-11-08'); INSERT INTO `PAYMENT` VALUES (835, 11, '2005-11-06'); INSERT INTO `PAYMENT` VALUES (836, 14, '2005-11-04'); INSERT INTO `PAYMENT` VALUES (838, 18, '2005-11-02'); INSERT INTO `PAYMENT` VALUES (839, 19, '2005-11-07'); INSERT INTO `PAYMENT` VALUES (840, 21, '2005-11-09'); -- -- Contenu de la table `PERSON` -- INSERT INTO `PERSON` VALUES (1, 'Mason', 'Nick', '1945-01-27', '+3201587001', '105 street Pierre Carnivore', 4); INSERT INTO `PERSON` VALUES (2, 'Gilmour', 'David', '1946-03-06', '+31453574001', NULL, NULL); INSERT INTO `PERSON` VALUES (3, 'Barrett', 'Syd', '1946-01-06', '+340532189001', '372 avenue Bernard Ham', 2); INSERT INTO `PERSON` VALUES (4, 'Cretu', 'Michael', '1957-07-15', NULL, NULL, NULL); INSERT INTO `PERSON` VALUES (5, 'Peterson', 'Franck', '1960-01-01', NULL, NULL, NULL); INSERT INTO `PERSON` VALUES (6, 'Cretu', 'Sandra', '1962-05-18', '+345032198', NULL, NULL); INSERT INTO `PERSON` VALUES (7, 'De Bounevialle', 'Dido', '1971-12-25', '+2205623218', '17 street Maryse Rempant', 7); INSERT INTO `PERSON` VALUES (8, 'Van Giersbergen', 'Anneke', '1973-03-08', '+56421051658', NULL, NULL); INSERT INTO `PERSON` VALUES (9, 'Morissette', 'Alanis', '1974-06-01', '+2316500121', '32 chemin Laurent Insecte', 3); INSERT INTO `PERSON` VALUES (10, 'Duteil', 'Yves', '1949-07-24', '+3306532465', '326 avenue Jean Jacques Dulion', 7); INSERT INTO `PERSON` VALUES (11, 'Simon', 'Emilie', '1986-11-03', '+4269349665', '815 chemin Henri Delezard', 6); INSERT INTO `PERSON` VALUES (12, 'Serra', 'Eric', '1959-09-09', '+116532978', '25 boulevard Amelie Dauphine', 5); INSERT INTO `PERSON` VALUES (13, 'Elfman', 'Danny', '1953-05-29', '+6153191987', '42 street Erica Raigne', 4); INSERT INTO `PERSON` VALUES (14, 'Williams', 'John', '1932-02-08', '+99434656731', '96 avenue Richard Binks', 2); INSERT INTO `PERSON` VALUES (15, 'Horner', 'James', '1953-08-14', '+8921348756', '735 street Emanuel Foc', 3); INSERT INTO `PERSON` VALUES (16, 'Dion', 'Celine', '1968-03-30', '+1114297652', '184 chemin Erica Ribou', 4); INSERT INTO `PERSON` VALUES (17, 'Shore', 'Howard', '1946-12-08', '+6129032065', '21 street Mateo Liphant', 5); INSERT INTO `PERSON` VALUES (18, 'Chedid', 'Matthieu', '1971-12-21', '+3375434010', '408 boulevard Henri Mifour', 6); INSERT INTO `PERSON` VALUES (19, 'Saez', 'Damien', '1977-08-01', '+09218523290', '230 avenue Conchi Yen', 7); INSERT INTO `PERSON` VALUES (20, 'Corrs', 'Erica', '1981-05-12', '+42315789001', NULL, NULL); INSERT INTO `PERSON` VALUES (21, 'Corrs', 'Andrea', '1980-11-11', '+223479043', NULL, NULL); INSERT INTO `PERSON` VALUES (22, 'Corrs', 'Aurelia', '1978-08-19', '+235903211', '31 boulevard Ignitus Renne', 5); -- -- Contenu de la table `DISTRICT` -- INSERT INTO `DISTRICT` VALUES (4, 'Lowne', 3); INSERT INTO `DISTRICT` VALUES (2, 'Twuna', 2); INSERT INTO `DISTRICT` VALUES (3, 'Lumpo', 2); INSERT INTO `DISTRICT` VALUES (5, 'Papwa', 5); INSERT INTO `DISTRICT` VALUES (6, 'Sali', 4); INSERT INTO `DISTRICT` VALUES (7, 'Luxows', 7); -- -- Contenu de la table `SIGNATORY` -- INSERT INTO `SIGNATORY` VALUES (4, 4, 3, 3540); INSERT INTO `SIGNATORY` VALUES (7, 3, 1, 1200); INSERT INTO `SIGNATORY` VALUES (6, 4, 1, 2546); INSERT INTO `SIGNATORY` VALUES (22, 4, 5, 4192); INSERT INTO `SIGNATORY` VALUES (1, 8, 5, 3288); INSERT INTO `SIGNATORY` VALUES (5, 7, 1, 1291); INSERT INTO `SIGNATORY` VALUES (2, 4, 2, 2500); INSERT INTO `SIGNATORY` VALUES (12, 7, 5, 4180); INSERT INTO `SIGNATORY` VALUES (17, 7, 4, 2517); INSERT INTO `SIGNATORY` VALUES (19, 3, 3, 3092); INSERT INTO `SIGNATORY` VALUES (8, 4, 5, 1500); -- -- Contenu de la table `SIGNATURE` -- INSERT INTO `SIGNATURE` VALUES (1, 1); INSERT INTO `SIGNATURE` VALUES (1, 2); INSERT INTO `SIGNATURE` VALUES (3, 4); INSERT INTO `SIGNATURE` VALUES (3, 6); INSERT INTO `SIGNATURE` VALUES (5, 2); INSERT INTO `SIGNATURE` VALUES (6, 7); INSERT INTO `SIGNATURE` VALUES (7, 12); INSERT INTO `SIGNATURE` VALUES (8, 5); INSERT INTO `SIGNATURE` VALUES (9, 17); INSERT INTO `SIGNATURE` VALUES (10, 19); INSERT INTO `SIGNATURE` VALUES (11, 8); INSERT INTO `SIGNATURE` VALUES (13, 17); INSERT INTO `SIGNATURE` VALUES (14, 8); INSERT INTO `SIGNATURE` VALUES (15, 12); INSERT INTO `SIGNATURE` VALUES (16, 1); INSERT INTO `SIGNATURE` VALUES (17, 7); INSERT INTO `SIGNATURE` VALUES (18, 1); INSERT INTO `SIGNATURE` VALUES (19, 7); INSERT INTO `SIGNATURE` VALUES (20, 22); INSERT INTO `SIGNATURE` VALUES (21, 5); INSERT INTO `SIGNATURE` VALUES (22, 4); INSERT INTO `SIGNATURE` VALUES (39, 1); INSERT INTO `SIGNATURE` VALUES (40, 2); -- -- Contenu de la table `PROFESSIONAL_SITUATION` -- INSERT INTO `PROFESSIONAL_SITUATION` VALUES (2, 'Student'); INSERT INTO `PROFESSIONAL_SITUATION` VALUES (3, 'Determined ended contract'); INSERT INTO `PROFESSIONAL_SITUATION` VALUES (4, 'Endless contract'); INSERT INTO `PROFESSIONAL_SITUATION` VALUES (5, 'Interim'); INSERT INTO `PROFESSIONAL_SITUATION` VALUES (6, 'Unemployed person'); INSERT INTO `PROFESSIONAL_SITUATION` VALUES (7, 'Retired'); INSERT INTO `PROFESSIONAL_SITUATION` VALUES (8, 'Independent'); -- -- Contenu de la table `FLAT_TYPE` -- INSERT INTO `FLAT_TYPE` VALUES (1, '1 main room'); INSERT INTO `FLAT_TYPE` VALUES (2, '2 main rooms'); INSERT INTO `FLAT_TYPE` VALUES (3, '3 main rooms'); INSERT INTO `FLAT_TYPE` VALUES (4, '4 main rooms'); INSERT INTO `FLAT_TYPE` VALUES (5, '5 main rooms'); INSERT INTO `FLAT_TYPE` VALUES (6, 'Studio'); -- -- Contenu de la table `TOWN` -- INSERT INTO `TOWN` VALUES (2, 'Butare'); INSERT INTO `TOWN` VALUES (3, 'Byumba'); INSERT INTO `TOWN` VALUES (4, 'Cyangugu'); INSERT INTO `TOWN` VALUES (5, 'Gikongoro'); INSERT INTO `TOWN` VALUES (6, 'Gisenyi'); INSERT INTO `TOWN` VALUES (7, 'Gitarama');