/** * Project-scope `cleo.db` — consolidated **provenance / commits** domain. * * Part of the consolidated PROJECT-scope `cleo.db` target shape authored for * SG-DB-SUBSTRATE-V2 (saga T11242, epic T11245/E2, task T11360). Target-shape * authoring only — physical names carry the `tasks_` domain prefix (provenance * is a satellite of the project-tier tasks-core cluster per the canonical * `targetTable` map). The live runtime module * `schema/provenance/commits.ts` keeps its UNPREFIXED physical names * (`commits` / `task_commits` / `commit_files`) until the exodus migration * (T11248) deploys this shape; the migration-baseline test depends on the live * names, so they must not change in-place. * * This module is the canonical demonstration of the E10 §3b boolean * non-conformer transform within T11360's slice: * * - `commits.is_release_commit` INTEGER 0/1 → integer({ mode: 'boolean' }) * - `commits.is_merge_commit` INTEGER 0/1 → integer({ mode: 'boolean' }) * - `commit_files.is_binary` INTEGER 0/1 → integer({ mode: 'boolean' }) * * The matching SQL `CHECK (col IN (0,1))` ships as raw DDL in the exodus * migration (drizzle-orm sqlite-core surfaces no typed per-column CHECK DSL in * rc.3); the `{ mode: 'boolean' }` builder guarantees the application only ever * writes 0/1, so the row type narrows to `boolean`. * * ## E10 enum-like bare-TEXT transform (§5b) * * Four §5b enum-like bare-TEXT non-conformers gain `{ enum }` narrowing from * the named const arrays already declared in the live module (referenced by * identifier, never hand-typed literals — §5a): * * - `commits.conventional_type` → { enum: COMMIT_CONVENTIONAL_TYPES } * - `task_commits.link_kind` → { enum: COMMIT_LINK_KINDS } * - `task_commits.link_source` → { enum: COMMIT_LINK_SOURCES } * - `commit_files.change_type` → { enum: COMMIT_FILE_CHANGE_TYPES } * * ## E10 timestamps (§4) * * All timestamp columns are already the canonical TEXT ISO8601 form * (`authored_at`, `committed_at`, `created_at`); none were epoch non-conformers. * * @task T11360 * @epic T11245 * @saga T11242 * @see docs/migration/sqlite-schema-canonical.md §1 (D1″) · §3b · §5 · §4 * @see docs/migration/sqlite-schema-columns.json (per-column affinity SSoT) */ /** * `tasks_commits` — domain-prefixed target of the legacy `commits` table. * * @task T11360 (target shape) · T9506 (original) */ export declare const tasksCommits: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "tasks_commits"; schema: undefined; columns: { sha: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; shortSha: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; authorName: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; authorEmail: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; authoredAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; committerName: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; committerEmail: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; committedAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; message: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; subject: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; conventionalType: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string enum"; data: "fix" | "docs" | "refactor" | "feat" | "chore" | "test" | "build" | "ci" | "perf" | "revert" | "breaking"; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: ["feat", "fix", "chore", "docs", "refactor", "test", "build", "ci", "perf", "revert", "breaking"]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; isReleaseCommit: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "boolean"; data: boolean; driverParam: number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; isMergeCommit: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "boolean"; data: boolean; driverParam: number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; parentShas: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; signatureVerified: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "number int53"; data: number; driverParam: number; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; branchAtCommit: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; projectHash: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; createdAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** * `tasks_task_commits` — M:N junction between tasks and commits. * * Domain-prefixed target of the legacy `task_commits` table. `task_id` is a * cross-table FK into `tasks_tasks` resolved by the exodus prefixer; carried * here as a plain TEXT id. `commit_sha` references the in-module * {@link tasksCommits}. * * @task T11360 (target shape) · T9506 (original) */ export declare const tasksTaskCommits: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "tasks_task_commits"; schema: undefined; columns: { taskId: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_task_commits"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; commitSha: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_task_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; linkKind: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_task_commits"; dataType: "string enum"; data: "implements" | "docs" | "fixes" | "refactors" | "tests" | "reverts"; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: ["implements", "fixes", "refactors", "tests", "docs", "reverts"]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; linkSource: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_task_commits"; dataType: "string enum"; data: "manual" | "commit-trailer" | "commit-subject" | "pr-title" | "pr-body" | "branch-name"; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: ["commit-trailer", "commit-subject", "pr-title", "pr-body", "branch-name", "manual"]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; createdAt: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_task_commits"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** * `tasks_commit_files` — per-file × SHA materialization (blast-radius enabler). * * Domain-prefixed target of the legacy `commit_files` table. * * @task T11360 (target shape) · T9506 (original) */ export declare const tasksCommitFiles: import("drizzle-orm/sqlite-core").SQLiteTableWithColumns<{ name: "tasks_commit_files"; schema: undefined; columns: { commitSha: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commit_files"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; path: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commit_files"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; oldPath: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commit_files"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; changeType: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commit_files"; dataType: "string enum"; data: "A" | "M" | "D" | "R" | "C"; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: ["A", "M", "D", "R", "C"]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; linesAdded: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commit_files"; dataType: "number int53"; data: number; driverParam: number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; linesDeleted: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commit_files"; dataType: "number int53"; data: number; driverParam: number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; isBinary: import("drizzle-orm/sqlite-core").SQLiteColumn<{ name: string; tableName: "tasks_commit_files"; dataType: "boolean"; data: boolean; driverParam: number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; baseColumn: never; identity: undefined; generated: undefined; }, {}>; }; dialect: "sqlite"; }>; /** Row type for `tasks_commits` SELECT queries (target shape). */ export type TasksCommitRow = typeof tasksCommits.$inferSelect; /** Row type for `tasks_commits` INSERT operations (target shape). */ export type NewTasksCommitRow = typeof tasksCommits.$inferInsert; /** Row type for `tasks_task_commits` SELECT queries (target shape). */ export type TasksTaskCommitRow = typeof tasksTaskCommits.$inferSelect; /** Row type for `tasks_task_commits` INSERT operations (target shape). */ export type NewTasksTaskCommitRow = typeof tasksTaskCommits.$inferInsert; /** Row type for `tasks_commit_files` SELECT queries (target shape). */ export type TasksCommitFileRow = typeof tasksCommitFiles.$inferSelect; /** Row type for `tasks_commit_files` INSERT operations (target shape). */ export type NewTasksCommitFileRow = typeof tasksCommitFiles.$inferInsert; //# sourceMappingURL=provenance-commits.d.ts.map