-- Per-locker charges for customer registration.
-- Import after the existing locker_registration_items table has been created.

ALTER TABLE `locker_registration_items`
    ADD COLUMN IF NOT EXISTS `stamping_fee` DECIMAL(10,2) NOT NULL DEFAULT 0.00 AFTER `amount`,
    ADD COLUMN IF NOT EXISTS `key_deposit` DECIMAL(10,2) NOT NULL DEFAULT 0.00 AFTER `stamping_fee`,
    ADD COLUMN IF NOT EXISTS `insurance_charges` DECIMAL(10,2) NOT NULL DEFAULT 0.00 AFTER `key_deposit`,
    ADD COLUMN IF NOT EXISTS `discount_amount` DECIMAL(10,2) NOT NULL DEFAULT 0.00 AFTER `insurance_charges`;