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

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

trunk/conf/isi/cited.sql revision 1208 by dpavlin, Fri May 29 21:41:37 2009 UTC trunk/conf/dipl/cited.sql revision 1272 by mglavica, Tue Aug 11 13:05:35 2009 UTC
# Line 1  Line 1 
1    drop table if exists utca;
2    
3    create table utca (
4            id serial,
5            ut text,
6            ca text,
7    );
8    
9    drop table if exists cited;
10    
11  create table cited (  create table cited (
12          id serial,          id serial,
13          au text not null,          cited_au text,
14          cited text not null          from_au text,
15            ut text,
16            cited_full text
17  );  );
18    
19  create index cited_au on cited(au);  drop table if exists authors;
20  create index cited_cited on cited(cited);  
21    create table authors (
22            id serial,
23            au text not null
24    );
25    
26    
27    drop table if exists citing;
28    
29    create table citing (
30            id serial,
31            ut text,
32            ca text,
33            pt text,
34            au text,
35            af text,
36            ti text,
37            so text,
38            la text,
39            dt text,
40            c1 text,
41            rp text,
42            cr text,
43            nr integer,
44            pi text,
45            py integer,
46            sc text
47    );
48    
49    
50    -- create index cited_au on cited(au);
51    -- create index cited_cited on cited(cited);
52    
Legend:
Removed from v.1208  
changed lines
  Added in v.1272
  ViewVC Help
Powered by ViewVC 1.1.26