export declare const SCHEMA_VERSION = 4;
export declare const CATALOG_CONTENT_TYPES: readonly ["page", "article", "pageVariant", "template", "articleType", "tagType", "tag", "navigation", "navigationItem"];
export type CatalogContentType = (typeof CATALOG_CONTENT_TYPES)[number];
/** @deprecated Use {@link CATALOG_CONTENT_TYPES}. */
export declare const REFERENCE_CONTENT_TYPES: readonly ["page", "article", "pageVariant", "template", "articleType", "tagType", "tag", "navigation", "navigationItem"];
/** @deprecated Use {@link CatalogContentType}. */
export type ReferenceContentType = CatalogContentType;
export declare function isCatalogContentType(type: string): type is CatalogContentType;
/** @deprecated Use {@link isCatalogContentType}. */
export declare function isReferenceContentType(type: string): type is ReferenceContentType;
export declare const TABLE_DDL = "\nCREATE TABLE IF NOT EXISTS meta (\n  key TEXT PRIMARY KEY,\n  value TEXT NOT NULL\n);\n\nCREATE TABLE IF NOT EXISTS assets (\n  id TEXT PRIMARY KEY,\n  fileName TEXT NOT NULL,\n  title TEXT NOT NULL,\n  description TEXT,\n  contentType TEXT NOT NULL,\n  url TEXT NOT NULL,\n  width INTEGER,\n  height INTEGER,\n  size INTEGER,\n  updatedAt TEXT NOT NULL\n);\n\nCREATE TABLE IF NOT EXISTS media (\n  id TEXT PRIMARY KEY,\n  name TEXT NOT NULL,\n  assetId TEXT NOT NULL,\n  assetFileName TEXT NOT NULL,\n  updatedAt TEXT NOT NULL\n);\n\nCREATE TABLE IF NOT EXISTS reference_entries (\n  id TEXT PRIMARY KEY,\n  contentType TEXT NOT NULL,\n  slug TEXT,\n  label TEXT NOT NULL,\n  cmsLabel TEXT,\n  updatedAt TEXT NOT NULL,\n  tagTypeSlug TEXT,\n  articleTypeSlug TEXT,\n  date TEXT\n);\n";
/** Indexes on columns present in schema v1/v2 (safe before v3 column migration). */
export declare const BASE_INDEX_DDL = "\nCREATE INDEX IF NOT EXISTS idx_assets_fileName ON assets(fileName);\nCREATE INDEX IF NOT EXISTS idx_assets_title ON assets(title);\nCREATE INDEX IF NOT EXISTS idx_media_assetId ON media(assetId);\nCREATE INDEX IF NOT EXISTS idx_media_assetFileName ON media(assetFileName);\nCREATE INDEX IF NOT EXISTS idx_ref_type_slug ON reference_entries(contentType, slug);\nCREATE INDEX IF NOT EXISTS idx_ref_type_label ON reference_entries(contentType, label);\n";
/** Indexes on schema v3 catalog columns — applied after migrateReferenceEntriesTable. */
export declare const REFERENCE_V3_INDEX_DDL = "\nCREATE INDEX IF NOT EXISTS idx_ref_type_cms_label ON reference_entries(contentType, cmsLabel);\nCREATE INDEX IF NOT EXISTS idx_ref_tag_type_slug ON reference_entries(contentType, tagTypeSlug);\nCREATE INDEX IF NOT EXISTS idx_ref_article_type_slug ON reference_entries(contentType, articleTypeSlug);\n";
/** Indexes on schema v4 article date column — applied after migrateReferenceEntriesTable. */
export declare const REFERENCE_V4_INDEX_DDL = "\nCREATE INDEX IF NOT EXISTS idx_ref_article_date ON reference_entries(contentType, date);\n";
export declare const DDL = "\nCREATE TABLE IF NOT EXISTS meta (\n  key TEXT PRIMARY KEY,\n  value TEXT NOT NULL\n);\n\nCREATE TABLE IF NOT EXISTS assets (\n  id TEXT PRIMARY KEY,\n  fileName TEXT NOT NULL,\n  title TEXT NOT NULL,\n  description TEXT,\n  contentType TEXT NOT NULL,\n  url TEXT NOT NULL,\n  width INTEGER,\n  height INTEGER,\n  size INTEGER,\n  updatedAt TEXT NOT NULL\n);\n\nCREATE TABLE IF NOT EXISTS media (\n  id TEXT PRIMARY KEY,\n  name TEXT NOT NULL,\n  assetId TEXT NOT NULL,\n  assetFileName TEXT NOT NULL,\n  updatedAt TEXT NOT NULL\n);\n\nCREATE TABLE IF NOT EXISTS reference_entries (\n  id TEXT PRIMARY KEY,\n  contentType TEXT NOT NULL,\n  slug TEXT,\n  label TEXT NOT NULL,\n  cmsLabel TEXT,\n  updatedAt TEXT NOT NULL,\n  tagTypeSlug TEXT,\n  articleTypeSlug TEXT,\n  date TEXT\n);\n\nCREATE INDEX IF NOT EXISTS idx_assets_fileName ON assets(fileName);\nCREATE INDEX IF NOT EXISTS idx_assets_title ON assets(title);\nCREATE INDEX IF NOT EXISTS idx_media_assetId ON media(assetId);\nCREATE INDEX IF NOT EXISTS idx_media_assetFileName ON media(assetFileName);\nCREATE INDEX IF NOT EXISTS idx_ref_type_slug ON reference_entries(contentType, slug);\nCREATE INDEX IF NOT EXISTS idx_ref_type_label ON reference_entries(contentType, label);\n\nCREATE INDEX IF NOT EXISTS idx_ref_type_cms_label ON reference_entries(contentType, cmsLabel);\nCREATE INDEX IF NOT EXISTS idx_ref_tag_type_slug ON reference_entries(contentType, tagTypeSlug);\nCREATE INDEX IF NOT EXISTS idx_ref_article_type_slug ON reference_entries(contentType, articleTypeSlug);\n\nCREATE INDEX IF NOT EXISTS idx_ref_article_date ON reference_entries(contentType, date);\n";
//# sourceMappingURL=schema.d.ts.map