#DROP TABLE affix;
#DROP TABLE spell;

CREATE TABLE affix (
  flag char(1) DEFAULT '' NOT NULL,
  type char(1) DEFAULT '' NOT NULL,
  lang char(3) DEFAULT '' NOT NULL,
  mask char(32) DEFAULT '' NOT NULL,
  find char(32) DEFAULT '' NOT NULL,
  repl char(32) DEFAULT '' NOT NULL,
  UNIQUE KEY  affix_flag (flag,type,lang,mask,find,repl)
);

CREATE TABLE spell (
  word varchar(64) DEFAULT '' NOT NULL,
  flag varchar(32) DEFAULT '' NOT NULL,
  lang char(3) DEFAULT '' NOT NULL,
  UNIQUE KEY spell_word (word,flag,lang)
);

