blob: 9f5bcf3675807b18686491f8ec93d30faa32a7a5 (
plain)
1
2
3
4
5
6
7
8
9
|
BEGIN;
ALTER TABLE patchwork_bundle_patches RENAME TO patchwork_bundlepatch;
ALTER TABLE patchwork_bundlepatch ADD COLUMN "order" INTEGER NULL;
UPDATE patchwork_bundlepatch SET "order" =
(SELECT COALESCE(max("order"), 0) + 1 FROM patchwork_bundlepatch AS p2
WHERE p2.bundle_id = patchwork_bundlepatch.bundle_id);
ALTER TABLE patchwork_bundlepatch ALTER COLUMN "order" SET NOT NULL;
ALTER TABLE patchwork_bundlepatch ADD UNIQUE("bundle_id", "order");
COMMIT;
|
