getConnection(); // Add shipping columns to orders table $alter_queries = [ "ALTER TABLE orders ADD COLUMN IF NOT EXISTS shipping_company_id INT DEFAULT NULL", "ALTER TABLE orders ADD COLUMN IF NOT EXISTS tracking_number VARCHAR(100) DEFAULT NULL", "ALTER TABLE orders ADD COLUMN IF NOT EXISTS shipped_at TIMESTAMP NULL", "ALTER TABLE orders ADD COLUMN IF NOT EXISTS delivered_at TIMESTAMP NULL", "ALTER TABLE orders ADD COLUMN IF NOT EXISTS shipping_notes TEXT", "ALTER TABLE orders ADD CONSTRAINT fk_shipping_company FOREIGN KEY (shipping_company_id) REFERENCES shipping_companies(id) ON DELETE SET NULL" ]; foreach ($alter_queries as $query) { try { $db->exec($query); } catch (Exception $e) { // Column might already exist, continue } } echo "✅ تم إضافة حقول الشحن لجدول الطلبات بنجاح!
"; echo "الذهاب لصفحة الطلبات"; } catch (Exception $e) { echo "❌ خطأ: " . $e->getMessage(); } ?>