/samples/blog/blog_schema.sql

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