smallwiki

smallwiki@list.inf.unibe.ch

2312 discussions

by Timothy Reaves

Not too long ago (yesterday) I decided to re-check if Seaside had progressed in its maturity. It seems to done so. However, I was somewhat amazed that there was no app that seemed to be a poster- child for it's use. I shouldn't have been; it seems Smalltalk apps are there, just more difficult to find that those in other languages. Anyway. So I asked on the Seaside list about apps that showcased it; I had really expected there to be several in the vein of CMS, blog, web forums, and WIKIs. As I am really wanting to switch from OpenCMS, I had hoped... So someone there recommended I look at Pier (as I'm sure most of the people here also read that list, big surprise). I truly am impressed. The sample out of the box looks amazingly good for a WIKI. I tend to subscribe to the clea, non-clutered approach to web apps. And just looking at the default app makes it seem Pier / Seaside is just the ticket (as another wish item is to be able to develop on the web, as I travel every week). I've started looking at Pier's code, and unfortunately, I'd have to say it's not the clearest. This may simply be because I've only been looking at it for several hours over the last day. But the other issue is the lack of documentation. Of course, this applies equally - if not more - to Seaside. What I'm looking for is documentation on at least getting up-and-running with my own instance of the app. The default install creates the mini-intro WIKI: am I simply supposed to remove all the content there and replace with my own? That doesn't seem correct. At least, I'd be concerned about the default classes/ instances being over-written when I upgraded. Continuing in that vain, documentation covering where / how my data is stored / saved is critical. If I want a backup of my WIKI at a point in time, do I just simply file-out, well, what? Documentation on design and extensibility would be great, although I understand those would not be of the same importance as to getting them written. Lastly (for the moment anyway :-} ), I understand that Pier is a relatively new app, and there is adequate warning that this is experimental software, use at your own risk, not in production, etc. Well, I'm looking for some stable. And able to be used in a production environment. Does that mean I should stop looking at Pier? Is there a timeline for when a stable, production quality version will be available? Please do not infer from anything here that this is a bitch e-mail. I've not intended it as such. I just find Pier very promising, and want to use it. I'm just tired of needing to switch products (like JSPWiki, then OpenCMS, etc.) when I find that I've reached the limit of what they can do, or in OpenCMS' case, where the source code is so bad that there is no hope of me contributing to cleaning it up. Thanks for your time (and hopefully answers).

19 years

CSS question

by Timothy Reaves

I don't have a good understanding of how CSS is applied. I see in the source view of the page several references to CSS files, but I do not understand what generates those entities. Would someone explain? Thanks.

19 years

# of instances...

by Timothy Reaves

It I keep calling PRPierFrame.initialize, can I just keep creating instances? Or should each image only run one? Also, what is the difference in what name I give the kernel, and the context? Couldn't you just use the same name for both? Or is the name of the kernel relevant when upgrading Pier versions?

19 years

Reinstalled, and a new browser is there...

by Timothy Reaves

I just did a re-install on Seaside & Pier into a clean image. This time, I took a little time and browsed a few of the packages first. I came across OmniBrowser. This looked interesting, so I installed it. Then, when I installed Pier, a PierBrowser opened. This had not happened before. Did I miss something in the docs saying that OmniBrowser was something Pier interacted with, and to install it beforehand? Am I correct in the connection? Thanks.

19 years

[ANN][PR][MA] New Releases on SqueakMap

by Lukas Renggli

I published the latest code of Magritte and Pier on SqueakMap: * Magritte: Not many changes, but a few bug-fixes and small improvements. The reporting part is still experimental and incomplete, so don't complain about that ;-) * Pier: A lot of minor changes, fixes, improvements and a couple of new hooks to ensure easier extensibility without the use of overrides. Pier works with the latest version of Seaside and fully supports bookmark-able URLs on all its links. When updating an existing instance, take care that I changed the names of PRSeasideFrame, PRSeasideMain, PRSeasideConfiguration to PRPierFrame, PRPierMain, PRPierConfiguration; this might require that you re-register your kernel as a Seaside application. * Pier Unix Security: A new experimental package providing a simple unix like security system, using no overrides and being fully integrated (thanks to Magritte) into all currently available views (Seaside, Pier). When loading this package all the prerequisites such as Magritte and Pier and Seaside (if requested) will be automatically loaded. The default user name/password is admin/pier. To add/change user/groups it is required to directly use the image. Have fun, Lukas -- Lukas Renggli http://www.lukas-renggli.ch

19 years

Re: [Seaside] Pier question

by Lukas Renggli

> I realize that this is not a Seaside question directly, but I'm > interested in using Peir with Seaside. Problem is, I find no docs on > Pier, nor a website. Am I simply overlooking it? Pier was formerly called "SmallWiki 2", so you might find some information if you are looking for that. The following documentation is currently available: * I am about to setup a new website for Pier on my server (running with Pier), for now you can find some information at http://smallwiki.unibe.ch/smallwiki/smallwiki2/ (maintained by Damien Cassou, thanks). * There is a mailing-list about Magritte and Pier at http://www.iam.unibe.ch/cgi-bin/majordomo called smallwiki(a)iam.unibe.ch. An archive is available at http://impara.de/pipermail/smallwiki/. * There is also a about SmallWiki 2 (Pier), giving some more details. Right now there is no download, because it hasn't been published yet, but there will be probably soon and I can send it to anyone interested. * Yeah, from time to time I even some class comments ;-) Later today I will publish a new version with many fixes on SqueakMap. Stay tuned. Cheers, Lukas -- Lukas Renggli http://www.lukas-renggli.ch

19 years

MessageNotUnderstood: WAAnchorTag>>context

by Damien Cassou

Hi, I've installed Seaside2.6a2-pmm79, Magritte-All-lr.109 and Pier-All-lr.31 on a fresh Squeak3.8-6665. The examplebrowser is not accessible anymore. It seems there is a problem in WAAnchorTag>>url which refers to a non existant #context. Image: Squeak3.8 [latest update: #6665] SecurityManager state: Restricted: false FileAccess: true SocketAccess: true Working Dir /tmp/squeak Trusted Dir /tmp/squeak/secure Untrusted Dir /tmp/squeak/My Squeak WAAnchorTag(Object)>>doesNotUnderstand: #context Receiver: a WAAnchorTag Arguments and temporary variables: aMessage: context Receiver's instance variables: parent: a WATableDataTag canvas: a WARenderCanvas isClosed: nil attributes: a WAHtmlAttributes url: nil callbackKey: '16' promptString: nil WAAnchorTag>>url Receiver: a WAAnchorTag Arguments and temporary variables: Receiver's instance variables: parent: a WATableDataTag canvas: a WARenderCanvas isClosed: nil attributes: a WAHtmlAttributes url: nil callbackKey: '16' promptString: nil WAAnchorTag>>href Receiver: a WAAnchorTag Arguments and temporary variables: Receiver's instance variables: parent: a WATableDataTag canvas: a WARenderCanvas isClosed: nil attributes: a WAHtmlAttributes url: nil callbackKey: '16' promptString: nil [] in WAAnchorTag>>with: {[self href asString]} Arguments and temporary variables: aBlock: [] in MADescribedColumn(MAColumn)>>renderHeadCellOn: {[self renderHeadC...etc... --- The full stack --- WAAnchorTag(Object)>>doesNotUnderstand: #context WAAnchorTag>>url WAAnchorTag>>href [] in WAAnchorTag>>with: {[self href asString]} - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - [] in WAHtmlAttributes>>at:ifAbsentPut: {[self attributes add: keyString -> errBlock value]} Array(Collection)>>detect:ifNone: WAHtmlAttributes>>at:ifAbsent: WAHtmlAttributes>>at:ifAbsentPut: WAAnchorTag>>with: [] in MADescribedColumn(MAColumn)>>renderHeadCellOn: {[self isSortable ifTrue: [html anchor callback: [self report sort: sel...]} BlockContext>>renderOn: WATableDataTag(WATagBrush)>>within: [] in WATableDataTag(WATagBrush)>>with: {[self within: aBlock]} BlockContext>>renderOn: WARenderCanvas(WACanvas)>>nest: WATableDataTag(WABrush)>>with: WATableDataTag(WATagBrush)>>with: MADescribedColumn(MAColumn)>>renderHeadCellOn: [] in MAReport>>renderTableHeadOn: {[:each | each renderHeadCellOn: html]} Array(SequenceableCollection)>>do: [] in MAReport>>renderTableHeadOn: {[self columns do: [:each | each renderHeadCellOn: html]]} BlockContext>>renderOn: WAGenericTag(WATagBrush)>>within: [] in WAGenericTag(WATagBrush)>>with: {[self within: aBlock]} BlockContext>>renderOn: WARenderCanvas(WACanvas)>>nest: WAGenericTag(WABrush)>>with: WAGenericTag(WATagBrush)>>with: MAReport>>renderTableHeadOn: [] in MAReport>>renderTableOn: {[self showHeader ifTrue: [self renderTableHeadOn: html]]} BlockContext>>renderOn: WAGenericTag(WATagBrush)>>within: [] in WAGenericTag(WATagBrush)>>with: {[self within: aBlock]} BlockContext>>renderOn: WARenderCanvas(WACanvas)>>nest: WAGenericTag(WABrush)>>with: WAGenericTag(WATagBrush)>>with: MAReport>>renderTableOn: [] in MAReport>>renderContentOn: {[self renderTableOn: html]} BlockContext>>renderOn: WATableTag(WATagBrush)>>within: [] in WATableTag(WATagBrush)>>with: {[self within: aBlock]} BlockContext>>renderOn: WARenderCanvas(WACanvas)>>nest: WATableTag(WABrush)>>with: WATableTag(WATagBrush)>>with: MAReport>>renderContentOn: MAReport(WAPresenter)>>renderWithContext: [] in MAReport(WAComponent)>>renderOn: {[:each | each renderWithContext: aRenderer context]} MAReport(WAComponent)>>decorationChainDo: MAReport(WAComponent)>>renderOn: WARenderCanvas>>render: MAOneToManyComponent>>renderViewerOn: MAOneToManyComponent(MAElementComponent)>>renderContentOn: MAOneToManyComponent(WAPresenter)>>renderWithContext: [] in MAOneToManyComponent(WAComponent)>>renderOn: {[:each | each renderWithContext: aRenderer context]} MAOneToManyComponent(WAComponent)>>decorationChainDo: MAOneToManyComponent(WAComponent)>>renderOn: WARenderCanvas>>render: MATableRenderer(MAComponentRenderer)>>renderControl: [] in MATableRenderer>>renderControl: {[super renderControl: aDescription]}

19 years

[GestionImmo]

by Damien Cassou

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

19 years

[Magritte] Remove on OneToManyComponent does not remove

by Damien Cassou

When you click the remove link in a report for OneToManyComponent, the element is removed from the report but is still in the memory. Here are steps to reproduce : Open : http://localhost:8080/seaside/examplebrowser Click Edit In 'Phone numbers' click Add Put values inside fields and Save Give a first name and a last name Save the form Remove the phone number Click Edit In 'Phone numbers' click Add Put values inside fields and Save The two phone numbers are displayed even if we removed one.

19 years

[ANN] Central Magritte/Pier Code Repository

by Lukas Renggli

Hi, due to the increasing demand to have a central Magritte and Pier code repository, I migrated all my existing version to a new squeak-source repository at http://mc.lukas-renggli.ch. All the development will now go trough this interface. URLs to load the latest version of Magritte and Pier should still be working, however if you had a password to commit code into those directories it won't work anymore. Please register an account and I will add you to the appropriate projects. http://mc.lukas-renggli.ch/magritte http://mc.lukas-renggli.ch/pier I also created two projects for add-ons to Magritte and Pier, that are ment as places to put small-extensions you want to put into public, such as a new description type for Magritte or a new widget for Pier. Those two repositories have got public write rights. http://mc.lukas-renggli.ch/magritteaddons http://mc.lukas-renggli.ch/pieraddons If you have your own projects that you would like to share, feel free to register your own project. Lukas -- Lukas Renggli http://www.lukas-renggli.ch

19 years, 1 month

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

smallwiki