aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2016-09-22 10:44:29 +0500
committerAbyss777 <abyss@fox5.ru>2016-09-22 10:44:29 +0500
commitc8816bdd85d62fb767795b2dc4d31326fdad9cd5 (patch)
treecc1422319766a1ffe0688642830e2bdd535314b4 /schema
parentbaad910016f2f17e6bf89f9d5db17349c4a9a62a (diff)
downloadtrackermap-server-c8816bdd85d62fb767795b2dc4d31326fdad9cd5.tar.gz
trackermap-server-c8816bdd85d62fb767795b2dc4d31326fdad9cd5.tar.bz2
trackermap-server-c8816bdd85d62fb767795b2dc4d31326fdad9cd5.zip
- rename table and unique constraint
- rename some functions - optimization and simplification
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.8.xml6
1 files changed, 3 insertions, 3 deletions
diff --git a/schema/changelog-3.8.xml b/schema/changelog-3.8.xml
index 8cb6c0e04..304ac21d4 100644
--- a/schema/changelog-3.8.xml
+++ b/schema/changelog-3.8.xml
@@ -8,7 +8,7 @@
<changeSet author="author" id="changelog-3.8">
- <createTable tableName="device_aliases">
+ <createTable tableName="attribute_aliases">
<column name="id" type="INT" autoIncrement="true">
<constraints primaryKey="true" />
</column>
@@ -23,8 +23,8 @@
</column>
</createTable>
- <addForeignKeyConstraint baseTableName="device_aliases" baseColumnNames="deviceid" constraintName="fk_device_aliases_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
- <addUniqueConstraint tableName="device_aliases" columnNames="deviceid, attribute" constraintName="un_deviceid_attribute" />
+ <addForeignKeyConstraint baseTableName="attribute_aliases" baseColumnNames="deviceid" constraintName="fk_attribute_aliases_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
+ <addUniqueConstraint tableName="attribute_aliases" columnNames="deviceid, attribute" constraintName="uk_deviceid_attribute" />
<update tableName="users">
<column name="map" type="VARCHAR(128)"/>