20 lines
925 B
MySQL
20 lines
925 B
MySQL
|
-- Migration 062: Mimecast multi-tenant credentials
|
||
|
|
-- Stores per-client Mimecast API credentials for held mail and other per-tenant queries
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS mimecast_tenants (
|
||
|
|
id SERIAL PRIMARY KEY,
|
||
|
|
company_id BIGINT REFERENCES companies(id) ON DELETE SET NULL,
|
||
|
|
account_code VARCHAR(50),
|
||
|
|
account_name VARCHAR(255),
|
||
|
|
client_id VARCHAR(255) NOT NULL,
|
||
|
|
client_secret VARCHAR(255) NOT NULL,
|
||
|
|
base_url VARCHAR(255) DEFAULT 'https://api.services.mimecast.com',
|
||
|
|
enabled BOOLEAN DEFAULT true,
|
||
|
|
notes TEXT,
|
||
|
|
created_at TIMESTAMP WITHOUT TIME ZONE DEFAULT NOW(),
|
||
|
|
updated_at TIMESTAMP WITHOUT TIME ZONE DEFAULT NOW()
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_mimecast_tenants_company ON mimecast_tenants(company_id);
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_mimecast_tenants_enabled ON mimecast_tenants(enabled);
|