CREATE TABLE users_param (
    param_id mediumint UNSIGNED NOT NULL auto_increment,
    uid mediumint UNSIGNED NOT NULL,
    name varchar(32) DEFAULT '' NOT NULL,
    value text DEFAULT '' NOT NULL,
    UNIQUE uid_key (uid,name),
    KEY (uid),
    FOREIGN KEY (uid) REFERENCES users(uid),
    PRIMARY KEY (param_id)
) TYPE = myisam;