From 33f46f13f06f9a543556eb1c5ecd100f2876719c Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Sat, 19 Dec 2015 10:34:33 +1300
Subject: Fix more contraints and default values

---
 database/db.changelog-3.2.xml | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'database')

diff --git a/database/db.changelog-3.2.xml b/database/db.changelog-3.2.xml
index 750e91dc8..a1fc19b06 100644
--- a/database/db.changelog-3.2.xml
+++ b/database/db.changelog-3.2.xml
@@ -32,7 +32,9 @@
     <dropNotNullConstraint tableName="position" columnName="longitude" columnDataType="FLOAT" />
     <modifyDataType tableName="position" columnName="longitude" newDataType="DOUBLE" />
     <addNotNullConstraint tableName="position" columnName="longitude" columnDataType="DOUBLE" />
+    <dropNotNullConstraint tableName="position" columnName="other" columnDataType="VARCHAR(4096)" />
     <renameColumn tableName="position" oldColumnName="other" newColumnName="attributes" columnDataType="VARCHAR(4096)" />
+    <addNotNullConstraint tableName="position" columnName="attributes" columnDataType="VARCHAR(4096)" />
 
     <dropTable tableName="data" />
 
@@ -45,9 +47,11 @@
     <dropNotNullConstraint tableName="server" columnName="latitude" columnDataType="FLOAT" />
     <modifyDataType tableName="server" columnName="latitude" newDataType="DOUBLE" />
     <addNotNullConstraint tableName="server" columnName="latitude" columnDataType="DOUBLE" />
+    <addDefaultValue tableName="server" columnName="latitude" defaultValueNumeric="0" />
     <dropNotNullConstraint tableName="server" columnName="longitude" columnDataType="FLOAT" />
     <modifyDataType tableName="server" columnName="longitude" newDataType="DOUBLE" />
     <addNotNullConstraint tableName="server" columnName="longitude" columnDataType="DOUBLE" />
+    <addDefaultValue tableName="server" columnName="longitude" defaultValueNumeric="0" />
 
     <update tableName="traccar">
       <column name="version" valueNumeric="302" />
-- 
cgit v1.2.3