CREATE TABLE Account (id INT NOT NULL AUTO_INCREMENT, email varchar(255) NOT NULL UNIQUE, password varchar(255) not null, firstName varchar(255) , lastName varchar(255), primary key (id));
| UserConnection |
CREATE TABLE `UserConnection` (
`email` varchar(255) NOT NULL,
`providerId` varchar(255) NOT NULL,
`providerUserId` varchar(255) NOT NULL DEFAULT '',
`rank` int(11) NOT NULL,
`displayName` varchar(255) DEFAULT NULL,
`profileUrl` varchar(512) DEFAULT NULL,
`imageUrl` varchar(512) DEFAULT NULL,
`accessToken` varchar(255) NOT NULL,
`secret` varchar(255) DEFAULT NULL,
`refreshToken` varchar(255) DEFAULT NULL,
`expireTime` bigint(20) DEFAULT NULL,
PRIMARY KEY (`email`,`providerId`,`providerUserId`),
UNIQUE KEY `UserConnectionRank` (`email`,`providerId`,`rank`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2005424
http://stackoverflow.com/questions/6170915/spring-security-rename-login-form-tags-name