curtime upgrade check ....
soft_product_id is 'inv'
soft_product_ver is '20101026'
开始备份数据库 F:\易洁\inv_setup\db\正式库.mdb，目录 F:\易洁\inv_setup 请稍候
备份数据库 F:\易洁\inv_setup\db\正式库.mdb，目录 F:\易洁\inv_setup 成功
Inv_Upgrade_20101101
alter column res in_ceil_price DECIMAL(12,2) NULL
--OK
alter column res in_ref_price DECIMAL(12,2) NULL
--OK
alter column res out_floor_price DECIMAL(12,2) NULL
--OK
alter column res out_ref_price DECIMAL(12,2) NULL
--OK
alter column res cost_price DECIMAL(12,2) NULL
--OK
alter column res_unit_type_ext in_ceil_price DECIMAL(12,2) NULL
--OK
alter column res_unit_type_ext in_ref_price DECIMAL(12,2) NULL
--OK
alter column res_unit_type_ext out_floor_price DECIMAL(12,2) NULL
--OK
alter column res_unit_type_ext out_ref_price DECIMAL(12,2) NULL
--OK
alter column ebs_vr_item inp_price DECIMAL(12,2) NULL
--ERROR -100
--ERMSG 由于您和其他用户试图同时改变同一数据，导致 Microsoft Jet 数据库引擎停止进程。
commit
--NOT DONE, PRE ERROR
alter column ebs_vr_item tag_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column ebs_vr_item cost_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_res_init price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column edt_res_cost price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column edt_res_cost_price cost_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column edt_res_cost_usage price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column edt_io inp_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_io tag_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_io cost_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_eba_io inp_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column eba_io inp_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column eba_io cost_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column eba_io_init inp_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column eba_io_init cost_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column eba_price price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column sup_io inp_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column sup_io_init inp_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
alter column sup_price_info price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
create table edt_res_batch_price ( res_id VARCHAR(20) , batch_no VARCHAR(30) , price DECIMAL(12,2) default 0 , voucher_id INT default 0 , voucher_date CHAR(8) )
--NOT DONE, PRE ERROR
create unique index edt_res_batch_price_pri on edt_res_batch_price(res_id,batch_no)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20101101','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20101101 over
Base_Upgrade_20101111
create table rep_obj_key_map ( obj_key_id VARCHAR(30) , rep_id VARCHAR(60) )
--NOT DONE, PRE ERROR
create unique index rep_obj_key_map_pri on rep_obj_key_map(obj_key_id,rep_id)
--NOT DONE, PRE ERROR
Inv_Upgrade_20101111
create table edt_cycle_cost_price ( res_id VARCHAR(20) , cycle_id INT default 0 , num DECIMAL(12,4) default 0 , cost_price DECIMAL(12,2) default 0 )
--NOT DONE, PRE ERROR
create unique index edt_cycle_cost_price_pri on edt_cycle_cost_price(res_id,cycle_id)
--NOT DONE, PRE ERROR
create table edt_cycle_res_link_cost_tmp ( res_id VARCHAR(20) , cycle_id INT default 0 , price_cycle_id INT default 0 , cost_price DECIMAL(12,2) default 0 )
--NOT DONE, PRE ERROR
create unique index edt_cycle_res_link_cost_tmp_pri on edt_cycle_res_link_cost_tmp(res_id,cycle_id)
--NOT DONE, PRE ERROR
add column edt_cycle_res cost_price DECIMAL(12,2) default 0
--NOT DONE, PRE ERROR
create table qm_catalog ( qm_cat_id VARCHAR(20) , qm_cat_name VARCHAR(80) , parent_qm_cat_id VARCHAR(20) , order_id INT default 0 )
--NOT DONE, PRE ERROR
create unique index qm_catalog_pri on qm_catalog(qm_cat_id)
--NOT DONE, PRE ERROR
add column qm_item qm_cat_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebs_vr_ctl print_map_obj_opt CHAR(1)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20101111','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20101111 over
Inv_Upgrade_20101119
add column ebs_vr_item discount_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
add column ebs_vr_item tax_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
update ebs_vr_item set discount_price=inp_price*discount/100
--NOT DONE, PRE ERROR
update ebs_vr_item set tax_price=discount_price*(100+tax_rate)/100
--NOT DONE, PRE ERROR
add column edt_io discount_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
add column edt_io tax_price DECIMAL(12,2) NULL
--NOT DONE, PREERROR
update edt_io set discount_price=inp_price*discount/100
--NOT DONE, PRE ERROR
update edt_io set tax_price=discount_price*(100+tax_rate)/100
--NOT DONE, PRE ERROR
add column sup_io discount_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
add column sup_io tax_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
update sup_io set discount_price=inp_price*discount/100
--NOT DONE, PRE ERROR
update sup_io set tax_price=discount_price*(100+tax_rate)/100
--NOT DONE, PRE ERROR
add column eba_io discount_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
add column eba_io tax_price DECIMAL(12,2) NULL
--NOT DONE, PRE ERROR
update eba_io set discount_price=inp_price*discount/100
--NOT DONE, PRE ERROR
update eba_io set tax_price=discount_price*(100+tax_rate)/100
--NOT DONE, PRE ERROR
add column ebs_vr_ctl is_tax_price CHAR(1) NULL
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20101119','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20101119 over
Inv_Upgrade_20101125
alter column ebs_vr discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column ebs_vr_item discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_io discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_eba_io discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column sup_io discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column sup_io v_discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column eba_io discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column eba_io v_discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column eba_vr discount DECIMAL(7,4) NULL
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
add column qm_v col_num INT default 0
--NOT DONE, PRE ERROR
create table qm_v_data ( voucher_id INT default 0 , item_id INT default 0 , col_id INT default 0 , val DECIMAL(8,2) default 0 )
--NOT DONE, PRE ERROR
create unique index qm_v_data_pri on qm_v_data(voucher_id,item_id,col_id)
--NOT DONE, PRE ERROR
Base_Upgrade_20101125
create table ebs_v_oper_log ( rec_id INT default 0 , voucher_id INT default 0 , voucher_no VARCHAR(20) , voucher_type VARCHAR(3) , oper_date CHAR(8) , oper_time CHAR(6) , oper_user_id VARCHAR(8) , oper_type CHAR(1) )
--NOT DONE, PRE ERROR
create unique index ebs_v_oper_log_pri on ebs_v_oper_log(rec_id)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20101125','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20101125 over
Inv_Upgrade_20101202
add column ebs_vr_ref_set mix_id VARCHAR(16) NULL
--NOT DONE, PRE ERROR
add column mio_account method_id CHAR(1) NULL
--NOT DONE, PRE ERROR
alter column qm_v sup_id VARCHAR(16) NULL
--NOT DONE, PRE ERROR
add column qm_v eba_id VARCHAR(16) NULL
--NOT DONE, PRE ERROR
add column qm_v res_info VARCHAR(120) NULL
--NOT DONE, PRE ERROR
create table qm_obj_grp ( qm_obj_grp_id VARCHAR(20) , name VARCHAR(30) , note_info VARCHAR(250) , parent_obj_grp_id VARCHAR(20) )
--NOT DONE, PRE ERROR
create unique index qm_obj_grp_pri on qm_obj_grp(qm_obj_grp_id)
--NOT DONE, PRE ERROR
create table qm_degree_std ( rec_id INT default 0 , qm_obj_grp_id VARCHAR(20) , qm_degree VARCHAR(20) , max_exceed DECIMAL(8,2) default 0 , max_short DECIMAL(8,2) default 0 )
--NOT DONE, PRE ERROR
create unique index qm_degree_std_pri on qm_degree_std(rec_id)
--NOT DONE, PRE ERROR
add column qm_catalog qm_obj_grp_id VARCHAR(16) NULL
--NOT DONE, PRE ERROR
add column qm_item qm_obj_grp_id VARCHAR(16) NULL
--NOT DONE, PRE ERROR
add column qm_v qm_degree VARCHAR(8) NULL
--NOT DONE, PRE ERROR
add column qm_v_item item_qm_degree VARCHAR(8) NULL
--NOT DONE, PRE ERROR
Base_Upgrade_20101202
alter table app_voucher_date_lmt add lmt_type CHAR(1)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20101202','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20101202 over
Inv_Upgrade_20101209
create table ebm_brand ( ebm_brand_id VARCHAR(8) , name VARCHAR(40) , note_info VARCHAR(120) , order_id INT default 0 )
--NOT DONE, PRE ERROR
create unique index ebm_brand_pri on ebm_brand(ebm_brand_id)
--NOT DONE, PRE ERROR
add column ebm_bill ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update ebm_bill set ebm_brand_id='-'
--NOT DONE, PRE ERROR
add column ebm_io ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update ebm_io set ebm_brand_id='-'
--NOT DONE, PRE ERROR
add column ebm_mio ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update ebm_mio set ebm_brand_id='-'
--NOT DONE, PRE ERROR
add column ebs_vr ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update ebs_vr set ebm_brand_id='-'
--NOT DONE, PRE ERROR
add column ebs_vr_ctl show_ebm_brand_id CHAR(1) NULL
--NOT DONE, PRE ERROR
update ebs_vr_ctl set show_ebm_brand_id='N'
--NOT DONE, PRE ERROR
add column eba_bill_init ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update eba_bill_init set ebm_brand_id='-'
--NOT DONE, PRE ERROR
add column eba_pre_init ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update eba_pre_init set ebm_brand_id='-'
--NOT DONE, PRE ERROR
add column sup_bill_init ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update sup_bill_init set ebm_brand_id='-'
--NOT DONE, PRE ERROR
add column sup_pre_init ebm_brand_id VARCHAR(8) NULL
--NOT DONE, PRE ERROR
update sup_pre_init set ebm_brand_id='-'
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20101209','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20101209 over
Inv_Upgrade_20101210
alter column ebs_vr_item cost_price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_io cost_price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column eba_io cost_price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_cycle_res cost_price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_cycle_cost_price cost_price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_cycle_res_link_cost_tmp cost_price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_res_cost_price cost_price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_res_cost price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_res_cost_usage price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
alter column edt_res_batch_price price DECIMAL(14,4)
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
add column ebs_vr_ctl io_amount_default_opt CHAR(1) NULL
--NOT DONE, PRE ERROR
update ebs_vr_ctl set io_amount_default_opt='~'
--NOT DONE, PRE ERROR
update ebs_vr_ctl set io_amount_default_opt='A' where voucher_type in('BE','BF','BH','AE','AF')
--NOT DONE, PRE ERROR
add column qm_v_item item_note_info VARCHAR(80) NULL
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20101210','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20101210 over
下载 DLL 升级升不聊
我用的是 2010.9.4 更新的版本，请问能让我升级到现在的最新版本，并保留当前所有数据吗？ |
