INSERT into sys_updata(softid,up_ver,up_db,up_date,up_name,up_type,up_sql,last_change,last_date)
VALUES(0,'1.1.2.1','down',NOW(),'addtable','down','CREATE TABLE IF NOT EXISTS sys_branchdata(softid  int(11) NOT NULL,branch_no  varchar(6) NOT NULL,proj_type varchar(2) NOT NULL,data_no varchar(20)NOT NULL,last_date datetime DEFAULT NULL,last_change  int(11) DEFAULT 0,PRIMARY KEY (softid,branch_no,proj_type,data_no));',10,NOW())

 
 
INSERT into sys_updata(softid,up_ver,up_db,up_date,up_name,up_type,up_sql,last_change,last_date)
VALUES(0,'1.1.2.1','down',NOW(),'addbak24','down','insert into cm_trans(softid,branch_no,table_id,isbranch,up_flag,down_flag,can_up,can_down) values (-1,0,''sys_branchdata'',0,0,-1,0,1);',10,NOW())


update sys_lastchg set max_flow=10  where softid=0 and table_id='sys_updata'