CMS / foldkit-cms-drizzle

sqliteSchema

const · packages/cms-drizzle/src/tables.ts:83

const sqliteSchema: '\ncreate table if not exists cms_entries (\n  id text primary key, type text not null, target_id text, label text not null,\n  created_by text, created_at text not null, archived_at text, revision integer\n);\ncreate table if not exists cms_drafts (\n  id text primary key, "values" text, model text, form text not null,\n  updated_at text not null, updated_by text, base_revision integer,\n  scheduled_for text, scheduled_by text, schedule_error text\n);\ncreate table if not exists cms_revisions (\n  id text primary key, entry_id text not null, n integer not null, "values" text,\n  published_at text not null, published_by text\n);\n'

The create table statements for SQLite, for a test or a first migration.