8 lines
No EOL
225 B
SQL
8 lines
No EOL
225 B
SQL
-- Add migration script here
|
|
CREATE TABLE posts(
|
|
id SERIAL PRIMARY KEY,
|
|
user_id INTEGER REFERENCES users(id) ON DELETE CASCADE,
|
|
title TEXT NOT NULL,
|
|
body TEXT NOT NULL,
|
|
created_at TIMESTAMP DEFAULT NOW()
|
|
) |