DROP TABLE IF EXISTS users CASCADE;
DROP TABLE IF EXISTS cards CASCADE;
DROP TABLE IF EXISTS items CASCADE;

-- Tables

DROP TABLE IF EXISTS Category CASCADE;
DROP TABLE IF EXISTS Country CASCADE;
DROP TABLE IF EXISTS City CASCADE;
DROP TABLE IF EXISTS Localization CASCADE;
DROP TABLE IF EXISTS Admin CASCADE;
DROP TABLE IF EXISTS AuthenticatedUser CASCADE;
DROP TABLE IF EXISTS Photo CASCADE;
DROP TABLE IF EXISTS Invitation CASCADE;
DROP TABLE IF EXISTS Message CASCADE;
DROP TABLE IF EXISTS Event CASCADE;
DROP TABLE IF EXISTS EventCategory CASCADE;
DROP TABLE IF EXISTS EventParticipant CASCADE;
DROP TABLE IF EXISTS Participate CASCADE;
DROP TABLE IF EXISTS EventOwner CASCADE;
DROP TABLE IF EXISTS OwnEvent CASCADE;
DROP TABLE IF EXISTS File CASCADE;
DROP TABLE IF EXISTS Post CASCADE;
DROP TABLE IF EXISTS Poll CASCADE;
DROP TABLE IF EXISTS PollVote CASCADE;
DROP TABLE IF EXISTS PollOption CASCADE;

CREATE TABLE Category (
   id SERIAL NOT NULL,
   name text NOT NULL
);

CREATE TABLE Country (
   id SERIAL NOT NULL,
   name text NOT NULL
);





CREATE TABLE City (
   id SERIAL NOT NULL,
   name text NOT NULL,
   id_country integer NOT NULL
);

CREATE TABLE Localization (
   id SERIAL NOT NULL,
   street text,
   latitude double precision  NOT NULL,
   longitude double precision  NOT NULL,
   id_city integer
);

CREATE TABLE Admin (
   id SERIAL NOT NULL,
   email text NOT NULL,
   firstName text NOT NULL,
   password text NOT NULL,
   lastName text NOT NULL,
   username text NOT NULL
);

CREATE TABLE AuthenticatedUser (
   id SERIAL NOT NULL,
   email text,
   firstName text NOT NULL,
   password text NOT NULL,
   lastName text NOT NULL,
   username text NOT NULL,
   id_photo integer,
   id_city integer
);

CREATE TABLE Photo (
   id SERIAL NOT NULL,
   path text NOT NULL,
      id_event integer
);

CREATE TABLE Invitation (
   id SERIAL NOT NULL,
   status text,
   id_receiver integer NOT NULL,
   id_sender integer NOT NULL,
   id_event integer NOT NULL,
   "date" timestamp with time zone DEFAULT now() NOT NULL,
   CHECK (id_sender != id_receiver)
);

CREATE TABLE Message (
   id SERIAL NOT NULL,
   content text NOT NULL,
   id_sender integer NOT NULL,
   id_receiver integer NOT NULL,
   "date" timestamp with time zone DEFAULT now() NOT NULL
);

CREATE TABLE Event (
   id SERIAL NOT NULL,
   description text NOT NULL,
   title text NOT NULL,
   is_Public BOOLEAN NOT NULL,
   id_localization integer NOT NULL,
   "date" timestamp with time zone DEFAULT now() NOT NULL
);

CREATE TABLE EventCategory (
   id_event integer NOT NULL,
   id_category integer NOT NULL
);

CREATE TABLE EventParticipant (
   id_user integer NOT NULL
);

CREATE TABLE Participate (
  id_eventParticipant integer NOT NULL,
  id_event integer NOT NULL,
  classification integer CHECK (((classification > 0) AND (classification <= 5)))
);

CREATE TABLE EventOwner (
     id_eventParticipant integer NOT NULL
);

CREATE TABLE OwnEvent (
   id_eventOwner integer NOT NULL,
   id_event integer NOT NULL
);

CREATE TABLE File (
   id SERIAL NOT NULL,
   id_event integer NOT NULL,
   id_eventParticipant integer NOT NULL,
   path text NOT NULL,
   submittedDate timestamp with time zone DEFAULT now() NOT NULL
);

CREATE TABLE Post (
   id SERIAL NOT NULL,
   content text NOT NULL,
   id_poster integer NOT NULL,
   id_event integer NOT NULL,
   "date" timestamp with time zone DEFAULT now() NOT NULL
);

CREATE TABLE Poll (
   id SERIAL NOT NULL,
   description text NOT NULL,
   id_owner integer NOT NULL,
   id_event integer NOT NULL,
   "date" timestamp with time zone DEFAULT now() NOT NULL
);

CREATE TABLE PollVote (
   id_poll_option integer NOT NULL,
   id_eventParticipant integer NOT NULL
);

CREATE TABLE PollOption (
   id SERIAL NOT NULL,
   description text NOT NULL,
   id_poll integer NOT NULL
);

-- Primary Keys and Uniques

ALTER TABLE ONLY Category
   ADD CONSTRAINT category_pkey PRIMARY KEY (id),
   ADD CONSTRAINT name_category UNIQUE (name);

ALTER TABLE ONLY Country
   ADD CONSTRAINT country_pkey PRIMARY KEY (id);

ALTER TABLE ONLY City
   ADD CONSTRAINT city_pkey PRIMARY KEY (id);

ALTER TABLE ONLY Localization
   ADD CONSTRAINT localization_pkey PRIMARY KEY (id),
   ADD CONSTRAINT localization_coordinates_key UNIQUE (latitude,longitude);

ALTER TABLE ONLY Admin
   ADD CONSTRAINT admin_email_key UNIQUE (email),
   ADD CONSTRAINT admin_username_key UNIQUE (username);

ALTER TABLE ONLY Admin
   ADD CONSTRAINT admin_pkey PRIMARY KEY (id);

ALTER TABLE ONLY AuthenticatedUser
   ADD CONSTRAINT auth_user_email_key UNIQUE (email),
   ADD CONSTRAINT auth_user_username_key UNIQUE (username),
   ADD CONSTRAINT auth_user_id_photo_key UNIQUE (id_photo);

ALTER TABLE ONLY AuthenticatedUser
   ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);

ALTER TABLE ONLY Photo
   ADD CONSTRAINT photo_pkey PRIMARY KEY (id),
   ADD CONSTRAINT path_key UNIQUE (path);

ALTER TABLE ONLY Invitation
   ADD CONSTRAINT invitation_pkey PRIMARY KEY (id);

ALTER TABLE ONLY Message
   ADD CONSTRAINT message_pkey PRIMARY KEY (id);

ALTER TABLE ONLY Event
   ADD CONSTRAINT event_pkey PRIMARY KEY (id);

ALTER TABLE ONLY EventCategory
   ADD CONSTRAINT event_category_pkey PRIMARY KEY (id_event, id_category);

ALTER TABLE ONLY EventParticipant
   ADD CONSTRAINT event_participant_pkey PRIMARY KEY (id_user);

ALTER TABLE ONLY Participate
   ADD CONSTRAINT participate_pkey PRIMARY KEY (id_eventParticipant, id_event);

ALTER TABLE ONLY EventOwner
   ADD CONSTRAINT event_owner_pkey PRIMARY KEY (id_eventParticipant);

ALTER TABLE ONLY OwnEvent
   ADD CONSTRAINT own_event_pkey PRIMARY KEY (id_eventOwner, id_event);

ALTER TABLE ONLY File
   ADD CONSTRAINT file_pkey PRIMARY KEY (id);

ALTER TABLE ONLY Post
   ADD CONSTRAINT post_pkey PRIMARY KEY (id);

ALTER TABLE ONLY Poll
   ADD CONSTRAINT poll_pkey PRIMARY KEY (id);

ALTER TABLE ONLY PollVote
   ADD CONSTRAINT poll_vote_pkey PRIMARY KEY (id_poll_option, id_eventParticipant);

ALTER TABLE ONLY PollOption
   ADD CONSTRAINT poll_option_pkey PRIMARY KEY (id);

-- Foreign Keys

ALTER TABLE ONLY City
   ADD CONSTRAINT city_id_country_fkey FOREIGN KEY (id_country) REFERENCES Country(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Localization
   ADD CONSTRAINT localization_id_city_fkey FOREIGN KEY (id_city) REFERENCES City(id) ON UPDATE CASCADE;

ALTER TABLE ONLY AuthenticatedUser
   ADD CONSTRAINT auth_user_id_photo_fkey FOREIGN KEY (id_photo) REFERENCES Photo(id) ON UPDATE CASCADE;

ALTER TABLE ONLY AuthenticatedUser
   ADD CONSTRAINT auth_user_id_city_fkey FOREIGN KEY (id_city) REFERENCES City(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Invitation
   ADD CONSTRAINT invitation_id_receiver_fkey FOREIGN KEY (id_receiver) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Invitation
   ADD CONSTRAINT invitation_id_sender_fkey FOREIGN KEY (id_sender) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;

ALTER TABLE ONLY Invitation
   ADD CONSTRAINT invitation_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Message
   ADD CONSTRAINT message_id_sender_fkey FOREIGN KEY (id_sender) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Message
   ADD CONSTRAINT message_id_receiver_fkey FOREIGN KEY (id_receiver) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Event
   ADD CONSTRAINT event_id_localization_fkey FOREIGN KEY (id_localization) REFERENCES Localization(id) ON UPDATE CASCADE;

ALTER TABLE ONLY EventCategory
   ADD CONSTRAINT event_category_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;

ALTER TABLE ONLY EventCategory
   ADD CONSTRAINT event_category_id_category_fkey FOREIGN KEY (id_category) REFERENCES Category(id) ON UPDATE CASCADE;

ALTER TABLE ONLY EventParticipant
   ADD CONSTRAINT event_participant_id_user_fkey FOREIGN KEY (id_user) REFERENCES AuthenticatedUser(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Participate
   ADD CONSTRAINT participate_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;

ALTER TABLE ONLY Participate
   ADD CONSTRAINT participate_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;


ALTER TABLE ONLY EventOwner
   ADD CONSTRAINT event_owner_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;

ALTER TABLE ONLY OwnEvent
   ADD CONSTRAINT own_event_id_event_owner_fkey FOREIGN KEY (id_eventOwner) REFERENCES EventOwner(id_eventParticipant) ON UPDATE CASCADE;

ALTER TABLE ONLY OwnEvent
   ADD CONSTRAINT own_event_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;

ALTER TABLE ONLY File
   ADD CONSTRAINT file_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;

ALTER TABLE ONLY File
   ADD CONSTRAINT file_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;

ALTER TABLE ONLY Post
   ADD CONSTRAINT post_id_poster_fkey FOREIGN KEY (id_poster) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;

ALTER TABLE ONLY Post
   ADD CONSTRAINT post_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Poll
   ADD CONSTRAINT poll_id_event_fkey FOREIGN KEY (id_event) REFERENCES Event(id) ON UPDATE CASCADE;

ALTER TABLE ONLY Poll
   ADD CONSTRAINT poll_id_owner_fkey FOREIGN KEY (id_owner) REFERENCES EventOwner(id_eventParticipant) ON UPDATE CASCADE;

ALTER TABLE ONLY PollVote
   ADD CONSTRAINT poll_vote_id_poll_option_fkey FOREIGN KEY (id_poll_option) REFERENCES Poll(id) ON UPDATE CASCADE;

ALTER TABLE ONLY PollVote
   ADD CONSTRAINT poll_vote_id_event_participant_fkey FOREIGN KEY (id_eventParticipant) REFERENCES EventParticipant(id_user) ON UPDATE CASCADE;

ALTER TABLE ONLY PollOption
   ADD CONSTRAINT poll_option_id_poll_fkey FOREIGN KEY (id_poll) REFERENCES Poll(id) ON UPDATE CASCADE;

CREATE INDEX "EventRecent" ON event USING btree (date);

CREATE INDEX name_category_idx ON category USING hash(name);

CREATE INDEX "PostsPerEvent" ON post USING btree ( id_event);

CREATE INDEX search_idx ON event USING gin(to_tsvector('english'::regconfig, description));

CREATE INDEX search_event_per_title ON event USING GIST (to_tsvector('english', title));

CREATE INDEX search_category ON category USING GIST (to_tsvector('english', name));

DROP TRIGGER IF EXISTS only_owner_private_invite ON invitation;
DROP FUNCTION IF EXISTS only_owner_private_invite() CASCADE;

CREATE FUNCTION only_owner_private_invite() RETURNS TRIGGER AS
$BODY$
BEGIN
IF EXISTS (SELECT *
              FROM invitation INNER JOIN event
              ON invitation.id_event = event.id
              WHERE NEW.id_event = event.id AND event.is_public = false AND invitation.id_sender NOT IN (
                   SELECT ownevent.id_eventOwner
                   FROM ownevent
                   WHERE ownevent.id_event = event.id
              ) ) THEN
  RAISE EXCEPTION 'A non owner cannot invite other users to a private event';
END IF;
RETURN NEW;
END
$BODY$
LANGUAGE plpgsql;
CREATE TRIGGER only_owner_private_invite
BEFORE INSERT OR UPDATE ON invitation
FOR EACH ROW
  EXECUTE PROCEDURE only_owner_private_invite();

  DROP TRIGGER IF EXISTS no_self_message ON message;
DROP FUNCTION IF EXISTS no_self_message() CASCADE;

CREATE FUNCTION no_self_message() RETURNS TRIGGER AS
$BODY$
BEGIN
 IF EXISTS (SELECT * FROM message WHERE NEW.id_sender = NEW.id_receiver) THEN
   RAISE EXCEPTION 'A user cannot send messages to himself';
 END IF;
 RETURN NEW;
END
$BODY$
LANGUAGE plpgsql;
CREATE TRIGGER no_self_message
 BEFORE INSERT OR UPDATE ON message
 FOR EACH ROW
   EXECUTE PROCEDURE no_self_message();

DROP TRIGGER IF EXISTS no_self_invitation ON invitation;
DROP FUNCTION IF EXISTS no_self_invitation() CASCADE;

CREATE FUNCTION no_self_invitation() RETURNS TRIGGER AS
$BODY$
BEGIN
 IF EXISTS (SELECT * FROM invitation WHERE NEW.id_sender = NEW.id_receiver) THEN
   RAISE EXCEPTION 'A user cannot send invitations to himself';
 END IF;
 RETURN NEW;
END
$BODY$
LANGUAGE plpgsql;
CREATE TRIGGER no_self_invitation
 BEFORE INSERT OR UPDATE ON invitation
 FOR EACH ROW
   EXECUTE PROCEDURE no_self_invitation();

DROP TRIGGER IF EXISTS no_participate_old_events ON participate;
DROP FUNCTION IF EXISTS no_participate_old_events() CASCADE;

CREATE FUNCTION no_participate_old_events() RETURNS TRIGGER AS
$BODY$
BEGIN
 IF EXISTS (SELECT *
            FROM participate INNER JOIN event
            ON participate.id_event = event.id
            WHERE NEW.id_event = event.id AND event.date < now()) THEN
   RAISE EXCEPTION 'A user cannot join a finished event';
 END IF;
 RETURN NEW;
END
$BODY$
LANGUAGE plpgsql;
CREATE TRIGGER no_participate_old_events
 BEFORE INSERT OR UPDATE ON participate
 FOR EACH ROW
   EXECUTE PROCEDURE no_participate_old_events();

TRUNCATE "category","country","city","localization","admin","photo","authenticateduser","eventparticipant","event","invitation","message","eventcategory","participate","eventowner","ownevent", "file", "post", "poll", "polloption", "pollvote" CASCADE;
INSERT INTO "category" (name) VALUES ('Dance and Theatre');
INSERT INTO "category" (name) VALUES ('Clubbing');
INSERT INTO "category" (name) VALUES ('Conferences');
INSERT INTO "category" (name) VALUES ('Concerts');
INSERT INTO "category" (name) VALUES ('Formation');
INSERT INTO "category" (name) VALUES ('Gastronomy');
INSERT INTO "category" (name) VALUES ('Children');
INSERT INTO "category" (name) VALUES ('Fashion');
INSERT INTO "category" (name) VALUES ('Academics');
INSERT INTO "category" (name) VALUES ('Nature');
INSERT INTO "category" (name) VALUES ('Travel');
INSERT INTO "category" (name) VALUES ('Literature');

INSERT INTO "country" (name) VALUES ('Portugal');
INSERT INTO "country" (name) VALUES ('Spain');
INSERT INTO "country" (name) VALUES ('France');
INSERT INTO "country" (name) VALUES ('Switzerland');
INSERT INTO "country" (name) VALUES ('Germany');
INSERT INTO "country" (name) VALUES ('Netherlands');
INSERT INTO "country" (name) VALUES ('Russia');
INSERT INTO "country" (name) VALUES ('China');
INSERT INTO "country" (name) VALUES ('Japan');
INSERT INTO "country" (name) VALUES ('Italy');
INSERT INTO "country" (name) VALUES ('Australia');
INSERT INTO "country" (name) VALUES ('USA');

INSERT INTO "city" (name,id_country) VALUES ('Porto', 1);
INSERT INTO "city" (name,id_country) VALUES ('Faro', 1);
INSERT INTO "city" (name,id_country) VALUES ('Madrid', 2);
INSERT INTO "city" (name,id_country) VALUES ('Paris', 3);
INSERT INTO "city" (name,id_country) VALUES ('Luzern', 4);
INSERT INTO "city" (name,id_country) VALUES ('Frankfurt', 5);
INSERT INTO "city" (name,id_country) VALUES ('Amsterdam', 6);
INSERT INTO "city" (name,id_country) VALUES ('Beijing', 8);
INSERT INTO "city" (name,id_country) VALUES ('Rome', 10);
INSERT INTO "city" (name,id_country) VALUES ('Sydney', 11);
INSERT INTO "city" (name,id_country) VALUES ('New York', 12);
INSERT INTO "city" (name,id_country) VALUES ('Aveiro', 1);

INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('diam lorem, auctor','-57.83262','120.88352',10);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('Quisque purus sapien,','1.43736','-143.19847',4);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('Donec vitae erat','38.29072','109.41783',10);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('nec, malesuada ut,','72.75425','151.88681',2);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('amet orci. Ut','22.58932','-27.19582',8);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('sem egestas blandit.','46.45921','-39.02434',1);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('ac libero nec','-15.54521','55.05494',4);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('lacus. Nulla tincidunt,','-22.60314','38.78897',8);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('posuere vulputate, lacus.','17.20856','12.84046',9);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('venenatis vel, faucibus','75.18007','-41.27717',5);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('justo sit amet','73.17373','37.20697',7);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('Integer tincidunt aliquam','-4.79812','178.94257',4);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('Lorem ipsum dolor','65.09022','96.3736',9);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('eu eros. Nam','51.32303','-105.15054',1);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('posuere cubilia Curae;','-31.24328','-110.92501',3);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('Cras pellentesque. Sed','28.87859','-58.91476',5);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('parturient montes, nascetur','0.71294','178.77274',5);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('luctus et ultrices','-23.88917','-165.24832',9);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('cursus et, eros.','-76.6059','117.8904',12);
INSERT INTO "localization" (street,latitude,longitude,id_city)
VALUES ('ultrices iaculis odio.','77.72928','114.31794',3);

INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('non@Sednunc.com','Pascale','LUD73ILG7BH','Moore','accumsan');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('magna@vulputate.org','Stewart','FMK91UTU7VJ','Gonzalez','sodales.');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('Suspendisse.aliquet@Nulla.net','Samuel','PWG57NUN3ZB','Flynn','id risus');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('a.feugiat@id.edu','Janna','XNG10TUN6UA','Vasquez','faucibus lectus,');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES('luctus@eleifendegestas.net','Clementine','CIU02ORP3MZ','Neal','consectetuer ipsum');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('elit@nibh.com','Aimee','BIN74GSX7LS','Jenkins','eros');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES('tincidunt.aliquam@pharetraNamac.org','Candace','QES41CBF6OB','Marshall','sed leo.');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('consectetuer@Namnulla.net','Joseph','ZPD22RJN2DR','Ortiz','sagittis lobortis');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('fermentum.arcu@tristiquesenectus.com','Zelenia','JPK04SQI8RM','Vargas','ornare. In');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('sit.amet@sociosquad.edu','Ryder','WWT23VSW6MR','Gay','dignissim pharetra.');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('fringilla@imperdiet.co.uk','Althea','ZNN00XQJ1VP','Ray','adipiscing');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES('vel.est.tempor@ullamcorpervelitin.net','Uriel','PLL50RVJ0TO','Watkins','et tristique');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES('aliquet@maurisIntegersem.co.uk','Odette','ZYU41PXX4JV','Carpenter','luctus felis');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES('consectetuer.mauris.id@vestibulummassa.edu','Benjamin','WWA23XAQ2PR','Mcdowell','tellus sem');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES('at.velit.Pellentesque@Donecfringilla.org','Gillian','EYH37GZP5HR','Lara','Fusce diam');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('massa@disparturientmontes.edu','Chelsea','EBZ86OOF2HY','Mullins','Cras vulputate');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('Phasellus@nec.net','Tobias','CZR51YAW8VH','Bolton','magna.');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('dolor.dapibus.gravida@libero.com','Ivory','DIF33ASG1SO','Browning','mi felis,');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES ('Etiam@ornarelectus.net','Roanna','KMM31PWZ4BU','Taylor','Donec est.');
INSERT INTO "admin" (email,firstName,password,lastName,username)
VALUES('egestas@montesnascetur.net','Jessica','KDK13ERS3ED','Gonzales','tincidunt pede');

INSERT INTO "photo" (path) VALUES ('../elit/Nulla');
INSERT INTO "photo" (path) VALUES ('../a/felisullamcorper');
INSERT INTO "photo" (path) VALUES ('../sociosqu');
INSERT INTO "photo" (path) VALUES ('../nonummyac,');
INSERT INTO "photo" (path) VALUES ('../vulputate');
INSERT INTO "photo" (path) VALUES ('../interdum');
INSERT INTO "photo" (path) VALUES ('../nascetur');
INSERT INTO "photo" (path) VALUES ('../enim/Mauris');
INSERT INTO "photo" (path) VALUES ('../posuerecubilia/Curae;');
INSERT INTO "photo" (path) VALUES ('../eros');
INSERT INTO "photo" (path) VALUES ('../lectusjusto');
INSERT INTO "photo" (path) VALUES ('../Aenean/gravida_nunc');
INSERT INTO "photo" (path) VALUES ('../imperdiet_ornare.');
INSERT INTO "photo" (path) VALUES ('../porttitor');
INSERT INTO "photo" (path) VALUES ('../Proinnon');
INSERT INTO "photo" (path) VALUES ('../libero.');
INSERT INTO "photo" (path) VALUES ('../Seddictum_Proin');
INSERT INTO "photo" (path) VALUES ('../Curabitur');
INSERT INTO "photo" (path) VALUES ('../felis_adipiscing');
INSERT INTO "photo" (path) VALUES ('../non');

INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('nascetur@a.co.uk','Kyra','QSS06HGT3YN','Mills','morbi tristique',5,5);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('fringilla.euismod@nuncsedlibero.com','Phyllis','UER02KGU0LP','Acevedo','lectus ante',3,6);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES('sit.amet.consectetuer@velit.co.uk','Kimberley','KLU83ZIF4XP','Mosley','Mauris nulla.',12,2);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('Nunc@dolornonummy.org','Gay','WKW16RZU9AQ','England','aliquet,',6,10);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('cursus@nonegestas.org','Camden','QDS97IAP5JL','Calhoun','et',11,6);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('ipsum.nunc@sitametante.co.uk','Lars','VNL46ZSD2AE','Cline','pretium aliquet,',10,12);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('tortor.at.risus@lacinia.ca','Ronan','TOT92LIB8PO','Barker','penatibus et',4,12);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES('cursus.Integer@Morbinon.edu','Sloane','BLZ66TGR6II','Shepard','Quisque',2,5);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES('natoque.penatibus@In.net','Thane','DMA37PTA2PG','Dillard','Quisque2',20,12);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES('cursus@volutpatornarefacilisis.edu','Talon','MNU74JXQ3EE','Guzman','lacus, varius',9,9);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('adipiscing@gravidamauris.ca','Zane','XSA11UUT4XF','Alvarado','lacus. Quisque',15,12);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES('Aliquam.erat.volutpat@lacusUtnec.edu','Angela','OZA96AGG4UW','Massey','lorem. Donec',16,9);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('Proin@velitin.co.uk','Akeem','PCB43QKU5GT','Scott','Aliquam',17,1);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('dui@tacitisociosquad.net','Robert','XQD40EAE7CV','Mullins','egestas, urna',7,4);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('vel.est@nislsem.net','Chester','HUK31NWH5IG','Saunders','mi',19,6);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES('rutrum.non@placeratvelitQuisque.ca','Clark','ROM54XLC0JJ','Tucker','feugiat metus',18,11);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('nec@nislMaecenas.com','Iliana','ARI34QDO3ME','Gibson','ultrices',8,12);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('Nulla.eu@ante.ca','Portia','RZN50RGQ8NQ','Payne','at auctor',1,7);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES ('Nullam@InloremDonec.edu','Fuller','IRQ81NOY0XJ','Cole','id, mollis',14,4);
INSERT INTO "authenticateduser" (email,firstName,password,lastName,username,id_photo,id_city)
VALUES('adipiscing.elit.Aliquam@justo.net','Reuben','TRH93IUD5CE','Freeman','quis massa.',13,9);

INSERT INTO "eventparticipant" (id_user) VALUES (1);
INSERT INTO "eventparticipant" (id_user) VALUES (2);
INSERT INTO "eventparticipant" (id_user) VALUES (3);
INSERT INTO "eventparticipant" (id_user) VALUES (4);
INSERT INTO "eventparticipant" (id_user) VALUES (5);
INSERT INTO "eventparticipant" (id_user) VALUES (6);
INSERT INTO "eventparticipant" (id_user) VALUES (7);
INSERT INTO "eventparticipant" (id_user) VALUES (8);
INSERT INTO "eventparticipant" (id_user) VALUES (9);
INSERT INTO "eventparticipant" (id_user) VALUES (10);
INSERT INTO "eventparticipant" (id_user) VALUES (11);
INSERT INTO "eventparticipant" (id_user) VALUES (12);
INSERT INTO "eventparticipant" (id_user) VALUES (13);
INSERT INTO "eventparticipant" (id_user) VALUES (14);
INSERT INTO "eventparticipant" (id_user) VALUES (15);
INSERT INTO "eventparticipant" (id_user) VALUES (16);
INSERT INTO "eventparticipant" (id_user) VALUES (17);
INSERT INTO "eventparticipant" (id_user) VALUES (18);
INSERT INTO "eventparticipant" (id_user) VALUES (19);
INSERT INTO "eventparticipant" (id_user) VALUES (20);

INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('dui lectus rutrum urna, nec','mollis.','true',19,'2018-11-27 10:52:33');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('In at','amet ornare lectus','true',15,'2018-08-11 10:05:11');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('faucibus. Morbi','semper pretium neque.','true',18,'2019-03-08 21:37:55');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('sit amet','orci. Ut semper','true',18,'2017-11-29 15:03:53');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('lacus pede sagittis augue, eu','Integer','true',4,'2018-07-28 12:51:07');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('eu enim.','ad litora torquent','true',8,'2018-09-20 01:15:10');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('enim, gravida sit amet,','id,','true',13,'2018-05-14 00:29:15');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('vulputate, lacus. Cras','Sed eu nibh','true',8,'2018-10-27 00:42:43');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('egestas.','Fusce fermentum fermentum','true',18,'2017-11-22 00:13:54');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('Vivamus non','tempus non, lacinia','true',8,'2018-05-31 14:35:47');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('tortor. Nunc commodo','quis','true',13,'2018-06-29 09:20:26');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('Pellentesque habitant morbi tristique','Nunc mauris.','true',20,'2019-03-11 05:48:46');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('eget, dictum placerat, augue.','Etiam imperdiet','true',8,'2018-05-18 10:02:34');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('non lorem vitae','sodales purus,','true',16,'2017-07-20 04:36:50');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('Aliquam','tempor, est','true',1,'2018-01-22 12:59:49');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('dolor, tempus non,','Curabitur','true',16,'2018-07-22 02:47:44');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('Donec nibh enim, gravida sit','velit dui, semper','true',17,'2017-12-10 19:34:37');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('tempor arcu. Vestibulum ut eros','Donec tempus,','true',19,'2017-09-01 12:56:31');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('at','fermentum metus. Aenean','true',11,'2019-03-11 16:55:29');
INSERT INTO "event" (description,title,is_public,id_localization,date)
VALUES ('interdum. Sed','sed leo. Cras','true',4,'2017-12-17 04:54:43');


INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-07-04 06:12:54','false',14,7,11);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2019-01-14 00:41:07','false',20,6,3);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2017-12-27 17:52:09','false',5,14,14);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-05-02 16:54:19','false',6,14,14);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-08-15 15:37:16','false',7,14,14);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2019-03-09 13:12:32','false',8,14,14);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2017-12-07 07:46:44','false',19,15,3);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-09-10 04:16:47','false',17,15,3);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2017-10-21 08:21:00','false',16,15,3);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2017-06-22 00:06:34','false',1,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-01-20 08:56:58','false',2,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2017-12-10 12:20:02','false',3,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-08-21 04:28:55','false',4,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-05-27 15:27:15','false',5,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-02-18 03:46:56','false',16,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2017-04-10 06:40:21','false',7,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-03-01 15:51:14','false',8,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2019-03-15 09:24:37','false',9,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2018-09-28 22:34:30','false',10,6,19);
INSERT INTO "invitation" (date,status,id_receiver,id_sender,id_event)
VALUES ('2019-01-28 20:51:02','false',11,6,19);

INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('senectus et netus et malesuada',8,12,'2017-08-24 15:12:19');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('ipsum sodales purus,',5,12,'2017-06-11 23:03:48');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('consequat nec, mollis vitae,',1,17,'2017-09-14 20:46:57');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('quis, pede. Suspendisse dui. Fusce',8,10,'2018-11-01 11:34:23');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('vitae, orci. Phasellus dapibus quam quis diam.',2,15,'2017-08-19 03:32:39');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('eget massa. Suspendisse',4,14,'2019-02-22 09:33:41');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus',6,10,'2018-08-07 07:58:00');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('nulla at sem',9,10,'2018-07-26 21:58:03');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('lacus. Quisque purus sapien,',9,16,'2017-08-04 17:39:31');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('dui, in sodales elit erat vitae',6,20,'2018-08-14 15:00:49');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('montes, nascetur ridiculus mus. Donec dignissim',5,16,'2018-02-04 20:40:15');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('Nam interdum enim non nisi. Aenean eget',3,17,'2018-08-24 04:34:27');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('nec,',7,16,'2018-06-09 20:25:46');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('laoreet posuere, enim nisl',6,16,'2018-01-19 03:12:19');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('commodo at,',2,15,'2018-06-29 09:23:04');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('diam at pretium aliquet, metus urna convallis erat, eget',10,11,'2017-12-12 14:25:28');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('vel est tempor bibendum. Donec felis orci, adipiscing',2,20,'2018-12-18 03:16:26');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('natoque penatibus et magnis dis parturient montes, nascetur ridiculus',2,15,'2017-05-20 05:26:55');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('dolor elit, pellentesque',8,10,'2018-05-26 14:47:26');
INSERT INTO "message" (content,id_sender,id_receiver,date)
VALUES ('Maecenas malesuada',4,20,'2018-04-10 11:00:30');

INSERT INTO "eventcategory" (id_event,id_category) VALUES (1,9);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (2,4);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (3,10);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (4,1);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (5,8);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (6,5);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (7,8);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (8,11);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (9,9);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (10,2);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (11,1);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (12,6);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (13,12);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (14,8);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (15,11);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (16,5);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (17,7);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (18,5);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (19,12);
INSERT INTO "eventcategory" (id_event,id_category) VALUES (20,5);

INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (14,14,4);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (15,3,1);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (2,5,3);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (19,3,5);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (2,13,4);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (17,12,2);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (6,19,3);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (14,6,3);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (18,19,3);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (19,8,3);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (7,19,1);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (5,8,2);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (6,3,3);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (18,1,1);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (20,19,3);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (2,16,2);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (3,10,1);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (6,10,2);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (7,11,5);
INSERT INTO "participate" (id_eventParticipant,id_event,classification)
VALUES (12,19,4);

INSERT INTO "eventowner" (id_eventParticipant) VALUES (1);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (2);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (3);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (4);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (5);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (6);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (7);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (8);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (9);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (10);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (11);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (12);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (13);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (14);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (15);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (16);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (17);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (18);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (19);
INSERT INTO "eventowner" (id_eventParticipant) VALUES (20);

INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (8,12);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (11,19);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (5,10);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (19,12);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (8,5);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (12,10);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (12,13);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (10,10);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (20,13);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (3,16);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (11,10);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (14,4);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (2,14);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (6,13);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (2,19);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (7,17);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (6,10);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (3,20);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (10,17);
INSERT INTO "ownevent" (id_eventOwner,id_event) VALUES (3,14);


INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (14,14,'../lbaw/files/name','2017-06-03 03:51:10');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (3,15,'../lbaw/files/name','2017-12-10 01:32:57');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (3,19,'../lbaw/files/name','2017-11-21 20:16:15');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (3,6,'../lbaw/files/name','2018-12-25 23:55:51');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (5,2,'../lbaw/files/name','2018-06-12 10:56:18');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (13,2,'../lbaw/files/name','2018-05-11 09:25:37');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (12,17,'../lbaw/files/name','2018-01-26 06:39:44');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (19,6,'../lbaw/files/name','2018-08-25 04:52:53');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (19,18,'../lbaw/files/name','2018-08-22 07:49:04');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (19,7,'../lbaw/files/name','2019-02-08 23:08:09');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (19,20,'../lbaw/files/name','2017-07-10 21:22:37');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (6,14,'../lbaw/files/name','2017-05-16 16:42:57');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (8,19,'../lbaw/files/name','2018-06-12 18:03:24');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (8,5,'../lbaw/files/name','2017-09-17 15:51:56');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (10,3,'../lbaw/files/name','2017-09-06 18:49:18');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (10,6,'../lbaw/files/name','2018-10-11 18:52:35');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (10,6,'../lbaw/files/name','2017-11-07 00:42:29');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (10,6,'../lbaw/files/name','2019-02-24 19:11:43');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (11,7,'../lbaw/files/name','2017-10-04 15:30:02');
INSERT INTO "file" (id_event,id_eventparticipant,path,submitteddate)
VALUES (11,7,'../lbaw/files/name','2018-10-19 00:19:58');

INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('eu, euismod ac,',14,14,'2017-07-12 23:08:47');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('quis, tristique',14,14,'2017-05-16 18:43:52');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('commodo tincidunt nibh. Phasellus',15,3,'2017-12-23 02:36:34');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('Donec dignissim magna a',19,3,'2017-08-22 04:55:46');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('Aliquam nisl.',6,3,'2017-05-07 01:53:52');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('sociis',6,3,'2017-08-05 08:13:45');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('Vestibulum ante ipsum primis',7,11,'2018-09-20 00:16:50');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('amet,',6,3,'2018-06-26 16:47:49');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('ac mattis velit',6,3,'2017-06-28 19:12:13');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('eu dolor egestas rhoncus.',6,3,'2018-06-15 11:16:12');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('lectus sit',2,5,'2017-10-12 23:38:15');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('Nulla tincidunt, neque',2,13,'2018-07-13 02:17:42');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('In',19,8,'2017-04-13 12:08:43');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('Suspendisse tristique neque',19,8,'2018-02-05 02:09:48');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('tincidunt dui augue',19,8,'2017-08-03 08:43:44');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('quis accumsan convallis,',19,8,'2018-08-25 07:23:45');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('lobortis quis, pede.',3,10,'2018-09-16 12:44:04');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('vestibulum, neque sed',6,10,'2018-04-05 22:56:26');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('sodales purus,',7,19,'2018-05-29 19:32:18');
INSERT INTO "post" (content,id_poster,id_event,date)
VALUES ('arcu et',6,10,'2017-05-04 11:59:52');



INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('nulla.',8,12,'2018-07-05 08:50:44');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('dis parturient montes,',11,19,'2017-07-31 11:46:37');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('faucibus orci',5,10,'2019-01-23 19:25:49');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('neque. Nullam nisl.',19,12,'2018-12-20 00:51:58');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('facilisis non, bibendum sed, est.',8,5,'2017-07-05 17:34:24');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('vulputate eu, odio. Phasellus',12,10,'2017-06-18 15:55:29');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('Cum sociis natoque',12,13,'2017-08-20 14:50:35');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('erat.',19,12,'2017-07-06 23:06:59');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('Suspendisse sagittis. Nullam vitae',10,10,'2018-01-15 21:23:57');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('sem molestie',20,13,'2017-06-16 00:49:50');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('mi',3,16,'2018-04-08 07:03:58');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('amet ornare lectus justo eu',11,10,'2017-10-25 07:04:29');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('ac facilisis',11,10,'2017-06-10 10:00:14');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('convallis',11,10,'2018-12-27 09:38:50');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('sollicitudin a, malesuada',10,10,'2018-11-26 13:05:54');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('lacus.',10,10,'2018-04-13 21:35:47');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('a odio semper cursus.',10,10,'2017-10-29 18:22:17');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('In mi pede, nonummy',11,10,'2018-01-31 21:57:44');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('lectus ante dictum mi,',10,10,'2017-05-14 16:11:02');
INSERT INTO "poll" (description,id_owner,id_event,date)
VALUES ('diam dictum sapien.',10,10,'2018-10-07 21:35:19');


INSERT INTO "polloption" (description,id_poll)
VALUES ('sit',6);
INSERT INTO "polloption" (description,id_poll)
VALUES ('pellentesque a,',12);
INSERT INTO "polloption" (description,id_poll)
VALUES ('est',5);
INSERT INTO "polloption" (description,id_poll)
VALUES ('sit',14);
INSERT INTO "polloption" (description,id_poll)
VALUES ('ac, eleifend vitae, erat. Vivamus',18);
INSERT INTO "polloption" (description,id_poll) VALUES ('eget varius ultrices, mauris',16);
INSERT INTO "polloption" (description,id_poll) VALUES ('sollicitudin commodo ipsum. Suspendisse',6);
INSERT INTO "polloption" (description,id_poll) VALUES ('facilisis non,',8);
INSERT INTO "polloption" (description,id_poll) VALUES ('hendrerit. Donec porttitor tellus non',6);
INSERT INTO "polloption" (description,id_poll) VALUES ('magna. Ut tincidunt orci quis',11);
INSERT INTO "polloption" (description,id_poll) VALUES ('in felis. Nulla',16);
INSERT INTO "polloption" (description,id_poll) VALUES ('congue turpis. In condimentum.',11);
INSERT INTO "polloption" (description,id_poll) VALUES ('tincidunt dui augue eu tellus.',6);
INSERT INTO "polloption" (description,id_poll) VALUES ('sagittis augue,',15);
INSERT INTO "polloption" (description,id_poll) VALUES ('sed, hendrerit a, arcu. Sed',12);
INSERT INTO "polloption" (description,id_poll) VALUES ('accumsan sed,',14);
INSERT INTO "polloption" (description,id_poll) VALUES ('consectetuer adipiscing elit.',4);
INSERT INTO "polloption" (description,id_poll) VALUES ('natoque penatibus',5);
INSERT INTO "polloption" (description,id_poll) VALUES ('justo faucibus lectus, a sollicitudin',13);
INSERT INTO "polloption" (description,id_poll) VALUES ('quam. Curabitur',16);

INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (1,14);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (2,3);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (2,6);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (3,19);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (3,15);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (3,6);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (4,19);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (4,15);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (4,6);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (5,19);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (5,15);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (5,6);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (6,6);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (6,15);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (6,19);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (7,6);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (7,15);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (7,19);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (8,19);
INSERT INTO "pollvote" (id_poll_option,id_eventParticipant) VALUES (8,15);