<?php

require_once dirname(__FILE__) . '/accesscheck.php';

# convert the database to add the prefix
# dangerous, should not be used, particularly not if the prefix already exists

if (!$GLOBALS['table_prefix']) {
    print 'No prefix defined, nothing to do';

    return;
}

include 'structure.php';

while (list($table, $value) = each($DBstruct)) {
    if ($table != $tables[$table]) {
        Sql_Verbose_Query("drop table if exists $tables[$table]", 0);
        Sql_Verbose_Query("alter table $table rename $tables[$table]", 0);
    }
}

$req = Sql_Verbose_Query('select tablename from ' . $tables['attribute']);
while ($row = Sql_Fetch_Row($req)) {
    set_time_limit(500);
    if (Sql_Table_Exists('listattr_' . $row[0]) && $table_prefix) {
        Sql_Verbose_Query("alter table listattr_$row[0] rename $table_prefix" . 'listattr_' . $row[0]);
    }
    if (Sql_Table_Exists($table_prefix . 'listattr_' . $row[0])) {
        Sql_Query("alter table $table_prefix" . 'listattr_' . $row[0] . ' add column listorder integer default 0', 0);
    }
}
flush();
