From 53bcb5c788e6b24bf8f6f631445b61a87c5f715f Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton.tananaev@gmail.com>
Date: Sun, 25 Sep 2016 14:51:16 +1300
Subject: Implement server statistics collection

---
 schema/changelog-3.8.xml | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

(limited to 'schema')

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>
-- 
cgit v1.2.3