ALTER TABLE purchase_requisitions
    ADD COLUMN style_info_id BIGINT UNSIGNED NULL AFTER mrp_header_id,
    ADD COLUMN bom_header_id BIGINT UNSIGNED NULL AFTER style_info_id,
    ADD KEY idx_pr_style_info (style_info_id, deleted_at),
    ADD KEY idx_pr_bom_header (bom_header_id),
    ADD CONSTRAINT fk_pr_style_info FOREIGN KEY (style_info_id) REFERENCES style_infos (id),
    ADD CONSTRAINT fk_pr_bom_header FOREIGN KEY (bom_header_id) REFERENCES bom_headers (id);
