USE indes_billing;
CREATE TABLE IF NOT EXISTS point_rewards (
 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(150) NOT NULL,
 points INT UNSIGNED NOT NULL,
 status ENUM('active','inactive') NOT NULL DEFAULT 'active',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;
INSERT INTO point_rewards(name,points)
SELECT seed.name,seed.points FROM (
 SELECT 'Rinso 1 kg' name,50 points UNION ALL
 SELECT 'Minyak goreng 2 liter',120 UNION ALL
 SELECT 'Beras 2,5 kg',150 UNION ALL
 SELECT 'Indomie 1 dus',200 UNION ALL
 SELECT 'Beras 5 kg',300 UNION ALL
 SELECT 'Magic com',350 UNION ALL
 SELECT 'Kompor gas',650
) seed WHERE NOT EXISTS (SELECT 1 FROM point_rewards r WHERE r.name=seed.name);
