blob: 89437a24c8bf19024f8aa58ed4441244f88a61ae (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
BEGIN;
ALTER TABLE "patchwork_userpersonconfirmation"
RENAME TO "patchwork_emailconfirmation";
ALTER SEQUENCE "patchwork_userpersonconfirmation_id_seq"
RENAME TO "patchwork_emailconfirmation_id_seq";
ALTER TABLE "patchwork_emailconfirmation"
ALTER COLUMN "user_id" DROP NOT NULL,
ADD COLUMN "type" varchar(20) NOT NULL DEFAULT 'userperson';
ALTER TABLE "patchwork_emailconfirmation"
ALTER COLUMN "type" DROP DEFAULT;
COMMIT;
|