diff options
Diffstat (limited to 'lib/sql/migration/008-confirmations.sql')
-rw-r--r-- | lib/sql/migration/008-confirmations.sql | 11 |
1 files changed, 0 insertions, 11 deletions
diff --git a/lib/sql/migration/008-confirmations.sql b/lib/sql/migration/008-confirmations.sql deleted file mode 100644 index 89437a2..0000000 --- a/lib/sql/migration/008-confirmations.sql +++ /dev/null @@ -1,11 +0,0 @@ -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; |