-- Run this to add claim tracking support
CREATE TABLE IF NOT EXISTS claim_info (
    id INT AUTO_INCREMENT PRIMARY KEY,
    item_type ENUM('lost','found') NOT NULL,
    item_id INT NOT NULL,
    claimant_name VARCHAR(150) NOT NULL,
    claimant_contact VARCHAR(30) NOT NULL,
    remarks TEXT DEFAULT NULL,
    claimed_at DATETIME NOT NULL,
    released_by VARCHAR(150) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY unique_claim (item_type, item_id)
);
