1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE TABLE blog_post
("id" INTEGER PRIMARY KEY NOT NULL,
"title" VARCHAR(255) DEFAULT NULL,
"body" TEXT DEFAULT NULL,
"n_comments" INTEGER DEFAULT NULL,
"published_at" DATETIME DEFAULT NULL);
CREATE TABLE blog_comment
("id" INTEGER PRIMARY KEY NOT NULL,
"post_id" INTEGER DEFAULT NULL,
"author" VARCHAR(255) DEFAULT NULL,
"email" VARCHAR(255) DEFAULT NULL,
"url" VARCHAR(255) DEFAULT NULL,
"body" TEXT DEFAULT NULL,
"created_at" DATETIME DEFAULT NULL);
CREATE TABLE blog_page
("id" INTEGER PRIMARY KEY NOT NULL,
"title" VARCHAR(30) DEFAULT NULL,
"body" TEXT DEFAULT NULL);
|
