PostText/migrations/1/up.sql

10 lines
297 B
MySQL
Raw Permalink Normal View History

2022-07-29 22:15:14 -04:00
CREATE TABLE IF NOT EXISTS threads (
thread_id SERIAL PRIMARY KEY,
2022-09-03 01:19:34 -04:00
thread_date TIMESTAMPTZ DEFAULT NOW(),
2022-07-29 22:15:14 -04:00
thread_author VARCHAR(64),
thread_title VARCHAR(256),
thread_body VARCHAR(4096),
hidden_status BOOLEAN NOT NULL,
flagged_status BOOLEAN NOT NULL
);