blob: e0db398e1ee3add1e2f3fb896a1bd7a8ab6a94ac (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
BEGIN;
ALTER TABLE patchwork_bundle_patches RENAME TO patchwork_bundlepatch;
CREATE SEQUENCE bundlepatch_tmp_seq;
ALTER TABLE patchwork_bundlepatch
ADD COLUMN "order" INTEGER NOT NULL
DEFAULT nextval('bundlepatch_tmp_seq');
ALTER TABLE patchwork_bundlepatch ALTER COLUMN "order" DROP DEFAULT;
DROP SEQUENCE bundlepatch_tmp_seq;
ALTER TABLE patchwork_bundlepatch ADD UNIQUE("bundle_id", "order");
COMMIT;
|
