USE indes_billing;
ALTER TABLE admins ADD COLUMN role ENUM('super_admin','admin') NOT NULL DEFAULT 'admin';
ALTER TABLE admins ADD COLUMN status ENUM('active','inactive') NOT NULL DEFAULT 'active';
ALTER TABLE admins ADD COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
UPDATE admins SET role='super_admin',status='active' WHERE username='admin';
INSERT INTO settings(setting_key,setting_value) VALUES ('wa_billing_template','Halo {nama},\n\nPengingat tagihan internet {perusahaan}.\n\nNo. Tagihan: {invoice}\nPaket: {paket}\nPeriode: {periode}\nNominal: {nominal}\nJatuh tempo: {jatuh_tempo}\n\n{info_pembayaran}\n\nTerima kasih.') ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value);
