sunho4828@naver.com
ohmaterry@naver.com
wndals13@naver.com
CREATE TABLE WORDS (
ID BIGINT AUTO_INCREMENT,
WORD VARCHAR(128) NOT NULL UNIQUE,
PRIMARY KEY(ID)
);
CREATE TABLE Account (id INT NOT NULL AUTO_INCREMENT, username varchar(128) NOT NULL UNIQUE, password varchar(255) not null, email varchar
(255) not null, firstName varchar(255) , lastName varchar(255), primary key (id));
ALTER TABLE Account ADD (email varchar(255));
+--------+------------+-------------------+------+-------------+------------------------------------------------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+--------------+---------------+
| userId | providerId | providerUserId | rank | displayName | profileUrl | imageUrl | accessToken | secret | refreshToken | expireTime |
+--------+------------+-------------------+------+-------------+------------------------------------------------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+--------------+---------------+
| sumin | facebook | 10153000330279523 | 1 | NULL | http://facebook.com/profile.php?id=10153000330279523 | http://graph.facebook.com/10153000330279523/picture | CAALfLEIEQSQBAG938rTk0WghndotZC0Ljosk6ScNPgGqxZAeyWVrTm6sZCAebZBfm2xZAxZBJtp594GcDkfrYOa1nhzL4bgnZBIQLt2IGbRoPDlp2N1QU0SBZBTs8HkZAZCuQ5Mq4f8R1fqdvz4xzkyZCMOEVbyKDwCZCyebnnc7BwfUkcppUv6xz9s8JwZAeR4COF1bOtfrLKBGio1Mct7DjC6ol | NULL | NULL | 1418748331956 |
+--------+------------+-------------------+------+-------------+------------------------------------------------------+-----------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+--------------+---------------+