migrations/0003_create_authorisations_table.up.sql at develop

Mirror for https://github.com/STBoyden/go-portfolio

go-portfolio / migrations / 0003_create_authorisations_table.up.sql

at develop 4 lines 156 B view raw

wrap content

stboyden.com feat: add middlewares for authorisation and logging; add relevant migrations and queries for sqlc 11 months ago

e182bad4

1CREATE TABLE IF NOT EXISTS "authorisations" (
2  "id" uuid UNIQUE PRIMARY KEY NOT NULL,
3  "expiry" timestamp NOT NULL DEFAULT (now() + interval '2 hour')
4);