You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE `works_to_creators` (
`work_id` integer NOT NULL,
`creator_id` integer NOT NULL,
`classification` text NOT NULL,
PRIMARY KEY(`classification`, `creator_id`, `work_id`), # wrong order
FOREIGN KEY (`work_id`) REFERENCES `works`(`id`) ON UPDATE no action ON DELETE no action,
FOREIGN KEY (`creator_id`) REFERENCES `creators`(`id`) ON UPDATE no action ON DELETE no action
);
CREATE TABLE `works_to_creators` (
`work_id` integer NOT NULL,
`creator_id` integer NOT NULL,
`classification` text NOT NULL,
PRIMARY KEY(`work_id`, `creator_id`, `classification`), # correct order
FOREIGN KEY (`work_id`) REFERENCES `works`(`id`) ON UPDATE no action ON DELETE no action,
FOREIGN KEY (`creator_id`) REFERENCES `creators`(`id`) ON UPDATE no action ON DELETE no action
);
What version of
drizzle-orm
are you using?0.30.10
What version of
drizzle-kit
are you using?0.21.1
Describe the Bug
desired column order: [t.workId, t.creatorId, t.classification]
actual column order: [t.classification, t.creator_id, t.work_id]
Expected behavior
Environment & setup
The text was updated successfully, but these errors were encountered: