summaryrefslogtreecommitdiff
path: root/migrations/2020-02-03-225040_tasks/up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2020-02-03-225040_tasks/up.sql')
-rw-r--r--migrations/2020-02-03-225040_tasks/up.sql7
1 files changed, 7 insertions, 0 deletions
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
+);