getConnection();
echo "إنشاء نظام الاستوريز...
";
// جدول الاستوريز
$sql = "CREATE TABLE IF NOT EXISTS stories (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
image VARCHAR(500) NOT NULL,
link VARCHAR(500),
duration INT DEFAULT 5,
is_active BOOLEAN DEFAULT TRUE,
views_count INT DEFAULT 0,
order_position INT DEFAULT 0,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
expires_at TIMESTAMP NULL,
created_by INT,
FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
$db->exec($sql);
echo "✅ تم إنشاء جدول stories
";
// جدول مشاهدات الاستوريز
$sql = "CREATE TABLE IF NOT EXISTS story_views (
id INT AUTO_INCREMENT PRIMARY KEY,
story_id INT NOT NULL,
user_id INT NULL,
ip_address VARCHAR(45),
viewed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (story_id) REFERENCES stories(id) ON DELETE CASCADE,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE SET NULL,
UNIQUE KEY unique_view (story_id, user_id, ip_address)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
$db->exec($sql);
echo "✅ تم إنشاء جدول story_views
";
echo "
✅ تم إنشاء نظام الاستوريز بنجاح!
";
echo "الذهاب لإدارة الاستوريز
";
} catch (PDOException $e) {
echo "❌ خطأ: " . $e->getMessage() . "
";
}