t7c0Ejim

1CREATE TABLE IF NOT EXISTS "meta" (
2  "k" text NOT NULL,
3  "v" text NOT NULL,
4  PRIMARY KEY ("k")
5);
6
7CREATE TABLE IF NOT EXISTS "license" (
8  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
9  "name" text NOT NULL,
10  FOREIGN KEY ("id") REFERENCES "book" ("id")
11);
12
13CREATE TABLE IF NOT EXISTS "author" (
14  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
15  "name" text NOT NULL,
16  "firstname" text NOT NULL,
17  "lastname" text NOT NULL,
18  "info" text NOT NULL,
19  "olid" text NOT NULL,
20  "wikipedia_url" text NOT NULL
21);
22
23CREATE TABLE IF NOT EXISTS "book" (
24  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
25  "name" text NOT NULL,
26  "author_name" text NOT NULL,
27  "author_id" integer NOT NULL,
28  "category_id" integer NOT NULL,
29  "license_id" integer NOT NULL,
30  "short_info" text NOT NULL,
31  "long_info" text NOT NULL DEFAULT '',
32  "isbn" text NOT NULL,
33  "olid" text NOT NULL,
34  "wikipedia_url" text NOT NULL,
35  "download_url" text NOT NULL,
36  "mirror_url" text NOT NULL,
37  "source_url" text NOT NULL,
38  FOREIGN KEY ("license_id") REFERENCES "license" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
39  FOREIGN KEY ("author_id") REFERENCES "author" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
40);