NyDUSd0s

1DROP TABLE IF EXISTS users CASCADE;
2DROP TABLE IF EXISTS cards CASCADE;
3DROP TABLE IF EXISTS items CASCADE;
4
5-- Tables
6
7DROP TABLE IF EXISTS Category CASCADE;
8DROP TABLE IF EXISTS Country CASCADE;
9DROP TABLE IF EXISTS City CASCADE;
10DROP TABLE IF EXISTS Localization CASCADE;
11DROP TABLE IF EXISTS Admin CASCADE;
12DROP TABLE IF EXISTS AuthenticatedUser CASCADE;
13DROP TABLE IF EXISTS Photo CASCADE;
14DROP TABLE IF EXISTS Invitation CASCADE;
15DROP TABLE IF EXISTS Message CASCADE;
16DROP TABLE IF EXISTS Event CASCADE;
17DROP TABLE IF EXISTS EventCategory CASCADE;
18DROP TABLE IF EXISTS EventParticipant CASCADE;
19DROP TABLE IF EXISTS Participate CASCADE;
20DROP TABLE IF EXISTS EventOwner CASCADE;
21DROP TABLE IF EXISTS OwnEvent CASCADE;
22DROP TABLE IF EXISTS File CASCADE;
23DROP TABLE IF EXISTS Post CASCADE;
24DROP TABLE IF EXISTS Poll CASCADE;
25DROP TABLE IF EXISTS PollVote CASCADE;
26DROP TABLE IF EXISTS PollOption CASCADE;
27
28CREATE TABLE Category (
29   id SERIAL NOT NULL,
30   name text NOT NULL
31);
32
33CREATE TABLE Country (
34   id SERIAL NOT NULL,
35   name text NOT NULL
36);
37
38
39
40
41
42CREATE TABLE City (
43   id SERIAL NOT NULL,
44   name text NOT NULL,
45   id_country integer NOT NULL
46);
47
48CREATE TABLE Localization (
49   id SERIAL NOT NULL,
50   street text,
51   latitude double precision  NOT NULL,
52   longitude double precision  NOT NULL,
53   id_city integer
54);
55
56CREATE TABLE Admin (
57   id SERIAL NOT NULL,
58   email text NOT NULL,
59   firstName text NOT NULL,
60   password text NOT NULL,
61   lastName text NOT NULL,
62   username text NOT NULL
63);
64
65CREATE TABLE AuthenticatedUser (
66   id SERIAL NOT NULL,
67   email text,
68   firstName text NOT NULL,
69   password text NOT NULL,
70   lastName text NOT NULL,
71   username text NOT NULL,
72   id_photo integer,
73   id_city integer
74);
75
76CREATE TABLE Photo (
77   id SERIAL NOT NULL,
78   path text NOT NULL,
79      id_event integer
80);
81
82CREATE TABLE Invitation (
83   id SERIAL NOT NULL,
84   status text,
85   id_receiver integer NOT NULL,
86   id_sender integer NOT NULL,
87   id_event integer NOT NULL,
88   "date" timestamp with time zone DEFAULT now() NOT NULL,
89   CHECK (id_sender != id_receiver)
90);
91
92CREATE TABLE Message (
93   id SERIAL NOT NULL,
94   content text NOT NULL,
95   id_sender integer NOT NULL,
96   id_receiver integer NOT NULL,
97   "date" timestamp with time zone DEFAULT now() NOT NULL
98);
99
100CREATE TABLE Event (
101   id SERIAL NOT NULL,
102   description text NOT NULL,
103   title text NOT NULL,
104   is_Public BOOLEAN NOT NULL,
105   id_localization integer NOT NULL,
106   "date" timestamp with time zone DEFAULT now() NOT NULL
107);
108
109CREATE TABLE EventCategory (
110   id_event integer NOT NULL,
111   id_category integer NOT NULL
112);
113
114CREATE TABLE EventParticipant (
115   id_user integer NOT NULL
116);
117
118CREATE TABLE Participate (
119  id_eventParticipant integer NOT NULL,
120  id_event integer NOT NULL,
121  classification integer CHECK (((classification > 0) AND (classification <= 5)))
122);
123
124CREATE TABLE EventOwner (
125     id_eventParticipant integer NOT NULL
126);
127
128CREATE TABLE OwnEvent (
129   id_eventOwner integer NOT NULL,
130   id_event integer NOT NULL
131);
132
133CREATE TABLE File (
134   id SERIAL NOT NULL,
135   id_event integer NOT NULL,
136   id_eventParticipant integer NOT NULL,
137   path text NOT NULL,
138   submittedDate timestamp with time zone DEFAULT now() NOT NULL
139);
140
141CREATE TABLE Post (
142   id SERIAL NOT NULL,
143   content text NOT NULL,
144   id_poster integer NOT NULL,
145   id_event integer NOT NULL,
146   "date" timestamp with time zone DEFAULT now() NOT NULL
147);
148
149CREATE TABLE Poll (
150   id SERIAL NOT NULL,
151   description text NOT NULL,
152   id_owner integer NOT NULL,
153   id_event integer NOT NULL,
154   "date" timestamp with time zone DEFAULT now() NOT NULL
155);
156
157CREATE TABLE PollVote (
158   id_poll_option integer NOT NULL,
159   id_eventParticipant integer NOT NULL
160);
161
162CREATE TABLE PollOption ( 
163   id SERIAL NOT NULL,
164   description text NOT NULL,
165   id_poll integer NOT NULL
166);
167
168-- Primary Keys and Uniques
169
170ALTER TABLE ONLY Category
171   ADD CONSTRAINT category_pkey PRIMARY KEY (id),
172   ADD CONSTRAINT name_category UNIQUE (name);
173
174ALTER TABLE ONLY Country
175   ADD CONSTRAINT country_pkey PRIMARY KEY (id);
176
177ALTER TABLE ONLY City
178   ADD CONSTRAINT city_pkey PRIMARY KEY (id);
179
180ALTER TABLE ONLY Localization
181   ADD CONSTRAINT localization_pkey PRIMARY KEY (id),
182   ADD CONSTRAINT localization_coordinates_key UNIQUE (latitude,longitude);
183
184ALTER TABLE ONLY Admin
185   ADD CONSTRAINT admin_email_key UNIQUE (email),
186   ADD CONSTRAINT admin_username_key UNIQUE (username);
187
188ALTER TABLE ONLY Admin
189   ADD CONSTRAINT admin_pkey PRIMARY KEY (id);
190
191ALTER TABLE ONLY AuthenticatedUser
192   ADD CONSTRAINT auth_user_email_key UNIQUE (email),
193   ADD CONSTRAINT auth_user_username_key UNIQUE (username),
194   ADD CONSTRAINT auth_user_id_photo_key UNIQUE (id_photo);
195
196ALTER TABLE ONLY AuthenticatedUser
197   ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);
198
199ALTER TABLE ONLY Photo
200   ADD CONSTRAINT photo_pkey PRIMARY KEY (id),
201   ADD CONSTRAINT path_key UNIQUE (path);
202
203ALTER TABLE ONLY Invitation
204   ADD CONSTRAINT invitation_pkey PRIMARY KEY (id);
205
206ALTER TABLE ONLY Message
207   ADD CONSTRAINT message_pkey PRIMARY KEY (id);
208
209ALTER TABLE ONLY Event
210   ADD CONSTRAINT event_pkey PRIMARY KEY (id);
211
212ALTER TABLE ONLY EventCategory
213   ADD CONSTRAINT event_category_pkey PRIMARY KEY (id_event, id_category);
214
215ALTER TABLE ONLY EventParticipant
216   ADD CONSTRAINT event_participant_pkey PRIMARY KEY (id_user);
217
218ALTER TABLE ONLY Participate
219   ADD CONSTRAINT participate_pkey PRIMARY KEY (id_eventParticipant, id_event);
220
221ALTER TABLE ONLY EventOwner
222   ADD CONSTRAINT event_owner_pkey PRIMARY KEY (id_eventParticipant);
223
224ALTER TABLE ONLY OwnEvent
225   ADD CONSTRAINT own_event_pkey PRIMARY KEY (id_eventOwner, id_event);
226
227ALTER TABLE ONLY File
228   ADD CONSTRAINT file_pkey PRIMARY KEY (id);
229
230ALTER TABLE ONLY Post
231   ADD CONSTRAINT post_pkey PRIMARY KEY (id);
232
233ALTER TABLE ONLY Poll
234   ADD CONSTRAINT poll_pkey PRIMARY KEY (id);
235
236ALTER TABLE ONLY PollVote
237   ADD CONSTRAINT poll_vote_pkey PRIMARY KEY (id_poll_option, id_eventParticipant);
238
239ALTER TABLE ONLY PollOption
240   ADD CONSTRAINT poll_option_pkey PRIMARY KEY (id);
241
242-- Foreign Keys
243
244ALTER TABLE ONLY City
245   ADD CONSTRAINT city_id_country_fkey FOREIGN KEY (id_country) REFERENCES Country(id) ON UPDATE CASCADE;
246
247ALTER TABLE ONLY Localization
248   ADD CONSTRAINT localization_id_city_fkey FOREIGN KEY (id_city) REFERENCES City(id) ON UPDATE CASCADE;
249
250ALTER TABLE ONLY AuthenticatedUser
251   ADD CONSTRAINT auth_user_id_photo_fkey FOREIGN KEY (id_photo) REFERENCES Photo(id) ON UPDATE CASCADE;
252
253ALTER TABLE ONLY AuthenticatedUser
254   ADD CONSTRAINT auth_user_id_city_fkey FOREIGN KEY (id_city) REFERENCES City(id) ON UPDATE CASCADE;
255
256ALTER TABLE ONLY Invitation
257   ADD CONSTRAINT invitation_id_receiver_fkey FOREIGN KEY (id_receiver) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;
258
259ALTER TABLE ONLY Invitation
260   ADD CONSTRAINT invitation_id_sender_fkey FOREIGN KEY (id_sender) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;
261
262ALTER TABLE ONLY Invitation
263   ADD CONSTRAINT invitation_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;
264
265ALTER TABLE ONLY Message
266   ADD CONSTRAINT message_id_sender_fkey FOREIGN KEY (id_sender) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;
267
268ALTER TABLE ONLY Message
269   ADD CONSTRAINT message_id_receiver_fkey FOREIGN KEY (id_receiver) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;
270
271ALTER TABLE ONLY Event
272   ADD CONSTRAINT event_id_localization_fkey FOREIGN KEY (id_localization) REFERENCES Localization(id) ON UPDATE CASCADE;
273
274ALTER TABLE ONLY EventCategory
275   ADD CONSTRAINT event_category_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;
276
277ALTER TABLE ONLY EventCategory
278   ADD CONSTRAINT event_category_id_category_fkey FOREIGN KEY (id_category) REFERENCES Category(id) ON UPDATE CASCADE;
279
280ALTER TABLE ONLY EventParticipant
281   ADD CONSTRAINT event_participant_id_user_fkey FOREIGN KEY (id_user) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;
282
283ALTER TABLE ONLY Participate
284   ADD CONSTRAINT participate_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;
285
286ALTER TABLE ONLY Participate
287   ADD CONSTRAINT participate_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;
288
289
290ALTER TABLE ONLY EventOwner
291   ADD CONSTRAINT event_owner_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;
292
293ALTER TABLE ONLY OwnEvent
294   ADD CONSTRAINT own_event_id_event_owner_fkey FOREIGN KEY (id_eventOwner) REFERENCES EventOwner(id_eventParticipant) ON UPDATE CASCADE;
295
296ALTER TABLE ONLY OwnEvent
297   ADD CONSTRAINT own_event_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE; 
298
299ALTER TABLE ONLY File
300   ADD CONSTRAINT file_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE; 
301
302ALTER TABLE ONLY File
303   ADD CONSTRAINT file_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE; 
304
305ALTER TABLE ONLY Post
306   ADD CONSTRAINT post_id_poster_fkey FOREIGN KEY (id_poster) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE; 
307
308ALTER TABLE ONLY Post
309   ADD CONSTRAINT post_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE; 
310
311ALTER TABLE ONLY Poll
312   ADD CONSTRAINT poll_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE; 
313
314ALTER TABLE ONLY Poll
315   ADD CONSTRAINT poll_id_owner_fkey FOREIGN KEY (id_owner) REFERENCES EventOwner(id_eventParticipant) ON UPDATE CASCADE; 
316
317ALTER TABLE ONLY PollVote
318   ADD CONSTRAINT poll_vote_id_poll_option_fkey FOREIGN KEY (id_poll_option) REFERENCES Poll(id) ON UPDATE CASCADE;
319
320ALTER TABLE ONLY PollVote
321   ADD CONSTRAINT poll_vote_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;
322
323ALTER TABLE ONLY PollOption
324   ADD CONSTRAINT poll_option_id_poll_fkey FOREIGN KEY (id_poll) REFERENCES Poll(id) ON UPDATE CASCADE;
325
326CREATE INDEX "EventRecent" ON event USING btree (date);
327
328CREATE INDEX name_category_idx ON category USING hash(name);
329
330CREATE INDEX "PostsPerEvent" ON post USING btree ( id_event);
331
332CREATE INDEX search_idx ON event USING gin(to_tsvector('english'::regconfig, description));
333
334CREATE INDEX search_event_per_title ON event USING GIST (to_tsvector('english', title));
335
336CREATE INDEX search_category ON category USING GIST (to_tsvector('english', name));
337
338DROP TRIGGER IF EXISTS only_owner_private_invite ON invitation;
339DROP FUNCTION IF EXISTS only_owner_private_invite() CASCADE;
340
341CREATE FUNCTION only_owner_private_invite() RETURNS TRIGGER AS
342$BODY$
343BEGIN
344IF EXISTS (SELECT *
345              FROM invitation INNER JOIN event
346              ON invitation.id_event = event.id
347              WHERE NEW.id_event = event.id AND event.is_public = false AND invitation.id_sender NOT IN (
348                   SELECT ownevent.id_eventOwner
349                   FROM ownevent
350                   WHERE ownevent.id_event = event.id
351              ) ) THEN
352  RAISE EXCEPTION 'A non owner cannot invite other users to a private event';
353END IF;
354RETURN NEW;
355END
356$BODY$
357LANGUAGE plpgsql;
358CREATE TRIGGER only_owner_private_invite
359BEFORE INSERT OR UPDATE ON invitation
360FOR EACH ROW
361  EXECUTE PROCEDURE only_owner_private_invite();
362
363  DROP TRIGGER IF EXISTS no_self_message ON message;
364DROP FUNCTION IF EXISTS no_self_message() CASCADE;
365
366CREATE FUNCTION no_self_message() RETURNS TRIGGER AS
367$BODY$
368BEGIN
369 IF EXISTS (SELECT * FROM message WHERE NEW.id_sender = NEW.id_receiver) THEN
370   RAISE EXCEPTION 'A user cannot send messages to himself';
371 END IF;
372 RETURN NEW;
373END
374$BODY$
375LANGUAGE plpgsql;
376CREATE TRIGGER no_self_message
377 BEFORE INSERT OR UPDATE ON message
378 FOR EACH ROW
379   EXECUTE PROCEDURE no_self_message();
380
381DROP TRIGGER IF EXISTS no_self_invitation ON invitation;
382DROP FUNCTION IF EXISTS no_self_invitation() CASCADE;
383
384CREATE FUNCTION no_self_invitation() RETURNS TRIGGER AS
385$BODY$
386BEGIN
387 IF EXISTS (SELECT * FROM invitation WHERE NEW.id_sender = NEW.id_receiver) THEN
388   RAISE EXCEPTION 'A user cannot send invitations to himself';
389 END IF;
390 RETURN NEW;
391END
392$BODY$
393LANGUAGE plpgsql;
394CREATE TRIGGER no_self_invitation
395 BEFORE INSERT OR UPDATE ON invitation
396 FOR EACH ROW
397   EXECUTE PROCEDURE no_self_invitation();
398
399DROP TRIGGER IF EXISTS no_participate_old_events ON participate;
400DROP FUNCTION IF EXISTS no_participate_old_events() CASCADE;
401
402CREATE FUNCTION no_participate_old_events() RETURNS TRIGGER AS
403$BODY$
404BEGIN
405 IF EXISTS (SELECT *
406            FROM participate INNER JOIN event
407            ON participate.id_event = event.id
408            WHERE NEW.id_event = event.id AND event.date < now()) THEN
409   RAISE EXCEPTION 'A user cannot join a finished event';
410 END IF;
411 RETURN NEW;
412END
413$BODY$
414LANGUAGE plpgsql;
415CREATE TRIGGER no_participate_old_events
416 BEFORE INSERT OR UPDATE ON participate
417 FOR EACH ROW
418   EXECUTE PROCEDURE no_participate_old_events(); 
419
420TRUNCATE "category","country","city","localization","admin","photo","authenticateduser","eventparticipant","event","invitation","message","eventcategory","participate","eventowner","ownevent", "file", "post", "poll", "polloption", "pollvote" CASCADE;
421INSERT INTO "category" (name) VALUES ('Dance and Theatre');
422INSERT INTO "category" (name) VALUES ('Clubbing');
423INSERT INTO "category" (name) VALUES ('Conferences');
424INSERT INTO "category" (name) VALUES ('Concerts');
425INSERT INTO "category" (name) VALUES ('Formation');
426INSERT INTO "category" (name) VALUES ('Gastronomy');
427INSERT INTO "category" (name) VALUES ('Children');
428INSERT INTO "category" (name) VALUES ('Fashion');
429INSERT INTO "category" (name) VALUES ('Academics');
430INSERT INTO "category" (name) VALUES ('Nature');
431INSERT INTO "category" (name) VALUES ('Travel');
432INSERT INTO "category" (name) VALUES ('Literature');
433
434INSERT INTO "country" (name) VALUES ('Portugal');
435INSERT INTO "country" (name) VALUES ('Spain');
436INSERT INTO "country" (name) VALUES ('France');
437INSERT INTO "country" (name) VALUES ('Switzerland');
438INSERT INTO "country" (name) VALUES ('Germany');
439INSERT INTO "country" (name) VALUES ('Netherlands');
440INSERT INTO "country" (name) VALUES ('Russia');
441INSERT INTO "country" (name) VALUES ('China');
442INSERT INTO "country" (name) VALUES ('Japan');
443INSERT INTO "country" (name) VALUES ('Italy');
444INSERT INTO "country" (name) VALUES ('Australia');
445INSERT INTO "country" (name) VALUES ('USA');
446
447INSERT INTO "city" (name,id_country) VALUES ('Porto', 1);
448INSERT INTO "city" (name,id_country) VALUES ('Faro', 1);
449INSERT INTO "city" (name,id_country) VALUES ('Madrid', 2);
450INSERT INTO "city" (name,id_country) VALUES ('Paris', 3);
451INSERT INTO "city" (name,id_country) VALUES ('Luzern', 4);
452INSERT INTO "city" (name,id_country) VALUES ('Frankfurt', 5);
453INSERT INTO "city" (name,id_country) VALUES ('Amsterdam', 6);
454INSERT INTO "city" (name,id_country) VALUES ('Beijing', 8);
455INSERT INTO "city" (name,id_country) VALUES ('Rome', 10);
456INSERT INTO "city" (name,id_country) VALUES ('Sydney', 11);
457INSERT INTO "city" (name,id_country) VALUES ('New York', 12);
458INSERT INTO "city" (name,id_country) VALUES ('Aveiro', 1);
459
460INSERT INTO "localization" (street,latitude,longitude,id_city)
461VALUES ('diam lorem, auctor','-57.83262','120.88352',10);
462INSERT INTO "localization" (street,latitude,longitude,id_city)
463VALUES ('Quisque purus sapien,','1.43736','-143.19847',4);
464INSERT INTO "localization" (street,latitude,longitude,id_city)
465VALUES ('Donec vitae erat','38.29072','109.41783',10);
466INSERT INTO "localization" (street,latitude,longitude,id_city)
467VALUES ('nec, malesuada ut,','72.75425','151.88681',2);
468INSERT INTO "localization" (street,latitude,longitude,id_city)
469VALUES ('amet orci. Ut','22.58932','-27.19582',8);
470INSERT INTO "localization" (street,latitude,longitude,id_city)
471VALUES ('sem egestas blandit.','46.45921','-39.02434',1);
472INSERT INTO "localization" (street,latitude,longitude,id_city)
473VALUES ('ac libero nec','-15.54521','55.05494',4);
474INSERT INTO "localization" (street,latitude,longitude,id_city)
475VALUES ('lacus. Nulla tincidunt,','-22.60314','38.78897',8);
476INSERT INTO "localization" (street,latitude,longitude,id_city)
477VALUES ('posuere vulputate, lacus.','17.20856','12.84046',9);
478INSERT INTO "localization" (street,latitude,longitude,id_city)
479VALUES ('venenatis vel, faucibus','75.18007','-41.27717',5);
480INSERT INTO "localization" (street,latitude,longitude,id_city)
481VALUES ('justo sit amet','73.17373','37.20697',7);
482INSERT INTO "localization" (street,latitude,longitude,id_city)
483VALUES ('Integer tincidunt aliquam','-4.79812','178.94257',4);
484INSERT INTO "localization" (street,latitude,longitude,id_city)
485VALUES ('Lorem ipsum dolor','65.09022','96.3736',9);
486INSERT INTO "localization" (street,latitude,longitude,id_city)
487VALUES ('eu eros. Nam','51.32303','-105.15054',1);
488INSERT INTO "localization" (street,latitude,longitude,id_city)
489VALUES ('posuere cubilia Curae;','-31.24328','-110.92501',3);
490INSERT INTO "localization" (street,latitude,longitude,id_city)
491VALUES ('Cras pellentesque. Sed','28.87859','-58.91476',5);
492INSERT INTO "localization" (street,latitude,longitude,id_city)
493VALUES ('parturient montes, nascetur','0.71294','178.77274',5);
494INSERT INTO "localization" (street,latitude,longitude,id_city)
495VALUES ('luctus et ultrices','-23.88917','-165.24832',9);
496INSERT INTO "localization" (street,latitude,longitude,id_city)
497VALUES ('cursus et, eros.','-76.6059','117.8904',12);
498INSERT INTO "localization" (street,latitude,longitude,id_city)
499VALUES ('ultrices iaculis odio.','77.72928','114.31794',3);
500
501INSERT INTO "admin" (email,firstName,password,lastName,username) 
502VALUES ('non@Sednunc.com','Pascale','LUD73ILG7BH','Moore','accumsan');
503INSERT INTO "admin" (email,firstName,password,lastName,username) 
504VALUES ('magna@vulputate.org','Stewart','FMK91UTU7VJ','Gonzalez','sodales.');
505INSERT INTO "admin" (email,firstName,password,lastName,username) 
506VALUES ('Suspendisse.aliquet@Nulla.net','Samuel','PWG57NUN3ZB','Flynn','id risus');
507INSERT INTO "admin" (email,firstName,password,lastName,username) 
508VALUES ('a.feugiat@id.edu','Janna','XNG10TUN6UA','Vasquez','faucibus lectus,');
509INSERT INTO "admin" (email,firstName,password,lastName,username) 
510VALUES('luctus@eleifendegestas.net','Clementine','CIU02ORP3MZ','Neal','consectetuer ipsum');
511INSERT INTO "admin" (email,firstName,password,lastName,username) 
512VALUES ('elit@nibh.com','Aimee','BIN74GSX7LS','Jenkins','eros');
513INSERT INTO "admin" (email,firstName,password,lastName,username) 
514VALUES('tincidunt.aliquam@pharetraNamac.org','Candace','QES41CBF6OB','Marshall','sed leo.');
515INSERT INTO "admin" (email,firstName,password,lastName,username) 
516VALUES ('consectetuer@Namnulla.net','Joseph','ZPD22RJN2DR','Ortiz','sagittis lobortis');
517INSERT INTO "admin" (email,firstName,password,lastName,username) 
518VALUES ('fermentum.arcu@tristiquesenectus.com','Zelenia','JPK04SQI8RM','Vargas','ornare. In');
519INSERT INTO "admin" (email,firstName,password,lastName,username) 
520VALUES ('sit.amet@sociosquad.edu','Ryder','WWT23VSW6MR','Gay','dignissim pharetra.');
521INSERT INTO "admin" (email,firstName,password,lastName,username) 
522VALUES ('fringilla@imperdiet.co.uk','Althea','ZNN00XQJ1VP','Ray','adipiscing');
523INSERT INTO "admin" (email,firstName,password,lastName,username) 
524VALUES('vel.est.tempor@ullamcorpervelitin.net','Uriel','PLL50RVJ0TO','Watkins','et tristique');
525INSERT INTO "admin" (email,firstName,password,lastName,username) 
526VALUES('aliquet@maurisIntegersem.co.uk','Odette','ZYU41PXX4JV','Carpenter','luctus felis');
527INSERT INTO "admin" (email,firstName,password,lastName,username)
528VALUES('consectetuer.mauris.id@vestibulummassa.edu','Benjamin','WWA23XAQ2PR','Mcdowell','tellus sem');
529INSERT INTO "admin" (email,firstName,password,lastName,username) 
530VALUES('at.velit.Pellentesque@Donecfringilla.org','Gillian','EYH37GZP5HR','Lara','Fusce diam');
531INSERT INTO "admin" (email,firstName,password,lastName,username) 
532VALUES ('massa@disparturientmontes.edu','Chelsea','EBZ86OOF2HY','Mullins','Cras vulputate');
533INSERT INTO "admin" (email,firstName,password,lastName,username) 
534VALUES ('Phasellus@nec.net','Tobias','CZR51YAW8VH','Bolton','magna.');
535INSERT INTO "admin" (email,firstName,password,lastName,username) 
536VALUES ('dolor.dapibus.gravida@libero.com','Ivory','DIF33ASG1SO','Browning','mi felis,');
537INSERT INTO "admin" (email,firstName,password,lastName,username) 
538VALUES ('Etiam@ornarelectus.net','Roanna','KMM31PWZ4BU','Taylor','Donec est.');
539INSERT INTO "admin" (email,firstName,password,lastName,username) 
540VALUES('egestas@montesnascetur.net','Jessica','KDK13ERS3ED','Gonzales','tincidunt pede');
541
542INSERT INTO "photo" (path) VALUES ('../elit/Nulla');
543INSERT INTO "photo" (path) VALUES ('../a/felisullamcorper');
544INSERT INTO "photo" (path) VALUES ('../sociosqu');
545INSERT INTO "photo" (path) VALUES ('../nonummyac,');
546INSERT INTO "photo" (path) VALUES ('../vulputate');
547INSERT INTO "photo" (path) VALUES ('../interdum');
548INSERT INTO "photo" (path) VALUES ('../nascetur');
549INSERT INTO "photo" (path) VALUES ('../enim/Mauris');
550INSERT INTO "photo" (path) VALUES ('../posuerecubilia/Curae;');
551INSERT INTO "photo" (path) VALUES ('../eros');
552INSERT INTO "photo" (path) VALUES ('../lectusjusto');
553INSERT INTO "photo" (path) VALUES ('../Aenean/gravida_nunc');
554INSERT INTO "photo" (path) VALUES ('../imperdiet_ornare.');
555INSERT INTO "photo" (path) VALUES ('../porttitor');
556INSERT INTO "photo" (path) VALUES ('../Proinnon');
557INSERT INTO "photo" (path) VALUES ('../libero.');
558INSERT INTO "photo" (path) VALUES ('../Seddictum_Proin');
559INSERT INTO "photo" (path) VALUES ('../Curabitur');
560INSERT INTO "photo" (path) VALUES ('../felis_adipiscing');
561INSERT INTO "photo" (path) VALUES ('../non');
562
563INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
564VALUES ('nascetur@a.co.uk','Kyra','QSS06HGT3YN','Mills','morbi tristique',5,5);
565INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
566VALUES ('fringilla.euismod@nuncsedlibero.com','Phyllis','UER02KGU0LP','Acevedo','lectus ante',3,6);
567INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
568VALUES('sit.amet.consectetuer@velit.co.uk','Kimberley','KLU83ZIF4XP','Mosley','Mauris nulla.',12,2);
569INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
570VALUES ('Nunc@dolornonummy.org','Gay','WKW16RZU9AQ','England','aliquet,',6,10);
571INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
572VALUES ('cursus@nonegestas.org','Camden','QDS97IAP5JL','Calhoun','et',11,6);
573INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
574VALUES ('ipsum.nunc@sitametante.co.uk','Lars','VNL46ZSD2AE','Cline','pretium aliquet,',10,12);
575INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
576VALUES ('tortor.at.risus@lacinia.ca','Ronan','TOT92LIB8PO','Barker','penatibus et',4,12);
577INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
578VALUES('cursus.Integer@Morbinon.edu','Sloane','BLZ66TGR6II','Shepard','Quisque',2,5);
579INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
580VALUES('natoque.penatibus@In.net','Thane','DMA37PTA2PG','Dillard','Quisque2',20,12);
581INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
582VALUES('cursus@volutpatornarefacilisis.edu','Talon','MNU74JXQ3EE','Guzman','lacus, varius',9,9);
583INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
584VALUES ('adipiscing@gravidamauris.ca','Zane','XSA11UUT4XF','Alvarado','lacus. Quisque',15,12);
585INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
586VALUES('Aliquam.erat.volutpat@lacusUtnec.edu','Angela','OZA96AGG4UW','Massey','lorem. Donec',16,9);
587INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
588VALUES ('Proin@velitin.co.uk','Akeem','PCB43QKU5GT','Scott','Aliquam',17,1);
589INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
590VALUES ('dui@tacitisociosquad.net','Robert','XQD40EAE7CV','Mullins','egestas, urna',7,4);
591INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
592VALUES ('vel.est@nislsem.net','Chester','HUK31NWH5IG','Saunders','mi',19,6);
593INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
594VALUES('rutrum.non@placeratvelitQuisque.ca','Clark','ROM54XLC0JJ','Tucker','feugiat metus',18,11);
595INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
596VALUES ('nec@nislMaecenas.com','Iliana','ARI34QDO3ME','Gibson','ultrices',8,12);
597INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
598VALUES ('Nulla.eu@ante.ca','Portia','RZN50RGQ8NQ','Payne','at auctor',1,7);
599INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
600VALUES ('Nullam@InloremDonec.edu','Fuller','IRQ81NOY0XJ','Cole','id, mollis',14,4);
601INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
602VALUES('adipiscing.elit.Aliquam@justo.net','Reuben','TRH93IUD5CE','Freeman','quis massa.',13,9);
603
604INSERT INTO "eventparticipant" (id_user) VALUES (1);
605INSERT INTO "eventparticipant" (id_user) VALUES (2);
606INSERT INTO "eventparticipant" (id_user) VALUES (3);
607INSERT INTO "eventparticipant" (id_user) VALUES (4);
608INSERT INTO "eventparticipant" (id_user) VALUES (5);
609INSERT INTO "eventparticipant" (id_user) VALUES (6);
610INSERT INTO "eventparticipant" (id_user) VALUES (7);
611INSERT INTO "eventparticipant" (id_user) VALUES (8);
612INSERT INTO "eventparticipant" (id_user) VALUES (9);
613INSERT INTO "eventparticipant" (id_user) VALUES (10);
614INSERT INTO "eventparticipant" (id_user) VALUES (11);
615INSERT INTO "eventparticipant" (id_user) VALUES (12);
616INSERT INTO "eventparticipant" (id_user) VALUES (13);
617INSERT INTO "eventparticipant" (id_user) VALUES (14);
618INSERT INTO "eventparticipant" (id_user) VALUES (15);
619INSERT INTO "eventparticipant" (id_user) VALUES (16);
620INSERT INTO "eventparticipant" (id_user) VALUES (17);
621INSERT INTO "eventparticipant" (id_user) VALUES (18);
622INSERT INTO "eventparticipant" (id_user) VALUES (19);
623INSERT INTO "eventparticipant" (id_user) VALUES (20);
624
625INSERT INTO "event" (description,title,is_public,id_localization,date)
626VALUES ('dui lectus rutrum urna, nec','mollis.','true',19,'2018-11-27 10:52:33');
627INSERT INTO "event" (description,title,is_public,id_localization,date)
628VALUES ('In at','amet ornare lectus','true',15,'2018-08-11 10:05:11');
629INSERT INTO "event" (description,title,is_public,id_localization,date)
630VALUES ('faucibus. Morbi','semper pretium neque.','true',18,'2019-03-08 21:37:55');
631INSERT INTO "event" (description,title,is_public,id_localization,date)
632VALUES ('sit amet','orci. Ut semper','true',18,'2017-11-29 15:03:53');
633INSERT INTO "event" (description,title,is_public,id_localization,date)
634VALUES ('lacus pede sagittis augue, eu','Integer','true',4,'2018-07-28 12:51:07');
635INSERT INTO "event" (description,title,is_public,id_localization,date)
636VALUES ('eu enim.','ad litora torquent','true',8,'2018-09-20 01:15:10');
637INSERT INTO "event" (description,title,is_public,id_localization,date)
638VALUES ('enim, gravida sit amet,','id,','true',13,'2018-05-14 00:29:15');
639INSERT INTO "event" (description,title,is_public,id_localization,date)
640VALUES ('vulputate, lacus. Cras','Sed eu nibh','true',8,'2018-10-27 00:42:43');
641INSERT INTO "event" (description,title,is_public,id_localization,date)
642VALUES ('egestas.','Fusce fermentum fermentum','true',18,'2017-11-22 00:13:54');
643INSERT INTO "event" (description,title,is_public,id_localization,date)
644VALUES ('Vivamus non','tempus non, lacinia','true',8,'2018-05-31 14:35:47');
645INSERT INTO "event" (description,title,is_public,id_localization,date)
646VALUES ('tortor. Nunc commodo','quis','true',13,'2018-06-29 09:20:26');
647INSERT INTO "event" (description,title,is_public,id_localization,date)
648VALUES ('Pellentesque habitant morbi tristique','Nunc mauris.','true',20,'2019-03-11 05:48:46');
649INSERT INTO "event" (description,title,is_public,id_localization,date)
650VALUES ('eget, dictum placerat, augue.','Etiam imperdiet','true',8,'2018-05-18 10:02:34');
651INSERT INTO "event" (description,title,is_public,id_localization,date)
652VALUES ('non lorem vitae','sodales purus,','true',16,'2017-07-20 04:36:50');
653INSERT INTO "event" (description,title,is_public,id_localization,date)
654VALUES ('Aliquam','tempor, est','true',1,'2018-01-22 12:59:49');
655INSERT INTO "event" (description,title,is_public,id_localization,date)
656VALUES ('dolor, tempus non,','Curabitur','true',16,'2018-07-22 02:47:44');
657INSERT INTO "event" (description,title,is_public,id_localization,date)
658VALUES ('Donec nibh enim, gravida sit','velit dui, semper','true',17,'2017-12-10 19:34:37');
659INSERT INTO "event" (description,title,is_public,id_localization,date)
660VALUES ('tempor arcu. Vestibulum ut eros','Donec tempus,','true',19,'2017-09-01 12:56:31');
661INSERT INTO "event" (description,title,is_public,id_localization,date)
662VALUES ('at','fermentum metus. Aenean','true',11,'2019-03-11 16:55:29');
663INSERT INTO "event" (description,title,is_public,id_localization,date)
664VALUES ('interdum. Sed','sed leo. Cras','true',4,'2017-12-17 04:54:43');
665
666
667INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
668VALUES ('2018-07-04 06:12:54','false',14,7,11);
669INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
670VALUES ('2019-01-14 00:41:07','false',20,6,3);
671INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
672VALUES ('2017-12-27 17:52:09','false',5,14,14);
673INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
674VALUES ('2018-05-02 16:54:19','false',6,14,14);
675INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
676VALUES ('2018-08-15 15:37:16','false',7,14,14);
677INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
678VALUES ('2019-03-09 13:12:32','false',8,14,14);
679INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
680VALUES ('2017-12-07 07:46:44','false',19,15,3);
681INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
682VALUES ('2018-09-10 04:16:47','false',17,15,3);
683INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
684VALUES ('2017-10-21 08:21:00','false',16,15,3);
685INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
686VALUES ('2017-06-22 00:06:34','false',1,6,19);
687INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
688VALUES ('2018-01-20 08:56:58','false',2,6,19);
689INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
690VALUES ('2017-12-10 12:20:02','false',3,6,19);
691INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
692VALUES ('2018-08-21 04:28:55','false',4,6,19);
693INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
694VALUES ('2018-05-27 15:27:15','false',5,6,19);
695INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
696VALUES ('2018-02-18 03:46:56','false',16,6,19);
697INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
698VALUES ('2017-04-10 06:40:21','false',7,6,19);
699INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
700VALUES ('2018-03-01 15:51:14','false',8,6,19);
701INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
702VALUES ('2019-03-15 09:24:37','false',9,6,19);
703INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
704VALUES ('2018-09-28 22:34:30','false',10,6,19);
705INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event) 
706VALUES ('2019-01-28 20:51:02','false',11,6,19);
707
708INSERT INTO "message" (content,id_sender,id_receiver,date)
709VALUES ('senectus et netus et malesuada',8,12,'2017-08-24 15:12:19');
710INSERT INTO "message" (content,id_sender,id_receiver,date)
711VALUES ('ipsum sodales purus,',5,12,'2017-06-11 23:03:48');
712INSERT INTO "message" (content,id_sender,id_receiver,date)
713VALUES ('consequat nec, mollis vitae,',1,17,'2017-09-14 20:46:57');
714INSERT INTO "message" (content,id_sender,id_receiver,date)
715VALUES ('quis, pede. Suspendisse dui. Fusce',8,10,'2018-11-01 11:34:23');
716INSERT INTO "message" (content,id_sender,id_receiver,date)
717VALUES ('vitae, orci. Phasellus dapibus quam quis diam.',2,15,'2017-08-19 03:32:39');
718INSERT INTO "message" (content,id_sender,id_receiver,date)
719VALUES ('eget massa. Suspendisse',4,14,'2019-02-22 09:33:41');
720INSERT INTO "message" (content,id_sender,id_receiver,date)
721VALUES ('dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus',6,10,'2018-08-07 07:58:00');
722INSERT INTO "message" (content,id_sender,id_receiver,date)
723VALUES ('nulla at sem',9,10,'2018-07-26 21:58:03');
724INSERT INTO "message" (content,id_sender,id_receiver,date)
725VALUES ('lacus. Quisque purus sapien,',9,16,'2017-08-04 17:39:31');
726INSERT INTO "message" (content,id_sender,id_receiver,date)
727VALUES ('dui, in sodales elit erat vitae',6,20,'2018-08-14 15:00:49');
728INSERT INTO "message" (content,id_sender,id_receiver,date)
729VALUES ('montes, nascetur ridiculus mus. Donec dignissim',5,16,'2018-02-04 20:40:15');
730INSERT INTO "message" (content,id_sender,id_receiver,date)
731VALUES ('Nam interdum enim non nisi. Aenean eget',3,17,'2018-08-24 04:34:27');
732INSERT INTO "message" (content,id_sender,id_receiver,date)
733VALUES ('nec,',7,16,'2018-06-09 20:25:46');
734INSERT INTO "message" (content,id_sender,id_receiver,date)
735VALUES ('laoreet posuere, enim nisl',6,16,'2018-01-19 03:12:19');
736INSERT INTO "message" (content,id_sender,id_receiver,date)
737VALUES ('commodo at,',2,15,'2018-06-29 09:23:04');
738INSERT INTO "message" (content,id_sender,id_receiver,date)
739VALUES ('diam at pretium aliquet, metus urna convallis erat, eget',10,11,'2017-12-12 14:25:28');
740INSERT INTO "message" (content,id_sender,id_receiver,date)
741VALUES ('vel est tempor bibendum. Donec felis orci, adipiscing',2,20,'2018-12-18 03:16:26');
742INSERT INTO "message" (content,id_sender,id_receiver,date)
743VALUES ('natoque penatibus et magnis dis parturient montes, nascetur ridiculus',2,15,'2017-05-20 05:26:55');
744INSERT INTO "message" (content,id_sender,id_receiver,date)
745VALUES ('dolor elit, pellentesque',8,10,'2018-05-26 14:47:26');
746INSERT INTO "message" (content,id_sender,id_receiver,date)
747VALUES ('Maecenas malesuada',4,20,'2018-04-10 11:00:30');
748
749INSERT INTO "eventcategory" (id_event,id_category) VALUES (1,9);
750INSERT INTO "eventcategory" (id_event,id_category) VALUES (2,4);
751INSERT INTO "eventcategory" (id_event,id_category) VALUES (3,10);
752INSERT INTO "eventcategory" (id_event,id_category) VALUES (4,1);
753INSERT INTO "eventcategory" (id_event,id_category) VALUES (5,8);
754INSERT INTO "eventcategory" (id_event,id_category) VALUES (6,5);
755INSERT INTO "eventcategory" (id_event,id_category) VALUES (7,8);
756INSERT INTO "eventcategory" (id_event,id_category) VALUES (8,11);
757INSERT INTO "eventcategory" (id_event,id_category) VALUES (9,9);
758INSERT INTO "eventcategory" (id_event,id_category) VALUES (10,2);
759INSERT INTO "eventcategory" (id_event,id_category) VALUES (11,1);
760INSERT INTO "eventcategory" (id_event,id_category) VALUES (12,6);
761INSERT INTO "eventcategory" (id_event,id_category) VALUES (13,12);
762INSERT INTO "eventcategory" (id_event,id_category) VALUES (14,8);
763INSERT INTO "eventcategory" (id_event,id_category) VALUES (15,11);
764INSERT INTO "eventcategory" (id_event,id_category) VALUES (16,5);
765INSERT INTO "eventcategory" (id_event,id_category) VALUES (17,7);
766INSERT INTO "eventcategory" (id_event,id_category) VALUES (18,5);
767INSERT INTO "eventcategory" (id_event,id_category) VALUES (19,12);
768INSERT INTO "eventcategory" (id_event,id_category) VALUES (20,5);
769
770INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
771VALUES (14,14,4);
772INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
773VALUES (15,3,1);
774INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
775VALUES (2,5,3);
776INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
777VALUES (19,3,5);
778INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
779VALUES (2,13,4);
780INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
781VALUES (17,12,2);
782INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
783VALUES (6,19,3);
784INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
785VALUES (14,6,3);
786INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
787VALUES (18,19,3);
788INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
789VALUES (19,8,3);
790INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
791VALUES (7,19,1);
792INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
793VALUES (5,8,2);
794INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
795VALUES (6,3,3);
796INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
797VALUES (18,1,1);
798INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
799VALUES (20,19,3);
800INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
801VALUES (2,16,2);
802INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
803VALUES (3,10,1);
804INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
805VALUES (6,10,2);
806INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
807VALUES (7,11,5);
808INSERT INTO "participate" (id_eventParticipant,id_event,classification) 
809VALUES (12,19,4);
810
811INSERT INTO "eventowner" (id_eventParticipant) VALUES (1);
812INSERT INTO "eventowner" (id_eventParticipant) VALUES (2);
813INSERT INTO "eventowner" (id_eventParticipant) VALUES (3);
814INSERT INTO "eventowner" (id_eventParticipant) VALUES (4);
815INSERT INTO "eventowner" (id_eventParticipant) VALUES (5);
816INSERT INTO "eventowner" (id_eventParticipant) VALUES (6);
817INSERT INTO "eventowner" (id_eventParticipant) VALUES (7);
818INSERT INTO "eventowner" (id_eventParticipant) VALUES (8);
819INSERT INTO "eventowner" (id_eventParticipant) VALUES (9);
820INSERT INTO "eventowner" (id_eventParticipant) VALUES (10);
821INSERT INTO "eventowner" (id_eventParticipant) VALUES (11);
822INSERT INTO "eventowner" (id_eventParticipant) VALUES (12);
823INSERT INTO "eventowner" (id_eventParticipant) VALUES (13);
824INSERT INTO "eventowner" (id_eventParticipant) VALUES (14);
825INSERT INTO "eventowner" (id_eventParticipant) VALUES (15);
826INSERT INTO "eventowner" (id_eventParticipant) VALUES (16);
827INSERT INTO "eventowner" (id_eventParticipant) VALUES (17);
828INSERT INTO "eventowner" (id_eventParticipant) VALUES (18);
829INSERT INTO "eventowner" (id_eventParticipant) VALUES (19);
830INSERT INTO "eventowner" (id_eventParticipant) VALUES (20);
831
832INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (8,12);
833INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (11,19);
834INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (5,10);
835INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (19,12);
836INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (8,5);
837INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (12,10);
838INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (12,13);
839INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (10,10);
840INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (20,13);
841INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (3,16);
842INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (11,10);
843INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (14,4);
844INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (2,14);
845INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (6,13);
846INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (2,19);
847INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (7,17);
848INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (6,10);
849INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (3,20);
850INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (10,17);
851INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (3,14);
852
853
854INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
855VALUES (14,14,'../lbaw/files/name','2017-06-03 03:51:10');
856INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
857VALUES (3,15,'../lbaw/files/name','2017-12-10 01:32:57');
858INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
859VALUES (3,19,'../lbaw/files/name','2017-11-21 20:16:15');
860INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
861VALUES (3,6,'../lbaw/files/name','2018-12-25 23:55:51');
862INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
863VALUES (5,2,'../lbaw/files/name','2018-06-12 10:56:18');
864INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
865VALUES (13,2,'../lbaw/files/name','2018-05-11 09:25:37');
866INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
867VALUES (12,17,'../lbaw/files/name','2018-01-26 06:39:44');
868INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
869VALUES (19,6,'../lbaw/files/name','2018-08-25 04:52:53');
870INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
871VALUES (19,18,'../lbaw/files/name','2018-08-22 07:49:04');
872INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
873VALUES (19,7,'../lbaw/files/name','2019-02-08 23:08:09');
874INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
875VALUES (19,20,'../lbaw/files/name','2017-07-10 21:22:37');
876INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
877VALUES (6,14,'../lbaw/files/name','2017-05-16 16:42:57');
878INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
879VALUES (8,19,'../lbaw/files/name','2018-06-12 18:03:24');
880INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
881VALUES (8,5,'../lbaw/files/name','2017-09-17 15:51:56');
882INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
883VALUES (10,3,'../lbaw/files/name','2017-09-06 18:49:18');
884INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
885VALUES (10,6,'../lbaw/files/name','2018-10-11 18:52:35');
886INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
887VALUES (10,6,'../lbaw/files/name','2017-11-07 00:42:29');
888INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
889VALUES (10,6,'../lbaw/files/name','2019-02-24 19:11:43');
890INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
891VALUES (11,7,'../lbaw/files/name','2017-10-04 15:30:02');
892INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
893VALUES (11,7,'../lbaw/files/name','2018-10-19 00:19:58');
894
895INSERT INTO "post" (content,id_poster,id_event,date)
896VALUES ('eu, euismod ac,',14,14,'2017-07-12 23:08:47');
897INSERT INTO "post" (content,id_poster,id_event,date)
898VALUES ('quis, tristique',14,14,'2017-05-16 18:43:52');
899INSERT INTO "post" (content,id_poster,id_event,date)
900VALUES ('commodo tincidunt nibh. Phasellus',15,3,'2017-12-23 02:36:34');
901INSERT INTO "post" (content,id_poster,id_event,date)
902VALUES ('Donec dignissim magna a',19,3,'2017-08-22 04:55:46');
903INSERT INTO "post" (content,id_poster,id_event,date)
904VALUES ('Aliquam nisl.',6,3,'2017-05-07 01:53:52');
905INSERT INTO "post" (content,id_poster,id_event,date)
906VALUES ('sociis',6,3,'2017-08-05 08:13:45');
907INSERT INTO "post" (content,id_poster,id_event,date)
908VALUES ('Vestibulum ante ipsum primis',7,11,'2018-09-20 00:16:50'); 
909INSERT INTO "post" (content,id_poster,id_event,date)
910VALUES ('amet,',6,3,'2018-06-26 16:47:49');
911INSERT INTO "post" (content,id_poster,id_event,date)
912VALUES ('ac mattis velit',6,3,'2017-06-28 19:12:13');
913INSERT INTO "post" (content,id_poster,id_event,date)
914VALUES ('eu dolor egestas rhoncus.',6,3,'2018-06-15 11:16:12');
915INSERT INTO "post" (content,id_poster,id_event,date)
916VALUES ('lectus sit',2,5,'2017-10-12 23:38:15');
917INSERT INTO "post" (content,id_poster,id_event,date)
918VALUES ('Nulla tincidunt, neque',2,13,'2018-07-13 02:17:42');
919INSERT INTO "post" (content,id_poster,id_event,date)
920VALUES ('In',19,8,'2017-04-13 12:08:43');
921INSERT INTO "post" (content,id_poster,id_event,date)
922VALUES ('Suspendisse tristique neque',19,8,'2018-02-05 02:09:48');
923INSERT INTO "post" (content,id_poster,id_event,date)
924VALUES ('tincidunt dui augue',19,8,'2017-08-03 08:43:44');
925INSERT INTO "post" (content,id_poster,id_event,date)
926VALUES ('quis accumsan convallis,',19,8,'2018-08-25 07:23:45');
927INSERT INTO "post" (content,id_poster,id_event,date)
928VALUES ('lobortis quis, pede.',3,10,'2018-09-16 12:44:04');
929INSERT INTO "post" (content,id_poster,id_event,date)
930VALUES ('vestibulum, neque sed',6,10,'2018-04-05 22:56:26');
931INSERT INTO "post" (content,id_poster,id_event,date)
932VALUES ('sodales purus,',7,19,'2018-05-29 19:32:18');
933INSERT INTO "post" (content,id_poster,id_event,date)
934VALUES ('arcu et',6,10,'2017-05-04 11:59:52'); 
935
936
937
938INSERT INTO "poll" (description,id_owner,id_event,date)
939VALUES ('nulla.',8,12,'2018-07-05 08:50:44');
940INSERT INTO "poll" (description,id_owner,id_event,date)
941VALUES ('dis parturient montes,',11,19,'2017-07-31 11:46:37');
942INSERT INTO "poll" (description,id_owner,id_event,date)
943VALUES ('faucibus orci',5,10,'2019-01-23 19:25:49');
944INSERT INTO "poll" (description,id_owner,id_event,date)
945VALUES ('neque. Nullam nisl.',19,12,'2018-12-20 00:51:58');
946INSERT INTO "poll" (description,id_owner,id_event,date)
947VALUES ('facilisis non, bibendum sed, est.',8,5,'2017-07-05 17:34:24');
948INSERT INTO "poll" (description,id_owner,id_event,date)
949VALUES ('vulputate eu, odio. Phasellus',12,10,'2017-06-18 15:55:29');
950INSERT INTO "poll" (description,id_owner,id_event,date)
951VALUES ('Cum sociis natoque',12,13,'2017-08-20 14:50:35');
952INSERT INTO "poll" (description,id_owner,id_event,date)
953VALUES ('erat.',19,12,'2017-07-06 23:06:59');
954INSERT INTO "poll" (description,id_owner,id_event,date)
955VALUES ('Suspendisse sagittis. Nullam vitae',10,10,'2018-01-15 21:23:57');
956INSERT INTO "poll" (description,id_owner,id_event,date)
957VALUES ('sem molestie',20,13,'2017-06-16 00:49:50');
958INSERT INTO "poll" (description,id_owner,id_event,date)
959VALUES ('mi',3,16,'2018-04-08 07:03:58');
960INSERT INTO "poll" (description,id_owner,id_event,date)
961VALUES ('amet ornare lectus justo eu',11,10,'2017-10-25 07:04:29');
962INSERT INTO "poll" (description,id_owner,id_event,date)
963VALUES ('ac facilisis',11,10,'2017-06-10 10:00:14');
964INSERT INTO "poll" (description,id_owner,id_event,date)
965VALUES ('convallis',11,10,'2018-12-27 09:38:50');
966INSERT INTO "poll" (description,id_owner,id_event,date)
967VALUES ('sollicitudin a, malesuada',10,10,'2018-11-26 13:05:54');
968INSERT INTO "poll" (description,id_owner,id_event,date)
969VALUES ('lacus.',10,10,'2018-04-13 21:35:47');
970INSERT INTO "poll" (description,id_owner,id_event,date)
971VALUES ('a odio semper cursus.',10,10,'2017-10-29 18:22:17');
972INSERT INTO "poll" (description,id_owner,id_event,date)
973VALUES ('In mi pede, nonummy',11,10,'2018-01-31 21:57:44');
974INSERT INTO "poll" (description,id_owner,id_event,date)
975VALUES ('lectus ante dictum mi,',10,10,'2017-05-14 16:11:02');
976INSERT INTO "poll" (description,id_owner,id_event,date)
977VALUES ('diam dictum sapien.',10,10,'2018-10-07 21:35:19');
978
979
980INSERT INTO "polloption" (description,id_poll) 
981VALUES ('sit',6);
982INSERT INTO "polloption" (description,id_poll) 
983VALUES ('pellentesque a,',12);
984INSERT INTO "polloption" (description,id_poll)
985VALUES ('est',5);
986INSERT INTO "polloption" (description,id_poll) 
987VALUES ('sit',14);
988INSERT INTO "polloption" (description,id_poll) 
989VALUES ('ac, eleifend vitae, erat. Vivamus',18);
990INSERT INTO "polloption" (description,id_poll) VALUES ('eget varius ultrices, mauris',16);
991INSERT INTO "polloption" (description,id_poll) VALUES ('sollicitudin commodo ipsum. Suspendisse',6);
992INSERT INTO "polloption" (description,id_poll) VALUES ('facilisis non,',8);
993INSERT INTO "polloption" (description,id_poll) VALUES ('hendrerit. Donec porttitor tellus non',6);
994INSERT INTO "polloption" (description,id_poll) VALUES ('magna. Ut tincidunt orci quis',11);
995INSERT INTO "polloption" (description,id_poll) VALUES ('in felis. Nulla',16);
996INSERT INTO "polloption" (description,id_poll) VALUES ('congue turpis. In condimentum.',11);
997INSERT INTO "polloption" (description,id_poll) VALUES ('tincidunt dui augue eu tellus.',6);
998INSERT INTO "polloption" (description,id_poll) VALUES ('sagittis augue,',15);
999INSERT INTO "polloption" (description,id_poll) VALUES ('sed, hendrerit a, arcu. Sed',12);
1000INSERT INTO "polloption" (description,id_poll) VALUES ('accumsan sed,',14);
1001INSERT INTO "polloption" (description,id_poll) VALUES ('consectetuer adipiscing elit.',4);
1002INSERT INTO "polloption" (description,id_poll) VALUES ('natoque penatibus',5);
1003INSERT INTO "polloption" (description,id_poll) VALUES ('justo faucibus lectus, a sollicitudin',13);
1004INSERT INTO "polloption" (description,id_poll) VALUES ('quam. Curabitur',16);
1005
1006INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (1,14);
1007INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (2,3);
1008INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (2,6);
1009INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (3,19);
1010INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (3,15);
1011INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (3,6);
1012INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (4,19);
1013INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (4,15);
1014INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (4,6);
1015INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (5,19);
1016INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (5,15);
1017INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (5,6);
1018INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (6,6);
1019INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (6,15);
1020INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (6,19);
1021INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (7,6);
1022INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (7,15);
1023INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (7,19);
1024INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (8,19);
1025INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (8,15);