aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSergey Poznyakoff <gray@gnu.org.ua>2004-06-21 09:55:22 +0000
committerSergey Poznyakoff <gray@gnu.org.ua>2004-06-21 09:55:22 +0000
commit46db0a002858a7d00401d08ded5e505c50084586 (patch)
tree8e350a3317e881c1f6047d52ec64307da1d6a91c
parent1f65166b9cb2cea4c253902f59ff99b8270c0791 (diff)
downloadellinika-46db0a002858a7d00401d08ded5e505c50084586.tar.gz
ellinika-46db0a002858a7d00401d08ded5e505c50084586.tar.bz2
(antonym,xref): Replaced by 'links'
(pending_links): New table. Keeps unresolved links. git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@155 941c8c0f-9102-463b-b60b-cd22ce0e6858
-rw-r--r--data/db.struct23
1 files changed, 12 insertions, 11 deletions
diff --git a/data/db.struct b/data/db.struct
index 9d38bd6..afb5eee 100644
--- a/data/db.struct
+++ b/data/db.struct
@@ -11,7 +11,6 @@ CREATE TABLE pos(
INDEX(abbr)
);
-# where pos=0
INSERT INTO pos VALUES(0, "άρθρο", "άρθρ.", "art", 'Y');
INSERT INTO pos VALUES(conv("100",16,10), "ουσιαστικό", "ουσ.", "subst", 'Y');
@@ -48,8 +47,8 @@ INSERT INTO pos VALUES(conv("1000000",16,10), "πρόθεση", "πρόθ.
INSERT INTO pos VALUES(conv("2000000",16,10), "σύνδεσμος", "σύνδ.", "conj", 'Y');
CREATE TABLE dict(
- ident int(32), # REL 1
- word varchar(128) binary,
+ ident int(32), # REL 1,3
+ word varchar(128) binary, # REL 4
sound varchar(128) binary,
pos int(4), # REL 0
forms blob,
@@ -79,14 +78,8 @@ CREATE TABLE topic_tab (
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(
+CREATE TABLE links(
+ type enum('XREF','ANT') not null,
ident int(32) not null, # REL 1
xref int(32) not null, # REL 1
INDEX (ident),
@@ -97,3 +90,11 @@ CREATE TABLE stat(
updated datetime not null,
count int(32) not null
);
+
+CREATE TABLE pending_links(
+ type enum('CLOSED','XREF','ANT') not null,
+ originator int(32) not null, # REL 3
+ word varchar(128) binary, # REL 4
+);
+
+

Return to:

Send suggestions and report system problems to the System administrator.