⬅ Back Nehal Textile 29-09-2022.sql
use t22l001

ALTER TABLE OPENING_GREY_PURCHASE ADD Remark Varchar(255)
ALTER TABLE OPENING_FINISHED_PURCHASE ADD Remark Varchar(255)
ALTER TABLE OPENING_GENERAL_PURCHASE ADD Remark Varchar(255)
ALTER TABLE OPENING_RECEIVED_FROM_JOB ADD Remark Varchar(255)
ALTER TABLE OPENING_MILL_GP ADD Remark Varchar(255)

UPDATE OPENING_GREY_PURCHASE SET Remark=''
UPDATE OPENING_FINISHED_PURCHASE SET Remark=''
UPDATE OPENING_GENERAL_PURCHASE SET Remark=''
UPDATE OPENING_RECEIVED_FROM_JOB SET Remark=''
UPDATE OPENING_MILL_GP SET Remark=''