etc

SADFASD

Sumin Lim 2014. 11. 4. 19:18
반응형

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

반응형