diff options
Diffstat (limited to 'postgrest/migrations/002-todos.sql')
| -rw-r--r-- | postgrest/migrations/002-todos.sql | 9 |
1 files changed, 9 insertions, 0 deletions
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'); |
