nilsteampassnet / TeamPass

mysqli_query($db_link, "ALTER TABLE `".$pre."items` MODIFY pw_len INT(5) NOT NULL DEFAULT '0'");

// alter table MISC - rename ID is exists

if (columnExists($pre."misc", "id") === true) {

    // Change name of field

    mysqli_query($db_link, "ALTER TABLE `".$pre."misc` CHANGE `id` `increment_id` INT(12) NOT NULL AUTO_INCREMENT");

} else {

    // alter table misc to add an index

    $res = addColumnIfNotExist(

        $pre."misc",

        "increment_id",

        "INT(12) NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`increment_id`)"

    );

}

// alter table misc to add an index

mysqli_query(

    "ALTER TABLE `".$pre."users` ADD `ga_temporary_code` VARCHAR(20) NOT NULL DEFAULT 'none' AFTER `ga`;"

);

// alter table USERS to add a new field "user_ip"

if (columnExists($pre."users", "user_ip") === true) {

    // Change name of field

    mysqli_query($db_link, "ALTER TABLE `".$pre."users` CHANGE `user_ip` `user_ip` VARCHAR(400) NOT NULL DEFAULT 'none'");

} else {

    // alter table misc to add an index

    $res = addColumnIfNotExist(

        $pre."users",

        "user_ip",

        "VARCHAR(400) NOT NULL DEFAULT 'none'"

    );

}

// alter table USERS to allow NULL on field "email"

mysqli_query(