.gitignore

CREATE DATABASE IF NOT EXISTS mydb;

USE mydb;

CREATE TABLE IF NOT EXISTS todos (
    id INT AUTO_INCREMENT PRIMARY KEY,
    task VARCHAR(255) NOT NULL,
    status ENUM('pending', 'completed') DEFAULT 'pending',
    deleted BOOLEAN DEFAULT FALSE,              -- Add for soft delete
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    deleted_at TIMESTAMP NULL,                  -- Add for soft delete
    INDEX idx_status (status),
    INDEX idx_created_at (created_at),
    INDEX idx_deleted (deleted)                 -- Add for soft delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Sample data
INSERT INTO todos (task, status) VALUES
    ('Welcome back!', 'pending'),
    ('Table recreated successfully', 'completed');
    ('Learn Docker basics', 'completed'),
    ('Build Flask application', 'completed'),
    ('Write Dockerfile', 'pending'),
    ('Create docker-compose.yml', 'pending'),
    ('Push to Docker Hub', 'pending'),
    ('Deploy to production', 'pending');