aboutsummaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2016-03-03 11:10:25 +1300
committerAnton Tananaev <anton.tananaev@gmail.com>2016-03-03 11:10:25 +1300
commitdbe7c3ff97d127bdff4aae21a65ed1e5106c4d76 (patch)
tree5ed14dd95d483ff889059a4a3cdb57cab1200cda /database
parent07412baa3500a8ff4086adb0edf03c9bd2a69310 (diff)
downloadtrackermap-server-dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76.tar.gz
trackermap-server-dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76.tar.bz2
trackermap-server-dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76.zip
Make column names lowercase (fix #1674)
Diffstat (limited to 'database')
-rw-r--r--database/changelog-3.3.xml50
1 files 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>