-- Foundation Database Schema

CREATE DATABASE IF NOT EXISTS foundation;
USE foundation;

-- Activities table for the WelcomeScreen module
CREATE TABLE activities (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT NOT NULL,
    is_read BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- Sample data
INSERT INTO activities (title, description, is_read, created_at) VALUES
('Welcome to Foundation', 'This is your first activity in the Foundation framework!', false, '2024-01-15 10:00:00'),
('Framework Architecture', 'The framework follows Domain-Driven Design principles with clean architecture.', false, '2024-01-15 11:30:00'),
('Module System', 'Each module is self-contained with Application, Domain, and Infrastructure layers.', true, '2024-01-15 12:15:00'),
('API Endpoints', 'RESTful API endpoints are available for all major operations.', false, '2024-01-15 14:20:00'),
('Database Integration', 'The framework uses PDO with prepared statements for secure database operations.', true, '2024-01-15 15:45:00');