CREATE TABLE IF NOT EXISTS credit_packages (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  credits INT NOT NULL,
  price DECIMAL(10, 2) NOT NULL,
  currency VARCHAR(10) DEFAULT 'USD',
  description TEXT,
  popular TINYINT(1) DEFAULT 0,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Optional: Insert default data if table is empty
INSERT IGNORE INTO credit_packages (name, credits, price, currency, description, popular) VALUES 
('Starter', 50, 50000, 'IDR', 'Perfect for beginners', 0),
('Pro', 120, 100000, 'IDR', 'Best value for professionals', 1),
('Business', 250, 200000, 'IDR', 'For high volume needs', 0);