aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2016-10-17 12:08:04 +1300
committerAnton Tananaev <anton.tananaev@gmail.com>2016-10-17 12:08:45 +1300
commit83ca0476167d91f16f18ae3cc532d56cd97f743e (patch)
tree61d5fdd1a1b1061bc2ccf7d00122456c9754b62c /schema
parentb857d08adc3336630b5e471f89ea0bf0e952cf18 (diff)
downloadtraccar-server-83ca0476167d91f16f18ae3cc532d56cd97f743e.tar.gz
traccar-server-83ca0476167d91f16f18ae3cc532d56cd97f743e.tar.bz2
traccar-server-83ca0476167d91f16f18ae3cc532d56cd97f743e.zip
Change attributes column length
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.8.xml15
1 files changed, 14 insertions, 1 deletions
diff --git a/schema/changelog-3.8.xml b/schema/changelog-3.8.xml
index be9df5410..7a2b1e4e0 100644
--- a/schema/changelog-3.8.xml
+++ b/schema/changelog-3.8.xml
@@ -61,7 +61,7 @@
<column name="messagesstored" type="INT" defaultValueNumeric="0">
<constraints nullable="false" />
</column>
- <column name="attributes" type="VARCHAR(4096)">
+ <column name="attributes" type="VARCHAR(4000)">
<constraints nullable="false" />
</column>
</createTable>
@@ -81,5 +81,18 @@
<column name="coordinateformat" type="VARCHAR(128)" />
</addColumn>
+ <dropNotNullConstraint tableName="positions" columnName="attributes" columnDataType="VARCHAR(4096)" />
+ <modifyDataType tableName="positions" columnName="attributes" newDataType="VARCHAR(4000)" />
+ <dropNotNullConstraint tableName="events" columnName="attributes" columnDataType="VARCHAR(4096)" />
+ <modifyDataType tableName="events" columnName="attributes" newDataType="VARCHAR(4000)" />
+ <dropNotNullConstraint tableName="geofences" columnName="attributes" columnDataType="VARCHAR(4096)" />
+ <modifyDataType tableName="geofences" columnName="attributes" newDataType="VARCHAR(4000)" />
+ <dropNotNullConstraint tableName="notifications" columnName="attributes" columnDataType="VARCHAR(4096)" />
+ <modifyDataType tableName="notifications" columnName="attributes" newDataType="VARCHAR(4000)" />
+ <modifyDataType tableName="users" columnName="attributes" newDataType="VARCHAR(4000)" />
+ <modifyDataType tableName="devices" columnName="attributes" newDataType="VARCHAR(4000)" />
+ <modifyDataType tableName="groups" columnName="attributes" newDataType="VARCHAR(4000)" />
+ <modifyDataType tableName="server" columnName="attributes" newDataType="VARCHAR(4000)" />
+
</changeSet>
</databaseChangeLog>