summaryrefslogtreecommitdiff
path: root/migrations/2020-02-04-105747_raw_data/up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2020-02-04-105747_raw_data/up.sql')
-rw-r--r--migrations/2020-02-04-105747_raw_data/up.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/migrations/2020-02-04-105747_raw_data/up.sql b/migrations/2020-02-04-105747_raw_data/up.sql
new file mode 100644
index 0000000..386ba84
--- /dev/null
+++ b/migrations/2020-02-04-105747_raw_data/up.sql
@@ -0,0 +1,8 @@
+create table raw_data(
+ data_type varchar(8) not null,
+ id bigint not null,
+ username varchar not null references users(username),
+ payload jsonb,
+
+ primary key(data_type, id)
+);