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

diff --git a/sql/dslam.sql b/sql/dslam.sql
new file mode 100644
index 0000000..6561548
--- /dev/null
+++ b/sql/dslam.sql
@@ -0,0 +1,13 @@
+create table dslam (
+ip inet not null,
+username text not null,
+timestamp timestamp default now(),
+variant text not null,
+h hstore
+);
+
+-- columns used in where for gnuplot
+create index dslam_username on dslam(username);
+create index dslam_timestamp on dslam(timestamp) ;
+create index dslam_variant on dslam(variant) ;
+