diff options
| author | Abyss777 <abyss@fox5.ru> | 2017-06-07 08:39:53 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2017-06-07 08:39:53 +0500 |
| commit | f5b6dacb24e7694b60fb01ace87e90cc2bd7d91a (patch) | |
| tree | e74d5f088e352125377918cc35e29398f4264270 | |
| parent | 0d5b1440503ee50127554e0664b0ae7cbf9a25fd (diff) | |
| download | traccar-server-f5b6dacb24e7694b60fb01ace87e90cc2bd7d91a.tar.gz traccar-server-f5b6dacb24e7694b60fb01ace87e90cc2bd7d91a.tar.bz2 traccar-server-f5b6dacb24e7694b60fb01ace87e90cc2bd7d91a.zip | |
Fix calendar.data type for postgresql
| -rw-r--r-- | schema/changelog-3.12.xml | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/schema/changelog-3.12.xml b/schema/changelog-3.12.xml index 850287606..efd978532 100644 --- a/schema/changelog-3.12.xml +++ b/schema/changelog-3.12.xml @@ -108,4 +108,19 @@ </changeSet> + <changeSet author="author" id="changelog-3.12-pgsql"> + + <preConditions onFail="MARK_RAN"> + <dbms type="postgresql" /> + <sqlCheck expectedResult="oid">SELECT data_type FROM information_schema.columns WHERE table_name = 'calendars' AND column_name = 'data';</sqlCheck> + </preConditions> + <dropColumn tableName="calendars" columnName="data" /> + <addColumn tableName="calendars"> + <column name="data" type="bytea"> + <constraints nullable="false" /> + </column> + </addColumn> + + </changeSet> + </databaseChangeLog> |