blog_posts.sql

CREATE TABLE posts(
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(256) NOT NULL,
body TEXT NOT NULL,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL
);

INSERT INTO posts(
title, body, created_at, updated_at
) VALUES(
'test title',
'test body',
NOW(),
NOW()
);