CREATE DATABASE IF NOT EXISTS vaultixai_db;
USE vaultixai_db;

CREATE TABLE IF NOT EXISTS services (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    image_url VARCHAR(255),
    sort_order INT NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS certifications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    image_url VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS sliders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    image_url VARCHAR(255),
    link_url VARCHAR(255),
    sort_order INT DEFAULT 0,
    active BOOLEAN DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS pages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(255) UNIQUE NOT NULL,
    content TEXT
);

CREATE TABLE IF NOT EXISTS contact_info (
    id INT AUTO_INCREMENT PRIMARY KEY,
    type VARCHAR(100) NOT NULL, -- e.g., email, phone, address
    value VARCHAR(255) NOT NULL
);

INSERT INTO pages (title, slug, content) VALUES
('Home', 'home', 'Welcome to VAULTIXAI - Secure Data Destruction Services.'),
('About VaultixAI', 'about', 'VAULTIXAI is a specialized provider of Secure Data Destruction Services...'),
('Services', 'services', 'Our Services include HDD Destruction, SSD Destruction, Mobile Device Destruction, Paper Shredding, IT Asset Disposition (ITAD), Certificate of Destruction (CoD), Secure Logistics & Chain of Custody.'),
('Certifications', 'certifications', 'Upon completion of every project, clients receive official documentation confirming the destruction process.'),
('Contact Us', 'contact', 'Contact us for secure data destruction services.');

INSERT INTO services (name, description) VALUES
('HDD Destruction', 'Professional physical destruction of HDDs, ensuring complete and irreversible destruction of stored information.'),
('SSD Destruction', 'Solid-state drives require specialized destruction procedures due to their unique architecture.'),
('Mobile Device Destruction', 'Secure destruction of mobile communication equipment and smart devices.'),
('Confidential Document Destruction', 'Secure destruction of confidential paper documents and archives.'),
('IT Asset Disposition (ITAD)', 'Comprehensive management of retired IT assets through secure processing, destruction, reporting, and responsible recycling.'),
('Data Center Decommissioning', 'Secure dismantling and destruction of data center infrastructure and storage systems.'),
('Certificate of Destruction (CoD)', 'Upon completion of every project, clients receive official documentation confirming the destruction process.');

INSERT INTO contact_info (type, value) VALUES
('email_info', 'info@vaultixai.com'),
('email_sales', 'sales@vaultixai.com'),
('email_operations', 'operations@vaultixai.com'),
('email_ahmad', 'ahmad@vaultixai.com'),
('phone_iraq', '+964 777 351 7004'),
('phone_jordan', '+962 79 512 4434'),
('website', 'www.vaultixai.com'),
('address_baghdad', 'Baghdad, Iraq'),
('address_amman', 'Amman, Jordan'),
('whatsapp', 'https://wa.me/9647773517004');

CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(100) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    full_name VARCHAR(255),
    email VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO users (username, password, full_name, email) VALUES
('admin', '$2y$10$X/VXyxJphE2/LOV0UPGYReybdYkypv0DnSYFb5LM6KRMd7.P3Cfea', 'Admin User', 'admin@vaultixai.com')
ON DUPLICATE KEY UPDATE username=username;

INSERT INTO certifications (title, description) VALUES
('Certificate of Destruction (CoD)', 'شهادة إتلاف رسمية تصدر فور إتمام العملية لتأكيد تدمير الوسائط بشكل نهائي لا يمكن استرجاعه.'),
('ISO 27001 Compliance', 'الالتزام بمعايير أمن المعلومات العالمية لإدارة المخاطر وحماية خصوصية بيانات عملائنا.'),
('HIPAA Compliance', 'تلبية متطلبات السرية التامة وحماية سجلات الرعاية الصحية والبيانات الحساسة وفقاً لأعلى المعايير القانونية.'),
('NIST SP 800-88 Standards', 'تطبيق إرشادات المعهد الوطني للمعايير والتكنولوجيا للتخلص الآمن وإلغاء تنشيط وسائط تخزين البيانات.');

INSERT INTO sliders (title, description, link_url, sort_order, active) VALUES
('Secure Data Destruction', 'Protect your sensitive data with our professional destruction services', 'services.php', 1, 1),
('Certified & Compliant', 'ISO 27001 & HIPAA compliant data destruction solutions', 'certifications.php', 2, 1),
('24/7 Service Available', 'Emergency data destruction services available round the clock', 'contact.php', 3, 1);