20260413175956_chief_energizer.ts · part 1

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

File contents and all parts · All files

        CREATE TABLE `session_entry` (
          `id` text PRIMARY KEY,
          `session_id` text NOT NULL,
          `type` text NOT NULL,
          `time_created` integer NOT NULL,
          `time_updated` integer NOT NULL,
          `data` text NOT NULL,
          CONSTRAINT `fk_session_entry_session_id_session_id_fk` FOREIGN KEY (`session_id`) REFERENCES `session`(`id`) ON DELETE CASCADE
        );
      

CREATE INDEX `session_entry_session_idx` ON `session_entry` (`session_id`);

CREATE INDEX `session_entry_session_type_idx` ON `session_entry` (`session_id`,`type`);

CREATE INDEX `session_entry_time_created_idx` ON `session_entry` (`time_created`);