diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2016-09-25 14:51:16 +1300 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2016-09-25 14:51:16 +1300 |
| commit | 53bcb5c788e6b24bf8f6f631445b61a87c5f715f (patch) | |
| tree | bffd421a1e538090ba868ff981635b1b5a01da65 /schema | |
| parent | d8dd2091c36099e5f2e5eeb00734cad54f342cbb (diff) | |
| download | traccar-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.xml | 27 |
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> |