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`);

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'
  }
}

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),
  })
);