From 55f725a502011155f0943f2340ef3763f014ccc0 Mon Sep 17 00:00:00 2001
From: Jan Tuomi <jan.tuomi@eficode.com>
Date: Sun, 26 Apr 2020 15:48:24 +0300
Subject: Initial commit

---
 postgrest/migrations/002-todos.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 postgrest/migrations/002-todos.sql

(limited to 'postgrest/migrations/002-todos.sql')

diff --git a/postgrest/migrations/002-todos.sql b/postgrest/migrations/002-todos.sql
new file mode 100644
index 0000000..5efb477
--- /dev/null
+++ b/postgrest/migrations/002-todos.sql
@@ -0,0 +1,9 @@
+create table api.todos (
+  id serial primary key,
+  done boolean not null default false,
+  task text not null,
+  due timestamptz
+);
+
+-- insert into api.todos (task) values
+--   ('finish tutorial 0'), ('pat self on back');
-- 
cgit v1.3