20260602002951_lowly_union_jack.ts · part 1

2 text occurrences from packages/core/src/database/migration/20260602002951_lowly_union_jack.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 `permission` (
          `id` text PRIMARY KEY,
          `project_id` text NOT NULL,
          `action` text NOT NULL,
          `resource` text NOT NULL,
          `time_created` integer NOT NULL,
          `time_updated` integer NOT NULL,
          CONSTRAINT `fk_permission_project_id_project_id_fk` FOREIGN KEY (`project_id`) REFERENCES `project`(`id`) ON DELETE CASCADE
        );
      

CREATE UNIQUE INDEX `permission_project_action_resource_idx` ON `permission` (`project_id`,`action`,`resource`);