9 lines
195 B
MySQL
9 lines
195 B
MySQL
|
-- Your SQL goes here
|
||
|
|
CREATE TABLE posts (
|
||
|
|
id INTEGER PRIMARY KEY,
|
||
|
|
title VARCHAR NOT NULL,
|
||
|
|
body TEXT NOT NULL,
|
||
|
|
published BOOLEAN NOT NULL DEFAULT 'f',
|
||
|
|
publish_date TIMESTAMP NOT NULL
|
||
|
|
)
|