Parent Directory | Revision Log | Patch
revision 1274 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; |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |