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]}
17 years, 5 months
- 5
- 4
[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');
17 years, 5 months
- 1
- 0
[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.
17 years, 5 months
- 2
- 1
[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
17 years, 5 months
- 3
- 4
questions about descriptions
by Cdrick
I think I will be interested in specific descriptions and before trying
to code them or whatever else, here are what I need... Mostly here to
discuss on solutions to do that without "breaking" Magritte ;)
- will it be good to have something like a nested descriptions
(MANestedContainer ??). I have to represent event and according to the
type of event (human or natural), the option list is different. How to
you do that ? using a nesting container (that doesn't exist yet) or
using two descriptions with maybe a MADynamic object for the second
description linked to the first one...
- second point, I will probably need to represent a "physical"
measurement (with a unit or an intensity). Units or descriptions of
intensity can be different according to what is measured. So here, what
would you do ? using nested description ? What about creating a
MAMeasurementDescription but if so, will it be a subclass of
MAElementDescription and then MAMagnitudeDescription or will it be a
subclass of MAContainer or even of MADescription ?
Thanks
Cédrick
17 years, 5 months
- 2
- 3
Layout component
by Cdrick
Just an email to make some remarks... maybe useless, so if I say
something stupid tell it ;)
First, I found the name of Pier really good. It really reflects that it
is more than a wiki (for me the wiki is just a component among
others...). Pier is a framework where you can attach and organize
seaside application (component)...
so I was wandering Lukas if you plan to make a specific component to
organize the application Layout. It is done now in the environnement
edit... so with a wiki syntax... and maybe it's possible to create a
specific component for it that could be organized dynamically with ajax
like in the google personnalized main page
(http://cdrick.free.fr/googlePersonalized.png /I was moving the "RSS
component" Musiciens.biz during the capture/)...
Do you think it is possible, interesting ? I wish I could create such a
component but I actually have some doubt :d
Anyway Thanks for all this great work (especially magritte for me ;) )
See you
Cédrick
17 years, 5 months
- 3
- 2
[PIER] MAOneToManyComponent>>add without duplicates
by Damien Cassou
Hi all,
I modified the MAOneToManyComponent>>add method not to accept the
duplicated :
MAOneToManyComponent>>add
[...]
(result notNil and: [(self value includes: result) not])
ifTrue: [ self value: (self value copyWith: result); refresh ].
Bye
17 years, 6 months
- 1
- 0
RE: Autofocus
by Ramon Leon
Good enough, appreciate the explanation.
> -----Original Message-----
> From: owner-smallwiki(a)iam.unibe.ch
> [mailto:owner-smallwiki@iam.unibe.ch] On Behalf Of Lukas Renggli
> Sent: Tuesday, December 06, 2005 2:42 AM
> To: smallwiki(a)iam.unibe.ch
> Subject: Re: Autofocus
>
> > Anyone know what happened to autofocus on magritte descriptions?
> > With this gone, how are you currently putting the cursor in
> the first
> > field when an edit form appears?
>
> I removed it.
>
> The problem was basically because there is no good place to
> put this property and the following problems:
>
> - you could have multiple descriptions within the same form
> where auto-focus was set to true, especially when composing
> descriptions at runtime from several different sources.
>
> - #autofocus: did not work with some more complex
> form-elements like one-to-one, one-to-many, multiple-selection, ...
>
> - when changing from WAHtmlRenderer to WACanvasRenderer there
> was no replacement for the method #autofocus:, however this
> could be easily added again.
>
> - I felt that is unnecessary to have #autofocus: in the
> description itself, if you really need to automatically focus
> an element you probably do a sophisticated manual rendering anyway.
>
> - proper separation of view and meta-model, something
> Stéphane Ducasse and I just recently discussed: a problem in
> the current version of Magritte is that I mix meta-stuff and
> Seaside/Morphic configuration, such as #componentClass:,
> #attributes, #morphicClass,
> #autofocus: ... this should be the responsibility of a
> different object, not the description itself. It leads to
> some hard to tackle problems with extension-methods, if you
> want to use descriptions with/ without different
> view-implementations, however it is not easy to solve. Maybe
> something for Magritte 1.1 ;-)
>
> Lukas
>
> --
> Lukas Renggli
> http://www.lukas-renggli.ch
>
>
>
17 years, 6 months
- 1
- 0
RE: Magritte Validation Error
by Ramon Leon
> It is definitely not a conversion method, the resulting
> description is completely independent from the receiver of
> the message: it can be recomposed, reused with or without any
> other model instance. What is more, have you ever seen an
> #asClass conversion method to ask your instance for its
> meta-representation (#class)?
>
> Lukas
>
> --
> Lukas Renggli
> http://www.lukas-renggli.ch
Hmm.. that's a good point. My inclination is to toss the word meta in
there somewhere, it is after all metadata, but you already said you were
avoiding that. It's not that big a deal I guess, I just wanted to raise
the issue since it was a problem for me. I still think description is
far to useful an accessor in "any" problem domain to use it as an
extension on Object, I'd at least call it descriptor, but I'm not
complaining. I love the framework man, keep up the great work, I check
for updates daily and have learned quite a bit about Smalltalk style
from reading your code.
17 years, 6 months
- 2
- 3
Re: Stable SW1 version on squeaksource
by stéphane ducasse
Hi samir
I think that this is important that people willing to continue to
work on SmallWiki 1 takes control of it.
So this is good that you invest and shared.
Stef
> Hi,
>
> I put a stable version of smallwiki1 on squeaksource
> (http://www.squeaksource.com/smallwiki1 , SmallWiki-Kernel-stable and
> SmallWiki-Parser-stable). This version is currently used for
> squeak.org, and www.seaside.st, and seems stable as a rock ! The
> current version, available in squeakmap, will be renamed unstable. So
> for little and/or trivial features, just put them into the stable
> version on squeaksource (read/write access for everyone), and for big
> and important features, requiring some deep modification of the
> smallwiki1 kernel, probably shoud we work with the unstable branch
> (read/write access for everyone too).
>
> Let's share our contributions !
>
> Regards,
> Samir
17 years, 6 months
- 1
- 0