PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.66_ad_campaign_schedules_unique.sql   Download  
File: database/migrations/v1.11.0.66_ad_campaign_schedules_unique.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 397 bytes
 

Contents

Class file image Download 
-- Migration: 1.11.0.66 - Unique constraint on advertisement_campaign_schedules
-- Prevents duplicate schedule rows per logical slot and enables upsert-based sync
-- so that last_triggered_at is preserved when a campaign is saved mid-window.

ALTER TABLE advertisement_campaign_schedules
    ADD CONSTRAINT uq_ad_campaign_schedules_slot
    UNIQUE (campaign_id, days_mask, time_of_day, timezone);