-- Deploy diary:tags to pg
-- requires: schema

BEGIN;

SET search_path to diary;

CREATE TABLE tags(
  id UUID PRIMARY KEY,
  name TEXT UNIQUE NOT NULL,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

COMMIT;
