/[hr-web]/sql/DB-SEQ
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /sql/DB-SEQ

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by ravilov, Wed Jun 19 16:38:10 2002 UTC revision 1.2 by ravilov, Wed Jun 19 18:24:41 2002 UTC
# Line 1  Line 1 
 SELECT setval('certifikati_sif_edukacije_seq', (SELECT max(sif_edukacije) FROM certifikati));  
 SELECT setval('edukacije_sifra_seq', (SELECT max(sifra) FROM edukacije));  
1  SELECT setval('izvan_plive_id_seq', (SELECT max(id) FROM izvan_plive));  SELECT setval('izvan_plive_id_seq', (SELECT max(id) FROM izvan_plive));
2  SELECT setval('nagrade_id_seq', (SELECT max(id) FROM nagrade));  SELECT setval('nagrade_id_seq', (SELECT max(id) FROM nagrade));
 SELECT setval('obrazovna_ustanova_sifra_seq', (SELECT max(sifra) FROM obrazovna_ustanova));  
3  SELECT setval('osoba_sif_radnika_seq', (SELECT max(sif_radnika) FROM osoba));  SELECT setval('osoba_sif_radnika_seq', (SELECT max(sif_radnika) FROM osoba));
4  SELECT setval('patenti_sifra_seq', (SELECT max(sifra) FROM patenti));  SELECT setval('patenti_sifra_seq', (SELECT max(sifra) FROM patenti));
5  SELECT setval('qualification_sifra_seq', (SELECT max(sifra) FROM qualification));  SELECT setval('qualification_sifra_seq', (SELECT max(sifra) FROM qualification));
 SELECT setval('radovi_rbr_seq', (SELECT max(rbr) FROM radovi));  
6  SELECT setval('strani_jezik_sifra_seq', (SELECT max(sifra) FROM strani_jezik));  SELECT setval('strani_jezik_sifra_seq', (SELECT max(sifra) FROM strani_jezik));
7  SELECT setval('strucne_sprem_sif_str_sprem_seq', (SELECT max(sif_str_spreme) FROM strucne_spreme));  SELECT setval('strucne_sprem_sif_str_sprem_seq', (SELECT max(sif_str_spreme) FROM strucne_spreme));
 SELECT setval('strucni_skupovi_rbr_seq', (SELECT max(rbr) FROM strucni_skupovi));  
8  SELECT setval('stupanj_str_jezika_sifra_seq', (SELECT max(sifra) FROM stupanj_str_jezika));  SELECT setval('stupanj_str_jezika_sifra_seq', (SELECT max(sifra) FROM stupanj_str_jezika));
9  SELECT setval('tecajevi_sifra_seq', (SELECT max(sifra) FROM tecajevi));  SELECT setval('tecajevi_sifra_seq', (SELECT max(sifra) FROM tecajevi));
10  SELECT setval('u_plivi_id_seq', (SELECT max(id) FROM u_plivi));  SELECT setval('u_plivi_id_seq', (SELECT max(id) FROM u_plivi));
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.26