1 files changed, 10 insertions, 0 deletions
diff --git a/www/wiki/maintenance/mssql/archives/patch-rev_text_id-default.sql b/www/wiki/maintenance/mssql/archives/patch-rev_text_id-default.sql
new file mode 100644
index 00000000..0c9d48a3
--- /dev/null
+++ b/www/wiki/maintenance/mssql/archives/patch-rev_text_id-default.sql
@@ -0,0 +1,10 @@
+--
+-- Adds a default value to the rev_text_id field in the revision table.
+-- This is to allow the Multi Content Revisions migration to happen where
+-- rows will have to be added to the revision table with no rev_text_id.
+--
+-- 2018-03-12
+--
+
+ALTER TABLE /*_*/revision
+  ADD CONSTRAINT DF_rev_text_id DEFAULT 0 FOR rev_text_id;
+\ No newline at end of file