-- Table: public.activity
 DROP TABLE public.link_activityplan_to_location;
 DROP TABLE public.link_activity_to_location;
 DROP TABLE public.link_activity_to_plan;
 DROP TABLE public.users_roles_link;
 DROP TABLE public.link_plan_to_user;
 DROP TABLE public.location;
 DROP TABLE public.roles;
 DROP TABLE public.users;
 DROP TABLE public.activityplan;

 DROP TABLE public.activity;

CREATE TABLE public.activity
(
    activityuuid uuid NOT NULL,
    name text,
    description text,
    "time" text,
    weekday integer,
    weeknumber integer,
    year integer,
    place text,
    type integer,
    duration real,
    CONSTRAINT activity_pkey PRIMARY KEY (activityuuid)
);


-- Table: public.location



CREATE TABLE public.location
(
    name_of_location text NOT NULL,
    uuid uuid NOT NULL,
    CONSTRAINT location_pkey PRIMARY KEY (uuid)
);

-- Table: public.activityplan


CREATE TABLE public.activityplan
(
    name text NOT NULL,
    activityplanuuid uuid NOT NULL,
    CONSTRAINT activityplan_pkey PRIMARY KEY (activityplanuuid)
);


-- Table: public.link_activity_to_plan



CREATE TABLE public.link_activity_to_plan
(
    activityuuid uuid NOT NULL,
    planuuid uuid NOT NULL
);


-- Table: public.link_plan_to_user



CREATE TABLE public.link_plan_to_user
(
    planuuid uuid NOT NULL,
    useruuid uuid NOT NULL
);


-- Table: public.roles



CREATE TABLE public.roles
(
    uuid uuid NOT NULL,
    name text NOT NULL,
    CONSTRAINT roles_pkey PRIMARY KEY (uuid)
);


-- Table: public.users



CREATE TABLE public.users
(
    uuid uuid NOT NULL,
    name text NOT NULL,
    username text NOT NULL,
    password text NOT NULL,
    CONSTRAINT users_pkey PRIMARY KEY (uuid)
);


-- Table: public.users_roles_link



CREATE TABLE public.users_roles_link
(
    user_fk uuid NOT NULL,
    role_fk uuid NOT NULL,
    location_fk uuid NOT NULL
);

-- Table: public.link_activity_to_location



CREATE TABLE public.link_activity_to_location
(
    fk_activity_uuid uuid NOT NULL,
    fk_location_uuid uuid NOT NULL,
    CONSTRAINT fk_activity FOREIGN KEY (fk_activity_uuid)
        REFERENCES public.activity (activityuuid) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE,
    CONSTRAINT fk_location FOREIGN KEY (fk_location_uuid)
        REFERENCES public.location (uuid) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE
);


-- Table: public.link_activityplan_to_location



CREATE TABLE public.link_activityplan_to_location
(
    fk_location_uuid uuid NOT NULL,
    fk_activityplan_uuid uuid NOT NULL,
    CONSTRAINT fk_activityplan_uuid FOREIGN KEY (fk_activityplan_uuid)
        REFERENCES public.activityplan (activityplanuuid) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE,
    CONSTRAINT fk_location FOREIGN KEY (fk_location_uuid)
        REFERENCES public.location (uuid) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE
);

insert into roles values ('1efec4d7-3543-4ae4-accd-6c32c0b268b3','ansat');
insert into roles values ('6715b71a-5b9a-4bd7-bbab-7189a9117642','vikar');
insert into roles values ('e626f910-cbd9-40fd-8e1a-9395ad69bffa','borger');

insert into users values ('b3891e83-92ae-4386-9efa-f4fa9805a59c','jens','jens','jensen');
insert into users values ('cf9b4813-4924-4865-ab40-36c8f5c6ce43','trine','trine','madsen');
insert into users values ('99e59345-eb3e-4e18-bd5c-fb2916ac95ec','find','find','klausen');
insert into users values ('41cda85e-9a9d-4307-a7b7-031df472513c','jan','jan','hansen');
insert into users values ('14be2c66-8516-4c3e-9d41-5aeff46d7e9e','gurlig','gurlig','jensen');
insert into users values ('04786ec1-ed79-4b07-ae09-15fe957656f1','klaus','klaus','caspersen');
insert into users values ('5f85dac4-cc45-41a3-abc0-5ec1df6acb44','bo','bo','pedersen');


insert into location values ('Bjørnemosen','8e9a570f-8339-45d6-8f05-8a12e71c27b6');
insert into location values ('Vendelbo','d596aa6e-035e-4abf-b995-43bc18895965');

insert into users_roles_link values ('b3891e83-92ae-4386-9efa-f4fa9805a59c','e626f910-cbd9-40fd-8e1a-9395ad69bffa','8e9a570f-8339-45d6-8f05-8a12e71c27b6');
insert into users_roles_link values ('5f85dac4-cc45-41a3-abc0-5ec1df6acb44','e626f910-cbd9-40fd-8e1a-9395ad69bffa','8e9a570f-8339-45d6-8f05-8a12e71c27b6');
insert into users_roles_link values ('04786ec1-ed79-4b07-ae09-15fe957656f1','6715b71a-5b9a-4bd7-bbab-7189a9117642','8e9a570f-8339-45d6-8f05-8a12e71c27b6');
insert into users_roles_link values ('14be2c66-8516-4c3e-9d41-5aeff46d7e9e','1efec4d7-3543-4ae4-accd-6c32c0b268b3','8e9a570f-8339-45d6-8f05-8a12e71c27b6');
insert into users_roles_link values ('41cda85e-9a9d-4307-a7b7-031df472513c','e626f910-cbd9-40fd-8e1a-9395ad69bffa','d596aa6e-035e-4abf-b995-43bc18895965');
insert into users_roles_link values ('99e59345-eb3e-4e18-bd5c-fb2916ac95ec','e626f910-cbd9-40fd-8e1a-9395ad69bffa','d596aa6e-035e-4abf-b995-43bc18895965');
insert into users_roles_link values ('cf9b4813-4924-4865-ab40-36c8f5c6ce43','6715b71a-5b9a-4bd7-bbab-7189a9117642','d596aa6e-035e-4abf-b995-43bc18895965');
insert into users_roles_link values ('04786ec1-ed79-4b07-ae09-15fe957656f1','1efec4d7-3543-4ae4-accd-6c32c0b268b3','d596aa6e-035e-4abf-b995-43bc18895965');

insert into activityplan values ('Fodbold','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into activityplan values ('Fællesspisning','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');

insert into link_activityplan_to_location values ('8e9a570f-8339-45d6-8f05-8a12e71c27b6','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into link_activityplan_to_location values ('8e9a570f-8339-45d6-8f05-8a12e71c27b6','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');

insert into activity values ('27ab147b-611f-48e3-a11c-4ebe28222509','Træning','Fodbold Træning på Banen',1400,1,24,2019,'Fodboldbanen',1,2);	insert into link_activity_to_location values ('27ab147b-611f-48e3-a11c-4ebe28222509','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('27ab147b-611f-48e3-a11c-4ebe28222509','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into activity values ('d6fc2878-2d23-460f-b9a7-aa21da0b6509','Træning','Fodbold Træning på Banen',1400,4,24,2019,'Fodboldbanen',1,2);	insert into link_activity_to_location values ('d6fc2878-2d23-460f-b9a7-aa21da0b6509','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('d6fc2878-2d23-460f-b9a7-aa21da0b6509','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into activity values ('1d14a0b6-cfa6-4e29-8f04-87c7399e7753','Træning','Fodbold Træning på Banen',1400,1,25,2019,'Fodboldbanen',1,2);	insert into link_activity_to_location values ('1d14a0b6-cfa6-4e29-8f04-87c7399e7753','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('1d14a0b6-cfa6-4e29-8f04-87c7399e7753','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into activity values ('c696b645-eeaa-4e52-a62a-cc3a9a390034','Træning','Fodbold Træning på Banen',1400,4,25,2019,'Fodboldbanen',1,2);	insert into link_activity_to_location values ('c696b645-eeaa-4e52-a62a-cc3a9a390034','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('c696b645-eeaa-4e52-a62a-cc3a9a390034','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into activity values ('5a849c86-c4aa-47e7-b957-a8f26efcca52','Træning','Fodbold Træning på Banen',1400,1,26,2019,'Fodboldbanen',1,2);	insert into link_activity_to_location values ('5a849c86-c4aa-47e7-b957-a8f26efcca52','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('5a849c86-c4aa-47e7-b957-a8f26efcca52','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into activity values ('96d128cb-70d4-4b60-b20f-4edbbbe1abac','Træning','Fodbold Træning på Banen',1400,4,26,2019,'Fodboldbanen',1,2);	insert into link_activity_to_location values ('96d128cb-70d4-4b60-b20f-4edbbbe1abac','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('96d128cb-70d4-4b60-b20f-4edbbbe1abac','dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef');
insert into activity values ('bdb987b1-3b4e-4b43-bcc7-fe45db378481','Morgenmad','Fælles Spisning','0800',2,24,2019,'Kantinen',2,1);	insert into link_activity_to_location values ('bdb987b1-3b4e-4b43-bcc7-fe45db378481','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('bdb987b1-3b4e-4b43-bcc7-fe45db378481','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');
insert into activity values ('50619410-36c7-4e1e-946e-85d9973d3a45','Morgenmad','Fælles Spisning','0800',5,24,2019,'Kantinen',2,1);	insert into link_activity_to_location values ('50619410-36c7-4e1e-946e-85d9973d3a45','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('50619410-36c7-4e1e-946e-85d9973d3a45','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');
insert into activity values ('ec26fc52-5c2c-4f71-a25a-7d54cd0541ae','Morgenmad','Fælles Spisning','0800',2,25,2019,'Kantinen',2,1);	insert into link_activity_to_location values ('ec26fc52-5c2c-4f71-a25a-7d54cd0541ae','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('ec26fc52-5c2c-4f71-a25a-7d54cd0541ae','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');
insert into activity values ('356aa5aa-f427-47a5-97ba-75aa1109b17e','Morgenmad','Fælles Spisning','0800',5,25,2019,'Kantinen',2,1);	insert into link_activity_to_location values ('356aa5aa-f427-47a5-97ba-75aa1109b17e','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('356aa5aa-f427-47a5-97ba-75aa1109b17e','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');
insert into activity values ('07c235df-6c02-4d38-ad82-2b410a0e9b79','Morgenmad','Fælles Spisning','0800',2,26,2019,'Kantinen',2,1);	insert into link_activity_to_location values ('07c235df-6c02-4d38-ad82-2b410a0e9b79','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('07c235df-6c02-4d38-ad82-2b410a0e9b79','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');
insert into activity values ('f2ca60f3-ecf7-4fd6-b563-959b99010b2a','Morgenmad','Fælles Spisning','0800',5,26,2019,'Kantinen',2,1);	insert into link_activity_to_location values ('f2ca60f3-ecf7-4fd6-b563-959b99010b2a','8e9a570f-8339-45d6-8f05-8a12e71c27b6');	insert into link_activity_to_plan values ('f2ca60f3-ecf7-4fd6-b563-959b99010b2a','5ded9746-87ce-4ffe-b26b-98c4c7181f3b');

insert into link_plan_to_user values ('5ded9746-87ce-4ffe-b26b-98c4c7181f3b','b3891e83-92ae-4386-9efa-f4fa9805a59c');
insert into link_plan_to_user values ('5ded9746-87ce-4ffe-b26b-98c4c7181f3b','5f85dac4-cc45-41a3-abc0-5ec1df6acb44');
insert into link_plan_to_user values ('dd8e0c9a-421f-4be8-9ca8-0bb66f35d5ef','5f85dac4-cc45-41a3-abc0-5ec1df6acb44');