ALTER TABLE `receivingitem` ADD COLUMN `billed` tinyint(1) NOT NULL DEFAULT 0 AFTER `isCredit`;
CREATE INDEX `billed` ON `receivingitem`(`billed`) USING BTREE;

UPDATE receivingitem
SET billed = 1, updated = updated
