accounts table

CREATE TABLE account (
    account_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    account_name VARCHAR(25) NOT NULL,
    account_password VARCHAR(128) NOT NULL,
    account_salt VARCHAR(32) NOT NULL,
    account_email VARCHAR(255) NOT NULL,
    is_active BOOLEAN NOT NULL,

    PRIMARY KEY (account_id),
    UNIQUE KEY (account_name),
    UNIQUE KEY (account_email)
)
ENGINE=InnoDB,
DEFAULT CHARSET utf8
;