From dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Thu, 3 Mar 2016 11:10:25 +1300
Subject: Make column names lowercase (fix #1674)

---
 database/changelog-3.3.xml | 50 +++++++++++++++++++++++-----------------------
 1 file changed, 25 insertions(+), 25 deletions(-)

diff --git a/database/changelog-3.3.xml b/database/changelog-3.3.xml
index 25b359401..1893a0200 100644
--- a/database/changelog-3.3.xml
+++ b/database/changelog-3.3.xml
@@ -23,7 +23,7 @@
       <column name="email" type="VARCHAR(128)">
         <constraints nullable="false" />
       </column>
-      <column name="hashedPassword" type="VARCHAR(128)">
+      <column name="hashedpassword" type="VARCHAR(128)">
         <constraints nullable="false" />
       </column>
       <column name="salt" type="VARCHAR(128)">
@@ -41,10 +41,10 @@
       <column name="language" type="VARCHAR(128)" defaultValue="en">
         <constraints nullable="false" />
       </column>
-      <column name="distanceUnit" type="VARCHAR(128)" defaultValue="km">
+      <column name="distanceunit" type="VARCHAR(128)" defaultValue="km">
         <constraints nullable="false" />
       </column>
-      <column name="speedUnit" type="VARCHAR(128)" defaultValue="kmh">
+      <column name="speedunit" type="VARCHAR(128)" defaultValue="kmh">
         <constraints nullable="false" />
       </column>
       <column name="latitude" type="DOUBLE" defaultValueNumeric="0">
@@ -67,30 +67,30 @@
       <column name="name" type="VARCHAR(128)">
         <constraints nullable="false" />
       </column>
-      <column name="uniqueId" type="VARCHAR(128)">
+      <column name="uniqueid" type="VARCHAR(128)">
         <constraints nullable="false" />
       </column>
       <column name="status" type="VARCHAR(128)" />
-      <column name="lastUpdate" type="TIMESTAMP" />
-      <column name="positionId" type="INT" />
+      <column name="lastupdate" type="TIMESTAMP" />
+      <column name="positionid" type="INT" />
     </createTable>
 
-    <addUniqueConstraint tableName="devices" columnNames="uniqueId" constraintName="uk_device_uniqueId" />
+    <addUniqueConstraint tableName="devices" columnNames="uniqueid" constraintName="uk_device_uniqueid" />
 
     <createTable tableName="user_device">
-      <column name="userId" type="INT">
+      <column name="userid" type="INT">
         <constraints nullable="false" />
       </column>
-      <column name="deviceId" type="INT">
+      <column name="deviceid" type="INT">
         <constraints nullable="false" />
       </column>
     </createTable>
 
-    <addForeignKeyConstraint baseTableName="user_device" baseColumnNames="userId" constraintName="fk_user_device_userId" referencedTableName="users" referencedColumnNames="id" onDelete="CASCADE" />
-    <addForeignKeyConstraint baseTableName="user_device" baseColumnNames="deviceId" constraintName="fk_user_device_deviceId" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
+    <addForeignKeyConstraint baseTableName="user_device" baseColumnNames="userid" constraintName="fk_user_device_userid" referencedTableName="users" referencedColumnNames="id" onDelete="CASCADE" />
+    <addForeignKeyConstraint baseTableName="user_device" baseColumnNames="deviceid" constraintName="fk_user_device_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
 
     <createIndex tableName="user_device" indexName="user_device_user_id">
-      <column name="userId" />
+      <column name="userid" />
     </createIndex>
 
     <createTable tableName="positions">
@@ -98,16 +98,16 @@
         <constraints primaryKey="true" />
       </column>
       <column name="protocol" type="VARCHAR(128)" />
-      <column name="deviceId" type="int">
+      <column name="deviceid" type="int">
         <constraints nullable="false" />
       </column>
-      <column name="serverTime" type="TIMESTAMP">
+      <column name="servertime" type="TIMESTAMP">
         <constraints nullable="false" />
       </column>
-      <column name="deviceTime" type="TIMESTAMP">
+      <column name="devicetime" type="TIMESTAMP">
         <constraints nullable="false" />
       </column>
-      <column name="fixTime" type="TIMESTAMP">
+      <column name="fixtime" type="TIMESTAMP">
         <constraints nullable="false" />
       </column>
       <column name="valid" type="BOOLEAN">
@@ -134,11 +134,11 @@
       </column>
     </createTable>
 
-    <addForeignKeyConstraint baseTableName="positions" baseColumnNames="deviceId" constraintName="fk_position_deviceId" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
+    <addForeignKeyConstraint baseTableName="positions" baseColumnNames="deviceid" constraintName="fk_position_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
 
-    <createIndex tableName="positions" indexName="position_deviceId_fixTime">
-      <column name="deviceId" />
-      <column name="fixTime" />
+    <createIndex tableName="positions" indexName="position_deviceid_fixtime">
+      <column name="deviceid" />
+      <column name="fixtime" />
     </createIndex>
 
     <createTable tableName="server">
@@ -159,10 +159,10 @@
       </column>
       <column name="map" type="VARCHAR(128)" />
       <column name="language" type="VARCHAR(128)" />
-      <column name="distanceUnit" type="VARCHAR(128)" />
-      <column name="speedUnit" type="VARCHAR(128)" />
-      <column name="bingKey" type="VARCHAR(128)" />
-      <column name="mapUrl" type="VARCHAR(128)" />
+      <column name="distanceunit" type="VARCHAR(128)" />
+      <column name="speedunit" type="VARCHAR(128)" />
+      <column name="bingkey" type="VARCHAR(128)" />
+      <column name="mapurl" type="VARCHAR(128)" />
       <column name="readonly" type="BOOLEAN" defaultValueBoolean="false">
         <constraints nullable="false" />
       </column>
@@ -178,7 +178,7 @@
     <insert tableName="users">
       <column name="name" value="admin" />
       <column name="email" value="admin" />
-      <column name="hashedPassword" value="D33DCA55ABD4CC5BC76F2BC0B4E603FE2C6F61F4C1EF2D47" />
+      <column name="hashedpassword" value="D33DCA55ABD4CC5BC76F2BC0B4E603FE2C6F61F4C1EF2D47" />
       <column name="salt" value="000000000000000000000000000000000000000000000000" />
       <column name="admin" valueBoolean="true" />
     </insert>
-- 
cgit v1.2.3