diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2016-03-03 11:10:25 +1300 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2016-03-03 11:10:25 +1300 |
| commit | dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76 (patch) | |
| tree | 5ed14dd95d483ff889059a4a3cdb57cab1200cda | |
| parent | 07412baa3500a8ff4086adb0edf03c9bd2a69310 (diff) | |
| download | traccar-server-dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76.tar.gz traccar-server-dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76.tar.bz2 traccar-server-dbe7c3ff97d127bdff4aae21a65ed1e5106c4d76.zip | |
Make column names lowercase (fix #1674)
| -rw-r--r-- | database/changelog-3.3.xml | 50 |
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> |