-- Tabel untuk menyimpan daftar produk/layanan
CREATE TABLE `products` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `buyer_sku_code` VARCHAR(50) NOT NULL UNIQUE,
  `product_name` VARCHAR(150) NOT NULL,
  `category` VARCHAR(50) NOT NULL,
  `brand` VARCHAR(50) NOT NULL,
  `price` DECIMAL(12,2) NOT NULL,
  `status` ENUM('normal', 'gangguan') DEFAULT 'normal'
);

-- Tabel untuk mencatat riwayat transaksi
CREATE TABLE `transactions` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `ref_id` VARCHAR(50) NOT NULL UNIQUE,
  `buyer_sku_code` VARCHAR(50) NOT NULL,
  `customer_no` VARCHAR(50) NOT NULL,
  `price` DECIMAL(12,2) NOT NULL,
  `status` ENUM('Pending', 'Sukses', 'Gagal') DEFAULT 'Pending',
  `sn` VARCHAR(100) DEFAULT NULL,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);