<?php
require_once 'includes/db.php';

echo "<h2>Updating Database Schema...</h2>";

// 1. Remove BOARD MINISTERS and Rename STATE to Board Members in display (backend)
// We'll delete existing BOARD MINISTERS as requested
$conn->query("DELETE FROM board_members WHERE cell = 'BOARD MINISTERS' OR cell = 'BOARD'");

// 2. Create Services Table
$conn->query("CREATE TABLE IF NOT EXISTS `services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `title_hi` varchar(255) DEFAULT '',
  `description` text,
  `description_hi` text,
  `icon` varchar(100) DEFAULT 'fas fa-hands-helping',
  `section` enum('Standard', 'Others Social Work', 'Shaaskt Bharat') DEFAULT 'Standard',
  `sort_order` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");

// 3. Create Service Gallery Table
$conn->query("CREATE TABLE IF NOT EXISTS `service_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT '',
  `subtitle` varchar(255) DEFAULT '',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");

// 4. Insert Initial Services if empty
$check = $conn->query("SELECT id FROM services LIMIT 1");
if ($check->num_rows == 0) {
    $initial_services = [
        ['Education', 'शिक्षा', 'Education par work aur shiksha ka prasar.', 'शिक्षा पर कार्य और शिक्षा का प्रसार।', 'fas fa-book-reader', 'Standard'],
        ['Environment', 'पर्यावरण', 'Paryavaran sanrakshan aur vriksharopan abhiyan.', 'पर्यावरण संरक्षण और वृक्षारोपण अभियान।', 'fas fa-leaf', 'Standard'],
        ['Others Social Work', 'अन्य सामाजिक कार्य', 'Supporting various social causes.', 'विभिन्न सामाजिक कार्यों में सहायता।', 'fas fa-users', 'Others Social Work'],
        ['Shaaskt Bharat', 'सशक्त भारत', 'Working towards a stronger India.', 'एक मजबूत भारत की दिशा में काम करना।', 'fas fa-flag', 'Shaaskt Bharat'],
    ];

    foreach ($initial_services as $s) {
        $stmt = $conn->prepare("INSERT INTO services (title, title_hi, description, description_hi, icon, section) VALUES (?, ?, ?, ?, ?, ?)");
        $stmt->bind_param("ssssss", $s[0], $s[1], $s[2], $s[3], $s[4], $s[5]);
        $stmt->execute();
    }
}

echo "<p style='color:green;'>Database updated successfully!</p>";
echo "<a href='index.php'>Go to Home</a>";
?>