Parent Directory | Revision Log
diploma work - changing the name of conf directory
1 | mglavica | 1230 | drop table if exists utca; |
2 | |||
3 | create table utca ( | ||
4 | id serial, | ||
5 | ut text, | ||
6 | ca text, | ||
7 | ); | ||
8 | |||
9 | dpavlin | 1210 | drop table if exists cited; |
10 | |||
11 | dpavlin | 1208 | create table cited ( |
12 | id serial, | ||
13 | mglavica | 1230 | cited_au text, |
14 | from_au text, | ||
15 | ut text, | ||
16 | cited_full text | ||
17 | dpavlin | 1208 | ); |
18 | |||
19 | dpavlin | 1210 | drop table if exists authors; |
20 | dpavlin | 1208 | |
21 | dpavlin | 1210 | create table authors ( |
22 | id serial, | ||
23 | au text not null | ||
24 | ); | ||
25 | |||
26 | mglavica | 1230 | |
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 | dpavlin | 1210 | -- create index cited_au on cited(au); |
51 | -- create index cited_cited on cited(cited); | ||
52 |
Name | Value |
---|---|
svn:mergeinfo |
ViewVC Help | |
Powered by ViewVC 1.1.26 |