Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. UPDATES FROM gear-devel sql:
  2.  
  3. ALTER TABLE dataset:
  4. --------------------
  5. ALTER TABLE dataset ADD COLUMN share_id VARCHAR(50) NOT NULL AFTER schematic_image;
  6.  
  7.  
  8. ADD dataset_shares table:
  9. -------------------------
  10. CREATE TABLE dataset_shares(id INT PRIMARY KEY AUTO_INCREMENT, dataset_id VARCHAR(50) NOT NULL, user_id INT NOT NULL, is_allowed TINYINT(1) DEFAULT 0, FOREIGN KEY (dataset_id) REFERENCES dataset(id) ON DELETE CASCADE, FOREIGN KEY (user_id) REFERENCES guser(id) ON DELETE CASCADE) ENGINE=INNODB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement