-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `putera_motor`
--

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

--
-- Table structure for table `bestseller`
--

CREATE TABLE `bestseller` (
  `id_bestSeller` int(15) NOT NULL,
  `namaMotor` varchar(200) NOT NULL,
  `hargaMotor` varchar(200) NOT NULL,
  `fotoMotor` text NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bestseller`
--

INSERT INTO `bestseller` (`id_bestSeller`, `namaMotor`, `hargaMotor`, `fotoMotor`, `updated_at`, `created_at`) VALUES
(6, 'Yamaha Grand Filano Neo', '27050000', '1718853234.png', '2024-06-20 03:13:54', '2024-06-20 03:13:54'),
(7, 'YAMAHA FAZZIO', '23350000', '1719822799.png', '2024-07-01 08:33:19', '2024-07-01 08:33:19'),
(8, 'YAMAHA GEAR 125', '19220000', '1719822934.png', '2024-07-01 08:35:34', '2024-07-01 08:35:34'),
(9, 'YAMAHA LEXI LX 155', '25650000', '1719823004.png', '2024-07-01 08:36:44', '2024-07-01 08:36:44');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id_category` int(15) NOT NULL,
  `name` varchar(200) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id_category`, `name`, `updated_at`, `created_at`) VALUES
(1, 'classy', '2024-06-19 06:02:05', '2024-06-19 06:02:05'),
(2, 'maxi', '2024-06-19 06:02:05', '2024-06-19 06:02:05'),
(5, 'matic', '2024-06-19 06:02:51', '2024-06-19 06:02:51'),
(6, 'sport', '2024-06-19 06:02:51', '2024-06-19 06:02:51'),
(7, 'moped', '2024-06-21 05:47:22', '2024-06-21 05:47:22'),
(8, 'off-road', '2024-06-21 05:47:22', '2024-06-21 05:47:22');

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

--
-- Table structure for table `dealer`
--

CREATE TABLE `dealer` (
  `id_dealer` int(15) NOT NULL,
  `nama_dealer` varchar(155) NOT NULL,
  `alamat_dealer` text NOT NULL,
  `url_gmaps` text NOT NULL,
  `no_wa` varchar(255) NOT NULL,
  `foto_dealer` text NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dealer`
--

INSERT INTO `dealer` (`id_dealer`, `nama_dealer`, `alamat_dealer`, `url_gmaps`, `no_wa`, `foto_dealer`, `updated_at`, `created_at`) VALUES
(4, 'YAMAHA PUTERA TANJUNG PRIOK', '5, Jl. Kebon Bawang III No.48, RT.7/RW.8, Kb. Bawang, Kec. Tj. Priok, Jkt Utara, Daerah Khusus Ibukota Jakarta 14320', 'https://maps.app.goo.gl/wnaSBMw1o4atpJm59', '02143930651', '1718790776.JPG', '2024-06-19 09:52:56', '2024-06-19 09:52:56'),
(5, 'YAMAHA PUTERA BUARAN', '6, Jl. Buaran Raya No.11, RT.6/RW.13, Klender, Kec. Duren Sawit, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13470', 'https://maps.app.goo.gl/TJd7DXPGdYMUPEpk6', '02186601301', '1718850797.jpeg', '2024-06-20 02:33:17', '2024-06-20 02:33:17'),
(6, 'YAMAHA PUTERA PONDOK UNGU', 'Jalan Sultan Agung KM.27 No.4 RT.7/RW.5 Medan Satria Bekasi Barat, RT.001/RW.006, Medan Satria, Kecamatan Medan Satria, Kota Bks, Jawa Barat 17132', 'https://maps.app.goo.gl/YesouCft8g7tNNKX7', '02188861435', '1718851139.jpg', '2024-06-20 02:38:59', '2024-06-20 02:38:59'),
(7, 'YAMAHA PUTERA CIKARANG', 'Jalan Raya Cibarusah Cikarang, Sukaresmi, Cikarang Selatan, Sukaresmi, Cikarang Sel., Kabupaten Bekasi, Jawa Barat 17550', 'https://maps.app.goo.gl/CfGWzAm2ULkjVx9JA', '02189908513', '1718851508.JPG', '2024-06-20 02:45:08', '2024-06-20 02:45:08'),
(8, 'YAMAHA PUTERA KEDOYA', '7, Jl. Panjang No.24, RT.7/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta 11520', 'https://maps.app.goo.gl/XKQn3H2LE8YLvt36A', '0215687542', '1718851597.JPG', '2024-06-20 02:46:37', '2024-06-20 02:46:37'),
(9, 'YAMAHA PUTERA POS PENGUMBEN', '1, Jl. Raya Pos Pengumben No.37, RT.1/RW.5, Kec. Kb. Jeruk, Daerah Khusus Ibukota Jakarta 11550', 'https://maps.app.goo.gl/3gLDjALZEQZg8Sj48', '0215347651', '1718851685.jpeg', '2024-06-20 02:48:05', '2024-06-20 02:48:05'),
(10, 'YAMAHA PUTERA RAGUNAN', 'Jalan Taman Margasatwa No.22 Ragunan, RT.7/RW.5, Jati Padang, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12560', 'https://maps.app.goo.gl/2Cov1jFFMohrWvFM8', '0217807830', '1718852099.jpg', '2024-06-20 02:54:59', '2024-06-20 02:54:59'),
(11, 'YAMAHA PUTERA BOGOR', 'Jl. Merdeka No.50, RT.01/RW.08, Ciwaringin, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat 17157', 'https://maps.app.goo.gl/LPgBbuNH3dnxhCpc7', '02518357035', '1719282690.jpeg', '2024-06-25 02:31:30', '2024-06-25 02:31:30'),
(12, 'YAMAHA PUTERA BSD', 'Jl. Raya Serpong Kilometer 7 No.1C, Lengkong Karya, Kec. Serpong Utara, Kota Tangerang Selatan, Banten 15326', 'https://maps.app.goo.gl/kZPteD8EmRCHhnSe9', '0215383655', '1719282923.jpg', '2024-06-25 02:35:23', '2024-06-25 02:35:23'),
(13, 'YAMAHA PUTERA TIGARAKSA', 'Ruko I, Jl. Aria Wangsakara Blok J-K No.166, Tigaraksa, Kec. Tigaraksa, Kabupaten Tangerang, Banten 15720', 'https://maps.app.goo.gl/e2AgzZyupaUghZEg6', '0215993337', '1719282974.JPG', '2024-06-25 02:36:14', '2024-06-25 02:36:14'),
(14, 'YAMAHA PUTERA PASAR BARU', 'Jl. Moh. Toha No.105, RT.001/RW.008, Nambo Jaya, Kec. Karawaci, Kota Tangerang, Banten 15131', 'https://maps.app.goo.gl/4ty2Cprzj331GHqY9', '02155796455', '1719283099.JPG', '2024-06-25 02:38:19', '2024-06-25 02:38:19'),
(15, 'YAMAHA PUTERA CIKANDE', 'Jl. Raya Serang - Jkt No.Km.72, Tambak, Kec. Kibin, Kabupaten Serang, Banten 42185', 'https://maps.app.goo.gl/xbAvEo65vBdqLMSq9', '0254400861', '1719283572.png', '2024-06-25 02:46:12', '2024-06-25 02:46:12'),
(16, 'YAMAHA PUTERA SERANG', 'Jl. Ahmad Yani No.68A, Cipare, Kec. Serang, Serang Kota, Banten 42117', 'https://maps.app.goo.gl/SDyWnicceyxx4RhU7', '0254224775', '1719283724.JPG', '2024-06-25 02:48:44', '2024-06-25 02:48:44'),
(17, 'YAMAHA PUTERA ANYER', 'Raya, Jl. Raya Anyer-Sirih No.60, Anyar, Kec. Anyar, Kabupaten Serang, Banten 42166', 'https://maps.app.goo.gl/DEUHo8ofzJdxmMUt5', '0254601161', '1719283962.jpg', '2024-06-25 02:52:42', '2024-06-25 02:52:42'),
(18, 'YAMAHA PUTERA CILEGON', 'Jl. Lingkar cilegon km.1, kp. Cigodag, Harjatani, Kec. Kramatwatu, Kabupaten Serang, Banten 42161', 'https://maps.app.goo.gl/3JVZwtN8uYG7TkHm9', '087808931145', '1719284128.jpeg', '2024-06-25 02:55:28', '2024-06-25 02:55:28'),
(19, 'YAMAHA PUTERA LABUAN', 'Jl. Raya Perintis Kemerdekaan No.km 1, Sukamaju, Kec. Labuan, Kabupaten Pandeglang, Banten 42264', 'https://maps.app.goo.gl/zyRCniwCMAw68wET6', '0253804432', '1719284186.jpeg', '2024-06-25 02:56:26', '2024-06-25 02:56:26'),
(20, 'YAMAHA PUTERA PANDEGLANG', 'Jl. Raya Labuan - Pandeglang, Sukasari, Kec. Kaduhejo, Kabupaten Pandeglang, Banten 42252', 'https://maps.app.goo.gl/YfqHzdLqqdba9zDh8', '02535213341', '1719284282.JPG', '2024-06-25 02:58:02', '2024-06-25 02:58:02'),
(21, 'YAMAHA PUTERA RANGKASBITUNG', 'Rangkasbitung Tim., Kec. Rangkasbitung, Kabupaten Lebak, Banten 42313', 'https://maps.app.goo.gl/jJj6QQ77pxmfDcBF8', '081932044980', '1719284460.jpg', '2024-06-25 03:01:00', '2024-06-25 03:01:00'),
(22, 'YAMAHA DUTA PASAR KEMIS', 'Gelam Jaya, Kec. Ps. Kemis, Kabupaten Tangerang, Banten 15560', 'https://maps.app.goo.gl/iToeE7ZJvGTpgsqL9', '02159313180', '1719284537.jpeg', '2024-06-25 03:02:17', '2024-06-25 03:02:17'),
(23, 'YAMAHA DUTA DUREN SAWIT', 'Jl. Dermaga Raya No.319, RT.5/RW.5, Klender, Kec. Duren Sawit, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13470', 'https://maps.app.goo.gl/a9yaDizwpTaMbMqHA', '02186606969', '1719284633.jpg', '2024-06-25 03:03:53', '2024-06-25 03:03:53'),
(24, 'YAMAHA DUTA UJUNG MENTENG', '1, Jl. Raya Bekasi No.28, RW.1, Ujung Menteng, Kec. Cakung, Kota Jakarta Timur, Daerah Khusus Ibukota Jakarta 13960', 'https://maps.app.goo.gl/fZV4E65byVAEMixE6', '02146826693', '1719285031.jpg', '2024-06-25 03:10:31', '2024-06-25 03:10:31'),
(26, 'YAMAHA ERAMOTOR TANGERANG', 'Jl. RE Martadinata No.14, Ciputat, Kec. Ciputat, Kota Tangerang Selatan, Banten 15411', 'https://maps.app.goo.gl/UQYwWYzpoy587bjP9', '02122743116', '1719993546.jpeg', '2024-07-03 07:59:06', '2024-07-03 07:59:06'),
(27, 'YAMAHA ERAMOTOR JATIWARINGIN', 'Jl. Raya Jatiwaringin No.176, RT.001/RW.002, Jatiwaringin, Kec. Pd. Gede, Kota Bks, Jawa Barat 17411', 'https://maps.app.goo.gl/iMSXbi2wyCKCMQRC8', '087879350686', '1719993647.jpg', '2024-07-03 08:00:47', '2024-07-03 08:00:47'),
(28, 'YAMAHA ERAMOTOR PASAR MINGGU', 'PR6V+33j, Jl. Raya Rw. Bambu No.13, RT.13/RW.5, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12520', 'https://maps.app.goo.gl/NtQpmeP2vvspMpUx9', '085893593801', '1719993736.jpg', '2024-07-03 08:02:16', '2024-07-03 08:02:16'),
(29, 'YAMAHA BINTARA MOTOR', 'Jalan Bintara Raya No. 17 Bintara, RT.006/RW.013, Bintara Jaya, Kec. Bekasi Bar., Kota Bks, Jawa Barat 17136', 'https://maps.app.goo.gl/2qDdjdMVJhz1UEhQ8', '082299912409', '1719993798.jpg', '2024-07-03 08:03:18', '2024-07-03 08:03:18'),
(30, 'YAMAHA ERAMOTOR TAMBUN', 'Jl. Raya Teuku Umar No.8, Tambun, Kec. Tambun Sel., Kabupaten Bekasi, Jawa Barat 17510', 'https://maps.app.goo.gl/zhqgVoMCewRntkHq5', '081287996231', '1719993884.jpg', '2024-07-03 08:04:44', '2024-07-03 08:04:44'),
(31, 'YAMAHA ERAMOTOR SUKATANI', 'Jl. Pilar Sukatani Kecamatan No.52, Sukaraya, Kec. Karangbahagia, Kabupaten Bekasi, Jawa Barat 17530', 'https://maps.app.goo.gl/e7scpuqub9ZTSD4F7', '081213009989', '1719993945.jpg', '2024-07-03 08:05:45', '2024-07-03 08:05:45'),
(32, 'YAMAHA ERAMOTOR CIBARUSAH', 'Jl. Raya Serang Cibarusah, Cibarusahkota, Kec. Cibarusah, Kabupaten Bekasi, Jawa Barat 17340', 'https://maps.app.goo.gl/XRWTs8Lw48eCqGTXA', '02189282860', '1719994017.jpg', '2024-07-03 08:06:57', '2024-07-03 08:06:57'),
(33, 'YAMAHA ERAMOTOR PONDOK CABE', 'Jl. Cabe V No.22, RT.02/RW.05, Pd. Cabe Ilir, Kec. Pamulang, Kota Tangerang Selatan, Banten 15418', 'https://maps.app.goo.gl/Zois8i7a4y4PrCZy7', '081310366027', '1719994099.png', '2024-07-03 08:08:19', '2024-07-03 08:08:19'),
(34, 'YAMAHA ERAMOTOR MAMPANG', 'PRRH+29W, Jl. Buncit Raya No.37, RT.2/RW.2, Duren Tiga, Kec. Pancoran, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12760', 'https://maps.app.goo.gl/oRMBwHDZA8e1nRhT8', '082210687484', '1719994208.png', '2024-07-03 08:10:08', '2024-07-03 08:10:08');

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

--
-- Table structure for table `fotomotor`
--

CREATE TABLE `fotomotor` (
  `id_foto` int(15) NOT NULL,
  `id_motor` int(15) NOT NULL,
  `fotoNama` text NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `motor`
--

CREATE TABLE `motor` (
  `id_motor` int(15) NOT NULL,
  `namaMotor` varchar(255) NOT NULL,
  `hargaMotor` int(155) NOT NULL,
  `categoryMotor` int(5) NOT NULL,
  `tipe` varchar(155) NOT NULL,
  `deskripsiWarna` varchar(155) NOT NULL,
  `deskripsi` text NOT NULL,
  `fotoMotor` text NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `motor`
--

INSERT INTO `motor` (`id_motor`, `namaMotor`, `hargaMotor`, `categoryMotor`, `tipe`, `deskripsiWarna`, `deskripsi`, `fotoMotor`, `updated_at`, `created_at`) VALUES
(20, 'YAMAHA WR 155 R', 38900000, 8, 'wr 155 r', '[\"BLUE\",\"BLACK\"]', '[\"blue\",\"black\"]', '[\"1718957324_6675350cac3ec.png\",\"1718957324_6675350cacd95.png\"]', '2024-06-21 08:08:44', '2024-06-21 08:08:44'),
(21, 'YAMAHA VEGA FORCE', 18175000, 7, 'vega force', '[\"HITAM KUNING\",\"HITAM MERAH\"]', '[\"black\",\"red\"]', '[\"1718961901_667546ed5a75d.png\",\"1718961901_667546ed5bda3.png\"]', '2024-06-21 09:25:01', '2024-06-21 09:25:01'),
(22, 'YAMAHA X-RIDE 125', 20200000, 5, 'x-ride 125', '[\"Cyan Yellow\",\"Black Red\",\"Sand\"]', '[\"blue\",\"red\",\"grey\"]', '[\"1718962165_667547f512f63.png\",\"1718962165_667547f513872.png\",\"1718962165_667547f515d2d.png\"]', '2024-06-21 09:29:25', '2024-06-21 09:29:25'),
(23, 'YAMAHA GEAR 125', 19220000, 5, 'gear s', '[\"Matte Blue\",\"Matte Red\"]', '[\"blue\",\"red\"]', '[\"1718963490_66754d22f26d5.png\",\"1718963490_66754d22f3820.png\"]', '2024-06-21 09:51:31', '2024-06-21 09:51:31'),
(24, 'YAMAHA GEAR 125', 18505000, 5, 'gear standart', '[\"Dull Blue\",\"Red\",\"CYAN\",\"Olive\",\"BLACK\"]', '[\"#b0d4ea\",\"red\",\"cyan\",\"olive\",\"black\"]', '[\"1718963907_66754ec351732.png\",\"1718963907_66754ec352543.png\",\"1718963907_66754ec352c93.png\",\"1718963907_66754ec3533d9.png\",\"1718963907_66754ec354089.png\"]', '2024-06-26 09:12:01', '2024-06-21 09:58:27'),
(26, 'YAMAHA MX KING 150', 26225000, 7, 'mx king', '[\"RED\",\"BLUE\",\"CYAN\"]', '[\"red\",\"blue\",\"blue\"]', '[\"1719210954_667913caa2a87.png\",\"1719210954_667913caa4411.png\",\"1719210954_667913caa4ed1.png\"]', '2024-06-24 06:35:54', '2024-06-24 06:35:54'),
(27, 'YAMAHA JUPITER Z1', 20090000, 7, 'jupiter z1', '[\"Metallic Black\",\"Metallic Red\",\"Metallic Cyan\"]', '[\"black\",\"red\",\"blue\"]', '[\"1719211326_6679153e67714.png\",\"1719211326_6679153e67f34.png\",\"1719211326_6679153e685db.png\"]', '2024-06-24 06:42:06', '2024-06-24 06:42:06'),
(33, 'YAMAHA XSR 155', 38075000, 6, 'xsr 155', '[\"Metallic Red Authentic\",\"Metallic Black Elegance\",\"Matte Silver Premium\",\"Light Blue Wanderlust\"]', '[\"red\",\"black\",\"grey\",\"cyan\"]', '[\"1719295934_667a5fbe0a254.png\",\"1719295934_667a5fbe0aabe.png\",\"1719295934_667a5fbe0b1dd.png\",\"1719295934_667a5fbe0b74f.png\"]', '2024-06-25 06:13:45', '2024-06-25 04:16:01'),
(34, 'YAMAHA MT-15', 38825000, 6, 'mt 15', '[\"Metallic Dark Grey\",\"Metallic Blue\"]', '[\"grey\",\"blue\"]', '[\"1719296195_667a60c3e600f.png\",\"1719296195_667a60c3e689b.png\"]', '2024-06-25 06:16:35', '2024-06-25 04:19:11'),
(35, 'YAMAHA VIXION', 29525000, 6, 'vixion 150', '[\"Matte Blue\",\"Matte Black\",\"Metallic Red\"]', '[\"blue\",\"black\",\"red\"]', '[\"1719301261_667a748dadf36.png\",\"1719301261_667a748dae892.png\",\"1719301261_667a748daeef4.png\"]', '2024-06-25 07:41:01', '2024-06-25 07:09:14'),
(36, 'YAMAHA VIXION', 33250000, 6, 'vixion r 155', '[\"Matte Black\",\"Matte Red\"]', '[\"black\",\"red\"]', '[\"1719301410_667a7522b4c8e.png\",\"1719301410_667a7522b7354.png\"]', '2024-06-25 07:43:30', '2024-06-25 07:43:30'),
(37, 'YAMAHA ALL NEW R15', 40175000, 6, 'r15 c', '[\"Aggresive Grey\",\"Icon Blue\",\"Tech Black\"]', '[\"grey\",\"blue\",\"black\"]', '[\"1719301849_667a76d9780f6.png\",\"1719301849_667a76d978b5e.png\",\"1719301849_667a76d9791d1.png\"]', '2024-06-26 03:54:49', '2024-06-25 07:50:49'),
(38, 'YAMAHA ALL NEW R15', 44825000, 6, 'r15m cabs', '[\"Icon Performance\"]', '[\"grey\"]', '[\"1719301969_667a7751015e4.png\"]', '2024-06-26 03:55:50', '2024-06-25 07:52:49'),
(39, 'YAMAHA ALL NEW R15', 44995000, 6, 'r15m wgp 60th', '[\"WGP 60th Livery\"]', '[\"red\"]', '[\"1719302243_667a78633e607.png\"]', '2024-06-25 07:57:23', '2024-06-25 07:57:23'),
(40, 'YAMAHA ALL NEW R25', 70675000, 6, 'r25 abs', '[\"Racing Blue\",\"Metallic Black\"]', '[\"blue\",\"black\"]', '[\"1719302511_667a796f05533.png\",\"1719302511_667a796f06074.png\"]', '2024-06-25 08:01:51', '2024-06-25 08:01:51'),
(41, 'YAMAHA ALL NEW R25', 63900000, 6, 'r25 std', '[\"Racing Blue\"]', '[\"blue\"]', '[\"1719303996_667a7f3c02b2b.png\"]', '2024-06-25 08:26:36', '2024-06-25 08:26:36'),
(42, 'YAMAHA MT-25', 57575000, 6, 'mt 25', '[\"Metallic Dark Grey\",\"Metallic Blue\"]', '[\"grey\",\"blue\"]', '[\"1719308232_667a8fc83557b.png\",\"1719308232_667a8fc836261.png\"]', '2024-06-25 09:37:12', '2024-06-25 09:37:12'),
(43, 'YAMAHA GRAND FILANO', 27800000, 1, 'lux connected', '[\"Elixir Dark Silver\",\"White Pearl\"]', '[\"grey\",\"white\"]', '[\"1719374845_667b93fd4d8aa.png\",\"1719374845_667b93fd4f6c9.png\"]', '2024-06-26 04:07:25', '2024-06-26 04:07:25'),
(44, 'YAMAHA GRAND FILANO', 27050000, 1, 'neo', '[\"Tuscany Yellow\",\"Pink Mauve\",\"Dull Blue\",\"Red\",\"Black\"]', '[\"yellow\",\"pink\",\"blue\",\"red\",\"black\"]', '[\"1719375047_667b94c7d8c6b.png\",\"1719375047_667b94c7d9899.png\",\"1719375047_667b94c7da11a.png\",\"1719375047_667b94c7da96b.png\",\"1719375047_667b94c7db290.png\"]', '2024-06-26 04:10:47', '2024-06-26 04:10:47'),
(45, 'YAMAHA FAZZIO', 23350000, 1, 'lux connected', '[\"White Pearl\",\"Prestige Silver\",\"Black\"]', '[\"white\",\"grey\",\"black\"]', '[\"1719375250_667b95925d09d.png\",\"1719375250_667b95925da49.png\",\"1719375250_667b95925dd86.png\"]', '2024-06-26 04:14:10', '2024-06-26 04:14:10'),
(46, 'YAMAHA FAZZIO', 22700000, 6, 'neo', '[\"Yellow\",\"Dull Blue\",\"Orange\",\"Merah\",\"Mint\"]', '[\"yellow\",\"blue\",\"orange\",\"red\",\"green\"]', '[\"neoyellow2024.png\",\"neodullblue.png\",\"neoorange2023.png\",\"1719375590_667b96e68c768.png\",\"neomint2024.png\"]', '2024-06-26 04:19:50', '2024-06-26 04:17:28'),
(47, 'YAMAHA LEXI LX 155', 25650000, 2, 'standart', '[\"Metallic Red\",\"Metallic Black\",\"Matte Grey\"]', '[\"red\",\"black\",\"grey\"]', '[\"1719382230_667bb0d63ec01.png\",\"1719382230_667bb0d640997.png\",\"1719382230_667bb0d6412e0.png\"]', '2024-06-26 06:10:30', '2024-06-26 06:10:30'),
(48, 'YAMAHA LEXI LX 155', 27150000, 2, 's version', '[\"Elixir Dark Silver\",\"Magma Black\",\"Matte Red\"]', '[\"grey\",\"#2c2324\",\"red\"]', '[\"1719382439_667bb1a7c672f.png\",\"1719382439_667bb1a7c72d9.png\",\"1719382439_667bb1a7c7b5d.png\"]', '2024-06-26 06:13:59', '2024-06-26 06:13:59'),
(49, 'YAMAHA LEXI LX 155', 30200000, 2, 'cabs', '[\"Magma Black\"]', '[\"#2c2324\"]', '[\"1719382533_667bb205ea647.png\"]', '2024-06-26 06:15:33', '2024-06-26 06:15:33'),
(50, 'YAMAHA ALL NEW AEROX 155', 27775000, 2, 'standart', '[\"Dull Blue Orange\",\"Silver Cyan\",\"Metallic Red\",\"Black Grey\"]', '[\"orange\",\"cyan\",\"red\",\"black\"]', '[\"1719383431_667bb5872066b.png\",\"1719383431_667bb587215aa.png\",\"1719383431_667bb58721b18.png\",\"1719383431_667bb58722138.png\"]', '2024-06-26 06:30:31', '2024-06-26 06:30:31'),
(51, 'YAMAHA ALL NEW AEROX 155', 27975000, 2, 'cybercity', '[\"Cyber City Livery\"]', '[\"blue\"]', '[\"1719383551_667bb5ff05309.png\"]', '2024-06-26 06:32:31', '2024-06-26 06:32:31'),
(52, 'YAMAHA ALL NEW AEROX 155', 31560000, 2, 'cabs', '[\"Prestige Silver\",\"Maxi Signature\"]', '[\"grey\",\"black\"]', '[\"1719383696_667bb69015e0b.png\",\"1719383696_667bb690166c4.png\"]', '2024-06-26 06:34:56', '2024-06-26 06:34:56'),
(53, 'YAMAHA ALL NEW NMAX 155', 32175000, 2, 'standart', '[\"Metallic Blue\",\"Matte Green\",\"Metallic Red\",\"Maxi Signature\"]', '[\"blue\",\"green\",\"red\",\"black\"]', '[\"1719384220_667bb89c1f647.png\",\"1719384220_667bb89c23a7b.png\",\"1719384220_667bb89c244f0.png\",\"1719384220_667bb89c26f9e.png\"]', '2024-06-26 06:43:40', '2024-06-26 06:43:40'),
(54, 'YAMAHA ALL NEW NMAX 155', 33175000, 2, 's version', '[\"Metallic Red\",\"Matte Green\",\"Prestige Silver\",\"Maxi Signature\"]', '[\"red\",\"green\",\"grey\",\"black\"]', '[\"1719384518_667bb9c67f6bf.png\",\"1719384518_667bb9c68da25.png\",\"1719384518_667bb9c68f541.png\",\"1719384518_667bb9c68fe8b.png\"]', '2024-06-26 06:48:38', '2024-06-26 06:48:38'),
(55, 'YAMAHA ALL NEW NMAX 155', 36300000, 2, 'connected / abs', '[\"Prestige Silver\",\"Matte Green\",\"Maxi Signature\"]', '[\"grey\",\"green\",\"black\"]', '[\"1719384810_667bbaea710aa.png\",\"1719384810_667bbaea73b2e.png\",\"1719384810_667bbaea749fd.png\"]', '2024-06-26 08:17:16', '2024-06-26 06:53:30'),
(57, 'YAMAHA NMAX TURBO', 37750000, 2, 'nmax turbo', '[\"Magma Black\",\"Elixir Dark Silver\"]', '[\"#2c2324\",\"grey\"]', '[\"1719389143_667bcbd735267.png\",\"1719389143_667bcbd7361c6.png\"]', '2024-06-26 08:21:34', '2024-06-26 08:05:43'),
(58, 'YAMAHA NMAX TURBO', 43250000, 2, '\"turbo\" tech max', '[\"Magma Black\"]', '[\"#2c2324\"]', '[\"1719389280_667bcc60463b8.png\"]', '2024-06-26 08:23:18', '2024-06-26 08:08:00'),
(59, 'YAMAHA NMAX TURBO', 45250000, 2, '\"turbo\" tech max ultimate', '[\"Magma Black\"]', '[\"#2c2324\"]', '[\"1719389377_667bccc1743aa.png\"]', '2024-06-26 08:23:49', '2024-06-26 08:09:37'),
(60, 'YAMAHA NMAX TURBO', 32700000, 2, 'neo version', '[\"Black\",\"Red\",\"Dull Blue\",\"White\"]', '[\"black\",\"red\",\"#b0d4ea\",\"white\"]', '[\"1719390686_667bd1de3e58a.png\",\"1719390686_667bd1de405d6.png\",\"1719390686_667bd1de41070.png\",\"1719390686_667bd1de418c5.png\"]', '2024-06-26 08:31:26', '2024-06-26 08:31:26'),
(61, 'YAMAHA NMAX TURBO', 33700000, 2, 'neo s version', '[\"Black\",\"Red\",\"Dull Blue\",\"White\"]', '[\"black\",\"red\",\"#b0d4ea\",\"white\"]', '[\"1719391688_667bd5c8d38c4.png\",\"1719391688_667bd5c8d4ad2.png\",\"1719391688_667bd5c8d4f48.png\",\"1719391688_667bd5c8d5317.png\"]', '2024-06-26 08:48:08', '2024-06-26 08:37:48'),
(62, 'YAMAHA XMAX 250 CONNECTED', 66450000, 2, 'xmax 250 connected', '[\"Premium Black\",\"Prestige Grey\",\"Luxury Red\"]', '[\"black\",\"grey\",\"red\"]', '[\"1719392473_667bd8d97efe8.png\",\"1719392473_667bd8d980582.png\",\"1719392473_667bd8d980b96.png\"]', '2024-06-26 09:01:13', '2024-06-26 09:01:13'),
(63, 'YAMAHA XMAX 250 CONNECTED', 71750000, 2, 'xmax 250 tech max', '[\"Magma Black\"]', '[\"#2c2324\"]', '[\"1719392583_667bd94721378.png\"]', '2024-06-26 09:03:03', '2024-06-26 09:03:03'),
(64, 'YAMAHA MIO M3 125', 17750000, 5, 'mio m3 125', '[\"Metallic Cyan\",\"Metallic Yellow\",\"Metallic Red\",\"Metallic Black\"]', '[\"cyan\",\"yellow\",\"red\",\"black\"]', '[\"1719392891_667bda7bbe43f.png\",\"1719392891_667bda7bbf100.png\",\"1719392891_667bda7bbf531.png\",\"1719392891_667bda7bbfab3.png\"]', '2024-06-26 09:08:11', '2024-06-26 09:08:11'),
(66, 'YAMAHA FREEGO 125 C', 21700000, 5, 'standart', '[\"Blue\",\"Red\",\"Sand\",\"Black\"]', '[\"blue\",\"red\",\"brown\",\"black\"]', '[\"1719458311_667cda07ebdda.png\",\"1719458311_667cda07ec696.png\",\"1719458311_667cda07ecbdc.png\",\"1719458311_667cda07ed0cb.png\"]', '2024-06-27 03:18:31', '2024-06-27 03:18:31'),
(67, 'YAMAHA FREEGO 125 C', 23500000, 5, 'connected', '[\"Magma Black\",\"Silver\"]', '[\"#2c2324\",\"grey\"]', '[\"1719458918_667cdc663ce04.png\",\"1719458918_667cdc663d8db.png\"]', '2024-06-27 03:28:38', '2024-06-27 03:28:38'),
(69, 'YAMAHA FINO', 21610000, 5, 'fino grande', '[\"Luxury Red\",\"Royal Blue\"]', '[\"red\",\"blue\"]', '[\"1719459439_667cde6f9008e.png\",\"1719459439_667cde6f90837.png\"]', '2024-06-27 03:37:19', '2024-06-27 03:37:19'),
(70, 'YAMAHA FINO', 20400000, 5, 'fino premium', '[\"Black Espresso\",\"White Latte\",\"Creamy Grey\"]', '[\"black\",\"white\",\"grey\"]', '[\"1719459544_667cded867983.png\",\"1719459544_667cded869f64.png\",\"1719459544_667cded86a51b.png\"]', '2024-06-27 03:39:04', '2024-06-27 03:39:04'),
(71, 'YAMAHA FINO', 20400000, 5, 'fino sporty', '[\"Classic Tosca\",\"Vintage Red\",\"Retro Grey\"]', '[\"green\",\"red\",\"grey\"]', '[\"1719459667_667cdf53b256e.png\",\"1719459667_667cdf53b4dc9.png\",\"1719459667_667cdf53b5553.png\"]', '2024-06-27 03:41:07', '2024-06-27 03:41:07');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id_artikel` int(15) NOT NULL,
  `judul` varchar(255) NOT NULL,
  `isi` text NOT NULL,
  `foto_artikel` text NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id_artikel`, `judul`, `isi`, `foto_artikel`, `updated_at`, `created_at`) VALUES
(1, 'Tester', 'tester isi artikel', '1718866406.png', '2024-06-20 06:53:26', '2024-06-20 06:53:26'),
(2, 'Akhirnya Yamaha Luncurkan NMAX Tercanggih di Dunia, Dilengkapi Mesin Berteknologi “TURBO”', 'Jakarta – Menjelang hari jadinya yang ke-50 tahun pada 6 Juli mendatang, PT Yamaha Indonesia Motor Mfg. (YIMM) mempersembahkan kejutan bagi para pecinta skutik premium di tanah air dengan meluncurkan produk paling canggih di jajaran skutik MAXi Yamaha, yaitu NMAX “TURBO”. Peluncuran perdana secara global ini berlangsung pada Rabu (12/6), di Double Tree Hotel by Hilton, Kemayoran, Jakarta.\r\n\r\nHadir dengan berbagai sentuhan pembaruan baik dari segi desain, fitur, maupun performa mesin yang sarat akan teknologi canggih, NMAX “TURBO” diyakini tidak hanya memberikan pengalaman berkendara dan rasa percaya diri di level tertinggi bagi para penggunanya, tetapi juga akan menjadi trend setter yang membawa standar baru di segmen skutik premium 150cc tanah air.\r\n\r\n“Sebagai ‘KANDO’ creating company yang terus berinovasi dalam menghadirkan sesuatu yang baru untuk mendukung kebutuhan mobilitas konsumen, bertepatan dengan hari ulang tahun Yamaha Indonesia yang ke-50, kami mempersembahkan NMAX “TURBO” kepada msayarakat Indonesia dalam banyak varian. Ini adalah NMAX tercanggih di dunia yang dilengkapi dengan desain yang semakin mewah, fitur first class, dan juga performa mesin yang mengadopsi teknologi baru YECVT, sehingga dapat memberikan sensasi TURBO dalam berkendara,” ungkap Dyonisius Beti, President Director & CEO, PT Yamaha Indonesia Motor Mfg., saat memberikan kata sambutan di acara launching NMAX “TURBO”\r\n\r\nDikembangkan dengan konsep Evolution: Fun Tech X Prestige X Sporty, NMAX “TURBO” merupakan skutik yang menawarkan perpaduan antara nilai-nilai premium dengan teknologi canggih yang mendukung passion berkendara. Nilai premium itu sendiri dapat dilihat pada tampilan desain dan juga kelengkapan fitur first class yang tersemat pada motor. Sementara Fun Tech, merujuk pada kehadiran teknologi terbaru Yamaha Electric Continuously Variable Transmission (YECVT), yang memberikan pengalaman berkendara menyenangkan dengan sensasi “TURBO”.\r\n\r\nPerforma SEMAXIN Garang \r\n\r\nKeunggulan utama yang menjadi daya tarik dari NMAX “TURBO” adalah penggunaan mesin Blue Core 155cc VVA generasi terbaru yang telah teruji andal, kuat, dan memiliki torsi merata disetiap putaran mesin sehingga mampu mendukung berbagai macam kebutuhan bermobilitas. Dengan sentuhan pembaruan di sektor jantung pacu, NMAX “TURBO” mampu menghasilkan tenaga maksimal sebesar 11,3 kW / 8.000 Rpm dan torsi maksimal sebesar 14,2 Nm / 6.500 Rpm.\r\n\r\nPerforma mesin baru pada NMAX “TURBO” juga turut dioptimalkan dengan adanya teknologi canggih terbaru, yaitu YECVT* yang menggantikan sistem CVT konvensional. Dengan penggunaan teknologi ini, maka NMAX “TURBO” telah memiliki fitur Riding Mode* yang menawarkan 2 mode berkendara, yaitu T-Mode (Town Commuting) dan juga S-Mode (Sport Touring) yang dapat dioperasikan melalui tombol “Mode” pada bagian depan stang kemudi kiri. T-Mode sendiri cocok digunakan untuk mobilitas harian di dalam kota, karena karakter berkendara yang lebih smooth serta efisien bahan bakar. Sedangkan S-Mode, cocok digunakan saat perjalanan jarak jauh seperti touring karena menawarkan akselerasi berkendara yang lebih responsif.\r\n\r\nBerdasarkan hasil pengetesan internal Yamaha dengan menggunakan mode berkendara S. NMAX “TURBO” mampu berakselerasi lebih cepat untuk menempuh jarak 200 meter dibandingkan dengan NMAX generasi sebelumnya, dengan selisih jarak terpaut 9,2 meter**.\r\n\r\nSelain adanya Riding Mode, dengan menggunakan YECVT NMAX “TURBO” juga memiliki fitur lain berupa Y-Shift* yang tombol pengoperasiannya terletak di bawah stang kemudi kiri. Y-Shift sendiri mampu memberikan sensasi berkendara berbeda karena fungsinya mampu membantu pengendara untuk melakukan akselerasi kecepatan secara instan layaknya “TURBO” dengan 3 tingkatan, yakni Low (1), Medium (2), dan High (3) sehingga cocok dioperasikan ketika ingin mendahului kendaraan di depan, melewati tanjakan, ataupun saat berkendara tandem. Tidak hanya saat akselerasi, Y-Shift juga dapat digunakan untuk melakukan deselerasi kecepatan motor ketika menghadapi jalanan yang menurun dan juga saat masuk ke tikungan (cornering).\r\n\r\nSelain fitur-fitur terkait mesin, untuk memberikan pengalaman berkendara terbaik, NMAX “TURBO” juga disematkan dengan fitur Dual Channel ABS*, Traction Control System*, Rear Sub Tank Suspension dan juga Ban Tubeless bertapak lebar.', '1718870048.jpg', '2024-06-20 07:54:08', '2024-06-20 07:54:08');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id_slider` int(15) NOT NULL,
  `name` text NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id_slider`, `name`, `updated_at`, `created_at`) VALUES
(11, '1719826425.jpg', '2024-07-01 09:33:45', '2024-07-01 09:33:45'),
(12, '1719826643.jpg', '2024-07-01 09:37:23', '2024-07-01 09:37:23'),
(13, '1719826664.jpg', '2024-07-01 09:37:44', '2024-07-01 09:37:44'),
(14, '1719826670.jpg', '2024-07-01 09:37:50', '2024-07-01 09:37:50'),
(15, '1719826686.jpg', '2024-07-01 09:38:06', '2024-07-01 09:38:06'),
(16, '1719826692.jpg', '2024-07-01 09:38:12', '2024-07-01 09:38:12'),
(17, '1719826698.png', '2024-07-01 09:38:18', '2024-07-01 09:38:18');

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

--
-- Table structure for table `warna_motor`
--

CREATE TABLE `warna_motor` (
  `id_warna` int(15) NOT NULL,
  `id_motor` int(15) NOT NULL,
  `namaWarna` int(155) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bestseller`
--
ALTER TABLE `bestseller`
  ADD PRIMARY KEY (`id_bestSeller`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id_category`);

--
-- Indexes for table `dealer`
--
ALTER TABLE `dealer`
  ADD PRIMARY KEY (`id_dealer`);

--
-- Indexes for table `fotomotor`
--
ALTER TABLE `fotomotor`
  ADD PRIMARY KEY (`id_foto`);

--
-- Indexes for table `motor`
--
ALTER TABLE `motor`
  ADD PRIMARY KEY (`id_motor`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id_artikel`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`id_slider`);

--
-- Indexes for table `warna_motor`
--
ALTER TABLE `warna_motor`
  ADD PRIMARY KEY (`id_warna`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bestseller`
--
ALTER TABLE `bestseller`
  MODIFY `id_bestSeller` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id_category` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `dealer`
--
ALTER TABLE `dealer`
  MODIFY `id_dealer` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `fotomotor`
--
ALTER TABLE `fotomotor`
  MODIFY `id_foto` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `motor`
--
ALTER TABLE `motor`
  MODIFY `id_motor` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id_artikel` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id_slider` int(15) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `warna_motor`
--
ALTER TABLE `warna_motor`
  MODIFY `id_warna` int(15) NOT NULL AUTO_INCREMENT;
COMMIT;

