ALTER TABLE item_code
    ADD COLUMN length_type VARCHAR(50) NULL AFTER length_value,
    ADD COLUMN zipper_no VARCHAR(80) NULL AFTER length_type,
    ADD COLUMN lock_type VARCHAR(80) NULL AFTER zipper_no,
    ADD COLUMN end_type VARCHAR(80) NULL AFTER lock_type,
    ADD COLUMN zipper_tape_color_id BIGINT UNSIGNED NULL AFTER end_type,
    ADD KEY idx_item_code_zipper_tape (zipper_tape_color_id),
    ADD CONSTRAINT fk_item_code_zipper_tape_color
        FOREIGN KEY (zipper_tape_color_id) REFERENCES zipper_tape_colors (id);