From b51526fdb177d3641e2780d5485586b487850874 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton@traccar.org>
Date: Sun, 11 Sep 2022 17:44:49 -0700
Subject: Fix column name

---
 schema/changelog-5.2.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema')

diff --git a/schema/changelog-5.2.xml b/schema/changelog-5.2.xml
index 1ac9eedc5..687024f52 100644
--- a/schema/changelog-5.2.xml
+++ b/schema/changelog-5.2.xml
@@ -13,7 +13,7 @@
     </addColumn>
 
     <addColumn tableName="tc_devices">
-      <column name="geofenceIds" type="VARCHAR(128)" />
+      <column name="geofenceids" type="VARCHAR(128)" />
     </addColumn>
 
   </changeSet>
-- 
cgit v1.2.3


From 30e04d7209561b7ebf6055a9170794ab9496c357 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton@traccar.org>
Date: Tue, 13 Sep 2022 06:50:44 -0700
Subject: Fix PostgreSQL blob (fix #4947)

---
 schema/changelog-5.3.xml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'schema')

diff --git a/schema/changelog-5.3.xml b/schema/changelog-5.3.xml
index 2021fe6c7..1e5a6005a 100644
--- a/schema/changelog-5.3.xml
+++ b/schema/changelog-5.3.xml
@@ -24,10 +24,10 @@
       <column autoIncrement="true" name="id" type="INT">
         <constraints primaryKey="true" />
       </column>
-      <column name="publickey" type="BLOB">
+      <column name="publickey" type="MEDIUMBLOB">
         <constraints nullable="false" />
       </column>
-      <column name="privatekey" type="BLOB">
+      <column name="privatekey" type="MEDIUMBLOB">
         <constraints nullable="false" />
       </column>
     </createTable>
-- 
cgit v1.2.3