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 | trackermap-server-f5b6dacb24e7694b60fb01ace87e90cc2bd7d91a.tar.gz trackermap-server-f5b6dacb24e7694b60fb01ace87e90cc2bd7d91a.tar.bz2 trackermap-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> |