X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=migrations%2F002-up-slices.sql;fp=migrations%2F002-up-slices.sql;h=4bf656db3b0c55cfa16f17a1a95d980c692288ee;hb=a48266f78b43aa1569c6353eecbe2f90cb0bbd46;hp=0000000000000000000000000000000000000000;hpb=a8026bd981fbc99e44b74f1b3780805f21e23da2;p=plcapi.git

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;