20260602182828_add_project_directories.ts · part 1

1 text occurrences from packages/core/src/database/migration/20260602182828_add_project_directories.ts, part 1. Every entry preserves the shipped literal and its saved verdict or selection reason.

File contents and all parts · All files

Shipped text

CREATE TABLE project directory ( project id text NOT NULL, directory text

Source: packages/core/src/database/migration/20260602182828_add_project_directories.ts, characters 220–682, SHA-256 f453eea51126a9da.

Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.

Readable text: CREATE TABLE 'project_directory' ( 'project_id' text NOT NULL, 'directory' text NOT NULL, 'type' text NOT NULL, 'time_created' integer NOT NULL, CONSTRAINT 'project_directory_pk' PR…


        CREATE TABLE `project_directory` (
          `project_id` text NOT NULL,
          `directory` text NOT NULL,
          `type` text NOT NULL,
          `time_created` integer NOT NULL,
          CONSTRAINT `project_directory_pk` PRIMARY KEY(`project_id`, `directory`),
          CONSTRAINT `fk_project_directory_project_id_project_id_fk` FOREIGN KEY (`project_id`) REFERENCES `project`(`id`) ON DELETE CASCADE
        );