--Creating tables--
BEGIN TRANSACTION;

--Scen table--
CREATE TABLE Scen(
    scen_id SERIAL PRIMARY KEY,
    namn VARCHAR(20) NOT NULL,
    max_askadare INTEGER NOT NULL
);

--Jobbare table--
CREATE TABLE Jobbare(
    jobbare_id SERIAL PRIMARY KEY,
    namn VARCHAR(30) NOT NULL,
    personnummer VARCHAR(13) NOT NULL,
    adress VARCHAR(40) NOT NULL
);

--Band table--
CREATE TABLE Band(
    band_id SERIAL PRIMARY KEY,
    namn VARCHAR(30) NOT NULL,
    land VARCHAR(20) NOT NULL,
    info TEXT NOT NULL,
    jobbare INTEGER REFERENCES Jobbare(jobbare_id)
);

--Artist table--
CREATE TABLE Artist(
    artist_id SERIAL PRIMARY KEY,
    namn VARCHAR(30) NOT NULL,
    info TEXT NOT NULL
);

--Band_Artist table--
CREATE TABLE Band_Artist(
    band INTEGER REFERENCES Band(band_id),
    artist INTEGER REFERENCES Artist(artist_id),
    PRIMARY KEY(band, artist)
);

--Scen_Schema table--
CREATE TABLE Scen_Schema(
    upptradande_id SERIAL PRIMARY KEY,
    scen INTEGER REFERENCES Scen(scen_id) NOT NULL,
    band INTEGER REFERENCES Band(band_id) NOT NULL,
    tid_start TIMESTAMP NOT NULL,
    tid_stopp TIMESTAMP NOT NULL
);

END TRANSACTION;

--Inserting dara into tables--
BEGIN TRANSACTION;

--Scen data--
INSERT INTO Scen(namn, max_askadare) VALUES('Mallorcascenen', 2000);
INSERT INTO Scen(namn, max_askadare) VALUES('Forumscenen', 500);
INSERT INTO Scen(namn, max_askadare) VALUES('Skogsscenen', 1000);
INSERT INTO Scen(namn, max_askadare) VALUES('LillaScenen', 200);
INSERT INTO Scen(namn, max_askadare) VALUES('Dieseltältet', 150);

--Jobbare data--
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Hugo Hansen', '19971031-1441', 'Landvägen 31');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Oscar Nilsson', '19830503-3142', 'Björkavägen 12');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Hannah Svensson', '19930721-6314', 'Järnvägsgatan 15b');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Ulf Lidgren', '19880212-5312', 'Kyrkvägen 7');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Marie Magnusson', '19751005-3219', 'Apelgatan 21');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Lennart Karlsson', '19631201-3265', 'Drakagatan 18');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Daniel Cehic', '19961023-5963', 'Gibraltargatan 39');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Ebba Begntsson', '19831104-8263', 'Gråvidegatan 13');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Jacob Jacobsson', '19910112-5763', 'Husievägen 26');
INSERT INTO Jobbare(namn personnummer, adress) VALUES('Johan Nyman', '200003015-7294', 'Hammargatan 14b');

--Band data--
INSERT INTO Band(namn, land, info, jobbare) VALUES('The Rockets', 'Sverige',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
 Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
 Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'
 , 1);
INSERT INTO Band(namn, land, info, jobbare) VALUES('Chemist Adam', 'Irland',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
 Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
 Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'
 , 1);
INSERT INTO Band(namn, land, info, jobbare) VALUES('Whizz Bishop', 'Sverige',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
 Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
 Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'
 , 2);
INSERT INTO Band(namn, land, info, jobbare) VALUES('Jedi Eggshell', 'Norge',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
 Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
 Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'
 , 5);
INSERT INTO Band(namn, land, info, jobbare) VALUES('Restricted Prescription', 'Finland',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
 Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
 Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'
 , 8);
INSERT INTO Band(namn, land, info, jobbare) VALUES('Dope Shelf', 'Sverige',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
 Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
 Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'
 , 10);
INSERT INTO Band(namn, land, info, jobbare) VALUES('Jarmo Haapala', 'Sverige',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
 Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
 Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'
 , 3);


--Artist data--
INSERT INTO Artist(namn, info) VALUES('Ivar Hofman',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Gabriel Norddahl',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Linus Sanddahl',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Anders Tegnér',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Jonny Norström',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Therese Sundin',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Nichole Samuelsson',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('August Sparre',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Ludvig Edgren',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Johan Nordquist',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Mattias Rosenquist',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Max Englund',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Nelly Borg',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Gösta Sjöholm',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Lucas Löfgren',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Jimmy McDermott',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Rory O Casey',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Owen Brennan',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');
INSERT INTO Artist(namn, info) VALUES('Jarmo Haapala',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
 Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.');

--Band_Artist data--
INSERT INTO Band_Artist(band, artist) VALUES(1, 1);
INSERT INTO Band_Artist(band, artist) VALUES(1, 2);
INSERT INTO Band_Artist(band, artist) VALUES(1, 3);
INSERT INTO Band_Artist(band, artist) VALUES(1, 4);
INSERT INTO Band_Artist(band, artist) VALUES(2, 16);
INSERT INTO Band_Artist(band, artist) VALUES(2, 17);
INSERT INTO Band_Artist(band, artist) VALUES(2, 18);
INSERT INTO Band_Artist(band, artist) VALUES(3, 5);
INSERT INTO Band_Artist(band, artist) VALUES(3, 6);
INSERT INTO Band_Artist(band, artist) VALUES(4, 7);
INSERT INTO Band_Artist(band, artist) VALUES(4, 8);
INSERT INTO Band_Artist(band, artist) VALUES(5, 9);
INSERT INTO Band_Artist(band, artist) VALUES(5, 10);
INSERT INTO Band_Artist(band, artist) VALUES(5, 11);
INSERT INTO Band_Artist(band, artist) VALUES(5, 12);
INSERT INTO Band_Artist(band, artist) VALUES(6, 13);
INSERT INTO Band_Artist(band, artist) VALUES(6, 14);
INSERT INTO Band_Artist(band, artist) VALUES(6, 15);
INSERT INTO Band_Artist(band, artist) VALUES(7, 19);

--Spel_Schema data dag 1--
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(1, 1, '2018-06-07 15:00:00', '2018-06-07 18:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(1, 2, '2018-06-07 19:00:00', '2018-06-07 22:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(1, 3, '2018-06-07 23:00:00', '2018-06-08 02:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(2, 7, '2018-06-07 15:00:00', '2018-06-07 17:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(2, 6, '2018-06-07 18:00:00', '2018-06-07 22:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(2, 5, '2018-06-07 22:00:00', '2018-06-08 01:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(3, 4, '2018-06-07 15:00:00', '2018-06-07 18:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(3, 1, '2018-06-07 19:00:00', '2018-06-07 22:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(3, 7, '2018-06-07 23:00:00', '2018-06-08 02:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(4, 5, '2018-06-07 15:00:00', '2018-06-07 17:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(4, 7, '2018-06-07 19:00:00', '2018-06-07 21:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(4, 2, '2018-06-07 24:00:00', '2018-06-08 02:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(5, 4, '2018-06-07 23:00:00', '2018-06-08 02:00:00');

--Spel_Schema data dag 2--
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(1, 5, '2018-06-08 15:00:00', '2018-06-08 18:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(1, 6, '2018-06-08 19:00:00', '2018-06-08 22:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(1, 4, '2018-06-08 23:00:00', '2018-06-09 02:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(2, 1, '2018-06-08 15:00:00', '2018-06-08 17:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(2, 2, '2018-06-08 18:00:00', '2018-06-08 21:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(2, 3, '2018-06-08 22:00:00', '2018-06-09 01:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(3, 7, '2018-06-08 15:00:00', '2018-06-08 18:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(3, 1, '2018-06-08 19:00:00', '2018-06-08 22:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(3, 5, '2018-06-08 23:00:00', '2018-06-09 02:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(4, 3, '2018-06-08 15:00:00', '2018-06-08 17:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(4, 6, '2018-06-08 24:00:00', '2018-06-09 02:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(5, 4, '2018-06-08 19:00:00', '2018-06-08 22:00:00');
INSERT INTO Spel_Schema(scen, band, tid_start, tid_stopp) VALUES(5, 7, '2018-06-08 23:00:00', '2018-06-09 02:00:00');

END TRANSACTION;