002-todos.sql « migrations « postgrest - postgrest-demo.git - Example system with PostgREST, JWTs, an authentication/authorization microservice (Node.js) with Google auth support, PostgreSQL db and a small frontend

about summary refs log tree commit diff stats

path: root/postgrest/migrations/002-todos.sql

blob: 5efb477a1166717dae69f80716db8c074de2b7d6 (plain)

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');