aboutsummaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
Diffstat (limited to '')
-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
+);