   PRIMARY KEY (`login_id`),
   KEY `identityx` (`identity`),
   KEY `user_idx` (`user_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=27834 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=37358 DEFAULT CHARSET=latin1;
 
 CREATE TABLE `session` (
   `last_session_no` int(10) unsigned NOT NULL DEFAULT '0'

  `identity` varchar(255) DEFAULT NULL,
  `type` enum('local','openid','ldap') NOT NULL DEFAULT 'local',
  `data` text,
  `status` enum('active','pending') NOT NULL DEFAULT 'pending',
  `salt` varchar(8) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,

  `modified_by` int(11) DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  PRIMARY KEY (`group_member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=49027 DEFAULT CHARSET=latin1;

CREATE TABLE `login` (
  `login_id` int(11) NOT NULL AUTO_INCREMENT,
