Add raw data to database

2 files changed, 8 insertions, 0 deletions

diff --git a/migrations/2020-02-03-225040_tasks/down.sql b/migrations/2020-02-03-225040_tasks/down.sql
new file mode 100644
index 0000000..4827072
--- /dev/null
+++ b/migrations/2020-02-03-225040_tasks/down.sql
@@ -0,0 +1 @@
+drop table tasks;
diff --git a/migrations/2020-02-03-225040_tasks/up.sql b/migrations/2020-02-03-225040_tasks/up.sql
new file mode 100644
index 0000000..faebc0a
--- /dev/null
+++ b/migrations/2020-02-03-225040_tasks/up.sql
@@ -0,0 +1,7 @@
+create table tasks (
+  id bigserial not null primary key,
+  state varchar(8) not null,
+  start_at timestamptz not null,
+  username varchar not null references users(username),
+  payload jsonb not null
+);