#required statement

CREATE TABLE authmap (
aid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
authname varchar(128) DEFAULT '' NOT NULL,
uid int(10) DEFAULT '' NOT NULL,
authmodulename varchar(128) DEFAULT '' NOT NULL,
UNIQUE authname (authname),
PRIMARY KEY (aid)
);

#optional. no harm in omitting this section.
#DELETE FROM variable WHERE name = 'user_jabber';
#DELETE FROM variable WHERE name = 'user_drupal';

#optional. note that any data in these columns will be lost. these columns were introduced after drupal v3
#ALTER TABLE users DROP jabber;
#ALTER TABLE users DROP drupal;