mysql unique

CREATE TABLE IF NOT EXISTS tag (

    id          INTEGER PRIMARY KEY AUTO_INCREMENT,
    name        MEDIUMTEXT DEFAULT NULL,
    mime        MEDIUMTEXT DEFAULT NULL,
    file        MEDIUMTEXT DEFAULT NULL,
    keyword     MEDIUMTEXT DEFAULT NULL,
    UNIQUE(keyword(1000))

)
 

Leave a Reply

*