aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSergey Poznyakoff <gray@gnu.org.ua>2004-06-19 17:08:04 +0000
committerSergey Poznyakoff <gray@gnu.org.ua>2004-06-19 17:08:04 +0000
commit41535b56f92b7283f539a3de48614cedafac4c17 (patch)
tree150917a32bdc00667fd4da7f732d4a6f221b3ba9
parent23ffe85572bdd40e7e9a571d70e39dcba31bb6a3 (diff)
downloadellinika-41535b56f92b7283f539a3de48614cedafac4c17.tar.gz
ellinika-41535b56f92b7283f539a3de48614cedafac4c17.tar.bz2
* data/db.struct: New table 'pos' keeps information about
parts of speech. Dict.pos changed: the part of speech of each dictionary entry is strored as a bitmask, e.g. verb|transitive or substanive|masculine, etc. This facilitates searches and makes the database more flexible. git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@143 941c8c0f-9102-463b-b60b-cd22ce0e6858
-rw-r--r--data/db.struct48
1 files changed, 47 insertions, 1 deletions
diff --git a/data/db.struct b/data/db.struct
index 3159d36..9d38bd6 100644
--- a/data/db.struct
+++ b/data/db.struct
@@ -1,11 +1,57 @@
CREATE DATABASE ellinika;
use ellinika
+CREATE TABLE pos(
+ id bigint not null, # REL 0
+ name char(64) not null,
+ abbr char(12) not null,
+ abbr_lat char(12) not null,
+ canonical enum('Y','N') not null default 'Y',
+ INDEX(id),
+ INDEX(abbr)
+);
+
+# where pos=0
+INSERT INTO pos VALUES(0, "άρθρο", "άρθρ.", "art", 'Y');
+
+INSERT INTO pos VALUES(conv("100",16,10), "ουσιαστικό", "ουσ.", "subst", 'Y');
+INSERT INTO pos VALUES(conv("101",16,10), "αρσενικό", "ο", "m", 'Y');
+INSERT INTO pos VALUES(conv("102",16,10), "θηλυκό", "η", "f", 'Y');
+INSERT INTO pos VALUES(conv("104",16,10), "ουδέτερο", "το", "n", 'Y');
+INSERT INTO pos VALUES(conv("101",16,10)|2, "αρσενικό και θηλυκό", "ο/η", "m/f", 'N');
+INSERT INTO pos VALUES(conv("101",16,10)|2, "αρσενικό και θηλυκό", "ο,η", "m,f", 'Y');
+INSERT INTO pos VALUES(conv("101",16,10)|2|4,"αρσενικό,θηλυκό,ουδέτερο", "ο,η,το", "m,f,n", 'N');
+INSERT INTO pos VALUES(conv("114",16,10), "πληθυντικό ουδέτερο", "τα", "pl.n", 'Y');
+
+INSERT INTO pos VALUES(conv("200",16,10), "επίθετο", "επίθ.", "adj", 'Y');
+
+INSERT INTO pos VALUES(conv("400",16,10), "επίρρημα", "επίρρ.", "adv", 'Y');
+
+INSERT INTO pos VALUES(conv("800",16,10), "αριθμός", "αριθ.", "num", 'Y');
+
+INSERT INTO pos VALUES(conv("1000",16,10), "αντωνυμία", "αντων.", "pron", 'Y');
+
+INSERT INTO pos VALUES(conv("100000",16,10), "ρήμα", "ρήμα", "v", 'Y');
+INSERT INTO pos VALUES(conv("110000",16,10), "μεταβατικό", "μετ.", "vt", 'Y');
+INSERT INTO pos VALUES(conv("120000",16,10), "αμετάβατο", "αμετ.", "vi", 'Y');
+INSERT INTO pos VALUES(conv("140000",16,10), "απρώσοπο", "απρώσ.", "vimp", 'Y');
+INSERT INTO pos VALUES(conv("180000",16,10), "αποθετικό", "αποθ.", "vdep", 'Y');
+
+INSERT INTO pos VALUES(conv("200000",16,10), "επιφώνημα", "επιφ.", "int", 'Y');
+
+INSERT INTO pos VALUES(conv("400000",16,10), "μετοχή", "μετχ.", "part", 'Y');
+
+INSERT INTO pos VALUES(conv("800000",16,10), "μόριο", "μόριο.", "ptc", 'Y');
+
+INSERT INTO pos VALUES(conv("1000000",16,10), "πρόθεση", "πρόθ.", "prep", 'Y');
+
+INSERT INTO pos VALUES(conv("2000000",16,10), "σύνδεσμος", "σύνδ.", "conj", 'Y');
+
CREATE TABLE dict(
ident int(32), # REL 1
word varchar(128) binary,
sound varchar(128) binary,
- pos varchar(64),
+ pos int(4), # REL 0
forms blob,
INDEX (ident),
INDEX (word)

Return to:

Send suggestions and report system problems to the System administrator.