deploy/tags.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

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

BEGIN;

SET search_path to diary;

CREATE TABLE tags(
  tag_id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
  name VARCHAR UNIQUE NOT NULL
);

COMMIT;