BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
            job_name => '"PAXDATA"."AKTUALIZUJ_BIALA_LISTE"',
            job_type => 'PLSQL_BLOCK',
            job_action => 'begin
  PKG_JSON_TOOLS.AktualizujBialaListe;
end;',
            number_of_arguments => 0,
            start_date => NULL,
            repeat_interval => 'FREQ=DAILY;BYTIME=070000;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN',
            end_date => NULL,
            enabled => FALSE,
            auto_drop => FALSE,
            comments => '');

    DBMS_SCHEDULER.SET_ATTRIBUTE( 
             name => '"PAXDATA"."AKTUALIZUJ_BIALA_LISTE"', 
             attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);
  
    DBMS_SCHEDULER.enable(
             name => '"PAXDATA"."AKTUALIZUJ_BIALA_LISTE"');
END;
/
ALTER TABLE paxdata.operator ADD CONSTRAINT oper__un UNIQUE ( login );
/
ALTER TABLE paxdata.kontrahent_rachunek ADD ( slwa_id NUMBER DEFAULT 1 NOT NULL );
/
ALTER TABLE paxdata.kontrahent_rachunek ADD CONSTRAINT kora_slwa_fk FOREIGN KEY ( slwa_id ) REFERENCES paxdata.slo_waluta ( id ) NOT DEFERRABLE;
/
ALTER TABLE UMOWA DROP CONSTRAINT UMOW__UN;
/
grant select on paxdata.planeta_req to paxpars;
/

