X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=sql%2Fdslam_poll.sql;fp=sql%2Fdslam_poll.sql;h=fd4fa637658a51e61d102ff43196781eb18a34de;hb=93b042750d2b467c18608b056437fc3a120ee3ec;hp=0000000000000000000000000000000000000000;hpb=1252f5b8ebd4c4adbbfb9713ce5dda6782c20f23;p=APKPM.git

diff --git a/sql/dslam_poll.sql b/sql/dslam_poll.sql
new file mode 100644
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);