-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.4.3 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             12.8.0.6908
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for pazar_seasoning
CREATE DATABASE IF NOT EXISTS `pazar_seasoning` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ ;
USE `pazar_seasoning`;

-- Dumping structure for table pazar_seasoning.cache
CREATE TABLE IF NOT EXISTS `cache` (
  `key` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `value` text COLLATE utf8mb4_general_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.cache: ~0 rows (approximately)

-- Dumping structure for table pazar_seasoning.career_careerinfo
CREATE TABLE IF NOT EXISTS `career_careerinfo` (
  `ci_id` int NOT NULL AUTO_INCREMENT,
  `ci_title_id` varchar(255) NOT NULL,
  `ci_title_en` varchar(255) NOT NULL,
  `ci_description_id` text NOT NULL,
  `ci_description_en` text NOT NULL,
  `ci_image` text NOT NULL,
  PRIMARY KEY (`ci_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pazar_seasoning.career_careerinfo: ~2 rows (approximately)
INSERT INTO `career_careerinfo` (`ci_id`, `ci_title_id`, `ci_title_en`, `ci_description_id`, `ci_description_en`, `ci_image`) VALUES
	(1, 'Memberikan Dampak Positif', 'Making a Positive Impact', 'Kami percaya pada kekuatan kebaikan untuk meningkatkan kualitas hidup. Keyakinan ini mendorong komitmen kami untuk menggunakan skala global, sumber daya dan keahlian untuk berkontribusi pada masa depan yang lebih sehat bagi masyarakat. Anda akan bergabung dengan perusahaan yang berkomitmen membuat dampak positif melalui cita rasa autentik Indonesia.', 'We believe in the power of goodness to improve the quality of life. This belief drives our commitment to use our global scale, resources, and expertise to contribute to a healthier future for people. You will join a company committed to making a positive impact through the authentic flavors of Indonesia.', 'careers/HR (ft karyawan).webp'),
	(2, 'Budaya Inovasi', 'A Culture of Innovation', 'Di Pazar, inovasi adalah inti dari semua yang kami lakukan. Dari teknik tradisional pencampuran bumbu hingga proses manufaktur modern, kami mendorong tim untuk berpikir kreatif dan melampaui batas. Bergabunglah dengan tempat kerja di mana ide-ide Anda dihargai dan inovasi mendorong kesuksesan kami dalam menghadirkan produk luar biasa untuk keluarga Indonesia.', 'At Pazar, innovation is at the core of everything we do. From traditional spice-blending techniques to modern manufacturing processes, we encourage our team to think creatively and push boundaries. Join a workplace where your ideas are valued, and innovation drives our success in delivering exceptional products to Indonesian families.', 'careers/HR (ft QC).webp');

-- Dumping structure for table pazar_seasoning.career_departments
CREATE TABLE IF NOT EXISTS `career_departments` (
  `da_id` int NOT NULL AUTO_INCREMENT,
  `da_title_id` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `da_title_en` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `da_created_by` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `da_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `da_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `da_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`da_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.career_departments: ~8 rows (approximately)
INSERT INTO `career_departments` (`da_id`, `da_title_id`, `da_title_en`, `da_created_by`, `da_created_at`, `da_updated_by`, `da_updated_at`) VALUES
	(1, 'Keuangan & Akutansi (FA)', 'Finance & Accounting (FA)', 'EMP001', '2025-05-14 04:26:43', 'EMP001', '2025-05-23 04:27:17'),
	(2, 'Sumber Daya Manusia dan Urusan Umum (HRGA)', 'Human Resources and General Affairs (HRGA)', 'EMP001', '2025-05-14 04:26:43', 'EMP001', '2025-05-23 04:31:21'),
	(3, 'Produksi', 'Production', 'EMP001', '2025-05-14 04:26:43', 'EMP001', '2025-05-23 04:31:39'),
	(4, 'Pemasaran', 'Marketing', 'EMP001', '2025-05-14 04:26:43', 'EMP001', '2025-05-23 04:32:15'),
	(5, 'Pemeliharaan', 'Maintenance', 'EMP001', '2025-05-23 04:33:08', NULL, '2025-05-23 04:33:08'),
	(6, 'Penjaminan Kualitas & Pengendalian Mutu (QA QC)', 'Quality Assurance & Quality Control (QA QC)', 'EMP001', '2025-05-23 04:34:51', NULL, '2025-05-23 04:34:51'),
	(7, 'Penelitian dan Pengembangan (RnD)', 'Research & Development (RnD)', 'EMP001', '2025-05-23 04:35:47', NULL, '2025-05-23 04:35:47'),
	(8, 'Pergudangan', 'Warehouse', 'EMP001', '2025-05-23 04:36:01', NULL, '2025-05-23 04:36:01');

-- Dumping structure for table pazar_seasoning.career_experiences
CREATE TABLE IF NOT EXISTS `career_experiences` (
  `ex_id` int NOT NULL AUTO_INCREMENT,
  `ex_title_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ex_title_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ex_created_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ex_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ex_updated_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ex_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ex_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.career_experiences: ~5 rows (approximately)
INSERT INTO `career_experiences` (`ex_id`, `ex_title_id`, `ex_title_en`, `ex_created_by`, `ex_created_at`, `ex_updated_by`, `ex_updated_at`) VALUES
	(1, 'Fresh Graduate', 'Fresh Graduate', 'EMP001', '2025-05-13 21:26:43', NULL, NULL),
	(2, '1 Tahun Pengalaman', '1 Year of Experience', 'EMP001', '2025-05-13 21:26:43', NULL, NULL),
	(3, '2 Tahun Pengalaman', '2 Years of Experience', 'EMP001', '2025-05-13 21:26:43', NULL, NULL),
	(4, '3 Tahun Pengalaman', '3 Years of Experience', 'EMP001', '2025-05-13 21:26:43', NULL, NULL),
	(5, '5 Tahun Pengalaman', '5 Years of Experience', 'EMP001', '2025-05-13 21:26:43', NULL, NULL);

-- Dumping structure for table pazar_seasoning.career_vacancies
CREATE TABLE IF NOT EXISTS `career_vacancies` (
  `v_id` int NOT NULL AUTO_INCREMENT,
  `v_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `v_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `v_department_id` int DEFAULT NULL,
  `v_experience_id` int DEFAULT NULL,
  `v_type` enum('Onsite','Hybrid','Remote') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `v_description_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `v_description_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `v_requirement_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `v_requirement_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `v_responsibilities_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `v_responsibilities_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `v_posted_date` date NOT NULL,
  `v_closed_date` date NOT NULL,
  `v_urgent` tinyint(1) DEFAULT '0',
  `v_is_active` tinyint(1) DEFAULT '1',
  `v_created_by` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `v_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `v_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `v_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`v_id`),
  KEY `v_experience_id` (`v_experience_id`),
  KEY `idx_vacancy_filters` (`v_department_id`,`v_experience_id`,`v_type`,`v_is_active`),
  KEY `idx_vacancy_dates` (`v_posted_date`,`v_closed_date`),
  CONSTRAINT `career_vacancies_ibfk_1` FOREIGN KEY (`v_department_id`) REFERENCES `career_departments` (`da_id`),
  CONSTRAINT `career_vacancies_ibfk_2` FOREIGN KEY (`v_experience_id`) REFERENCES `career_experiences` (`ex_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.career_vacancies: ~6 rows (approximately)
INSERT INTO `career_vacancies` (`v_id`, `v_title_id`, `v_title_en`, `v_department_id`, `v_experience_id`, `v_type`, `v_description_id`, `v_description_en`, `v_requirement_id`, `v_requirement_en`, `v_responsibilities_id`, `v_responsibilities_en`, `v_posted_date`, `v_closed_date`, `v_urgent`, `v_is_active`, `v_created_by`, `v_created_at`, `v_updated_by`, `v_updated_at`) VALUES
	(1, 'Admin Media Sosial', 'Social Media Admin', 4, 1, 'Onsite', 'Kami mencari seorang Admin Media Sosial yang energik dan kreatif untuk bergabung dengan tim marketing kami. Posisi ini cocok untuk fresh graduate yang memiliki passion di dunia digital marketing dan media sosial. Kandidat yang tepat akan bertanggung jawab mengelola seluruh aktivitas media sosial perusahaan, mulai dari pembuatan konten hingga monitoring performa, serta membantu dalam proses operasional online shop.', 'We are looking for an energetic and creative Social Media Admin to join our marketing team. This position is suitable for fresh graduates who have a passion for digital marketing and social media. The right candidate will be responsible for managing all company social media activities, from content creation to performance monitoring, as well as assisting in online shop operational processes.', '• Pendidikan: Minimal SLTA/D3/S1 dari semua jurusan\r\n• Pengalaman: Fresh graduate atau pengalaman 0-1 tahun\r\n• Kemampuan Komunikasi: Mampu berkomunikasi dengan baik secara lisan dan tulisan\r\n• Kreativitas: Memiliki jiwa kreatif dan selalu update dengan tren media sosial terkini\r\n• Technical Skills: Mampu dan menguasai tools design (Canva, Adobe Creative Suite, atau software design lainnya)\r\n• Digital Savvy: Memahami berbagai platform media sosial dan karakteristiknya\r\n• Organisasi: Mampu bekerja dengan deadline dan mengatur prioritas\r\n• Portofolio: Wajib melampirkan portofolio desain atau alamat media sosial pribadi', '• Education: Minimum High School/Diploma/Bachelor\'s degree from any major\r\n• Experience: Fresh graduate or 0-1 year experience\r\n• Communication Skills: Excellent verbal and written communication abilities\r\n• Creativity: Creative mindset and always up-to-date with current social media trends\r\n• Technical Skills: Proficient in design tools (Canva, Adobe Creative Suite, or other design software)\r\n• Digital Savvy: Understanding of various social media platforms and their characteristics\r\n• Organization: Able to work with deadlines and prioritize tasks\r\n• Portfolio: Must include design portfolio or personal social media accounts', '• Pengelolaan Media Sosial: Mengelola dan mengoperasikan akun media sosial perusahaan di berbagai platform (Instagram, Facebook, TikTok, Twitter, dll.)\r\n• Pembuatan Konten: Merancang, membuat, dan memposting konten yang menarik dan sesuai dengan brand identity perusahaan\r\n• Content Planning: Membuat calendar konten dan strategy posting yang konsisten\r\n• Desain Visual: Membuat desain grafis untuk postingan, story, dan materi promosi lainnya\r\n• Engagement Management: Merespons komentar, direct message, dan berinteraksi dengan followers\r\n• Operasional Online Shop: Memproses pesanan dan mengatur pengiriman produk\r\n• Performance Monitoring: Memonitoring dan menganalisis performa online shop dan media sosial menggunakan analytics tools\r\n• Trend Research: Melakukan riset tren terkini di media sosial dan mengimplementasikannya dalam strategi konten\r\n• Reporting: Membuat laporan berkala mengenai performa media sosial dan online shop\r\n• Kolaborasi: Bekerja sama dengan tim marketing lain untuk campaign terintegrasi', '• Social Media Management: Manage and operate company social media accounts across various platforms (Instagram, Facebook, TikTok, Twitter, etc.)\r\n• Content Creation: Design, create, and post engaging content that aligns with company brand identity\r\n• Content Planning: Develop content calendar and consistent posting strategy\r\n• Visual Design: Create graphic designs for posts, stories, and other promotional materials\r\n• Engagement Management: Respond to comments, direct messages, and interact with followers\r\n• Online Shop Operations: Process orders and manage product shipping\r\n• Performance Monitoring: Monitor and analyze online shop and social media performance using analytics tools\r\n• Trend Research: Research current social media trends and implement them in content strategy\r\n• Reporting: Create periodic reports on social media and online shop performance\r\n• Collaboration: Work with other marketing team members for integrated campaigns', '2025-07-14', '2025-09-26', 1, 1, 'EMP001', '2025-05-14 04:28:29', 'IT001', '2025-07-14 02:03:59'),
	(2, 'QC Inline', 'Inline QC', 6, 2, 'Onsite', 'Kami mencari profesional QC Inline yang berdedikasi untuk bergabung dengan tim Quality Assurance dan Quality Control kami. Kandidat ideal akan bertanggung jawab untuk memantau dan mengendalikan kualitas produk selama proses produksi untuk memastikan semua produk memenuhi standar dan spesifikasi kualitas yang telah ditetapkan. Posisi ini membutuhkan pengalaman langsung dalam proses kontrol kualitas industri makanan dan minuman.', 'We are seeking a dedicated QC Inline professional to join our Quality Assurance and Quality Control team. The ideal candidate will be responsible for monitoring and controlling product quality throughout the production process to ensure all products meet established quality standards and specifications. This role requires hands-on experience in food and beverage industry quality control processes.', '• Pendidikan: Minimal S1 Jurusan Teknologi Pangan, Teknik Kimia, atau jurusan terkait\r\n• Pengalaman: Memiliki pengalaman minimal 1 tahun sebagai QC Inline di industri makanan dan minuman (lebih diutamakan)\r\n• Pengetahuan Teknis: Familiar dengan sistem yang terkait dengan standar mutu dan kendali mutu\r\n• Jadwal Kerja: Bersedia bekerja shift\r\n• Sertifikasi/Standar: Memahami GMP (Good Manufacturing Practices), HACCP (Hazard Analysis Critical Control Points), dan BRCGS (British Retail Consortium Global Standard)', '• Education: Minimum Bachelor\'s degree (S1) in Food Technology, Chemical Engineering, or related field\r\n• Experience: Minimum 1 year of experience as QC Inline in food and beverage industry (preferred)\r\n• Technical Knowledge: Familiar with quality standard systems and quality control procedures\r\n• Work Schedule: Willing to work in shifts\r\n• Certifications/Standards: Understanding of GMP (Good Manufacturing Practices), HACCP (Hazard Analysis Critical Control Points), and BRCGS (British Retail Consortium Global Standard)', '• Pemantauan Kualitas: Melakukan pemeriksaan kualitas inline secara rutin selama proses produksi untuk memastikan produk memenuhi spesifikasi kualitas\r\n• Pengumpulan Data: Mencatat dan mendokumentasikan hasil tes kontrol kualitas, menjaga catatan dan laporan kualitas yang akurat\r\n• Kontrol Proses: Memantau titik kontrol kritis (CCPs) dan memastikan kepatuhan terhadap prinsip HACCP\r\n• Kepatuhan Standar: Memastikan adherensi terhadap standar GMP, HACCP, dan BRCGS selama operasi produksi\r\n• Penyelesaian Masalah: Mengidentifikasi penyimpangan kualitas dan berkoordinasi dengan tim produksi untuk mengimplementasikan tindakan korektif\r\n• Pemeliharaan Peralatan: Melakukan kalibrasi rutin dan pemeliharaan instrumen serta peralatan kontrol kualitas\r\n• Dokumentasi: Menyelesaikan dokumentasi kontrol kualitas, termasuk catatan batch, laporan inspeksi, dan laporan ketidaksesuaian\r\n• Perbaikan Berkelanjutan: Berpartisipasi dalam inisiatif peningkatan kualitas dan menyarankan perbaikan proses\r\n• Dukungan Pelatihan: Membantu dalam pelatihan staf produksi mengenai prosedur dan standar kualitas\r\n• Cakupan Shift: Menyediakan cakupan kontrol kualitas di berbagai shift produksi sesuai kebutuhan', '• Quality Monitoring: Conduct regular inline quality checks during production processes to ensure products meet quality specifications\r\n• Data Collection: Record and document quality control test results, maintaining accurate quality records and reports\r\n• Process Control: Monitor critical control points (CCPs) and ensure compliance with HACCP principles\r\n• Standard Compliance: Ensure adherence to GMP, HACCP, and BRCGS standards throughout production operations\r\n• Issue Resolution: Identify quality deviations and coordinate with production team to implement corrective actions\r\n• Equipment Maintenance: Perform routine calibration and maintenance of quality control instruments and equipment\r\n• Documentation: Complete quality control documentation, including batch records, inspection reports, and non-conformance reports\r\n• Continuous Improvement: Participate in quality improvement initiatives and suggest process enhancements\r\n• Training Support: Assist in training production staff on quality procedures and standards\r\n• Shift Coverage: Provide quality control coverage across different production shifts as required', '2025-07-14', '2025-09-26', 0, 1, 'EMP001', '2025-05-14 04:28:29', 'IT001', '2025-07-14 02:17:03'),
	(3, 'Sales Modern Trade & HORECA', 'Sales Modern Trade & HORECA', 4, 3, 'Onsite', 'Kami mencari seorang Sales Professional yang dinamis untuk bergabung dengan tim kami, dengan fokus pada saluran Modern Trade dan HORECA (Hotel, Restaurant, Café). Posisi ini membutuhkan individu berpengalaman yang dapat mendorong pertumbuhan penjualan, membangun hubungan yang kuat dengan akun-akun kunci, dan memperluas kehadiran pasar kami di industri makanan. Kandidat yang berhasil akan bertanggung jawab untuk mengelola dan mengembangkan hubungan bisnis dengan outlet modern trade dan establishment HORECA di wilayah Jabodetabek.', 'We are seeking a dynamic Sales Professional to join our team, focusing on Modern Trade and HORECA (Hotel, Restaurant, Café) channels. This role requires an experienced individual who can drive sales growth, build strong relationships with key accounts, and expand our market presence in the food industry. The successful candidate will be responsible for managing and developing business relationships with modern trade outlets and HORECA establishments across the Jabodetabek region.', '• Pendidikan: Minimal lulusan SLTA/Akademi/S1\r\n• Transportasi: Memiliki SIM dan kendaraan sendiri\r\n• Pengalaman: Minimal 2 tahun pengalaman di sektor Modern Trade dan HORECA dalam industri makanan\r\n• Keterampilan: Berorientasi pada tujuan, kemampuan komunikasi yang baik, dan keterampilan penjualan yang kuat\r\n• Kerjasama Tim: Mampu berkolaborasi secara efektif dengan anggota tim\r\n• Koordinasi: Pengalaman dalam berkoordinasi dengan outlet Modern Trade dan HORECA\r\n• Lokasi: Bersedia ditempatkan di wilayah Jabodetabek', '• Education: Minimum high school diploma (SLTA), Academy, or Bachelor\'s degree (S1)\r\n• Transportation: Valid driver\'s license (SIM) and own vehicle\r\n• Experience: Minimum 2 years of experience in Modern Trade and HORECA sectors within the food industry\r\n• Skills: Goal-oriented, excellent communication skills, and strong sales abilities\r\n• Teamwork: Ability to collaborate effectively with team members\r\n• Coordination: Experience in coordinating with Modern Trade and HORECA outlets\r\n• Location: Willing to be placed in Jabodetabek area', '• Manajemen Akun: Mengembangkan dan mempertahankan hubungan yang kuat dengan klien Modern Trade dan HORECA untuk memastikan kepuasan dan loyalitas pelanggan\r\n• Pencapaian Target Penjualan: Mencapai dan melampaui target penjualan bulanan dan triwulanan melalui strategi penjualan yang efektif dan keterlibatan pelanggan\r\n• Pengembangan Pasar: Mengidentifikasi peluang bisnis baru dan klien potensial dalam segmen Modern Trade dan HORECA\r\n• Promosi Produk: Mempresentasikan dan mempromosikan produk perusahaan kepada klien yang ada dan prospektif, menyoroti manfaat utama dan proposisi nilai\r\n• Aktivitas Koordinasi: Berkolaborasi erat dengan outlet Modern Trade dan HORECA untuk memastikan operasi dan pengiriman layanan yang lancar\r\n• Intelijen Pasar: Mengumpulkan dan menganalisis informasi pasar, aktivitas pesaing, dan umpan balik pelanggan untuk menginformasikan strategi bisnis\r\n• Pelaporan Penjualan: Menyiapkan laporan penjualan, prakiraan, dan analisis kinerja secara berkala untuk tinjauan manajemen\r\n• Layanan Pelanggan: Memberikan layanan dan dukungan pelanggan yang luar biasa untuk menyelesaikan masalah atau kekhawatiran dengan cepat\r\n• Manajemen Wilayah: Mengelola wilayah yang ditugaskan dalam area Jabodetabek secara efektif untuk memaksimalkan cakupan penjualan dan efisiensi\r\n• Membangun Hubungan: Membangun dan mempertahankan jaringan profesional dalam industri makanan untuk memperluas peluang bisnis', '• Account Management: Develop and maintain strong relationships with Modern Trade and HORECA clients to ensure customer satisfaction and loyalty\r\n• Sales Target Achievement: Meet and exceed monthly and quarterly sales targets through effective sales strategies and customer engagement\r\n• Market Development: Identify new business opportunities and potential clients within the Modern Trade and HORECA segments\r\n• Product Promotion: Present and promote company products to existing and prospective clients, highlighting key benefits and value propositions\r\n• Coordination Activities: Collaborate closely with Modern Trade and HORECA outlets to ensure smooth operations and service delivery\r\n• Market Intelligence: Gather and analyze market information, competitor activities, and customer feedback to inform business strategies\r\n• Sales Reporting: Prepare regular sales reports, forecasts, and performance analyses for management review\r\n• Customer Service: Provide exceptional customer service and support to resolve any issues or concerns promptly\r\n• Territory Management: Effectively manage assigned territory within Jabodetabek area to maximize sales coverage and efficiency\r\n• Relationship Building: Build and maintain professional networks within the food industry to expand business opportunities', '2025-07-14', '2025-09-26', 0, 1, 'EMP001', '2025-05-14 04:28:29', 'IT001', '2025-07-14 02:16:29'),
	(4, 'Sales', 'Sales', 4, 2, 'Onsite', 'Jadi sales', 'Become sales', 'Ganteng atau Cantik, kalo jelek kita pukulin', 'Good looking, we beat you up if you ugly', 'Naikin penjualan jadi 3 milliar', 'Increase sales to 3 billion', '2025-07-07', '2025-07-14', 1, 1, 'EMP001', '2025-05-14 09:43:42', 'IT001', '2025-07-14 02:44:17'),
	(5, 'Staf Pergudangan', 'Warehouse Staff', 8, 2, 'Onsite', 'Kami membutuhkan Staf Pergudangan.', 'We need Warehouse Staff.', 'Harus Ganteng/Cantik.', 'Must Good looking.', 'Memindahkan & mengelola barang.', 'Moving and managing goods.', '2025-07-10', '2025-07-14', 1, 1, 'EMP001', '2025-05-23 05:01:10', 'IT001', '2025-07-14 02:49:46');

-- Dumping structure for table pazar_seasoning.career_work_at_pazar
CREATE TABLE IF NOT EXISTS `career_work_at_pazar` (
  `wap_id` int NOT NULL AUTO_INCREMENT,
  `wap_title_id` varchar(255) NOT NULL,
  `wap_title_en` varchar(255) NOT NULL,
  `wap_description_id` text,
  `wap_description_en` text,
  `wap_type` text NOT NULL,
  PRIMARY KEY (`wap_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pazar_seasoning.career_work_at_pazar: ~3 rows (approximately)
INSERT INTO `career_work_at_pazar` (`wap_id`, `wap_title_id`, `wap_title_en`, `wap_description_id`, `wap_description_en`, `wap_type`) VALUES
	(1, 'Bekerja di Pazar?', 'Ready to Join Pazar Team?', 'Pazar adalah perusahaan manufaktur bumbu masakan terkemuka yang telah dipercaya oleh ribuan keluarga di seluruh Indonesia. Sebagai bagian dari keluarga besar kami, Anda akan memegang peranan penting dalam menyajikan cita rasa autentik dan menjaga kualitas terbaik yang memperkaya kuliner nusantara hingga sampai ke tangan konsumen.\r\n\r\nKami mencari individu yang penuh semangat (passionate), inovatif, dan siap berkembang bersama perusahaan. Bergabunglah dengan tim profesional kami untuk merasakan pengalaman bekerja di lingkungan yang mendukung kreativitas, pembelajaran berkelanjutan, dan pencapaian tujuan karier Anda secara optimal.', 'Pazar is a leading manufacturer of cooking spices, trusted by thousands of families across Indonesia. As part of our family, you will play a vital role in delivering authentic flavors and upholding the highest quality that enriches Indonesian culinary traditions, all the way to our consumers. \r\n\r\nWe are looking for passionate, innovative individuals who are ready to grow with the company. Join our professional team to experience a work environment that supports creativity, continuous learning, and helps you achieve your career aspirations.', 'work'),
	(2, 'Mengapa Memilih Berkarir di Pazar?', 'Why Choose Pazar?', NULL, NULL, 'why'),
	(3, 'Siap Bergabung dengan Tim Pazar?', 'Ready to Join Pazar Team?', 'Jelajahi berbagai posisi karir yang tersedia dan temukan peluang yang sesuai dengan passion dan keahlian Anda. Mari bersama-sama menciptakan cita rasa yang menginspirasi.', 'Explore our career opportunities and discover the perfect role for your passion and expertise. Let\'s create flavors that inspire, together.', 'join');

-- Dumping structure for table pazar_seasoning.login_divisions
CREATE TABLE IF NOT EXISTS `login_divisions` (
  `div_id` int NOT NULL AUTO_INCREMENT,
  `div_code` varchar(10) COLLATE utf8mb4_general_ci NOT NULL,
  `div_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `div_is_active` tinyint(1) DEFAULT '1',
  `div_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `div_created_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `div_updated_at` timestamp NULL DEFAULT NULL,
  `div_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`div_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.login_divisions: ~8 rows (approximately)
INSERT INTO `login_divisions` (`div_id`, `div_code`, `div_name`, `div_is_active`, `div_created_at`, `div_created_by`, `div_updated_at`, `div_updated_by`) VALUES
	(1, 'IT', 'Information Technology', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-09 01:34:13', 'EMP001'),
	(2, 'HR', 'Human Resources', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-09 01:34:13', 'EMP001'),
	(3, 'FIN', 'Finance', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-09 01:34:13', 'EMP001'),
	(4, 'MKT', 'Marketing', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-09 01:34:13', 'EMP001'),
	(5, 'OPS', 'Operations', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-09 01:34:13', 'EMP001'),
	(6, 'RND', 'Research and Development', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-09 01:34:13', 'EMP001'),
	(7, 'SALES', 'Sales', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-09 01:34:13', 'EMP001'),
	(8, 'DUIT', 'Ngurusin Duit', 1, '2025-04-09 02:49:45', NULL, '2025-04-09 02:50:13', NULL);

-- Dumping structure for table pazar_seasoning.login_positions
CREATE TABLE IF NOT EXISTS `login_positions` (
  `pos_id` int NOT NULL AUTO_INCREMENT,
  `pos_code` varchar(10) COLLATE utf8mb4_general_ci NOT NULL,
  `pos_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `pos_is_active` tinyint(1) DEFAULT '1',
  `pos_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pos_created_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pos_updated_at` timestamp NULL DEFAULT NULL,
  `pos_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`pos_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.login_positions: ~6 rows (approximately)
INSERT INTO `login_positions` (`pos_id`, `pos_code`, `pos_name`, `pos_is_active`, `pos_created_at`, `pos_created_by`, `pos_updated_at`, `pos_updated_by`) VALUES
	(1, 'DIR', 'Director', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:26:32', 'EMP001'),
	(2, 'VP', 'Vice President', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:26:52', 'EMP001'),
	(3, 'GMGR', 'General Manager', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:27:16', 'EMP001'),
	(4, 'MGR', 'Manager', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:27:34', 'EMP001'),
	(5, 'STAFF', 'Staff', 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:27:46', 'EMP001'),
	(6, 'INTERN', 'Intern', 1, '2025-04-13 20:27:55', 'EMP001', '2025-04-13 20:27:55', 'EMP001');

-- Dumping structure for table pazar_seasoning.login_roles
CREATE TABLE IF NOT EXISTS `login_roles` (
  `role_id` int NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `role_level` int NOT NULL,
  `role_is_active` tinyint(1) DEFAULT '1',
  `role_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `role_created_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `role_updated_at` timestamp NULL DEFAULT NULL,
  `role_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.login_roles: ~5 rows (approximately)
INSERT INTO `login_roles` (`role_id`, `role_name`, `role_level`, `role_is_active`, `role_created_at`, `role_created_by`, `role_updated_at`, `role_updated_by`) VALUES
	(1, 'superadmin', 0, 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:33:19', '1'),
	(2, 'admin', 10, 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:33:54', '1'),
	(3, 'manager', 110, 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:34:12', '1'),
	(4, 'user', 11100, 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:35:16', '1'),
	(5, 'guest', 100000, 1, '2025-04-09 01:34:13', 'EMP001', '2025-04-13 20:35:56', '1');

-- Dumping structure for table pazar_seasoning.login_users
CREATE TABLE IF NOT EXISTS `login_users` (
  `u_id` int NOT NULL AUTO_INCREMENT,
  `u_uid` char(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `u_employee_id` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `u_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `u_email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `u_password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `u_phone` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `u_address` text COLLATE utf8mb4_general_ci,
  `u_birthdate` date DEFAULT NULL,
  `u_join_date` date NOT NULL,
  `u_profile_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `u_role` varchar(80) COLLATE utf8mb4_general_ci DEFAULT 'admin',
  `u_division_id` int DEFAULT NULL,
  `u_position_id` int DEFAULT NULL,
  `u_is_manager` tinyint(1) DEFAULT '0',
  `u_manager_id` int DEFAULT NULL,
  `u_is_active` tinyint(1) DEFAULT '1',
  `u_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `u_created_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `u_updated_at` timestamp NULL DEFAULT NULL,
  `u_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.login_users: ~11 rows (approximately)
INSERT INTO `login_users` (`u_id`, `u_uid`, `u_employee_id`, `u_name`, `u_email`, `u_password`, `u_phone`, `u_address`, `u_birthdate`, `u_join_date`, `u_profile_image`, `u_role`, `u_division_id`, `u_position_id`, `u_is_manager`, `u_manager_id`, `u_is_active`, `u_created_at`, `u_created_by`, `u_updated_at`, `u_updated_by`) VALUES
	(1, 'c0175509-0e0e-4c15-819c-6488053a7860', 'IT001', 'Admin Sistem', 'admin@pazarseasonings.com', '$2y$12$ZHtM.Y68xaRaulGSMBbQz.ycly.PjsSD3De7lbwocD3XZGyqcnb3C', NULL, NULL, NULL, '2025-03-10', 'profile_images/1744690348_IT.jpg', 'super_admin', 1, 4, 1, NULL, 1, '2025-04-09 01:34:13', 'EMP001', '2025-07-10 09:19:51', '1'),
	(2, 'bb5f7450-ca93-4328-b517-2d0bac22abe5', 'HR001', 'Admin HRGA', 'adm.hrga@pazarseasonings.com', '$2y$12$XTQKjgjUePNQrVIEgHG4q.RZCafCeAOelT25EbhRSR1aO8/C7mrdS', NULL, NULL, NULL, '2016-03-15', NULL, 'admin', 2, 4, 1, 1, 1, '2025-04-09 01:34:13', 'EMP001', '2025-07-10 09:24:17', '1'),
	(3, '707b8eff-0654-4c38-a435-b108632c9e75', 'HR002', 'HRGA', 'hrga@pazarseasonings.com', '$2y$12$EMJ15nF5SOb3CEfZ3Kg2C.1AcgJhqkha/iMLG7CljiWkuU3Cn4S3y', NULL, NULL, NULL, '2018-02-10', NULL, 'admin', 2, 5, 0, 2, 1, '2025-04-09 01:34:13', 'EMP002', '2025-07-10 09:25:18', '1'),
	(4, '361327a3-e1b5-48fc-95a8-785fe4cc3bf5', 'SL001', 'Admin Sales', 'adm.sales@pazarseasonings.com', '$2y$12$E.Wm05iJvAu6tIhsU0z7tesoGS98S6QcjDO0wORmu8NTzL/xXu86m', NULL, NULL, NULL, '2024-04-16', NULL, 'admin', 7, 4, 1, NULL, 1, '2025-04-09 02:18:05', 'EMP001', '2025-07-10 09:27:20', '1'),
	(5, '3f9d9080-2d27-425c-98fd-b6bbd8d059f3', 'SL002', 'Sales', 'sales@pazarseasonings.com', '$2y$12$a1ZJsiKdzY4sVmt9fQZ/ze5xGC3m/VhrpK/gKBSJJ4TDWxaVR.AuK', NULL, NULL, NULL, '2025-04-09', 'profile_images/1744361866_cihuy.jpg', 'admin', 7, 5, 0, NULL, 1, '2025-04-09 02:24:55', 'EMP001', '2025-07-10 09:28:12', '1'),
	(6, '509c13d2-dcff-48b3-bf98-c2fed5a8d4f7', 'FI001', 'Admin Finance', 'adm.finance@pazarseasonings.com', '$2y$12$0.6dDFCaDHtTpE.MyL0dquA/VnmypyIo5kXq6GtkSKZ/SNi0RZUIe', NULL, NULL, NULL, '2025-04-10', NULL, 'admin', 3, 4, 1, NULL, 1, '2025-04-10 02:26:58', 'EMP004', '2025-07-10 09:29:53', '1'),
	(7, '8bb6fee1-0065-4348-a98d-a1e23b377567', 'FI002', 'Finance', 'finance@pazarseasonings.com', '$2y$12$TkKYb8u5ykQMml0rlNlvQ.qk71bqynmR3mToxdo9ffgB5bvtL7NG2', NULL, NULL, NULL, '2025-04-10', NULL, 'admin', 3, 5, 0, NULL, 1, '2025-04-10 02:48:42', 'EMP004', '2025-07-10 09:30:53', '1'),
	(8, 'ed2834ca-8f01-4d03-960f-ab859cde698a', 'RD001', 'Admin RnD', 'adm.rnd@pazarseasonings.com', '$2y$12$ZTlWreZmU18J0iqJhbIV..FAqsfuOS16HbLoRLU3ML0TNns0x7dfa', NULL, NULL, NULL, '2025-04-10', NULL, 'admin', 6, 4, 1, NULL, 1, '2025-04-10 02:57:52', 'EMP004', '2025-07-10 09:31:58', '1'),
	(9, 'd8a79426-618b-4350-9718-d302365e111a', 'RD002', 'RnD', 'rnd@pazarseasonings.com', '$2y$12$T29QvAE6RtcDzi0LzYx7xOwTcu67WqUOFgB0nAz8GHksDaOE/vP3.', NULL, NULL, NULL, '2025-04-10', '', 'admin', 6, 5, 0, NULL, 1, '2025-04-10 03:09:28', 'EMP004', '2025-07-10 09:32:49', '1'),
	(10, '409c02f0-cccf-450e-a4ce-2760e46720ae', 'TES123', 'Testing', 'testing@company.com', '$2y$12$fFlBRux3C8IgzbkcPAVVlO26yRpaHyVHh5rBokmn2TJO2GAgSMQFa', '9876789231', NULL, NULL, '2025-04-29', NULL, 'admin', 6, 5, 0, NULL, 1, '2025-04-29 03:10:52', 'EMP001', '2025-05-14 03:38:48', '1'),
	(11, '5279fdef-473b-11f0-b936-508140b5abf5', 'TES456', 'Testingan', 'testingan@company.com', '$2y$12$DsQ2mACcvJO8udqmGvnRYeEW3g0y7eN60bF92iGlv74r0bEOvMa2e', NULL, NULL, NULL, '2025-06-12', NULL, 'admin', 1, 5, 0, NULL, 1, '2025-06-12 03:14:16', '1', '2025-07-10 09:42:47', '1');

-- Dumping structure for table pazar_seasoning.login_user_roles
CREATE TABLE IF NOT EXISTS `login_user_roles` (
  `ur_id` int NOT NULL AUTO_INCREMENT,
  `ur_user_id` int DEFAULT NULL,
  `ur_role_id` int DEFAULT NULL,
  `ur_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ur_created_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`ur_id`),
  KEY `ur_user_id` (`ur_user_id`),
  KEY `ur_role_id` (`ur_role_id`),
  CONSTRAINT `login_user_roles_ibfk_1` FOREIGN KEY (`ur_user_id`) REFERENCES `login_users` (`u_id`),
  CONSTRAINT `login_user_roles_ibfk_2` FOREIGN KEY (`ur_role_id`) REFERENCES `login_roles` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.login_user_roles: ~15 rows (approximately)
INSERT INTO `login_user_roles` (`ur_id`, `ur_user_id`, `ur_role_id`, `ur_created_at`, `ur_created_by`) VALUES
	(1, 1, 1, '2025-04-09 01:34:13', 'EMP001'),
	(3, 3, 4, '2025-04-09 01:34:13', 'EMP001'),
	(9, 9, 4, '2025-04-10 09:57:52', 'EMP001'),
	(10, 10, 4, '2025-04-10 10:09:28', 'EMP001'),
	(12, 1, 2, '2025-04-14 03:57:46', 'EMP001'),
	(18, 6, 2, '2025-04-15 04:28:00', 'EMP001'),
	(19, 11, 4, '2025-06-12 03:14:16', '1'),
	(20, 2, 2, '2025-07-10 09:23:44', NULL),
	(21, 2, 3, '2025-07-10 09:23:44', NULL),
	(22, 4, 2, '2025-07-10 09:27:20', NULL),
	(23, 4, 3, '2025-07-10 09:27:20', NULL),
	(24, 5, 4, '2025-07-10 09:28:12', NULL),
	(25, 6, 3, '2025-07-10 09:29:53', NULL),
	(26, 7, 4, '2025-07-10 09:30:53', NULL),
	(27, 8, 2, '2025-07-10 09:31:58', NULL),
	(28, 8, 3, '2025-07-10 09:31:58', NULL);

-- Dumping structure for table pazar_seasoning.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pazar_seasoning.migrations: ~0 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '0001_01_01_000000_create_users_table', 1);

-- Dumping structure for table pazar_seasoning.password_reset_tokens
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pazar_seasoning.password_reset_tokens: ~0 rows (approximately)

-- Dumping structure for table pazar_seasoning.pazar_certifications
CREATE TABLE IF NOT EXISTS `pazar_certifications` (
  `c_id` int NOT NULL AUTO_INCREMENT,
  `c_label_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `c_label_en` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `c_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `c_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `c_description_id` text COLLATE utf8mb4_general_ci,
  `c_description_en` text COLLATE utf8mb4_general_ci,
  `c_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_certifications: ~3 rows (approximately)
INSERT INTO `pazar_certifications` (`c_id`, `c_label_id`, `c_label_en`, `c_title_id`, `c_title_en`, `c_description_id`, `c_description_en`, `c_image`) VALUES
	(1, 'Halal', 'Halal', 'Sertifikat HALAL MUI', 'MUI HALAL Certificate', 'Menandakan bahwa produk telah memenuhi standar halal menurut syariat Islam. Diproses tanpa bahan terkontaminasi najis dan terjamin kehalalannya.', 'Indicates that the product has met halal standards according to Islamic law. Processed without contaminated materials and guaranteed halal.', 'certifications/Halal.webp'),
	(2, 'Higiene', 'Hygiene', 'Sertifikat NKV', 'NKV Certificate', 'Nomor Kontrol Veteriner dari Kementerian Pertanian. Menjamin higienitas produk hewani dari hulu ke hilir sesuai standar kesehatan.', 'Veterinary Control Number from the Ministry of Agriculture. Ensures the hygiene of animal products from upstream to downstream according to health standards.', 'certifications/NKV.webp'),
	(3, 'Keamanan Pangan', 'Standar Internasional', 'Sertifikat BRCGS', 'BRCGS Certificate', 'Standar global untuk keamanan pangan yang diakui dunia. Menjamin produk diproses secara higienis dan aman dikonsumsi.', 'Global standards for food security that are recognized by the world. Guarantee the product is processed hygienically and safely to consume.', 'certifications/BRCGS Certificate - Grade A - PPL 2025.webp');

-- Dumping structure for table pazar_seasoning.pazar_company_profile
CREATE TABLE IF NOT EXISTS `pazar_company_profile` (
  `cp_id` int NOT NULL AUTO_INCREMENT,
  `cp_description_id` text COLLATE utf8mb4_general_ci NOT NULL,
  `cp_description_en` text COLLATE utf8mb4_general_ci NOT NULL,
  `cp_type` text COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`cp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_company_profile: ~4 rows (approximately)
INSERT INTO `pazar_company_profile` (`cp_id`, `cp_description_id`, `cp_description_en`, `cp_type`) VALUES
	(1, 'PT Pristine Prima Lestari adalah produsen bumbu, kondimen, tepung berbumbu, rempah, dan sambal berkualitas tinggi yang berfokus pada kepraktisan tanpa mengurangi cita rasa autentik. Dengan dukungan standar halal, sistem keamanan pangan global, dan inovasi berkelanjutan, kami terus berinovasi untuk menghadirkan solusi yang aman, praktis, dan bercita rasa tinggi. Kami hadir sebagai jawaban atas kebutuhan dapur modern, membuat pengalaman memasak jadi menyenangkan.', 'PT Pristine Prima Lestari is a manufacturer of premium seasonings, condiments, seasoned flour, spices, and chili sauces that emphasizes practicality while preserving authentic flavor. Backed by halal standards, global food safety systems, and a commitment to continuous innovation, we strive to deliver safe, practical, and flavorful solutions. We aim to meet the demands of the modern kitchen, enhancing the cooking experience.', 'what'),
	(2, 'PT. Pristine Prima Lestari adalah perusahaan yang bergerak di bidang usaha produksi bumbu kondimen, tepung bumbu dan rempah.\r\nPT. Pristine Prima Lestari bertekad menjadi perusahaan penyedia produk pangan global yang konsisten menyediakan produk-produk pangan yang berkualitas, halal, asli, memenuhi standar keamanan pangan, dan mematuhi semua peraturan perundang-undangan yang berlaku. Dalam usahanya mencapai tujuan tersebut segenap karyawan dan manajemen PT. Pristine Prima Lestari menyatakan tekadnya untuk menerapkan sistem manajemen keamanan pangan dan terus melakukan perbaikan yang berkelanjutan terkait budaya mutu dan keamanan pangan.', 'PT. Pristine Prima Lestari is a company specializing in the production of condiment seasonings, seasoning flour, and spices.\r\nPT. Pristine Prima Lestari is committed to establishing itself as a global provider of food products, consistently delivering quality, halal, and authentic offerings that adhere to food safety standards and comply with all relevant laws and regulations. In pursuit of this objective, all employees and management at PT. Pristine Prima Lestari have expressed their resolve to implement a food safety management system and to pursue ongoing enhancements related to the culture of quality and food safety.', 'policy'),
	(3, 'Menjadi perusahaan produsen makanan dan minuman halal di Indonesia dengan standar keamanan global yang memenuhi kebutuhan dan harapan pelanggan.', 'To establish a halal food and beverage manufacturing enterprise in Indonesia that adheres to global safety standards while fulfilling customer needs and expectations.', 'vision'),
	(4, '• Proses produksi yang mengacu pada sistem keamanan pangan berstandar global.\r\n• Produk aman, berkualitas, dan halal yang dihasilkan untuk memenuhi kebutuhan dan harapan pelanggan.\r\n• Lakukan terus menerus budaya disiplin, jujur, dan bertanggung jawab.', '• The production process pertains to a comprehensive standard for food safety on a global scale.\r\n• Safe, high-quality, and halal products are produced to fulfill customer needs and expectations.\r\n• Consistently foster a culture of discipline, integrity, and accountability.', 'mission');

-- Dumping structure for table pazar_seasoning.pazar_footer
CREATE TABLE IF NOT EXISTS `pazar_footer` (
  `f_id` int NOT NULL AUTO_INCREMENT,
  `f_type` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `f_label_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_label_en` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_description_id` text COLLATE utf8mb4_general_ci,
  `f_description_en` text COLLATE utf8mb4_general_ci,
  `f_icon` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_link` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`f_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_footer: ~9 rows (approximately)
INSERT INTO `pazar_footer` (`f_id`, `f_type`, `f_label_id`, `f_label_en`, `f_description_id`, `f_description_en`, `f_icon`, `f_link`) VALUES
	(1, 'alamat', 'PT Pristine Prima Lestari', 'PT Pristine Prima Lestari', 'Jl. Vihara No.2, Curug Kulon, Kec. Curug, Kabupaten Tangerang, Banten 15820', 'Vihara Street No.2, Curug Kulon, Curug Subdistrict, Tangerang Regency, Banten 15820', NULL, 'https://g.co/kgs/K4ckX4k'),
	(2, 'kontak', 'Email', 'Email', 'admin@pazarseasonings.com', 'admin@pazarseasonings.com', 'footers/Email.svg', 'mailto:admin@pazarseasonings.com'),
	(3, 'kontak', 'Telepon', 'Phone', '+62 21 5989 4255', '+62 21 5989 4255', 'footers/1746612014_Phone.svg', 'tel:+622159894255'),
	(4, 'social', 'Instagram', 'Instagram', NULL, NULL, 'footers/Instagram.svg', 'https://www.instagram.com/pazarseasonings'),
	(5, 'social', 'Facebook', 'Facebook', NULL, NULL, 'footers/Facebook.svg', 'https://www.facebook.com/pazarseasonings'),
	(6, 'kontak', 'Whatsapp', 'Whatsapp', '+62 81 7491 8835', '+62 81 7491 8835', 'footers/1746612037_Whatsapp.svg', 'https://wa.me/628174918835'),
	(7, 'social', 'X', 'X', NULL, NULL, 'footers/1746612062_X.svg', 'https://x.com/PazarSeasoning'),
	(8, 'social', 'Tiktok', 'Tiktok', NULL, NULL, 'footers/1746612078_Tiktok.svg', 'https://www.tiktok.com/@pazar.seasonings');

-- Dumping structure for table pazar_seasoning.pazar_headers
CREATE TABLE IF NOT EXISTS `pazar_headers` (
  `h_id` int NOT NULL AUTO_INCREMENT,
  `h_page_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `h_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `h_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `h_description_id` text COLLATE utf8mb4_general_ci,
  `h_description_en` text COLLATE utf8mb4_general_ci,
  `h_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`h_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_headers: ~7 rows (approximately)
INSERT INTO `pazar_headers` (`h_id`, `h_page_name`, `h_title_id`, `h_title_en`, `h_description_id`, `h_description_en`, `h_image`) VALUES
	(1, 'index', 'Kelezatan setiap hidangan berawal dari bahan dasar berkualitas. PAZAR berkomitmen menghadirkan produk bumbu, rempah dan sambal terbaik untuk memperkaya cita rasa kuliner nusantara maupun dunia.', 'The exquisite flavor of each dish begins with high-quality fundamental ingredients. PAZAR is dedicated to offering the finest spices, herbs, and chili sauce products to enhance the taste of both Indonesian and global cuisine.', '#JadiBisaMasak | Praktis Bersama PAZAR', '#SoYouCanCook | Practical with PAZAR', 'headers/Desain tanpa judul (37).webp'),
	(2, 'company', 'Perusahaan Kami', 'Our Company', NULL, NULL, 'headers/Header (Perusahaan Kami).webp'),
	(3, 'brand', 'Brand Kami', 'Our Brand', NULL, NULL, 'headers/Header (Brand Kami).webp'),
	(4, 'products', 'Produk Pazar Seasoning', 'Pazar Seasoning Products', NULL, NULL, 'headers/Header (Produk).webp'),
	(5, 'recipes', 'Resep Pazar Seasoning', 'Pazar Seasoning Recipes', NULL, NULL, 'headers/Header (Resep).webp'),
	(6, 'careerinfo', 'Info Karir', 'Career Info', NULL, NULL, 'headers/Header (Info Karir).webp'),
	(7, 'vacancies', 'Lowongan', 'Vacancies', NULL, NULL, 'headers/Header (Lowongan).webp');

-- Dumping structure for table pazar_seasoning.pazar_history
CREATE TABLE IF NOT EXISTS `pazar_history` (
  `hs_id` int NOT NULL AUTO_INCREMENT,
  `hs_year` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `hs_description_id` text COLLATE utf8mb4_general_ci NOT NULL,
  `hs_description_en` text COLLATE utf8mb4_general_ci NOT NULL,
  `hs_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`hs_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_history: ~3 rows (approximately)
INSERT INTO `pazar_history` (`hs_id`, `hs_year`, `hs_description_id`, `hs_description_en`, `hs_image`) VALUES
	(1, '2016', 'Perjalanan PT Pristine Prima Lestari dimulai dengan komitmen kuat terhadap kualitas yang langsung dibuktikan melalui perolehan sertifikasi halal dan izin edar PIRT, yang kemudian ditingkatkan menjadi MD atau BPOM.', 'PT Pristine Prima Lestari\'s journey began with a strong commitment to quality which was immediately proven through the acquisition of halal certification and PIRT distribution permit, which was later upgraded to MD or BPOM.', 'histories/1748230492_2016.webp'),
	(2, '2019', 'PT Pristine Prima Lestari menjadi tonggak penting dengan penguasaan kepemilikan penuh oleh manajemen internal.', 'PT Pristine Prima Lestari has become an important milestone with full ownership control by internal management.', 'histories/1748230508_2019.webp'),
	(3, '2022', 'Sebagai bentuk komitmen terhadap standar keamanan pangan bertaraf internasional, PT Pristine Prima Lestari meraih sertifikasi BRCGS.', 'As a form of commitment to international food safety standards, PT Pristine Prima Lestari has achieved BRCGS certification.', 'histories/1748230570_2022.webp'),
	(4, '2024', 'PT. Pristine Prima Lestari terus melangkah maju sebagai produsen pangan nasional yang terpercaya, inovatif, dan siap bersaing di pasar global.', 'PT. Pristine Prima Lestari continues to move forward as a trusted, innovative national food producer, ready to compete in the global market.', 'histories/1748230570_2022.webp');

-- Dumping structure for table pazar_seasoning.pazar_popup
CREATE TABLE IF NOT EXISTS `pazar_popup` (
  `pu_id` int NOT NULL AUTO_INCREMENT,
  `pu_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pu_link` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pu_is_active` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`pu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_popup: ~3 rows (approximately)
INSERT INTO `pazar_popup` (`pu_id`, `pu_image`, `pu_link`, `pu_is_active`) VALUES
	(1, 'popups/inidia (1).webp', 'https://shopee.co.id/pazar_seasonings', 1),
	(2, 'popups/cihuy.jpg', 'https://www.google.com/', 0),
	(3, 'popups/cihuy.jpg', 'https://claude.ai', 0);

-- Dumping structure for table pazar_seasoning.pazar_product
CREATE TABLE IF NOT EXISTS `pazar_product` (
  `p_id` int NOT NULL AUTO_INCREMENT,
  `p_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `p_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `p_id_product_category` int NOT NULL,
  `p_description_id` text COLLATE utf8mb4_general_ci,
  `p_description_en` text COLLATE utf8mb4_general_ci,
  `p_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `p_created_by` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `p_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `p_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `p_updated_at` timestamp NULL DEFAULT NULL,
  `p_is_active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`p_id`),
  KEY `p_id_product_category` (`p_id_product_category`),
  CONSTRAINT `pazar_product_ibfk_1` FOREIGN KEY (`p_id_product_category`) REFERENCES `pazar_product_category` (`pc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_product: ~26 rows (approximately)
INSERT INTO `pazar_product` (`p_id`, `p_title_id`, `p_title_en`, `p_id_product_category`, `p_description_id`, `p_description_en`, `p_image`, `p_created_by`, `p_created_at`, `p_updated_by`, `p_updated_at`, `p_is_active`) VALUES
	(1, 'Bumbu Ayam Goreng Pack', 'Fried Chicken Seasoning Pack', 1, 'Bumbu tradisional untuk menghasilkan ayam goreng gurih dan berbumbu hingga ke dalam daging. Menggunakan rempah-rempah seperti ketumbar, bawang putih, dan kunyit.', 'Traditional seasoning to create flavorful and well-seasoned fried chicken that permeates the meat, utilizing spices such as coriander, garlic, and turmeric.', 'products/Ayam Goreng pack.webp', 'EMP001', '2025-04-08 02:13:44', 'EMP001', '2025-05-23 04:09:15', 1),
	(2, 'Bumbu Ayam Kalasan', 'Kalasan Chicken Seasoning', 1, 'Bumbu khas Yogyakarta ini menghasilkan ayam goreng dengan cita rasa manis gurih yang meresap sempurna. Biasanya disajikan dengan kremesan dan sambal terasi.', 'This characteristic Yogyakarta seasoning imparts a sweet and savory flavor to fried chicken, which is thoroughly absorbed. It is typically accompanied by kremesan and chili paste.', 'products/Ayam Kalasan pack.webp', 'EMP001', '2025-04-08 02:13:44', 'EMP001', '2025-05-23 02:50:46', 1),
	(3, 'Sambal Terasi', 'Shrimp Paste Chili Sauce', 2, 'Sambal khas Indonesia yang dibuat dari campuran cabai segar dan terasi udang pilihan. Rasanya pedas gurih dengan aroma khas, cocok sebagai pelengkap hidangan nasi, lalapan, hingga seafood.', 'Indonesian specialty sambal crafted from a blend of fresh chilies and premium shrimp paste. It offers a spicy and savory flavor profile accompanied by a distinctive aroma, making it an ideal accompaniment to rice dishes, fresh vegetables, and seafood.', 'products/Terasi 180g.webp', 'EMP001', '2025-04-08 02:13:44', 'EMP001', '2025-05-23 02:53:32', 1),
	(4, 'Kunyit Bubuk', 'Turmenic Powder', 3, 'Rempah berwarna kuning keemasan ini berasal dari akar tanaman kunyit. Digunakan untuk memberi warna alami dan rasa khas pada masakan seperti kari, soto, dan berbagai hidangan tradisional.', 'This vibrant yellow spice is derived from the roots of the turmeric plant. It imparts natural color and a unique flavor to dishes such as curry, soto, and a variety of traditional cuisines.', 'products/Kunyit.webp', 'EMP001', '2025-04-08 02:13:44', 'EMP001', '2025-05-23 02:56:21', 1),
	(5, 'Bumbu Instan Horeka', 'Horeca Instant Seasoning', 4, 'Tepung bumbu praktis...', 'Practical seasoned flour...', 'products/bumbu-instan-edisi-spesial.jpg', 'EMP001', '2025-04-08 02:13:44', NULL, '2025-04-29 19:03:13', 1),
	(6, 'Bawang Putih Bubuk', 'Garlic Powder', 3, 'Bawang putih yang dikeringkan dan dihaluskan, memberikan rasa gurih dan aroma kuat khas bawang putih. Praktis untuk digunakan dalam marinasi, sup, hingga aneka tumisan.', 'Dried and ground garlic imparts a savory flavor and robust aroma characteristic of garlic. It is convenient for incorporation into marinades, soups, and a variety of stir-fries.', 'products/Bawang Putih .webp', 'EMP001', '2025-05-02 08:11:49', 'EMP001', '2025-05-23 02:59:48', 1),
	(7, 'Sambal Bajak', 'Combination Chili Relish', 2, 'Sambal tradisional asal Jawa Tengah, berbahan dasar cabai rawit merah, tomat, lengkuas, dan gula merah, yang ditumis hingga matang. Rasanya pedas manis dengan tekstur yang lebih lembut, sempurna untuk lauk seperti ayam goreng atau ikan bakar.', 'Traditional sambal from Central Java is crafted from red chili peppers, tomatoes, galangal, and brown sugar, which are sautéed until fully cooked. It boasts a sweet and spicy flavor profile with a smooth texture, making it an ideal accompaniment for side dishes like fried chicken or grilled fish.', 'products/Bajak 180g.webp', 'EMP001', '2025-05-02 08:23:06', 'EMP001', '2025-05-23 02:57:53', 1),
	(8, 'Sambal Bakso', 'Meatball Chili Sauce', 2, 'Sambal spesial yang diformulasikan untuk menemani sajian bakso dan makanan berkuah lainnya. Perpaduan cabai rawit, bawang putih, dan sedikit asam memberikan sensasi pedas yang langsung membangkitkan selera.', 'A specially crafted chili sauce designed to complement meatballs and various soupy dishes. The blend of cayenne pepper, garlic, and a hint of acidity delivers a piquant experience that instantly stimulates the appetite.', 'products/Bakso 180g.webp', 'EMP001', '2025-06-12 07:11:32', NULL, '2025-06-12 07:11:32', 1),
	(9, 'Sambal Hijau', 'Green Chili Sauce', 2, 'Sambal ini menggunakan cabai hijau segar, bawang, dan tomat hijau. Rasa pedas segarnya berpadu dengan sedikit asam yang menggugah selera, cocok untuk hidangan olahan daging.', 'This sambal incorporates fresh green chilies, onions, and green tomatoes. The vibrant spicy flavor is complemented by a hint of enticing sourness, making it ideal for meat dishes.', 'products/Hijau 75g.webp', 'EMP001', '2025-06-12 07:28:43', NULL, '2025-06-12 07:28:43', 1),
	(10, 'Bumbu Kuah Bakso', 'Beef Meatball Seasoning', 1, 'Bumbu khusus untuk menciptakan kuah bakso yang bening, gurih, dan kaya rasa. Berbahan dasar kaldu sapi dan rempah pilihan, cocok untuk segala jenis bakso.', 'A distinctive seasoning designed to produce a clear, savory, and robust meatball broth. Crafted from beef broth and carefully chosen spices, it is appropriate for all varieties of meatballs.', 'products/Kuah Bakso pack.webp', 'EMP001', '2025-06-12 07:46:54', NULL, '2025-06-12 07:46:54', 1),
	(11, 'Bumbu Empal', 'Indonesian Sweet Fried Beef Jerky Seasoning', 1, 'Bumbu untuk membuat empal daging khas Jawa, yaitu daging sapi yang direbus dengan bumbu, digoreng, dan menghasilkan rasa manis gurih serta tekstur empuk.', 'The spices utilized in the preparation of Javanese beef empal include beef that is simmered with seasonings, fried, resulting in a sweet and savory flavor profile accompanied by a tender texture.', 'products/Empal pack.webp', 'EMP001', '2025-06-12 08:02:28', NULL, '2025-06-12 08:02:28', 1),
	(12, 'Bumbu Opor', 'Braised Chicken In Coconut Seasoning', 1, 'Bumbu lengkap untuk membuat opor ayam, hidangan khas Lebaran. Kaya akan santan, kunyit, ketumbar, dan rempah-rempah aromatik lainnya yang memberikan rasa gurih lembut.', 'A comprehensive seasoning blend for preparing chicken opor, a traditional Lebaran dish. Infused with coconut milk, turmeric, coriander, and an array of aromatic spices that impart a delicate savory flavor.', 'products/Opor pack.webp', 'EMP001', '2025-06-12 09:35:51', NULL, '2025-06-12 09:35:51', 1),
	(13, 'Bumbu Rica', 'Rica Seasoning', 1, 'Bumbu pedas asal Manado yang berbahan dasar cabai, bawang, dan rempah segar lainnya. Cocok untuk hidangan ayam, ikan, atau seafood rica-rica dengan cita rasa pedas menyegarkan.', 'Spicy seasoning from Manado, crafted from chili, onion, and an array of fresh spices. Ideal for chicken, fish, or seafood rica-rica dishes, it offers a refreshing and piquant flavor.', 'products/Rica pack.webp', 'EMP001', '2025-06-12 09:54:15', NULL, '2025-06-12 09:54:15', 1),
	(14, 'Bumbu Woku', 'Woku Seasoning', 1, 'Bumbu khas Manado dengan cita rasa pedas segar dari campuran daun kemangi, cabai, dan rempah lokal lainnya. Sering digunakan untuk memasak ayam atau ikan woku yang menggugah selera.', 'Manadonese spice offers a vibrant and piquant flavor derived from a blend of basil leaves, chilies, and various local spices. It is frequently employed in the preparation of delectable woku chicken or fish.', 'products/Woku pack.webp', 'EMP001', '2025-06-12 09:57:13', NULL, '2025-06-12 09:57:13', 1),
	(15, 'Bumbu Rendang', 'Padangnese Beef Rendang Seasoning', 1, 'Bumbu khas Minangkabau untuk membuat rendang, salah satu hidangan terenak di dunia. Memadukan santan, cabai, kunyit, lengkuas, dan aneka rempah yang dimasak hingga menghasilkan daging sapi empuk, berbumbu kental, dan penuh rasa.', 'Minangkabau\'s distinctive seasoning for rendang, renowned as one of the world\'s most exquisite dishes, combines coconut milk, chili, turmeric, galangal, and an array of spices, all meticulously cooked to yield tender, richly seasoned, and flavorful beef.', 'products/Rendang pack.webp', 'EMP001', '2025-06-12 09:57:58', NULL, '2025-06-12 09:57:58', 1),
	(16, 'Bumbu Rawon', 'Black Beef Soup Seasoning', 1, 'Bumbu otentik untuk rawon, sup daging berwarna hitam khas Jawa Timur yang dibuat dari kluwek, bawang, dan aneka rempah aromatik. Rasanya kaya, gurih, dan sedikit pahit khas.', 'Authentic seasoning for rawon, a traditional black meat soup from East Java, is crafted from kluwek, onions, and an array of aromatic spices. The flavor profile is rich, savory, and subtly bitter.', 'products/Rawon pack.webp', 'EMP001', '2025-06-12 10:02:50', NULL, '2025-06-12 10:02:50', 1),
	(17, 'Bumbu Soto Betawi', 'Jakarta Style Soup Seasoning', 1, 'Bumbu siap pakai untuk soto khas Jakarta berbahan dasar santan atau susu dengan isian daging sapi, kentang dan aroma rempah-rempah seperti kayu manis dan pala yang kuat.', 'A convenient seasoning blend for traditional Jakarta soto, crafted from coconut milk or dairy, featuring beef and potato filling, complemented by a robust aroma of spices including cinnamon and nutmeg.', 'products/Soto Betawi pack.webp', 'EMP001', '2025-06-12 10:05:14', NULL, '2025-06-12 10:05:14', 1),
	(18, 'Bumbu Tom Yam', 'Tom Yum Soup Seasoning', 1, 'Bumbu instan untuk membuat Tomyam, sup pedas asam khas Thailand. Menggabungkan rasa pedas, asam, dan harum dari serai, daun jeruk, dan cabai.', 'Instant seasoning for preparing Tomyam, a quintessential Thai spicy and sour soup. It harmonizes the piquant, tangy, and aromatic notes of lemongrass, lime leaves, and chili.', 'products/Tom Yam pack.webp', 'EMP001', '2025-06-12 10:08:37', NULL, '2025-06-12 10:08:37', 1),
	(19, 'Cabai Kering Kasar', 'Flakes Chili', 3, 'Cabai merah kering yang memberikan sensasi pedas alami dengan tekstur yang masih terasa. Ideal untuk topping mie atau nasi goreng.', 'Dried red chilies that deliver a natural spiciness with a discernible texture. Perfect for garnishing noodles or fried rice.', 'products/Cabai Bubuk Kasar.webp', 'EMP001', '2025-06-13 01:20:00', NULL, '2025-06-13 01:20:00', 1),
	(20, 'Cabai Bubuk Halus', 'Chili Powder', 3, 'Cabai kering yang digiling halus untuk menghasilkan bubuk pedas serbaguna. Cocok untuk menambah tingkat kepedasan pada berbagai masakan, mulai dari sambal, sup, hingga bumbu tabur.', 'Finely ground dried chilies produce a versatile hot powder, ideal for enhancing the flavor of various dishes, including chili sauce, soups, and as a seasoning.', 'products/Cabe Bubuk Halus.webp', 'EMP001', '2025-06-13 01:20:57', NULL, '2025-06-13 01:20:57', 1),
	(21, 'Kayu Manis Bubuk', 'Cinnamon Powder', 3, 'Kayu manis pilihan yang digiling halus, memberikan aroma manis rempah yang hangat. Digunakan dalam hidangan manis seperti kue, serta beberapa masakan gurih seperti rendang.', 'Finely ground cinnamon imparts a warm, sweet spice aroma. It is utilized in sweet dishes like cakes, as well as in certain savory dishes such as rendang.', 'products/Kayu Manis .webp', 'EMP001', '2025-06-13 01:26:00', NULL, '2025-06-13 01:26:00', 1),
	(22, 'Lada Hitam Bubuk', 'Coarse Ground Black Papper', 3, 'Biji lada hitam berkualitas yang diolah menjadi bubuk yang berteskstur, menawarkan rasa pedas tajam dan aroma harum yang kuat, sempurna untuk steak, sup, dan aneka masakan berbumbu.', 'Premium black peppercorns ground into a textured powder, delivering a sharp, spicy flavor and a robust aromatic profile, ideal for enhancing steaks, soups, and a variety of spiced dishes.', 'products/Lada Hitam Kasar.webp', 'EMP001', '2025-06-13 01:30:04', NULL, '2025-06-13 01:30:04', 1),
	(23, 'Lada Hitam Bubuk Halus', 'Fine Powder Black Pepper', 3, 'Biji lada hitam berkualitas yang diolah menjadi bubuk halus, menawarkan rasa pedas tajam dan aroma harum yang kuat, sempurna untuk steak, sup, dan aneka masakan berbumbu.', 'Premium black peppercorns ground into a fine powder, delivering a sharp, spicy flavor and a robust aromatic profile, ideal for enhancing steaks, soups, and a variety of spiced dishes.', 'products/Lada Hitam Halus.webp', 'EMP001', '2025-06-13 01:32:56', NULL, '2025-06-13 01:32:56', 1),
	(24, 'Lada Putih Bubuk', 'Ground White Pepper', 3, 'Bubuk lada putih memberikan rasa pedas yang lebih lembut dibanding lada hitam, cocok untuk hidangan berkuah seperti soto, sup ayam, atau bakso.', 'White pepper powder offers a subtler spiciness compared to black pepper, making it ideal for brothy dishes such as soto, chicken soup, or meatballs.', 'products/Lada Putih.webp', 'EMP001', '2025-06-13 01:34:37', NULL, '2025-06-13 01:34:37', 1),
	(25, 'Ngohiong Bubuk', 'Five Spices Powder', 3, 'Campuran rempah khas Tiongkok seperti kayu manis, cengkeh, kayu manis, bunga lawang, lada putih dan adas, yang menghasilkan rasa manis pedas aromatik. Sering digunakan untuk bumbu daging, siomay, dan lumpia.', 'A combination of Chinese spices, including cinnamon, cloves, star anise, white pepper, and fennel, creates a sweet and spicy aromatic flavor. This blend is frequently employed to season meat, dumplings, and spring rolls.', 'products/Ngohiong.webp', 'EMP001', '2025-06-13 01:39:01', NULL, '2025-06-13 01:39:01', 1),
	(26, 'Ketumbar Bubuk', 'Ground Coriander', 3, 'Rempah klasik dari biji ketumbar yang digiling halus, menghasilkan aroma harum yang lembut. Sangat cocok untuk bumbu dasar berbagai masakan Indonesia seperti gulai, sate, hingga opor.', 'Classic spice derived from finely ground coriander seeds, yielding a delicate and fragrant aroma. It is particularly well-suited for the fundamental seasoning of various Indonesian dishes, including gulai, satay, and opor.', 'products/Ketumbar.webp', 'EMP001', '2025-06-13 01:40:28', NULL, '2025-06-13 01:40:28', 1),
	(27, 'Bawang Goreng', 'Fried Onions', 3, 'Bawang merah pilihan yang digoreng hingga renyah dan harum. Digunakan sebagai taburan di berbagai masakan seperti soto, nasi goreng, dan sup untuk menambah tekstur dan rasa gurih.', 'Selected shallots are fried until they achieve a crispy texture and a fragrant aroma. They serve as a topping for various dishes, including soto, fried rice, and soup, enhancing both texture and savory flavor.', 'products/Bawang Goreng.webp', 'EMP001', '2025-06-13 01:44:36', NULL, '2025-06-13 01:44:36', 1),
	(28, 'Bumbu Nasi Goreng', 'Fried Rice Seasoning', 1, 'Bumbu praktis untuk menciptakan nasi goreng ala restoran di rumah Anda. Perpaduan rempah dan bumbu seperti bawang, kecap, dan cabai yang siap memanjakan lidah.', 'Practical seasoning for crafting restaurant-quality fried rice in the comfort of your home. A harmonious blend of spices and seasonings, including onions, soy sauce, and chilies, designed to delight your palate.', 'products/Nasi Goreng sachet.webp', 'EMP001', '2025-06-13 01:54:26', NULL, '2025-06-13 01:54:26', 1);

-- Dumping structure for table pazar_seasoning.pazar_product_catalog
CREATE TABLE IF NOT EXISTS `pazar_product_catalog` (
  `pct_id` int NOT NULL AUTO_INCREMENT,
  `pct_catalog_id` varchar(255) DEFAULT NULL,
  `pct_catalog_en` varchar(255) DEFAULT NULL,
  `pct_created_by` varchar(20) NOT NULL,
  `pct_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `pct_updated_by` varchar(20) DEFAULT NULL,
  `pct_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`pct_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pazar_seasoning.pazar_product_catalog: ~1 rows (approximately)
INSERT INTO `pazar_product_catalog` (`pct_id`, `pct_catalog_id`, `pct_catalog_en`, `pct_created_by`, `pct_created_at`, `pct_updated_by`, `pct_updated_at`) VALUES
	(1, 'catalogs/Catalog PPL _IDN.pdf', 'catalogs/Catalog PPL_ENG.pdf', 'EMP001', '2025-07-04 09:06:00', 'EMP001', '2025-07-04 09:08:06');

-- Dumping structure for table pazar_seasoning.pazar_product_category
CREATE TABLE IF NOT EXISTS `pazar_product_category` (
  `pc_id` int NOT NULL AUTO_INCREMENT,
  `pc_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `pc_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `pc_description_id` text COLLATE utf8mb4_general_ci,
  `pc_description_en` text COLLATE utf8mb4_general_ci,
  `pc_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`pc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_product_category: ~4 rows (approximately)
INSERT INTO `pazar_product_category` (`pc_id`, `pc_title_id`, `pc_title_en`, `pc_description_id`, `pc_description_en`, `pc_image`) VALUES
	(1, 'Bumbu Instan', 'Instant Seasoning', 'Hadirkan hidangan autentik di meja makanmu. Cocok untuk konsumsi keluarga hingga usaha kuliner.', 'Bring authentic dishes to your dining table. Perfect for family consumption to culinary businesses.', 'product_categories/Bumbu (pack).webp'),
	(2, 'Sambal', 'Sambal', 'Pedas nikmat khas nuantara, praktis tinggal tuang. Hadir dengan beragam pilihan rasa.', 'Delicious spicy condiment with authentic Indonesian flavors, convenient ready-to-serve. Available in various flavor options.', 'product_categories/Sambal.webp'),
	(3, 'Rempah', 'Spices', 'Rempah asli pilihan, dikemas praktis untuk dapur modern. Dari bubuk hingga utuh.', 'Premium selected authentic spices, packaged conveniently for modern kitchens. From powder to whole spices.', 'product_categories/Rempah.webp'),
	(4, 'Horeka', 'Horeca', 'Rasa terbaik untuk dapur hotel, restoran, dan katering. Efisien, higienis, dan berkualitas premium.', 'Premium quality for hotel, restaurant, and catering kitchens. Efficient, hygienic, and premium quality.', 'product_categories/Horeca.webp');

-- Dumping structure for table pazar_seasoning.pazar_product_detail
CREATE TABLE IF NOT EXISTS `pazar_product_detail` (
  `pd_id` int NOT NULL AUTO_INCREMENT,
  `pd_id_product` int NOT NULL,
  `pd_net_weight` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pd_longdesc_id` text COLLATE utf8mb4_general_ci,
  `pd_longdesc_en` text COLLATE utf8mb4_general_ci,
  `pd_link_shopee` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pd_link_tokopedia` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pd_link_blibli` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pd_link_lazada` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pd_created_by` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `pd_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pd_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pd_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`pd_id`),
  KEY `pd_id_product` (`pd_id_product`),
  CONSTRAINT `pazar_product_detail_ibfk_1` FOREIGN KEY (`pd_id_product`) REFERENCES `pazar_product` (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_product_detail: ~26 rows (approximately)
INSERT INTO `pazar_product_detail` (`pd_id`, `pd_id_product`, `pd_net_weight`, `pd_longdesc_id`, `pd_longdesc_en`, `pd_link_shopee`, `pd_link_tokopedia`, `pd_link_blibli`, `pd_link_lazada`, `pd_created_by`, `pd_created_at`, `pd_updated_by`, `pd_updated_at`) VALUES
	(1, 1, '100g', NULL, NULL, 'https://shopee.co.id/Bumbu-Ayam-Goreng-Pazar-Pack-(100g)-i.1058738488.23877750098', 'https://tk.tokopedia.com/ZShWNp2eL/', 'https://www.blibli.com/p/bumbu-ayam-goreng-instan-pazar-100g/ps--PAS-70580-00002?ds=PAS-70580-00002-00001&source=MERCHANT_PAGE&sid=5bc3d85c20cc3ed5&cnc=false&pickupPointCode=PP-3531024&pid1=PAS-70580-00002', 'https://www.lazada.co.id/products/pdp-i7968990616.html?spm=a2o4j.store_product.list.41.58c964c2eJJM0T', '12345678', '2025-04-08 02:13:46', 'EMP001', '2025-06-12 09:52:04'),
	(2, 2, '90g', NULL, NULL, 'https://shopee.co.id/Bumbu-Ayam-Kalasan-Pazar-(90g)-i.1058738488.20783361318', 'https://tk.tokopedia.com/ZSkuuHdRs/', 'https://www.blibli.com/p/bumbu-ayam-kalasan-instan-pazar-90g/ps--PAS-70580-00004?ds=PAS-70580-00004-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', NULL, '12345678', '2025-04-08 02:13:46', 'EMP001', '2025-06-12 09:51:33'),
	(3, 3, '180g', NULL, NULL, 'https://shopee.co.id/Sambal-Terasi-Pazar-(180g)-i.1058738488.23377987069', 'https://tk.tokopedia.com/ZSkuuSsTy/', 'https://www.blibli.com/p/pazar-sambal-terasi-180g/ps--PAS-70580-00028?ds=PAS-70580-00028-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969728525-s14384954572.html?spm=a2o4j.8553159.0.0.28bf62ef3x20wR', '12345678', '2025-04-08 02:13:46', 'EMP001', '2025-06-12 09:46:52'),
	(4, 4, '50g', NULL, NULL, 'https://shopee.co.id/Kunyit-Bubuk-Pazar-(50g)-Rempah-i.1058738488.23752301151', 'https://tk.tokopedia.com/ZSkuu8ffw/', 'https://www.blibli.com/p/kunyit-bubuk-pazar-50g/ps--PAS-70580-00022?ds=PAS-70580-00022-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969832016-s14384998946.html?spm=a2o4j.8553159.0.0.28bf62ef3x20wR', '12345678', '2025-04-08 02:13:46', 'EMP001', '2025-06-12 09:45:09'),
	(5, 5, NULL, 'Bumbu Instan Edisi Spesial Pazar Seasonings...', 'Pazar Seasonings Special Edition Instant Seasoning...', 'https://shopee.co.id/pazar_seasonings/bumbu-instan-edisi-spesial', 'https://www.tokopedia.com/pazarseasonings/bumbu-instan-edisi-spesial', 'https://www.blibli.com/p/pazar-seasonings-bumbu-instan-edisi-spesial', 'https://www.lazada.co.id/products/pazar-seasonings-bumbu-instan-edisi-spesial', '12345678', '2025-04-08 02:13:46', NULL, NULL),
	(6, 7, '180g', NULL, NULL, 'https://shopee.co.id/Sambal-Bajak-Pazar-(180g)-i.1058738488.22377886402', 'https://tk.tokopedia.com/ZSkumgkTs/', 'https://www.blibli.com/p/sambal-bajak-instan-pazar-180g/ps--PAS-70580-00029?ds=PAS-70580-00029-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969710810-s14384962456.html?spm=a2o4j.8553159.0.0.28bf62ef3x20wR', 'EMP001', '2025-05-02 08:37:31', 'EMP001', '2025-06-12 09:42:28'),
	(7, 8, NULL, NULL, NULL, 'https://shopee.co.id/Sambal-Bakso-Pazar-(180g)-i.1058738488.23552390873', NULL, 'https://www.blibli.com/p/pazar-sambal-bakso-180g/ps--PAS-70580-00027?ds=PAS-70580-00027-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024&pid1=PAS-70580-00027', NULL, 'EMP001', '2025-06-12 07:25:05', NULL, '2025-06-12 07:25:05'),
	(8, 9, '85g', NULL, NULL, 'https://shopee.co.id/Sambal-Hijau-l-PAZAR-(85g)-i.1058738488.26256556894', NULL, 'https://www.blibli.com/p/sambal-bajak-l-pazar-85g/is--PAS-70580-00033-00001?source=SEARCH&sid=d67c56db6e5810c2&cnc=false&pickupPointCode=PP-3531024', NULL, 'EMP001', '2025-06-12 07:41:34', NULL, '2025-06-12 07:41:34'),
	(9, 10, '60g', NULL, NULL, 'https://shopee.co.id/Bumbu-Kuah-Bakso-Pazar-Pack-(60g)-i.1058738488.17798614594', 'https://tk.tokopedia.com/ZSkuSNe2U/', 'https://www.blibli.com/p/bumbu-kuah-bakso-instan-pazar-60g/ps--PAS-70580-00008?ds=PAS-70580-00008-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969054555-s14384284138.html?spm=a2o4j.8553159.0.0.28bf62ef6OjQzt', 'EMP001', '2025-06-12 07:53:29', NULL, '2025-06-12 07:53:29'),
	(10, 6, '60g', NULL, NULL, 'https://shopee.co.id/Bawang-Putih-Bubuk-Pazar-(60g)-Rempah-i.1058738488.18792319795', 'https://tk.tokopedia.com/ZSkuSSWBp/', 'https://www.blibli.com/p/bawang-putih-bubuk-pazar-60g/ps--PAS-70580-00001?ds=PAS-70580-00001-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969786698-s14385030586.html?spm=a2o4j.8553159.0.0.28bf62ef6OjQzt', 'EMP001', '2025-06-12 07:58:42', NULL, '2025-06-12 07:58:42'),
	(11, 11, '75g', NULL, NULL, 'https://shopee.co.id/Bumbu-Empal-Pazar-Pack-(75g)-i.1058738488.23852490656', 'https://tk.tokopedia.com/ZSkumyCT2/', 'https://www.blibli.com/p/bumbu-empal-instan-pazar-75g/ps--PAS-70580-00006?ds=PAS-70580-00006-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969138032-s14384278212.html?spm=a2o4j.8553159.0.0.28bf62ef3x20wR', 'EMP001', '2025-06-12 09:34:09', NULL, '2025-06-12 09:34:09'),
	(12, 12, '70g', NULL, NULL, 'https://shopee.co.id/Bumbu-Opor-Ayam-Pazar-Pack-(70g)-i.1058738488.18792245519', 'https://tk.tokopedia.com/ZSkummrAj/', 'https://www.blibli.com/p/bumbu-opor-instan-pazar-70g/ps--PAS-70580-00010?ds=PAS-70580-00010-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969726068-s14384912006.html?spm=a2o4j.8553159.0.0.28bf62ef3x20wR', 'EMP001', '2025-06-12 09:39:40', NULL, '2025-06-12 09:39:40'),
	(13, 13, '100g', NULL, NULL, 'https://shopee.co.id/Bumbu-Rica-Pazar-Pack-(100g)-i.1058738488.18883380675', 'https://tk.tokopedia.com/ZSkuuw8Jp/', 'https://www.blibli.com/p/bumbu-rica-instan-pazar-100g/ps--PAS-70580-00014?ds=PAS-70580-00014-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969674601.html?spm=a2o4j.store_product.list.1.435664c2qvV8Mz', 'EMP001', '2025-06-12 09:55:48', NULL, '2025-06-12 09:55:48'),
	(14, 14, '100', NULL, NULL, 'https://shopee.co.id/Bumbu-Woku-Pazar-Pack-(100g)-i.1058738488.20383320764', 'https://tk.tokopedia.com/ZSkuHSKpm/', 'https://www.blibli.com/p/bumbu-woku-instan-pazar-100g/ps--PAS-70580-00017?ds=PAS-70580-00017-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969752101.html?spm=a2o4j.store_product.list.33.435664c2qvV8Mz', 'EMP001', '2025-06-12 10:00:16', NULL, '2025-06-12 10:00:16'),
	(15, 15, '100g', NULL, NULL, 'https://shopee.co.id/Bumbu-Rendang-Pazar-Pack-(100g)-i.1058738488.22477786660', 'https://tk.tokopedia.com/ZSkuH5g9k/', 'https://www.blibli.com/p/bumbu-rendang-padang-instan-pazar-100g/ps--PAS-70580-00012?ds=PAS-70580-00012-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969704104.html?spm=a2o4j.store_product.list.87.435664c2qvV8Mz', 'EMP001', '2025-06-12 10:01:15', NULL, '2025-06-12 10:01:15'),
	(16, 16, '100g', NULL, NULL, 'https://shopee.co.id/Bumbu-Rawon-Pazar-Pack-(100g)-i.1058738488.20083318065', 'https://tk.tokopedia.com/ZSkuHoMjH/', 'https://www.blibli.com/p/bumbu-rawon-instan-pazar-100g/ps--PAS-70580-00011?ds=PAS-70580-00011-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969000073.html?spm=a2o4j.store_product.list.91.435664c2qvV8Mz', 'EMP001', '2025-06-12 10:04:33', NULL, '2025-06-12 10:04:33'),
	(17, 17, '100g', NULL, NULL, 'https://shopee.co.id/Bumbu-Soto-Betawi-Pazar-Pack-(100g)-i.1058738488.22952496354', 'https://tk.tokopedia.com/ZSku9j35k/', 'https://www.blibli.com/p/bumbu-soto-betawi-instan-pazar-100g/ps--PAS-70580-00015?ds=PAS-70580-00015-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969664879.html?spm=a2o4j.store_product.list.58.435664c2qvV8Mz', 'EMP001', '2025-06-12 10:07:59', NULL, '2025-06-12 10:07:59'),
	(18, 18, '100g', NULL, NULL, 'https://shopee.co.id/Bumbu-Tom-Yam-Pazar-Pack-(100g)-i.1058738488.19092273122', 'https://tk.tokopedia.com/ZSku9uW6j/', 'https://www.blibli.com/p/bumbu-tom-yam-pazar-100g/ps--PAS-70580-00016?ds=PAS-70580-00016-00001&source=MERCHANT_PAGE&sid=93de1f251470d0ac&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969716150.html?spm=a2o4j.store_product.list.61.435664c2qvV8Mz', 'EMP001', '2025-06-12 10:09:39', NULL, '2025-06-12 10:09:39'),
	(19, 19, '30g', NULL, NULL, 'https://shopee.co.id/Cabai-Bubuk-Merah-Kering-Pazar-(30g)-Rempah-i.1058738488.22252494921', 'https://tk.tokopedia.com/ZSkHCxrkd/', 'https://www.blibli.com/p/cabai-merah-kering-instan-pazar-30g/ps--PAS-70580-00019?ds=PAS-70580-00019-00001&source=MERCHANT_PAGE&sid=010bfc6fa3df3bb9&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969810373.html?spm=a2o4j.store_product.list.21.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:24:06', NULL, '2025-06-13 01:24:06'),
	(20, 20, '40g', NULL, NULL, 'https://shopee.co.id/Cabai-Bubuk-Pazar-(40g)-Rempah-i.1058738488.19092329899', 'https://tk.tokopedia.com/ZSkHCPV5r/', 'https://www.blibli.com/p/cabai-bubuk-pazar-40g/ps--PAS-70580-00018?ds=PAS-70580-00018-00001&source=MERCHANT_PAGE&sid=010bfc6fa3df3bb9&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969790638.html?spm=a2o4j.store_product.list.37.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:25:10', NULL, '2025-06-13 01:25:10'),
	(21, 21, '40g', NULL, NULL, 'https://shopee.co.id/Kayu-Manis-Bubuk-Pazar-(40g)-Rempah-i.1058738488.23277791011', 'https://tk.tokopedia.com/ZSkHX8524/', 'https://www.blibli.com/p/kayu-manis-bubuk-pazar-40g/ps--PAS-70580-00020?ds=PAS-70580-00020-00001&source=MERCHANT_PAGE&sid=010bfc6fa3df3bb9&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969988049.html?spm=a2o4j.store_product.list.7.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:29:42', NULL, '2025-06-13 01:29:42'),
	(22, 22, '50g', NULL, NULL, 'https://shopee.co.id/Lada-Hitam-Bubuk-Pazar-(50g)-Rempah-i.1058738488.22177907430', 'https://tk.tokopedia.com/ZSkHXeJja/', 'https://www.blibli.com/p/lada-hitam-bubuk-pazar-50g/ps--PAS-70580-00024?ds=PAS-70580-00024-00001&source=MERCHANT_PAGE&sid=010bfc6fa3df3bb9&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969920650.html?spm=a2o4j.store_product.list.23.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:32:15', NULL, '2025-06-13 01:32:15'),
	(23, 23, '50g', NULL, NULL, 'https://shopee.co.id/Lada-Hitam-Bubuk-Halus-Pazar-(50g)-Rempah-i.1058738488.20583332763', 'https://tk.tokopedia.com/ZSkHXGREy/', 'https://www.blibli.com/p/lada-hitam-bubuk-halus-pazar-50g/ps--PAS-70580-00023?ds=PAS-70580-00023-00001&source=MERCHANT_PAGE&sid=010bfc6fa3df3bb9&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969972372.html?spm=a2o4j.store_product.list.19.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:33:53', NULL, '2025-06-13 01:33:53'),
	(24, 24, '50g', NULL, NULL, 'https://shopee.co.id/Lada-Putih-Bubuk-Pazar-(50g)-Rempah-i.1058738488.23377905512', 'https://tk.tokopedia.com/ZSkHXGY9h/', NULL, 'https://www.lazada.co.id/products/pdp-i7969886623.html?spm=a2o4j.store_product.list.27.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:38:21', NULL, '2025-06-13 01:38:21'),
	(25, 25, '40g', NULL, NULL, 'https://shopee.co.id/Ngo-Hiong-Bubuk-Pazar-(40g)-Rempah-i.1058738488.20792282022', NULL, NULL, 'http://lazada.co.id/products/pdp-i7969902819.html?spm=a2o4j.store_product.list.11.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:40:06', NULL, '2025-06-13 01:40:06'),
	(26, 26, '40g', NULL, NULL, 'https://shopee.co.id/Ketumbar-Bubuk-Pazar-(40g)-Rempah-i.1058738488.22452416639', 'https://tk.tokopedia.com/ZSkHXo1gH/', 'https://www.blibli.com/p/ketumbar-bubuk-pazar-40g/ps--PAS-70580-00021?ds=PAS-70580-00021-00001&source=MERCHANT_PAGE&sid=010bfc6fa3df3bb9&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969896717.html?spm=a2o4j.store_product.list.15.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:43:58', NULL, '2025-06-13 01:43:58'),
	(27, 27, '80g', NULL, NULL, 'https://shopee.co.id/Bawang-Goreng-Pazar-(80g)-i.1058738488.22852265613', NULL, NULL, NULL, 'EMP001', '2025-06-13 01:45:55', NULL, '2025-06-13 01:45:55'),
	(28, 28, '40g', NULL, NULL, 'https://shopee.co.id/Bumbu-Nasi-Goreng-Instan-Pazar-(Sachet-40g)-i.1058738488.21192311585', 'https://tk.tokopedia.com/ZSkHV1BGN/', 'https://www.blibli.com/p/bumbu-instan-nasi-goreng-pazar-40g/ps--PAS-70580-00007?ds=PAS-70580-00007-00001&source=MERCHANT_PAGE&sid=010bfc6fa3df3bb9&cnc=false&pickupPointCode=PP-3531024', 'https://www.lazada.co.id/products/pdp-i7969810061.html?spm=a2o4j.store_product.list.25.4c1f12e8rY0MsE', 'EMP001', '2025-06-13 01:56:15', NULL, '2025-06-13 01:56:15');

-- Dumping structure for table pazar_seasoning.pazar_recipe
CREATE TABLE IF NOT EXISTS `pazar_recipe` (
  `r_id` int NOT NULL AUTO_INCREMENT,
  `r_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `r_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `r_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `r_created_by` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `r_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `r_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `r_updated_at` timestamp NULL DEFAULT NULL,
  `r_is_active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_recipe: ~12 rows (approximately)
INSERT INTO `pazar_recipe` (`r_id`, `r_title_id`, `r_title_en`, `r_image`, `r_created_by`, `r_created_at`, `r_updated_by`, `r_updated_at`, `r_is_active`) VALUES
	(1, 'Rendang', 'Rendang', 'recipes/Rendang Padang.webp', 'EMP001', '2025-04-30 08:18:21', 'EMP001', '2025-05-23 04:16:20', 1),
	(2, 'Opor Ayam', 'Chicken Opor', 'recipes/Opor.webp', 'EMP001', '2025-04-30 08:18:21', 'EMP001', '2025-07-09 06:07:40', 1),
	(3, 'Ayam Rica-Rica', 'Chicken Rica-Rica', 'recipes/Rica.webp', 'EMP001', '2025-04-30 08:18:21', 'EMP001', '2025-06-12 04:36:59', 1),
	(4, 'Empal Daging', 'Beef Empal', 'recipes/Empal.webp', 'EMP001', '2025-04-30 08:18:21', 'EMP001', '2025-06-12 04:37:46', 1),
	(5, 'Ayam Goreng', 'Fried Chicken', 'recipes/Ayam goreng.webp', 'EMP001', '2025-04-30 08:18:21', 'EMP001', '2025-06-12 04:41:22', 1),
	(6, 'Ayam Kalasan', 'Kalasan Chicken', 'recipes/Kalasan.webp', 'EMP001', '2025-05-23 09:24:05', 'EMP001', '2025-06-12 04:42:32', 1),
	(7, 'Soto Betawi', 'Soto Betawi', 'recipes/Soto Betawi.webp', 'EMP001', '2025-05-23 09:39:20', 'EMP001', '2025-06-12 04:42:55', 1),
	(8, 'Kuah bakso', 'Bakso Broth', 'recipes/Bakso.webp', 'EMP001', '2025-05-23 09:47:21', 'EMP001', '2025-06-12 04:43:16', 1),
	(9, 'Ayam Woku', 'Woku Chicken', 'recipes/Woku.webp', 'EMP001', '2025-06-11 09:38:46', 'EMP001', '2025-06-12 04:43:34', 1),
	(10, 'Tom Yam', 'Tom Yam', 'recipes/Tomyam.webp', 'EMP001', '2025-06-11 09:40:49', 'EMP001', '2025-06-12 04:43:51', 1),
	(11, 'Rawon', 'Black Beef Soup', 'recipes/Rawon.webp', 'EMP001', '2025-06-11 09:47:14', 'EMP001', '2025-06-12 04:44:22', 1),
	(12, 'Nasi Goreng', 'Fried Rice', 'recipes/Nasi goreng.webp', 'EMP001', '2025-06-11 09:49:00', 'EMP001', '2025-06-12 04:44:50', 1);

-- Dumping structure for table pazar_seasoning.pazar_recipe_category
CREATE TABLE IF NOT EXISTS `pazar_recipe_category` (
  `rc_id` int NOT NULL AUTO_INCREMENT,
  `rc_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `rc_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`rc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_recipe_category: ~2 rows (approximately)
INSERT INTO `pazar_recipe_category` (`rc_id`, `rc_title_id`, `rc_title_en`) VALUES
	(1, 'Nusantara', 'Indonesian'),
	(2, 'Asia', 'Asian');

-- Dumping structure for table pazar_seasoning.pazar_recipe_category_junction
CREATE TABLE IF NOT EXISTS `pazar_recipe_category_junction` (
  `rcj_id` int NOT NULL AUTO_INCREMENT,
  `rcj_id_recipe` int NOT NULL,
  `rcj_id_category` int NOT NULL,
  PRIMARY KEY (`rcj_id`),
  KEY `rcj_id_recipe` (`rcj_id_recipe`),
  KEY `rcj_id_category` (`rcj_id_category`),
  CONSTRAINT `pazar_recipe_category_junction_ibfk_1` FOREIGN KEY (`rcj_id_recipe`) REFERENCES `pazar_recipe` (`r_id`),
  CONSTRAINT `pazar_recipe_category_junction_ibfk_2` FOREIGN KEY (`rcj_id_category`) REFERENCES `pazar_recipe_category` (`rc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_recipe_category_junction: ~12 rows (approximately)
INSERT INTO `pazar_recipe_category_junction` (`rcj_id`, `rcj_id_recipe`, `rcj_id_category`) VALUES
	(1, 1, 1),
	(3, 2, 1),
	(4, 3, 1),
	(6, 4, 1),
	(7, 5, 2),
	(8, 5, 1),
	(9, 6, 1),
	(10, 7, 1),
	(11, 8, 1),
	(12, 9, 1),
	(13, 10, 2),
	(14, 11, 1),
	(15, 12, 1),
	(16, 12, 2);

-- Dumping structure for table pazar_seasoning.pazar_recipe_detail
CREATE TABLE IF NOT EXISTS `pazar_recipe_detail` (
  `rd_id` int NOT NULL AUTO_INCREMENT,
  `rd_id_recipe` int NOT NULL,
  `rd_desc_id` text COLLATE utf8mb4_general_ci,
  `rd_desc_en` text COLLATE utf8mb4_general_ci,
  `rd_ingredients_id` text COLLATE utf8mb4_general_ci,
  `rd_ingredients_en` text COLLATE utf8mb4_general_ci,
  `rd_cook_id` text COLLATE utf8mb4_general_ci,
  `rd_cook_en` text COLLATE utf8mb4_general_ci,
  `rd_link_youtube` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rd_created_by` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `rd_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `rd_updated_by` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rd_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`rd_id`),
  KEY `rd_id_recipe` (`rd_id_recipe`),
  CONSTRAINT `pazar_recipe_detail_ibfk_1` FOREIGN KEY (`rd_id_recipe`) REFERENCES `pazar_recipe` (`r_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_recipe_detail: ~11 rows (approximately)
INSERT INTO `pazar_recipe_detail` (`rd_id`, `rd_id_recipe`, `rd_desc_id`, `rd_desc_en`, `rd_ingredients_id`, `rd_ingredients_en`, `rd_cook_id`, `rd_cook_en`, `rd_link_youtube`, `rd_created_by`, `rd_created_at`, `rd_updated_by`, `rd_updated_at`) VALUES
	(1, 1, 'Rendang adalah .....', 'Rendang is .....', '- 1 pak PAZAR Bumbu Rendang Padang\r\n- 70 ml santan instan\r\n- 700 ml air\r\n- 700 gram daging di potong 5 x 5 x 2 cm\r\n\r\nBAHAN TAMBAHAN\r\n- 1 lembar daun kunyit\r\n- 2 lembar daun jeruk', '- 1 pack of PAZAR Padangnese Beef Rendang Seasoning (100g)\r\n70 ml instant coconut milk\r\n- 700 ml of water\r\n- 700 grams of meat, diced into 5 x 5 x 2 cm cubes\r\n\r\nADDITIONAL COMPONENTS\r\n- 1 turmeric leaf\r\n- 2 lime leaves', '1. Masukkan daging, air, santan, daun kunyit, daun jeruk, dan bumbu ke dalam panci lalu didihkan.\r\n2. Masak dengan api kecil dan aduk sekali-kali hingga airnya kering dan dagingnya empuk.', '1.	Combine the meat, water, coconut milk, turmeric leaves, lime leaves, and spices in a pan and bring to a boil.\r\n2.	Cook over low heat, stirring occasionally, until the water evaporates and the meat becomes tender.', 'https://drive.google.com/file/d/1zxCjK_jzKVe5FnJbbQbeJLS_pDdTUbst/preview', 'EMP001', '2025-04-30 09:10:53', 'EMP001', '2025-05-23 04:19:24'),
	(2, 2, NULL, NULL, 'SIAPKAN\r\n- 1 pak PAZAR Bumbu Opor Ayam\r\n- 1 ekor ayam (700 gram) dipotong 12 bagian\r\n- 65 ml santan instan\r\n- 700 ml air\r\n- 3 lembar daun salam', 'PREPARE\r\n- 1 package of PAZAR Braised Chicken In Coconut Seasoning (70g)\r\n- 1 chicken (700 grams) divided into 12 portions\r\n- 65 ml of instant coconut milk\r\n- 700 ml of water\r\n- Three bay leaves', '1. Masukkan ayam potong, air, daun salam dan bumbu ke dalam panci atau wajan.\r\n2. Masak hingga mendidih lalu masukan santan.\r\n3. Masak sambil diaduk dengan api kecil agar santan tidak pecah hingga ayam empuk.', '1.	Combine the chicken pieces, water, bay leaves, and spices in a pan or wok.\r\n2. Heat until boiling, then incorporate coconut milk.\r\n3. Cook while stirring over low heat to prevent the coconut milk from curdling until the chicken is tender.', 'https://drive.google.com/file/d/1x0-DbgrUJtcddt4rQeXjuSG3UGBFVFyg/preview', 'EMP001', '2025-05-22 01:23:29', 'EMP001', '2025-05-23 08:51:28'),
	(3, 3, NULL, NULL, 'SIAPKAN\r\n- 1 pak Pazar Bumbu Rica\r\n- 1 ekor ayam (700 gram) dipotong 12 bagian\r\n- 250 ml air\r\n- 3 lembar daun jeruk\r\n\r\nBAHAN PELENGKAP\r\n- 1 buah jeruk limau diperas buang bijinya.', 'PREPARE\r\n- 1 package of PAZAR Rica Seasoning (100 g)\r\n- 1 chicken (700 grams) divided into 12 pieces\r\n- 250 ml of water\r\n- 3 lime leaves\r\n\r\nSUPPLEMENTARY RESOURCES\r\n- 1 lime, juiced and seeds discarded.', '1. Masukkan ayam, air, daun jeruk dan bumbu kedalam panci atau wajan.\r\n2. Masak hingga ayam menjadi empuk dan bumbu meresap.\r\n3. Masukkan perasan jeruk limau, aduk rata lalu hidangkan.', '1.	Combine the chicken, water, lime leaves, and spices in a pan or wok.\r\n2. Cook until the chicken is tender and the spices have been absorbed.\r\n3. Incorporate lime juice, mix thoroughly, and serve.', 'https://drive.google.com/file/d/1xAIWfdIK2UaR40cjdZDVo4fZzFR-wa9-/preview', 'EMP001', '2025-05-23 09:11:02', NULL, '2025-05-23 09:11:02'),
	(4, 4, NULL, NULL, 'SIAPKAN\r\n- 1 pak PAZAR Bumbu Empal\r\n- 500 gram daging khas dalam di potong 5 x 5 x 1 cm\r\n- 750 ml air', 'PREPARE\r\n- 1 package of PAZAR Indonesian Sweet Fried Beef Jerky Seasoning (75 g)\r\n- 500 grams of premium meat, diced into 5 x 5 x 1 cm cubes\r\n- 750 ml of water', '1. Masukkan air, daging dan bumbu ke dalam panci atau wajan.\r\n2. Masak hingga daging empuk dan air kering.\r\n3. Goreng dengan minyak panas sedang hingga berwarna coklat.', '1.	Combine the water, meat, and spices in a pot or frying pan.\r\n2. Cook until the meat becomes tender and the water has evaporated.\r\n3. Fry in moderately hot oil until browned.', 'https://drive.google.com/file/d/1ztZR4L0KmCoTOZwyuTgIM0T60q7qz-c1/preview', 'EMP001', '2025-05-23 09:19:14', NULL, '2025-05-23 09:19:14'),
	(5, 5, NULL, NULL, 'SIAPKAN\r\n- 1 pak PAZAR Bumbu Ayam Goreng\r\n- 1 ekor ayam (700 gram) dipotong 12 bagian\r\n- 250 ml air', 'PREPARE\r\n- 1 package of PAZAR Fried Chicken Seasoning (100g)\r\n- 1 chicken (700 grams) divided into 12 portions\r\n- 250 ml of water', '1. Masukkan ayam, bumbu dan air ke dalam panci.\r\n2. Masak hingga ayam empuk dan bumbu meresap.\r\n3. Goreng ayam dengan minyak panas hingga kecoklatan.', '1.	Combine the chicken, spices, and water in a pan.\r\n2.	Cook until the chicken is tender and the spices have been absorbed.', 'https://drive.google.com/file/d/1wi73LByFJA5lGm8X1J9Z3HH6G8HcwEbR/preview', 'EMP001', '2025-05-23 09:22:37', NULL, '2025-05-23 09:22:37'),
	(6, 6, NULL, NULL, 'SIAPKAN\r\n- 1 pak PAZAR Bumbu Ayam Kalasan\r\n- 1 ekor ayam (700 gram) dipotong 12 bagian \r\n- 350 ml air atau air kelapa', 'PREPARE\r\n- 1 pack of PAZAR Kalasan Chicken Seasoning (90 g)\r\n- 1 chicken (700 grams) divided into 12 pieces\r\n- 350 ml of water or coconut water', '1. Masukkan ayam, air atau air kelapa dan bumbu ke dalam panci.\r\n2. Masak hingga ayam empuk dan bumbu meresap.\r\n3. Goreng ayam dalam minyak panas hingga kecoklatan.', '1.	Combine the chicken, water or coconut water, and spices in a pan.\r\n2.	Cook until the chicken is tender and the spices have been absorbed.', 'https://drive.google.com/file/d/1znkgfGoOws7JZxkBK_dUh6_-Wm36Of6a/preview', 'EMP001', '2025-05-23 09:25:51', NULL, '2025-05-23 09:25:51'),
	(7, 7, NULL, NULL, 'SIAPKAN\r\nBahan A:\r\n-400 gram daging sapi tetelan\r\n-2000 ml air mendidih\r\n-5 lembar daun salam\r\n\r\nBahan B:\r\n-150 gram paru\r\n-150 gram urat\r\n-1500 ml air mendidih\r\n\r\nBahan C:\r\n- 250 ml santan instan\r\n- 1 pak PAZAR Bumbu Soto Betawi\r\n\r\nBAHAN PELENGKAP\r\n- 1 buah tomat iris tipis-tipis\r\n- 2 batang daun bawang iris tipis-tipis \r\n- 1 kentang direbus, digoreng utuh lalu potong kotak\r\n- kecap manis\r\n- jeruk limau\r\n- PAZAR Bawang Merah Goreng\r\n- emping goreng', 'PREPARE\r\nMaterial A:\r\n-400 grams of beef organ meat\r\n-2000 ml of boiling water\r\n-5 bay leaves\r\n\r\nMaterial B:\r\n-150 grams of pulmonary tissue\r\n-150 grams of tendons\r\n-1500 ml of boiling water\r\n\r\nMaterial C:\r\n- 250 ml of instant coconut milk\r\n- 1 package of PAZAR Jakarta Style Soup Seasoning (100g)\r\n\r\nSUPPLEMENTARY RESOURCES\r\n- 1 tomato, finely sliced\r\n- 2 stalks of scallions, finely sliced\r\n- 1 potato, boiled, fried whole, and diced\r\n- sweet soy glaze\r\n- lime\r\n- Fried Shallots Market\r\ncrispy fries', '1. Masak Bahan A hingga empuk, angkat. Potong dadu, sisihkan. Tambahkan air hingga menjadi 2500 ml kaldu.\r\n2. Masak bahan secara terpisah hingga empuk, angkat. Potong dadu, sisishkan.\r\n3. Masak Bahan A dengan Bahan C dengan api kecil sambil diaduk hingga mendidih selama 5 menit.\r\n4. Siapkan mangkok: Masukkan daging, paru, urat, potongan tomat, kentang, dan daun bawang. Tuang air soto ke dalam mangkok. Sajikan dengan perasan jeruk, kecap manis, PAZAR Bawang Goreng dan emping sesuai selera.', '1. Cook Ingredient A until tender, then remove it. Cut into cubes and set aside. Add water until the total volume reaches 2500 ml of stock.\r\n2. Cook the ingredients individually until tender, then remove. Cut into cubes and set aside.\r\n3. Combine Ingredient A with Ingredient C and cook over low heat, stirring continuously until the mixture reaches a boil, approximately 5 minutes.\r\n4. Prepare a bowl: Combine the meat, lungs, tendons, tomato slices, potatoes, and spring onions. Pour the soto broth into the bowl. Serve with lime juice, sweet soy sauce, PAZAR Fried Onions, and emping to taste.', 'https://drive.google.com/file/d/1P_Jv5B-5yjCB5O77b3PPBseJrTh7Jn1J/preview', 'EMP001', '2025-05-23 09:44:42', NULL, '2025-05-23 09:44:42'),
	(8, 8, NULL, NULL, 'SIAPKAN\r\n- 1 pak PAZAR Bumbu Kuah Bakso\r\n- 500 gram tulang sapi\r\n- 250 gram tetelan sapi\r\n- 1500 ml air mendidih\r\n- 250 gram bihun rebus selama 1 menit\r\n- bakso sapi (secukupnya)\r\n\r\nBAHAN PELENGKAP\r\n- PAZAR Bawang Merah  Goreng\r\n- 1 batang seledri di iris tipis\r\n- PAZAR Sambal Bakso\r\n- kecap manis', 'PREPARE\r\n- 1 package of PAZAR Beef Meatball Seasoning (60 g)\r\n- 500 grams of beef bones\r\n- 250 grams of beef organ meat\r\n- 1500 ml of boiling water\r\n- 250 grams of rice vermicelli, cooked for 1 minute\r\n- beef meatballs (as required)\r\n\r\nSUPPLEMENTARY RESOURCES\r\n- Fried Shallots Market\r\n- 1 stalk of celery, finely sliced\r\n- Sambal Meatball Market\r\n- sweet soy glaze', '1. Masukkan tulang sapi, tetelan ke dalam air mendidih. Masak dengan api kecil selama 30 menit, tambahkan air hingga ke level awal.\r\n2. Masukkan bumbu. Didihkan 10 menit.\r\n3. Taruh bihun ke dalam mangkuk. Tuangkan kaldu, bakso. Sajikan dengan PAZAR Bawang Goreng, irisan daun seledri, sambal dan kecap manis sesuai selera.', '1. Place the beef bones and offal into boiling water. Simmer on low heat for 30 minutes, adding water to return to the initial level.\r\n2. Incorporate the spices. Allow to simmer for 10 minutes.\r\n3. Place the rice vermicelli in a bowl. Add the broth and meatballs. Serve with PAZAR Fried Onions, sliced celery leaves, chili sauce, and sweet soy sauce to taste.', 'https://drive.google.com/file/d/1x99-lJCKJCghH7wo_X8oP9x4kICPi41S/preview', 'EMP001', '2025-05-23 09:48:33', 'EMP001', '2025-05-23 09:49:26'),
	(9, 9, NULL, NULL, 'SIAPKAN\r\n- 1 pak PAZAR Bumbu Woku\r\n- 1 ekor ayam (700 gram) dipotong 24 bagian\r\n- 250 ml air\r\n- 100 gram daun bawang dipotong 1 cm\r\n- 1 ikat daun kemangi\r\n\r\nBAHAN TAMBAHAN\r\n- 2 lembar daun jeruk\r\n- 1 batang sereh digeprek', 'PREPARE\r\n- 1 pack of PAZAR Woku Seasoning (100 g)\r\n- 1 chicken (700 grams) divided into 24 pieces\r\n- 250 ml of water\r\n- 100 grams of spring onions, chopped into 1 cm segments\r\n- 1 bunch of basil leaves\r\n\r\nADDITIONAL COMPONENTS\r\n- 2 lime leaves\r\n- 1 stalk of crushed lemongrass', '1. Masukkan ayam, air, daun jeruk, sereh dan bumbu ke dalam panci atau wajan.\r\n2. Masak hingga ayam menjadi empuk dan bumbu meresap.\r\n3. Masukkan daun bawang dan daun kemangi, masak sebentar.', '1.Combine the chicken, water, lime leaves, lemongrass, and spices in a pot or wok.\r\n2. Cook until the chicken is tender and the spices have been absorbed.\r\n3. Add the spring onions and basil leaves, and cook briefly.', 'https://drive.google.com/file/d/1xcCq9hZnkJ3e0yvDk3iWnDkz7le7SMrM/preview', 'EMP001', '2025-06-12 03:39:24', NULL, '2025-06-12 03:39:24'),
	(10, 10, NULL, NULL, 'SIAPKAN\r\n- 1 pak PAZAR Bumbu Tom Yam\r\n- 1700 ml air\r\n- 300 gram udang kupas kulitnya dengan ekor kulit udang (dicuci bersih)\r\n- 200 gram jamur merang (dipotong 2)\r\n- 6 buah cabe rawit merah\r\n- 4 lembar daun jeruk\r\n- 2 batang sereh (bagian putih, iris serong panjang)\r\n- 3 cm lengkuas (iris tipis-tipis)\r\n\r\nBAHAN PELENGKAP\r\n- 2 ikat daun ketumbar (wansui)', 'PREPARE\r\n- 1 pack PAZAR Tom Yum Soup Seasoning (100g)\r\n- 1700 ml of water\r\n- 300 grams of peeled shrimp with tails (thoroughly washed)\r\n- 200 grams of straw mushrooms (halved)\r\n- 6 red cayenne peppers\r\n- 4 kaffir lime leaves\r\n- 2 stalks of lemongrass (white portion, sliced diagonally)\r\n- 3 cm galangal (finely sliced)\r\n\r\nSUPPLEMENTARY RESOURCES\r\n- 2 bunches of cilantro leaves (coriander)', '1. Rebus kulit udang selama 15 menit dengan api kecil.\r\n2. Angkat kulit udang dari kaldu.\r\n3. Masukkan udang, jamur, cabe rawit, daun jeruk, sereh, lengkuas dan bumbu. Didihkan selama 2 menit lalu masukan daun ketumbar dan langsung matikan kompor. (Daun ketumbar akan berubah warna apabila dimasak terlalu lama)', '1.	Boil the shrimp shells for 15 minutes on low heat.\r\n2.	Remove the shells of the shrimp from the broth.\r\n3.	Incorporate shrimp, mushrooms, cayenne pepper, lime leaves, lemongrass, galangal, and spices. Boil for two minutes, then add coriander leaves and promptly turn off the heat. (Coriander leaves will discolor if cooked for an extended period.)', 'https://drive.google.com/file/d/1x_btxMOHz6rq69nZgCAxlPzz9E-JuGbZ/preview', 'EMP001', '2025-06-12 03:42:27', NULL, '2025-06-12 03:42:27'),
	(11, 11, NULL, NULL, 'SIAPKAN\r\n-1 pak PAZAR Bumbu Rawon\r\n- 1200 ml air, didihkan\r\n- 500 gram daging sandung lamur/sengkel\r\n-1 lembar daun salam\r\n- 2 lembar daun jeruk\r\n- 1 batang sereh di geprek\r\n\r\nBAHAN PELENGKAP\r\n-100 gram tauge kecambah\r\n- PAZAR Bawang Goreng\r\n- jeruk limau', 'PREPARE\r\n-1 pack of PAZAR Black Beef Soup Seasoning (100g)\r\n- 1200 ml of water, bring to a boil\r\n- 500 grams of brisket or shank\r\n-1 bay leaf\r\n- 2 lime leaves\r\n- 1 stalk of crushed lemongrass\r\n\r\nSUPPLEMENTARY RESOURCES\r\n-100 grams of mung bean sprouts\r\n- Fried Onion Industry\r\n- lime', '1. Masukkan daging, bumbu, daun salam, daun jeruk, sereh ke dalam air mendidih.\r\n2. Masak dengan api kecil hingga daging empuk.\r\n3. Sajikan dengan PAZAR Bawang Goreng, tauge kecambah dan perasan jeruk limau.', '1. Place the meat, spices, bay leaves, lime leaves, and lemongrass into boiling water.\r\n2. Simmer over low heat until the meat becomes tender.\r\n3. Accompany with PAZAR Fried Onions, bean sprouts, and lime juice.', 'https://drive.google.com/file/d/1zqFybUAJrOLnH_2UHBeex7Ex52DYRQSG/preview', 'EMP001', '2025-06-12 03:46:20', NULL, '2025-06-12 03:46:20'),
	(12, 12, NULL, NULL, 'SIAPKAN\r\n- 1 sachet Pazar Bumbu Nasi Goreng\r\n- 1.5 piring (300 g) nasi putih dingin\r\n- 5 ekor udang kupas\r\n-1/2 papan petai dikupas\r\n- 2 sendok makan minyak goreng\r\n- PAZAR Bawang Goreng', 'PREPARE\r\n- 1 sachet of Pazar Fried Rice Seasoning (40g)\r\n- 1.5 plates (300 g) of chilled white rice\r\n- 5 deveined shrimps\r\n-1/2 petai board, peeled\r\n- 2 tablespoons of cooking oil\r\n- Fried Onion Industry', '1. Masukkan minyak goreng, bumbu, petai dan udang.\r\n2. Masak selama 2 menit, lalu masukkan nasi, aduk hingga merata.\r\n3. Tabur dengan PAZAR Bawang Goreng.', '1.	Incorporate cooking oil, spices, petai, and shrimp.\r\n2.	Cook for 2 minutes, then incorporate the rice, stirring until thoroughly combined.\r\n3. Garnish with PAZAR Fried Onion.', 'https://drive.google.com/file/d/1xFqFbczP6MAbTR3DGskF2QBtaeRq6J9-/preview', 'EMP001', '2025-06-12 03:48:32', NULL, '2025-06-12 03:48:32');

-- Dumping structure for table pazar_seasoning.pazar_testimonial
CREATE TABLE IF NOT EXISTS `pazar_testimonial` (
  `t_id` int NOT NULL AUTO_INCREMENT,
  `t_name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `t_gender` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `t_description_id` text COLLATE utf8mb4_general_ci,
  `t_description_en` text COLLATE utf8mb4_general_ci,
  `t_product_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_product_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `t_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `t_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`t_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_testimonial: ~4 rows (approximately)
INSERT INTO `pazar_testimonial` (`t_id`, `t_name`, `t_gender`, `t_description_id`, `t_description_en`, `t_product_id`, `t_product_en`, `t_type`, `t_link`, `t_image`) VALUES
	(1, 'Chef Aziz Amri', 'Male', 'Event : Cooking Series "Ide Menu Bekal Praktis” Nasi Goreng Ayam Kalasan dan Telur Gulung Bento. Kolaborasi Informa x Olagud x PAZAR Seasonings\r\nTime : 27 April 2024\r\n\r\n(Nasi Goreng Ayam Kalasan)\r\nProduk yang digunakan : \r\nBawang goreng PAZAR\r\nBumbu Nasi goreng PAZAR\r\nBumbu Ayam kalasan PAZAR                                                                   \r\n\r\n(Gulung Bento & Grilled Veggies)\r\nProduk yang digunakan : \r\nLada hitam bubuk\r\nBawang putih bubuk\r\nCabai bubuk', 'Event: Cooking Series "Practical Lunchbox Ideas" Kalasan Chicken Fried Rice and Bento Egg Rolls. A collaboration between Informa x Olagud x PAZAR Seasonings\r\nTime: April 27, 2024\r\n\r\n(Kalasan Chicken Fried Rice)\r\nProducts used:\r\nPAZAR fried onions\r\nPAZAR fried rice seasoning\r\nPAZAR Kalasan Chicken Seasoning\r\n\r\n(Bento Rolls & Grilled Veggies)\r\nProducts used:\r\nBlack pepper powder\r\nGarlic powder\r\nChili powder', NULL, NULL, 'chef', NULL, 'testimonials/1747967084_Cooking Demo Informa (Chef aziz).webp'),
	(2, 'nadyam5', 'Female', 'Rasa: enak, praktis bgt\r\nKualitas: oke', 'Taste: delicious, very practical\r\nQuality: okay', 'Bumbu Ayam Goreng Sachet (40g)', 'Fried Chicken Seasoning Sachet (40g)', 'customer', 'https://shopee.co.id/Bumbu-Ayam-Goreng-Pazar-(Sachet-40g)-i.1058738488.14699375704', 'testimonials/1751965191_nadyam.webp'),
	(3, 'mbak', 'Female', 'Diam elitr kasd sed...', 'Diam elitr kasd sed...', NULL, NULL, 'customer', NULL, NULL),
	(4, 'Chef Koko', 'Male', 'Event : Injourney Aviation Services (IAS) in Borobudur\r\nTime : 23 Mei 2024\r\n\r\n(Nasi Goreng Andaliman)\r\nProduct yang digunakan : \r\nBumbu Nasi Goreng \r\nBumbu Rendang padang\r\nSambal Andaliman', 'Event : Injourney Aviation Services (IAS) in Borobudur\r\nTime : May 23, 2024\r\n\r\n(Andaliman Fried Rice)\r\nProducts used :\r\nFried Rice Seasoning\r\nPadang Rendang Seasoning\r\nAndaliman Sambal', NULL, NULL, 'chef', NULL, 'testimonials/1747967106_Cooking Demo Waisak Borobudur (Chef koko).webp');

-- Dumping structure for table pazar_seasoning.pazar_why_pazar
CREATE TABLE IF NOT EXISTS `pazar_why_pazar` (
  `w_id` int NOT NULL AUTO_INCREMENT,
  `w_title_id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `w_title_en` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `w_description_id` text COLLATE utf8mb4_general_ci,
  `w_description_en` text COLLATE utf8mb4_general_ci,
  `w_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`w_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.pazar_why_pazar: ~5 rows (approximately)
INSERT INTO `pazar_why_pazar` (`w_id`, `w_title_id`, `w_title_en`, `w_description_id`, `w_description_en`, `w_image`) VALUES
	(1, 'Rempah Asli Berkualitas', 'Original Quality Spices', 'Terbuat dari rempah pilihan yang diolah dengan standar terbaik.', 'Made from selected spices processed to the best standards.', 'webs/leaf.svg'),
	(2, 'Hemat Waktu & Tenaga', 'Save Time & Energy', 'Tanpa perlu menakar dan meracik, masakan lezat siap lebih cepat.', 'Without the need to measure and mix, delicious dishes are ready faster.', 'webs/fire.svg'),
	(3, 'Cocok untuk Semua Kebutuhan', 'Suitable for All Needs', 'Dari rumahan hingga bisnis kuliner, hasil masakan tetap premium.', 'From home to culinary business, the cooking results remain premium.', 'webs/chef.svg'),
	(5, 'Terpercaya & Banyak Digemari', 'Trusted & Popular', 'Dipilih oleh ribuan pelanggan untuk menciptakan masakan istimewa.', 'Chosen by thousands of customers to create special dishes.', 'webs/medal.svg');

-- Dumping structure for table pazar_seasoning.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `tokenable_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_general_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table pazar_seasoning.personal_access_tokens: ~63 rows (approximately)
INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES
	(1, 'App\\Models\\User', 1, 'auth_token', '1bfac174faf596ca09064070ee28de6253a3d72492cc03cd457ec4c0fd3082c2', '["*"]', NULL, NULL, '2025-05-14 03:35:39', '2025-05-14 03:35:39'),
	(2, 'App\\Models\\User', 1, 'auth_token', 'e75f96d2bca0cb5b793e39068185789aec85ed0f47e866171d64a93726463c75', '["*"]', '2025-05-14 03:38:49', NULL, '2025-05-14 03:35:43', '2025-05-14 03:38:49'),
	(3, 'App\\Models\\User', 1, 'auth_token', '88ba55f7c3772f83f9ab7f9f6449b25ac4b141221c092352bcd5a4dbad1d870d', '["*"]', '2025-05-14 03:45:25', NULL, '2025-05-14 03:45:24', '2025-05-14 03:45:25'),
	(4, 'App\\Models\\User', 1, 'auth_token', '353f0b1ff12e60653cd04c04db45c41343e1d2464665814f0b3473384442babd', '["*"]', '2025-05-14 03:51:15', NULL, '2025-05-14 03:51:14', '2025-05-14 03:51:15'),
	(5, 'App\\Models\\User', 1, 'auth_token', 'bc7e1744460de911a9184984129b952d9d59b7b942f00a9af91a7f0b082c44c9', '["*"]', '2025-05-14 09:44:51', NULL, '2025-05-14 07:14:34', '2025-05-14 09:44:51'),
	(6, 'App\\Models\\User', 1, 'auth_token', '0f48f6fe50fb0e90332d48cf3b1a77d12d6a51f11f495a892d23f345858976d7', '["*"]', '2025-05-15 10:26:41', NULL, '2025-05-15 08:08:08', '2025-05-15 10:26:41'),
	(7, 'App\\Models\\User', 1, 'auth_token', '05d870d802cd6173aea3bf9b7a28d06dd11d563e7c9e9fb2302e94649b4c522c', '["*"]', '2025-05-20 02:39:08', NULL, '2025-05-20 02:03:59', '2025-05-20 02:39:08'),
	(8, 'App\\Models\\User', 1, 'auth_token', '83fa99a2cd0cb02495563d702efc7f140996efdee3742ea333cb5a0f3949fa54', '["*"]', '2025-05-20 04:12:43', NULL, '2025-05-20 03:55:06', '2025-05-20 04:12:43'),
	(9, 'App\\Models\\User', 1, 'auth_token', 'ef86b1848f53dc9fdd540fdb8dc4e7521ae0dbd737731304ee90d3a6af1de367', '["*"]', '2025-05-20 09:12:15', NULL, '2025-05-20 06:33:11', '2025-05-20 09:12:15'),
	(10, 'App\\Models\\User', 1, 'auth_token', '9dd18d206311da42d1ebb17ade38769030a31acfd93032ce21681a1a7a3c3e64', '["*"]', NULL, NULL, '2025-05-22 07:14:44', '2025-05-22 07:14:44'),
	(11, 'App\\Models\\User', 1, 'auth_token', '810460f895db3129eec0781d449042c1f8df6e411c518f127f0b1820fc7ab991', '["*"]', NULL, NULL, '2025-05-22 07:14:45', '2025-05-22 07:14:45'),
	(12, 'App\\Models\\User', 1, 'auth_token', '827212d291e50b6c57b4c4cce17cf86fa80de260f1160e2cf558dd68e54420aa', '["*"]', NULL, NULL, '2025-05-22 07:14:47', '2025-05-22 07:14:47'),
	(13, 'App\\Models\\User', 1, 'auth_token', '1bd07b98914849668be45d9495843da11cf90fc282614e985005c385f50aaaed', '["*"]', '2025-05-22 07:19:29', NULL, '2025-05-22 07:14:48', '2025-05-22 07:19:29'),
	(14, 'App\\Models\\User', 1, 'auth_token', '544d544f071d77778e086dd94432707e788434c7bf21b0bed836023fddf6e8d2', '["*"]', '2025-05-23 05:33:11', NULL, '2025-05-23 01:40:23', '2025-05-23 05:33:11'),
	(15, 'App\\Models\\User', 1, 'auth_token', 'a6fe3cf987eece4edf733c0c280f0f99db8477fb35b4998a3cedbf3291a89503', '["*"]', '2025-05-23 09:49:44', NULL, '2025-05-23 07:37:03', '2025-05-23 09:49:44'),
	(16, 'App\\Models\\User', 1, 'auth_token', 'ae7fe7ec138ba96b025376d976d3cd4a3b828722be69a391a6df146610b7cb42', '["*"]', '2025-05-26 03:38:14', NULL, '2025-05-26 03:26:52', '2025-05-26 03:38:14'),
	(17, 'App\\Models\\User', 1, 'auth_token', '4e2d093341093a1c1b8e48e74f0b6caae64cd3609a20d072259e49540e4f9060', '["*"]', '2025-05-26 04:41:12', NULL, '2025-05-26 04:39:27', '2025-05-26 04:41:12'),
	(18, 'App\\Models\\User', 1, 'auth_token', 'b0c9b08d1b36499e8ae52c50544a330bb3efac5e4fbd1bfbd95ecac4c9eeb6c6', '["*"]', '2025-05-26 05:00:40', NULL, '2025-05-26 04:50:53', '2025-05-26 05:00:40'),
	(19, 'App\\Models\\User', 1, 'auth_token', '50aab42bc1c5402501d7f1b2dd712c6c99de8f3fe4e14d47158901d40c3e6c22', '["*"]', '2025-05-27 02:26:56', NULL, '2025-05-27 01:21:17', '2025-05-27 02:26:56'),
	(21, 'App\\Models\\User', 1, 'auth_token', '9eb216edc13e5bb7c0f23954f9701d0531346d0ca843e6269a58baea6140b1d6', '["*"]', '2025-06-09 07:49:29', NULL, '2025-06-09 07:49:28', '2025-06-09 07:49:29'),
	(22, 'App\\Models\\User', 1, 'auth_token', '02d934630ae3a1d161353f3a5bd0131bb458dc11a00d45730a8d736aa5524723', '["*"]', '2025-06-11 09:49:01', NULL, '2025-06-11 06:42:25', '2025-06-11 09:49:01'),
	(23, 'App\\Models\\User', 1, 'auth_token', '0cc6ff8524a4ed19b43b6b0195fbbd7547ca43761e74c9474a25deeef09a31d9', '["*"]', '2025-06-12 03:14:21', NULL, '2025-06-12 03:12:06', '2025-06-12 03:14:21'),
	(24, 'App\\Models\\User', 1, 'auth_token', 'f8582ae6cfefd9d816a40b7d92ebe3cf1c81049dd5c294b53581bca9ec0a4913', '["*"]', '2025-06-12 10:09:40', NULL, '2025-06-12 03:15:10', '2025-06-12 10:09:40'),
	(25, 'App\\Models\\User', 1, 'auth_token', 'ba43b39a4ac54f65dff04b59abf5b928077674f5648783ddc28c775b8df25abb', '["*"]', '2025-06-13 02:39:00', NULL, '2025-06-13 01:16:11', '2025-06-13 02:39:00'),
	(26, 'App\\Models\\User', 1, 'auth_token', '1e6fcbafd030c8e3eea502a37ecceeec9a9ba6f572400024da0f46ccb6b9b03b', '["*"]', '2025-06-13 09:41:10', NULL, '2025-06-13 09:41:03', '2025-06-13 09:41:10'),
	(28, 'App\\Models\\User', 8, 'auth_token', 'da32a66defc903fab0145173d608f01958374a45f26f4a351bf8c366829e45e8', '["*"]', NULL, NULL, '2025-06-19 03:44:56', '2025-06-19 03:44:56'),
	(29, 'App\\Models\\User', 8, 'auth_token', '5690233e01b3df460554164ba4ccc7796b45ba7612ffaeb292000a3e0f93ed7a', '["*"]', NULL, NULL, '2025-06-19 03:45:21', '2025-06-19 03:45:21'),
	(32, 'App\\Models\\User', 8, 'auth_token', 'bb6ac0c94483f924e9775b6c41f9e13e9f4b479dda16cb6a29981eb3b99d5a18', '["*"]', '2025-06-19 03:57:36', NULL, '2025-06-19 03:56:48', '2025-06-19 03:57:36'),
	(35, 'App\\Models\\User', 1, 'auth_token', '77193bd2de1f9dacea8bdf07b9cc67cc5b9878b44919447d82253e5bb2915a3c', '["*"]', '2025-06-19 06:40:49', NULL, '2025-06-19 06:39:41', '2025-06-19 06:40:49'),
	(36, 'App\\Models\\User', 1, 'auth_token', 'e5ea819deea9f21011175a837923081afe52cb676472863290e55e87045e1656', '["*"]', '2025-06-19 06:45:35', NULL, '2025-06-19 06:43:55', '2025-06-19 06:45:35'),
	(37, 'App\\Models\\User', 1, 'auth_token', '3d71c6bb71755fdd32f3308b3ce709fda22bfd86b5f9b5bbc4cc2db9f30d178b', '["*"]', '2025-06-19 07:28:30', NULL, '2025-06-19 06:46:41', '2025-06-19 07:28:30'),
	(42, 'App\\Models\\User', 1, 'auth_token', '1d766d504962e28d53cc28731f0c6e95a339fd5482196a987870de24a0e8ff41', '["*"]', '2025-06-20 03:38:23', NULL, '2025-06-20 03:04:31', '2025-06-20 03:38:23'),
	(44, 'App\\Models\\User', 1, 'auth_token', '226923549fb7f05cb4d666c8d61043f5a6022fcde7173d31fbefc11439c9c041', '["*"]', '2025-06-20 09:08:21', NULL, '2025-06-20 09:08:20', '2025-06-20 09:08:21'),
	(47, 'App\\Models\\User', 6, 'auth_token', '09f24995aa1e7cd265525b4003fb247bc0584d811ea3ecccbf02194081aa69e0', '["*"]', '2025-06-23 03:48:59', NULL, '2025-06-23 03:45:26', '2025-06-23 03:48:59'),
	(48, 'App\\Models\\User', 1, 'auth_token', 'c71c01d4f0dc376f374a6e1998bdbfe7bf63186c12ff2818dd501507932855cd', '["*"]', '2025-06-23 09:35:49', NULL, '2025-06-23 07:52:14', '2025-06-23 09:35:49'),
	(49, 'App\\Models\\User', 1, 'auth_token', 'dd48755cf63a551ddc535a4a7de860fc3a69d5e79aeca8fa082d39076a360db3', '["*"]', '2025-06-24 03:52:59', NULL, '2025-06-24 03:52:42', '2025-06-24 03:52:59'),
	(50, 'App\\Models\\User', 8, 'auth_token', '7a497f630e5f478db3fe11d7b814b27b40b2d4e685317835141ed8fb8718f432', '["*"]', '2025-06-24 03:53:47', NULL, '2025-06-24 03:53:12', '2025-06-24 03:53:47'),
	(51, 'App\\Models\\User', 1, 'auth_token', 'fc8c00a3820680fe12e8dd720b2c7ab58e579fb07c736d37be4652f045b10ed5', '["*"]', '2025-06-24 03:54:11', NULL, '2025-06-24 03:54:00', '2025-06-24 03:54:11'),
	(52, 'App\\Models\\User', 8, 'auth_token', 'c5b915cdc94c8f6f41c3fc5d8f5fc0cc41ff73782e571d16b58e9a564fcce23a', '["*"]', '2025-06-24 03:58:10', NULL, '2025-06-24 03:58:04', '2025-06-24 03:58:10'),
	(53, 'App\\Models\\User', 1, 'auth_token', 'cd285c01d6f6b8e128ce5733d22622dddb03e90919f588cd8ae782a36d1ca667', '["*"]', '2025-06-24 04:20:26', NULL, '2025-06-24 04:05:34', '2025-06-24 04:20:26'),
	(59, 'App\\Models\\User', 8, 'auth_token', 'eefc7310f0df3d488ca716d270f03f989f55c2bacdbcfe954cc5cac2ba0b47a5', '["*"]', '2025-06-30 03:23:17', NULL, '2025-06-30 02:47:33', '2025-06-30 03:23:17'),
	(62, 'App\\Models\\User', 1, 'auth_token', '7b2c3d00fa9c337501e387a4b609d327367d13996a656d86107c4a83fe3a1b02', '["*"]', '2025-06-30 03:53:43', NULL, '2025-06-30 03:53:42', '2025-06-30 03:53:43'),
	(63, 'App\\Models\\User', 1, 'auth_token', 'e4c3d3ef1eee4f6ae55b84c036bd0d9278526cb4556ef22817e1102acdb6c5fb', '["*"]', NULL, NULL, '2025-06-30 04:31:35', '2025-06-30 04:31:35'),
	(64, 'App\\Models\\User', 1, 'auth_token', '3663b879de92e81543381bcf98bb542a13dcf86570b9d9cecc512c51f6878c5a', '["*"]', NULL, NULL, '2025-06-30 04:32:36', '2025-06-30 04:32:36'),
	(66, 'App\\Models\\User', 8, 'auth_token', 'e2175c67f85e225656eb0e99826c9fc4ac491b93131892004bc0b9642d1783de', '["*"]', '2025-06-30 04:36:42', NULL, '2025-06-30 04:36:41', '2025-06-30 04:36:42'),
	(67, 'App\\Models\\User', 6, 'auth_token', '4092d768c3663dceea9a5282dea4512c3c1412b768b547d7b56bb144efed9b2a', '["*"]', '2025-06-30 04:36:57', NULL, '2025-06-30 04:36:56', '2025-06-30 04:36:57'),
	(68, 'App\\Models\\User', 8, 'auth_token', '93258452ad4a5e5274f788a947415e834d716636119ff1d0eb0dfe25b421a27f', '["*"]', '2025-06-30 04:46:32', NULL, '2025-06-30 04:46:31', '2025-06-30 04:46:32'),
	(69, 'App\\Models\\User', 8, 'auth_token', '9e7ae08e381e84e7675e312c8c0402f66cb30ab3fd6d4aa39270d3c02d1ab461', '["*"]', '2025-06-30 04:48:22', NULL, '2025-06-30 04:48:21', '2025-06-30 04:48:22'),
	(82, 'App\\Models\\User', 1, 'auth_token', '70dae0525a7bbb16891729dca6d8dda32a508d44a49dc7db14ae4e6902400936', '["*"]', '2025-07-01 09:00:43', NULL, '2025-07-01 09:00:41', '2025-07-01 09:00:43'),
	(83, 'App\\Models\\User', 1, 'auth_token', 'd489ffd0ccec16d8bac74564cb63c9baeb0b23dbe2dd0743f9ba9d26c5239df1', '["*"]', '2025-07-01 09:15:32', NULL, '2025-07-01 09:09:34', '2025-07-01 09:15:32'),
	(85, 'App\\Models\\User', 1, 'auth_token', '73fe4208e8387030265b96a7a7802a8240a0605435c2f675e9c374ee69efc8c4', '["*"]', '2025-07-02 03:44:33', NULL, '2025-07-02 03:34:30', '2025-07-02 03:44:33'),
	(86, 'App\\Models\\User', 1, 'auth_token', 'c7f0f47267acdd2fb6291adb4fad3338d04a3dbd9982787508fc3a18c8a09049', '["*"]', '2025-07-03 07:22:20', NULL, '2025-07-03 07:12:36', '2025-07-03 07:22:20'),
	(87, 'App\\Models\\User', 1, 'auth_token', '9f45d181e49b840ba0e65cc0dcd2a2a44d2cfd11cead8387d470de08353bfc08', '["*"]', '2025-07-03 08:22:28', NULL, '2025-07-03 08:16:27', '2025-07-03 08:22:28'),
	(88, 'App\\Models\\User', 1, 'auth_token', 'f4f729066d5b2263320b95848aa36189de3847d5a5c30ccf1c9b601691082d26', '["*"]', '2025-07-03 08:26:51', NULL, '2025-07-03 08:17:43', '2025-07-03 08:26:51'),
	(89, 'App\\Models\\User', 1, 'auth_token', 'bd23b0fbbafba17bb3871f9dad8e818680f681f8ff41f808c199c0b47cde231f', '["*"]', '2025-07-04 01:50:46', NULL, '2025-07-04 01:23:24', '2025-07-04 01:50:46'),
	(90, 'App\\Models\\User', 1, 'auth_token', '560a97436c7ad9bd522f6c5b57a2c7369720eeca16ada9105486f4728bab8913', '["*"]', '2025-07-04 09:10:01', NULL, '2025-07-04 06:34:05', '2025-07-04 09:10:01'),
	(91, 'App\\Models\\User', 1, 'auth_token', 'a7127c54fd3228e4910789917ddc13e92d7246f8593e2c25fe69ee456c2e7ca1', '["*"]', '2025-07-04 06:45:29', NULL, '2025-07-04 06:45:28', '2025-07-04 06:45:29'),
	(92, 'App\\Models\\User', 1, 'auth_token', 'be5d84951177d8a442b228179cccfa59edd5a1de7d293c884c418b1c8b97c04c', '["*"]', '2025-07-04 08:44:28', NULL, '2025-07-04 08:32:23', '2025-07-04 08:44:28'),
	(93, 'App\\Models\\User', 1, 'auth_token', '2aa159044798460ed37e269d2cb4599ec3e5526f6126fe7bb335b4e21d3cd508', '["*"]', '2025-07-08 09:05:48', NULL, '2025-07-08 07:32:02', '2025-07-08 09:05:48'),
	(94, 'App\\Models\\User', 1, 'auth_token', '606a2e108b8f1d351767e1a810b63e89e01402dd2c1d4e596718a7e8c78afed0', '["*"]', '2025-07-09 06:07:41', NULL, '2025-07-09 04:20:28', '2025-07-09 06:07:41'),
	(95, 'App\\Models\\User', 1, 'auth_token', '3c2296cc56fbcda0fa88d5722f14cb93545cb04226c4a141fd391bc0e7de2608', '["*"]', '2025-07-10 01:39:33', NULL, '2025-07-10 01:33:51', '2025-07-10 01:39:33'),
	(97, 'App\\Models\\User', 1, 'auth_token', '668e8b095465ced3d6d4dbce0597901c6ac1a1c599ef50dccaf9b8ca040ca117', '["*"]', '2025-07-10 09:43:00', NULL, '2025-07-10 09:13:20', '2025-07-10 09:43:00'),
	(105, 'App\\Models\\User', 1, 'auth_token', '3ef82862c470d7f0dac2f3ac86c29c83f411028f353ecf7b8f8631fc4cd63f2f', '["*"]', '2025-07-14 03:47:14', NULL, '2025-07-14 01:27:31', '2025-07-14 03:47:14'),
	(106, 'App\\Models\\User', 1, 'auth_token', 'ad9e5f2f9041173669be455b45877d15ea48be789f20b9e428adbb086794c03e', '["*"]', '2025-07-14 09:52:04', NULL, '2025-07-14 09:52:03', '2025-07-14 09:52:04');

-- Dumping structure for table pazar_seasoning.sessions
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pazar_seasoning.sessions: ~2 rows (approximately)
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('fqJKNEigeI9IgGCi7hwt0u8S4fG3EXmMmdcRc3uh', NULL, '10.27.9.188', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYUVDUzc1c0Fwa0xkbkpJdFpDNU8zVDhNVEJxb1YzNnREOXI0Nlk2SSI7czo2OiJsb2NhbGUiO3M6MjoiaWQiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM3OiJodHRwOi8vMTAuMjcuOS4xODg6ODAwMy9pZC9icmFuZC1rYW1pIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1752715472),
	('hsucnoEP4oeLLgucdhruycTwuFYSM4l5WnT8C1mi', NULL, '10.27.9.188', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZWhHcDFoY3ZuaTZXczNlZ0hjaUduc2JXSkRWYUlHUk5GS0hjQ3c0biI7czo2OiJsb2NhbGUiO3M6MjoiaWQiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM3OiJodHRwOi8vMTAuMjcuOS4xODg6ODAwMy9pZC9icmFuZC1rYW1pIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1752566745);

-- Dumping structure for table pazar_seasoning.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pazar_seasoning.users: ~0 rows (approximately)

-- Dumping structure for trigger pazar_seasoning.before_insert_users
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
DELIMITER //
CREATE TRIGGER `before_insert_users` BEFORE INSERT ON `login_users` FOR EACH ROW BEGIN
  IF NEW.u_uid IS NULL THEN
    SET NEW.u_uid = UUID();
  END IF;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;

-- Single-domain CI migration default accounts
INSERT INTO `login_roles` (`role_id`,`role_name`,`role_level`,`role_is_active`,`role_created_by`) VALUES
(99,'Super Admin',1,1,'SYSTEM'),(100,'Sosmed Admin',2,1,'SYSTEM')
ON DUPLICATE KEY UPDATE role_name=VALUES(role_name), role_level=VALUES(role_level), role_is_active=VALUES(role_is_active);

INSERT INTO `login_users` (`u_employee_id`,`u_name`,`u_email`,`u_password`,`u_join_date`,`u_is_active`,`u_created_by`) VALUES
('ADM001','Administrator','admin@pazarseasonings.com','$2y$12$ZHtM.Y68xaRaulGSMBbQz.ycly.PjsSD3De7lbwocD3XZGyqcnb3C',CURDATE(),1,'SYSTEM'),
('SOS001','Sosmed Admin','sosmed@pazarseasonings.com','$2y$12$ZHtM.Y68xaRaulGSMBbQz.ycly.PjsSD3De7lbwocD3XZGyqcnb3C',CURDATE(),1,'SYSTEM')
ON DUPLICATE KEY UPDATE u_password=VALUES(u_password), u_is_active=1;


-- Pastikan password akun utama sesuai README (123456)
UPDATE `login_users` SET `u_password`='$2y$12$ZHtM.Y68xaRaulGSMBbQz.ycly.PjsSD3De7lbwocD3XZGyqcnb3C', `u_is_active`=1 WHERE `u_email` IN ('admin@pazarseasonings.com','sosmed@pazarseasonings.com');


-- V16 Admin Matured + Blog Tables
CREATE TABLE IF NOT EXISTS `pazar_blog_category` (
  `bc_id` int(11) NOT NULL AUTO_INCREMENT,
  `bc_title_id` varchar(190) NOT NULL,
  `bc_title_en` varchar(190) DEFAULT NULL,
  `bc_slug_id` varchar(220) DEFAULT NULL,
  `bc_slug_en` varchar(220) DEFAULT NULL,
  `bc_description_id` text DEFAULT NULL,
  `bc_description_en` text DEFAULT NULL,
  `bc_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `bc_created_at` datetime DEFAULT NULL,
  `bc_updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`bc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_blog` (
  `b_id` int(11) NOT NULL AUTO_INCREMENT,
  `b_title_id` varchar(220) NOT NULL,
  `b_title_en` varchar(220) DEFAULT NULL,
  `b_slug_id` varchar(240) DEFAULT NULL,
  `b_slug_en` varchar(240) DEFAULT NULL,
  `b_excerpt_id` text DEFAULT NULL,
  `b_excerpt_en` text DEFAULT NULL,
  `b_content_id` longtext DEFAULT NULL,
  `b_content_en` longtext DEFAULT NULL,
  `b_image` varchar(255) DEFAULT NULL,
  `b_category_id` int(11) DEFAULT NULL,
  `b_status` varchar(30) NOT NULL DEFAULT 'published',
  `b_is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `b_publish_at` datetime DEFAULT NULL,
  `b_meta_title_id` varchar(220) DEFAULT NULL,
  `b_meta_title_en` varchar(220) DEFAULT NULL,
  `b_meta_description_id` text DEFAULT NULL,
  `b_meta_description_en` text DEFAULT NULL,
  `b_focus_keyword_id` varchar(190) DEFAULT NULL,
  `b_focus_keyword_en` varchar(190) DEFAULT NULL,
  `b_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `b_created_by` varchar(120) DEFAULT NULL,
  `b_updated_by` varchar(120) DEFAULT NULL,
  `b_created_at` datetime DEFAULT NULL,
  `b_updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`b_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_blog_comment` (
  `bcmt_id` int(11) NOT NULL AUTO_INCREMENT,
  `bcmt_blog_id` int(11) NOT NULL,
  `bcmt_name` varchar(160) NOT NULL,
  `bcmt_email` varchar(190) DEFAULT NULL,
  `bcmt_message` text NOT NULL,
  `bcmt_status` varchar(30) NOT NULL DEFAULT 'pending',
  `bcmt_created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`bcmt_id`),
  KEY `bcmt_blog_id` (`bcmt_blog_id`),
  KEY `bcmt_status` (`bcmt_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_media_library` (
  `m_id` int(11) NOT NULL AUTO_INCREMENT,
  `m_title` varchar(220) DEFAULT NULL,
  `m_file` varchar(255) NOT NULL,
  `m_alt_id` varchar(220) DEFAULT NULL,
  `m_alt_en` varchar(220) DEFAULT NULL,
  `m_caption_id` text DEFAULT NULL,
  `m_caption_en` text DEFAULT NULL,
  `m_mime` varchar(100) DEFAULT NULL,
  `m_size` int(11) DEFAULT 0,
  `m_width` int(11) DEFAULT 0,
  `m_height` int(11) DEFAULT 0,
  `m_used_for` varchar(120) DEFAULT NULL,
  `m_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `m_created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`m_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_frontend_menu` (
  `fm_id` int(11) NOT NULL AUTO_INCREMENT,
  `fm_title_id` varchar(160) NOT NULL,
  `fm_title_en` varchar(160) DEFAULT NULL,
  `fm_url_id` varchar(255) DEFAULT NULL,
  `fm_url_en` varchar(255) DEFAULT NULL,
  `fm_parent_id` int(11) DEFAULT NULL,
  `fm_sort_order` int(11) NOT NULL DEFAULT 0,
  `fm_target` varchar(20) DEFAULT '_self',
  `fm_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `fm_created_at` datetime DEFAULT NULL,
  `fm_updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`fm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_page_blocks` (
  `pb_id` int(11) NOT NULL AUTO_INCREMENT,
  `pb_page` varchar(80) NOT NULL,
  `pb_type` varchar(60) NOT NULL DEFAULT 'text_image',
  `pb_title_id` varchar(220) DEFAULT NULL,
  `pb_title_en` varchar(220) DEFAULT NULL,
  `pb_content_id` longtext DEFAULT NULL,
  `pb_content_en` longtext DEFAULT NULL,
  `pb_image` varchar(255) DEFAULT NULL,
  `pb_button_text_id` varchar(160) DEFAULT NULL,
  `pb_button_text_en` varchar(160) DEFAULT NULL,
  `pb_button_url` varchar(255) DEFAULT NULL,
  `pb_sort_order` int(11) NOT NULL DEFAULT 0,
  `pb_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `pb_created_at` datetime DEFAULT NULL,
  `pb_updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`pb_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_content_revisions` (
  `cr_id` int(11) NOT NULL AUTO_INCREMENT,
  `cr_table` varchar(120) NOT NULL,
  `cr_record_id` varchar(80) NOT NULL,
  `cr_action` varchar(40) NOT NULL,
  `cr_snapshot` longtext DEFAULT NULL,
  `cr_user` varchar(160) DEFAULT NULL,
  `cr_created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`cr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_seo_global` (
  `sg_id` int(11) NOT NULL AUTO_INCREMENT,
  `sg_key` varchar(120) NOT NULL,
  `sg_value_id` text DEFAULT NULL,
  `sg_value_en` text DEFAULT NULL,
  `sg_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sg_updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sg_id`),
  UNIQUE KEY `sg_key` (`sg_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `pazar_admin_notifications` (
  `an_id` int(11) NOT NULL AUTO_INCREMENT,
  `an_title` varchar(220) NOT NULL,
  `an_message` text DEFAULT NULL,
  `an_type` varchar(50) DEFAULT 'info',
  `an_is_read` tinyint(1) NOT NULL DEFAULT 0,
  `an_created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`an_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `pazar_blog_category` (`bc_title_id`,`bc_title_en`,`bc_slug_id`,`bc_slug_en`,`bc_description_id`,`bc_description_en`,`bc_is_active`,`bc_created_at`)
SELECT 'Tips Masak','Cooking Tips','tips-masak','cooking-tips','Tips dan inspirasi memasak bersama Pazar Seasonings.','Cooking tips and inspiration with Pazar Seasonings.',1,NOW()
WHERE NOT EXISTS (SELECT 1 FROM `pazar_blog_category` LIMIT 1);

INSERT INTO `pazar_blog` (`b_title_id`,`b_title_en`,`b_slug_id`,`b_slug_en`,`b_excerpt_id`,`b_excerpt_en`,`b_content_id`,`b_content_en`,`b_category_id`,`b_status`,`b_is_active`,`b_created_at`)
SELECT 'Cara Membuat Masakan Lebih Praktis dengan Bumbu Siap Pakai','How to Make Cooking Easier with Ready-to-Use Seasonings','cara-membuat-masakan-lebih-praktis','make-cooking-easier-with-ready-to-use-seasonings','Inspirasi sederhana agar proses memasak lebih cepat, konsisten, dan tetap lezat.','Simple inspiration to make cooking faster, more consistent, and still delicious.','<p>Bumbu siap pakai membantu proses memasak menjadi lebih cepat tanpa mengurangi cita rasa. Dengan takaran yang konsisten, hasil masakan lebih mudah dijaga.</p>','<p>Ready-to-use seasonings help make cooking faster without compromising flavor. With consistent measurements, your dishes are easier to perfect.</p>',1,'published',1,NOW()
WHERE NOT EXISTS (SELECT 1 FROM `pazar_blog` LIMIT 1);
