curtime upgrade check ....
soft_product_id is 'oedt'
soft_product_ver is '20110326'
开始备份数据库 E:\edt_setup\db\000086_000083_01_正式库.mdb，目录 E:\edt_setup 请稍候
备份数据库 E:\edt_setup\db\000086_000083_01_正式库.mdb，目录 E:\edt_setup 成功
Base_Upgrade_20110413
create table tbx_mail_catalog ( group_id VARCHAR(8) , order_id INT default 0 , group_name VARCHAR(40) , user_id VARCHAR(8) , parent_group_id VARCHAR(8) , is_default_send_box CHAR(1) , is_default_recv_box CHAR(1) , is_default_sended_box CHAR(1) )
--OK
create unique index tbx_mail_catalog_pri on tbx_mail_catalog(group_id)
--OK
create table tbx_mail ( mail_id INT default 0 , group_id VARCHAR(8) , mail_date VARCHAR(8) , mail_time VARCHAR(6) , subject VARCHAR(120) , sender VARCHAR(80) , receiver VARCHAR(200) , mail_size INT default 0 , mail_text TEXT , need_send CHAR(1) , last_send_date VARCHAR(8) , last_send_time VARCHAR(6) , send_times INT default 0 , need_recv CHAR(1) , message_id VARCHAR(80) , user_id VARCHAR(8) , in_out_flag CHAR(1) , email VARCHAR(80) )
--OK
create unique index tbx_mail_pri on tbx_mail(mail_id)
--OK
create table tbx_mail_attachment ( mail_id INT default 0 , attachment_id INT default 0 , name VARCHAR(120) , file_size INT default 0 , file_id INT default 0 )
--OK
create unique index tbx_mail_attachment_pri on tbx_mail_attachment(mail_id,attachment_id)
--OK
create table tbx_mail_account ( email VARCHAR(80) , user_id VARCHAR(8) , email_pwd VARCHAR(20) , smtp_host VARCHAR(80) , smtp_port INT default 0 , pop3_host VARCHAR(80) , pop3_port INT default 0 , is_default CHAR(1) , sync_flag CHAR(1) , keep_mail_on_server CHAR(1) )
--OK
create unique index tbx_mail_account_pri on tbx_mail_account(email)
--OK
Inv_Upgrade_20110413
create table res_eba_code_map ( res_id VARCHAR(20) , eba_id VARCHAR(8) , eba_res_id VARCHAR(20) )
--OK
create unique index res_eba_code_map_pri on res_eba_code_map(res_id,eba_res_id)
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110413','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110413 over
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110425','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110425 over
Base_Upgrade_20110503
add column tbx_task evaluate_grade VARCHAR(8)
--OK
add column tbx_task evaluate_comment VARCHAR(120)
--OK
add column tbx_task evaluate_mark DECIMAL(8,2)
--OK
Base_Upgrade_20110507
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110509','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110509 over
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110514','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110514 over
Inv_Upgrade_20110526
add column edt_res_cost amount DECIMAL(14,2)
--OK
add column edt_res_cost batch_no VARCHAR(30)
--OK
update edt_res_cost set amount=std_num*price
--OK
add column edt_res_cost_usage amount DECIMAL(14,2)
--OK
add column edt_res_cost_usage batch_no VARCHAR(30)
--OK
update edt_res_cost_usage set amount=std_num*price
--OK
add column edt_res_cost_price amount DECIMAL(14,2)
--OK
add column edt_res_cost_price voucher_date CHAR(8)
--OK
add column edt_res_cost_price voucher_id INT
--OK
update edt_res_cost_price set amount=num*cost_price
--OK
add column edt_res_cost_req min_date_i CHAR(8)
--OK
add column edt_res_cost_req min_date_o CHAR(8)
--OK
add column edt_res_cost_req min_date_a CHAR(8)
--OK
add column edt_io cost_amount DECIMAL(14,2)
--OK
update edt_io set cost_amount=total_amount
--OK
create table edt_res_cost_edt_io_tmp ( voucher_id INT default 0 , item_id INT default 0 , cost_price DECIMAL(14,4) default 0 , cost_amount DECIMAL(14,2) default 0 )
--OK
create unique index edt_res_cost_edt_io_tmp_pri on edt_res_cost_edt_io_tmp(voucher_id,item_id)
--OK
delete from edt_res_cost_price
--OK
insert into edt_res_cost_price(res_id,num,cost_price,amount,voucher_date,voucher_id) select res_id,std_num,price,amount,cost_voucher_date,cost_voucher_id from edt_res_cost where cost_voucher_date='19700101' and cost_voucher_id=0
--OK
delete from edt_res_cost where cost_voucher_date='19700101' and cost_voucher_id=0
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110526','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110526 over
Inv_Upgrade_20110531
add column ebs_vr_item is_main CHAR(1)
--OK
add column ebs_vr_item main_id INT
--OK
update ebs_vr_item set is_main='N',main_id=1
--OK
update ebs_vr_item set is_main='Y' where item_id=0
--OK
add column ebs_vr_ctl main_res_num_flag CHAR(1)
--OK
update ebs_vr_ctl set main_res_num_flag='A'
--OK
add column edt_io move_res_flag CHAR(1)
--OK
update edt_io set move_res_flag='N'
--OK
update edt_io set move_res_flag='Y' where voucher_type='GD'
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110531','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110531 over
Inv_Upgrade_20110603
add column ebm_io create_voucher_no VARCHAR(20)
--OK
update ebm_io set create_voucher_no='cx_init' where voucher_type='CX'
--OK
update ebm_io set create_voucher_no='cy_init' where voucher_type='CY'
--OK
update ebm_io set create_voucher_no='dx_init' where voucher_type='DX'
--OK
update ebm_io set create_voucher_no='dy_init' where voucher_type='DY'
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110603','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110603 over
Inv_Upgrade_20110607
alter column eba id_code VARCHAR(40)
--OK
alter column sup id_code VARCHAR(40)
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110607','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110607 over
Inv_Upgrade_20110615
alter column ebs_vr_item inp_price DECIMAL(14,4)
--OK
commit
--OK
alter column ebs_vr_item tag_price DECIMAL(14,4)
--OK
commit
--OK
alter column ebs_vr_item discount_price DECIMAL(14,4)
--OK
commit
--OK
alter column ebs_vr_item tax_price DECIMAL(14,4)
--OK
commit
--OK
alter column edt_io inp_price DECIMAL(14,4)
--OK
commit
--OK
alter column edt_io tag_price DECIMAL(14,4)
--OK
commit
--OK
alter column edt_io discount_price DECIMAL(14,4)
--OK
commit
--OK
alter column edt_io tax_price DECIMAL(14,4)
--OK
commit
--OK
alter column edt_eba_io inp_price DECIMAL(14,4)
--OK
commit
--OK
alter column edt_res_init price DECIMAL(14,4)
--OK
commit
--OK
alter column eba_io inp_price DECIMAL(14,4)
--OK
commit
--OK
alter column eba_io discount_price DECIMAL(14,4)
--OK
commit
--OK
alter column eba_io tax_price DECIMAL(14,4)
--OK
commit
--OK
alter column eba_io_init inp_price DECIMAL(14,4)
--OK
commit
--OK
alter column eba_io_init cost_price DECIMAL(14,4)
--OK
commit
--OK
alter column eba_price price DECIMAL(14,4)
--OK
commit
--OK
alter column sup_io inp_price DECIMAL(14,4)
--OK
commit
--OK
alter column sup_io discount_price DECIMAL(14,4)
--OK
commit
--OK
alter column sup_io tax_price DECIMAL(14,4)
--OK
commit
--OK
alter column sup_io_init inp_price DECIMAL(14,4)
--OK
commit
--OK
alter column sup_price_info price DECIMAL(14,4)
--OK
commit
--OK
alter column res in_ceil_price DECIMAL(14,4)
--OK
commit
--OK
alter column res in_ref_price DECIMAL(14,4)
--OK
commit
--OK
alter column res out_floor_price DECIMAL(14,4)
--OK
commit
--OK
alter column res out_ref_price DECIMAL(14,4)
--OK
commit
--OK
alter column res_unit_type_ext in_ceil_price DECIMAL(14,4)
--OK
commit
--OK
alter column res_unit_type_ext in_ref_price DECIMAL(14,4)
--OK
commit
--OK
alter column res_unit_type_ext out_floor_price DECIMAL(14,4)
--OK
commit
--OK
alter column res_unit_type_ext out_ref_price DECIMAL(14,4)
--OK
commit
--OK
alter column mio_account_io note_info VARCHAR(200)
--OK
alter column mio_account_io abstract VARCHAR(200)
--OK
alter column mio_oper_io_item abstract VARCHAR(200)
--OK
create table mio_v_loan ( voucher_id INT default 0 , account_id VARCHAR(8) , amount INT default 0 , loan_usage VARCHAR(80) , mio_oper_flag CHAR(1) , mio_subject_id VARCHAR(8) , ret_amount INT default 0 )
--OK
create unique index mio_v_loan_pri on mio_v_loan(voucher_id)
--OK
create table mio_v_loan_ret ( voucher_id INT default 0 , account_id VARCHAR(8) , amount INT default 0 , mio_oper_flag CHAR(1) , mio_subject_id VARCHAR(8) , ref_voucher_id INT default 0 , ref_voucher_no VARCHAR(20) )
--OK
create unique index mio_v_loan_ret_pri on mio_v_loan_ret(voucher_id)
--OK
delete from mio_v_loan
--OK
delete from mio_v_loan_ret
--OK
delete from ebs_v where voucher_type = 'FD' or voucher_type = 'FE'
--OK
select loan_id,voucher_no,amount,ret_amount,loan_usage,note_info,happen_date,state,dept_id,emp_id,create_date,create_user_id from mio_loan
--OK
add column ebs_vr_ctl eba_out_of_owe_lmt_flag CHAR(1)
--OK
update ebs_vr_ctl set eba_out_of_owe_lmt_flag='~'
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110615','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110615 over
Inv_Upgrade_20110621
create table mio_cycle ( cycle_id INT default 0 )
--OK
create unique index mio_cycle_pri on mio_cycle(cycle_id)
--OK
create table mio_cycle_account ( account_id VARCHAR(3) , cycle_id INT default 0 , amount INT default 0 )
--OK
create unique index mio_cycle_account_pri on mio_cycle_account(account_id,cycle_id)
--OK
add column qm_item is_str CHAR(1)
--OK
alter column qm_v_data val VARCHAR(20)
--OK
alter column ebm_bill note_info VARCHAR(200)
--OK
alter column ebm_io note_info VARCHAR(200)
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110621','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110621 over
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110626','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110626 over
Inv_Upgrade_20110630
alter column res res_name VARCHAR(80)
--OK
add column res create_date VARCHAR(8)
--OK
add column res create_user_id VARCHAR(8)
--OK
add column res last_modi_date VARCHAR(8)
--OK
add column res last_modi_user_id VARCHAR(8)
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110630','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110630 over
Inv_Upgrade_20110707
alter column res res_name VARCHAR(100)
--OK
alter column res res_spec VARCHAR(100)
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110707','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110707 over
Inv_Upgrade_20110714
add column eba create_user_id VARCHAR(8)
--OK
add column eba last_modi_date VARCHAR(8)
--OK
add column eba last_modi_user_id VARCHAR(8)
--OK
add column sup create_user_id VARCHAR(8)
--OK
add column sup last_modi_date VARCHAR(8)
--OK
add column sup last_modi_user_id VARCHAR(8)
--OK
alter column res res_model VARCHAR(100)
--OK
add column qm_v batch_no VARCHAR(30)
--OK
add column qm_v produce_date VARCHAR(8)
--OK
add column qm_list batch_no VARCHAR(30)
--OK
add column qm_list produce_date VARCHAR(8)
--OK
add column qm_item_list batch_no VARCHAR(30)
--OK
add column qm_item_list produce_date VARCHAR(8)
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110714','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110714 over
Inv_Upgrade_20110724
alter column eba address VARCHAR(160)
--OK
alter column sup address VARCHAR(160)
--OK
add column mio_oper_io eba_id VARCHAR(16)
--OK
add column mio_oper_io sup_id VARCHAR(16)
--OK
add column mio_account_io eba_id VARCHAR(16)
--OK
add column mio_account_io sup_id VARCHAR(16)
--OK
delete from app_para where para_id='soft_product_ver'
--OK
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20110724','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--OK
commit
--OK
inv upgrade to 20110724 over
Base_Upgrade_20110803
add column app_dept company_id VARCHAR(8)
--OK
create table app_company ( company_id VARCHAR(8) , company_name VARCHAR(60) , order_id INT default 0 , note_info VARCHAR(120) )
--OK
create unique index app_company_pri on app_company(company_id)
--OK
create table tbx_memory_type ( memory_type_id VARCHAR(8) , name VARCHAR(40) , user_id VARCHAR(8) , color_val INT default 0 )
--OK
create unique index tbx_memory_type_pri on tbx_memory_type(memory_type_id,user_id)
--OK
add column tbx_memory memory_type_id VARCHAR(8)
--OK
Inv_Upgrade_20110802
add column edt_res sub_attr_val_3 VARCHAR(30)
--OK
add column edt_res_init sub_attr_val_3 VARCHAR(30)
--OK
add column edt_io sub_attr_val_3 VARCHAR(30)
--OK
add column edt_eba_res sub_attr_val_3 VARCHAR(30)
--OK
add column edt_eba_io sub_attr_val_3 VARCHAR(30)
--OK
add column eba_io sub_attr_val_3 VARCHAR(30)
--OK
add column sup_io sub_attr_val_3 VARCHAR(30)
--OK
add column ebs_vr_item sub_attr_val_3 VARCHAR(30)
--OK
drop index edt_res edt_res_pri
--ERROR -100
--ERMSG 在表 'edt_res' 中没有这样的索引 'edt_res_pri'。
create unique index edt_res_pri on edt_res(res_id,edt_id,sub_attr_val_1,sub_attr_val_2,sub_attr_val_3,batch_no,edt_site_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','20110802','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110802 over
drop column res_catalog sub_attr_1
--NOT DONE, PRE ERROR
drop column res_catalog sub_attr_2
--NOT DONE, PRE ERROR
drop column res sub_attr_1
--NOT DONE, PRE ERROR
drop column res sub_attr_2
--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','20110803','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110803 over
Base_Upgrade_20110816
create table tbx_inform ( rec_id INT default 0 , inform_date VARCHAR(8) , inform_time VARCHAR(6) , inform_info TEXT , inform_state CHAR(1) , create_user_id VARCHAR(8) , create_date VARCHAR(8) )
--NOT DONE, PRE ERROR
create unique index tbx_inform_pri on tbx_inform(rec_id)
--NOT DONE, PRE ERROR
create table tbx_inform_reader ( rec_id INT default 0 , user_id VARCHAR(8) , send_date VARCHAR(8) , send_time VARCHAR(6) , send_flag CHAR(1) , read_date VARCHAR(8) , read_time VARCHAR(6) , read_flag CHAR(1) )
--NOT DONE, PRE ERROR
create unique index tbx_inform_reader_pri on tbx_inform_reader(rec_id,user_id)
--NOT DONE, PRE ERROR
Inv_Upgrade_20110816
create table evm_account_sep_cycle ( subject_id VARCHAR(20) , cycle_id VARCHAR(6) , sep_code VARCHAR(30) , org_amount DECIMAL(12,2) default 0, amount DECIMAL(12,2) default 0 , num DECIMAL(10,2) default 0 )
--NOT DONE, PRE ERROR
create unique index evm_account_sep_cycle_pri on evm_account_sep_cycle(subject_id,cycle_id,sep_code)
--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','20110816','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110816 over
Inv_Upgrade_20110901
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','20110901','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110901 over
Inv_Upgrade_20110905
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','20110905','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110905 over
Inv_Upgrade_20110912
alter column evm_abstract abstract VARCHAR(200)
--NOT DONE, PRE ERROR
alter column evm_v_item abstract VARCHAR(200)
--NOT DONE, PRE ERROR
alter column evm_io abstract VARCHAR(200)
--NOT DONE, PRE ERROR
alter column evm_init abstract VARCHAR(200)
--NOT DONE, PRE ERROR
add column ebs_vr project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column eba_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column sup_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column edt_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column mio_account_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebm_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
addcolumn ebm_bill project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebm_mio_item project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebs_vr_ctl show_project_id 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','20110912','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110912 over
Base_Upgrade_20110925
add column app_emp post_id VARCHAR(8)
--NOT DONE, PRE ERROR
add column oa_request obj_type VARCHAR(30)
--NOT DONE, PRE ERROR
add column oa_request obj_id VARCHAR(30)
--NOT DONE, PRE ERROR
add column app_voucher_type oa_request_type VARCHAR(8)
--NOT DONE, PRE ERROR
add column app_voucher_type check_mode CHAR(1)
--NOT DONE, PRE ERROR
Inv_Upgrade_20110925
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','20110925','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110925 over
Base_Upgrade_20111012
add column app_emp stop_flag 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','20111012','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111012 over
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','20111016','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111016 over
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','20111025','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111025 over
Base_Upgrade_20111028
add column ebs_v check_time VARCHAR(6)
--NOT DONE, PRE ERROR
add column ebs_v_log check_time VARCHAR(6)
--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','20111101','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111101 over
Inv_Upgrade_20111109
add column ebs_vr_ref_set order_id INT
--NOT DONE, PRE ERROR
Base_Upgrade_20111109
add column app_dict_sql sort_col VARCHAR(160)
--NOT DONE, PRE ERROR
add column app_dict_sql ext_col VARCHAR(80)
--NOT DONE, PRE ERROR
add column app_dict_sql ext_col_val VARCHAR(80)
--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','20111109','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111109 over
Inv_Upgrade_20111115
add column evm_subject stop_flag CHAR(1)
--NOT DONE, PRE ERROR
alter column ebm_mio_item note_info VARCHAR(200)
--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','20111115','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111115 over
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','20111121','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111121 over
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','20111128','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111128 over
Inv_Upgrade_20111208
add column eba_mem_card eba_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_mem_card address VARCHAR(160)
--NOT DONE, PRE ERROR
Base_Upgrade_20111208
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','20111208','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111208 over
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','20111209','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111209 over
Base_Upgrade_20111218
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('eba_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=121
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('sup_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=288
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('mio_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=240
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('ebm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=144
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('ebm_rep.pay','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=145
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('ebm_rep.recv','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=146
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('evm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=222
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('edt_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=160
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('crm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='IGFBA' where role_pri_id=105
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('emf_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=194
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('qm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=273
--NOT DONE, PRE ERROR
create table tbx_notebook_text ( notebook_id INT default 0 , order_id INT default 0 , info VARCHAR(200) )
--NOT DONE, PRE ERROR
create unique index tbx_notebook_text_pri on tbx_notebook_text(notebook_id,order_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','20111223','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111223 over
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','20120101','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120101 over
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','20120111','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120111 over
Inv_Upgrade_20120130
add column ebm_bill dept_id VARCHAR(8)
--NOT DONE, PRE ERROR
add column ebm_bill emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column ebm_io emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=1
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=2
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=3
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=4
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=5
--NOT DONE, PRE ERROR
alter column eba_io emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_vr emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_io_init emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_mem_card emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_contract emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_request emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_service emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column sup_io_init emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column sup_io emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column sup_contract emp_id VARCHAR(16)
--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','20120130','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120130 over
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','20120206','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120206 over
Inv_Upgrade_20120215
create table taobao_shop ( taobao_user_id VARCHAR(40) , user_name VARCHAR(60) , order_id INT default 0 , app_key VARCHAR(80) , session_key VARCHAR(80) )
--NOT DONE, PRE ERROR
create unique index taobao_shop_pri on taobao_shop(taobao_user_id)
--NOT DONE, PRE ERROR
create table taobao_app ( app_key VARCHAR(80) , app_secret VARCHAR(80) )
--NOT DONE, PRE ERROR
create unique index taobao_app_pri on taobao_app(app_key)
--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','20120215','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120215 over
curtime upgrade check ....
soft_product_id is 'oedt'
soft_product_ver is '20110724'
开始备份数据库 E:\edt_setup\db\000086_000083_01_正式库.mdb，目录 E:\edt_setup 请稍候
备份数据库 E:\edt_setup\db\000086_000083_01_正式库.mdb，目录 E:\edt_setup 成功
Base_Upgrade_20110803
add column app_dept company_id VARCHAR(8)
--OK
create table app_company ( company_id VARCHAR(8) , company_name VARCHAR(60) , order_id INT default 0 , note_info VARCHAR(120) )
--OK
create unique index app_company_pri on app_company(company_id)
--OK
create table tbx_memory_type ( memory_type_id VARCHAR(8) , name VARCHAR(40) , user_id VARCHAR(8) , color_val INT default 0 )
--OK
create unique index tbx_memory_type_pri on tbx_memory_type(memory_type_id,user_id)
--OK
add column tbx_memory memory_type_id VARCHAR(8)
--OK
Inv_Upgrade_20110802
add column edt_res sub_attr_val_3 VARCHAR(30)
--OK
add column edt_res_init sub_attr_val_3 VARCHAR(30)
--OK
add column edt_io sub_attr_val_3 VARCHAR(30)
--OK
add column edt_eba_res sub_attr_val_3 VARCHAR(30)
--OK
add column edt_eba_io sub_attr_val_3 VARCHAR(30)
--OK
add column eba_io sub_attr_val_3 VARCHAR(30)
--OK
add column sup_io sub_attr_val_3 VARCHAR(30)
--OK
add column ebs_vr_item sub_attr_val_3 VARCHAR(30)
--OK
drop index edt_res edt_res_pri
--ERROR -100
--ERMSG 在表 'edt_res' 中没有这样的索引 'edt_res_pri'。
create unique index edt_res_pri on edt_res(res_id,edt_id,sub_attr_val_1,sub_attr_val_2,sub_attr_val_3,batch_no,edt_site_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','20110802','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110802 over
drop column res_catalog sub_attr_1
--NOT DONE, PRE ERROR
drop column res_catalog sub_attr_2
--NOT DONE, PRE ERROR
drop column res sub_attr_1
--NOT DONE, PRE ERROR
drop column res sub_attr_2
--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','20110803','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110803 over
Base_Upgrade_20110816
create table tbx_inform ( rec_id INT default 0 , inform_date VARCHAR(8) , inform_time VARCHAR(6) , inform_info TEXT , inform_state CHAR(1) , create_user_id VARCHAR(8) , create_date VARCHAR(8) )
--NOT DONE, PRE ERROR
create unique index tbx_inform_pri on tbx_inform(rec_id)
--NOT DONE, PRE ERROR
create table tbx_inform_reader ( rec_id INT default 0 , user_id VARCHAR(8) , send_date VARCHAR(8) , send_time VARCHAR(6) , send_flag CHAR(1) , read_date VARCHAR(8) , read_time VARCHAR(6) , read_flag CHAR(1) )
--NOT DONE, PRE ERROR
create unique index tbx_inform_reader_pri on tbx_inform_reader(rec_id,user_id)
--NOT DONE, PRE ERROR
Inv_Upgrade_20110816
create table evm_account_sep_cycle ( subject_id VARCHAR(20) , cycle_id VARCHAR(6) , sep_code VARCHAR(30) , org_amount DECIMAL(12,2) default 0 , amount DECIMAL(12,2) default 0 , num DECIMAL(10,2) default 0 )
--NOT DONE, PRE ERROR
create unique index evm_account_sep_cycle_pri on evm_account_sep_cycle(subject_id,cycle_id,sep_code)
--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','20110816','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110816 over
Inv_Upgrade_20110901
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','20110901','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110901 over
Inv_Upgrade_20110905
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','20110905','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110905 over
Inv_Upgrade_20110912
alter column evm_abstract abstract VARCHAR(200)
--NOT DONE, PRE ERROR
alter column evm_v_item abstract VARCHAR(200)
--NOT DONE, PRE ERROR
alter column evm_io abstract VARCHAR(200)
--NOT DONE, PRE ERROR
alter column evm_init abstract VARCHAR(200)
--NOT DONE, PRE ERROR
add column ebs_vr project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column eba_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column sup_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column edt_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column mio_account_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebm_io project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebm_bill project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebm_mio_item project_id VARCHAR(20)
--NOT DONE, PRE ERROR
add column ebs_vr_ctl show_project_id 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','20110912','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110912 over
Base_Upgrade_20110925
add column app_emp post_id VARCHAR(8)
--NOT DONE, PRE ERROR
add column oa_request obj_type VARCHAR(30)
--NOT DONE, PRE ERROR
add column oa_request obj_id VARCHAR(30)
--NOT DONE, PRE ERROR
add column app_voucher_type oa_request_type VARCHAR(8)
--NOT DONE, PRE ERROR
add column app_voucher_type check_mode CHAR(1)
--NOT DONE, PRE ERROR
Inv_Upgrade_20110925
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','20110925','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20110925 over
Base_Upgrade_20111012
add column app_emp stop_flag 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','20111012','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111012 over
delete from app_parawhere 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','20111016','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111016 over
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','20111025','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111025 over
Base_Upgrade_20111028
add column ebs_v check_time VARCHAR(6)
--NOT DONE, PRE ERROR
add column ebs_v_log check_time VARCHAR(6)
--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','20111101','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111101 over
Inv_Upgrade_20111109
add column ebs_vr_ref_set order_id INT
--NOT DONE, PRE ERROR
Base_Upgrade_20111109
add column app_dict_sql sort_col VARCHAR(160)
--NOT DONE, PRE ERROR
add column app_dict_sql ext_col VARCHAR(80)
--NOT DONE, PRE ERROR
add column app_dict_sql ext_col_val VARCHAR(80)
--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','20111109','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111109 over
Inv_Upgrade_20111115
add column evm_subject stop_flag CHAR(1)
--NOT DONE, PRE ERROR
alter column ebm_mio_item note_info VARCHAR(200)
--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','20111115','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111115 over
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','20111121','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111121 over
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','20111128','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111128 over
Inv_Upgrade_20111208
add column eba_mem_card eba_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_mem_card address VARCHAR(160)
--NOT DONE, PRE ERROR
Base_Upgrade_20111208
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','20111208','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111208 over
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','20111209','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111209 over
Base_Upgrade_20111218
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('eba_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=121
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('sup_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=288
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('mio_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=240
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('ebm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=144
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('ebm_rep.pay','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=145
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('ebm_rep.recv','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=146
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('evm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=222
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('edt_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=160
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('crm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='IGFBA' where role_pri_id=105
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('emf_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=194
--NOT DONE, PRE ERROR
insert into mup_modu_obj_action(obj_id,action_id,action_name) values('qm_rep','I','打印格式定义')
--NOT DONE, PRE ERROR
update mup_role_priv set actions='LIGFA' where role_pri_id=273
--NOT DONE, PRE ERROR
create table tbx_notebook_text ( notebook_id INT default 0 , order_id INT default 0 , info VARCHAR(200) )
--NOT DONE, PRE ERROR
create unique index tbx_notebook_text_pri on tbx_notebook_text(notebook_id,order_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','20111223','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20111223 over
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','20120101','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120101 over
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','20120111','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120111 over
Inv_Upgrade_20120130
add column ebm_bill dept_id VARCHAR(8)
--NOT DONE, PRE ERROR
add column ebm_bill emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column ebm_io emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=1
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=2
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=3
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=4
--NOT DONE, PRE ERROR
update ebm_bill set dept_id='003',emp_id='003' where bill_id=5
--NOT DONE, PRE ERROR
alter column eba_io emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_vr emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_io_init emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_mem_card emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_contract emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_request emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column eba_service emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column sup_io_init emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column sup_io emp_id VARCHAR(16)
--NOT DONE, PRE ERROR
alter column sup_contract emp_id VARCHAR(16)
--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','20120130','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120130 over
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','20120206','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120206 over
Inv_Upgrade_20120215
create table taobao_shop ( taobao_user_id VARCHAR(40) , user_name VARCHAR(60) , order_id INT default 0 , app_key VARCHAR(80) , session_key VARCHAR(80) )
--NOT DONE, PRE ERROR
create unique index taobao_shop_pri on taobao_shop(taobao_user_id)
--NOT DONE, PRE ERROR
create table taobao_app ( app_key VARCHAR(80) , app_secret VARCHAR(80) )
--NOT DONE, PRE ERROR
create unique index taobao_app_pri on taobao_app(app_key)
--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','20120215','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
inv upgrade to 20120215 over |
