1 drop view if exists parovi;
2 drop view if exists rpcou;
3 drop view if exists citingu;
4 drop view if exists citiraniu;
5 drop view if exists radoviu;
7 drop table if exists utca;
14 drop table if exists cited;
27 drop table if exists authors;
28 create table authors (
36 drop table if exists radovi;
59 drop table if exists radoviau;
60 create table radoviau (
65 drop table if exists citing;
87 drop table if exists rpco;
95 drop table if exists citirani;
96 create table citirani (
110 create view citingu as select distinct ut,pt,au,so,la,dt,nr,tc,pi,py,di,sc,rp from citing ;
112 create view radoviu as select distinct ut,pt,au,so,la,dt,nr,tc,pi,py,di,sc,rp from radovi ;
114 create view rpcou as select distinct * from rpco ;
116 create view parovi as select distinct citirani.ca,
117 citirani.cr_full as cr,
132 left join cited on citirani.cr_full = cited.cr_full
133 left join citingu on cited.ut = citingu.ut
134 left join rpcou on cited.ut = rpcou.ut
137 create view citiraniu as select distinct cr_auth,cr_ref,cr_year,cr_vol,cr_page,catc,cr_full,isi from citirani ;
140 drop table if exists cropsy;
141 create table cropsy (
151 drop table if exists jcr;
166 drop table if exists izbori;
167 create table izbori (
175 -- CREATE AGGREGATE array_accum (anyelement)
177 -- sfunc = array_append,
182 -- select d, count(*),
183 -- array_to_string(array_accum('+'::text),'') as graph
184 -- from hits group by 1 order by 1 asc;
187 -- create index cited_au on cited(au);
188 -- create index cited_cited on cited(cited);