CREATE TABLE IF NOT EXISTS stock_items (
    si_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    si_name VARCHAR(255) NOT NULL,
    si_model VARCHAR(255) DEFAULT NULL,
    si_cost DECIMAL(10,2) NOT NULL DEFAULT 0.00,
    si_status VARCHAR(32) NOT NULL DEFAULT 'Active',
    si_created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    si_updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (si_id),
    KEY idx_stock_items_name (si_name),
    KEY idx_stock_items_status (si_status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
