CREATE TABLE users (
    id_user INTEGER NOT NULL AUTO_INCREMENT,
    fname VARCHAR(20),
    lname VARCHAR(30),
    organization VARCHAR(40),
    email VARCHAR(50),
    login VARCHAR(15) NOT NULL,
    password VARCHAR(15) NOT NULL,
    spam BOOL DEFAULT 0,
    active BOOL DEFAULT 0,
    active_link VARCHAR(40),
    id_type INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY (id_user),
    KEY IDX_users1(id_type),
    UNIQUE KEY IDX_users2(id_user)
) TYPE=INNODB;