CREATE TABLE Tickets (
    TicketID   INT NOT NULL PRIMARY KEY,
    Subject    VARCHAR(200) NOT NULL,
    Status     VARCHAR(20) DEFAULT 'open',
    Priority   INT DEFAULT 3,
    CreatedAt  DATE DEFAULT CURRENT_DATE
);