6 lines
207 B
MySQL
6 lines
207 B
MySQL
|
-- Drop the existing primary key
|
||
|
|
ALTER TABLE puzzles DROP CONSTRAINT puzzles_pkey;
|
||
|
|
|
||
|
|
-- Add new auto-incrementing primary key while keeping PuzzleId
|
||
|
|
ALTER TABLE puzzles ADD COLUMN pkey BIGSERIAL PRIMARY KEY;
|