7 lines
316 B
MySQL
7 lines
316 B
MySQL
|
ALTER TABLE internet_connections_connections
|
||
|
|
ADD COLUMN IF NOT EXISTS sla_subscription_id INTEGER REFERENCES sag_subscriptions(id) ON DELETE SET NULL;
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_internet_connections_sla_subscription
|
||
|
|
ON internet_connections_connections(sla_subscription_id)
|
||
|
|
WHERE deleted_at IS NULL;
|