aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2016-09-25 14:51:16 +1300
committerAnton Tananaev <anton.tananaev@gmail.com>2016-09-25 14:51:16 +1300
commit53bcb5c788e6b24bf8f6f631445b61a87c5f715f (patch)
treebffd421a1e538090ba868ff981635b1b5a01da65 /schema
parentd8dd2091c36099e5f2e5eeb00734cad54f342cbb (diff)
downloadtraccar-server-53bcb5c788e6b24bf8f6f631445b61a87c5f715f.tar.gz
traccar-server-53bcb5c788e6b24bf8f6f631445b61a87c5f715f.tar.bz2
traccar-server-53bcb5c788e6b24bf8f6f631445b61a87c5f715f.zip
Implement server statistics collection
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.8.xml27
1 files changed, 27 insertions, 0 deletions
diff --git a/schema/changelog-3.8.xml b/schema/changelog-3.8.xml
index 304ac21d4..deab6603c 100644
--- a/schema/changelog-3.8.xml
+++ b/schema/changelog-3.8.xml
@@ -39,5 +39,32 @@
<where>speedunit = 'kmh'</where>
</update>
+ <createTable tableName="statistics">
+ <column name="id" type="INT" autoIncrement="true">
+ <constraints primaryKey="true" />
+ </column>
+ <column name="capturetime" type="TIMESTAMP">
+ <constraints nullable="false" />
+ </column>
+ <column name="activeusers" type="INT" defaultValueNumeric="0">
+ <constraints nullable="false" />
+ </column>
+ <column name="activedevices" type="INT" defaultValueNumeric="0">
+ <constraints nullable="false" />
+ </column>
+ <column name="requests" type="INT" defaultValueNumeric="0">
+ <constraints nullable="false" />
+ </column>
+ <column name="messagesreceived" type="INT" defaultValueNumeric="0">
+ <constraints nullable="false" />
+ </column>
+ <column name="messagesstored" type="INT" defaultValueNumeric="0">
+ <constraints nullable="false" />
+ </column>
+ <column name="attributes" type="VARCHAR(4096)">
+ <constraints nullable="false" />
+ </column>
+ </createTable>
+
</changeSet>
</databaseChangeLog>