Hier die Tabellen-Definitionen, die man benötigt, wenn man im dokuwiki die Authentifizierung auf MySQL umstellt:
CREATE TABLE users ( uid int(10) UNSIGNED NOT NULL AUTO_INCREMENT, login varchar(20) NOT NULL DEFAULT '', pass varchar(60) NOT NULL DEFAULT '', firstname varchar(255) NOT NULL DEFAULT '', lastname varchar(255) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (uid), UNIQUE KEY login (login) ) ENGINE = MYISAM; CREATE TABLE groups ( gid int(10) UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (gid), UNIQUE KEY name (name) ) ENGINE = MYISAM; CREATE TABLE usergroup ( uid int(10) UNSIGNED NOT NULL DEFAULT '0', gid int(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (uid,gid) ) ENGINE = MYISAM;







