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