From 46db0a002858a7d00401d08ded5e505c50084586 Mon Sep 17 00:00:00 2001
From: Sergey Poznyakoff <gray@gnu.org.ua>
Date: Mon, 21 Jun 2004 09:55:22 +0000
Subject: (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
---
 data/db.struct | 23 ++++++++++++-----------
 1 file changed, 12 insertions(+), 11 deletions(-)

(limited to 'data/db.struct')

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
+);
+
+
-- 
cgit v1.2.1