Syntax error mysql migration using composite primary key
--> statement-breakpoint
CREATE TABLE `member_to_address` (
`member_id` varchar(32) NOT NULL,
`address_id` varchar(32) NOT NULL
);
ALTER TABLE `member_to_address` ADD PRIMARY KEY(`member_id`,`address_id`);--> statement-breakpoint
CREATE TABLE `member_to_address` (
`member_id` varchar(32) NOT NULL,
`address_id` varchar(32) NOT NULL
);
ALTER TABLE `member_to_address` ADD PRIMARY KEY(`member_id`,`address_id`);This part of my migration won't run due to:
DatabaseError: syntax error at position 114 near 'ALTER'
at Connection.execute (webpack-internal:///(sc_server)/./node_modules/@planetscale/database/dist/index.js:95:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
status: 400,
body: {
message: "syntax error at position 114 near 'ALTER'",
code: 'UNKNOWN'
}
}DatabaseError: syntax error at position 114 near 'ALTER'
at Connection.execute (webpack-internal:///(sc_server)/./node_modules/@planetscale/database/dist/index.js:95:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
status: 400,
body: {
message: "syntax error at position 114 near 'ALTER'",
code: 'UNKNOWN'
}
}The table looks like this:
export const memberToAddress = mysqlTable(
"member_to_address",
{
memberId: varchar("member_id", { length: 32 }).notNull(),
addressId: varchar("address_id", { length: 32 }).notNull(),
},
(memberToAddress) => ({
cpk: primaryKey(memberToAddress.memberId, memberToAddress.addressId),
memberIdx: index("member_idx").on(memberToAddress.memberId),
addressIdx: index("address_idx").on(memberToAddress.addressId),
})
);export const memberToAddress = mysqlTable(
"member_to_address",
{
memberId: varchar("member_id", { length: 32 }).notNull(),
addressId: varchar("address_id", { length: 32 }).notNull(),
},
(memberToAddress) => ({
cpk: primaryKey(memberToAddress.memberId, memberToAddress.addressId),
memberIdx: index("member_idx").on(memberToAddress.memberId),
addressIdx: index("address_idx").on(memberToAddress.addressId),
})
);Where I want to link multiple addresses to a member object.
Im using the planetscale-serverless migrator.
