19 lines
632 B
SQL
19 lines
632 B
SQL
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; |