-- editor: squashed from 1100_editor_containers.sql. -- Editor "Run in container" sessions: one row per container start, closed with its billed minutes. CREATE TABLE editor_container_sessions ( id TEXT PRIMARY KEY, account_id TEXT NOT NULL REFERENCES accounts(id) ON DELETE CASCADE, repo_id TEXT NOT NULL REFERENCES repos(id) ON DELETE CASCADE, branch TEXT NOT NULL, instance_type TEXT NOT NULL, started_at INTEGER NOT NULL, stopped_at INTEGER, minutes INTEGER, stop_reason TEXT ); CREATE INDEX editor_container_sessions_account ON editor_container_sessions(account_id, started_at); CREATE INDEX editor_container_sessions_open ON editor_container_sessions(stopped_at) WHERE stopped_at IS NULL;