aboutsummaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorMaZderMind2014-12-22 13:30:42 +0100
committerMaZderMind2014-12-22 13:30:42 +0100
commit2040e49f949396aa79fb84ed9e025e4de5571ed6 (patch)
tree2f11c7af5741cff1e410ea25d821986692056b8c /lib
parent095e23686087b311636a3394fe207e50ca41fc04 (diff)
standalone feedback page & intrinsic save mechanism
Diffstat (limited to 'lib')
-rw-r--r--lib/schema.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/lib/schema.sql b/lib/schema.sql
new file mode 100644
index 0000000..f187326
--- /dev/null
+++ b/lib/schema.sql
@@ -0,0 +1,14 @@
+DROP TABLE IF EXISTS feedback;
+CREATE TABLE feedback (
+ reported NUMERIC,
+ datetime NUMERIC,
+ net TEXT,
+ os TEXT,
+ player TEXT,
+ stream TEXT,
+ ipproto_v4 NUMERIC,
+ ipproto_v6 NUMERIC,
+ provider TEXT,
+ issues TEXT,
+ issuetext TEXT
+);