diff options
| author | Jeremy Kerr <jk@ozlabs.org> | 2011-09-19 09:42:44 +0800 |
|---|---|---|
| committer | Jeremy Kerr <jk@ozlabs.org> | 2011-09-19 09:42:44 +0800 |
| commit | 75d8cf966034e673afe0077ba393d8b2eb3e9b93 (patch) | |
| tree | 3f6cf6b9f87ad313d23de77b4c33422e7444a1df /lib/sql/migration/008-confirmations.sql | |
| parent | 539b6596dc1bf1d3118631095625e354026da373 (diff) | |
| parent | f1e5f6a2c9d737f12290f5bd5a934b74c362616f (diff) | |
| download | patchwork-75d8cf966034e673afe0077ba393d8b2eb3e9b93.tar.bz2 patchwork-75d8cf966034e673afe0077ba393d8b2eb3e9b93.tar.xz | |
Merge branch 'notifications'
Diffstat (limited to 'lib/sql/migration/008-confirmations.sql')
| -rw-r--r-- | lib/sql/migration/008-confirmations.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/lib/sql/migration/008-confirmations.sql b/lib/sql/migration/008-confirmations.sql new file mode 100644 index 0000000..89437a2 --- /dev/null +++ b/lib/sql/migration/008-confirmations.sql @@ -0,0 +1,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; |