aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2016-09-21 16:27:55 +0500
committerAbyss777 <abyss@fox5.ru>2016-09-21 16:27:55 +0500
commitbaad910016f2f17e6bf89f9d5db17349c4a9a62a (patch)
tree559c919ea736013ff758d5145082bf9fa65751ac /schema
parent9ee812366367148387f289b9977fd809e6a56786 (diff)
downloadtrackermap-server-baad910016f2f17e6bf89f9d5db17349c4a9a62a.tar.gz
trackermap-server-baad910016f2f17e6bf89f9d5db17349c4a9a62a.tar.bz2
trackermap-server-baad910016f2f17e6bf89f9d5db17349c4a9a62a.zip
Add attributes aliases
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.8.xml18
1 files changed, 18 insertions, 0 deletions
diff --git a/schema/changelog-3.8.xml b/schema/changelog-3.8.xml
index 97bc1c9a3..8cb6c0e04 100644
--- a/schema/changelog-3.8.xml
+++ b/schema/changelog-3.8.xml
@@ -8,6 +8,24 @@
<changeSet author="author" id="changelog-3.8">
+ <createTable tableName="device_aliases">
+ <column name="id" type="INT" autoIncrement="true">
+ <constraints primaryKey="true" />
+ </column>
+ <column name="deviceid" type="INT">
+ <constraints nullable="false" />
+ </column>
+ <column name="attribute" type="VARCHAR(128)">
+ <constraints nullable="false" />
+ </column>
+ <column name="alias" type="VARCHAR(128)">
+ <constraints nullable="false" />
+ </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" />
+
<update tableName="users">
<column name="map" type="VARCHAR(128)"/>
<where>map = 'osm'</where>