projects
/
webpac2
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
local
[webpac2]
/
conf
/
isi
/
cited.sql
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 (
12
id serial,
13
cited_au text,
14
from_au text,
15
ut text,
16
cited_full text
17
);
18
19
drop table if exists authors;
20
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