-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 05, 2025 at 03:18 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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: `cms`
--

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

--
-- Table structure for table `brand_branch_image_work_section`
--

CREATE TABLE `brand_branch_image_work_section` (
  `id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `brand_branch_image_work_section`
--

INSERT INTO `brand_branch_image_work_section` (`id`, `branch_id`, `image`, `created_at`) VALUES
(1, 1, 'IMG_3881.JPG', '2025-04-01 10:25:27'),
(2, 1, 'IMG_3882.JPG', '2025-04-01 10:27:47'),
(3, 1, 'IMG_3883.JPG', '2025-04-01 10:28:01'),
(4, 1, 'IMG_3884.JPG', '2025-04-01 10:28:07'),
(5, 1, 'IMG_3880.JPG', '2025-04-01 11:40:37'),
(11, 11, 'IMG_3784.JPG', '2025-04-01 18:55:34'),
(12, 11, 'IMG_3785.JPG', '2025-04-01 18:55:39'),
(13, 11, 'IMG_3786.JPG', '2025-04-01 18:55:44'),
(14, 11, 'IMG_3787.JPG', '2025-04-01 18:55:49'),
(15, 11, 'IMG_3788.JPG', '2025-04-01 18:55:58'),
(16, 11, 'IMG_3789.JPG', '2025-04-01 18:56:02'),
(17, 11, 'IMG_3790.JPG', '2025-04-01 18:56:07'),
(18, 11, 'IMG_3791.JPG', '2025-04-01 18:56:11'),
(19, 12, 'IMG_3746.JPG', '2025-04-01 18:57:21'),
(20, 12, 'IMG_3747.JPG', '2025-04-01 18:57:26'),
(21, 12, 'IMG_3748.JPG', '2025-04-01 18:57:32'),
(22, 12, 'IMG_3749.JPG', '2025-04-01 18:57:37'),
(23, 12, 'IMG_3750.JPG', '2025-04-01 18:57:45'),
(24, 12, 'IMG_3751.JPG', '2025-04-01 18:57:50'),
(25, 13, 'IMG_3724.JPG', '2025-04-01 18:58:52'),
(26, 13, 'IMG_3725.JPG', '2025-04-01 18:58:57'),
(27, 13, 'IMG_3726.JPG', '2025-04-01 18:59:02'),
(28, 13, 'IMG_3727.JPG', '2025-04-01 18:59:06'),
(29, 14, 'IMG_3707.JPG', '2025-04-01 18:59:45'),
(30, 14, 'IMG_3708.JPG', '2025-04-01 18:59:49'),
(31, 14, 'IMG_3709.JPG', '2025-04-01 18:59:53'),
(32, 14, 'IMG_3710.JPG', '2025-04-01 18:59:57'),
(33, 14, 'IMG_3711.JPG', '2025-04-01 19:00:01'),
(34, 15, '1.png', '2025-04-01 19:01:20'),
(35, 15, '2.png', '2025-04-01 19:01:26'),
(36, 15, '3.png', '2025-04-01 19:01:31'),
(37, 15, '4.png', '2025-04-01 19:01:36'),
(43, 16, '5.jpg', '2025-05-05 16:46:40'),
(44, 16, '4.jpg', '2025-05-05 16:46:44'),
(45, 16, '3.jpg', '2025-05-05 16:46:49'),
(48, 16, 'Ir__Soekarno___Surabaya_2.jpg', '2025-05-05 17:16:34');

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

--
-- Table structure for table `brand_branch_work_section`
--

CREATE TABLE `brand_branch_work_section` (
  `id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `branch_name` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `brand_branch_work_section`
--

INSERT INTO `brand_branch_work_section` (`id`, `brand_id`, `branch_name`, `image`, `created_at`) VALUES
(1, 1, 'Living World Cibubur', 'IMG_3880.JPG', '2025-04-01 10:21:52'),
(11, 7, 'Karawang', 'IMG_3785.JPG', '2025-04-01 18:55:27'),
(12, 15, 'Nasville PIK 2', 'IMG_3748.JPG', '2025-04-01 18:57:13'),
(13, 8, 'SMS BEKASI', 'IMG_3724.JPG', '2025-04-01 18:58:46'),
(14, 13, 'Toko Mr. Electronic Prabumulih', 'IMG_3709.JPG', '2025-04-01 18:59:39'),
(15, 9, 'Karawang', '1.png', '2025-04-01 19:01:08'),
(16, 15, 'Ir. Soekarno - Surabaya', '5.jpg', '2025-05-05 16:45:32'),
(17, 7, 'POINT 2000 - Tangerang', 'testing.jpg', '2025-05-05 17:24:42');

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

--
-- Table structure for table `brand_work_section`
--

CREATE TABLE `brand_work_section` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `orders` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `brand_work_section`
--

INSERT INTO `brand_work_section` (`id`, `name`, `logo`, `orders`, `created_at`) VALUES
(1, 'Kopi Kenangan', 'kopken.svg', 6, '2025-04-01 10:21:12'),
(7, 'Samsung', 'Samsung.svg', 1, '2025-04-01 16:49:34'),
(8, 'Erafone', 'erafone.svg', 2, '2025-04-01 16:50:32'),
(9, 'Opus Bay', 'opus-bay.svg', 8, '2025-04-01 16:50:46'),
(10, 'Coca Cola', 'cocacola.svg', 3, '2025-04-01 16:50:59'),
(12, 'Es Teh Indonesia', 'es-teh.svg', 9, '2025-04-01 16:51:26'),
(13, 'Electrolux', 'electrrolux.svg', 4, '2025-04-01 16:52:14'),
(14, 'Bosch', 'beosch.svg', 5, '2025-04-01 16:53:13'),
(15, 'Indomaret', 'Indomart.svg', 7, '2025-04-01 16:53:26');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` bigint(20) NOT NULL,
  `address` varchar(500) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `whatsapp` varchar(20) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `updated_on` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `address`, `phone`, `email`, `whatsapp`, `instagram`, `facebook`, `updated_on`) VALUES
(1, 'Jl. Dr. Ratna No.39 Jatibening - Pondok Gede, Kota Bekasi', '+62817189589', 'william@ardaya.co.id', '+62817189589', 'https://www.instagram.com/pt.ardaya/', 'https://www.facebook.com/Ardaya.pt', '2025-04-11 13:38:32');

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

--
-- Table structure for table `home_section`
--

CREATE TABLE `home_section` (
  `id` int(11) NOT NULL,
  `background_image` varchar(255) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_section`
--

INSERT INTO `home_section` (`id`, `background_image`, `updated_on`) VALUES
(1, 'image-enhanced.webp', '2025-03-29 06:40:34');

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

--
-- Table structure for table `team_members_about_section`
--

CREATE TABLE `team_members_about_section` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `orders` int(11) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `team_members_about_section`
--

INSERT INTO `team_members_about_section` (`id`, `name`, `title`, `image`, `orders`, `updated_on`) VALUES
(1, 'William Arianto', 'President Director', 'willi-cropped.svg', 1, '2025-03-30 08:00:55'),
(2, 'Setiyo', 'Team Head Productions & Operations', 'setiyo-cropped.svg', 2, '2025-03-31 07:19:48'),
(3, 'Nurul Akbar Siswanto', 'Team Head Project', 'nurul-cropped.svg', 3, '2025-03-31 07:29:01'),
(4, 'Hendi Hidayat', 'Team Head Admin', 'Hendi (2)@3x.png', 4, '2025-03-31 07:29:20'),
(5, 'Arif Kurnia', 'Production SPV 1', '3-cropped.svg', 5, '2025-03-31 07:29:49'),
(6, 'Maulana Adi Saputro', 'Design Manager', 'maulana-cropped.svg', 6, '2025-03-31 07:30:17'),
(7, 'Siminnara', 'Branding Tax Head', 'siminnara-cropped (1).svg', 7, '2025-03-31 07:31:19'),
(8, 'Yana', 'Finance', 'yana-cropped.svg', 8, '2025-03-31 07:33:15');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `password`, `created_at`) VALUES
(1, 'admin', 'admin@admin.com', '$2y$10$GMKGESo5hYG.vcLvUw4ByeeouoneDBjgq..hu4sAZIlwDjzmIzwSK', '2025-03-28 07:27:13');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `brand_branch_image_work_section`
--
ALTER TABLE `brand_branch_image_work_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `brand_branch_work_section`
--
ALTER TABLE `brand_branch_work_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `brand_work_section`
--
ALTER TABLE `brand_work_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `home_section`
--
ALTER TABLE `home_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `team_members_about_section`
--
ALTER TABLE `team_members_about_section`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;