M2 Github Issue 19597 Patches

Fix-setup-db-status-issue.patch

# Module: cms-staging
From 92b3db5210eb6730d22d6cd3bca2c3d9fb87d46a Mon Sep 17 00:00:00 2001
From: Chris Huffman <chris.huffman@classyllama.com>
Date: Fri, 17 Jan 2020 10:52:04 -0600
Subject: [PATCH] Fix setup:db:status issue

---
 etc/db_schema.xml | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/etc/db_schema.xml b/etc/db_schema.xml
index ee87119..bb01036 100644
--- a/etc/db_schema.xml
+++ b/etc/db_schema.xml
@@ -46,6 +46,9 @@
         <constraint xsi:type="foreign" referenceId="CMS_PAGE_PAGE_ID_SEQUENCE_CMS_PAGE_SEQUENCE_VALUE" table="cms_page"
                     column="page_id" referenceTable="sequence_cms_page" referenceColumn="sequence_value"
                     onDelete="CASCADE"/>
+        <constraint xsi:type="foreign" referenceId="FK_12C2962523CC7EF2EA73AD4121B5DBFF" table="cms_page"
+                    column="page_id" referenceTable="sequence_cms_page" referenceColumn="sequence_value"
+                    onDelete="CASCADE"/>
         <index referenceId="CMS_PAGE_CREATED_IN" indexType="btree">
             <column name="created_in"/>
         </index>
-- 
2.15.1



# Module: reminder
From 67c76d68581724b1fc7bb1904f5b1bb9625a520c Mon Sep 17 00:00:00 2001
From: Chris Huffman <chris.huffman@classyllama.com>
Date: Fri, 17 Jan 2020 10:54:07 -0600
Subject: [PATCH] Fix setup:db:status issue

---
 etc/db_schema.xml | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/etc/db_schema.xml b/etc/db_schema.xml
index 794ad73..9a63cfd 100644
--- a/etc/db_schema.xml
+++ b/etc/db_schema.xml
@@ -31,6 +31,9 @@
         <constraint xsi:type="foreign" referenceId="MAGENTO_REMINDER_RULE_SALESRULE_ID_SALESRULE_RULE_ID"
                     table="magento_reminder_rule" column="salesrule_id" referenceTable="salesrule"
                     referenceColumn="rule_id" onDelete="SET NULL"/>
+        <constraint xsi:type="foreign" referenceId="FK_81ACD87B0CB5AB8CC9B8D0B05F30FBB8"
+                    table="magento_reminder_rule" column="salesrule_id" referenceTable="sequence_salesrule"
+                    referenceColumn="sequence_value" onDelete="SET NULL"/>
         <index referenceId="MAGENTO_REMINDER_RULE_SALESRULE_ID" indexType="btree">
             <column name="salesrule_id"/>
         </index>
--
2.15.1


#Module: versions-cms
From 152ea510d7155f98b1e9ff7b889c94f73e77fdfd Mon Sep 17 00:00:00 2001
From: Chris Huffman <chris.huffman@classyllama.com>
Date: Fri, 17 Jan 2020 10:56:09 -0600
Subject: [PATCH] Fix setup:db:status

---
 etc/db_schema.xml | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/etc/db_schema.xml b/etc/db_schema.xml
index 58d13c7..083c327 100644
--- a/etc/db_schema.xml
+++ b/etc/db_schema.xml
@@ -60,6 +60,9 @@
             <column name="scope"/>
             <column name="scope_id"/>
         </constraint>
+        <constraint xsi:type="foreign" referenceId="FK_12C2962523CC7EF2EA73AD4121B5DBFF"
+                    table="magento_versionscms_hierarchy_node" column="page_id"
+                    referenceTable="sequence_cms_page" referenceColumn="sequence_value" onDelete="CASCADE"/>
         <index referenceId="MAGENTO_VERSIONSCMS_HIERARCHY_NODE_PARENT_NODE_ID" indexType="btree">
             <column name="parent_node_id"/>
         </index>
--
2.15.1


#See also this patch: https://gist.github.com/erikhansen/41bbc22d501fecb36892d49b41c204d3