rename tables and functions to make them consistant

[APKPM.git] / sql / dslam_poll.sql

diff --git a/sql/dslam_poll.sql b/sql/dslam_poll.sql
new file mode 100644 (file)
index 0000000..fd4fa63
--- /dev/null
+++ b/sql/dslam_poll.sql
@@ -0,0 +1,17 @@
+create table dslam_poll (
+       variant text not null,
+       start timestamp not null,
+       finish timestamp not null,
+       -- grep '$variant.$ip.' persistant_worker.pl | cut -d\" -f2
+       logout int,
+       error   int,
+       empty   int,
+       ok      int,
+       invalid int,
+       queued  int,
+       complete int,
+       failed  int
+);
+
+create index dslam_poll_variant on dslam_poll(variant);
+create index dslam_poll_start on dslam_poll(start);