#更改表结构 ALTER TABLE e_feerule CHANGE code prefix varchar ( 255 ) not null ; ALTER TABLE e_feerule CHANGE locationName location varchar ( 255 ) not null ; ALTER TABLE e_feerule CHANGE ruleset_id feerategroup_id int ( 11 ) not null ; ALTER TABLE e_customer CHANGE ruleset_id feerategroup_id int ( 11 ) not null ; ALTER TABLE e_customer CHANGE state locktype int ( 11 ) null ; ALTER TABLE e_customer DROP COLUMN paytype; ALTER TABLE e_customer DROP COLUMN alarmmoney; ALTER TABLE e_customer DROP COLUMN discountset_id; ALTER TABLE e_bill_template CHANGE gatewayfeetime agentfeetime int ( 11 ) null ; ALTER TABLE e_bill_template ADD feeprefix varchar ( 255 ) null after holdtime; ALTER TABLE e_bill_template ADD suitefeetime int ( 11 ) null after fee; ALTER TABLE e_bill_template ADD suitefee double null after fee; ALTER TABLE e_bill_template ADD agentfeeprefix varchar ( 255 ) null after customername; ALTER TABLE e_bill_template ADD agentsuitefeetime int ( 11 ) null after agentfee; ALTER TABLE e_bill_template ADD agentsuitefee double null after agentfee; ALTER TABLE e_bill_template CHANGE relateindex cdrlevel int ( 11 ) null ; ALTER TABLE e_bill_template CHANGE rel_id subcdr_id int ( 11 ) null ; ALTER TABLE e_gateway DROP COLUMN remainmoney; ALTER TABLE e_gateway DROP COLUMN ruleset_id; ALTER TABLE e_gateway DROP COLUMN discountset_id; ALTER TABLE e_gateway ADD clearingcustomer_id int ( 11 ) not null after mbx_id; UPDATE e_gateway SET clearingcustomer_id = - 1 ; ALTER TABLE r_ruleset_privileges CHANGE ruleset_id feerategroup_id int ( 11 ) null ; ALTER TABLE