-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Waktu pembuatan: 28 Apr 2026 pada 14.27
-- Versi server: 10.11.16-MariaDB-cll-lve
-- Versi PHP: 8.4.19

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

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

--
-- Struktur dari tabel `abouts`
--

CREATE TABLE `abouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `subtitle_en` varchar(255) DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `desc_en` text DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `label_en` varchar(255) DEFAULT NULL,
  `list` text DEFAULT NULL,
  `list_en` text DEFAULT NULL,
  `callout` text DEFAULT NULL,
  `callout_en` text DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `vision` text DEFAULT NULL,
  `vision_en` text DEFAULT NULL,
  `mission_title` varchar(255) DEFAULT NULL,
  `mission_title_en` varchar(255) DEFAULT NULL,
  `mission_list` text DEFAULT NULL,
  `mission_list_en` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `abouts`
--

INSERT INTO `abouts` (`id`, `title`, `title_en`, `subtitle`, `subtitle_en`, `desc`, `desc_en`, `label`, `label_en`, `list`, `list_en`, `callout`, `callout_en`, `img`, `vision`, `vision_en`, `mission_title`, `mission_title_en`, `mission_list`, `mission_list_en`, `created_at`, `updated_at`) VALUES
(1, 'Amethyst Suites', 'Amethyst Suites', 'Solusi Virtual Office Terpercaya di Jakarta', 'Trusted Virtual Office Solution in Jakarta', 'We offer virtual office rental services in strategic locations in Jakarta, helping your business achieve a professional office address without the high operational costs. Our services are suitable for startups, new companies, and businesses looking to expand their reach in Jakarta.', 'We offer virtual office rental services in strategic locations in Jakarta, helping your business achieve a professional office address without the high operational costs. Our services are suitable for startups, new companies, and businesses looking to expand their reach in Jakarta.', 'Years of Experience', 'Years of Experience', 'Legal office address for your company\r\nMail and package receiving services\r\nMeeting rooms & office facilities', 'Legal office address for your company\r\nMail and package receiving services\r\nMeeting rooms & office facilities', 'Need Virtual Office information?', 'Need Virtual Office information?', 'zFcDJBVWyaCgZZm9qHoFBrdqBv6eQNcUb0oiOrHQ.jpg', 'To be the leading Virtual Office provider in Indonesia, providing modern, flexible, and professional office solutions to support today\'s business growth.', 'To be the leading Virtual Office provider in Indonesia, providing modern, flexible, and professional office solutions to support today\'s business growth.', 'Providing Real Solutions for Your Business', 'Providing Real Solutions for Your Business', 'Strategic & Legal Business Address\r\nProfessional & Responsive Service\r\nOperational Cost Efficiency\r\nModern & Flexible Office Facilities', 'Strategic & Legal Business Address\r\nProfessional & Responsive Service\r\nOperational Cost Efficiency\r\nModern & Flexible Office Facilities', '2026-03-28 06:44:05', '2026-04-16 19:46:23');

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

--
-- Struktur dari tabel `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `desktop_img` varchar(255) DEFAULT NULL,
  `mobile_img` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `sub_title_en` varchar(255) DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `desc_en` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_text_en` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `banners`
--

INSERT INTO `banners` (`id`, `desktop_img`, `mobile_img`, `title`, `title_en`, `sub_title`, `sub_title_en`, `desc`, `desc_en`, `button_text`, `button_text_en`, `link`, `status`, `created_at`, `updated_at`) VALUES
(1, 'GJ63LweQlJGhOXOxDJhoAIBq24xAtMVJZ4C5Sg6O.jpg', 'carousel-1.jpg', 'Amethyst Suites', 'Amethyst Suites', 'Virtual Office & Kantor Siap Pakai Terbaik di Jakarta', 'Best Virtual Office and Serviced Office in Jakarta', 'Solusi kantor modern untuk bisnis Anda dengan alamat kantor yang bergengsi.', 'Modern office solutions for your business with a prestigious office address.', 'layanan kami', 'our services', 'https://amethyst.rubicweb.com/#services-section', 1, '2026-04-18 03:20:56', '2026-04-18 03:20:56'),
(2, '6RsN7EeGaiyHsRe9DQ5EyzTBuN4EL0WI9Z3dfZJC.jpg', NULL, 'Kantor Siap Pakai', 'Serviced Office', 'Ruang Kerja Siap Digunakan', 'Ready to Use Workspace', 'Nikmati lingkungan kerja profesional, tanpa repot mengurus setup maupun operasional, serta fleksibilitas sewa sesuai kebutuhan bisnis Anda.', 'Enjoy a professional business environment, complete facilities, and flexible lease terms without the hassle of setup and maintenance.', 'selengkapnya', 'more detail', 'https://amethyst.rubicweb.com/jasa/kantor-siap-pakai', 1, '2026-04-18 02:57:29', '2026-04-18 02:57:29'),
(3, '48pTIX217jNplFzkxt03jgumKn8ya0DMl65ZtcDc.jpg', NULL, 'Virtual Office', 'Virtual Office', 'Alamat Bisnis Bergengsi & Fleksibel', 'Prestigious Business Address & Flexibility', 'Bangun citra bisnis profesional tanpa biaya kantor fisik. Dapatkan alamat bisnis strategis, layanan penerimaan surat, serta akses ke fasilitas kantor, solusi ideal bagi bisnis yang mengutamakan fleksibilitas dan efisiensi.', 'Establish a professional business presence without the cost of a physical office. Get a prestigious business address, mail handling, and access to essential office facilities, perfect for growing businesses seeking flexibility and efficiency.', 'selengkapnya', 'more detail', 'https://amethyst.rubicweb.com/jasa/virtual-office', 1, '2026-04-18 02:57:28', '2026-04-18 02:57:28'),
(4, 'KJDqET6AloFHuUQXZaRxYBcdEp15UtiI3vTFMdai.jpg', NULL, 'Ruang Kerja', 'Workspace', 'Fleksibel & Produktif', 'Flexible & Productive Environment', 'Dirancang untuk meningkatkan produktivitas, ruang kerja kami memberikan fleksibilitas, kenyamanan, serta suasana kolaboratif. Cocok untuk individu maupun tim yang membutuhkan tempat kerja yang efisien dan inspiratif.', 'Designed to boost productivity, our workspace offers flexibility, comfort, and a collaborative atmosphere. Ideal for individuals or teams seeking an efficient and inspiring place to work.', 'selengkapnya', 'more detail', 'https://amethyst.rubicweb.com/jasa/ruang-kerja', 1, '2026-04-18 02:57:27', '2026-04-18 02:57:27'),
(5, '7WnkLgBTNWcWIiTkeWztsZblKKOp0SHcXPLjjKh2.jpg', NULL, 'Ruang Meeting', 'Meeting Room', 'Profesional & Lengkap', 'Professional & Fully Equipped', 'Selenggarakan meeting dengan percaya diri di ruang meeting modern kami yang dilengkapi fasilitas lengkap. Suasana profesional membantu diskusi dan presentasi berjalan lebih efektif dan berkesan.', 'Host your meetings with confidence in our modern meeting rooms, equipped with advanced facilities and a professional setting to support productive discussions and presentations.', 'selengkapnya', 'more detail', 'https://amethyst.rubicweb.com/jasa/ruang-meeting', 1, '2026-04-18 02:57:26', '2026-04-18 02:57:26'),
(6, 'carousel-2.jpg', 'carousel-2.jpg', 'Professional Partner', 'Professional Partner', 'Tax & Financial Solutions', 'Tax & Financial Solutions', 'We assist in managing corporate tax and financial matters professionally, including bookkeeping and tax reporting.', 'We assist in managing corporate tax and financial matters professionally, including bookkeeping and tax reporting.', 'more', 'more', 'https://amethyst.rubicweb.com/jasa/konsultan-pajak', 1, '2026-04-18 02:57:24', '2026-04-18 02:57:24'),
(7, 'carousel-3.jpg', 'carousel-3.jpg', 'Partner Profesional', 'Professional Partner', 'Jasa Pendirian Badan Usaha', 'Business Entity Establishment Services', 'Kami membantu proses pendirian badan usaha seperti PT, CV, dan legalitas perusahaan secara cepat, aman, dan terpercaya, sehingga bisnis Anda siap berkembang secara legal dan profesional.', 'We assist in the process of establishing business entities such as PT, CV, and other company legalities quickly, securely, and reliably, ensuring your business is ready to grow legally and professionally.', 'konsultasi gratis', 'ask for free', 'https://amethyst.rubicweb.com/jasa/pendirian-badan-usaha', 1, '2026-04-18 02:57:25', '2026-04-18 02:57:25'),
(8, 'promo.jpg', 'promo.jpg', 'Hemat Hingga 40%', 'Save up to 40%', 'Dapatkan alamat bisnis prestisius di Jakarta dengan harga promo terbatas.', 'Get a prestigious business address in Jakarta at a limited promotional price.', 'Alamat bisnis prestisius\r\nMail handling profesional\r\nMeeting room eksklusif', 'Prestigious business address\r\nProfessional mail handling\r\nExclusive meeting room', 'mulai berlangganan', 'subscribe', 'https://wa.me/6289636941722?text=Saya%20tertarik%20dengan%20Promo%20Amethyst', 2, '2026-03-28 04:49:57', '2026-03-28 04:49:59'),
(9, 'promo-2.jpg', 'promo-2.jpg', 'Hemat Hingga 50%', 'Save up to 50%', 'Dapatkan extra 6 bulan akses ruang meeting dengan fasilitas lengkap', 'Get an extra 6 months of access to a meeting room with complete facilities.', 'Kapasitas hingga 15 orang\r\nGratis akses Wifi\r\nGratis air mineral\r\nSmart TV', 'Capacity up to 15 people\r\nFree Wi-Fi access\r\nFree mineral water\r\nSmart TV', 'mulai berlangganan', 'subscribe', 'https://wa.me/6289636941722?text=Saya%20tertarik%20dengan%20Promo%20Amethyst', 2, '2026-03-28 04:49:57', '2026-03-28 04:49:59'),
(32, 'YVS1rw6kokbjFiqRNsqBUqkrlrfb7okZS2yXp7VW.jpg', NULL, 'Diskon 50% Ruang Meeting', '50% OFF Meeting Room', 'Tingkatkan Kualitas Meeting Anda', 'Boost Your Business Meetings', 'Rasakan pengalaman rapat yang lebih profesional dengan fasilitas pendukung kami. Cocok untuk rapat klien dan diskusi bisnis yang lebih efektif.', 'Experience a more professional meeting experience with our supporting facilities. Perfect for client meetings and more effective business discussions.', 'berlangganan', 'subscribe', 'https://api.whatsapp.com/send/?phone=6281234567890&text=Saya+tertarik+dengan+promo+diskon+50%&type=phone_number&app_absent=0', 1, '2026-04-18 02:57:23', '2026-04-18 02:57:23');

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

--
-- Struktur dari tabel `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `careers`
--

CREATE TABLE `careers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `status_en` varchar(255) DEFAULT NULL,
  `short` text DEFAULT NULL,
  `short_en` text DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `desc_en` text DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `careers`
--

INSERT INTO `careers` (`id`, `title`, `title_en`, `status`, `status_en`, `short`, `short_en`, `desc`, `desc_en`, `expired_date`, `created_at`, `updated_at`) VALUES
(1, 'Sales Executive', 'Sales Executive', 'Full Time', 'Full Time', 'Bertanggung jawab untuk menjual layanan Virtual Office dan menjalin hubungan dengan klien.', 'Responsible for selling Virtual Office services and building relationships with clients.', NULL, NULL, '2026-04-07', NULL, NULL),
(2, 'Customer Service', 'Customer Service', 'Full Time', 'Full Time', 'Memberikan pelayanan terbaik kepada klien serta menangani kebutuhan administrasi.', 'Providing the best service to clients and handling administrative needs.', NULL, NULL, '2026-04-07', NULL, NULL),
(3, 'Digital Marketing', 'Digital Marketing', 'Remote', 'Remote', 'Mengelola strategi pemasaran digital untuk meningkatkan brand awareness dan leads.', 'Manage digital marketing strategies to increase brand awareness and leads.', NULL, NULL, '2026-04-07', NULL, NULL);

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

--
-- Struktur dari tabel `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `categories`
--

INSERT INTO `categories` (`id`, `title`, `title_en`, `img`, `link`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Tips', 'Tips', 'tips.jpg', NULL, 1, '2026-04-02 09:27:11', '2026-04-02 09:27:11'),
(2, 'Legalitas', 'Legality', 'legal.jpg', NULL, 1, '2026-04-02 09:27:11', '2026-04-02 09:27:11'),
(3, 'Startup', 'Startup', 'startup.jpg', NULL, 1, '2026-04-02 09:27:11', '2026-04-02 09:27:11'),
(4, 'Bisnis', 'Business', 'business.jpg', NULL, 1, '2026-04-02 09:27:11', '2026-04-02 09:27:11');

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

--
-- Struktur dari tabel `counters`
--

CREATE TABLE `counters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `value_en` varchar(255) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `text_en` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `counters`
--

INSERT INTO `counters` (`id`, `icon`, `title`, `title_en`, `value`, `value_en`, `text`, `text_en`, `created_at`, `updated_at`) VALUES
(1, 'fas fa-map-marker-alt', 'Lokasi Strategis', 'Strategic Locations', '2', '2', NULL, NULL, '2026-04-02 08:59:56', '2026-04-13 08:17:02'),
(2, 'fas fa-bolt', 'Proses Cepat', 'Fast Process', '1', '1', 'Hari', 'Day', '2026-04-02 08:59:56', '2026-04-02 08:59:56'),
(3, 'fas fa-briefcase', 'Layanan Bisnis', 'Business Services', '5', '5', '+', '+', '2026-04-02 08:59:56', '2026-04-02 08:59:56'),
(4, 'fas fa-clock', 'Dukungan Tim', 'Team Support', '24', '24', '/7', '/7', '2026-04-02 08:59:56', '2026-04-02 08:59:56');

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

--
-- Struktur dari tabel `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `galleries`
--

INSERT INTO `galleries` (`id`, `service_id`, `label`, `img`, `title`, `title_en`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'serviced office', '1.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(2, 1, 'serviced office', '2.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(3, 1, 'serviced office', '3.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(4, 1, 'serviced office', '4.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(5, 3, 'working space', 'cowork-1.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(6, 3, 'working space', 'cowork-2.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(7, 3, 'working space', 'cowork-3.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(8, 4, 'meeting room', 'meeting-1.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(9, 4, 'meeting room', 'meeting-2.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(10, 4, 'meeting room', 'meeting-3.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(11, 4, 'meeting room', 'meeting-4.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(12, 2, 'virtual office', 'vo-1.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(13, 2, 'virtual office', 'vo-2.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(14, 2, 'virtual office', 'vo-3.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07'),
(15, 2, 'virtual office', 'vo-4.jpg', 'title here', 'title here', 1, '2026-04-07 11:38:07', '2026-04-07 11:38:07');

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

--
-- Struktur dari tabel `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `job_applications`
--

CREATE TABLE `job_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `experience` int(11) DEFAULT NULL,
  `education` varchar(255) DEFAULT NULL,
  `cv` varchar(255) NOT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `job_applications`
--

INSERT INTO `job_applications` (`id`, `name`, `email`, `phone`, `position`, `experience`, `education`, `cv`, `message`, `created_at`, `updated_at`) VALUES
(3, 'Raka Pratama', 'raka1212@gmail.com', '082233444333', 'Digital Marketing', 5, 'S1', 'cv/1776147144_CV Raka Pratama.pdf', 'Saya tertarik dengan posisi ini dan berharap dapat memberikan kontribusi positif untuk perusahaan.', '2026-04-13 23:12:24', '2026-04-13 23:12:24');

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

--
-- Struktur dari tabel `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `address_en` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `maps` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `locations`
--

INSERT INTO `locations` (`id`, `name`, `name_en`, `address`, `address_en`, `phone`, `img`, `logo`, `link`, `maps`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Sahid Sudirman Center', 'Sahid Sudirman Center', 'Jl. Jenderal Sudirman No.Kav. 86 Lantai 11 Suite A, RT.10/RW.11, Karet Tengsin, Kecamatan Tanah Abang, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta 10220', 'Jl. Jenderal Sudirman No. Kav. 86, 11th Floor Suite A, RT 10/RW 11, Karet Tengsin, Tanah Abang District, Central Jakarta, Special Capital Region of Jakarta 10220, Indonesia', '02180631631', 'r7wIK7pFkENWECUzNj0N6r1zHCemFTs5tAqBtsbk.jpg', '9H55i63ns4M5f7ugeCIVE6r5S2DyFurRfDb1FgIb.jpg', '/contact', 'https://maps.app.goo.gl/gwhrPZoFKvWzfCzb8', 1, '2026-04-02 09:10:59', '2026-04-11 08:49:06'),
(2, '18 Office Park', '18 Office Park', '18 Office Park, Lantai 22, Jl. TB Simatupang No.18, RT.2/RW.1, Kebagusan, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 12520', '18 Office Park, 22nd Floor, Jl. TB Simatupang No. 18, RT 2/RW 1, Kebagusan, Pasar Minggu, South Jakarta, Special Capital Region of Jakarta 12520, Indonesia', '02180641888', 'L9OoFslsKjXSx36iCtJD6gZNmkATeWZ3MbrUlxWT.jpg', 'HIfXZbsETwjB1GmLVcM9rEZ9Mxp0QLTkQ3SwhlKF.jpg', '/contact', 'https://maps.app.goo.gl/pQwHxpDLZPokTMSA9', 1, '2026-04-02 09:10:59', '2026-04-11 08:50:51');

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

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(5, '2026_03_19_231852_create_banners_table', 2),
(7, '2026_03_19_231958_create_galleries_table', 2),
(8, '2026_03_19_232020_create_counters_table', 2),
(9, '2026_03_19_232040_create_categories_table', 2),
(10, '2026_03_19_232059_create_testimonis_table', 2),
(11, '2026_03_19_232120_create_news_table', 2),
(12, '2026_03_19_232149_create_careers_table', 2),
(13, '2026_03_19_232216_create_promos_table', 2),
(14, '2026_03_19_232236_create_opening_hours_table', 2),
(15, '2026_03_19_232302_create_site_settings_table', 2),
(16, '2026_03_19_232325_create_seo_settings_table', 2),
(17, '2026_03_19_231803_create_abouts_table', 3),
(18, '2026_03_30_074746_create_titles_table', 4),
(19, '2026_03_19_231935_create_services_table', 5),
(20, '2026_04_02_090706_create_locations_table', 6),
(21, '2026_04_07_075205_create_job_applications_table', 7),
(22, '2026_04_11_180447_add_menu_access_to_users_table', 8),
(23, '2026_04_13_112822_create_seos_table', 9);

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

--
-- Struktur dari tabel `news`
--

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `img` varchar(255) DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `keyword` varchar(255) DEFAULT NULL,
  `keyword_en` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `slug_en` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `content_en` longtext DEFAULT NULL,
  `quotes` text DEFAULT NULL,
  `quotes_en` text DEFAULT NULL,
  `widget_text` varchar(255) DEFAULT NULL,
  `widget_text_en` varchar(255) DEFAULT NULL,
  `widget_button` varchar(255) DEFAULT NULL,
  `widget_button_en` varchar(255) DEFAULT NULL,
  `widget_link` varchar(255) DEFAULT NULL,
  `meta_keyword` text DEFAULT NULL,
  `meta_keyword_en` text DEFAULT NULL,
  `meta_desc` text DEFAULT NULL,
  `meta_desc_en` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `news`
--

INSERT INTO `news` (`id`, `category_id`, `img`, `thumbnail`, `title`, `title_en`, `keyword`, `keyword_en`, `slug`, `slug_en`, `content`, `content_en`, `quotes`, `quotes_en`, `widget_text`, `widget_text_en`, `widget_button`, `widget_button_en`, `widget_link`, `meta_keyword`, `meta_keyword_en`, `meta_desc`, `meta_desc_en`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'post-1.jpg', 'training-1.jpg', '5 Keuntungan Menggunakan Virtual Office', '5 Benefits of Using a Virtual Office', 'keuntungan kantor virtual, keuntungan virtual office', 'Benefits of Using a Virtual Office', '5-keuntungan-menggunakan-virtual-office', '5-benefits-of-using-a-virtual-office', '<p>Di era digital saat ini, penggunaan <i><strong>virtual office</strong></i> semakin diminati oleh pelaku usaha. Solusi ini menjadi pilihan tepat bagi bisnis yang ingin memiliki alamat profesional tanpa harus menyewa kantor fisik. Dengan biaya yang lebih terjangkau, <strong>virtual office</strong> memungkinkan perusahaan tetap terlihat kredibel dan terpercaya di mata klien.</p><p>Salah satu keuntungan utama dari <i>virtual office</i> adalah efisiensi biaya operasional. Anda tidak perlu mengeluarkan biaya besar untuk sewa gedung, listrik, hingga perawatan kantor. Meski begitu, Anda tetap mendapatkan alamat bisnis prestisius di lokasi strategis. Pelajari lebih lanjut tentang layanan ini melalui <a href=\"#\">virtual office profesional</a> yang sesuai dengan kebutuhan bisnis Anda.</p><p>Selain itu, <i><strong>virtual office</strong></i> juga menyediakan layanan tambahan seperti penerimaan surat (mail handling) dan akses ke ruang meeting. Hal ini memungkinkan Anda menjalankan bisnis secara profesional tanpa harus memiliki kantor fisik permanen. Ketika dibutuhkan, Anda tetap bisa mengadakan pertemuan dengan klien di tempat yang representatif.</p><p>Keunggulan lainnya adalah fleksibilitas kerja. Dengan menggunakan virtual office, Anda dapat bekerja dari mana saja tanpa batasan lokasi. Hal ini sangat cocok untuk startup, freelancer, maupun bisnis berbasis digital yang mengutamakan mobilitas tinggi.</p><p>Tidak hanya itu, penggunaan <strong>virtual office</strong> juga mampu meningkatkan citra profesional perusahaan. Alamat bisnis di kawasan strategis memberikan kesan lebih terpercaya dan meningkatkan peluang kerja sama dengan klien maupun investor.</p><p>Kesimpulannya, <i><strong>virtual office</strong></i> adalah solusi modern yang memberikan banyak keuntungan, mulai dari efisiensi biaya, fleksibilitas kerja, hingga peningkatan citra bisnis. Jika Anda ingin mengembangkan usaha dengan lebih praktis, maka menggunakan layanan <a href=\"#\">jasa virtual office</a> adalah langkah yang tepat.</p>', '<p>In today’s digital era, the use of a <i><strong>virtual office</strong></i> is becoming increasingly popular among entrepreneurs. This solution allows businesses to have a professional address without renting a physical office. With lower operational costs, a <strong>virtual office</strong> helps companies maintain a credible and professional image.</p><p>One of the main advantages of a <i>virtual office</i> is cost efficiency. Businesses no longer need to spend large amounts on office rent, utilities, or maintenance. Despite this, they can still enjoy a prestigious business address in a strategic location. To learn more, explore <a href=\"#\">professional virtual office services</a> tailored to your needs.</p><p>Additionally, a <i><strong>virtual office</strong></i> offers extra services such as mail handling and access to meeting rooms. This ensures that businesses can operate professionally without maintaining a physical workspace. Whenever necessary, you can still meet clients in a well-equipped and professional environment.</p><p>Another key benefit is flexibility. By using a virtual office, you can run your business from anywhere without being tied to a specific location. This is especially beneficial for startups, freelancers, and digital businesses that require high mobility.</p><p>Moreover, a <strong>virtual office</strong> enhances your company’s professional image. Having a business address in a strategic area builds trust and increases opportunities for partnerships and investments.</p><p>In conclusion, a <i><strong>virtual office</strong></i> is a modern solution that offers numerous advantages, including cost efficiency, flexibility, and improved business credibility. If you want to grow your business efficiently, choosing a <a href=\"#\">virtual office service</a> is the right decision.</p>', 'Hemat biaya, maksimal hasil.', 'Save cost, maximize results.', 'Butuh kantor virtual?', 'Need a virtual office?', 'Hubungi Kami', 'Contact Us', '#', 'virtual office, bisnis, kantor', 'virtual office, business, office', 'Manfaat virtual office untuk bisnis modern.', 'Benefits of virtual office for modern business.', 1, '2026-04-02 09:28:37', '2026-04-13 23:19:53'),
(2, 2, 'post-2.jpg', 'training-2.jpg', 'Apakah Virtual Office Bisa Untuk PT?', 'Can Virtual Office Be Used for a Company?', NULL, NULL, 'vo-untuk-pt', 'virtual-office-for-company', '<p>\r\nBanyak pelaku usaha bertanya, apakah <u><b><i>virtual office</i></b></u> bisa digunakan sebagai alamat resmi untuk mendirikan PT? \r\nJawabannya adalah <b>bisa</b>, selama layanan <i>virtual office</i> tersebut memenuhi persyaratan yang ditetapkan oleh pemerintah. \r\nHal ini menjadikan <b>virtual office</b> sebagai solusi praktis dan legal bagi bisnis modern.\r\n</p>\r\n\r\n<p>\r\nDalam proses pendirian PT, alamat bisnis merupakan salah satu syarat utama. \r\nPenggunaan <u>virtual office</u> diperbolehkan selama berada di zona komersial dan bukan di wilayah pemukiman. \r\nSelain itu, penyedia layanan juga harus memiliki izin yang sesuai agar dapat digunakan sebagai domisili perusahaan. \r\nUntuk memastikan legalitas, Anda dapat menggunakan layanan \r\n<a href=\"#\" title=\"Virtual Office Legal\">virtual office legal dan terpercaya</a> yang sudah memenuhi regulasi.\r\n</p>\r\n\r\n<p>\r\nSalah satu keunggulan menggunakan <b><i>virtual office</i></b> untuk PT adalah efisiensi biaya. \r\nAnda tidak perlu menyewa kantor fisik dengan harga mahal, namun tetap bisa mendapatkan alamat bisnis strategis. \r\nHal ini sangat membantu bagi startup dan UMKM yang ingin fokus pada pengembangan usaha tanpa terbebani biaya operasional tinggi.\r\n</p>\r\n\r\n<p>\r\nNamun, penting untuk memastikan bahwa penyedia <u><b>virtual office</b></u> memiliki dokumen pendukung yang lengkap, \r\nseperti Surat Keterangan Domisili, izin usaha gedung, serta dokumen administratif lainnya. \r\nKelengkapan dokumen ini akan mempermudah proses pengurusan legalitas PT dan menghindari kendala di masa depan.\r\n</p>\r\n\r\n<p>\r\nSelain legalitas, <i>virtual office</i> juga memberikan citra profesional bagi bisnis Anda. \r\nAlamat yang berada di lokasi strategis dapat meningkatkan kepercayaan klien dan mitra bisnis. \r\nDengan demikian, penggunaan <b><i>virtual office</i></b> tidak hanya praktis tetapi juga mendukung pertumbuhan bisnis secara optimal.\r\n</p>\r\n\r\n<p>\r\nKesimpulannya, <u><b><i>virtual office</i></b></u> dapat digunakan untuk mendirikan PT selama memenuhi syarat yang berlaku. \r\nPastikan Anda memilih penyedia layanan yang terpercaya dan memiliki legalitas lengkap. \r\nUntuk memulai, Anda bisa mempertimbangkan \r\n<a href=\"#\" title=\"Jasa Pendirian PT dan Virtual Office\">jasa pendirian PT dengan virtual office</a> agar proses lebih mudah dan cepat.\r\n</p>', '<p>\r\nMany business owners wonder whether a <u><b><i>virtual office</i></b></u> can be used as an official address to establish a company (PT). \r\nThe answer is <b>yes</b>, as long as the <i>virtual office</i> meets the legal requirements set by the government. \r\nThis makes a <b>virtual office</b> a practical and legal solution for modern businesses.\r\n</p>\r\n\r\n<p>\r\nIn the process of company registration, a business address is a crucial requirement. \r\nUsing a <u>virtual office</u> is allowed as long as it is located in a commercial zone rather than a residential area. \r\nAdditionally, the service provider must have proper licensing to be used as a company domicile. \r\nTo ensure compliance, you can choose \r\n<a href=\"#\" title=\"Legal Virtual Office Service\">a legal and trusted virtual office service</a> that meets all regulations.\r\n</p>\r\n\r\n<p>\r\nOne of the main advantages of using a <b><i>virtual office</i></b> for a company is cost efficiency. \r\nYou don’t need to rent an expensive physical office while still enjoying a prestigious business address. \r\nThis is especially beneficial for startups and small businesses that want to focus on growth without high operational costs.\r\n</p>\r\n\r\n<p>\r\nHowever, it is important to ensure that the <u><b>virtual office</b></u> provider offers complete supporting documents, \r\nsuch as a domicile certificate and other necessary permits. \r\nHaving complete documentation will make the company registration process smoother and prevent administrative issues in the future.\r\n</p>\r\n\r\n<p>\r\nBeyond legality, a <i>virtual office</i> also enhances your business image. \r\nA strategic business address builds trust and increases credibility among clients and partners. \r\nTherefore, using a <b><i>virtual office</i></b> is not only practical but also beneficial for long-term business growth.\r\n</p>\r\n\r\n<p>\r\nIn conclusion, a <u><b><i>virtual office</i></b></u> can be used to establish a company as long as it complies with regulations. \r\nMake sure to choose a reliable provider with complete legal documentation. \r\nTo get started, you may consider \r\n<a href=\"#\" title=\"Company Registration with Virtual Office\">company registration services with a virtual office</a> for a faster and easier process.\r\n</p>', 'Legalitas jadi lebih mudah.', 'Legality becomes easier.', 'Pelajari lebih lanjut', 'Learn more', 'Baca Sekarang', 'Read Now', '#', 'legalitas, pt, virtual office', 'legality, company, virtual office', 'Panduan legalitas menggunakan virtual office.', 'Guide to legality using virtual office.', 1, '2026-04-02 09:28:37', '2026-04-02 09:28:37'),
(3, 3, 'post-3.jpg', 'training-3.jpg', 'Cara Memulai Bisnis Dengan Modal Minim', 'How to Start a Business with Low Budget', NULL, NULL, 'memulai-bisnis-minim-modal', 'start-business-low-budget', '<p>\r\nMemahami <u><b><i>cara memulai bisnis</i></b></u> adalah langkah penting bagi siapa saja yang ingin memiliki usaha sendiri. \r\nBanyak orang berpikir bahwa memulai bisnis membutuhkan modal besar, padahal kenyataannya tidak selalu demikian. \r\nDengan strategi yang tepat, Anda bisa menjalankan bisnis dengan biaya minim namun tetap menghasilkan keuntungan.\r\n</p>\r\n\r\n<p>\r\nLangkah pertama dalam <b>cara memulai bisnis</b> adalah mengenali keterampilan yang Anda miliki. \r\nAnda bisa memulai dari hal sederhana seperti jasa desain grafis, penulisan artikel, hingga menjadi reseller produk. \r\nDengan memanfaatkan kemampuan yang sudah ada, Anda tidak perlu mengeluarkan biaya tambahan untuk belajar dari nol. \r\nJika Anda ingin memperluas peluang, Anda juga bisa memanfaatkan layanan \r\n<a href=\"#\" title=\"Jasa Pembuatan Website Bisnis\">jasa pembuatan website bisnis</a> untuk meningkatkan kredibilitas usaha Anda.\r\n</p>\r\n\r\n<p>\r\nSelain itu, penting untuk memilih jenis usaha dengan biaya operasional rendah. \r\nDalam <i>cara memulai bisnis</i> yang efektif, hindari model bisnis yang membutuhkan stok barang dalam jumlah besar. \r\nSebagai alternatif, Anda bisa menjalankan sistem dropshipping atau pre-order yang lebih hemat biaya. \r\nDengan cara ini, risiko kerugian dapat diminimalkan karena Anda hanya membeli produk saat ada pesanan.\r\n</p>\r\n\r\n<p>\r\nPemanfaatan platform digital juga menjadi kunci utama dalam <u>cara memulai bisnis</u>. \r\nSaat ini, media sosial seperti Instagram, TikTok, dan Facebook dapat digunakan sebagai sarana promosi gratis. \r\nSelain itu, marketplace dan website sederhana juga dapat membantu Anda menjangkau lebih banyak pelanggan. \r\nUntuk hasil yang lebih optimal, Anda bisa memanfaatkan \r\n<a href=\"#\" title=\"Jasa Digital Marketing\">layanan digital marketing profesional</a> agar strategi pemasaran lebih terarah.\r\n</p>\r\n\r\n<p>\r\nTidak kalah penting, Anda harus memahami target pasar. \r\nMengetahui siapa pelanggan Anda akan memudahkan dalam menentukan strategi pemasaran yang tepat. \r\nDalam <b><i>cara memulai bisnis</i></b>, riset pasar menjadi langkah krusial agar produk atau jasa yang ditawarkan sesuai dengan kebutuhan konsumen.\r\n</p>\r\n\r\n<p>\r\nSelanjutnya, bangun branding yang kuat sejak awal. \r\nMeskipun bisnis Anda masih kecil, memiliki identitas brand yang jelas akan membantu meningkatkan kepercayaan pelanggan. \r\nGunakan logo, warna, dan pesan yang konsisten agar bisnis Anda mudah dikenali.\r\n</p>\r\n\r\n<p>\r\nTerakhir, konsistensi adalah kunci keberhasilan. \r\nBanyak bisnis gagal bukan karena kekurangan modal, tetapi karena kurangnya ketekunan. \r\nDengan menjalankan <u><b>cara memulai bisnis</b></u> secara konsisten, Anda dapat mengembangkan usaha secara bertahap hingga mencapai kesuksesan.\r\n</p>\r\n\r\n<p>\r\nKesimpulannya, <b><i>cara memulai bisnis</i></b> dengan modal minim sangat memungkinkan jika Anda memiliki strategi yang tepat. \r\nMulai dari memanfaatkan keterampilan, memilih bisnis berbiaya rendah, hingga menggunakan platform digital, semuanya dapat membantu Anda membangun usaha dari nol. \r\nJangan ragu untuk memulai sekarang dan kembangkan bisnis Anda secara bertahap.\r\n</p>', '<p>\r\nUnderstanding <u><b><i>how to start a business</i></b></u> is essential for anyone who wants to build their own venture. \r\nMany people assume that starting a business requires a large amount of capital, but in reality, it is not always the case. \r\nWith the right strategy, you can launch a business with minimal investment and still achieve success.\r\n</p>\r\n\r\n<p>\r\nThe first step in <b>how to start a business</b> is identifying your skills. \r\nYou can begin with simple services such as graphic design, content writing, or becoming a reseller. \r\nBy leveraging your existing skills, you can reduce initial costs significantly. \r\nTo enhance your business presence, you may consider using \r\n<a href=\"#\" title=\"Business Website Development Service\">business website development services</a> to build credibility.\r\n</p>\r\n\r\n<p>\r\nChoosing a low-cost business model is also crucial. \r\nIn an effective <i>how to start a business</i> strategy, avoid models that require large inventory or high operational costs. \r\nInstead, you can adopt dropshipping or pre-order systems, which are more cost-efficient and reduce financial risks.\r\n</p>\r\n\r\n<p>\r\nUtilizing digital platforms is another key factor in <u>how to start a business</u>. \r\nSocial media platforms such as Instagram, TikTok, and Facebook can be used as free marketing tools. \r\nAdditionally, marketplaces and simple websites can help you reach a wider audience. \r\nFor better results, you can use \r\n<a href=\"#\" title=\"Digital Marketing Service\">professional digital marketing services</a> to optimize your strategy.\r\n</p>\r\n\r\n<p>\r\nUnderstanding your target market is equally important. \r\nKnowing your audience will help you create more effective marketing strategies. \r\nIn <b><i>how to start a business</i></b>, market research plays a vital role in ensuring your product or service meets customer needs.\r\n</p>\r\n\r\n<p>\r\nBuilding a strong brand from the beginning is also essential. \r\nEven if your business is small, having a clear brand identity will increase customer trust. \r\nUse consistent visuals, messaging, and tone to make your business recognizable.\r\n</p>\r\n\r\n<p>\r\nFinally, consistency is the key to success. \r\nMany businesses fail not because of lack of capital, but due to inconsistency. \r\nBy consistently applying the right <u><b>how to start a business</b></u> strategies, you can grow your business step by step.\r\n</p>\r\n\r\n<p>\r\nIn conclusion, <b><i>how to start a business</i></b> with minimal capital is absolutely possible with the right approach. \r\nBy leveraging skills, choosing low-cost models, and utilizing digital platforms, you can successfully build your business from scratch.\r\n</p>', 'Mulai dari kecil, tumbuh besar.', 'Start small, grow big.', 'Mulai Sekarang', 'Start Now', 'Coba Gratis', 'Try Free', '#', 'startup, bisnis, modal kecil', 'startup, business, low budget', 'Tips memulai bisnis dengan modal minim.', 'Tips to start a business with low budget.', 1, '2026-04-02 09:28:37', '2026-04-02 09:28:37'),
(4, 4, 'post-4.jpg', 'training-4.jpg', 'Pentingnya Alamat Bisnis Profesional', 'Importance of Professional Business Address', NULL, NULL, 'alamat-bisnis-profesional', 'professional-business-address', '<p>\r\nMemiliki <u><b><i>alamat bisnis profesional</i></b></u> merupakan salah satu faktor penting dalam membangun kepercayaan pelanggan. \r\nDi era persaingan bisnis yang semakin ketat, kredibilitas menjadi kunci utama agar usaha Anda dapat berkembang dengan baik. \r\nAlamat bisnis yang jelas, strategis, dan terlihat profesional mampu memberikan kesan bahwa perusahaan Anda dikelola secara serius.\r\n</p>\r\n\r\n<p>\r\nSalah satu manfaat utama dari <b>alamat bisnis profesional</b> adalah meningkatkan citra perusahaan. \r\nBisnis yang memiliki alamat di lokasi prestisius akan lebih mudah dipercaya dibandingkan dengan bisnis tanpa identitas yang jelas. \r\nHal ini sangat penting terutama bagi startup atau usaha yang masih dalam tahap pengembangan. \r\nUntuk solusi praktis, Anda dapat menggunakan layanan \r\n<a href=\"#\" title=\"Virtual Office Profesional\">virtual office profesional</a> yang menyediakan alamat bisnis di lokasi strategis tanpa harus menyewa kantor fisik.\r\n</p>\r\n\r\n<p>\r\nSelain meningkatkan kepercayaan, <i>alamat bisnis profesional</i> juga dibutuhkan untuk berbagai keperluan administratif. \r\nDalam menjalankan usaha, Anda akan membutuhkan alamat resmi untuk pengurusan izin usaha, pendaftaran perusahaan, hingga kerja sama dengan pihak lain. \r\nTanpa alamat yang jelas, proses administrasi ini bisa menjadi lebih rumit dan berpotensi menghambat perkembangan bisnis Anda.\r\n</p>\r\n\r\n<p>\r\nMenggunakan <u>alamat bisnis profesional</u> juga memberikan keuntungan dalam hal branding. \r\nAlamat yang berada di kawasan bisnis atau perkantoran akan memberikan nilai tambah bagi brand Anda. \r\nCalon klien akan lebih yakin untuk bekerja sama karena melihat bisnis Anda memiliki identitas yang jelas dan terpercaya.\r\n</p>\r\n\r\n<p>\r\nDalam praktiknya, tidak semua pelaku usaha harus menyewa kantor mahal untuk mendapatkan alamat bisnis. \r\nSaat ini, tersedia alternatif yang lebih efisien seperti layanan \r\n<a href=\"#\" title=\"Jasa Virtual Office\">jasa virtual office</a>. \r\nLayanan ini memungkinkan Anda memiliki <b><i>alamat bisnis profesional</i></b> lengkap dengan fasilitas tambahan seperti penerimaan surat dan ruang meeting.\r\n</p>\r\n\r\n<p>\r\nKeuntungan lainnya adalah kemudahan dalam menjalin komunikasi dengan klien. \r\nDengan adanya alamat bisnis yang jelas, pelanggan akan merasa lebih aman dan percaya terhadap layanan yang Anda tawarkan. \r\nHal ini sangat penting untuk meningkatkan loyalitas pelanggan dalam jangka panjang.\r\n</p>\r\n\r\n<p>\r\nTidak hanya itu, <u><b>alamat bisnis profesional</b></u> juga membuka peluang kerja sama yang lebih luas. \r\nDalam dunia bisnis, reputasi sangat menentukan keberhasilan. \r\nAlamat yang kredibel akan mempermudah Anda dalam membangun relasi dengan mitra bisnis maupun investor.\r\n</p>\r\n\r\n<p>\r\nKesimpulannya, <b><i>alamat bisnis profesional</i></b> bukan hanya sekadar lokasi, tetapi merupakan bagian penting dari strategi bisnis. \r\nDengan memiliki alamat yang jelas dan terpercaya, Anda dapat meningkatkan citra perusahaan, mempermudah proses administrasi, serta membuka peluang pertumbuhan yang lebih besar. \r\nJika Anda ingin memulai atau mengembangkan bisnis secara optimal, pertimbangkan untuk menggunakan \r\n<a href=\"#\" title=\"Layanan Alamat Bisnis Profesional\">layanan alamat bisnis profesional</a> sebagai langkah awal yang tepat.\r\n</p>', '<p>\r\nHaving a <u><b><i>professional business address</i></b></u> is a crucial factor in building customer trust. \r\nIn today’s competitive business environment, credibility plays a key role in ensuring long-term success. \r\nA clear, strategic, and professional address gives the impression that your business is well-managed and trustworthy.\r\n</p>\r\n\r\n<p>\r\nOne of the main benefits of a <b>professional business address</b> is enhancing your company’s image. \r\nBusinesses located in prestigious areas are generally perceived as more credible than those without a clear identity. \r\nThis is especially important for startups and growing businesses. \r\nFor a practical solution, you can use \r\n<a href=\"#\" title=\"Professional Virtual Office\">professional virtual office services</a> to obtain a strategic business address without renting a physical office.\r\n</p>\r\n\r\n<p>\r\nIn addition to improving credibility, a <i>professional business address</i> is also essential for administrative purposes. \r\nRunning a business requires an official address for permits, company registration, and partnerships. \r\nWithout a proper address, these processes can become complicated and may slow down your business growth.\r\n</p>\r\n\r\n<p>\r\nUsing a <u>professional business address</u> also strengthens your branding. \r\nAn address located in a business district adds value to your brand and increases customer confidence. \r\nClients are more likely to trust and engage with businesses that have a clear and credible presence.\r\n</p>\r\n\r\n<p>\r\nIn practice, not all business owners need to rent expensive office spaces. \r\nThere are cost-effective alternatives such as \r\n<a href=\"#\" title=\"Virtual Office Service\">virtual office services</a>. \r\nThese services provide a <b><i>professional business address</i></b> along with additional facilities like mail handling and meeting rooms.\r\n</p>\r\n\r\n<p>\r\nAnother advantage is improved communication with clients. \r\nA clear business address reassures customers and builds trust in your services. \r\nThis is particularly important for online businesses that do not have a physical storefront.\r\n</p>\r\n\r\n<p>\r\nMoreover, a <u><b>professional business address</b></u> opens up more opportunities for partnerships. \r\nIn business, reputation is everything. \r\nA credible address makes it easier to build relationships with partners and investors.\r\n</p>\r\n\r\n<p>\r\nIn conclusion, a <b><i>professional business address</i></b> is more than just a location—it is a strategic asset. \r\nIt enhances your company’s image, simplifies administrative processes, and supports business growth. \r\nIf you want to establish a strong foundation, consider using \r\n<a href=\"#\" title=\"Business Address Service\">professional business address services</a> as your starting point.\r\n</p>', 'First impression matters.', 'Kesan pertama itu penting.', 'Tingkatkan branding Anda', 'Improve your branding', 'Mulai Sekarang', 'Start Now', '#', 'alamat bisnis, branding', 'business address, branding', 'Alamat bisnis untuk meningkatkan kredibilitas.', 'Business address to increase credibility.', 1, '2026-04-02 09:28:37', '2026-04-02 09:28:37'),
(5, 1, 'post-5.jpg', 'training-5.jpg', 'Tips Menghemat Biaya Operasional Kantor', 'Tips to Reduce Office Operational Costs', NULL, NULL, 'hemat-biaya-kantor', 'reduce-office-costs', '<p>\r\nDalam dunia bisnis yang kompetitif, kemampuan <u><b><i>menghemat biaya operasional</i></b></u> menjadi salah satu kunci utama keberhasilan perusahaan. \r\nBiaya operasional yang tinggi seringkali menjadi beban yang menghambat pertumbuhan bisnis, terutama bagi startup dan usaha kecil menengah. \r\nOleh karena itu, penting bagi setiap pelaku usaha untuk menerapkan strategi efisiensi tanpa mengorbankan produktivitas.\r\n</p>\r\n\r\n<p>\r\nSalah satu cara paling efektif dalam <b>menghemat biaya operasional</b> adalah dengan memanfaatkan teknologi digital. \r\nDigitalisasi memungkinkan perusahaan mengurangi penggunaan kertas, biaya cetak, serta pengeluaran untuk penyimpanan dokumen fisik. \r\nDengan menggunakan sistem berbasis cloud, Anda dapat menyimpan data secara aman sekaligus meningkatkan kolaborasi tim. \r\nUntuk solusi modern, Anda dapat mempertimbangkan \r\n<a href=\"#\" title=\"Solusi Digital Bisnis\">solusi digital bisnis</a> yang dirancang untuk meningkatkan efisiensi kerja.\r\n</p>\r\n\r\n<p>\r\nSelain itu, penggunaan perangkat lunak berbasis cloud juga sangat membantu dalam <i>menghemat biaya operasional</i>. \r\nDengan sistem ini, perusahaan tidak perlu mengeluarkan biaya besar untuk infrastruktur IT seperti server fisik. \r\nSemua data dapat diakses kapan saja dan di mana saja, sehingga mendukung sistem kerja fleksibel yang semakin dibutuhkan di era digital.\r\n</p>\r\n\r\n<p>\r\nStrategi lain yang tidak kalah penting adalah mengadopsi sistem kerja hybrid atau remote. \r\nDengan mengurangi kebutuhan kehadiran fisik di kantor, perusahaan dapat menekan biaya listrik, air, serta kebutuhan fasilitas lainnya. \r\nBahkan, banyak perusahaan kini beralih ke \r\n<a href=\"#\" title=\"Virtual Office Terbaik\">virtual office terbaik</a> untuk mendapatkan alamat bisnis tanpa harus menyewa ruang kantor secara penuh.\r\n</p>\r\n\r\n<p>\r\nPenggunaan <u>virtual office</u> terbukti menjadi solusi praktis dalam <b><i>menghemat biaya operasional</i></b>. \r\nSelain biaya sewa yang lebih rendah, Anda juga mendapatkan berbagai fasilitas tambahan seperti layanan penerimaan surat dan ruang meeting sesuai kebutuhan. \r\nHal ini memungkinkan bisnis tetap terlihat profesional tanpa harus mengeluarkan biaya besar.\r\n</p>\r\n\r\n<p>\r\nTidak hanya itu, efisiensi biaya juga dapat dilakukan dengan mengelola penggunaan energi secara bijak. \r\nMisalnya, menggunakan peralatan hemat energi, mematikan perangkat saat tidak digunakan, serta memanfaatkan pencahayaan alami. \r\nLangkah-langkah sederhana ini dapat memberikan dampak signifikan dalam jangka panjang terhadap pengeluaran perusahaan.\r\n</p>\r\n\r\n<p>\r\nManajemen sumber daya manusia juga berperan penting dalam upaya <u><b>menghemat biaya operasional</b></u>. \r\nDengan sistem kerja yang efisien dan penggunaan teknologi yang tepat, perusahaan dapat meningkatkan produktivitas tanpa harus menambah jumlah karyawan secara berlebihan. \r\nSelain itu, pelatihan karyawan untuk meningkatkan skill juga dapat menjadi investasi jangka panjang yang menguntungkan.\r\n</p>\r\n\r\n<p>\r\nKesimpulannya, <b><i>menghemat biaya operasional</i></b> bukan berarti mengurangi kualitas bisnis, melainkan mengelola sumber daya secara lebih cerdas. \r\nDengan memanfaatkan teknologi, menerapkan sistem kerja fleksibel, serta menggunakan layanan seperti \r\n<a href=\"#\" title=\"Jasa Virtual Office Profesional\">jasa virtual office profesional</a>, \r\nAnda dapat menekan pengeluaran sekaligus meningkatkan efisiensi. \r\nStrategi ini akan membantu bisnis Anda tetap kompetitif dan berkembang secara berkelanjutan di tengah persaingan pasar yang semakin ketat.\r\n</p>', '<p>\r\nIn today’s competitive business landscape, the ability to <u><b><i>reduce operational costs</i></b></u> is essential for long-term success. \r\nHigh operational expenses can become a burden, especially for startups and small businesses. \r\nTherefore, implementing efficient strategies without compromising productivity is crucial.\r\n</p>\r\n\r\n<p>\r\nOne of the most effective ways of <b>reducing operational costs</b> is by leveraging digital technology. \r\nDigital transformation helps businesses minimize paper usage, printing expenses, and physical storage costs. \r\nBy using cloud-based systems, companies can securely store data while improving team collaboration. \r\nYou can explore \r\n<a href=\"#\" title=\"Digital Business Solutions\">digital business solutions</a> to enhance operational efficiency.\r\n</p>\r\n\r\n<p>\r\nCloud-based software also plays a significant role in <i>reducing operational costs</i>. \r\nWith this system, businesses no longer need to invest heavily in IT infrastructure such as physical servers. \r\nData can be accessed anytime and anywhere, supporting a flexible work environment that is increasingly important in the digital era.\r\n</p>\r\n\r\n<p>\r\nAnother effective strategy is adopting hybrid or remote working systems. \r\nBy reducing the need for physical office presence, companies can significantly cut expenses related to electricity, utilities, and office maintenance. \r\nMany businesses are now turning to \r\n<a href=\"#\" title=\"Best Virtual Office\">best virtual office services</a> to maintain a professional address without renting a full office space.\r\n</p>\r\n\r\n<p>\r\nUsing a <u>virtual office</u> is a practical solution for <b><i>reducing operational costs</i></b>. \r\nIt offers lower rental expenses along with additional services such as mail handling and meeting rooms. \r\nThis allows businesses to maintain a professional image while minimizing overhead costs.\r\n</p>\r\n\r\n<p>\r\nEnergy management is another key factor in cost efficiency. \r\nUsing energy-saving equipment, turning off unused devices, and maximizing natural lighting can significantly reduce expenses over time. \r\nThese simple steps can create a substantial impact on your company’s budget.\r\n</p>\r\n\r\n<p>\r\nHuman resource management also contributes to <u><b>reducing operational costs</b></u>. \r\nWith efficient workflows and proper use of technology, companies can boost productivity without hiring excessive staff. \r\nInvesting in employee training is also beneficial for long-term growth and efficiency.\r\n</p>\r\n\r\n<p>\r\nIn conclusion, <b><i>reducing operational costs</i></b> does not mean lowering business quality. \r\nInstead, it involves managing resources more intelligently. \r\nBy adopting digital tools, flexible work systems, and services like \r\n<a href=\"#\" title=\"Professional Virtual Office Services\">professional virtual office services</a>, \r\nbusinesses can reduce expenses while improving efficiency. \r\nThis approach ensures sustainable growth and competitiveness in an ever-evolving market.\r\n</p>', 'Efisien adalah kunci.', 'Efficiency is key.', 'Hemat Sekarang', 'Save Now', 'Lihat Solusi', 'See Solutions', '#', 'biaya kantor, efisiensi', 'office cost, efficiency', 'Cara menghemat biaya kantor.', 'How to reduce office costs.', 1, '2026-04-02 09:28:37', '2026-04-02 09:28:37'),
(6, 4, 'post-6.jpg', 'training-6.jpg', 'Tren Bisnis Digital 2025', 'Digital Business Trends 2025', NULL, NULL, 'tren-bisnis-digital', 'digital-business-trends', '<p>\r\nMemasuki tahun 2025, perkembangan teknologi semakin pesat dan membawa perubahan besar dalam dunia usaha. \r\n<u><b><i>Tren Bisnis Digital 2025</i></b></u> diprediksi akan didominasi oleh inovasi berbasis teknologi seperti e-commerce, kecerdasan buatan (AI), dan strategi digital marketing yang semakin canggih. \r\nPerusahaan yang mampu beradaptasi dengan perubahan ini akan memiliki peluang besar untuk berkembang dan memenangkan persaingan pasar.\r\n</p>\r\n\r\n<p>\r\nSalah satu pilar utama dalam <b>Tren Bisnis Digital 2025</b> adalah pertumbuhan e-commerce yang semakin signifikan. \r\nPerilaku konsumen kini lebih banyak beralih ke platform online karena kemudahan akses dan kecepatan transaksi. \r\nUntuk memaksimalkan peluang ini, bisnis perlu memiliki strategi digital yang kuat, termasuk penggunaan website profesional dan optimasi SEO. \r\nAnda dapat memanfaatkan \r\n<a href=\"#\" title=\"Jasa Pembuatan Website\">jasa pembuatan website profesional</a> \r\nuntuk membangun fondasi digital yang kuat.\r\n</p>\r\n\r\n<p>\r\nSelain e-commerce, teknologi kecerdasan buatan juga menjadi bagian penting dari <i>Tren Bisnis Digital 2025</i>. \r\nAI memungkinkan bisnis untuk menganalisis data pelanggan secara lebih akurat, sehingga dapat memberikan layanan yang lebih personal. \r\nPersonalisasi ini menjadi kunci dalam meningkatkan pengalaman pelanggan dan membangun loyalitas jangka panjang.\r\n</p>\r\n\r\n<p>\r\nTidak hanya itu, strategi digital marketing juga mengalami transformasi signifikan. \r\nBisnis kini tidak cukup hanya hadir secara online, tetapi harus mampu memberikan konten yang relevan dan menarik. \r\nPenggunaan media sosial, email marketing, dan iklan digital harus dioptimalkan secara maksimal. \r\nUntuk hasil yang lebih optimal, Anda bisa menggunakan \r\n<a href=\"#\" title=\"Jasa Digital Marketing\">jasa digital marketing terpercaya</a> \r\nyang dapat membantu meningkatkan visibilitas bisnis Anda.\r\n</p>\r\n\r\n<p>\r\nDalam menghadapi <u>Tren Bisnis Digital 2025</u>, kecepatan dan responsivitas menjadi faktor penentu keberhasilan. \r\nKonsumen saat ini menginginkan layanan yang cepat, mudah, dan sesuai dengan kebutuhan mereka. \r\nOleh karena itu, bisnis perlu mengadopsi sistem yang mampu memberikan respon real-time, seperti chatbot atau layanan otomatis berbasis AI.\r\n</p>\r\n\r\n<p>\r\nSelain aspek teknologi, efisiensi operasional juga menjadi bagian penting dari <b><i>Tren Bisnis Digital 2025</i></b>. \r\nBanyak perusahaan mulai beralih ke sistem kerja fleksibel dan memanfaatkan layanan seperti \r\n<a href=\"#\" title=\"Virtual Office Modern\">virtual office modern</a> \r\nuntuk mengurangi biaya operasional tanpa mengurangi profesionalitas bisnis. \r\nLangkah ini memungkinkan perusahaan untuk tetap kompetitif di tengah perubahan yang cepat.\r\n</p>\r\n\r\n<p>\r\nKeamanan data juga menjadi perhatian utama dalam era digital. \r\nDengan meningkatnya aktivitas online, risiko kebocoran data juga semakin tinggi. \r\nOleh karena itu, bisnis harus memastikan sistem keamanan yang kuat untuk melindungi data pelanggan dan menjaga kepercayaan mereka.\r\n</p>\r\n\r\n<p>\r\nKesimpulannya, <b><i>Tren Bisnis Digital 2025</i></b> menuntut bisnis untuk lebih adaptif, inovatif, dan berorientasi pada pelanggan. \r\nDengan memanfaatkan teknologi seperti AI, mengoptimalkan digital marketing, serta menggunakan layanan pendukung seperti \r\n<a href=\"#\" title=\"Solusi Bisnis Digital\">solusi bisnis digital</a>, \r\nperusahaan dapat meningkatkan daya saing dan mencapai pertumbuhan yang berkelanjutan. \r\nKini saatnya Anda mengambil langkah strategis untuk menghadapi masa depan bisnis digital yang semakin dinamis.\r\n</p>', '<p>\r\nAs we approach 2025, technological advancements continue to reshape the business landscape. \r\n<u><b><i>Digital Business Trends 2025</i></b></u> are expected to be driven by innovations in e-commerce, artificial intelligence (AI), and advanced digital marketing strategies. \r\nBusinesses that can adapt to these changes will have greater opportunities to grow and outperform competitors.\r\n</p>\r\n\r\n<p>\r\nOne of the key drivers of <b>Digital Business Trends 2025</b> is the rapid growth of e-commerce. \r\nConsumers are increasingly shifting towards online platforms due to convenience and speed. \r\nTo capitalize on this trend, businesses need a strong digital presence, including a professional website and effective SEO strategies. \r\nYou can leverage \r\n<a href=\"#\" title=\"Website Development Services\">professional website development services</a> \r\nto build a solid online foundation.\r\n</p>\r\n\r\n<p>\r\nArtificial intelligence is another major component of <i>Digital Business Trends 2025</i>. \r\nAI enables businesses to analyze customer data more accurately, allowing them to deliver personalized experiences. \r\nThis level of personalization is essential for improving customer satisfaction and building long-term loyalty.\r\n</p>\r\n\r\n<p>\r\nDigital marketing strategies are also evolving rapidly. \r\nSimply being online is no longer enough—businesses must create relevant and engaging content. \r\nSocial media, email marketing, and paid advertising must be optimized effectively. \r\nTo achieve better results, consider using \r\n<a href=\"#\" title=\"Digital Marketing Services\">trusted digital marketing services</a> \r\nto increase your business visibility.\r\n</p>\r\n\r\n<p>\r\nIn the era of <u>Digital Business Trends 2025</u>, speed and responsiveness are critical success factors. \r\nModern consumers expect fast, seamless, and personalized services. \r\nBusinesses should implement systems such as chatbots or AI-driven automation to provide real-time responses.\r\n</p>\r\n\r\n<p>\r\nOperational efficiency is another important aspect of <b><i>Digital Business Trends 2025</i></b>. \r\nMany companies are adopting flexible work systems and utilizing services like \r\n<a href=\"#\" title=\"Modern Virtual Office\">modern virtual office solutions</a> \r\nto reduce operational costs while maintaining professionalism. \r\nThis approach helps businesses remain competitive in a rapidly changing environment.\r\n</p>\r\n\r\n<p>\r\nData security is also a major concern in the digital era. \r\nWith increased online activity, the risk of data breaches is higher. \r\nBusinesses must implement strong security measures to protect customer data and maintain trust.\r\n</p>\r\n\r\n<p>\r\nIn conclusion, <b><i>Digital Business Trends 2025</i></b> require businesses to be adaptive, innovative, and customer-focused. \r\nBy leveraging AI, optimizing digital marketing strategies, and using support services like \r\n<a href=\"#\" title=\"Digital Business Solutions\">digital business solutions</a>, \r\ncompanies can enhance competitiveness and achieve sustainable growth. \r\nNow is the time to take strategic action and prepare for the future of digital business.\r\n</p>', 'Ikuti tren, jangan tertinggal.', 'Follow trends, don’t fall behind.', 'Pelajari Tren', 'Learn Trends', 'Baca Artikel', 'Read Article', '#', 'tren bisnis, digital', 'business trends, digital', 'Perkembangan tren bisnis digital terbaru.', 'Latest digital business trends.', 1, '2026-04-02 09:28:37', '2026-04-02 09:28:37');

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

--
-- Struktur dari tabel `opening_hours`
--

CREATE TABLE `opening_hours` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `day` varchar(255) DEFAULT NULL,
  `day_en` varchar(255) DEFAULT NULL,
  `hour` varchar(255) DEFAULT NULL,
  `hour_en` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `promos`
--

CREATE TABLE `promos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `img` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `desc_en` text DEFAULT NULL,
  `list` text DEFAULT NULL,
  `list_en` text DEFAULT NULL,
  `btn_text` varchar(255) DEFAULT NULL,
  `btn_text_en` varchar(255) DEFAULT NULL,
  `btn_link` varchar(255) DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `seos`
--

CREATE TABLE `seos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_description_en` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `meta_keywords_en` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `seos`
--

INSERT INTO `seos` (`id`, `page`, `title`, `title_en`, `meta_description`, `meta_description_en`, `meta_keywords`, `meta_keywords_en`, `created_at`, `updated_at`) VALUES
(2, 'home', 'Amethyst Suites - Virtual Office Jakarta Terbaik & Kantor Virtual Profesional', 'Amethyst Suites - Best Virtual Office in Jakarta & Professional Business Address', 'Amethyst Suites menyediakan layanan virtual office Jakarta dengan alamat bisnis prestisius, layanan legal, dan fasilitas kantor modern untuk mendukung bisnis Anda.', 'Amethyst Suites provides the best virtual office in Jakarta with a prestigious business address, legal services, and modern office facilities to support your business.', 'virtual office jakarta, kantor virtual jakarta, virtual office murah, alamat bisnis jakarta, sewa kantor virtual', 'virtual office jakarta, business address jakarta, virtual office indonesia, affordable virtual office, office rental jakarta', '2026-04-13 11:34:10', '2026-04-13 11:34:10'),
(3, 'about', 'Tentang Amethyst Suites - Penyedia Virtual Office Profesional', 'About Amethyst Suites - Professional Virtual Office Provider', 'Amethyst Suites adalah penyedia layanan virtual office terpercaya dengan alamat bisnis strategis dan layanan profesional untuk menunjang pertumbuhan usaha Anda.', 'Amethyst Suites is a trusted virtual office provider offering strategic business addresses and professional services to support your business growth.', 'tentang virtual office, kantor virtual jakarta, profil perusahaan virtual office, jasa virtual office', 'about virtual office, company profile virtual office, business address provider, office services', '2026-04-13 11:34:10', '2026-04-13 11:34:10'),
(4, 'career', 'Lowongan Kerja Amethyst Suites - Bergabung Bersama Kami', 'Careers at Amethyst Suites - Join Our Team', 'Temukan peluang karir terbaik di Amethyst Suites. Bergabunglah bersama tim profesional kami di industri virtual office dan layanan bisnis.', 'Discover career opportunities at Amethyst Suites. Join our professional team in the virtual office and business services industry.', 'lowongan kerja jakarta, karir virtual office, pekerjaan kantor, hiring jakarta', 'jobs jakarta, career virtual office, office jobs indonesia, hiring jakarta', '2026-04-13 11:34:10', '2026-04-13 11:34:10'),
(6, 'contact', 'Kontak Amethyst Suites - Virtual Office Jakarta', 'Contact Amethyst Suites - Virtual Office Jakarta', 'Hubungi Amethyst Suites untuk mendapatkan layanan virtual office terbaik di Jakarta dengan harga terjangkau dan fasilitas lengkap.', 'Contact Amethyst Suites to get the best virtual office services in Jakarta with affordable pricing and complete facilities.', 'kontak virtual office, kantor virtual jakarta, alamat amethyst suites, hubungi kami', 'contact virtual office, business address jakarta contact, office services contact', '2026-04-13 11:34:10', '2026-04-13 11:34:10'),
(7, 'news', 'Berita & Artikel Virtual Office - Amethyst Suites', 'News & Articles About Virtual Office - Amethyst Suites', 'Dapatkan informasi terbaru seputar virtual office, bisnis, dan tips pengembangan usaha bersama Amethyst Suites.', 'Get the latest news about virtual office, business insights, and growth tips with Amethyst Suites.', 'berita virtual office, artikel bisnis, tips usaha, kantor virtual jakarta', 'virtual office news, business articles, startup tips, office insights', '2026-04-13 11:34:10', '2026-04-13 11:34:10'),
(8, 'gallery', 'Galeri Amethyst Suites - Virtual Office & Fasilitas Kantor', 'Amethyst Suites Gallery - Virtual Office & Office Facilities', 'Lihat galeri fasilitas kantor, ruang meeting, dan layanan virtual office dari Amethyst Suites yang modern dan profesional.', 'Explore our office facilities, meeting rooms, and virtual office services at Amethyst Suites.', 'galeri kantor virtual, virtual office jakarta, fasilitas kantor, meeting room jakarta', 'office gallery, virtual office facilities, meeting room jakarta, office space gallery', '2026-04-13 11:34:10', '2026-04-13 11:34:10');

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

--
-- Struktur dari tabel `seo_settings`
--

CREATE TABLE `seo_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_name` varchar(255) DEFAULT NULL,
  `page_name_en` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_title_en` varchar(255) DEFAULT NULL,
  `meta_keyword` text DEFAULT NULL,
  `meta_keyword_en` text DEFAULT NULL,
  `meta_desc` text DEFAULT NULL,
  `meta_desc_en` text DEFAULT NULL,
  `og_img` varchar(255) DEFAULT NULL,
  `header_img` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `slug_en` varchar(255) DEFAULT NULL,
  `img_thumbnail` varchar(255) DEFAULT NULL,
  `short` text DEFAULT NULL,
  `short_en` text DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `desc_en` text DEFAULT NULL,
  `list` text DEFAULT NULL,
  `list_en` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_text_en` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `services`
--

INSERT INTO `services` (`id`, `title`, `title_en`, `slug`, `slug_en`, `img_thumbnail`, `short`, `short_en`, `desc`, `desc_en`, `list`, `list_en`, `button_text`, `button_text_en`, `link`, `status`, `created_at`, `updated_at`) VALUES
(1, 'kantor siap pakai', 'serviced office', 'kantor-siap-pakai', 'serviced-office', 'service-1.jpg', 'Solusi praktis bagi perusahaan yang membutuhkan ruang kerja profesional tanpa repot menyiapkan infrastruktur kantor dari awal.', 'Practical solution for companies that need a professional workspace without the hassle of setting up office infrastructure from scratch.', 'Kami menyediakan kantor siap pakai sebagai solusi praktis bagi perusahaan yang membutuhkan ruang kerja profesional tanpa harus repot menyiapkan infrastruktur dari awal. Dilengkapi fasilitas lengkap dan lingkungan kerja modern untuk mendukung produktivitas serta kenyamanan operasional bisnis Anda.', 'We offer serviced office solutions for businesses that need prestigious workspace without the hassle of setting up infrastructure from scratch. Equipped with modern facilities in a productive environment to support efficient and comfortable business operations.', 'Siap digunakan tanpa setup awal\r\nFasilitas lengkap dan modern\r\nLingkungan kerja profesional\r\nHemat waktu dan biaya operasional', 'Ready to use with no setup required\r\nModern, fully equipped facilities\r\nProfessional working environment\r\nSave time and operational costs', 'dapatkan penawaran', 'get offers', 'https://wa.me/6289636941722?text=Halo%20saya%20tertarik%20dengan%20layanan%20serviced%20office%20dan%20ingin%20mengetahui%20informasi%20harga%20dan%20layanan%20lebih%20lanjut', 1, NULL, '2026-04-15 23:50:13'),
(2, 'kantor virtual', 'virtual office', 'kantor-virtual', 'virtual-office', 'service-2.jpg', 'Virtual Office cocok untuk legalitas perusahaan, korespondensi bisnis, serta meningkatkan kredibilitas usaha Anda.', 'Suitable for company legality, business correspondence, and increasing the credibility of your business.', 'Layanan kantor virtual yang menyediakan alamat bisnis profesional, ideal untuk legalitas perusahaan, korespondensi bisnis, serta meningkatkan kredibilitas brand Anda. Cocok untuk startup, freelancer, dan bisnis yang sedang berkembang yang membutuhkan lokasi strategis, efisiensi biaya, serta citra terpercaya untuk mendukung operasional harian dan pertumbuhan jangka panjang.', 'Virtual office services that provide prestigious business address, ideal for company legality, business correspondence, and enhancing your brand credibility. Perfect for startups, freelancers, and growing businesses seeking a strategic location, cost efficiency, and a trusted image to support daily operations and long-term business growth.', 'Alamat bergengsi untuk pendaftaran dan legalitas perusahaan\r\nLayanan penanganan surat dan korespondensi bisnis yang andal\r\nSolusi hemat biaya tanpa perlu kantor fisik\r\nMeningkatkan kredibilitas brand dan citra bisnis profesional', 'Prestigious business address for company registration and legality\r\nReliable mail handling and business correspondence services\r\nCost-effective solution without the need for a physical office\r\nEnhance brand credibility and professional business image', 'dapatkan penawaran', 'get offers', 'https://wa.me/6289636941722?text=Halo%20saya%20tertarik%20dengan%20layanan%20virtual%20office%20dan%20ingin%20mengetahui%20informasi%20harga%20dan%20layanan%20lebih%20lanjut', 1, NULL, '2026-04-15 23:53:59'),
(3, 'ruang kerja', 'coworking space', 'ruang-kerja', 'coworking-space', 'service-3.jpg', 'Coworking space dengan fasilitas lengkap dan lingkungan kerja yang kondusif, cocok untuk meeting, kolaborasi tim, maupun aktivitas kerja harian.', 'Coworking space with complete facilities in a conducive work environment, suitable for meetings, team collaboration, and daily work activities.', 'Kami menyediakan ruang kerja yang nyaman dengan fasilitas lengkap dan lingkungan profesional yang kondusif. Sangat cocok untuk meeting, kolaborasi tim, maupun aktivitas kerja harian agar produktivitas Anda semakin optimal.', 'We provide comfortable workspaces with complete facilities and a professional, productive environment. Perfect for meetings, team collaboration, and daily work activities to help boost your productivity and efficiency.', 'Fasilitas lengkap dan modern\r\nLingkungan kerja nyaman & kondusif\r\nMendukung kolaborasi dan meeting\r\nFleksibel sesuai kebutuhan bisnis', 'Modern, fully equipped facilities\r\nComfortable and productive environment\r\nIdeal for meetings and collaboration\r\nFlexible to suit business needs', 'dapatkan penawaran', 'get offers', 'https://wa.me/6289636941722?text=Halo%20saya%20tertarik%20dengan%20layanan%20coworking%20space%20dan%20ingin%20mengetahui%20informasi%20harga%20dan%20layanan%20lebih%20lanjut', 1, NULL, '2026-04-15 23:55:47'),
(4, 'ruang meeting', 'meeting room', 'ruang-meeting', 'meeting-room', 'meeting-room.jpg', 'Dilengkapi dengan fasilitas pendukung agar setiap pertemuan berjalan lebih efektif dan produktif.', 'Equipped with supporting facilities so meetings run more effectively and productively.', 'Ruang meeting modern yang nyaman dan representatif, dilengkapi berbagai fasilitas pendukung seperti proyektor, WiFi cepat, dan sistem audio. Dirancang untuk meningkatkan produktivitas, kolaborasi tim, serta efektivitas setiap pertemuan bisnis, presentasi, maupun diskusi penting agar berjalan lancar dan profesional.', 'Modern, comfortable, and professional meeting room equipped with supporting facilities such as projector, high-speed WiFi, and audio system. Designed to enhance productivity, team collaboration, and effective business meeting, presentation, or important discussion.', 'Internet stabil untuk mendukung meeting virtual\r\nPeralatan presentasi lengkap\r\nRuang yang nyaman dan ergonomis\r\nSuasana profesional yang cocok untuk berbagai meeting', 'Stable internet connection to support virtual meetings\r\nComplete presentation equipment\r\nComfortable and ergonomic space\r\nProfessional ambiance suitable for various meetings', 'dapatkan penawaran', 'get offers', 'https://wa.me/6289636941722?text=Halo%20saya%20tertarik%20dengan%20layanan%20meeting%20room%20dan%20ingin%20mengetahui%20informasi%20harga%20dan%20layanan%20lebih%20lanjut', 1, NULL, '2026-04-16 00:02:12'),
(5, 'pajak & keuangan', 'tax & financial', 'pajak-keuangan', 'tax-financial', 'konsultan-pajak.jpg', 'Layanan konsultasi pajak dan keuangan yang komprehensif untuk membantu bisnis Anda tetap tertata dan patuh regulasi', 'Comprehensive tax and financial consulting services to help your business stay organized and compliant.', 'Kami menyediakan layanan pajak dan keuangan yang komprehensif untuk membantu bisnis Anda tetap tertata dan patuh regulasi. Mulai dari pencatatan keuangan, pelaporan pajak, hingga konsultasi strategis untuk mendukung pertumbuhan usaha secara berkelanjutan dan profesional.', 'We provide comprehensive tax and financial services to help your business stay organized and compliant. From bookkeeping and tax reporting to strategic financial consultation, our solutions support sustainable and professional business growth.', 'Pencatatan keuangan rapih & akurat\r\nPelaporan pajak tepat waktu', 'Accurate and organized bookkeeping\r\nTimely tax reporting', 'konsultasi gratis', 'ask for free', 'https://wa.me/6289636941722?text=Halo%20saya%20tertarik%20dengan%20layanan%20konsultasi%20Finansial%20dan%20ingin%20mengetahui%20informasi%20harga%20dan%20layanan%20lebih%20lanjut', 1, NULL, '2026-04-18 03:55:04'),
(6, 'pendirian usaha', 'company establishment', 'pendirian-usaha', 'company-establishment', 'pendirian-badan-usaha.jpg', 'Kami membantu proses pendirian perusahaan secara cepat dan legal sehingga bisnis Anda siap beroperasi dengan alamat resmi.', 'We help with the company establishment process quickly and legally so that your business is ready to operate with an official address.', 'Kami membantu proses pendirian perusahaan secara cepat dan legal sehingga bisnis Anda siap beroperasi dengan alamat resmi.', 'We help with the company establishment process quickly and legally so that your business is ready to operate with an official address.', 'Alamat bisnis strategis & legal\r\nPenerimaan surat\r\nNomor telepon bisnis', 'Strategic & legal business address\r\nMail receipt\r\nBusiness telephone number', 'konsultasi gratis', 'ask for free', 'https://wa.me/6289636941722?text=Halo%20saya%20tertarik%20dengan%20layanan%20Pendirian%20Badan%20Usaha%20dan%20ingin%20mengetahui%20informasi%20harga%20dan%20layanan%20lebih%20lanjut', 1, '2026-04-10 10:15:52', '2026-04-11 09:04:44');

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

--
-- Struktur dari tabel `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('0hkI99TzYSBCpmH8vn1D40T2QueLakMawItxg0DB', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiI2ZlVDM2dUbThIa0dCUG9HRDBXRnVpaG96OXFjT1NoMUxROEt5RkNWIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9mb3JtdWxpci1sYW1hcmFuLWtlcmphP3Bvc2l0aW9uPUN1c3RvbWVyJTIwU2VydmljZSIsInJvdXRlIjoiYXBwbHkuZm9ybSJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19', 1776687974),
('5wNXfRcI21JsZcOuIvorPP13YEbHVjU23Xdd8r1I', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiJmS1JTSlBnMXloMGVreXZaWUFGUFltMjlieXVQZ3E5eWRvMXdaR2dhIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9uZXdzP2NhdGVnb3J5PXN0YXJ0dXAiLCJyb3V0ZSI6Im5ld3MifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776687492),
('A1PFqM1j25fbuju3W3vnRgn9b4b2jydzJxz1ZYor', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiIxRDROdnltdWRwRnJOb004Z013ZU10a1JBVVMzdDBKaXY5Sm5BSHpUIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9uZXdzP2NhdGVnb3J5PWJpc25pcyIsInJvdXRlIjoibmV3cyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19', 1776687616),
('Dr7I0q8jTZO9nY48H6tS1XB1X1zjTPKLmLKeFwnv', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiJRTk1VcVRIYWEyM3EyS0FNek5uRTVhTHNBWGxtNjl3b3VLaVJ3MGpNIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9mb3JtdWxpci1sYW1hcmFuLWtlcmphP3Bvc2l0aW9uPURpZ2l0YWwlMjBNYXJrZXRpbmciLCJyb3V0ZSI6ImFwcGx5LmZvcm0ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776688103),
('gyijj4Vo5eWbubcOEKFuUveLmj2o2s4ixdrFKS5u', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiIxNHdrZm1MWklPNmN6OGcxM0F2a2RlVjh6WlVPcHlZUmZFWWp4aWR3IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9mb3JtdWxpci1sYW1hcmFuLWtlcmphP3Bvc2l0aW9uPVNhbGVzJTIwRXhlY3V0aXZlIiwicm91dGUiOiJhcHBseS5mb3JtIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1776688066),
('ittO4DZVsov3lfemzrRg6Q9zYkLgtzDPhGoP7eLI', NULL, '66.132.172.98', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'eyJfdG9rZW4iOiJVdlBwUkhaTE1DNk1yN3F4MXZ1VjdKTTNRTVc1U1RSVDdTWFVkNnFBIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL3d3dy5hbWV0aHlzdC5ydWJpY3dlYi5jb20iLCJyb3V0ZSI6ImhvbWUifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776922686),
('jvb124TkjBQR7qj9LEYJ0QO3lCJlkJRBofEHj9sN', NULL, '79.127.186.217', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36', 'eyJfdG9rZW4iOiJmc0FiVWxJQ1pYYXVTeHljOUZVakNXdzNwTGRlUVV4dnNtQUxtbm5QIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1777336374),
('KJQklDsUoeB33L1bvU1ZJCSzfcHD324hD0cuaITs', NULL, '95.181.236.32', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJQeW9xOEwzcG1tNERScjdLSDRFTElXZkpkblVmdVg2cjJGaUJWbWhQIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC9hbWV0aHlzdC5ydWJpY3dlYi5jb20iLCJyb3V0ZSI6ImhvbWUifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776787415),
('mjMEtHiKm54SwAOvQR5yzKMrtrFmOROoIYaxPpqK', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiJBTnkzeEtCWkR0S1o4cHlxT2Q4YWJsMVpUQWp1VFFnSFBySjNtaGc2IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9uZXdzXC93aGF0c2FwcC5jb20iLCJyb3V0ZSI6Im5ld3MuZGV0YWlsIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1776687491),
('NTpoe7TUxgBf22rmURbTq2Pkz5840hY7DZ3AGiy4', NULL, '205.210.31.50', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'eyJfdG9rZW4iOiJiUGF0RGhKb0pZcHpCd0U3TlNVNVNyTzd4RmZ2b04weTQ3OWZlbHpnIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tIiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1777139383),
('P5VmB4m6SMGK7CZHACp8tyBTPLY76sXO8p0M3W5n', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiJHVzMyUUJxd3ZOd1p3QlVHMzFzaWExVGxpSmV4SGNFSVlpdnNic3AzIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9uZXdzP2NhdGVnb3J5PWxlZ2FsaXRhcyIsInJvdXRlIjoibmV3cyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19', 1776687794),
('tXXihky9WIrVMqvNL4nYLgijaGsCe51450FaOwJw', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiJNYVYyUmJ0R3lqTXpCUjZiV2VkRjBqSE5jWDV2WHc2WHQ2Ym84bURkIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9uZXdzXC9oZW1hdC1iaWF5YS1rYW50b3IiLCJyb3V0ZSI6Im5ld3MuZGV0YWlsIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1776688057),
('X5ojC9l2XX0fnxAGIrsZOCGhwCn0WNslTINZbjcY', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiIzaGx5NHQ0dlRKNjhFVXR3NUFaOUNUSDQ1aXNybEp3OFhNWmJxQ0J5IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9mb3JtdWxpci1sYW1hcmFuLWtlcmphIiwicm91dGUiOiJhcHBseS5mb3JtIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1776693951),
('xEPKAXAWwMkcmVi9cMF2H76YHKjYtAylEO6r9QIT', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiJUS0VPcmhnTzNLdEd6NjJKazU4THJGYTQ2cXZOSDUxN21iVW9pT3N3IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9uZXdzP2NhdGVnb3J5PXRpcHMiLCJyb3V0ZSI6Im5ld3MifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776687448),
('YIvVths4KZG1MugCTLY4j1txf7cqoBy78vEYpwgu', NULL, '216.73.217.46', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'eyJfdG9rZW4iOiJUSDI4MXZSb3JHeEtUeUVYc2JSdVI1cE9CWllQendHQW1nVnQzYUdRIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHBzOlwvXC93d3cuYW1ldGh5c3QucnViaWN3ZWIuY29tXC9uZXdzXC90cmVuLWJpc25pcy1kaWdpdGFsIiwicm91dGUiOiJuZXdzLmRldGFpbCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19', 1776687980);

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

--
-- Struktur dari tabel `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `navbar` text DEFAULT NULL,
  `navbar_en` text DEFAULT NULL,
  `site` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `alt_logo` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `email_alt` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `phone_alt` varchar(255) DEFAULT NULL,
  `wa` varchar(255) DEFAULT NULL,
  `main_address` text DEFAULT NULL,
  `main_address_en` text DEFAULT NULL,
  `branch_address` text DEFAULT NULL,
  `branch_address_en` text DEFAULT NULL,
  `open_hour_1` varchar(255) DEFAULT NULL,
  `open_hour_1_en` varchar(255) DEFAULT NULL,
  `open_hour_2` varchar(255) DEFAULT NULL,
  `open_hour_2_en` varchar(255) DEFAULT NULL,
  `open_hour_3` varchar(255) DEFAULT NULL,
  `open_hour_3_en` varchar(255) DEFAULT NULL,
  `fb` varchar(255) DEFAULT NULL,
  `ig` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `wa_community` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `site_settings`
--

INSERT INTO `site_settings` (`id`, `navbar`, `navbar_en`, `site`, `logo`, `alt_logo`, `email`, `email_alt`, `phone`, `phone_alt`, `wa`, `main_address`, `main_address_en`, `branch_address`, `branch_address_en`, `open_hour_1`, `open_hour_1_en`, `open_hour_2`, `open_hour_2_en`, `open_hour_3`, `open_hour_3_en`, `fb`, `ig`, `linkedin`, `wa_community`, `created_at`, `updated_at`) VALUES
(1, '<a href=\'/\' class=\'nav-item nav-link nav-home\'>Beranda</a>\r\n<a href=\'/#services-section\' class=\'nav-item nav-link\'>Layanan</a>\r\n<a href=\'/#testimoni-section\' class=\'nav-item nav-link\'>Testimoni</a>\r\n\r\n<div class=\'nav-item dropdown\'>\r\n    <a href=\'#\' class=\'nav-link dropdown-toggle\' data-bs-toggle=\'dropdown\'>\r\n        Informasi\r\n    </a>\r\n    <div class=\'dropdown-menu m-0\'>\r\n        <a href=\'/tentang-kami\' class=\'dropdown-item\'>Tentang Kami</a>\r\n        <a href=\'/lowongan-kerja-terbaru\' class=\'dropdown-item\'>Lowongan Kerja</a>\r\n        <a href=\'/news\' class=\'dropdown-item\'>Berita & Artikel</a>\r\n        <a href=\'/gallery\' class=\'dropdown-item\'>Galeri</a>\r\n        <a href=\'/contact\' class=\'dropdown-item\'>Kontak Kami</a>\r\n    </div>\r\n</div>\r\n\r\n<a href=\'/#\' id=\'promoBtn\' class=\'nav-item nav-link\'>\r\n    Promo <span class=\'fas fa-fire text-danger\'></span>\r\n</a>', '<a href=\'/\' class=\'nav-item nav-link nav-home\'>Home</a>\r\n<a href=\'/#services-section\' class=\'nav-item nav-link\'>Services</a>\r\n<a href=\'/#testimoni-section\' class=\'nav-item nav-link\'>Testimonials</a>\r\n\r\n<div class=\'nav-item dropdown\'>\r\n    <a href=\'#\' class=\'nav-link dropdown-toggle\' data-bs-toggle=\'dropdown\'>\r\n        Information\r\n    </a>\r\n    <div class=\'dropdown-menu m-0\'>\r\n        <a href=\'/tentang-kami\' class=\'dropdown-item\'>About Us</a>\r\n        <a href=\'/lowongan-kerja-terbaru\' class=\'dropdown-item\'>Job Vacancy</a>\r\n        <a href=\'/news\' class=\'dropdown-item\'>News & Article</a>\r\n        <a href=\'/gallery\' class=\'dropdown-item\'>Gallery</a>\r\n        <a href=\'/contact\' class=\'dropdown-item\'>Contact</a>\r\n    </div>\r\n</div>\r\n\r\n<a href=\'/#\' id=\'promoBtn\' class=\'nav-item nav-link\'>\r\n    Promo <span class=\'fas fa-fire text-danger\'></span>\r\n</a>', 'https://www.amethystsuites.com', '0s8IqsKBNLYtXhoHJB3j0BoLDlM0nz6ReQKn3H3z.png', 'OZob5fxDaAIyE3spI22wJOoA1XWqagLtlf8uORh2.png', 'sales@amethystsuites.com', 'sales@amethystsuites.com', '+622180631631 (phone)', '+6289636941722 (sales)', '6281234567890', 'Jl. Jenderal Sudirman 86, Jakarta Pusat (Head Office)', 'Jl. Jenderal Sudirman 86, Central Jakarta 10220, Indonesia (Head Office)', 'Jl. TB. Simatupang No. 18, South Jakarta 12520. (02180641888)', 'Jl. TB. Simatupang No. 18, South Jakarta 12520, Indonesia', '08:30 - 17:30 WIB', '08:30 AM - 05:30 PM', 'Libur', 'Closed', '24 Jam', '24 Hour', 'https://www.tiktok.com/@amethystsuites?_r=1&_t=ZS-95Q6ulBJ3qi', 'https://www.instagram.com/amethystsuites?igsh=a21mNm1ua2YzN2hr', 'https://www.linkedin.com/company/amethyst-executive-suites/', 'whatsapp.com', '2026-03-20 00:09:13', '2026-04-13 08:33:58');

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

--
-- Struktur dari tabel `testimonis`
--

CREATE TABLE `testimonis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `desc` text DEFAULT NULL,
  `desc_en` text DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `rating` int(11) NOT NULL DEFAULT 5,
  `img` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `testimonis`
--

INSERT INTO `testimonis` (`id`, `desc`, `desc_en`, `name`, `title`, `rating`, `img`, `status`, `created_at`, `updated_at`) VALUES
(1, 'The Virtual Office service at Amethyst Suites has been incredibly helpful in helping our company have a professional business address without having to rent a physical office.', 'The Virtual Office service at Amethyst Suites has been incredibly helpful in helping our company have a professional business address without having to rent a physical office.', 'Jason Kelly', 'Brand Loyalty Limited', 5, 'Mvcu8EFaNb7f4NcAaBZJID6qqyQEs6GeaQZAUaAC.jpg', 1, NULL, '2026-04-16 19:46:49'),
(2, 'Our strategic office location and mail handling services greatly assist our business operations. We highly recommend our services to companies seeking a professional image.', 'Our strategic office location and mail handling services greatly assist our business operations. We highly recommend our services to companies seeking a professional image.', 'Emanuel Bria', 'Natural Resource Governance Institute', 5, 'testimonial-2.jpg', 1, NULL, '2026-04-14 23:49:34'),
(3, 'Fasilitas meeting room yang tersedia sangat membantu saat bertemu klien.', 'The meeting room facilities are very helpful when meeting clients.', 'Alexander Demas', 'Horman Kg Verkaufsgesselschaft', 5, 'testimonial-3.jpg', 1, NULL, NULL),
(8, 'saya suka sekali dengan amethyst', 'love amethyst so much', 'Bill Gates', 'Yang Punya Microsoft', 5, 'qusa0ZelAMTmD1FOr0PEVVux4UotI7eYocwBHImA.png', 1, '2026-04-14 23:49:16', '2026-04-14 23:49:16');

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

--
-- Struktur dari tabel `titles`
--

CREATE TABLE `titles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_en` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `subtitle_en` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `desc_en` varchar(255) DEFAULT NULL,
  `section` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `titles`
--

INSERT INTO `titles` (`id`, `title`, `title_en`, `subtitle`, `subtitle_en`, `desc`, `desc_en`, `section`, `created_at`, `updated_at`) VALUES
(1, 'Mudah & Praktis', 'Quick & Easy', 'Layanan Office Terintegrasi', 'Integrated Office Services', 'Kami menyediakan Virtual Office (Kantor Virtual) & Serviced Office (Kantor Siap Pakai) yang membantu bisnis anda beradaptasi dengan cepat dan efisien di pasar Jakarta yang dinamis.', 'We provide Virtual Office and Serviced Office solutions that help your business adapt quickly and efficiently in Jakarta’s dynamic market.', 'home', '2026-03-30 08:08:59', '2026-04-13 08:32:49'),
(2, 'Lokasi Virtual Office', 'Our Location', 'Pilihan Alamat Bisnis Prestisius', 'Prestigious Business Address Choice', 'Kami membantu perusahaan Anda memiliki alamat kantor profesional tanpa biaya operasional tinggi. Pilih lokasi yang paling sesuai untuk meningkatkan citra dan kredibilitas bisnis Anda.', 'We help your company have a professional office address without high operational costs. Choose the most suitable location to enhance your business\'s image and credibility.', 'home', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(3, 'Testimoni Klien', 'Client Testimonials', 'Apa Kata Klien Kami', 'What Our Clients Say', 'Dengan alamat bisnis prestisius, layanan administrasi profesional, dan fasilitas meeting yang nyaman, kami membantu bisnis berkembang dengan lebih efisien dan terpercaya.', 'With a prestigious business address, professional administrative services, and comfortable meeting facilities, we help businesses grow more efficiently and reliably.', 'home', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(4, 'Berita & Artikel', 'News & Update', 'Insight Bisnis & Virtual Office', 'Business Insight', 'Temukan berbagai informasi, tips bisnis, serta artikel seputar Virtual Office, legalitas perusahaan, dan strategi membangun bisnis profesional di era modern.', 'Find various information, business tips, and articles about Virtual Offices, company legality, and strategies for building a professional business in the modern era.', 'home', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(5, 'Jelajah', 'Explore', 'Galeri Layanan Kami', 'Our Service Gallery', 'Temukan berbagai informasi, tips bisnis, serta artikel seputar Virtual Office, legalitas perusahaan, dan strategi membangun bisnis profesional di era modern.', 'Find various information, business tips, and articles about Virtual Offices, company legality, and strategies for building a professional business in the modern era.', 'service_detail', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(6, 'Temukan', 'Discover', 'Jasa Sewa Kantor & Konsultasi Terlengkap', 'Office Rental & Other Consulting Services', 'Kami menyediakan layanan lengkap mulai dari sewa kantor, pendirian badan usaha, konsultasi pajak & keuangan perusahaan Anda dan layanan legal lainnya', 'We provide complete services ranging from office rental, business establishment, tax & financial consulting for your company and other legal services.', 'service_detail', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(7, 'Komitmen Kami Sebagai', 'Our Commitment As', 'Layanan Virtual Office Terbaik', 'Best Virtual Office Services', 'Kami berkomitmen untuk menghadirkan solusi Virtual Office yang profesional, fleksibel, dan terpercaya guna mendukung pertumbuhan bisnis Anda di era modern.', 'We are committed to providing professional, flexible, and reliable Virtual Office solutions to support your business growth in the modern era.', 'mission', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(8, 'Lowongan Kerja', 'Job Vacancy', 'Karir di Industri Virtual Office', 'Job Vacancies in the Virtual Office Industry', 'Kami selalu mencari talenta terbaik untuk tumbuh bersama. Jadilah bagian dari tim profesional yang dinamis, inovatif, dan berorientasi pada solusi bisnis modern.', 'We\'re always looking for the best talent to grow with. Be part of a dynamic, innovative, and solution-oriented team of professionals focused on modern business solutions.', 'career', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(9, 'Hubungi Segera', 'Quick Contact', 'Konsultasi dengan tim profesional kami', 'Consult with our professional team', NULL, NULL, 'contact', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(10, 'Mari Terhubung', 'Let’s Connect', 'Kirim Pesan Anda', 'Send Your Message', NULL, NULL, 'contact', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(11, 'Mari Bergabung', 'Let’s Join', 'Form Lamaran Kerja', 'Job Application Form', 'Silakan isi data Anda dengan lengkap untuk dapat mengajukan lamaran pekerjaan.', 'Please fill in your data completely to be able to submit a job application.', 'contact', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(12, 'Jelajahi Layanan Kami', 'Explore Our Services', 'Galeri Layanan', 'Service Gallery', 'Temukan berbagai layanan terbaik yang kami sediakan untuk mendukung kebutuhan bisnis Anda.', 'Discover the various best services we provide to support your business needs.', 'gallery', '2026-03-30 08:08:59', '2026-03-30 08:08:59'),
(13, 'Berita & Insight', 'News & Insight', 'Artikel Terbaru', 'Latest Articles', 'Informasi terkini untuk mendukung perkembangan bisnis Anda.', 'The latest information to support your business development.', 'news', '2026-03-30 08:08:59', '2026-03-30 08:08:59');

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

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `menu_access` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`menu_access`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `menu_access`) VALUES
(99, 'Master Admin', 'master@demo.com', '2026-04-09 14:19:09', '$2y$12$7D8ixs6mTRbVUUJHR812NOAbT5/O7hMv9QvgtNCiJquqK9afZdVD.', NULL, '2026-04-09 14:18:59', '2026-04-13 20:30:20', '[\"banner\", \"service\", \"gallery\", \"news\", \"location\", \"about\", \"counter\", \"testimoni\", \"career\", \"applicant\", \"title\", \"site-settings\"]');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `abouts`
--
ALTER TABLE `abouts`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indeks untuk tabel `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

--
-- Indeks untuk tabel `careers`
--
ALTER TABLE `careers`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `counters`
--
ALTER TABLE `counters`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `galleries_service_id_foreign` (`service_id`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indeks untuk tabel `job_applications`
--
ALTER TABLE `job_applications`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `news_slug_unique` (`slug`),
  ADD UNIQUE KEY `news_slug_en_unique` (`slug_en`),
  ADD KEY `news_category_id_foreign` (`category_id`);

--
-- Indeks untuk tabel `opening_hours`
--
ALTER TABLE `opening_hours`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indeks untuk tabel `promos`
--
ALTER TABLE `promos`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `seos`
--
ALTER TABLE `seos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `seos_page_unique` (`page`);

--
-- Indeks untuk tabel `seo_settings`
--
ALTER TABLE `seo_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD UNIQUE KEY `slug_en` (`slug_en`);

--
-- Indeks untuk tabel `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indeks untuk tabel `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `testimonis`
--
ALTER TABLE `testimonis`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `titles`
--
ALTER TABLE `titles`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `abouts`
--
ALTER TABLE `abouts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT untuk tabel `careers`
--
ALTER TABLE `careers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `counters`
--
ALTER TABLE `counters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `job_applications`
--
ALTER TABLE `job_applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `locations`
--
ALTER TABLE `locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT untuk tabel `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `opening_hours`
--
ALTER TABLE `opening_hours`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `promos`
--
ALTER TABLE `promos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `seos`
--
ALTER TABLE `seos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `seo_settings`
--
ALTER TABLE `seo_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `testimonis`
--
ALTER TABLE `testimonis`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT untuk tabel `titles`
--
ALTER TABLE `titles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `galleries`
--
ALTER TABLE `galleries`
  ADD CONSTRAINT `galleries_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `news`
--
ALTER TABLE `news`
  ADD CONSTRAINT `news_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;
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 */;
