aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.7-notmssql.xml6
-rw-r--r--schema/changelog-3.7.xml8
2 files changed, 7 insertions, 7 deletions
diff --git a/schema/changelog-3.7-notmssql.xml b/schema/changelog-3.7-notmssql.xml
index a22703073..2478c4628 100644
--- a/schema/changelog-3.7-notmssql.xml
+++ b/schema/changelog-3.7-notmssql.xml
@@ -9,9 +9,9 @@
<changeSet author="author" id="changelog-3.7-notmssql">
<preConditions onFail="CONTINUE">
- <not>
- <dbms type="mssql" />
- </not>
+ <not>
+ <dbms type="mssql" />
+ </not>
</preConditions>
<addForeignKeyConstraint baseColumnNames="groupid" baseTableName="groups" constraintName="fk_group_group_groupid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="groups"/>
diff --git a/schema/changelog-3.7.xml b/schema/changelog-3.7.xml
index f6e2c713d..8e1af75d0 100644
--- a/schema/changelog-3.7.xml
+++ b/schema/changelog-3.7.xml
@@ -9,15 +9,15 @@
<changeSet author="author" id="changelog-3.7">
<update tableName="devices">
- <column name="groupid"/>
- <where>groupid NOT IN (SELECT id FROM groups)</where>
+ <column name="groupid"/>
+ <where>groupid NOT IN (SELECT id FROM groups)</where>
</update>
<addForeignKeyConstraint baseColumnNames="groupid" baseTableName="devices" constraintName="fk_device_group_groupid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="groups"/>
<update tableName="groups">
- <column name="groupid"/>
- <where>groupid NOT IN (SELECT id FROM (SELECT id FROM groups) AS groups_1)</where>
+ <column name="groupid"/>
+ <where>groupid NOT IN (SELECT id FROM (SELECT id FROM groups) AS groups_1)</where>
</update>
</changeSet>