CREATE TABLE IF NOT EXISTS users (
        id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        username VARCHAR(255) NOT NULL ,
        password VARCHAR(255) NOT NULL ,
        email TEXT NOT NULL ,
        ip VARCHAR(16) NOT NULL ,
        group INT(1) NOT NULL DEFAULT 1 ,
        banned VARCHAR(5) NOT NULL DEFAULT 'n'
        );";