diff options
| author | Jan Tuomi <jan.tuomi@eficode.com> | 2020-04-26 15:48:24 +0300 |
|---|---|---|
| committer | Jan Tuomi <jan.tuomi@eficode.com> | 2020-04-26 15:48:24 +0300 |
| commit | 55f725a502011155f0943f2340ef3763f014ccc0 (patch) | |
| tree | c1915fd2c3f67e93b3fd406d018583bc6b050baa /postgrest/migrations/002-todos.sql | |
Initial commit
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'); |