CREATE TABLE "accounts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "join_code" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "custom_styles" text)
CREATE TABLE "action_text_markdowns" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "record_type" varchar NOT NULL, "record_id" integer NOT NULL, "name" varchar NOT NULL, "content" text DEFAULT '' NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
CREATE TABLE "active_storage_blobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "filename" varchar NOT NULL, "content_type" varchar, "metadata" text, "service_name" varchar NOT NULL, "byte_size" bigint NOT NULL, "checksum" varchar, "created_at" datetime(6) NOT NULL)
CREATE TABLE "books" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "subtitle" varchar, "author" varchar, "published" boolean DEFAULT 0 NOT NULL, "slug" varchar NOT NULL, "everyone_access" boolean DEFAULT 1 NOT NULL, "theme" varchar DEFAULT 'blue' NOT NULL)
CREATE TABLE "pages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
CREATE TABLE "pictures" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "caption" varchar)
CREATE TABLE "sections" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "theme" varchar, "body" text)
CREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "email_address" varchar NOT NULL, "password_digest" varchar NOT NULL, "role" integer NOT NULL, "active" boolean DEFAULT 1, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
CREATE TABLE "accesses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "book_id" integer NOT NULL, "level" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_a453fa1dab"
FOREIGN KEY ("book_id")
REFERENCES "books" ("id")
, CONSTRAINT "fk_rails_e47574ce84"
FOREIGN KEY ("user_id")
REFERENCES "users" ("id")
)
CREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, "slug" varchar, CONSTRAINT "fk_rails_c3b3935057"
FOREIGN KEY ("blob_id")
REFERENCES "active_storage_blobs" ("id")
)
CREATE TABLE "active_storage_variant_records" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "blob_id" bigint NOT NULL, "variation_digest" varchar NOT NULL, CONSTRAINT "fk_rails_993965df05"
FOREIGN KEY ("blob_id")
REFERENCES "active_storage_blobs" ("id")
)
CREATE TABLE "edits" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "leaf_id" integer NOT NULL, "leafable_type" varchar NOT NULL, "leafable_id" integer NOT NULL, "action" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_855918d132"
FOREIGN KEY ("leaf_id")
REFERENCES "leaves" ("id")
)
CREATE TABLE "leaves" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "book_id" integer NOT NULL, "leafable_type" varchar NOT NULL, "leafable_id" integer NOT NULL, "position_score" float NOT NULL, "status" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "title" varchar NOT NULL, CONSTRAINT "fk_rails_3bb84105c0"
FOREIGN KEY ("book_id")
REFERENCES "books" ("id")
)
CREATE TABLE "sessions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "token" varchar NOT NULL, "ip_address" varchar, "user_agent" varchar, "last_active_at" datetime(6) NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_758836b4f0"
FOREIGN KEY ("user_id")
REFERENCES "users" ("id")
)
CREATE VIRTUAL TABLE leaf_search_index USING fts5 (title, content, tokenize='porter')
CREATE TABLE 'leaf_search_index_data'(id INTEGER PRIMARY KEY, block BLOB)
CREATE TABLE 'leaf_search_index_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID
CREATE TABLE 'leaf_search_index_content'(id INTEGER PRIMARY KEY, c0, c1)
CREATE TABLE 'leaf_search_index_docsize'(id INTEGER PRIMARY KEY, sz BLOB)
CREATE TABLE 'leaf_search_index_config'(k PRIMARY KEY, v) WITHOUT ROWID
CREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)
CREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)