티스토리 뷰

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

반응형

'etc' 카테고리의 다른 글

JDK  (0) 2014.11.05
apache 설정 rule  (0) 2014.11.05
하둡  (0) 2014.11.03
spec list  (0) 2014.10.27
war  (0) 2014.10.24
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
링크
«   2024/07   »
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
글 보관함