summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorYaakov M. Nemoy <loupgaroublond@gmail.com>2008-07-22 17:07:50 (GMT)
committerYaakov M. Nemoy <loupgaroublond@gmail.com>2008-07-22 17:07:50 (GMT)
commit11f1e90f2eee1591b8c6df3c5aa73739e0c59a81 (patch)
treefa6b2339c2b5f9e08e5ca758b39ba4109b4f0f20
parentd04969aa24bc497d1706f32cf20d65fac8733682 (diff)
downloadfas-11f1e90f2eee1591b8c6df3c5aa73739e0c59a81.zip
fas-11f1e90f2eee1591b8c6df3c5aa73739e0c59a81.tar.gz
fas-11f1e90f2eee1591b8c6df3c5aa73739e0c59a81.tar.xz
Sets default to False before setting to non null, preventing DB errors.
-rw-r--r--database/versions/4/4.postgres.upgrade.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/database/versions/4/4.postgres.upgrade.sql b/database/versions/4/4.postgres.upgrade.sql
index de4e1a0..7acc674 100644
--- a/database/versions/4/4.postgres.upgrade.sql
+++ b/database/versions/4/4.postgres.upgrade.sql
@@ -1,3 +1,3 @@
-ALTER TABLE people ALTER COLUMN privacy SET NOT NULL;
ALTER TABLE people ALTER COLUMN privacy SET DEFAULT FALSE;
+ALTER TABLE people ALTER COLUMN privacy SET NOT NULL;