-- file: sql/seed.sql
INSERT INTO sites (id, name, status, betco_host, betco_resource, betco_sid, betco_secret, check_enabled, created_at)
VALUES
(1, 'DefaultSite', 'ACTIVE', 'https://payments1.betconstruct.com/', 'TerminalCallbackPG/', '1875356', 'm3q11mkmdsii', 1, NOW())
ON DUPLICATE KEY UPDATE name=VALUES(name);

INSERT INTO panel_users (site_id, email, password_hash, role, is_active, totp_secret, totp_enabled, created_at)
VALUES
(1, 'admin@example.com', 'Admin123!', 'SUPER_ADMIN', 1, NULL, 0, NOW()),
(1, 'finance@example.com', 'Finance123!', 'FINANCE', 1, NULL, 0, NOW()),
(1, 'acc@example.com', 'Acc123!', 'ACCOUNTING', 1, NULL, 0, NOW())
ON DUPLICATE KEY UPDATE email=VALUES(email);

INSERT INTO bank_accounts (site_id, bank_name, iban, account_holder, is_active, created_at)
VALUES
(1, 'Example Bank', 'TR000000000000000000000000', 'DefaultSite Finans', 1, NOW());
