--przenumerowanie wszystkiego w systemie co narodzil sklep.

-- ... bo jakiś cretino nie ustawił sekwencji 

drop table new_dok_ka;
drop table new_p_dok_ka;
drop table new_dok_sp_spo_pl;
drop table new_dok_ma;
drop table new_p_dok_ma;
drop table new_p_dok_sp;
drop table new_dok_sp;
drop table new_dok_re;


create table new_dok_ka as select * from dok_ka where id<'57250000';
create table new_p_dok_ka as select * from p_dok_ka where dok_ka_id<'57250000';

create table new_dok_sp_spo_pl as select * from dok_sp_spo_pl where dok_sp_id<'57250000';

create table new_dok_ma as select * from dok_ma where id >'50000000' and id<'57250000';
create table new_p_dok_ma as select * from p_dok_ma where dok_ma_id >'50000000' and dok_ma_id<'57250000';

create table new_p_dok_sp as select * from p_dok_sp where dok_sp_id>'50000000' and dok_sp_id<'57250000';
create table new_dok_sp as select * from dok_sp where id >'50000000' and id<'57250000';

create table new_dok_re as select * from dok_re where id >'50000000' and id<'57250000';


--dok_sp
update new_dok_sp set id=id+1000000;
update new_dok_sp set dat_p=null where id >'50000000' and id<'57250000';

update new_p_dok_sp set dok_sp_id=dok_sp_id+1000000;
update new_p_dok_sp set p_dok_sp_dok_sp_id=p_dok_sp_dok_sp_id+1000000;

update new_dok_sp set dok_sp_id=dok_sp_id+1000000 where dok_sp_id is not null;

--dok_re

update new_dok_re set id=id+1000000;
update new_dok_re set dok_sp_id=dok_sp_id+1000000 where dok_sp_id<'57250000';

--dok_ma
update new_dok_ma set id=id+1000000 where id >'50000000' and id<'57250000';
update new_dok_ma set dat_p=null where id >'50000000' and id<'57250000';

update new_dok_ma set dok_ma_id=dok_ma_id+1000000 where dok_ma_id is not null and dok_ma_id >'50000000' and dok_ma_id<'5725000
0';

update new_dok_ma set dok_sp_id=dok_sp_id+1000000 where dok_sp_id is not null and dok_sp_id >'50000000' and dok_sp_id<'5725000
0';

--dok_ka
update new_dok_ka set id=id+1000000 where id >'50000000' and id<'57250000';
update new_p_dok_ka set dok_ka_id=dok_ka_id+1000000 where dok_ka_id >'50000000' and dok_ka_id<'57250000';
update new_p_dok_ka set tab_id=tab_id+1000000 where tab_id >'50000000' and tab_id<'57250000';

--dok_sp_spo_pl
update new_dok_sp_spo_pl set dok_sp_id=dok_sp_id+1000000 where dok_sp_id>'50000000' and dok_sp_id<'57250000';

--wstawianie
--naglowki dok_sp, dok_ma

--wlasciwe poprawki, modlmy sie...
--begin;
insert into dok_sp select * from new_dok_sp;
insert into dok_ma select * from new_dok_ma;


--odblokowanie dok_sp/dok_ma

update dok_sp set dat_p=null where id >'50000000' and id<'57250000';
update dok_ma set dat_p=null where id >'50000000' and id<'57250000';


--pozycje dok_sp; wstawienie
insert into p_dok_sp select * from new_p_dok_sp;

--pozycje dok_ma; przesuniecie
update p_dok_ma set dok_ma_id=dok_ma_id+1000000 where dok_ma_id is not null and dok_ma_id >'50000000' and dok_ma_id<'57250000'
;

update p_dok_ma set p_dok_sp_dok_sp_id=p_dok_sp_dok_sp_id+1000000 where p_dok_sp_dok_sp_id is not null and p_dok_sp_dok_sp_id
>'50000000' and p_dok_sp_dok_sp_id<'57250000';


--skasowanie starych pozycji z dok_sp, teraz juz mozna to zrobic, %&^%^$^&%!!
update p_dok_sp set p_dok_sp_dok_sp_id=null where dok_sp_id>'50000000' and dok_sp_id<'57250000';
--update p_dok_sp set dok_sp_id=dok_sp_id+1000000 where dok_sp_id>'50000000' and dok_sp_id<'57250000';


--teraz mozna skasowac. :S
delete from p_dok_sp where dok_sp_id>'50000000' and dok_sp_id<'57250000';

--kasa 
insert into dok_ka select * from new_dok_ka;
insert into p_dok_ka select * from new_p_dok_ka;

--pdk_dod. aaaargh! ^#$%#&%$!
update pdk_dod set p_dok_ka_dok_ka_id=p_dok_ka_dok_ka_id+1000000 where p_dok_ka_dok_ka_id>'50000000' and
p_dok_ka_dok_ka_id<'57250000';

--dok_ka_kar
update dok_ka_kar set dok_ka_id=dok_ka_id+1000000;


delete from p_dok_ka where dok_ka_id >'50000000' and dok_ka_id<'57250000';
delete from dok_ka where  id >'50000000' and id<'57250000';

--spo_pl . grrrr, to sie robi irytujace :X

insert into dok_sp_spo_pl select * from new_dok_sp_spo_pl;
delete from dok_sp_spo_pl where dok_sp_id>'50000000' and dok_sp_id<'57250000';

--potwierdzenie dok-sp/dok-ma

--dok_re  .........

insert into dok_re select * from new_dok_re;

update rek_st set dok_re_id=dok_re_id+1000000 where dok_re_id >'50000000' and dok_re_id<'57250000';

delete from dok_re where id>'50000000' and id<'57250000';

delete from dok_ma where id >'50000000' and id<'57250000';
delete from dok_sp where id >'50000000' and id<'57250000';

update dok_sp set dat_p='2007-09-29' where id >'50000000' and id<'56750200';
update dok_ma set dat_p='2007-09-29' where id >'50000000' and id<'56750200';


delete from dok_ma where id >'50000000' and id<'57250000';

delete from dok_sp_spo_pl where dok_sp_id>'50000000' and dok_sp_id<'57250000';
delete from dok_sp where id >'50000000' and id<'57250000';


--i koniec rzeźby :]
--kthxbye