dml.sql

INSERT INTO provinces (id, name) VALUES
(1, 'Bali'),
(2, 'Bangka Belitung'),
(3, 'Banten'),
(4, 'Bengkulu'),
(5, 'DI Yogyakarta'),
(6, 'DKI Jakarta'),
(7, 'Gorontalo'),
(8, 'Jambi'),
(9, 'Jawa Barat'),
(10, 'Jawa Tengah'),
(11, 'Jawa Timur'),
(12, 'Kalimantan Barat'),
(13, 'Kalimantan Selatan'),
(14, 'Kalimantan Tengah'),
(15, 'Kalimantan Timur'),
(16, 'Kalimantan Utara'),
(17, 'Kepulauan Riau'),
(18, 'Lampung'),
(19, 'Maluku'),
(20, 'Maluku Utara'),
(21, 'Nanggroe Aceh Darussalam (NAD)'),
(22, 'Nusa Tenggara Barat (NTB)'),
(23, 'Nusa Tenggara Timur (NTT)'),
(24, 'Papua'),
(25, 'Papua Barat'),
(26, 'Riau'),
(27, 'Sulawesi Barat'),
(28, 'Sulawesi Selatan'),
(29, 'Sulawesi Tengah'),
(30, 'Sulawesi Tenggara'),
(31, 'Sulawesi Utara'),
(32, 'Sumatera Barat'),
(33, 'Sumatera Selatan'),
(34, 'Sumatera Utara');

INSERT INTO districts (id, name, province_id) VALUES
(1, 'Aceh Barat', 21),
(2, 'Aceh Barat Daya', 21),
(3, 'Aceh Besar', 21),
(4, 'Aceh Jaya', 21),
(5, 'Aceh Selatan', 21),
(6, 'Aceh Singkil', 21),
(7, 'Aceh Tamiang', 21),
(8, 'Aceh Tengah', 21),
(9, 'Aceh Tenggara', 21),
(10, 'Aceh Timur', 21),
(11, 'Aceh Utara', 21),
(12, 'Agam', 32),
(13, 'Alor', 23),
(14, 'Ambon', 19),
(15, 'Asahan', 34),
(16, 'Asmat', 24),
(17, 'Badung', 1),
(18, 'Balangan', 13),
(19, 'Balikpapan', 15),
(20, 'Banda Aceh', 21),
(21, 'Bandar Lampung', 18),
(22, 'Bandung', 9),
(23, 'Bandung', 9),
(24, 'Bandung Barat', 9),
(25, 'Banggai', 29),
(26, 'Banggai Kepulauan', 29),
(27, 'Bangka', 2),
(28, 'Bangka Barat', 2),
(29, 'Bangka Selatan', 2),
(30, 'Bangka Tengah', 2),
(31, 'Bangkalan', 11),
(32, 'Bangli', 1),
(33, 'Banjar', 13),
(34, 'Banjar', 9),
(35, 'Banjarbaru', 13),
(36, 'Banjarmasin', 13),
(37, 'Banjarnegara', 10),
(38, 'Bantaeng', 28),
(39, 'Bantul', 5),
(40, 'Banyuasin', 33),
(41, 'Banyumas', 10),
(42, 'Banyuwangi', 11),
(43, 'Barito Kuala', 13),
(44, 'Barito Selatan', 14),
(45, 'Barito Timur', 14),
(46, 'Barito Utara', 14),
(47, 'Barru', 28),
(48, 'Batam', 17),
(49, 'Batang', 10),
(50, 'Batang Hari', 8),
(51, 'Batu', 11),
(52, 'Batu Bara', 34),
(53, 'Bau-Bau', 30),
(54, 'Bekasi', 9),
(55, 'Bekasi', 9),
(56, 'Belitung', 2),
(57, 'Belitung Timur', 2),
(58, 'Belu', 23),
(59, 'Bener Meriah', 21),
(60, 'Bengkalis', 26),
(61, 'Bengkayang', 12),
(62, 'Bengkulu', 4),
(63, 'Bengkulu Selatan', 4),
(64, 'Bengkulu Tengah', 4),
(65, 'Bengkulu Utara', 4),
(66, 'Berau', 15),
(67, 'Biak Numfor', 24),
(68, 'Bima', 22),
(69, 'Bima', 22),
(70, 'Binjai', 34),
(71, 'Bintan', 17),
(72, 'Bireuen', 21),
(73, 'Bitung', 31),
(74, 'Blitar', 11),
(75, 'Blitar', 11),
(76, 'Blora', 10),
(77, 'Boalemo', 7),
(78, 'Bogor', 9),
(79, 'Bogor', 9),
(80, 'Bojonegoro', 11),
(81, 'Bolaang Mongondow (Bolmong)', 31),
(82, 'Bolaang Mongondow Selatan', 31),
(83, 'Bolaang Mongondow Timur', 31),
(84, 'Bolaang Mongondow Utara', 31),
(85, 'Bombana', 30),
(86, 'Bondowoso', 11),
(87, 'Bone', 28),
(88, 'Bone Bolango', 7),
(89, 'Bontang', 15),
(90, 'Boven Digoel', 24),
(91, 'Boyolali', 10),
(92, 'Brebes', 10),
(93, 'Bukittinggi', 32),
(94, 'Buleleng', 1),
(95, 'Bulukumba', 28),
(96, 'Bulungan (Bulongan)', 16),
(97, 'Bungo', 8),
(98, 'Buol', 29),
(99, 'Buru', 19),
(100, 'Buru Selatan', 19),
(101, 'Buton', 30),
(102, 'Buton Utara', 30),
(103, 'Ciamis', 9),
(104, 'Cianjur', 9),
(105, 'Cilacap', 10),
(106, 'Cilegon', 3),
(107, 'Cimahi', 9),
(108, 'Cirebon', 9),
(109, 'Cirebon', 9),
(110, 'Dairi', 34),
(111, 'Deiyai (Deliyai)', 24),
(112, 'Deli Serdang', 34),
(113, 'Demak', 10),
(114, 'Denpasar', 1),
(115, 'Depok', 9),
(116, 'Dharmasraya', 32),
(117, 'Dogiyai', 24),
(118, 'Dompu', 22),
(119, 'Donggala', 29),
(120, 'Dumai', 26),
(121, 'Empat Lawang', 33),
(122, 'Ende', 23),
(123, 'Enrekang', 28),
(124, 'Fakfak', 25),
(125, 'Flores Timur', 23),
(126, 'Garut', 9),
(127, 'Gayo Lues', 21),
(128, 'Gianyar', 1),
(129, 'Gorontalo', 7),
(130, 'Gorontalo', 7),
(131, 'Gorontalo Utara', 7),
(132, 'Gowa', 28),
(133, 'Gresik', 11),
(134, 'Grobogan', 10),
(135, 'Gunung Kidul', 5),
(136, 'Gunung Mas', 14),
(137, 'Gunungsitoli', 34),
(138, 'Halmahera Barat', 20),
(139, 'Halmahera Selatan', 20),
(140, 'Halmahera Tengah', 20),
(141, 'Halmahera Timur', 20),
(142, 'Halmahera Utara', 20),
(143, 'Hulu Sungai Selatan', 13),
(144, 'Hulu Sungai Tengah', 13),
(145, 'Hulu Sungai Utara', 13),
(146, 'Humbang Hasundutan', 34),
(147, 'Indragiri Hilir', 26),
(148, 'Indragiri Hulu', 26),
(149, 'Indramayu', 9),
(150, 'Intan Jaya', 24),
(151, 'Jakarta Barat', 6),
(152, 'Jakarta Pusat', 6),
(153, 'Jakarta Selatan', 6),
(154, 'Jakarta Timur', 6),
(155, 'Jakarta Utara', 6),
(156, 'Jambi', 8),
(157, 'Jayapura', 24),
(158, 'Jayapura', 24),
(159, 'Jayawijaya', 24),
(160, 'Jember', 11),
(161, 'Jembrana', 1),
(162, 'Jeneponto', 28),
(163, 'Jepara', 10),
(164, 'Jombang', 11),
(165, 'Kaimana', 25),
(166, 'Kampar', 26),
(167, 'Kapuas', 14),
(168, 'Kapuas Hulu', 12),
(169, 'Karanganyar', 10),
(170, 'Karangasem', 1),
(171, 'Karawang', 9),
(172, 'Karimun', 17),
(173, 'Karo', 34),
(174, 'Katingan', 14),
(175, 'Kaur', 4),
(176, 'Kayong Utara', 12),
(177, 'Kebumen', 10),
(178, 'Kediri', 11),
(179, 'Kediri', 11),
(180, 'Keerom', 24),
(181, 'Kendal', 10),
(182, 'Kendari', 30),
(183, 'Kepahiang', 4),
(184, 'Kepulauan Anambas', 17),
(185, 'Kepulauan Aru', 19),
(186, 'Kepulauan Mentawai', 32),
(187, 'Kepulauan Meranti', 26),
(188, 'Kepulauan Sangihe', 31),
(189, 'Kepulauan Seribu', 6),
(190, 'Kepulauan Siau Tagulandang Biaro (Sitaro)', 31),
(191, 'Kepulauan Sula', 20),
(192, 'Kepulauan Talaud', 31),
(193, 'Kepulauan Yapen (Yapen Waropen)', 24),
(194, 'Kerinci', 8),
(195, 'Ketapang', 12),
(196, 'Klaten', 10),
(197, 'Klungkung', 1),
(198, 'Kolaka', 30),
(199, 'Kolaka Utara', 30),
(200, 'Konawe', 30),
(201, 'Konawe Selatan', 30),
(202, 'Konawe Utara', 30),
(203, 'Kotabaru', 13),
(204, 'Kotamobagu', 31),
(205, 'Kotawaringin Barat', 14),
(206, 'Kotawaringin Timur', 14),
(207, 'Kuantan Singingi', 26),
(208, 'Kubu Raya', 12),
(209, 'Kudus', 10),
(210, 'Kulon Progo', 5),
(211, 'Kuningan', 9),
(212, 'Kupang', 23),
(213, 'Kupang', 23),
(214, 'Kutai Barat', 15),
(215, 'Kutai Kartanegara', 15),
(216, 'Kutai Timur', 15),
(217, 'Labuhan Batu', 34),
(218, 'Labuhan Batu Selatan', 34),
(219, 'Labuhan Batu Utara', 34),
(220, 'Lahat', 33),
(221, 'Lamandau', 14),
(222, 'Lamongan', 11),
(223, 'Lampung Barat', 18),
(224, 'Lampung Selatan', 18),
(225, 'Lampung Tengah', 18),
(226, 'Lampung Timur', 18),
(227, 'Lampung Utara', 18),
(228, 'Landak', 12),
(229, 'Langkat', 34),
(230, 'Langsa', 21),
(231, 'Lanny Jaya', 24),
(232, 'Lebak', 3),
(233, 'Lebong', 4),
(234, 'Lembata', 23),
(235, 'Lhokseumawe', 21),
(236, 'Lima Puluh Koto/Kota', 32),
(237, 'Lingga', 17),
(238, 'Lombok Barat', 22),
(239, 'Lombok Tengah', 22),
(240, 'Lombok Timur', 22),
(241, 'Lombok Utara', 22),
(242, 'Lubuk Linggau', 33),
(243, 'Lumajang', 11),
(244, 'Luwu', 28),
(245, 'Luwu Timur', 28),
(246, 'Luwu Utara', 28),
(247, 'Madiun', 11),
(248, 'Madiun', 11),
(249, 'Magelang', 10),
(250, 'Magelang', 10),
(251, 'Magetan', 11),
(252, 'Majalengka', 9),
(253, 'Majene', 27),
(254, 'Makassar', 28),
(255, 'Malang', 11),
(256, 'Malang', 11),
(257, 'Malinau', 16),
(258, 'Maluku Barat Daya', 19),
(259, 'Maluku Tengah', 19),
(260, 'Maluku Tenggara', 19),
(261, 'Maluku Tenggara Barat', 19),
(262, 'Mamasa', 27),
(263, 'Mamberamo Raya', 24),
(264, 'Mamberamo Tengah', 24),
(265, 'Mamuju', 27),
(266, 'Mamuju Utara', 27),
(267, 'Manado', 31),
(268, 'Mandailing Natal', 34),
(269, 'Manggarai', 23),
(270, 'Manggarai Barat', 23),
(271, 'Manggarai Timur', 23),
(272, 'Manokwari', 25),
(273, 'Manokwari Selatan', 25),
(274, 'Mappi', 24),
(275, 'Maros', 28),
(276, 'Mataram', 22),
(277, 'Maybrat', 25),
(278, 'Medan', 34),
(279, 'Melawi', 12),
(280, 'Merangin', 8),
(281, 'Merauke', 24),
(282, 'Mesuji', 18),
(283, 'Metro', 18),
(284, 'Mimika', 24),
(285, 'Minahasa', 31),
(286, 'Minahasa Selatan', 31),
(287, 'Minahasa Tenggara', 31),
(288, 'Minahasa Utara', 31),
(289, 'Mojokerto', 11),
(290, 'Mojokerto', 11),
(291, 'Morowali', 29),
(292, 'Muara Enim', 33),
(293, 'Muaro Jambi', 8),
(294, 'Muko Muko', 4),
(295, 'Muna', 30),
(296, 'Murung Raya', 14),
(297, 'Musi Banyuasin', 33),
(298, 'Musi Rawas', 33),
(299, 'Nabire', 24),
(300, 'Nagan Raya', 21),
(301, 'Nagekeo', 23),
(302, 'Natuna', 17),
(303, 'Nduga', 24),
(304, 'Ngada', 23),
(305, 'Nganjuk', 11),
(306, 'Ngawi', 11),
(307, 'Nias', 34),
(308, 'Nias Barat', 34),
(309, 'Nias Selatan', 34),
(310, 'Nias Utara', 34),
(311, 'Nunukan', 16),
(312, 'Ogan Ilir', 33),
(313, 'Ogan Komering Ilir', 33),
(314, 'Ogan Komering Ulu', 33),
(315, 'Ogan Komering Ulu Selatan', 33),
(316, 'Ogan Komering Ulu Timur', 33),
(317, 'Pacitan', 11),
(318, 'Padang', 32),
(319, 'Padang Lawas', 34),
(320, 'Padang Lawas Utara', 34),
(321, 'Padang Panjang', 32),
(322, 'Padang Pariaman', 32),
(323, 'Padang Sidempuan', 34),
(324, 'Pagar Alam', 33),
(325, 'Pakpak Bharat', 34),
(326, 'Palangka Raya', 14),
(327, 'Palembang', 33),
(328, 'Palopo', 28),
(329, 'Palu', 29),
(330, 'Pamekasan', 11),
(331, 'Pandeglang', 3),
(332, 'Pangandaran', 9),
(333, 'Pangkajene Kepulauan', 28),
(334, 'Pangkal Pinang', 2),
(335, 'Paniai', 24),
(336, 'Parepare', 28),
(337, 'Pariaman', 32),
(338, 'Parigi Moutong', 29),
(339, 'Pasaman', 32),
(340, 'Pasaman Barat', 32),
(341, 'Paser', 15),
(342, 'Pasuruan', 11),
(343, 'Pasuruan', 11),
(344, 'Pati', 10),
(345, 'Payakumbuh', 32),
(346, 'Pegunungan Arfak', 25),
(347, 'Pegunungan Bintang', 24),
(348, 'Pekalongan', 10),
(349, 'Pekalongan', 10),
(350, 'Pekanbaru', 26),
(351, 'Pelalawan', 26),
(352, 'Pemalang', 10),
(353, 'Pematang Siantar', 34),
(354, 'Penajam Paser Utara', 15),
(355, 'Pesawaran', 18),
(356, 'Pesisir Barat', 18),
(357, 'Pesisir Selatan', 32),
(358, 'Pidie', 21),
(359, 'Pidie Jaya', 21),
(360, 'Pinrang', 28),
(361, 'Pohuwato', 7),
(362, 'Polewali Mandar', 27),
(363, 'Ponorogo', 11),
(364, 'Pontianak', 12),
(365, 'Pontianak', 12),
(366, 'Poso', 29),
(367, 'Prabumulih', 33),
(368, 'Pringsewu', 18),
(369, 'Probolinggo', 11),
(370, 'Probolinggo', 11),
(371, 'Pulang Pisau', 14),
(372, 'Pulau Morotai', 20),
(373, 'Puncak', 24),
(374, 'Puncak Jaya', 24),
(375, 'Purbalingga', 10),
(376, 'Purwakarta', 9),
(377, 'Purworejo', 10),
(378, 'Raja Ampat', 25),
(379, 'Rejang Lebong', 4),
(380, 'Rembang', 10),
(381, 'Rokan Hilir', 26),
(382, 'Rokan Hulu', 26),
(383, 'Rote Ndao', 23),
(384, 'Sabang', 21),
(385, 'Sabu Raijua', 23),
(386, 'Salatiga', 10),
(387, 'Samarinda', 15),
(388, 'Sambas', 12),
(389, 'Samosir', 34),
(390, 'Sampang', 11),
(391, 'Sanggau', 12),
(392, 'Sarmi', 24),
(393, 'Sarolangun', 8),
(394, 'Sawah Lunto', 32),
(395, 'Sekadau', 12),
(396, 'Selayar (Kepulauan Selayar)', 28),
(397, 'Seluma', 4),
(398, 'Semarang', 10),
(399, 'Semarang', 10),
(400, 'Seram Bagian Barat', 19),
(401, 'Seram Bagian Timur', 19),
(402, 'Serang', 3),
(403, 'Serang', 3),
(404, 'Serdang Bedagai', 34),
(405, 'Seruyan', 14),
(406, 'Siak', 26),
(407, 'Sibolga', 34),
(408, 'Sidenreng Rappang/Rapang', 28),
(409, 'Sidoarjo', 11),
(410, 'Sigi', 29),
(411, 'Sijunjung (Sawah Lunto Sijunjung)', 32),
(412, 'Sikka', 23),
(413, 'Simalungun', 34),
(414, 'Simeulue', 21),
(415, 'Singkawang', 12),
(416, 'Sinjai', 28),
(417, 'Sintang', 12),
(418, 'Situbondo', 11),
(419, 'Sleman', 5),
(420, 'Solok', 32),
(421, 'Solok', 32),
(422, 'Solok Selatan', 32),
(423, 'Soppeng', 28),
(424, 'Sorong', 25),
(425, 'Sorong', 25),
(426, 'Sorong Selatan', 25),
(427, 'Sragen', 10),
(428, 'Subang', 9),
(429, 'Subulussalam', 21),
(430, 'Sukabumi', 9),
(431, 'Sukabumi', 9),
(432, 'Sukamara', 14),
(433, 'Sukoharjo', 10),
(434, 'Sumba Barat', 23),
(435, 'Sumba Barat Daya', 23),
(436, 'Sumba Tengah', 23),
(437, 'Sumba Timur', 23),
(438, 'Sumbawa', 22),
(439, 'Sumbawa Barat', 22),
(440, 'Sumedang', 9),
(441, 'Sumenep', 11),
(442, 'Sungaipenuh', 8),
(443, 'Supiori', 24),
(444, 'Surabaya', 11),
(445, 'Surakarta (Solo)', 10),
(446, 'Tabalong', 13),
(447, 'Tabanan', 1),
(448, 'Takalar', 28),
(449, 'Tambrauw', 25),
(450, 'Tana Tidung', 16),
(451, 'Tana Toraja', 28),
(452, 'Tanah Bumbu', 13),
(453, 'Tanah Datar', 32),
(454, 'Tanah Laut', 13),
(455, 'Tangerang', 3),
(456, 'Tangerang', 3),
(457, 'Tangerang Selatan', 3),
(458, 'Tanggamus', 18),
(459, 'Tanjung Balai', 34),
(460, 'Tanjung Jabung Barat', 8),
(461, 'Tanjung Jabung Timur', 8),
(462, 'Tanjung Pinang', 17),
(463, 'Tapanuli Selatan', 34),
(464, 'Tapanuli Tengah', 34),
(465, 'Tapanuli Utara', 34),
(466, 'Tapin', 13),
(467, 'Tarakan', 16),
(468, 'Tasikmalaya', 9),
(469, 'Tasikmalaya', 9),
(470, 'Tebing Tinggi', 34),
(471, 'Tebo', 8),
(472, 'Tegal', 10),
(473, 'Tegal', 10),
(474, 'Teluk Bintuni', 25),
(475, 'Teluk Wondama', 25),
(476, 'Temanggung', 10),
(477, 'Ternate', 20),
(478, 'Tidore Kepulauan', 20),
(479, 'Timor Tengah Selatan', 23),
(480, 'Timor Tengah Utara', 23),
(481, 'Toba Samosir', 34),
(482, 'Tojo Una-Una', 29),
(483, 'Toli-Toli', 29),
(484, 'Tolikara', 24),
(485, 'Tomohon', 31),
(486, 'Toraja Utara', 28),
(487, 'Trenggalek', 11),
(488, 'Tual', 19),
(489, 'Tuban', 11),
(490, 'Tulang Bawang', 18),
(491, 'Tulang Bawang Barat', 18),
(492, 'Tulungagung', 11),
(493, 'Wajo', 28),
(494, 'Wakatobi', 30),
(495, 'Waropen', 24),
(496, 'Way Kanan', 18),
(497, 'Wonogiri', 10),
(498, 'Wonosobo', 10),
(499, 'Yahukimo', 24),
(500, 'Yalimo', 24),
(501, 'Yogyakarta', 5);

INSERT INTO accounts (
    username,
    email,
    password_hash,
    full_name,
    phone_number,
    gender,
    birth_date,
    profile_picture_url,
    is_seller,
    pin_hash,
    created_at,
    updated_at
)
VALUES
(
    'Houtarou',
    'houtarou@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Oreki Houtarou',
    '12312312312312',
    'male',
    '1997-04-28',
    '',
    TRUE,
    '$2a$10$S79REKyY5hgF3OdP6hv/tOdOss/TFzkgoXhdM1OASOd7Tg/3FSLO2',
    now(),
    now()
),
(
    'Eru',
    'eru@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Chitanda Eru',
    '12312312312312',
    'female',
    '1997-10-28',
    '',
    FALSE,
    '$2a$10$S79REKyY5hgF3OdP6hv/tOdOss/TFzkgoXhdM1OASOd7Tg/3FSLO2',
    now(),
    now()
), 
(
    'Mayaka',
    'mayaka@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Ibara Mayaka',
    '123123123123',
    'female',
    '1997-10-29',
    '',
    FALSE,
    NULL,
    now(),
    now()
),
(
    'Satoshi',
    'satoshi@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Fukube Satoshi',
    '123123123123',
    'male',
    '1997-05-03',
    '',
    TRUE,
    '$2a$10$S79REKyY5hgF3OdP6hv/tOdOss/TFzkgoXhdM1OASOd7Tg/3FSLO2',
    now(),
    now()
),
(
    'Tomoe',
    'tomoe@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Oreki Tomoe',
    '123123123123',
    'female',
    '1993-02-01',
    '',
    FALSE,
    NULL,
    now(),
    now()
),
(
    'Kaho',
    'kaho@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Juumonji Kaho',
    '123123123123',
    'female',
    '1997-07-02',
    '',
    TRUE,
    '$2a$10$S79REKyY5hgF3OdP6hv/tOdOss/TFzkgoXhdM1OASOd7Tg/3FSLO2',
    now(),
    now()
),
(
    'Fuyumi',
    'fuyumi@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Irisu Fuyumi',
    '123123123123',
    'female',
    '1996-03-23',
    '',
    FALSE,
    NULL,
    now(),
    now()
),
(
    'Koreyuki',
    'koreyuki@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Tani Koreyuki',
    '123123123123',
    'male',
    '1997-08-14',
    '',
    FALSE,
    NULL,
    now(),
    now()
),
(
    'Shouko',
    'shouko@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Yuasa Shouko',
    '123123123123',
    'female',
    '1966-05-10',
    '',
    FALSE,
    NULL,
    now(),
    now()
),
(
    'Muneyoshi',
    'muneyoshi@gmail.com',
    '$2a$10$QwZAb/ef4SX6GDtOD/ZTQubz2HaZ4huMIEGXbnu//J5SWimEe9KTu',
    'Kugayama Muneyoshi',
    '123123123123',
    'male',
    '1996-01-16',
    '',
    FALSE,
    NULL,
    now(),
    now()
);

INSERT INTO shops (name, account_id, created_at, updated_at)
VALUES
('Oreki Shop', 1, now(), now()),
('SatoShop', 4, now(), now()),
('Kaho Store', 6, now(), now());

INSERT INTO account_addresses (
    receiver_name,
    receiver_phone_number,
    detail,
    is_shop,
    is_default,
    province_id,
    district_id,
    postal_code,
    account_id,
    created_at,
    updated_at
)
VALUES
(
    'oreki address 1',
    '085123123123',
    'Oreki street',
    TRUE,
    FALSE,
    21,
    1,
    '12345',
    1,
    now(),
    now()
),
(
    'oreki address 2',
    '085812312312',
    'Oshop2 street',
    FALSE,
    TRUE,
    21,
    2,
    '12345',
    1,
    now(),
    now()
),
(
    'chitanda',
    '085812312312',
    'Chitanda street',
    FALSE,
    TRUE,
    21,
    2,
    '12345',
    2,
    now(),
    now()
),
(
    'mayaka',
    '085812312312',
    'Mayaka street',
    FALSE,
    TRUE,
    21,
    3,
    '12345',
    3,
    now(),
    now()
),
(
    'satoshi store',
    '085812312312',
    'Satoshi store default street',
    TRUE,
    TRUE,
    20,
    2,
    '12345',
    4,
    now(),
    now()
),
(
    'tomoe',
    '085812312312',
    'Tomoe street',
    FALSE,
    TRUE,
    2,
    3,
    '12345',
    5,
    now(),
    now()
),
(
    'kaho',
    '085812312312',
    'Kaho default street',
    FALSE,
    TRUE,
    22,
    3,
    '12345',
    6,
    now(),
    now()
),
(
    'kaho store',
    '085812312312',
    'Kaho store street',
    TRUE,
    FALSE,
    21,
    4,
    '12345',
    6,
    now(),
    now()
),
(
    'kaho no',
    '085812312312',
    'Kaho no street',
    FALSE,
    FALSE,
    12,
    3,
    '12345',
    6,
    now(),
    now()
),
(
    'fuyumi',
    '085812312312',
    'Fuyumi street',
    FALSE,
    TRUE,
    3,
    2,
    '12345',
    7,
    now(),
    now()
),
(
    'koreyuki',
    '085812312312',
    'Koreyuki street',
    FALSE,
    TRUE,
    14,
    2,
    '12345',
    8,
    now(),
    now()
),
(
    'shouko',
    '085812312312',
    'Shouko street',
    FALSE,
    TRUE,
    4,
    3,
    '12345',
    9,
    now(),
    now()
),
(
    'muneyoshi',
    '085812312312',
    'Muneyoshi street',
    FALSE,
    TRUE,
    10,
    1,
    '12345',
    10,
    now(),
    now()
);

INSERT INTO products (
    name,
    product_code,
    description,
    thumbnail_url,
    seller_id,
    weight,
    created_at,
    updated_at
)
VALUES
(
    'Shirt',
    'Shirt-98dba795-273e-435f-868b-374a4abc7e3f',
    'shirt desc',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    1,
    50,
    now(),
    now()
),
(
    'Rice',
    'Rice-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'rice desc',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    1,
    500,
    now(),
    now()
),
(
    'Pen',
    'Pen-70b5f62a-040e-4546-b096-a303064a9d03',
    'pen desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    10,
    now(),
    now()
),
(
    'Tumbler',
    'Tumbler-70b5f62a-040e-4546-b096-a303064a9d03',
    'tumbler desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    300,
    now(),
    now()
),
(
    'Mouse',
    'Mouse-70b5f62a-040e-4546-b096-a303064a9d03',
    'Mouse desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    200,
    now(),
    now()
),
(
    'Playing Card',
    'Playing Card-70b5f62a-040e-4546-b096-a303064a9d03',
    'Playing Card desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    150,
    now(),
    now()
),
(
    'Bag',
    'Bag-70b5f62a-040e-4546-b096-a303064a9d03',
    'Bag desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    220,
    now(),
    now()
),
(
    'TWS',
    'TWS-70b5f62a-040e-4546-b096-a303064a9d03',
    'TWS desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    70,
    now(),
    now()
),
(
    'Mouse Pad',
    'Mouse Pad-70b5f62a-040e-4546-b096-a303064a9d03',
    'Mouse Pad desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    400,
    now(),
    now()
),
(
    'T-Shirt',
    'T-Shirt-70b5f62a-040e-4546-b096-a303064a9d03',
    'T-Shirt desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    100,
    now(),
    now()
),
(
    'Ice Cream',
    'Ice Cream-70b5f62a-040e-4546-b096-a303064a9d03',
    'Ice Cream desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    200,
    now(),
    now()
),
(
    'Jewel',
    'Jewel-70b5f62a-040e-4546-b096-a303064a9d03',
    'Jewel desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    100,
    now(),
    now()
),
(
    'Spoon',
    'Spoon-70b5f62a-040e-4546-b096-a303064a9d03',
    'Spoon desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    300,
    now(),
    now()
),
(
    'Fork',
    'Fork-70b5f62a-040e-4546-b096-a303064a9d03',
    'Fork desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    300,
    now(),
    now()
),
(
    'Knife',
    'Knife-70b5f62a-040e-4546-b096-a303064a9d03',
    'Knife desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    500,
    now(),
    now()
),
(
    'Pan',
    'Pan-70b5f62a-040e-4546-b096-a303064a9d03',
    'Pan desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    1500,
    now(),
    now()
),
(
    'Pot',
    'Pot-70b5f62a-040e-4546-b096-a303064a9d03',
    'Pot desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    2100,
    now(),
    now()
),
(
    'Jar',
    'Jar-70b5f62a-040e-4546-b096-a303064a9d03',
    'Jar desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    900,
    now(),
    now()
),
(
    'Mug Glass',
    'Mug Glass-70b5f62a-040e-4546-b096-a303064a9d03',
    'Mug Glass desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    400,
    now(),
    now()
),
(
    'Mug Ceramic',
    'Mug Ceramic-70b5f62a-040e-4546-b096-a303064a9d03',
    'Mug Ceramic desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    600,
    now(),
    now()
),
(
    'Stainless Straw',
    'Stainless Straw-70b5f62a-040e-4546-b096-a303064a9d03',
    'Stainless Straw desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    20,
    now(),
    now()
),
(
    'Coffee Bean',
    'Coffee Bean-70b5f62a-040e-4546-b096-a303064a9d03',
    'Coffee Bean desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    200,
    now(),
    now()
),
(
    'Basketball Ball',
    'Basketball Ball-70b5f62a-040e-4546-b096-a303064a9d03',
    'Basketball Ball desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    1,
    600,
    now(),
    now()
),
(
    'Fresh Milk',
    'Fresh Milk-70b5f62a-040e-4546-b096-a303064a9d03',
    'Fresh Milk desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    450,
    now(),
    now()
),
(
    'Greenfields',
    'Greenfields-70b5f62a-040e-4546-b096-a303064a9d03',
    'Greenfields desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    500,
    now(),
    now()
),
(
    'Milo',
    'Milo-70b5f62a-040e-4546-b096-a303064a9d03',
    'Milo desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    300,
    now(),
    now()
),
(
    'Oatside',
    'Oatside-70b5f62a-040e-4546-b096-a303064a9d03',
    'Oatside desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    600,
    now(),
    now()
),
(
    'Hyoukamilk',
    'Hyoukamilk-70b5f62a-040e-4546-b096-a303064a9d03',
    'Hyoukamilk desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    200,
    now(),
    now()
),
(
    'Hyouka Flag',
    'Hyouka Flag-70b5f62a-040e-4546-b096-a303064a9d03',
    'Hyouka Flag desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    440,
    now(),
    now()
),
(
    'Chadburry',
    'Chadburry-70b5f62a-040e-4546-b096-a303064a9d03',
    'Chadburry desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    6,
    40,
    now(),
    now()
),
(
    'Vanhooten',
    'Vanhooten-70b5f62a-040e-4546-b096-a303064a9d03',
    'Vanhooten desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    6,
    140,
    now(),
    now()
),
(
    'Gold King',
    'Gold King-70b5f62a-040e-4546-b096-a303064a9d03',
    'Gold King desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    6,
    40,
    now(),
    now()
),
(
    'Chukae Bar',
    'Chukae Bar-70b5f62a-040e-4546-b096-a303064a9d03',
    'Chukae Bar desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    6,
    100,
    now(),
    now()
),
(
    'Orange Pulp',
    'Orange Pulp-70b5f62a-040e-4546-b096-a303064a9d03',
    'Orange Pulp desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    450,
    now(),
    now()
),
(
    'FruitVita',
    'FruitVita-70b5f62a-040e-4546-b096-a303064a9d03',
    'FruitVita desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    500,
    now(),
    now()
),
(
    'Pocira Sweet',
    'Pocira Sweet-70b5f62a-040e-4546-b096-a303064a9d03',
    'Pocira Sweet desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    90,
    now(),
    now()
),
(
    'Nessicafe',
    'Nessicafe-70b5f62a-040e-4546-b096-a303064a9d03',
    'Nessicafe desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    100,
    now(),
    now()
),
(
    'Coffee Ship',
    'Coffee Ship-70b5f62a-040e-4546-b096-a303064a9d03',
    'Coffee Ship desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    200,
    now(),
    now()
),
(
    'CoffeeKo',
    'CoffeeKo-70b5f62a-040e-4546-b096-a303064a9d03',
    'CoffeeKo desc',
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    4,
    110,
    now(),
    now()
);

INSERT INTO product_medias (
    media_url,
    media_type,
    product_id,
    created_at,
    updated_at
)
VALUES
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    1,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    2,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    3,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    4,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    5,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    6,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    7,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    8,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    9,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    10,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    11,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    12,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    13,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    14,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    15,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    16,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    17,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    18,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    19,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    20,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    21,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    22,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    23,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    24,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    25,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    26,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    27,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    28,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    29,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    30,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    31,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    32,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    33,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    34,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    35,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    36,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    37,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    38,
    now(),
    now()
),
(
    'https://images.tokopedia.net/img/cache/900/VqbcmM/2021/3/21/19e19780-4bf2-46b7-bbc7-8ebf4652e0ee.jpg',
    'image',
    39,
    now(),
    now()
);

INSERT INTO variant_groups (name, product_id, created_at, updated_at)
VALUES
('color', 1, now(), now()),
('size', 1, now(), now()),
('size', 2, now(), now()),
('default', 2, now(), now()),
('default', 3, now(), now()),
('default', 3, now(), now()),
('default', 4, now(), now()),
('default', 4, now(), now()),
('default', 5, now(), now()),
('default', 5, now(), now()),
('default', 6, now(), now()),
('default', 6, now(), now()),
('default', 7, now(), now()),
('default', 7, now(), now()),
('default', 8, now(), now()),
('default', 8, now(), now()),
('default', 9, now(), now()),
('default', 9, now(), now()),
('default', 10, now(), now()),
('default', 10, now(), now()),
('default', 11, now(), now()),
('default', 11, now(), now()),
('default', 12, now(), now()),
('default', 12, now(), now()),
('default', 13, now(), now()),
('default', 13, now(), now()),
('default', 14, now(), now()),
('default', 14, now(), now()),
('default', 15, now(), now()),
('default', 15, now(), now()),
('default', 16, now(), now()),
('default', 16, now(), now()),
('default', 17, now(), now()),
('default', 17, now(), now()),
('default', 18, now(), now()),
('default', 18, now(), now()),
('default', 19, now(), now()),
('default', 19, now(), now()),
('default', 20, now(), now()),
('default', 20, now(), now()),
('default', 21, now(), now()),
('default', 21, now(), now()),
('default', 22, now(), now()),
('default', 22, now(), now()),
('default', 23, now(), now()),
('default', 23, now(), now()),
('default', 24, now(), now()),
('default', 24, now(), now()),
('default', 25, now(), now()),
('default', 25, now(), now()),
('default', 26, now(), now()),
('default', 26, now(), now()),
('default', 27, now(), now()),
('default', 27, now(), now()),
('default', 28, now(), now()),
('default', 28, now(), now()),
('default', 29, now(), now()),
('default', 29, now(), now()),
('default', 30, now(), now()),
('default', 30, now(), now()),
('default', 31, now(), now()),
('default', 31, now(), now()),
('default', 32, now(), now()),
('default', 32, now(), now()),
('default', 33, now(), now()),
('default', 33, now(), now()),
('default', 34, now(), now()),
('default', 34, now(), now()),
('default', 35, now(), now()),
('default', 35, now(), now()),
('default', 36, now(), now()),
('default', 36, now(), now()),
('default', 37, now(), now()),
('default', 37, now(), now()),
('default', 38, now(), now()),
('default', 38, now(), now()),
('default', 39, now(), now()),
('default', 39, now(), now());

INSERT INTO variant_types (name, variant_group_id, created_at, updated_at)
VALUES
('default', 1, now(), now()),
('red', 1, now(), now()),
('blue', 1, now(), now()),
('default', 2, now(), now()),
('L', 2, now(), now()),
('default', 3, now(), now()),
('0.5L', 3, now(), now()),
('1L', 3, now(), now()),
('default', 4, now(), now()),
('default', 5, now(), now()),
('default', 6, now(), now()),
('default', 7, now(), now()),
('default', 8, now(), now()),
('default', 9, now(), now()),
('default', 10, now(), now()),
('default', 11, now(), now()),
('default', 12, now(), now()),
('default', 13, now(), now()),
('default', 14, now(), now()),
('default', 15, now(), now()),
('default', 16, now(), now()),
('default', 17, now(), now()),
('default', 18, now(), now()),
('default', 19, now(), now()),
('default', 20, now(), now()),
('default', 21, now(), now()),
('default', 22, now(), now()),
('default', 23, now(), now()),
('default', 24, now(), now()),
('default', 25, now(), now()),
('default', 26, now(), now()),
('default', 27, now(), now()),
('default', 28, now(), now()),
('default', 29, now(), now()),
('default', 30, now(), now()),
('default', 31, now(), now()),
('default', 32, now(), now()),
('default', 33, now(), now()),
('default', 34, now(), now()),
('default', 35, now(), now()),
('default', 36, now(), now()),
('default', 37, now(), now()),
('default', 38, now(), now()),
('default', 39, now(), now()),
('default', 40, now(), now()),
('default', 41, now(), now()),
('default', 42, now(), now()),
('default', 43, now(), now()),
('default', 44, now(), now()),
('default', 45, now(), now()),
('default', 46, now(), now()),
('default', 47, now(), now()),
('default', 48, now(), now()),
('default', 49, now(), now()),
('default', 50, now(), now()),
('default', 51, now(), now()),
('default', 52, now(), now()),
('default', 53, now(), now()),
('default', 54, now(), now()),
('default', 55, now(), now()),
('default', 56, now(), now()),
('default', 57, now(), now()),
('default', 58, now(), now()),
('default', 59, now(), now()),
('default', 60, now(), now()),
('default', 61, now(), now()),
('default', 62, now(), now()),
('default', 63, now(), now()),
('default', 64, now(), now()),
('default', 65, now(), now()),
('default', 66, now(), now()),
('default', 67, now(), now()),
('default', 68, now(), now()),
('default', 69, now(), now()),
('default', 70, now(), now()),
('default', 71, now(), now()),
('default', 72, now(), now()),
('default', 73, now(), now()),
('default', 74, now(), now()),
('default', 75, now(), now()),
('default', 76, now(), now()),
('default', 77, now(), now()),
('default', 78, now(), now());


INSERT INTO product_variants (
    price,
    stock,
    discount,
    product_id,
    variant_type1_id,
    variant_type2_id,
    created_at,
    updated_at
)
VALUES
(100000, 100, 5, 1, 2, 5, now(), now()),
(200000, 10, 0, 1, 3, 5, now(), now()),
(250000, 10, 0, 2, 7, 9, now(), now()),
(500000, 10, 0, 2, 8, 9, now(), now()),
(20000, 50, 10, 3, 10, 11, now(), now()),
(230000, 20, 5, 4, 12, 13, now(), now()),
(600000, 10, 0, 5, 14, 15, now(), now()),
(100000, 10, 23, 6, 16, 17, now(), now()),
(300000, 10, 20, 7, 18, 19, now(), now()),
(1500000, 10, 2, 8, 20, 21, now(), now()),
(90000, 50, 15, 9, 22, 23, now(), now()),
(200000, 50, 30, 10, 24, 25, now(), now()),
(200000, 50, 10, 11, 26, 27, now(), now()),
(2000000, 5, 1, 12, 28, 29, now(), now()),
(50000, 50, 10, 13, 30, 31, now(), now()),
(45000, 50, 10, 14, 32, 33, now(), now()),
(50000, 25, 5, 15, 34, 35, now(), now()),
(300000, 10, 5, 16, 36, 37, now(), now()),
(400000, 20, 0, 17, 38, 39, now(), now()),
(30000, 50, 12, 18, 40, 41, now(), now()),
(10000, 50, 15, 19, 42, 43, now(), now()),
(25000, 50, 10, 20, 44, 45, now(), now()),
(10000, 50, 20, 21, 46, 47, now(), now()),
(260000, 50, 0, 22, 48, 49, now(), now()),
(80000, 25, 0, 23, 50, 51, now(), now()),
(40000, 10, 0, 24, 52, 53, now(), now()),
(50000, 50, 0, 25, 53, 55, now(), now()),
(30000, 50, 0, 26, 56, 57, now(), now()),
(60000, 50, 0, 27, 58, 59, now(), now()),
(30000, 50, 0, 28, 60, 61, now(), now()),
(14000, 50, 0, 29, 62, 63, now(), now()),
(14000, 50, 0, 30, 64, 65, now(), now()),
(17000, 50, 0, 31, 66, 67, now(), now()),
(16000, 50, 0, 32, 68, 69, now(), now()),
(24000, 50, 10, 33, 70, 71, now(), now()),
(6000, 50, 10, 34, 72, 73, now(), now()),
(7200, 50, 10, 35, 74, 75, now(), now()),
(6000, 50, 10, 36, 76, 77, now(), now()),
(7000, 50, 10, 37, 78, 79, now(), now()),
(15000, 50, 10, 38, 80, 81, now(), now()),
(7000, 50, 10, 39, 82, 83, now(), now());

INSERT INTO carts (
    quantity,
    is_checked,
    product_variant_id,
    account_id,
    seller_id,
    created_at,
    updated_at
)
VALUES
(5, FALSE, 1, 2, 1, now(), now()),
(1, FALSE, 2, 2, 1, now(), now()),
(1, FALSE, 23, 2, 1, now(), now()),
(1, FALSE, 24, 2, 4, now(), now()),
(1, FALSE, 7, 2, 1, now(), now()),
(1, FALSE, 28, 2, 4, now(), now()),
(1, FALSE, 31, 2, 6, now(), now()),
(1, FALSE, 26, 2, 4, now(), now()),
(1, FALSE, 39, 2, 4, now(), now()),
(1, FALSE, 18, 7, 1, now(), now()),
(1, FALSE, 14, 7, 1, now(), now()),
(1, FALSE, 17, 5, 1, now(), now()),
(1, FALSE, 12, 5, 1, now(), now()),
(1, FALSE, 22, 3, 1, now(), now()),
(1, FALSE, 28, 3, 4, now(), now()),
(1, FALSE, 26, 2, 4, now(), now()),
(1, FALSE, 30, 2, 6, now(), now()),
(1, FALSE, 32, 2, 6, now(), now());

INSERT INTO wallets (
    balance,
    is_active,
    category,
    account_id,
    created_at,
    updated_at
)
VALUES
(5000000, TRUE, 'USER', 1, now(), now()),
(5000000, TRUE, 'TEMP', 1, now(), now()),
(5000000, TRUE, 'SHOP', 1, now(), now()),
(5000000, TRUE, 'USER', 2, now(), now()),
(5000000, TRUE, 'TEMP', 2, now(), now()),
(0, FALSE, 'USER', 3, now(), now()),
(0, FALSE, 'TEMP', 3, now(), now()),
(5000000, TRUE, 'USER', 4, now(), now()),
(5000000, TRUE, 'TEMP', 4, now(), now()),
(5000000, TRUE, 'SHOP', 4, now(), now()),
(0, FALSE, 'USER', 5, now(), now()),
(0, FALSE, 'TEMP', 5, now(), now()),
(5000000, TRUE, 'USER', 6, now(), now()),
(5000000, TRUE, 'TEMP', 6, now(), now()),
(5000000, TRUE, 'SHOP', 6, now(), now()),
(0, FALSE, 'USER', 7, now(), now()),
(0, FALSE, 'TEMP', 7, now(), now()),
(0, FALSE, 'USER', 8, now(), now()),
(0, FALSE, 'TEMP', 8, now(), now()),
(0, FALSE, 'USER', 9, now(), now()),
(0, FALSE, 'TEMP', 9, now(), now()),
(0, FALSE, 'USER', 10, now(), now()),
(0, FALSE, 'TEMP', 10, now(), now());

INSERT INTO couriers (
    name,
    code,
    service_name,
    description,
    image_url
)
VALUES
('JNE', 'jne', 'REG', 'JNE Reguler adalah paket reguler yang ditawarkan JNE. Kecepatan pengiriman tergantung dari lokasi pengiriman dan lokasi tujuan. Untuk kota yang sama, umumnya memakan waktu 2-3 hari.', 'https://images.tokopedia.net/img/kurir-jne.png'),
('Tiki', 'tiki', 'REG', 'TIKI Paket Reguler adalah paket yang dapat menjangkau seluruh Indonesia hanya dalam waktu kurang dari 7 hari kerja.', 'https://images.tokopedia.net/img/kurir-tiki.png'),
('Pos Indonesia', 'pos', 'Pos Reguler', 'Gunakan Pos Reguler, sebagai pilihan tepat untuk pengiriman Suratpos yang mengandalkan kecepatan kiriman dan menjangkau ke seluruh pelosok Indonesia.', 'https://images.tokopedia.net/img/kurir-pos-aja.png');

INSERT INTO shop_couriers (
    shop_id,
    courier_id,
    is_available
)
VALUES
(1, 1, TRUE),
(1, 2, TRUE),
(1, 3, TRUE),
(2, 1, TRUE),
(2, 2, TRUE),
(2, 3, FALSE),
(3, 1, TRUE),
(3, 2, FALSE),
(3, 3, FALSE);

INSERT INTO transactions (amount, title, from_wallet_id, to_wallet_id)
VALUES
(320000, 'PAYMENT-ORDER', 4, 5),
(420000, 'PAYMENT-ORDER', 4, 5),
(220000, 'PAYMENT-ORDER', 4, 5),
(520000, 'PAYMENT-ORDER', 4, 5),
(270000, 'PAYMENT-ORDER', 4, 5),
(270000, 'TRANSFER-ORDER', 5, 3),
(40000, 'PAYMENT-ORDER', 4, 5),
(40000, 'REFUND-ORDER', 5, 4),
(920000, 'PAYMENT-ORDER', 4, 5),
(420000, 'PAYMENT-ORDER', 4, 5),
(110000, 'PAYMENT-ORDER', 4, 5),
(250000, 'PAYMENT-ORDER', 4, 5),
(270000, 'PAYMENT-ORDER', 4, 5),
(170000, 'PAYMENT-ORDER', 4, 5),
(220000, 'PAYMENT-ORDER', 4, 5),
(80000, 'PAYMENT-ORDER', 4, 5),
(37000, 'PAYMENT-ORDER', 4, 5),
(260000, 'PAYMENT-ORDER', 4, 5),
(50000, 'PAYMENT-ORDER', 4, 5),
(120000, 'PAYMENT-ORDER', 4, 5),
(65000, 'PAYMENT-ORDER', 4, 5),
(620000, 'PAYMENT-ORDER', 4, 5),
(620000, 'TRANSFER-ORDER', 4, 5),
(50000, 'PAYMENT-ORDER', 4, 5),
(50000, 'TRANSFER-ORDER', 4, 5),
(55000, 'PAYMENT-ORDER', 4, 5),
(55000, 'REFUND-ORDER', 5, 4),
(170000, 'PAYMENT-ORDER', 4, 5),
(170000, 'REFUND-ORDER', 5, 4),
(30000, 'PAYMENT-ORDER', 4, 5);

INSERT INTO orders (
    status,
    estimated_time_arrival,
    delivery_cost,
    courier_id,
    seller_id,
    buyer_id,
    transaction_id,
    created_at,
    updated_at
)
VALUES

('NEW', NULL, 20000, 1, 1, 2, 1, now(), now()),
('PROCESS', NULL, 20000, 2, 1, 2, 2, now(), now()),
('DELIVER', '2023-11-17 00:00:00', 20000, 3, 1, 2, 3, now(), now()),
('ARRIVE', '2023-11-14 00:00:00', 20000, 1, 1, 2, 4, now(), now()),
('RECEIVE', '2023-11-13 00:00:00', 20000, 2, 1, 2, 5, now(), now()),
('CANCEL', NULL, 20000, 3, 1, 2, 7, now(), now()),
('NEW', NULL, 20000, 1, 1, 2, 9, now(), now()),
('NEW', NULL, 20000, 2, 1, 2, 10, now(), now()),
('NEW', NULL, 20000, 3, 1, 2, 11, now(), now()),
('PROCESS', NULL, 20000, 1, 1, 2, 12, now(), now()),
('PROCESS', NULL, 20000, 2, 1, 2, 13, now(), now()),
('PROCESS', NULL, 20000, 3, 1, 2, 14, now(), now()),
('PROCESS', NULL, 20000, 3, 4, 2, 15, now(), now()),
('DELIVER', '2023-11-20 00:00:00', 20000, 2, 4, 2, 16, now(), now()),
('DELIVER', '2023-11-22 00:00:00', 20000, 3, 6, 2, 17, now(), now()),
('DELIVER', '2023-11-23 00:00:00', 20000, 1, 6, 2, 18, now(), now()),
('DELIVER', '2023-11-24 00:00:00', 20000, 1, 1, 2, 19, now(), now()),
('ARRIVE', '2023-11-20 00:00:00', 20000, 2, 1, 2, 20, now(), now()),
('ARRIVE', '2023-11-21 00:00:00', 20000, 1, 1, 2, 21, now(), now()),
('RECEIVE', '2023-11-22 00:00:00', 20000, 2, 1, 2, 22, now(), now()),
('RECEIVE', '2023-11-22 00:00:00', 20000, 1, 6, 2, 24, now(), now()),
('CANCEL', NULL, 20000, 2, 4, 2, 26, now(), now()),
('CANCEL', NULL, 20000, 2, 4, 2, 28, now(), now()),
('ARRIVE', '2023-11-22 00:00:00', 30000, 1, 1, 2, 29, now(), now());

INSERT INTO order_details (
    order_id,
    product_code,
    product_name,
    thumbnail_url,
    variant_name,
    sub_total_price,
    quantity,
    created_at,
    updated_at
)
VALUES
(
    1,
    'Shirt-98dba795-273e-435f-868b-374a4abc7e3f',
    'Shirt',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    'red-L',
    600000,
    3,
    now(),
    now()
),
(
    2,
    'Shirt-98dba795-273e-435f-868b-374a4abc7e3f',
    'Shirt',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    'blue-XL',
    500000,
    2,
    now(),
    now()
),
(
    3,
    'Shirt-98dba795-273e-435f-868b-374a4abc7e3f',
    'Shirt',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    'blue-XL',
    500000,
    1,
    now(),
    now()
),
(
    4,
    'Rice-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Rice',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '1L',
    500000,
    1,
    now(),
    now()
),
(
    5,
    'Rice-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Rice',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '0.5L',
    500000,
    1,
    now(),
    now()
),
(
    6,
    'Pen-70b5f62a-040e-4546-b096-a303064a9d03',
    'Pen',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    'small-blue',
    10000,
    1,
    now(),
    now()
),
(
    7,
    'Rice-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Rice',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '1L',
    1000000,
    1,
    now(),
    now()
),
(
    7,
    'Shirt-98dba795-273e-435f-868b-374a4abc7e3f',
    'Shirt',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    'blue-XL',
    500000,
    2,
    now(),
    now()
),
(
    8,
    'T-Shirt-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'T-Shirt',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    400000,
    2,
    now(),
    now()
),
(
    9,
    'Mouse Pad-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Mouse Pad',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    90000,
    1,
    now(),
    now()
),
(
    10,
    'Tumbler-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Tumbler',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    230000,
    1,
    now(),
    now()
),
(
    11,
    'Spoon-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Spoon',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    250000,
    5,
    now(),
    now()
),
(
    12,
    'Knife-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Knife',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    150000,
    3,
    now(),
    now()
),
(
    13,
    'Greenfields-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Greenfields',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    200000,
    4,
    now(),
    now()
),
(
    14,
    'Oatside-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Oatside',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    60000,
    1,
    now(),
    now()
),
(
    15,
    'Vanhooten-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Vanhooten',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    17000,
    1,
    now(),
    now()
),
(
    16,
    'Chukae Bar-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Chukae Bar',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    240000,
    10,
    now(),
    now()
),
(
    17,
    'Jar-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Jar',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    30000,
    1,
    now(),
    now()
),
(
    18,
    'Stainless Straw-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Stainless Straw',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    100000,
    10,
    now(),
    now()
),
(
    19,
    'Fork-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Fork',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    45000,
    1,
    now(),
    now()
),
(
    20,
    'Bag-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Bag',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    600000, 
    2,
    now(),
    now()
),
(
    21,
    'Gold King-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Gold King',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    30000,
    1,
    now(),
    now()
),
(
    22,
    'Nessicafe-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Nessicafe',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    35000,
    5,
    now(),
    now()
),
(
    23,
    'Coffee Ship-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Coffee Ship',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    150000, 
    10,
    now(),
    now()
),
(
    24,
    'Coffee Ship-bc2a61d7-362f-48b2-9634-ab26ca845769',
    'Coffee Ship',
    'https://images.tokopedia.net/img/cache/100-square/VqbcmM/2023/10/16/9a895898-56d6-4430-b338-bbd43107f091.png.webp?ect=4g',
    '-',
    150000, 
    10,
    now(),
    now()
);

INSERT INTO categories (
    name,
    level,
    image_url,
    parent_category,
    created_at,
    updated_at
)
VALUES
(
    'Pakaian Wanita',
    1,
    'https://cf.shopee.sg/file/8238b032554f70a7a42630c3ed1795f6',
    NULL,
    now(),
    now()
),
(
    'Atasan',
    2,
    'https://cf.shopee.sg/file/5890daabcfae9d6ae13a5521c2659293',
    1,
    now(),
    now()
),
(
    'Kaos',
    3,
    'https://cf.shopee.sg/file/c6fbc3053b53a3bc8dd18fe928439651',
    2,
    now(),
    now()
),
(
    'Makanan & Minuman',
    1,
    'https://cf.shopee.sg/file/73c39892446e1a4f27de802ed83f28c8',
    NULL,
    now(),
    now()
),
(
    'Bahan Pokok',
    2,
    'https://cf.shopee.sg/file/54b7552727cbf5cb55fa1af8fa7729a6',
    4,
    now(),
    now()
),
(
    'Beras',
    3,
    'https://cf.shopee.sg/file/6e8a364693f7089000a1b02549b8d809',
    5,
    now(),
    now()
),
(
    'Buku & Alat Tulis',
    1,
    'https://cf.shopee.sg/file/3f57a0d70709300d96e800641ec80679',
    NULL,
    now(),
    now()
),
(
    'Alat Tulis',
    2,
    'https://cf.shopee.sg/file/fabd9d28cfaf163b37de0a24fc409dcd',
    7,
    now(),
    now()
),
(
    'Pulpen',
    3,
    'https://cf.shopee.sg/file/0ccc4930c22e5de04112fb8cba47b6f3',
    8,
    now(),
    now()
);

INSERT INTO product_categories (
    product_id,
    category_id,
    created_at,
    updated_at
)
VALUES
(1, 1, now(), now()),
(1, 2, now(), now()),
(1, 3, now(), now()),
(2, 4, now(), now()),
(2, 5, now(), now()),
(2, 6, now(), now()),
(3, 7, now(), now()),
(3, 8, now(), now()),
(3, 9, now(), now());

INSERT INTO wishlists (account_id, product_id)
VALUES
(2,1),
(2,2),
(2,3),
(2,5),
(2,8),
(2,13),
(2,21),
(2,34),
(2,23),
(1,25),
(1,12),
(1,23),
(3,15),
(3,13),
(3,16),
(5,13),
(5,29),
(8,27),
(8,22),
(4,21),
(6,20),
(3,10),
(8,4),
(2,4),
(2,6),
(2,7),
(2,9),
(2,10),
(2,11),
(2,12),
(2,15);

INSERT INTO promotions (
	name, 
	exact_price, 
	percentage, 
	minimum_spend, 
	quota, 
	shop_id, 
	started_at, 
	expired_at, 
	created_at, 
	updated_at
) VALUES
('Oreki Shop promo exact', 5000, NULL, 50000, 10, 1, '2023-11-20 00:00:00', '2023-12-20 00:00:00', '2023-11-20 00:00:00', '2023-11-20 00:00:00'),
('Oreki Shop promo percentage', NULL, 5, 100000, 15, 1, '2023-11-20 00:00:00', '2023-12-20 00:00:00', '2023-11-20 00:00:00', '2023-11-20 00:00:00'),
('Oreki Shop promo ended', 5000, NULL, 50000, 10, 1, '2023-10-01 00:00:00', '2023-10-20 00:00:00', '2023-10-01 00:00:00', '2023-10-01 00:00:00'),
('Oreki Shop promo will come', 5000, NULL, 50000, 10, 1, '2023-12-01 00:00:00', '2023-12-20 00:00:00', now(), now());