From a48266f78b43aa1569c6353eecbe2f90cb0bbd46 Mon Sep 17 00:00:00 2001
From: Mark Huang <mlhuang@cs.princeton.edu>
Date: Wed, 31 Jan 2007 19:55:12 +0000
Subject: [PATCH] - Remove NOT NULL constraint from creator_person_id in case
 the   creator is deleted.

---
 migrations/002-up-slices.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 migrations/002-up-slices.sql

diff --git a/migrations/002-up-slices.sql b/migrations/002-up-slices.sql
new file mode 100644
index 0000000..4bf656d
--- /dev/null
+++ b/migrations/002-up-slices.sql
@@ -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;
-- 
2.43.0