DROP TABLE IF EXISTS equipment;

CREATE TABLE equipment (
    id            BIGINT AUTO_INCREMENT PRIMARY KEY,
    code          VARCHAR(20)  NOT NULL UNIQUE,
    name          VARCHAR(100) NOT NULL,
    category      VARCHAR(50)  NOT NULL,
    stock         INT          NOT NULL,
    location      VARCHAR(100),
    purchase_date DATE,
    note          VARCHAR(500)
);
