CREATE TABLE ISSUESLISTS
(
    ID      SERIAL PRIMARY KEY,
    NAME        VARCHAR(100)
);

CREATE TABLE ISSUES
(
    ID          SERIAL PRIMARY KEY,
    ISSUESLIST_ID       BIGINT UNSIGNED NOT NULL,
    SUMMARY         VARCHAR(1024),
    DESCRIPTION     VARCHAR(1024),
    USER_ID_ASSIGNEDTO  BIGINT UNSIGNED NOT NULL,
    FOREIGN KEY (ISSUESLIST_ID)         REFERENCES ISSUESLISTS(ID),
    FOREIGN KEY (USER_ID_ASSIGNEDTO)    REFERENCES USERS(ID)
);

INSERT INTO ISSUESLISTS (NAME)
VALUES ("ToDo");

INSERT INTO ISSUESLISTS (NAME)
VALUES ("In progress");

INSERT INTO ISSUESLISTS (NAME)
VALUES ("Done");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (1, 1, "Screen", "Screen don't turn off");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (1, 2, "Memory", "Memory is low");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (1, 3, "Transfer data", "Low speed data transfer");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (1, 4, "Keyboard", "Spacerbar don't work");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (1, 5, "Processor", "Low reaction time");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (2, 1, "Hunger", "We need to eat");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (2, 2, "Thirsty", "We need to drink");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (2, 3, "Low condition", "We sit all day");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (2, 4, "Only one more", "Almost done");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (2, 5, "Last one", "We did it?");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (3, 1, "Fix 1", "First issue");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (3, 2, "Fix 2", "Second issue");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (3, 3, "Fix 3", "Third issue");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (3, 4, "Fix 4", "Fourth issue");

INSERT INTO ISSUES (ISSUESLIST_ID, USER_ID_ASSIGNEDTO, SUMMARY, DESCRIPTION)
VALUES (3, 5, "Fix 5", "Fifth issue");



COMMIT;