

INSERT INTO link(userId,contactId) values('1','2');
INSERT INTO link(userId,contactId) values('1','3');
INSERT INTO link(userId,contactId) values('1','4');

INSERT INTO list(userId,listName) values('1','MyListName');
INSERT INTO member(listId,linkId) values('1','1');
INSERT INTO member(listId,linkId) values('1','2');

INSERT INTO venue (ownerId,name,email,phoneNumber,longitude,latitude,country,postalCode,region,address,description,status)
            values('1','MyVenue1','myvenue1@gmail.com','003281345678','5.654104','51.642562','Belgium','5000','Namur','Adress of venue1','This is the venue1','available');

INSERT INTO plan (name,organizerId,venueId,startTime,description)
            values('Plan1','1','1','2010-10-29 22:00:00','This is my first plan.');
INSERT INTO invitation (planId,userId,status) values ('1','1','accepted');
INSERT INTO invitation (planId,userId,status) values ('1','2','pending');
INSERT INTO invitation (planId,userId,status) values ('1','3','pending');

INSERT INTO comment (planId,userId,time,comment) values('1','1','2010-10-29 21:30:00','This is my comment about the first plan.');

INSERT INTO plan (name,organizerId,venueId,startTime,description)
            values('Plan2','2','1','2010-10-29 22:00:00','This is the second plan.');
INSERT INTO invitation (planId,userId,status) values ('2','1','pending');
INSERT INTO invitation (planId,userId,status) values ('2','2','accepted');
INSERT INTO invitation (planId,userId,status) values ('2','3','pending');

INSERT INTO plan (name,organizerId,venueId,startTime,description)
            values('Plan3','2','1','2010-10-29 22:00:00','This is the third plan.');
INSERT INTO invitation (planId,userId,status) values ('3','1','pending');
INSERT INTO invitation (planId,userId,status) values ('3','2','accepted');
INSERT INTO invitation (planId,userId,status) values ('3','3','pending');
