-- Prestige Barber Club v4.40.9 fallback SQL
INSERT INTO settings(setting_key,setting_value) VALUES('pre_member_expired_discount_type','fixed') ON DUPLICATE KEY UPDATE setting_value=setting_value;
INSERT INTO settings(setting_key,setting_value) VALUES('pre_member_expired_discount_value','0') ON DUPLICATE KEY UPDATE setting_value=setting_value;
SET @db=DATABASE();
SET @x=(SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=@db AND TABLE_NAME='membership_sales' AND COLUMN_NAME='membership_validity_months');
SET @sql=IF(@x=0,'ALTER TABLE membership_sales ADD COLUMN membership_validity_months INT NULL AFTER discount_amount','SELECT 1'); PREPARE st FROM @sql; EXECUTE st; DEALLOCATE PREPARE st;
SET @x=(SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=@db AND TABLE_NAME='membership_sales' AND COLUMN_NAME='membership_start_date');
SET @sql=IF(@x=0,'ALTER TABLE membership_sales ADD COLUMN membership_start_date DATE NULL AFTER membership_validity_months','SELECT 1'); PREPARE st FROM @sql; EXECUTE st; DEALLOCATE PREPARE st;
SET @x=(SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=@db AND TABLE_NAME='membership_sales' AND COLUMN_NAME='membership_end_date');
SET @sql=IF(@x=0,'ALTER TABLE membership_sales ADD COLUMN membership_end_date DATE NULL AFTER membership_start_date','SELECT 1'); PREPARE st FROM @sql; EXECUTE st; DEALLOCATE PREPARE st;
INSERT INTO settings(setting_key,setting_value) VALUES('schema_release','4.40.9') ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value);