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.