

UPDATE `purchaseorder` SET `fromdate` = `orderdate` WHERE status="p.o" ;
UPDATE `purchaseorder` SET `paiddate` = `canceldate` WHERE status="p.o" ;
UPDATE `sales_order` SET `mode` = '16'; 




ALTER TABLE `dailycharges` ADD `transactioncode` VARCHAR(50) NOT NULL AFTER `close`;
ALTER TABLE `dailycharges` ADD `name` VARCHAR(20) NOT NULL AFTER `transactioncode`; 
ALTER TABLE `dailycharges` ADD `chargeid` VARCHAR(20) NOT NULL AFTER `name`; 
ALTER TABLE `dailycharges` ADD `plotno` VARCHAR(20) NOT NULL AFTER `chargeid`; 
ALTER TABLE `dailycharges` ADD `houseno` VARCHAR(20) NOT NULL AFTER `plotno`; 
ALTER TABLE `dailycharges` ADD `cost` VARCHAR(20) NOT NULL AFTER `houseno`; 
ALTER TABLE `dailycharges` ADD `createdat` VARCHAR(30) NOT NULL AFTER `cost`;  


ALTER TABLE `bookroom` ADD `mytable` VARCHAR(20) NOT NULL AFTER `vatable`; 
ALTER TABLE `bookroom` ADD `salesperson` VARCHAR(20) NULL DEFAULT NULL AFTER `mytable`; 
ALTER TABLE `bookroom` ADD `receiptno` VARCHAR(20) NULL DEFAULT NULL AFTER `salesperson`; 
ALTER TABLE `smsconfig` ADD `restricttill` VARCHAR(20) NOT NULL DEFAULT 'no' AFTER `displayservicecharge`; 
ALTER TABLE `house` ADD `beds` VARCHAR(5) NULL DEFAULT NULL AFTER `bowholeyear`; 
ALTER TABLE `house` ADD `bedstatus` VARCHAR(20) NOT NULL DEFAULT 'no' AFTER `beds`; 
ALTER TABLE `bookroom` ADD `bedid` INT NULL DEFAULT '1' AFTER `discountedtotal`, ADD `bedname` VARCHAR(100) NOT NULL AFTER `bedid`; 


update nhif set nhifrelief =( 0.15*`amount`);
