Skip to content

Modern Docker Management, Designed for Everyone

581 B
Raw Blame
-- +goose Up
-- Add api_key_id column to environments table for API key-based pairing
ALTER TABLE environments ADD COLUMN api_key_id TEXT REFERENCES api_keys(id) ON DELETE SET NULL;

-- Add environment_id column to api_keys table to link API keys to environments
ALTER TABLE api_keys ADD COLUMN environment_id TEXT REFERENCES environments(id) ON DELETE CASCADE;

-- +goose Down
-- Remove environment_id column from api_keys table
ALTER TABLE api_keys DROP COLUMN environment_id;

-- Remove api_key_id column from environments table
ALTER TABLE environments DROP COLUMN api_key_id;