CREATE DATABASE warranty_db;
USE warranty_db;

CREATE TABLE repairs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    serial_number VARCHAR(100) NOT NULL,
    repair_type VARCHAR(255),
    repair_date DATE,
    warranty_end_date DATE,
    notes TEXT
);