Used this MySQL script to take the users table to NeDi 1.0.4:
/* tidy up current users table */
UPDATE user SET adm = 0 WHERE adm IS NULL;
UPDATE user SET net = 0 WHERE net IS NULL;
UPDATE user SET dsk = 0 WHERE dsk IS NULL;
UPDATE user SET mon = 0 WHERE mon IS NULL;
UPDATE user SET mgr = 0 WHERE mgr IS NULL;
UPDATE user SET oth = 0 WHERE oth IS NULL;
UPDATE user SET language = 'deutsch' WHERE language = 'german';
UPDATE user SET language = 'deutsch' WHERE language = 'ger';
UPDATE user SET language = 'english' WHERE language = 'eng';
/* rename old users table */
RENAME TABLE user TO user_old;
/* create new users table */
CREATE TABLE user (
name VARCHAR(32) NOT NULL UNIQUE,
password VARCHAR(32) NOT NULL default '',
groups TINYINT unsigned NOT NULL default 0,
email VARCHAR(64),
phone VARCHAR(32),
time INT unsigned,
lastseen INT unsigned,
comment VARCHAR(255),
language VARCHAR(16) NOT NULL default 'english',
theme VARCHAR(16) NOT NULL default 'default',
volume TINYINT unsigned NOT NULL default 10,
columns TINYINT unsigned NOT NULL default 5,
msglimit TINYINT unsigned NOT NULL default 5,
graphs TINYINT unsigned NOT NULL default 2,
PRIMARY KEY (name)
);
/* transfer user information */
INSERT INTO user ( name, password, groups, email, phone, time, lastseen, comment, language, theme )
SELECT name, password, ( adm * 1 + net * 2 + dsk * 4 + mon * 8 + mgr * 16 + oth * 32 ) AS groups, email, phone, time, lastseen, comment, language, theme FROM user_old;
/* delete old user table */
DROP TABLE user_old;
Using the MySQL command line client, just run this script with:
mysql -u *nedi-dbuser* -p nedi < transferUsers.sql
