diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2016-09-27 10:15:01 +1300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-09-27 10:15:01 +1300 |
| commit | 18499577b16a198762609075ff1846f354d3d712 (patch) | |
| tree | 0d33302e1193724405099e1108ba04cad552a95e /schema | |
| parent | aaec58aec04256845dc37afd713b488071b1406b (diff) | |
| parent | ccd4a65a4954bcd7d2c38b806440bb766c51b0e2 (diff) | |
| download | traccar-server-18499577b16a198762609075ff1846f354d3d712.tar.gz traccar-server-18499577b16a198762609075ff1846f354d3d712.tar.bz2 traccar-server-18499577b16a198762609075ff1846f354d3d712.zip | |
Merge pull request #2367 from tananaev/implement_statistics
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> |