File Manager

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

-- ============================================================
-- IOOI Homepage Solution Section Dynamic Content Tables
-- Run this in phpMyAdmin on the production database
-- ============================================================

-- Select the database (uncomment for production)
-- USE `u625410797_nfsolar`;
-- For local development, use: USE `iooi`;

-- Homepage solution section settings (single-row config for Section 03)
CREATE TABLE IF NOT EXISTS `home_solution_section` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `section_label` VARCHAR(100) DEFAULT 'OUR SOLUTIONS' COMMENT 'Label above title (e.g., OUR SOLUTIONS)',
  `section_title_th` VARCHAR(255) DEFAULT 'โซลูชันของเรา' COMMENT 'Main title in Thai',
  `section_title_en` VARCHAR(255) DEFAULT 'Our Solutions' COMMENT 'Main title in English',
  `section_description_th` TEXT COMMENT 'Description in Thai',
  `section_description_en` TEXT COMMENT 'Description in English',
  `button_text` VARCHAR(100) DEFAULT 'ดูโซลูชันทั้งหมม' COMMENT 'Button text',
  `button_link` VARCHAR(255) DEFAULT 'solution.php' COMMENT 'Button link URL',
  `display_mode` ENUM('carousel', 'grid') DEFAULT 'carousel' COMMENT 'Display mode: carousel or grid',
  `cards_per_view` INT(11) DEFAULT 4 COMMENT 'Number of cards visible at once (for carousel)',
  `auto_play` TINYINT(1) DEFAULT 1 COMMENT 'Auto-play carousel (1 = yes, 0 = no)',
  `auto_play_interval` INT(11) DEFAULT 5000 COMMENT 'Auto-play interval in milliseconds',
  `show_arrows` TINYINT(1) DEFAULT 1 COMMENT 'Show navigation arrows (1 = yes, 0 = no)',
  `show_dots` TINYINT(1) DEFAULT 1 COMMENT 'Show pagination dots (1 = yes, 0 = no)',
  `card_aspect_ratio` VARCHAR(20) DEFAULT 'portrait' COMMENT 'Card aspect ratio: portrait or landscape',
  `overlay_style` ENUM('gradient', 'solid', 'none') DEFAULT 'gradient' COMMENT 'Card overlay style',
  `selected_solutions` TEXT COMMENT 'Comma-separated solution IDs to display (empty = all active)',
  `solution_order` VARCHAR(20) DEFAULT 'custom' COMMENT 'Order: custom, name_asc, name_desc, date_asc, date_desc',
  `is_active` TINYINT(1) DEFAULT 1 COMMENT 'Section visibility (1 = visible, 0 = hidden)',
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Homepage Solution Section Settings';

-- Insert default data matching current homepage Section 03
INSERT INTO `home_solution_section`
  (`section_label`, `section_title_th`, `section_title_en`, 
   `section_description_th`, `section_description_en`, 
   `button_text`, `button_link`, 
   `display_mode`, `cards_per_view`, `auto_play`, `auto_play_interval`,
   `show_arrows`, `show_dots`, `card_aspect_ratio`, `overlay_style`,
   `selected_solutions`, `solution_order`, `is_active`) VALUES
  ('OUR SOLUTIONS', 
   'โซลูชันของเรา', 
   'Our Solutions',
   'โซลูชันที่ครบครันและทันสมัย พร้อมบริการครบวงจรสำหรับทุกความต้องการของคุณ',
   'Comprehensive and modern solutions with full-service support for all your needs',
   'ดูโซลูชันทั้งหมม →',
   'solution.php',
   'carousel',
   4,
   1,
   5000,
   1,
   1,
   'portrait',
   'gradient',
   '',
   'custom',
   1);

-- ============================================================
-- Additional enhancement: Add description field to solutions table
-- This allows each solution to have a short description for homepage cards
-- ============================================================

-- Check if description column exists, if not add it
SET @column_exists = (
  SELECT COUNT(*)
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'solutions'
  AND COLUMN_NAME = 'solutionDetail'
);

SET @sql = IF(@column_exists = 0, 
  'ALTER TABLE `solutions` ADD COLUMN `solutionDetail` TEXT AFTER `solutionName`',
  'SELECT ''Column solutionDetail already exists'' AS message');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

-- Check if sort_order column exists, if not add it
SET @column_exists = (
  SELECT COUNT(*)
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'solutions'
  AND COLUMN_NAME = 'sort_order'
);

SET @sql = IF(@column_exists = 0, 
  'ALTER TABLE `solutions` ADD COLUMN `sort_order` INT(11) DEFAULT 0 AFTER `solutionStatus`',
  'SELECT ''Column sort_order already exists'' AS message');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

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