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)
);