
ALTER TABLE shiphead ADD COLUMN shiphead_delivery_note TEXT;        

CREATE INDEX shiphead_delivery_note_ix  ON shiphead   USING btree  (shiphead_delivery_note);

ALTER TABLE recvgrp ADD COLUMN recvgrp_receipt_number TEXT;

CREATE INDEX recvgrp_receipt_number_ix  ON recvgrp  USING btree  (recvgrp_receipt_number);

ALTER TABLE invhist_transfer ADD COLUMN invhist_transfer_delivery_note TEXT;

CREATE INDEX invhist_transfer_delivery_note_ix  ON invhist_transfer  USING btree  (invhist_transfer_delivery_note );