DROP TABLE IF EXISTS word;

CREATE TABLE word 
(
    id int(10) NOT NULL auto_increment,

    word char(20) NOT NULL,

    PRIMARY KEY (id),
    UNIQUE KEY (word)
);

DROP TABLE IF EXISTS abbrev;

CREATE TABLE abbrev 
(
    id int(10) NOT NULL auto_increment,
    word_id int(10) NOT NULL,

    abbrev char(10) NOT NULL,

    PRIMARY KEY (id),
    UNIQUE KEY (word_id, abbrev)
);
