-- Initial package data. Re-runnable: INSERT IGNORE never overwrites prices an administrator has edited.
-- purchase_price_usd = what the visitor pays in crypto. funding_amount_usd = what the token authorizes. They differ on purpose.
INSERT IGNORE INTO funding_packages (package_code, name, description, purchase_price_usd, funding_amount_usd, is_active, sort_order, created_at, updated_at) VALUES
('starter',  'Starter',  'Authorizes one $100 wallet-funding operation.',   15.00,  100.00, 1, 10, UTC_TIMESTAMP(), UTC_TIMESTAMP()),
('bronze',   'Bronze',   'Authorizes one $250 wallet-funding operation.',   25.00,  250.00, 1, 20, UTC_TIMESTAMP(), UTC_TIMESTAMP()),
('silver',   'Silver',   'Authorizes one $500 wallet-funding operation.',   50.00,  500.00, 1, 30, UTC_TIMESTAMP(), UTC_TIMESTAMP()),
('gold',     'Gold',     'Authorizes one $750 wallet-funding operation.',   75.00,  750.00, 1, 40, UTC_TIMESTAMP(), UTC_TIMESTAMP()),
('platinum', 'Platinum', 'Authorizes one $1,000 wallet-funding operation.', 100.00, 1000.00, 1, 50, UTC_TIMESTAMP(), UTC_TIMESTAMP());

INSERT IGNORE INTO system_settings (setting_key, setting_value, updated_by, updated_at) VALUES
('purchases_enabled', '1', NULL, UTC_TIMESTAMP()),
('funding_enabled',   '1', NULL, UTC_TIMESTAMP()),
('site_notice',       '',  NULL, UTC_TIMESTAMP());