10 lines
631 B
SQL
10 lines
631 B
SQL
-- Phase 11: the loyalty card's owner-configurable text now replaces the
|
|
-- hardcoded "Loyalty Card" title (top-left), not a secondary badge next to
|
|
-- the member number (top-right) — renamed to match, using CHANGE COLUMN so
|
|
-- any value an owner already configured (e.g. a custom title) survives the
|
|
-- rename instead of being dropped.
|
|
ALTER TABLE `LoyaltyProgramme`
|
|
CHANGE COLUMN `cardTopRightText` `cardTitleText` VARCHAR(191) NULL,
|
|
CHANGE COLUMN `cardTopRightTextSize` `cardTitleTextSize` ENUM('SM', 'MD', 'LG') NOT NULL DEFAULT 'MD',
|
|
CHANGE COLUMN `cardTopRightTextColor` `cardTitleTextColor` VARCHAR(191) NULL;
|