===== Pridanie nového zakaznika do back-endu na servri =====

  * Vytvorit na DB serveri rolu pre noveho zakaznika (cez phpPgAdmin napr)
  * Nastavit "default" prava (teda prava ktore dostanu DB objekty, ktore vzniknu v buducnosti. **Je potrebne zamenit user za vhodneho uzivatela**, kedze dopravca ma osobitny account do samostatnej instancie:
<code>
ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE ALL ON TABLES FROM PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE ALL ON SEQUENCES FROM PUBLIC;
ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE ALL ON FUNCTIONS FROM PUBLIC;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO transdata;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO transdata;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT EXECUTE ON FUNCTIONS TO transdata;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO stalker;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON SEQUENCES TO stalker;

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT EXECUTE ON FUNCTIONS TO user;

-- Niekedy sa stavalo ze nenastavilo po vytvoreni prava nad tabulkami. Tento prikaz ich nastavi spravne:
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user;

-- Pri vytvarani sa stavalo ze nenastavilo prava na sekvencie. Tento prikaz ich nastavi spravne:
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public to user;
</code>

Tento sql skript ulozit aj na server (**zamenit v ceste "zakaznik" za nazov zakaznika**)
<code>
/DokumentaciaTD/VyvojovyUsek/VyvojSW/TransFare/TransFare_Inspection/back-end/company_specific_scripts/zakaznik/privileges.sql
</code>
  * Import databazy z dumpu:

<code>/DokumentaciaTD/VyvojovyUsek/VyvojSW/TransFare/TransFare_Inspection/back-end/dump databazy</code>
Treba davat pozor na to, ze sa v dumpe nachadza aktualna verzia DBS. Ta je ulozena v tabulke versions. Najlepsie je vzdy overit voci niektorej ostrej uz nainstalovanej verzii.

  * vytvorit a spustit skript, ktory do databazy vlozi nastavenia specificke pre zakaznika (zamenit v ceste "zakaznik" za nazov zakaznika)
<code>
/DokumentaciaTD/VyvojovyUsek/VyvojSW/TransFare/TransFare_Inspection/back-end/company_specific_scripts/zakaznik/app_settings.sql
</code>