blob: ab284a57322c1c8ad4744752b9b3b593be6e66b7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE IF NOT EXISTS statuses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
contents TEXT,
posted_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE IF NOT EXISTS comments (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
contents TEXT NOT NULL,
posted_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
|
