tak nějak

knihovna.sql

CREATE TABLE IF NOT EXISTS "meta" (
  "k" text NOT NULL,
  "v" text NOT NULL,
  PRIMARY KEY ("k")
);

CREATE TABLE IF NOT EXISTS "license" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name" text NOT NULL,
  FOREIGN KEY ("id") REFERENCES "book" ("id")
);

CREATE TABLE IF NOT EXISTS "author" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name" text NOT NULL,
  "firstname" text NOT NULL,
  "lastname" text NOT NULL,
  "info" text NOT NULL,
  "olid" text NOT NULL,
  "wikipedia_url" text NOT NULL
);

CREATE TABLE IF NOT EXISTS "book" (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name" text NOT NULL,
  "author_name" text NOT NULL,
  "author_id" integer NOT NULL,
  "category_id" integer NOT NULL,
  "license_id" integer NOT NULL,
  "short_info" text NOT NULL,
  "long_info" text NOT NULL DEFAULT '',
  "isbn" text NOT NULL,
  "olid" text NOT NULL,
  "wikipedia_url" text NOT NULL,
  "download_url" text NOT NULL,
  "mirror_url" text NOT NULL,
  "source_url" text NOT NULL,
  FOREIGN KEY ("license_id") REFERENCES "license" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION,
  FOREIGN KEY ("author_id") REFERENCES "author" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION
);