UPDATE mst_paket SET active_st = 0;

INSERT INTO mst_paket (paket_nm, kategori_tx, deskripsi_tx, fasilitas_tx, durasi_menit, normal_harga, thumbnail_foto, active_st) VALUES
('Couple ArtBox Studio', 'ArtBox', 'Harga Normal Rp. 100.000', '30 Minutes of Self Portrait\nMax 2 People\nFree to Choose Property\nFree Digital Soft Copy\nFree 2 Printed Photo (Promo)', 30, 50000, 'koneksi1', 1),
('Group ArtBox Studio', 'ArtBox', 'Harga Normal Rp. 105.000', '30 Minutes of Self Portrait\nMin 3 Orang\nRp. 19.000/Orang\nFree to Choose Property\nFree Digital Soft Copy\nFree 2 Printed Photo (Promo)', 30, 105000, 'koneksi2', 1),
('Couple GrayscaleBox', 'Grayscale', 'Harga Normal Rp. 100.000', '30 Minutes of Self Portrait\nMax 2 People\nFree to Choose Property\nFree Digital Soft Copy\nFree 2 Printed Photo (Promo)', 30, 50000, 'koneksi3', 1),
('Group GrayscaleBox', 'Grayscale', 'Harga Normal Rp. 105.000', '30 Minutes of Self Portrait\nMin 3 Orang\nRp. 19.000/Orang\nFree to Choose Property\nFree Digital Soft Copy\nFree 2 Printed Photo (Promo)', 30, 105000, 'koneksi4', 1),
('Group Thematic Self Potrait', 'Thematic', 'Sesi foto Thematic group', '30 Minutes of Self Portrait\n19.000 Per Orang, Min 3 People\nFree to Choose Background\nFree to Choose Property\nFree Digital Soft Copy\nFree 2 Printed Photo', 30, 57000, 'koneksi5', 1),
('Couple Thematic Self Potrait', 'Thematic', 'Harga Normal Rp. 100.000', '30 Minutes of Self Portrait\nMax 2 People\nFree to Choose Background\nFree to Choose Property\nFree Digital Soft Copy\nFree 2 Printed Photo', 30, 60000, 'koneksi6', 1),
('Promo Graduation Paket A', 'Graduation', 'Promo Spesial Kelulusan', '30 Menit Sesi Foto\nMaksimal 3 Orang\nBebas Pilih 1 Background\nMenggunakan Fotografer\nBebas Menggunakan Properti\nGratis Cetak 3 Foto (4R)\nGratis Semua File Via GDrive', 30, 150000, 'koneksi7', 1),
('Promo Graduation Paket B', 'Graduation', 'Promo Spesial Kelulusan Terlengkap', '30 Menit Sesi Foto\nMaksimal 3 Orang\nBebas Pilih 1 Background\nMenggunakan Fotografer\nBebas Menggunakan Properti\nGratis Cetak 3 Foto (4R)\nGratis Cetak Frame (12R)\nGratis Semua File Via GDrive', 30, 250000, 'koneksi8', 1),
('Graduation / Family / Maternity Package', 'Family', 'Paket Keluarga/Maternity', '30 Minutes of Photoshoot\nMax 3 People\n1 Thematic Background\nFree 2 Printed Photo\n5 Photo Editing\nPhotoshoot by Photographer\nFree To Choose Property\nFree Digital Soft Copy', 30, 250000, 'koneksi9', 1);

UPDATE mst_promo SET active_st = 0;

INSERT INTO mst_promo (promo_nm, kode_promo, tipe_potongan, potongan_nominal, min_pembelian, maks_potongan, mulai_tgl, selesai_tgl, mulai_jam, selesai_jam, wajib_upload_st, active_st) VALUES
('Promo Spesial ArtBox', 'ARTBOX50', 'persen', 50.0, 100000.0, 50000.0, '2020-01-01', '2027-12-31', '00:00:00', '23:59:00', 0, 1),
('Potongan Graduation', 'GRAD100K', 'nominal', 100000.0, 200000.0, 0, '2020-01-01', '2027-12-31', '00:00:00', '23:59:00', 1, 1);
