summaryrefslogtreecommitdiffstats
path: root/lib/sql/migration/008-confirmations.sql
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;