- Remove NOT NULL constraint from creator_person_id in case the
authorMark Huang <mlhuang@cs.princeton.edu>
Wed, 31 Jan 2007 19:55:12 +0000 (19:55 +0000)
committerMark Huang <mlhuang@cs.princeton.edu>
Wed, 31 Jan 2007 19:55:12 +0000 (19:55 +0000)
  creator is deleted.

migrations/002-up-slices.sql [new file with mode: 0644]

diff --git a/migrations/002-up-slices.sql b/migrations/002-up-slices.sql
new file mode 100644 (file)
index 0000000..4bf656d
--- /dev/null
@@ -0,0 +1,6 @@
+-- Remove NOT NULL constraint from creator_person_id in case the
+-- creator is deleted.
+ALTER TABLE slices ALTER creator_person_id DROP NOT NULL;
+
+-- Bump subversion
+UPDATE plc_db_version SET subversion = 2;