Subversion Repositories SmartDukaan

-- Records who raised each purchase order (the logged-in user's name, or whoever resolved the GRN mismatch that
-- raised it). Nullable and additive: builds that do not map it are unaffected, so it runs BEFORE the deploy.
-- MySQL 5.7: ADD COLUMN rebuilds the table (~54k rows); INPLACE + LOCK=NONE keeps it online.
ALTER TABLE warehouse.purchaseorder ADD COLUMN createdBy VARCHAR(64) NULL, ALGORITHM=INPLACE, LOCK=NONE;