-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 15, 2025 at 08:17 PM
-- Server version: 10.11.14-MariaDB-cll-lve
-- PHP Version: 8.4.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `jacqxbxl_server`
--

-- --------------------------------------------------------

--
-- Table structure for table `shows`
--

CREATE TABLE `shows` (
  `id` int(11) NOT NULL,
  `showId` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `lineup` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`lineup`)),
  `seitansai` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`seitansai`)),
  `graduation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`graduation`)),
  `start_time` bigint(20) NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'Regular',
  `price` decimal(10,2) NOT NULL,
  `banner_link` varchar(255) DEFAULT NULL,
  `is_promo` tinyint(1) NOT NULL DEFAULT 0,
  `promo_price` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `is_live` tinyint(1) NOT NULL DEFAULT 0,
  `is_replay` tinyint(1) NOT NULL DEFAULT 0,
  `url_live` varchar(255) DEFAULT NULL,
  `url_replay` varchar(255) DEFAULT NULL,
  `type_live` varchar(50) NOT NULL DEFAULT 'idn'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shows`
--

INSERT INTO `shows` (`id`, `showId`, `title`, `description`, `lineup`, `seitansai`, `graduation`, `start_time`, `type`, `price`, `banner_link`, `is_promo`, `promo_price`, `is_active`, `is_live`, `is_replay`, `url_live`, `url_replay`, `type_live`) VALUES
(1, '3039', 'KIRA KIRA GIRLS', '', '[{\"id\":\"277\",\"name\":\"Aralie\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447278/assets/kabesha/oktober_2024/abigail_rachel.jpg\",\"url_key\":\"aralie\"},{\"id\":\"297\",\"name\":\"Virgi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164607/jkt48/kabesha-gen13/astrella_virgiananda.jpg\",\"url_key\":\"virgi\"},{\"id\":\"299\",\"name\":\"Rilly\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164653/jkt48/kabesha-gen13/bong_aprilli.jpg\",\"url_key\":\"rilly\"},{\"id\":\"281\",\"name\":\"Erine\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447281/assets/kabesha/oktober_2024/catherina_vallencia.jpg\",\"url_key\":\"erine\"},{\"id\":\"301\",\"name\":\"Maira\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164656/jkt48/kabesha-gen13/humaira_ramadhani.jpg\",\"url_key\":\"maira\"},{\"id\":\"286\",\"name\":\"Levi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447285/assets/kabesha/oktober_2024/michelle_levia.jpg\",\"url_key\":\"levi\"},{\"id\":\"304\",\"name\":\"Mikaela\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164659/jkt48/kabesha-gen13/mikaela_kusjanto.jpg\",\"url_key\":\"mikaela\"},{\"id\":\"287\",\"name\":\"Nayla\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447286/assets/kabesha/oktober_2024/nayla_suji.jpg\",\"url_key\":\"nayla\"},{\"id\":\"288\",\"name\":\"Nachia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447287/assets/kabesha/oktober_2024/nina_tutachia.jpg\",\"url_key\":\"nachia\"},{\"id\":\"291\",\"name\":\"Ribka\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447290/assets/kabesha/oktober_2024/ribka_budiman.jpg\",\"url_key\":\"ribka\"},{\"id\":\"292\",\"name\":\"Nala\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447291/assets/kabesha/oktober_2024/shabilqis_naila.jpg\",\"url_key\":\"nala\"},{\"id\":\"293\",\"name\":\"Kimmy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447292/assets/kabesha/oktober_2024/victoria_kimberly.jpg\",\"url_key\":\"kimmy\"}]', '[]', '[]', 1764849600000, 'Regular', 10000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1763233779/tanfbrrf8oexxmmfoouh.jpg', 0, NULL, 1, 1, 0, 'https://www.idn.live/jkt48-official/kira-kira-girls-04-12-25-251129125341', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn'),
(2, '3040', 'Aturan Anti Cinta', 'Setlist legendaris telah kembali! Ini adalah pertunjukan yang menjadi langkah awal JKT48 saat pertama kali berdiri. Seperti apakah new era JKT48 membawakannya? Bersiaplah menyaksikan 16 lagu yang akan menggetarkan hatimu dengan beragam bentuk dari cinta.', '[{\"id\":\"280\",\"name\":\"Lana\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1749901785/r7tfhcwucwpq9v080doo.jpg\",\"url_key\":\"lana\"},{\"id\":\"263\",\"name\":\"Cathy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447254/assets/kabesha/oktober_2024/cathleen_nixie.jpg\",\"url_key\":\"cathy\"},{\"id\":\"265\",\"name\":\"Chelsea\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447255/assets/kabesha/oktober_2024/chelsea_davina.jpg\",\"url_key\":\"chelsea\"},{\"id\":\"221\",\"name\":\"Oniel\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447256/assets/kabesha/oktober_2024/cornelia_vanisa.jpg\",\"url_key\":\"oniel\"},{\"id\":\"266\",\"name\":\"Cynthia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447258/assets/kabesha/oktober_2024/cynthia_yaputera.jpg\",\"url_key\":\"cynthia\"},{\"id\":\"267\",\"name\":\"Danella\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447259/assets/kabesha/oktober_2024/dena_natalia.jpg\",\"url_key\":\"danella\"},{\"id\":\"268\",\"name\":\"Daisy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447260/assets/kabesha/oktober_2024/desy_natalia.jpg\",\"url_key\":\"daisy\"},{\"id\":\"213\",\"name\":\"Olla\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447260/assets/kabesha/oktober_2024/febriola_sinambela.jpg\",\"url_key\":\"olla\"},{\"id\":\"269\",\"name\":\"Gendis\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447265/assets/kabesha/oktober_2024/gendis_mayrannisa.jpg\",\"url_key\":\"gendis\"},{\"id\":\"190\",\"name\":\"Gita\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447266/assets/kabesha/oktober_2024/gita_sekar_andarini.jpg\",\"url_key\":\"gita\"},{\"id\":\"270\",\"name\":\"Gracie\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447267/assets/kabesha/oktober_2024/grace_octaviani.jpg\",\"url_key\":\"gracie\"},{\"id\":\"210\",\"name\":\"Eli\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447268/assets/kabesha/oktober_2024/helisma_putri.jpg\",\"url_key\":\"eli\"},{\"id\":\"215\",\"name\":\"Jessi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447271/assets/kabesha/oktober_2024/jessica_chandra.jpg\",\"url_key\":\"jessi\"},{\"id\":\"228\",\"name\":\"Lulu\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447273/assets/kabesha/oktober_2024/lulu_salsabila.jpg\",\"url_key\":\"lulu\"},{\"id\":\"273\",\"name\":\"Michie\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447274/assets/kabesha/oktober_2024/michelle_alexandra.jpg\",\"url_key\":\"michie\"},{\"id\":\"286\",\"name\":\"Levi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447285/assets/kabesha/oktober_2024/michelle_levia.jpg\",\"url_key\":\"levi\"}]', '[]', '[]', 1764936000000, 'Regular', 10000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1709811057/hjsfgaw0kf3fhxg677fs.jpg', 0, NULL, 1, 0, 0, 'https://www.idn.live/jkt48-official/aturan-anti-cinta-05-12-25-251129125458', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn'),
(3, '3041', 'Ingin Bertemu', 'Manis dan pahitnya sebuah pertemuan akan dapat kalian rasakan melalui pertunjukan “Ingin Bertemu” yang dipersembahkan oleh JKT48 Trainee.', '[{\"id\":\"278\",\"name\":\"Delynn\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447279/assets/kabesha/oktober_2024/adeline_wijaya.jpg\",\"url_key\":\"delynn\"},{\"id\":\"297\",\"name\":\"Virgi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164607/jkt48/kabesha-gen13/astrella_virgiananda.jpg\",\"url_key\":\"virgi\"},{\"id\":\"298\",\"name\":\"Auwia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164652/jkt48/kabesha-gen13/aulia_riza.jpg\",\"url_key\":\"auwia\"},{\"id\":\"299\",\"name\":\"Rilly\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164653/jkt48/kabesha-gen13/bong_aprilli.jpg\",\"url_key\":\"rilly\"},{\"id\":\"281\",\"name\":\"Erine\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447281/assets/kabesha/oktober_2024/catherina_vallencia.jpg\",\"url_key\":\"erine\"},{\"id\":\"300\",\"name\":\"Giaa\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164655/jkt48/kabesha-gen13/hagia_sopia.jpg\",\"url_key\":\"giaa\"},{\"id\":\"302\",\"name\":\"Ekin\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164657/jkt48/kabesha-gen13/jacqueline_immanuela.jpg\",\"url_key\":\"ekin\"},{\"id\":\"284\",\"name\":\"Trisha\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447284/assets/kabesha/oktober_2024/jazzlyn_trisha.jpg\",\"url_key\":\"trisha\"},{\"id\":\"303\",\"name\":\"Jemima\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164658/jkt48/kabesha-gen13/jemima_evodie.jpg\",\"url_key\":\"jemima\"},{\"id\":\"304\",\"name\":\"Mikaela\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164659/jkt48/kabesha-gen13/mikaela_kusjanto.jpg\",\"url_key\":\"mikaela\"},{\"id\":\"305\",\"name\":\"Intan\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164660/jkt48/kabesha-gen13/nur_intan.jpg\",\"url_key\":\"intan\"},{\"id\":\"292\",\"name\":\"Nala\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447291/assets/kabesha/oktober_2024/shabilqis_naila.jpg\",\"url_key\":\"nala\"}]', '[]', '[]', 1765011600000, 'Regular', 10000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1746940686/gnzangtum7a8ygmk8hvj.jpg', 0, NULL, 1, 0, 0, 'https://www.idn.live/jkt48-official/ingin-bertemu-6-12-25-251129125612', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn'),
(4, '3042', 'Pertaruhan Cinta', '', '[{\"id\":\"204\",\"name\":\"Christy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447251/assets/kabesha/oktober_2024/angelina_christy.jpg\",\"url_key\":\"christy\"},{\"id\":\"250\",\"name\":\"Lia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447252/assets/kabesha/oktober_2024/aurellia.jpg\",\"url_key\":\"lia\"},{\"id\":\"280\",\"name\":\"Lana\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1749901785/r7tfhcwucwpq9v080doo.jpg\",\"url_key\":\"lana\"},{\"id\":\"221\",\"name\":\"Oniel\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447256/assets/kabesha/oktober_2024/cornelia_vanisa.jpg\",\"url_key\":\"oniel\"},{\"id\":\"190\",\"name\":\"Gita\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447266/assets/kabesha/oktober_2024/gita_sekar_andarini.jpg\",\"url_key\":\"gita\"},{\"id\":\"270\",\"name\":\"Gracie\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447267/assets/kabesha/oktober_2024/grace_octaviani.jpg\",\"url_key\":\"gracie\"},{\"id\":\"271\",\"name\":\"Greesel\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447267/assets/kabesha/oktober_2024/greesella_adhalia.jpg\",\"url_key\":\"greesel\"},{\"id\":\"215\",\"name\":\"Jessi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447271/assets/kabesha/oktober_2024/jessica_chandra.jpg\",\"url_key\":\"jessi\"},{\"id\":\"228\",\"name\":\"Lulu\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447273/assets/kabesha/oktober_2024/lulu_salsabila.jpg\",\"url_key\":\"lulu\"},{\"id\":\"243\",\"name\":\"Marsha\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447274/assets/kabesha/oktober_2024/marsha_lenathea.jpg\",\"url_key\":\"marsha\"},{\"id\":\"199\",\"name\":\"Muthe\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447275/assets/kabesha/oktober_2024/mutiara_azzahra.jpg\",\"url_key\":\"muthe\"},{\"id\":\"113\",\"name\":\"Gracia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447277/assets/kabesha/oktober_2024/shania_gracia.jpg\",\"url_key\":\"gracia\"}]', '[{\"id\":\"204\",\"name\":\"Christy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447251/assets/kabesha/oktober_2024/angelina_christy.jpg\",\"url_key\":\"christy\"}]', '[]', 1765090800000, 'Seitansai', 15000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1760105848/bi5ej2hgh0cc2uowu5xr.jpg', 0, NULL, 1, 0, 0, 'https://www.idn.live/jkt48-official/pertaruhan-cinta-07-12-25-251129125849', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn'),
(5, '3043', 'Sambil Menggandeng Erat Tanganku', 'Dengan penuh gairah dan penuh energi, JKT48 New Era membawakan setlist \'Te wo Tsunaginagara\' ke panggung dengan warna baru. Setlist yang dulu dirintis Team T pada 2015 ini kini hadir lagi, membawa nostalgia sekaligus semangat yang pernah di bawa oleh kakak-kakak nya. Siap-siap buat ikut terhanyut dalam energi ceria dan lagu-lagu ikonik yang dibawakan dengan sepenuh hati!', '[{\"id\":\"262\",\"name\":\"Anindya\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447251/assets/kabesha/oktober_2024/anindya_ramadhani.jpg\",\"url_key\":\"anindya\"},{\"id\":\"264\",\"name\":\"Elin\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447255/assets/kabesha/oktober_2024/celline_thefani.jpg\",\"url_key\":\"elin\"},{\"id\":\"221\",\"name\":\"Oniel\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447256/assets/kabesha/oktober_2024/cornelia_vanisa.jpg\",\"url_key\":\"oniel\"},{\"id\":\"266\",\"name\":\"Cynthia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447258/assets/kabesha/oktober_2024/cynthia_yaputera.jpg\",\"url_key\":\"cynthia\"},{\"id\":\"267\",\"name\":\"Danella\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447259/assets/kabesha/oktober_2024/dena_natalia.jpg\",\"url_key\":\"danella\"},{\"id\":\"223\",\"name\":\"Fiony\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447262/assets/kabesha/oktober_2024/fiony_alveria.jpg\",\"url_key\":\"fiony\"},{\"id\":\"214\",\"name\":\"Freya\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447264/assets/kabesha/oktober_2024/freya_jayawardana.jpg\",\"url_key\":\"freya\"},{\"id\":\"282\",\"name\":\"Fritzy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1749901735/inzlhy9clnv0sca67qrd.jpg\",\"url_key\":\"fritzy\"},{\"id\":\"241\",\"name\":\"Indah\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447269/assets/kabesha/oktober_2024/indah_cahya.jpg\",\"url_key\":\"indah\"},{\"id\":\"242\",\"name\":\"Kathrina\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447272/assets/kabesha/oktober_2024/kathrina_irene.jpg\",\"url_key\":\"kathrina\"},{\"id\":\"228\",\"name\":\"Lulu\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447273/assets/kabesha/oktober_2024/lulu_salsabila.jpg\",\"url_key\":\"lulu\"},{\"id\":\"199\",\"name\":\"Muthe\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447275/assets/kabesha/oktober_2024/mutiara_azzahra.jpg\",\"url_key\":\"muthe\"}]', '[]', '[]', 1765368000000, 'Regular', 10000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1746940449/zjdka1gtuuoc5gx9kkco.jpg', 0, NULL, 1, 0, 0, 'https://www.idn.live/jkt48-official/sambil-menggandeng-erat-tanganku-10-12-25-251129130010', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn'),
(6, '3044', 'KIRA KIRA GIRLS', '', '[{\"id\":\"278\",\"name\":\"Delynn\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447279/assets/kabesha/oktober_2024/adeline_wijaya.jpg\",\"url_key\":\"delynn\"},{\"id\":\"298\",\"name\":\"Auwia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164652/jkt48/kabesha-gen13/aulia_riza.jpg\",\"url_key\":\"auwia\"},{\"id\":\"281\",\"name\":\"Erine\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447281/assets/kabesha/oktober_2024/catherina_vallencia.jpg\",\"url_key\":\"erine\"},{\"id\":\"300\",\"name\":\"Giaa\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164655/jkt48/kabesha-gen13/hagia_sopia.jpg\",\"url_key\":\"giaa\"},{\"id\":\"283\",\"name\":\"Lily\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447283/assets/kabesha/oktober_2024/hillary_abigail.jpg\",\"url_key\":\"lily\"},{\"id\":\"302\",\"name\":\"Ekin\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164657/jkt48/kabesha-gen13/jacqueline_immanuela.jpg\",\"url_key\":\"ekin\"},{\"id\":\"284\",\"name\":\"Trisha\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447284/assets/kabesha/oktober_2024/jazzlyn_trisha.jpg\",\"url_key\":\"trisha\"},{\"id\":\"303\",\"name\":\"Jemima\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164658/jkt48/kabesha-gen13/jemima_evodie.jpg\",\"url_key\":\"jemima\"},{\"id\":\"288\",\"name\":\"Nachia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447287/assets/kabesha/oktober_2024/nina_tutachia.jpg\",\"url_key\":\"nachia\"},{\"id\":\"305\",\"name\":\"Intan\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164660/jkt48/kabesha-gen13/nur_intan.jpg\",\"url_key\":\"intan\"},{\"id\":\"289\",\"name\":\"Oline\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447288/assets/kabesha/oktober_2024/oline_manuel.jpg\",\"url_key\":\"oline\"},{\"id\":\"293\",\"name\":\"Kimmy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447292/assets/kabesha/oktober_2024/victoria_kimberly.jpg\",\"url_key\":\"kimmy\"}]', '[]', '[]', 1765454400000, 'Regular', 10000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1763233779/tanfbrrf8oexxmmfoouh.jpg', 0, NULL, 1, 0, 0, 'https://www.idn.live/jkt48-official/kira-kira-girls-11-12-25-251129130408', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn'),
(7, '3045', 'Ingin Bertemu', 'Manis dan pahitnya sebuah pertemuan akan dapat kalian rasakan melalui pertunjukan “Ingin Bertemu” yang dipersembahkan oleh JKT48 Trainee.', '[{\"id\":\"277\",\"name\":\"Aralie\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447278/assets/kabesha/oktober_2024/abigail_rachel.jpg\",\"url_key\":\"aralie\"},{\"id\":\"297\",\"name\":\"Virgi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164607/jkt48/kabesha-gen13/astrella_virgiananda.jpg\",\"url_key\":\"virgi\"},{\"id\":\"281\",\"name\":\"Erine\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447281/assets/kabesha/oktober_2024/catherina_vallencia.jpg\",\"url_key\":\"erine\"},{\"id\":\"300\",\"name\":\"Giaa\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1733164655/jkt48/kabesha-gen13/hagia_sopia.jpg\",\"url_key\":\"giaa\"},{\"id\":\"283\",\"name\":\"Lily\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447283/assets/kabesha/oktober_2024/hillary_abigail.jpg\",\"url_key\":\"lily\"},{\"id\":\"284\",\"name\":\"Trisha\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447284/assets/kabesha/oktober_2024/jazzlyn_trisha.jpg\",\"url_key\":\"trisha\"},{\"id\":\"286\",\"name\":\"Levi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447285/assets/kabesha/oktober_2024/michelle_levia.jpg\",\"url_key\":\"levi\"},{\"id\":\"287\",\"name\":\"Nayla\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447286/assets/kabesha/oktober_2024/nayla_suji.jpg\",\"url_key\":\"nayla\"},{\"id\":\"288\",\"name\":\"Nachia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447287/assets/kabesha/oktober_2024/nina_tutachia.jpg\",\"url_key\":\"nachia\"},{\"id\":\"289\",\"name\":\"Oline\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447288/assets/kabesha/oktober_2024/oline_manuel.jpg\",\"url_key\":\"oline\"},{\"id\":\"291\",\"name\":\"Ribka\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447290/assets/kabesha/oktober_2024/ribka_budiman.jpg\",\"url_key\":\"ribka\"},{\"id\":\"293\",\"name\":\"Kimmy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447292/assets/kabesha/oktober_2024/victoria_kimberly.jpg\",\"url_key\":\"kimmy\"}]', '[]', '[]', 1765540800000, 'Regular', 10000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1746940686/gnzangtum7a8ygmk8hvj.jpg', 0, NULL, 1, 0, 0, 'https://www.idn.live/jkt48-official/ingin-bertemu-12-12-25-251129130541', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn'),
(8, '3046', 'Cara Meminum Ramune', 'Pernahkah kamu meminum Ramune? Meskipun tidak bisa diminum sekaligus, tapi Ramune tetap dapat kita rasakan kesegarannya dalam setiap tetesnya. Seperti nikmatnya Ramune tersebut, para member JKT48 New Era siap untuk memberikanmu keceriaan dan semangat baru, melalui setiap lagu yang ada di dalam setlist Cara Meminum Ramune (Ramune no Nomikata) ini.', '[{\"id\":\"250\",\"name\":\"Lia\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447252/assets/kabesha/oktober_2024/aurellia.jpg\",\"url_key\":\"lia\"},{\"id\":\"280\",\"name\":\"Lana\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1749901785/r7tfhcwucwpq9v080doo.jpg\",\"url_key\":\"lana\"},{\"id\":\"263\",\"name\":\"Cathy\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447254/assets/kabesha/oktober_2024/cathleen_nixie.jpg\",\"url_key\":\"cathy\"},{\"id\":\"264\",\"name\":\"Elin\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447255/assets/kabesha/oktober_2024/celline_thefani.jpg\",\"url_key\":\"elin\"},{\"id\":\"265\",\"name\":\"Chelsea\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447255/assets/kabesha/oktober_2024/chelsea_davina.jpg\",\"url_key\":\"chelsea\"},{\"id\":\"221\",\"name\":\"Oniel\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447256/assets/kabesha/oktober_2024/cornelia_vanisa.jpg\",\"url_key\":\"oniel\"},{\"id\":\"267\",\"name\":\"Danella\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447259/assets/kabesha/oktober_2024/dena_natalia.jpg\",\"url_key\":\"danella\"},{\"id\":\"213\",\"name\":\"Olla\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447260/assets/kabesha/oktober_2024/febriola_sinambela.jpg\",\"url_key\":\"olla\"},{\"id\":\"223\",\"name\":\"Fiony\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447262/assets/kabesha/oktober_2024/fiony_alveria.jpg\",\"url_key\":\"fiony\"},{\"id\":\"252\",\"name\":\"Ella\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447264/assets/kabesha/oktober_2024/gabriela_abigail.jpg\",\"url_key\":\"ella\"},{\"id\":\"190\",\"name\":\"Gita\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447266/assets/kabesha/oktober_2024/gita_sekar_andarini.jpg\",\"url_key\":\"gita\"},{\"id\":\"271\",\"name\":\"Greesel\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447267/assets/kabesha/oktober_2024/greesella_adhalia.jpg\",\"url_key\":\"greesel\"},{\"id\":\"210\",\"name\":\"Eli\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447268/assets/kabesha/oktober_2024/helisma_putri.jpg\",\"url_key\":\"eli\"},{\"id\":\"215\",\"name\":\"Jessi\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447271/assets/kabesha/oktober_2024/jessica_chandra.jpg\",\"url_key\":\"jessi\"},{\"id\":\"254\",\"name\":\"Lyn\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447271/assets/kabesha/oktober_2024/jesslyn_elly.jpg\",\"url_key\":\"lyn\"},{\"id\":\"242\",\"name\":\"Kathrina\",\"img\":\"https://res.cloudinary.com/haymzm4wp/image/upload/v1730447272/assets/kabesha/oktober_2024/kathrina_irene.jpg\",\"url_key\":\"kathrina\"}]', '[]', '[]', 1765609200000, 'Regular', 10000.00, 'https://res.cloudinary.com/haymzm4wp/image/upload/v1709811568/hm6aztwojrngb6ryrdn9.png', 0, NULL, 1, 0, 0, 'https://www.idn.live/jkt48-official/cara-meminum-ramune-13-12-25-251129130702', '50a27780-93e7-4e40-8474-60f6e0cca6da', 'idn');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `shows`
--
ALTER TABLE `shows`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `shows`
--
ALTER TABLE `shows`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;