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

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

revision 1208 by dpavlin, Fri May 29 21:41:37 2009 UTC revision 1210 by dpavlin, Sat May 30 15:26:25 2009 UTC
# Line 1  Line 1 
1    drop table if exists cited;
2    
3  create table cited (  create table cited (
4          id serial,          id serial,
5          au text not null,          cited_au text not null,
6          cited text not null          from_au text not null
7    );
8    
9    drop table if exists authors;
10    
11    create table authors (
12            id serial,
13            au text not null
14  );  );
15    
16  create index cited_au on cited(au);  -- create index cited_au on cited(au);
17  create index cited_cited on cited(cited);  -- create index cited_cited on cited(cited);
18    

Legend:
Removed from v.1208  
changed lines
  Added in v.1210

  ViewVC Help
Powered by ViewVC 1.1.26