Answers for "ALTER TABLE `users` ADD FOREIGN KEY (`type`) REFERENCES `roles`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;"

mysql alter add foreign key

ALTER TABLE ordenes ADD ticket VARCHAR(50) NOT NULL;
ALTER TABLE ordenes ADD CONSTRAINT fk_ticket FOREIGN KEY (ticket) REFERENCES tickets(ticket);

Posted by: Guest on October-19-2020

Code answers related to "ALTER TABLE `users` ADD FOREIGN KEY (`type`) REFERENCES `roles`(`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;"