From 3db1451f587869006f3c1aee564a23cc1774e6fe Mon Sep 17 00:00:00 2001 From: Sergey Poznyakoff Date: Wed, 13 Oct 2004 12:37:25 +0000 Subject: (locus): New table git-svn-id: file:///home/puszcza/svnroot/ellinika/trunk@233 941c8c0f-9102-463b-b60b-cd22ce0e6858 --- data/db.struct | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/data/db.struct b/data/db.struct index afb5eee..f68e077 100644 --- a/data/db.struct +++ b/data/db.struct @@ -47,7 +47,7 @@ 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,3 + ident int(32), # REL 1,3,4 word varchar(128) binary, # REL 4 sound varchar(128) binary, pos int(4), # REL 0 @@ -56,6 +56,13 @@ CREATE TABLE dict( INDEX (word) ); +CREATE TABLE locus( + ident int(32), # REL 4 + file varchar(128) binary, + line int(32), + INDEX (ident) +); + CREATE TABLE articles( ident int(32) not null, # REL 1 subindex int(32) not null, -- cgit v1.2.1