20260603141458_session_input_inbox.ts · part 1

2 text occurrences from packages/core/src/database/migration/20260603141458_session_input_inbox.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_input` (
          `seq` integer PRIMARY KEY AUTOINCREMENT,
          `id` text NOT NULL UNIQUE,
          `session_id` text NOT NULL,
          `prompt` text NOT NULL,
          `delivery` text NOT NULL,
          `promoted_seq` integer,
          `time_created` integer NOT NULL,
          CONSTRAINT `fk_session_input_session_id_session_id_fk` FOREIGN KEY (`session_id`) REFERENCES `session`(`id`) ON DELETE CASCADE
        );
      

CREATE INDEX `session_input_session_pending_seq_idx` ON `session_input` (`session_id`,`promoted_seq`,`seq`);