8 lines
303 B
SQL
8 lines
303 B
SQL
-- Group static image slots by website page (home, products, about, …)
|
|
|
|
ALTER TABLE website_image_slots
|
|
ADD COLUMN IF NOT EXISTS page_key VARCHAR(100) NOT NULL DEFAULT 'home';
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_website_image_slots_business_id_page_key
|
|
ON website_image_slots (business_id, page_key);
|