forked from BRETT/BRETT
5 lines
445 B
SQL
5 lines
445 B
SQL
ALTER TABLE `comments` DROP FOREIGN KEY `comments_upload_id_uploads_id_fk`;--> statement-breakpoint
|
|
ALTER TABLE `uploads` MODIFY COLUMN `id` varchar(8) NOT NULL;--> statement-breakpoint
|
|
ALTER TABLE `comments` MODIFY COLUMN `upload_id` varchar(8) NOT NULL;--> statement-breakpoint
|
|
ALTER TABLE `comments` ADD CONSTRAINT `comments_upload_id_uploads_id_fk` FOREIGN KEY (`upload_id`) REFERENCES `uploads`(`id`) ON DELETE cascade ON UPDATE no action;
|