deploy/articles.sql


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

-- Deploy kakeibo:articles to pg
-- requires: appschema

BEGIN;

CREATE TABLE kakeibo.articles (
  id SERIAL PRIMARY KEY,
  location TEXT UNIQUE,
  title TEXT,
  created_at TIMESTAMP NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);

COMMIT;