//update qdetail 
update qdetail set IMPOS=0,OUTPO=0,OUTPOS=0,SPOS=0,SPOSS=1,IM_OUTSTK=1,IM_POSSTK=1,ORD=1;

update qdetail set IMPOS=0,OUTPO=0,OUTPOS=0,SPOS=0,SPOSS=1,IM_OUTSTK=1,IM_POSSTK=1,ORD=1,BILL='140000000000'


//TRANS_PD 
要注意到
QHEAD EMPID,EMPNAME,DEPTNO TRADETYPE=6時 要等於3 批發
BSUM=ASUMDISMONEY


ALTER TABLE qdetail DROP COLUMN ATLIST;
ALTER TABLE qhead DROP COLUMN ATM;
ALTER TABLE qhead DROP COLUMN ATMDATE;
ALTER TABLE qhead DROP COLUMN TRCASH;
ALTER TABLE qhead DROP COLUMN PS;
ALTER TABLE qhead DROP COLUMN PS1;
ALTER TABLE qhead DROP COLUMN PS2;

update qc_type set COUNTRY=3;
update qcust set CUSTNAME=PS where TR='30';
update qcust set PS=MOBIL where TR='30';
update qcust set MOBIL=MSN where TR='30' and MSN>'  ';
update qcust set MSN=PS where TR='30' and PS>'  ';
update qcust set PS=EMAIL where TR='30' and EMAIL>'  ';
update qcust set TRADETYPE=4 where TR='30' and TRADETYPE>5;

update qfact set MOBIL=MSN where MSN>'' and (MOBIL is null or MOBIL<=' ');

alter TABLE qdetail ADD COLUMN ATLIST VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
alter TABLE qhead ADD COLUMN ATM double;
alter TABLE qhead ADD COLUMN ATMDATE VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
alter TABLE qhead ADD COLUMN TRCASH double;
alter TABLE qhead ADD COLUMN PS VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
alter TABLE qhead ADD COLUMN PS1 VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
alter TABLE qhead ADD COLUMN PS2 VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

update qdetail set `ATLIST`=`INLIST`;
update qhead set `ATM`=0,`ATMDATE`='',`TRCASH`=0,`PS`='',`PS1`='',`PS2`='';

//最新的資料結構已變動
程序:

1.SERVER端 PHP 須更新
2.SERVER 需先 異動資料結構
2.LOCAL端,需要程式下載更新