-- An organisation's storage policy (oxygenhub#96): whether every new

-- repository must live in a bucket, and the store URL prefixes allowed.

CREATE TABLE org_storage_policy (

    org_id         INTEGER PRIMARY KEY REFERENCES organisations(id) ON DELETE CASCADE,

    require_bucket INTEGER NOT NULL DEFAULT 0,

    -- One store URL prefix per line; empty allows any bucket.

    allowed        TEXT NOT NULL DEFAULT ''

);