Squeak-dev December 2005

squeak-dev@lists.squeakfoundation.org

129 participants
187 discussions

REMINDER: Squeak Chat Saturday December 31st 16:00 GMT
by Ken Causey 30 Dec '05

30 Dec '05

Just a reminder that the next Squeak Chat will take place between 16:00 (4 PM) and 20:00 (8 PM) GMT Saturday December 31st, 2005. As usual we will meet in #squeak on irc.freenode.net. More information about the #squeak IRC channel can be found at http://people.squeakfoundation.org/article/7.html This is a good time to contribute to the development of Squeak by participating in the Harvesting Process. One of the main ways to contribute is by Reviewing submitted fixes and enhancements. For information about the Harvesting Process see http://minnow.cc.gatech.edu/squeak/3152 If you have the time please attend and work toward the future of Squeak. The next seven chats are scheduled for 20:00 (08:00 PM) GMT Wednesday January 04, 2006 00:00 (12:00 AM) GMT Monday January 09, 2006 04:00 (04:00 AM) GMT Friday January 13, 2006 08:00 (08:00 AM) GMT Tuesday January 17, 2006 12:00 (12:00 PM) GMT Saturday January 21, 2006 16:00 (04:00 PM) GMT Wednesday January 25, 2006 20:00 (08:00 PM) GMT Sunday January 29, 2006

1 0

OmniBase questions
by Pavel Krivanek 30 Dec '05

30 Dec '05

Hi, I’ve got several questions related to OmniBase usage: 1) File locking on Windows When I open a database session and process a transaction and then I try to connect new user, OODBStreamLockedNotification is raised. OmniBase then wants a confirmation of "File can not be read because it is locked. Do you want to try again ?". What is the best default answer? True causes long delay before the connection of new user. If false is chosen, fileIOError should be raised but nothing happens and new connection works well. 2) Object sharing between transactions If I’m not wrong, in case I want to modify a database object, I have to use transaction with explicit access to database object from the root. So If I want use the same object in two or more independent transactions, I cannot identify the object by its direct reference but I have to use something like primary key or oid, right? How to make it more comfortable? Is a way how to identify and use database object without access from root and searching in collections? 3) Index updating For example I have a collection of events an index by date of event. Then I modify an event that was not found by this index (I have no direct iterator). Do I have to find this event in date index manually, remove it and then add it again? Is there another way how access to index record directly? Thank you -- Pavel

5 10

Any 'delete' like message for object?
by Hilaire Fernandes 30 Dec '05

30 Dec '05

I was believing the release message was called when objet are garbage collected. It appears it is not the case. What is the standard way to do some clean up before forgetting about objet? Should it be done 'by hand' before? Hilaire

2 1

(newbie) String / Array / ArrayedCollection
by Tim Johnson 30 Dec '05

30 Dec '05

Hi everybody, Quick question. What is the quick way to get an Array of strings back into one String? Do I have to use a ReadStream / WriteStream? Example: 'A series of words to be shuffled' substrings shuffled -> #('of' 'series' 'words' 'A') Thanks, Tim

4 4

RV: [Morphic] [Q] About SyntaxErrorNotification missed methods
by Lic. Edgar J. De Cleene 29 Dec '05

29 Dec '05

------ Mensaje reenviado De: Juan Vuletich <jmvsqueak(a)uolsinectis.com.ar> Fecha: Thu, 29 Dec 2005 08:52:25 -0300 Para: "Lic. Edgar J. De Cleene" <edgardec2001(a)yahoo.com.ar>, <morphic(a)lists.squeakfoundation.org> Asunto: Re: [Morphic] [Q] About SyntaxErrorNotification missed methods guess you should ask in Squeak-dev, and after getting some answers, add a bug report to Mantis... If these methods used to be in some package, you could ask the package maintainers too. Cheers, Juan ----- Original Message ----- From: "Lic. Edgar J. De Cleene" <edgardec2001(a)yahoo.com.ar> To: <morphic(a)lists.squeakfoundation.org> Sent: Thursday, December 29, 2005 6:45 AM Subject: [Morphic] [Q] About SyntaxErrorNotification missed methods > Guys , I do the rest of the job with Squeak 3.9 6705 what is the last > Squeak > without Traits. > I wish know if you noticed what the following methods seems missed > > SyntaxErrorNotification class-inClasswithCodedoitFlag > > SyntaxErrorNotification-setClasscodedebuggerdoitFlag > > I refile both with no observable collateral effects . > What we should do, file a bug report in Mantis or what ? > > Edgar ------ Fin del mensaje reenviado Well , the messages goes to squeakdev too. Maybe exists very good reasons of why this two methods was ripped. So I repeat, someone could say if this was part of refactoring the image ? To which team or person belongs SyntaxErrorNotification ? Edgar ___________________________________________________________ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar

2 2

Can't rename a class with RB and 6706
by Damien Cassou 29 Dec '05

29 Dec '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I just submitted a bug : http://bugs.impara.de/view.php?id=2440 Does somebody can reproduce this ? Bye -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDtBGh3hhx1vOEX5sRAuTpAKCaZIOiAbsgLm1F0J1UYcI0fhUJ/wCcCK92 FUU110nWZtLA8uFXoxzGgQg= =kV0W -----END PGP SIGNATURE-----

1 0

[ANN] SmallLint Failure Model
by Hernan Wilkinson 29 Dec '05

29 Dec '05

Hi, I uploaded to Squeak Map a package to deal with the SmallLint failures. The package name is: Small Lint Failure <http://map.squeak.org/accountbyid/ce6957eb-c5ff-4a6e-a575-a1467238905e/pack…> The idea of this module is to declare smalllint failures as expected, so when SmallLint is run again, the expected failures will not appear. For example, let's say that there is a long method in ClassA>>method1. If SmallLint is ran, it will detect that error (long method) and it will report it. But suppose that the method, for some reason, can not be refactored in smaller ones... the next time SmallLint is run, it will report the same error even though you know it is not. The problem with this behavior is that the programmer gets tired of this "expected" smalllint failures and he will stop running SmallLint because of that.... SmallLint it is not prepared to be run continuously, in an automatic process because this expected failures will pop up. This module let's the programmer declare this expected failures so they are not reported when SmallLint is run. To declare this "expected" long method failure, it is very simple as it is shown below: ClassA class>>expectedSmallLintFailures "Each class that has expected SmallLint failures has to declared this method which returns a collection of expected failures" ^Array with: (ExpectedSmallLintFailure longMethodsFailedClass: self failedMethod: 'method1' asSymbol reasonDescription: 'The method can not be refactored in smaller ones' definedBy: 'Hernan') As you can see in the example, an ExpectedSmallLintFailure is created for the longMethods failure. The failure is for ClassA (self), the failedMethod: is #method1 (see that I wrote 'method1' asSymbol because I don't want to have references to #method1 because SmallLint will treat it as a sender when it is not), the reason because it is declare as expected is that the method can not be refactored and Hernan (me) declared it. This module helps the programmer to treat this smalllint failures, but it also allows the programmer to document the reason of the failure. For each smallLint failure, there is a message to create it in the class ExpectedSmallLintFailure. The module has a test for each failure so you can see how it works also. To be able to run it from the refactoring browser, the following methods have to be changed: RefactoringBrowser>>addClassSubMenuTo: aMenu "Added to to support the small lint failure model" lintSubMenu addLine; add: 'expected failures on class...' translated action: #expectedSmallLintOnClass; add: 'expected failures on class category...' translated action: #expectedSmallLintOnClassCategory; add: 'expected failures on class hierarchy...' translated action: #expectedSmallLintOnClassHierarchy. pkg ifNotNil: [lintSubMenu add: 'expected failures on package...' translated action: #expectedSmallLintOnPackageWithClassCategory]. "End of small lint failure model support" RefactoringBrowser>>systemCategoryMenu: aMenu "Added to integrate the browser with the small lint failures model - Hernan" lintSubMenu addLine; add: 'expected failures on class category...' translated action: #expectedSmallLintOnClassCategory; add: 'expected failures on package...' translated action: #expectedSmallLintOnPackageWithClassCategory. "End of addition" Well, I hope you will enjoy it!. We use it at work in our integration process and it is very helpful. We don't do it with all the modules, but with those we mark as "stable". Having no smalllint failure give us a lot of confidence in our code, like the unit test do. Hernan. -- ______________________________ Lic. Hernán A. Wilkinson Gerente de Desarrollo y Tecnología Mercap S.R.L. Tacuari 202 - 7mo Piso - Tel: 54-11-4878-1118 Buenos Aires - Argentina http://www.mercapsoftware.com --------------------------------------------------------------------- Este mensaje es confidencial. Puede contener informacion amparada por el secreto profesional. Si usted ha recibido este e-mail por error, por favor comuniquenoslo inmediatamente via e-mail y tenga la amabilidad de eliminarlo de su sistema; no debera copiar el mensaje ni divulgar su contenido a ninguna persona. Muchas gracias. This message is confidential. It may also contain information that is privileged or otherwise legally exempt from disclosure. If you have received it by mistake please let us know by e-mail immediately and delete it from your system; you should also not copy the message nor disclose its contents to anyone. Thanks. ---------------------------------------------------------------------

2 1

[GestionImmo]
by Damien Cassou 29 Dec '05

29 Dec '05

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

1 0

Re: Which OS
by Chris Muller 29 Dec '05

29 Dec '05

>> Not a bad idea. Maybe an april1 release that reverses all the >> pixels? Yea, but that's no joke, it is actually a useful function. I've long wanted something like this settable in BitBlt (or wherever) to easily toggle between day/night mode. Eventually I did it the "hard" way with "inverteBright" which is tons of code and far from ideal..

2 1

Humor break
by Alan Lovejoy 28 Dec '05

28 Dec '05

"Smalltalk is an amazing and legendary language divulged to humans by Prometheus. This angered the gods enough they condemned him to refactor a big ball of Hadean mud for all eternity." First paragraph from http://www.approximity.com/cgi-bin/blogtariAgile/index.rb/Smalltalk/onSTL.rd oc (the Approximity blog). It gets better (or worse) after that :-) --Alan

1 0

Jump to page: