-- ============================================================
-- CV Cloud Point Indonesia - Database Schema + Seed Data
-- MySQL Import File
-- ============================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- -----------------------------------------------------------
-- Table: users
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` VARCHAR(191) NOT NULL,
  `name` VARCHAR(191) NOT NULL,
  `email` VARCHAR(191) NOT NULL,
  `password_hash` VARCHAR(191) NOT NULL,
  `role` VARCHAR(191) NOT NULL DEFAULT 'editor',
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_key` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: services
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `services`;
CREATE TABLE `services` (
  `id` VARCHAR(191) NOT NULL,
  `slug_id` VARCHAR(191) NOT NULL,
  `slug_en` VARCHAR(191) NOT NULL,
  `name_id` VARCHAR(191) NOT NULL,
  `name_en` VARCHAR(191) NOT NULL,
  `description_id` TEXT NOT NULL,
  `description_en` TEXT NOT NULL,
  `benefits_id` TEXT DEFAULT NULL,
  `benefits_en` TEXT DEFAULT NULL,
  `icon` VARCHAR(191) DEFAULT NULL,
  `image` VARCHAR(500) DEFAULT NULL,
  `order_index` INT NOT NULL DEFAULT 0,
  `is_active` BOOLEAN NOT NULL DEFAULT true,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `services_slug_id_key` (`slug_id`),
  UNIQUE KEY `services_slug_en_key` (`slug_en`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: portofolios
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `portofolios`;
CREATE TABLE `portofolios` (
  `id` VARCHAR(191) NOT NULL,
  `slug_id` VARCHAR(191) NOT NULL,
  `slug_en` VARCHAR(191) NOT NULL,
  `title_id` VARCHAR(191) NOT NULL,
  `title_en` VARCHAR(191) NOT NULL,
  `client_name` VARCHAR(191) DEFAULT NULL,
  `description_id` TEXT DEFAULT NULL,
  `description_en` TEXT DEFAULT NULL,
  `images` TEXT DEFAULT NULL,
  `category` VARCHAR(191) DEFAULT NULL,
  `year` INT DEFAULT NULL,
  `link` VARCHAR(500) DEFAULT NULL,
  `is_featured` BOOLEAN NOT NULL DEFAULT false,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `portofolios_slug_id_key` (`slug_id`),
  UNIQUE KEY `portofolios_slug_en_key` (`slug_en`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: testimonials
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `testimonials`;
CREATE TABLE `testimonials` (
  `id` VARCHAR(191) NOT NULL,
  `client_name` VARCHAR(191) NOT NULL,
  `company` VARCHAR(191) DEFAULT NULL,
  `photo` VARCHAR(500) DEFAULT NULL,
  `content_id` TEXT NOT NULL,
  `content_en` TEXT NOT NULL,
  `rating` INT NOT NULL DEFAULT 5,
  `is_active` BOOLEAN NOT NULL DEFAULT true,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: clients
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
  `id` VARCHAR(191) NOT NULL,
  `name` VARCHAR(191) NOT NULL,
  `logo` VARCHAR(500) NOT NULL,
  `website_url` VARCHAR(500) DEFAULT NULL,
  `is_active` BOOLEAN NOT NULL DEFAULT true,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: site_settings
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `site_settings`;
CREATE TABLE `site_settings` (
  `id` VARCHAR(191) NOT NULL,
  `key` VARCHAR(191) NOT NULL,
  `value` TEXT DEFAULT NULL,
  `type` VARCHAR(191) NOT NULL DEFAULT 'text',
  `group_name` VARCHAR(191) DEFAULT NULL,
  `updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `site_settings_key_key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: pages
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` VARCHAR(191) NOT NULL,
  `slug_id` VARCHAR(191) NOT NULL,
  `slug_en` VARCHAR(191) NOT NULL,
  `title_id` VARCHAR(191) NOT NULL,
  `title_en` VARCHAR(191) NOT NULL,
  `content_id` LONGTEXT DEFAULT NULL,
  `content_en` LONGTEXT DEFAULT NULL,
  `meta_title_id` VARCHAR(191) DEFAULT NULL,
  `meta_title_en` VARCHAR(191) DEFAULT NULL,
  `meta_description_id` TEXT DEFAULT NULL,
  `meta_description_en` TEXT DEFAULT NULL,
  `is_published` BOOLEAN NOT NULL DEFAULT true,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `pages_slug_id_key` (`slug_id`),
  UNIQUE KEY `pages_slug_en_key` (`slug_en`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: blog_categories
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `blog_categories`;
CREATE TABLE `blog_categories` (
  `id` VARCHAR(191) NOT NULL,
  `slug_id` VARCHAR(191) NOT NULL,
  `slug_en` VARCHAR(191) NOT NULL,
  `name_id` VARCHAR(191) NOT NULL,
  `name_en` VARCHAR(191) NOT NULL,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `blog_categories_slug_id_key` (`slug_id`),
  UNIQUE KEY `blog_categories_slug_en_key` (`slug_en`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: blog_tags
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `blog_tags`;
CREATE TABLE `blog_tags` (
  `id` VARCHAR(191) NOT NULL,
  `slug_id` VARCHAR(191) NOT NULL,
  `slug_en` VARCHAR(191) NOT NULL,
  `name_id` VARCHAR(191) NOT NULL,
  `name_en` VARCHAR(191) NOT NULL,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `blog_tags_slug_id_key` (`slug_id`),
  UNIQUE KEY `blog_tags_slug_en_key` (`slug_en`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: blog_posts
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `blog_posts`;
CREATE TABLE `blog_posts` (
  `id` VARCHAR(191) NOT NULL,
  `slug_id` VARCHAR(191) NOT NULL,
  `slug_en` VARCHAR(191) NOT NULL,
  `title_id` VARCHAR(191) NOT NULL,
  `title_en` VARCHAR(191) NOT NULL,
  `excerpt_id` TEXT DEFAULT NULL,
  `excerpt_en` TEXT DEFAULT NULL,
  `content_id` LONGTEXT DEFAULT NULL,
  `content_en` LONGTEXT DEFAULT NULL,
  `featured_image` VARCHAR(500) DEFAULT NULL,
  `author_id` VARCHAR(191) DEFAULT NULL,
  `category_id` VARCHAR(191) DEFAULT NULL,
  `tags` TEXT DEFAULT NULL,
  `is_published` BOOLEAN NOT NULL DEFAULT false,
  `published_at` DATETIME(3) DEFAULT NULL,
  `meta_title_id` VARCHAR(191) DEFAULT NULL,
  `meta_title_en` VARCHAR(191) DEFAULT NULL,
  `meta_description_id` TEXT DEFAULT NULL,
  `meta_description_en` TEXT DEFAULT NULL,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `blog_posts_slug_id_key` (`slug_id`),
  UNIQUE KEY `blog_posts_slug_en_key` (`slug_en`),
  KEY `blog_posts_author_id_fkey` (`author_id`),
  KEY `blog_posts_category_id_fkey` (`category_id`),
  CONSTRAINT `blog_posts_author_id_fkey` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `blog_posts_category_id_fkey` FOREIGN KEY (`category_id`) REFERENCES `blog_categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: blog_post_tags
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `blog_post_tags`;
CREATE TABLE `blog_post_tags` (
  `post_id` VARCHAR(191) NOT NULL,
  `tag_id` VARCHAR(191) NOT NULL,
  PRIMARY KEY (`post_id`, `tag_id`),
  KEY `blog_post_tags_tag_id_fkey` (`tag_id`),
  CONSTRAINT `blog_post_tags_post_id_fkey` FOREIGN KEY (`post_id`) REFERENCES `blog_posts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `blog_post_tags_tag_id_fkey` FOREIGN KEY (`tag_id`) REFERENCES `blog_tags` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: leads
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `leads`;
CREATE TABLE `leads` (
  `id` VARCHAR(191) NOT NULL,
  `name` VARCHAR(191) NOT NULL,
  `email` VARCHAR(191) NOT NULL,
  `phone` VARCHAR(191) DEFAULT NULL,
  `company` VARCHAR(191) DEFAULT NULL,
  `service_interest` VARCHAR(191) DEFAULT NULL,
  `message` TEXT DEFAULT NULL,
  `source` VARCHAR(191) NOT NULL DEFAULT 'contact_form',
  `status` VARCHAR(191) NOT NULL DEFAULT 'new',
  `notes` TEXT DEFAULT NULL,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- -----------------------------------------------------------
-- Table: media
-- -----------------------------------------------------------
DROP TABLE IF EXISTS `media`;
CREATE TABLE `media` (
  `id` VARCHAR(191) NOT NULL,
  `filename` VARCHAR(500) NOT NULL,
  `original_name` VARCHAR(500) NOT NULL,
  `mime_type` VARCHAR(191) NOT NULL,
  `size` INT NOT NULL,
  `path` VARCHAR(500) NOT NULL,
  `alt_text` VARCHAR(191) DEFAULT NULL,
  `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ============================================================
-- SEED DATA
-- ============================================================

-- -----------------------------------------------------------
-- Admin User (password: admin123)
-- -----------------------------------------------------------
INSERT INTO `users` (`id`, `name`, `email`, `password_hash`, `role`, `created_at`, `updated_at`)
VALUES
('cmf7a1b2c3d4e5f6a7b8c9d0', 'Admin', 'admin@cloudpoint.co.id', '$2b$10$h3vNmcPFi8I2IJ4KZyYzgOteDEwxnUHriV9h6lX.T0JsbDrF6cNdm', 'admin', NOW(3), NOW(3));

-- -----------------------------------------------------------
-- Services
-- -----------------------------------------------------------
INSERT INTO `services` (`id`, `slug_id`, `slug_en`, `name_id`, `name_en`, `description_id`, `description_en`, `benefits_id`, `benefits_en`, `icon`, `image`, `order_index`, `is_active`, `created_at`, `updated_at`)
VALUES
('svc001', 'google-workspace', 'google-workspace', 'Google Workspace', 'Google Workspace', 'Jual beli lisensi Google Workspace resmi untuk bisnis Anda. Dapatkan akses ke Gmail, Google Drive, Google Meet, dan layanan Google lainnya.', 'Official Google Workspace license reseller for your business. Get access to Gmail, Google Drive, Google Meet, and other Google services.', '["Akun email profesional","Penyimpanan cloud","Video meeting","Kolaborasi real-time"]', '["Professional email","Cloud storage","Video meetings","Real-time collaboration"]', NULL, NULL, 1, 1, NOW(3), NOW(3)),
('svc002', 'pembuatan-website', 'website-development', 'Pembuatan Website', 'Website Development', 'Jasa pembuatan website profesional untuk company profile, e-commerce, dan kebutuhan bisnis lainnya.', 'Professional website development services for company profile, e-commerce, and other business needs.', '["Desain modern","Responsif","SEO friendly","Loading cepat"]', '["Modern design","Responsive","SEO friendly","Fast loading"]', NULL, NULL, 2, 1, NOW(3), NOW(3)),
('svc003', 'pembuatan-aplikasi', 'app-development', 'Pembuatan Aplikasi', 'App Development', 'Pengembangan aplikasi mobile dan web yang disesuaikan dengan kebutuhan bisnis Anda.', 'Mobile and web application development tailored to your business needs.', '["Android & iOS","Web app","UI/UX profesional","Scalable"]', '["Android & iOS","Web app","Professional UI/UX","Scalable"]', NULL, NULL, 3, 1, NOW(3), NOW(3)),
('svc004', 'konsultasi-it', 'it-consulting', 'Konsultasi IT', 'IT Consulting', 'Layanan konsultasi IT untuk membantu bisnis Anda dalam transformasi digital.', 'IT consulting services to help your business with digital transformation.', '["Analisis kebutuhan","Transformasi digital","Infrastruktur","Roadmap teknologi"]', '["Needs analysis","Digital transformation","Infrastructure","Technology roadmap"]', NULL, NULL, 4, 1, NOW(3), NOW(3));

-- -----------------------------------------------------------
-- Testimonials
-- -----------------------------------------------------------
INSERT INTO `testimonials` (`id`, `client_name`, `company`, `photo`, `content_id`, `content_en`, `rating`, `is_active`, `created_at`)
VALUES
('tst001', 'Budi Santoso', 'PT Maju Jaya', NULL, 'Layanan Google Workspace dari Cloud Point sangat membantu produktivitas tim kami. Proses migrasi berjalan lancar.', 'Google Workspace service from Cloud Point greatly helped our team productivity. The migration process went smoothly.', 5, 1, NOW(3)),
('tst002', 'Siti Rahayu', 'UD Berkah', NULL, 'Website yang dibuat oleh Cloud Point sesuai dengan ekspektasi kami. Desainnya profesional dan loadingnya cepat.', 'The website created by Cloud Point met our expectations. The design is professional and loads fast.', 5, 1, NOW(3)),
('tst003', 'Ahmad Fauzi', 'CV Sukses Mandiri', NULL, 'Konsultasi IT yang diberikan sangat membantu kami dalam merencanakan transformasi digital perusahaan.', 'The IT consulting provided greatly helped us in planning our company''s digital transformation.', 5, 1, NOW(3));

-- -----------------------------------------------------------
-- Blog Categories
-- -----------------------------------------------------------
INSERT INTO `blog_categories` (`id`, `slug_id`, `slug_en`, `name_id`, `name_en`, `created_at`)
VALUES
('cat001', 'google-workspace', 'google-workspace', 'Google Workspace', 'Google Workspace', NOW(3)),
('cat002', 'tips', 'tips', 'Tips', 'Tips', NOW(3)),
('cat003', 'konsultasi-it', 'it-consulting', 'Konsultasi IT', 'IT Consulting', NOW(3)),
('cat004', 'berita', 'news', 'Berita', 'News', NOW(3));

-- -----------------------------------------------------------
-- Site Settings
-- -----------------------------------------------------------
INSERT INTO `site_settings` (`id`, `key`, `value`, `type`, `group_name`, `updated_at`)
VALUES
('set001', 'company_name', 'CV Cloud Point Indonesia', 'text', 'general', NOW(3)),
('set002', 'site_logo', '', 'text', 'general', NOW(3)),
('set003', 'company_phone', '08563372278', 'text', 'contact', NOW(3)),
('set004', 'company_email', 'info@cloudpoint.co.id', 'text', 'contact', NOW(3)),
('set005', 'company_address_id', 'Jl. Semeru CD 3 Kepuh Permai Waru, Sidoarjo, 61256 Jawa Timur - Indonesia', 'text', 'contact', NOW(3)),
('set006', 'company_address_en', 'Jl. Semeru CD 3 Kepuh Permai Waru, Sidoarjo, 61256 East Java - Indonesia', 'text', 'contact', NOW(3)),
('set007', 'whatsapp_number', '628563372278', 'text', 'contact', NOW(3)),
('set008', 'facebook_url', '', 'text', 'social', NOW(3)),
('set009', 'instagram_url', '', 'text', 'social', NOW(3)),
('set010', 'linkedin_url', '', 'text', 'social', NOW(3)),
('set011', 'twitter_url', '', 'text', 'social', NOW(3)),
('set012', 'footer_description', 'Solusi IT terpercaya untuk bisnis Anda. Reseller resmi Google Workspace dan penyedia layanan pengembangan website, aplikasi, serta konsultasi IT profesional.', 'text', 'footer', NOW(3)),
('set013', 'footer_copyright', '© 2024 CV Cloud Point Indonesia. All rights reserved.', 'text', 'footer', NOW(3)),
('set014', 'hero_badge', 'Reseller Resmi Google Workspace', 'text', 'homepage', NOW(3)),
('set015', 'hero_title', 'Solusi IT Terpercaya untuk Bisnis Anda', 'text', 'homepage', NOW(3)),
('set016', 'hero_description', 'CV Cloud Point Indonesia menyediakan layanan IT komprehensif mulai dari lisensi Google Workspace, pengembangan website & aplikasi, hingga konsultasi IT profesional.', 'text', 'homepage', NOW(3)),
('set017', 'stats_1_number', '50+', 'text', 'homepage', NOW(3)),
('set018', 'stats_1_label', 'Klien Puas', 'text', 'homepage', NOW(3)),
('set019', 'stats_2_number', '100+', 'text', 'homepage', NOW(3)),
('set020', 'stats_2_label', 'Project Selesai', 'text', 'homepage', NOW(3)),
('set021', 'stats_3_number', '5+', 'text', 'homepage', NOW(3)),
('set022', 'stats_3_label', 'Tahun Pengalaman', 'text', 'homepage', NOW(3)),
('set023', 'stats_4_number', '24/7', 'text', 'homepage', NOW(3)),
('set024', 'stats_4_label', 'Dukungan Teknis', 'text', 'homepage', NOW(3)),
('set025', 'why_title', 'Partner IT Terpercaya untuk Bisnis Anda', 'text', 'homepage', NOW(3)),
('set026', 'why_description', 'Dengan pengalaman bertahun-tahun dalam industri IT, kami berkomitmen memberikan layanan terbaik untuk kesuksesan bisnis Anda.', 'text', 'homepage', NOW(3)),
('set027', 'why_item1_title', 'Reseller Resmi', 'text', 'homepage', NOW(3)),
('set028', 'why_item1_desc', 'Google Workspace resmi dengan harga kompetitif', 'text', 'homepage', NOW(3)),
('set029', 'why_item2_title', 'Tim Profesional', 'text', 'homepage', NOW(3)),
('set030', 'why_item2_desc', 'Didukung oleh tim IT berpengalaman', 'text', 'homepage', NOW(3)),
('set031', 'why_item3_title', 'Support 24/7', 'text', 'homepage', NOW(3)),
('set032', 'why_item3_desc', 'Dukungan teknis kapan saja Anda butuhkan', 'text', 'homepage', NOW(3)),
('set033', 'why_item4_title', 'Harga Kompetitif', 'text', 'homepage', NOW(3)),
('set034', 'why_item4_desc', 'Solusi terbaik dengan harga yang terjangkau', 'text', 'homepage', NOW(3)),
('set035', 'cta_title', 'Butuh Solusi IT untuk Bisnis Anda?', 'text', 'homepage', NOW(3)),
('set036', 'cta_description', 'Hubungi kami sekarang untuk konsultasi gratis dan dapatkan penawaran terbaik.', 'text', 'homepage', NOW(3)),
('set037', 'cta_whatsapp', 'https://wa.me/628563372278', 'text', 'homepage', NOW(3)),
('set038', 'cta_phone', '08563372278', 'text', 'homepage', NOW(3)),
('set039', 'google_maps_embed', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3955.1234567890123!2d112.7!3d-7.4!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zN8KwMjQnMDAuMCJTIDExMsKwNDInMDAuMCJF!5e0!3m2!1sid!2sid!4v1234567890', 'text', 'maps', NOW(3)),
('set040', 'layanan_hero_title', 'Layanan Kami', 'text', 'pages', NOW(3)),
('set041', 'layanan_hero_description', 'Solusi IT komprehensif untuk membantu bisnis Anda berkembang di era digital.', 'text', 'pages', NOW(3)),
('set042', 'portofolio_hero_title', 'Portofolio', 'text', 'pages', NOW(3)),
('set043', 'portofolio_hero_description', 'Lihat proyek-proyek yang telah kami kerjakan.', 'text', 'pages', NOW(3)),
('set044', 'about_hero_title', 'Tentang Kami', 'text', 'pages', NOW(3)),
('set045', 'about_hero_description', 'Mengenal lebih jauh CV Cloud Point Indonesia', 'text', 'pages', NOW(3)),
('set046', 'blog_hero_title', 'Blog', 'text', 'pages', NOW(3)),
('set047', 'blog_hero_description', 'Artikel dan tips seputar teknologi informasi.', 'text', 'pages', NOW(3)),
('set048', 'kontak_hero_title', 'Hubungi Kami', 'text', 'pages', NOW(3)),
('set049', 'kontak_hero_description', 'Kami siap membantu Anda. Hubungi kami untuk konsultasi gratis.', 'text', 'pages', NOW(3)),
('set050', 'about_profile_p1', 'CV Cloud Point Indonesia adalah perusahaan yang bergerak di bidang layanan teknologi informasi (IT) yang berlokasi di Sidoarjo, Jawa Timur. Kami adalah reseller resmi Google Workspace yang menyediakan berbagai solusi IT untuk bisnis Anda.', 'text', 'about', NOW(3)),
('set051', 'about_profile_p2', 'Dengan pengalaman dan tim profesional yang kami miliki, kami berkomitmen untuk memberikan layanan terbaik kepada klien kami. Layanan kami meliputi penjualan lisensi Google Workspace, pembuatan website, pengembangan aplikasi, serta konsultasi IT.', 'text', 'about', NOW(3)),
('set052', 'about_profile_p3', 'Visi kami adalah menjadi partner IT terpercaya yang membantu bisnis Anda berkembang di era digital dengan solusi teknologi yang tepat guna dan inovatif.', 'text', 'about', NOW(3)),
('set053', 'about_value1_title', 'Profesional', 'text', 'about', NOW(3)),
('set054', 'about_value1_desc', 'Kami selalu menjaga standar profesionalisme dalam setiap pekerjaan.', 'text', 'about', NOW(3)),
('set055', 'about_value2_title', 'Terpercaya', 'text', 'about', NOW(3)),
('set056', 'about_value2_desc', 'Kepercayaan klien adalah aset terbesar kami.', 'text', 'about', NOW(3)),
('set057', 'about_value3_title', 'Inovatif', 'text', 'about', NOW(3)),
('set058', 'about_value3_desc', 'Kami selalu menghadirkan solusi terbaru dan terbaik.', 'text', 'about', NOW(3)),
('set059', 'about_value4_title', 'Berkomitmen', 'text', 'about', NOW(3)),
('set060', 'about_value4_desc', 'Kami berkomitmen untuk memberikan yang terbaik bagi klien.', 'text', 'about', NOW(3)),
('set061', 'about_team1_name', 'Tim Pengembangan', 'text', 'about', NOW(3)),
('set062', 'about_team1_role', 'Website & Aplikasi', 'text', 'about', NOW(3)),
('set063', 'about_team1_desc', 'Tim developer berpengalaman dalam pengembangan website dan aplikasi.', 'text', 'about', NOW(3)),
('set064', 'about_team1_photo', '', 'text', 'about', NOW(3)),
('set065', 'about_team2_name', 'Tim Support', 'text', 'about', NOW(3)),
('set066', 'about_team2_role', 'Dukungan Teknis', 'text', 'about', NOW(3)),
('set067', 'about_team2_desc', 'Siap membantu Anda kapan saja dengan layanan support 24/7.', 'text', 'about', NOW(3)),
('set068', 'about_team2_photo', '', 'text', 'about', NOW(3)),
('set069', 'about_team3_name', 'Tim Konsultasi', 'text', 'about', NOW(3)),
('set070', 'about_team3_role', 'IT Consulting', 'text', 'about', NOW(3)),
('set071', 'about_team3_desc', 'Ahli IT yang siap membantu transformasi digital bisnis Anda.', 'text', 'about', NOW(3)),
('set072', 'about_team3_photo', '', 'text', 'about', NOW(3));

SET FOREIGN_KEY_CHECKS = 1;