Merge from trunk

[plcapi.git] / trunk / migrations / 002-up-slices.sql

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