PageRenderTime 7ms CodeModel.GetById 1ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

/samples/blog/blog_schema.sql

http://github.com/keplerproject/orbit
SQL | 20 lines | 18 code | 2 blank | 0 comment | 0 complexity | db296e57675bdb575f98cc5627e482c6 MD5 | raw file
 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);