lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README | LICENSE

0001_publish_workflows.up.sql (569B)

      1 CREATE TABLE IF NOT EXISTS signer_publish_workflow (
      2   workflow_id TEXT PRIMARY KEY,
      3   connection_id TEXT NOT NULL REFERENCES signer_connection (connection_id) ON DELETE CASCADE,
      4   kind TEXT NOT NULL,
      5   state TEXT NOT NULL,
      6   pending_request_json TEXT,
      7   authorized_at_unix INTEGER,
      8   created_at_unix INTEGER NOT NULL,
      9   updated_at_unix INTEGER NOT NULL
     10 );
     11 
     12 CREATE INDEX IF NOT EXISTS signer_publish_workflow_connection_id_idx
     13 ON signer_publish_workflow (connection_id);
     14 
     15 CREATE INDEX IF NOT EXISTS signer_publish_workflow_state_idx
     16 ON signer_publish_workflow (state);