git.ozlabs.org Git - patchwork/blob - lib/sql/migration/008-confirmations.sql

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