20260612174303_project_dir_strategy.ts · part 1
Full reference7 text occurrences from packages/core/src/database/migration/20260612174303_project_dir_strategy.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
ALTER TABLE project directory ADD strategy text;
Source: packages/core/src/database/migration/20260612174303_project_dir_strategy.ts, characters 217–275, SHA-256 ab64396237bb5682.
Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.
Readable text: ALTER TABLE 'project_directory' ADD 'strategy' text;
ALTER TABLE `project_directory` ADD `strategy` text;
PRAGMA foreign keys=OFF;
Source: packages/core/src/database/migration/20260612174303_project_dir_strategy.ts, characters 297–323, SHA-256 762021db779c6635.
Jev judged not model-facing (confidence 0.03; role code_data). This is a classifier judgment, not proof of delivery.
Readable text: PRAGMA foreign_keys=OFF;
PRAGMA foreign_keys=OFF;
CREATE TABLE new project directory ( project id text NOT NULL, directory
Source: packages/core/src/database/migration/20260612174303_project_dir_strategy.ts, characters 345–833, SHA-256 f30e2db05ffb0758.
Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.
Readable text: CREATE TABLE '__new_project_directory' ( 'project_id' text NOT NULL, 'directory' text NOT NULL, 'type' text, 'strategy' text, 'time_created' integer NOT NULL, CONSTRAINT '…
CREATE TABLE `__new_project_directory` (
`project_id` text NOT NULL,
`directory` text NOT NULL,
`type` text,
`strategy` text,
`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
);
INSERT INTO new project directory ( project id , directory , type , time c
Source: packages/core/src/database/migration/20260612174303_project_dir_strategy.ts, characters 864–1057, SHA-256 637b49632bedf393.
Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.
Readable text: INSERT INTO '__new_project_directory'('project_id', 'directory', 'type', 'time_created') SELECT 'project_id', 'directory', 'type', 'time_created' FROM 'project_directory';
INSERT INTO `__new_project_directory`(`project_id`, `directory`, `type`, `time_created`) SELECT `project_id`, `directory`, `type`, `time_created` FROM `project_directory`;
DROP TABLE project directory ;
Source: packages/core/src/database/migration/20260612174303_project_dir_strategy.ts, characters 1087–1122, SHA-256 c00682ec5ffefaa2.
Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.
Readable text: DROP TABLE 'project_directory';
DROP TABLE `project_directory`;
ALTER TABLE new project directory RENAME TO project directory ;
Source: packages/core/src/database/migration/20260612174303_project_dir_strategy.ts, characters 1144–1218, SHA-256 3cce0f183c97e715.
Jev judged not model-facing (confidence 0.02; role code_data). This is a classifier judgment, not proof of delivery.
Readable text: ALTER TABLE '__new_project_directory' RENAME TO 'project_directory';
ALTER TABLE `__new_project_directory` RENAME TO `project_directory`;
PRAGMA foreign keys=ON;
Source: packages/core/src/database/migration/20260612174303_project_dir_strategy.ts, characters 1240–1265, SHA-256 b5263dc6f4507df7.
Jev judged not model-facing (confidence 0.03; role code_data). This is a classifier judgment, not proof of delivery.
Readable text: PRAGMA foreign_keys=ON;
PRAGMA foreign_keys=ON;