From f5b6dacb24e7694b60fb01ace87e90cc2bd7d91a Mon Sep 17 00:00:00 2001
From: Abyss777 <abyss@fox5.ru>
Date: Wed, 7 Jun 2017 08:39:53 +0500
Subject: Fix calendar.data type for postgresql

---
 schema/changelog-3.12.xml | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'schema')

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>
-- 
cgit v1.2.3