/[webpac2]/trunk/conf/dipl/schema.sql
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 /trunk/conf/dipl/schema.sql

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

revision 1278 by mglavica, Wed Aug 19 15:59:04 2009 UTC revision 1279 by mglavica, Thu Aug 27 17:33:41 2009 UTC
# Line 73  create table citirani ( Line 73  create table citirani (
73          cr_page text,          cr_page text,
74          ttc integer,          ttc integer,
75          cr text,          cr text,
76          can text          can text,
77            isi text
78  );  );
79    
80  create view citingu as select distinct ut,pt,au,so,la,dt,nr,tc,pi,py,di,sc,rp from citing ;  create view citingu as select distinct ut,pt,au,so,la,dt,nr,tc,pi,py,di,sc,rp from citing ;
# Line 101  left join citingu on cited.ut = citingu. Line 102  left join citingu on cited.ut = citingu.
102  left join rpcou on cited.ut = rpcou.ut  left join rpcou on cited.ut = rpcou.ut
103  ;  ;
104    
105  create view citiraniu as select distinct cr_auth,cr_ref,cr_year,cr_vol,cr_page,ttc,cr from citirani ;  create view citiraniu as select distinct cr_auth,cr_ref,cr_year,cr_vol,cr_page,ttc,cr,isi from citirani ;
106    
107    
108  drop table if exists cropsy;  drop table if exists cropsy;
Legend:
Removed from v.1278  
changed lines
  Added in v.1279
  ViewVC Help
Powered by ViewVC 1.1.26