File Manager

✏️ Edit File: /home/u625410797/domains/iooi.co.th/public_html/database/home_schema.sql

-- ============================================================
-- IOOI Homepage Dynamic Content Tables
-- Run this in phpMyAdmin on the `iooi` database
-- ============================================================

-- 1. Company stats (Why Choose IOOI section)
CREATE TABLE IF NOT EXISTS `home_stats` (
  `id`         INT(11)      NOT NULL AUTO_INCREMENT,
  `stat_number` VARCHAR(50) NOT NULL COMMENT 'e.g. "10+", "500+"',
  `stat_label`  VARCHAR(150) NOT NULL COMMENT 'e.g. "Years Experience"',
  `stat_sub`    VARCHAR(150) NOT NULL COMMENT 'Thai subtitle',
  `icon_class`  VARCHAR(100) DEFAULT 'fas fa-star',
  `sort_order`  INT(11)      DEFAULT 0,
  `is_active`   TINYINT(1)   DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `home_stats`
  (`stat_number`, `stat_label`, `stat_sub`, `icon_class`, `sort_order`) VALUES
  ('10+',   'Years Experience',  'ประสบการณ์กว่า 10 ปี',   'fas fa-award',       1),
  ('500+',  'Projects Completed','โปรเจกต์ที่สำเร็จแล้ว',  'fas fa-check-circle', 2),
  ('1000+', 'Products',          'สินค้าในคลัง',            'fas fa-box-open',     3),
  ('24/7',  'Support',           'บริการหลังการขาย',        'fas fa-headset',      4);

-- 2. Trusted-by client logos
CREATE TABLE IF NOT EXISTS `home_trusted` (
  `id`         INT(11)      NOT NULL AUTO_INCREMENT,
  `name`       VARCHAR(150) NOT NULL,
  `logo_url`   VARCHAR(255) NOT NULL,
  `sort_order` INT(11)      DEFAULT 0,
  `is_active`  TINYINT(1)   DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Sample data (replace logo_url with actual paths after uploading)
INSERT INTO `home_trusted`
  (`name`, `logo_url`, `sort_order`) VALUES
  ('SC Asset',        'images/trusted/sc-asset.png',     1),
  ('Sansiri',         'images/trusted/sansiri.png',      2),
  ('Ananda',          'images/trusted/ananda.png',       3),
  ('Supalai',         'images/trusted/supalai.png',      4),
  ('Central Pattana', 'images/trusted/central.png',      5),
  ('Sugar Estate',    'images/trusted/sugar-estate.png', 6);

-- 3. Hero section settings (single-row config)
CREATE TABLE IF NOT EXISTS `home_settings` (
  `id`          INT(11)      NOT NULL AUTO_INCREMENT,
  `hero_title1` VARCHAR(255) DEFAULT 'LIGHTING',
  `hero_title2` VARCHAR(255) DEFAULT 'SMART SOLUTION',
  `hero_title3` VARCHAR(255) DEFAULT 'SOLAR & IOT',
  `hero_subtitle` TEXT,
  `about_text`  TEXT,
  `updated_at`  TIMESTAMP    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `home_settings`
  (`hero_title1`, `hero_title2`, `hero_title3`, `hero_subtitle`, `about_text`) VALUES
  ('LIGHTING', 'SMART SOLUTION', 'SOLAR & IOT',
   'ครบจบในที่เดียว เพื่อบ้าน ธุรกิจ และโครงการของคุณ ด้วยเทคโนโลยีที่ทันสมัยและได้มาตรฐานระดับสากล',
   'เราคือผู้นำด้านระบบแสงสว่างอัจฉริยะ ครบครันทั้ง Lighting, Smart Solution, Solar และ IoT เพื่อทุกรูปแบบการใช้งาน');

Batal

⬅ Naik ke public_html 40 item

Nama	Tipe	Ukuran	Diubah	Aksi
📝IMPLEMENTATION_SUMMARY.md	md	6.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_font_to_theme.sql	sql	340 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_hero_font_size_settings.sql	sql	1.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_home_solution_font_image_settings.sql	sql	3.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_portfolio_complete_fields.sql	sql	1.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_portfolio_description.sql	sql	368 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_portfolio_detailed_fields.sql	sql	2.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_portfolio_detailed_fields_safe.sql	sql	3.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_portfolio_font_image_settings.sql	sql	3.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_portfoliodetail_description.sql	sql	309 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_prodcategory_columns.sql	sql	1.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_product_section_font_image_settings.sql	sql	2.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_solution_details.sql	sql	712 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_solution_font_image_settings.sql	sql	10.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_solution_hero_image.sql	sql	314 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_solution_hero_image_safe.sql	sql	842 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️add_subtext_color_to_theme.sql	sql	303 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️alter_portfoliodetail_portfoliogroup.sql	sql	523 B	2026-06-04 10:52	✏️ Edit 👁️ View
🐘check_subtext_column.php	php	1.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️create_about_us_table.sql	sql	3.8 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️fix_double_encoding.sql	sql	1.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️floating_widget_schema.sql	sql	657 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️footer_schema.sql	sql	4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️home_about_schema.sql	sql	659 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️home_certifications_schema.sql	sql	1.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️home_portfolio_section_schema.sql	sql	3.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️home_product_section_schema.sql	sql	3.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️home_schema.sql	sql	3.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️home_solution_section_schema.sql	sql	4.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️insert_default_theme.sql	sql	1.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️iooi.sql	sql	3.5 MB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️main_menu_schema.sql	sql	8.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘migrate_add_font.php	php	1.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘migrate_add_subtext_color.php	php	1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️migrate_portfolio_fields.sql	sql	2.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️solution_page_schema.sql	sql	3.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘update_footer_images.php	php	946 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️update_footer_images.sql	sql	183 B	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️update_portfolio_image_paths.sql	sql	1.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️update_solution_image_paths.sql	sql	624 B	2026-06-03 06:33	✏️ Edit 👁️ View