aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/2017-10-01-193613_create_posts/up.sql
blob: c0c36e5cc5db07ffd27a3d71be03078f38b66240 (plain) (blame)
1
2
3
4
5
6
7
-- Create posts table
CREATE TABLE posts (
  id SERIAL PRIMARY KEY,
  title VARCHAR NOT NULL,
  body TEXT NOT NULL,
  published BOOLEAN NOT NULL DEFAULT 'f'
)