rename davolink table and collect queued and ok

[APKPM.git] / sql / davolink.sql

diff --git a/sql/davolink.sql b/sql/davolink.sql
new file mode 100644 (file)
index 0000000..8d619b5
--- /dev/null
+++ b/sql/davolink.sql
@@ -0,0 +1,20 @@
+create table davolink (
+ip inet not null,
+username text not null,
+timestamp timestamp default now(),
+SNRTX float,
+ATTNTX float,
+MAXTX integer,
+PWRTX float,
+PWRRX float,
+TX integer,
+RX integer,
+MAXRX integer,
+ATTNRX float,
+SNRRX float
+);
+
+-- columns used in where for gnuplot
+create index davolink_username on davolink(username);
+create index davolink_timestamp on davolink(timestamp) ;
+