CREATE TABLE IF NOT EXISTS `lines` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `code` VARCHAR(50) NOT NULL UNIQUE,
    `name` VARCHAR(255),
    `textColorHex` VARCHAR(7),
    `backColorHex` VARCHAR(7),
    `transportTypeId` INT UNSIGNED NOT NULL,
    `createdAt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

    PRIMARY KEY (`id`),

    CONSTRAINT `fk_lines_transport_type`
        FOREIGN KEY (`transportTypeId`)
        REFERENCES `transport_types` (`id`),

    INDEX `idx_transport_type` (`transportTypeId`)
);