Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATES FROM gear-devel sql:
- ALTER TABLE dataset:
- --------------------
- ALTER TABLE dataset ADD COLUMN share_id VARCHAR(50) NOT NULL AFTER schematic_image;
- ADD dataset_shares table:
- -------------------------
- 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