Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE `mcr_users`
- ADD COLUMN `uuid` CHAR(36) UNIQUE DEFAULT NULL,
- DELIMITER //
- CREATE TRIGGER setUUID BEFORE INSERT ON `mcr_users`
- FOR EACH ROW BEGIN
- IF NEW.uuid IS NULL THEN
- SET NEW.uuid = UUID();
- END IF;
- END; //
- DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement