aboutsummaryrefslogtreecommitdiff
path: root/data/db.struct
blob: 3159d3690704b1f054613460cb318538e0646418 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
CREATE DATABASE ellinika;
use ellinika

CREATE TABLE dict(
  ident         int(32),                    # REL 1
  word          varchar(128) binary,
  sound         varchar(128) binary,
  pos           varchar(64),
  forms         blob,
  INDEX (ident),
  INDEX  (word)
);

CREATE TABLE articles(
  ident         int(32) not null,           # REL 1
  subindex      int(32) not null,
  meaning       blob,
  INDEX (ident),
  INDEX  (subindex)
);  

CREATE TABLE topic(
 ident         int(32) not null auto_increment, # REL 2
 title         varchar(128) not null,
 UNIQUE  (ident),
 INDEX   (title)
);

CREATE TABLE topic_tab (
 topic_ident    int(32) not null,               # REL 2 
 word_ident     int(32) not null,               # REL 1
 INDEX    (topic_ident),
 INDEX    (word_ident)
);

CREATE TABLE antonym(
 ident    int(32) not null,                     # REL 1
 antonym  int(32) not null,                     # REL 1
 INDEX    (ident),
 UNIQUE   (ident,antonym)
);

CREATE TABLE xref(
 ident    int(32) not null,                     # REL 1
 xref     int(32) not null,                     # REL 1
 INDEX    (ident),
 UNIQUE   (ident,xref)
);

CREATE TABLE stat(
 updated datetime not null,
 count int(32) not null
);

Return to:

Send suggestions and report system problems to the System administrator.