Plume/migrations/postgres/2018-04-23-101717_create_blogs/up.sql

11 lines
310 B
MySQL
Raw Permalink Normal View History

2018-04-23 12:29:27 +02:00
-- Your SQL goes here
CREATE TABLE blogs (
id SERIAL PRIMARY KEY,
actor_id VARCHAR NOT NULL,
title VARCHAR NOT NULL,
summary TEXT NOT NULL DEFAULT '',
outbox_url VARCHAR NOT NULL,
inbox_url VARCHAR NOT NULL,
instance_id INTEGER REFERENCES instances(id) ON DELETE CASCADE NOT NULL
)