export declare const PAGES_SCHEMA: readonly ["CREATE TABLE IF NOT EXISTS documents (\n    uuid TEXT PRIMARY KEY,\n    document TEXT NOT NULL DEFAULT 'page',\n    template TEXT NOT NULL DEFAULT 'page.default',\n    title TEXT NOT NULL,\n    status TEXT NOT NULL CHECK (status IN ('draft','published','archived')),\n    draft_slug TEXT NOT NULL,\n    published_slug TEXT,\n    draft_content TEXT NOT NULL DEFAULT '{}',\n    published_content TEXT,\n    published_version_id TEXT,\n    created_at TEXT NOT NULL,\n    updated_at TEXT NOT NULL,\n    published_at TEXT\n  )", "CREATE UNIQUE INDEX IF NOT EXISTS documents_draft_slug_uq ON documents(draft_slug)", "CREATE UNIQUE INDEX IF NOT EXISTS documents_published_slug_uq ON documents(published_slug) WHERE published_slug IS NOT NULL", "CREATE INDEX IF NOT EXISTS documents_status_idx ON documents(status)", "CREATE TABLE IF NOT EXISTS document_versions (\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\n    document_uuid TEXT NOT NULL,\n    version_id TEXT NOT NULL,\n    kind TEXT NOT NULL CHECK (kind IN ('draft-save','publish')),\n    snapshot_json TEXT NOT NULL,\n    created_at TEXT NOT NULL,\n    created_by TEXT,\n    UNIQUE(document_uuid, version_id),\n    FOREIGN KEY(document_uuid) REFERENCES documents(uuid) ON DELETE CASCADE\n  )", "CREATE INDEX IF NOT EXISTS document_versions_doc_idx ON document_versions(document_uuid)", "CREATE INDEX IF NOT EXISTS document_versions_doc_created_idx ON document_versions(document_uuid, created_at DESC)", "CREATE TABLE IF NOT EXISTS routes (\n    locale TEXT NOT NULL,\n    page_uuid TEXT NOT NULL,\n    slug TEXT NOT NULL,\n    parent_uuid TEXT,\n    is_published INTEGER NOT NULL DEFAULT 0,\n    PRIMARY KEY(locale, page_uuid),\n    FOREIGN KEY(page_uuid) REFERENCES documents(uuid) ON DELETE CASCADE\n  )", "CREATE UNIQUE INDEX IF NOT EXISTS routes_locale_slug_parent_uq ON routes(locale, slug, COALESCE(parent_uuid, 'root'))", "CREATE TABLE IF NOT EXISTS navigations (\n    locale TEXT NOT NULL,\n    key TEXT NOT NULL,\n    name TEXT NOT NULL,\n    data_json TEXT NOT NULL DEFAULT '{}',\n    updated_at TEXT NOT NULL,\n    PRIMARY KEY(locale, key)\n  )", "CREATE TABLE IF NOT EXISTS workspaces (\n    scope TEXT NOT NULL,\n    key TEXT NOT NULL,\n    name TEXT NOT NULL,\n    data_json TEXT NOT NULL DEFAULT '{}',\n    updated_at TEXT NOT NULL,\n    PRIMARY KEY(scope, key)\n  )"];