CREATE TABLE IF NOT EXISTS settings (
    name VARCHAR(255) PRIMARY KEY,
    value VARCHAR(255)
);

INSERT INTO settings (name, value) VALUES
('service_fee_percentage', '7'),
('delivery_fee', '1.50'),
('driver_base_pay_tier1_miles', '3'),
('driver_base_pay_tier1_amount', '3'),
('driver_base_pay_tier2_miles', '5'),
('driver_base_pay_tier2_amount', '4'),
('driver_base_pay_tier3_amount', '5'),
('driver_mileage_pay_rate', '0.65'),
('driver_busy_hour_bonus', '2'),
('driver_quest_bonus_amount', '10'),
('driver_quest_bonus_deliveries', '10'),
('driver_quest_bonus_hours', '2')
ON CONFLICT (name) DO UPDATE SET value = EXCLUDED.value;