Subversion Repositories SmartDukaan

Rev

Details | Last modification | View Log | RSS feed

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