rename tables and functions to make them consistant

[APKPM.git] / sql / dslam.sql

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