task table.txt

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

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

3. INSERT INTO ISSUESLISTS (ID, NAME)
VALUES (1, "ToDo");

INSERT INTO ISSUESLISTS (ID, NAME)
VALUES (2, "In progress");

INSERT INTO ISSUESLISTS (ID, NAME)
VALUES (3, "Done");

COMMIT;

4. INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (1, 1, "SHOPPING", "BUY BEERS FOR THE PARTY", 1);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (2, 1, "COOKING", "MAKE LASAGNA", 1);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (3, 1, "VISIT MARK", "HELP HIM WITH THE NEW FURNITURE", 3);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (4, 1, "STUDYING", "EXAM TOMORROW", 4);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (5, 1, "WALKING", "TAKE REKSIO OUT FOR A WALK", 5);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (6, 2, "TAKING OUT TRASH", "IT IS ABOUT TIME", 5);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (7, 2, "CALLING MOM", "IT HAS BEEN A WHILE...", 2);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (8, 2, "PREPARING DRINKS", "WHISKY, RUM, GIN", 2);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (9, 2, "CLEANING", "VACUUMING, MOPPING THE FLOORS", 4);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (10, 2, "DISHES", "PUT THEM IN THE DISHWASHER", 3);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (11, 3, "SLEEPING", "8 HOURS", 4);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (12, 3, "READING", "NEW BOOK BY STEPHEN KING", 1);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (13, 3, "JOGGING", "BEFORE THE BREAKFAST", 5);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (14, 3, "SHOPPING", "BUY GIFTS FOR MARTHA", 2);

INSERT INTO ISSUES (ID, ISSUESLIST_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
VALUES (15, 3, "DANCING", "LEARN HOW TO DANCE SALSA", 2);