alter table t_deposit_rule add stype varchar2(5) default 2; alter table t_deposit_rule add versions varchar2(20) ; alter table t_deposit_area add stype varchar2(5) default 1; alter table t_orders add versions_rule varchar2(50); alter table t_orders add stype varchar2(50); create sequence seq_deposit_rule_lv_id increment by 1 start with 1 nomaxvalue nominvalue nocache; create sequence seq_deposit_rule_versions_id increment by 1 start with 1 nomaxvalue nominvalue nocache; select seq_deposit_rule_versions_id.NEXTVAL from dual; update t_deposit_rule set versions=1; update t_orders set stype=1,versions_rule=1 where ordersource in (504,502); update t_deposit_rule set lv=''; alter table t_deposit_rule modify (lv NUMBER(20)); update t_deposit_rule set lv=1 where id=6; update t_deposit_rule set lv=2 where id=7; update t_deposit_rule set lv=9 where id=29; update t_deposit_rule set lv=11 where id=36; update t_deposit_rule set lv=4 where id=9; update t_deposit_rule set lv=1 where id=10; update t_deposit_rule set lv=3 where id=8; update t_deposit_rule set lv=5 where id=14; update t_deposit_rule set lv=6 where id=15; update t_deposit_rule set lv=7 where id=16; update t_deposit_rule set lv=12 where id=37; update t_deposit_rule set lv=8 where id=28; update t_deposit_rule set lv=7 where id=27; update t_deposit_rule set lv=11 where id=33; update t_deposit_rule set lv=9 where id=34; update t_deposit_rule set lv=10 where id=35;