Guest User

Untitled

a guest
Oct 20th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. INSERT INTO ISSUES(ISSUESLISTS_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
  2. VALUES(1, "Task1", "JustTask1", 1);
  3.  
  4. INSERT INTO ISSUES(ISSUESLISTS_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
  5. VALUES(2, "Task5", "JustTask5", 4);
  6.  
  7. INSERT INTO ISSUES(ISSUESLISTS_ID, SUMMARY, DESCRIPTION, USER_ID_ASSIGNEDTO)
  8. VALUES(3, "Task5", "JustTask5", 1);
  9.  
  10. CREATE TABLE ISSUESLISTS
  11. (
  12. ID SERIAL PRIMARY KEY,
  13. NAME VARCHAR(100)
  14. );
  15.  
  16. CREATE TABLE ISSUES
  17. (
  18. ID SERIAL PRIMARY KEY,
  19. ISSUESLISTS_ID BIGINT UNSIGNED NOT NULL,
  20. FOREIGN KEY (ISSUESLISTS_ID) REFERENCES ISSUESLISTS(ID),
  21. SUMMARY VARCHAR(100),
  22. DESCRIPTION VARCHAR(1024),
  23. USER_ID_ASSIGNEDTO BIGINT UNSIGNED NOT NULL,
  24. FOREIGN KEY(USER_ID_ASSIGNEDTO) REFERENCES USERS(ID)
  25. );
Add Comment
Please, Sign In to add comment