Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO ISSUES(ISSUESLISTS_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
- VALUES(1, "Task1", "JustTask1", 1);
- INSERT INTO ISSUES(ISSUESLISTS_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
- VALUES(2, "Task5", "JustTask5", 4);
- INSERT INTO ISSUES(ISSUESLISTS_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
- VALUES(3, "Task5", "JustTask5", 1);
- CREATE TABLE ISSUESLISTS
- (
- ID SERIAL PRIMARY KEY,
- NAME VARCHAR(100)
- );
- CREATE TABLE ISSUES
- (
- ID SERIAL PRIMARY KEY,
- ISSUESLISTS_ID BIGINT UNSIGNED NOT NULL,
- FOREIGN KEY (ISSUESLISTS_ID) REFERENCES ISSUESLISTS(ID),
- SUMMARY VARCHAR(100),
- DESCRIPTION VARCHAR(1024),
- USER_ID_ASSIGNEDTO BIGINT UNSIGNED NOT NULL,
- FOREIGN KEY(USER_ID_ASSIGNEDTO) REFERENCES USERS(ID)
- );
Add Comment
Please, Sign In to add comment