Created
March 12, 2015 01:24
-
-
Save tomoumi-n/ea6aef86d76817ffaf71 to your computer and use it in GitHub Desktop.
SQL to add oauth2 table to aipo-database org001
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- oauth2_token table query | |
CREATE TABLE OAUTH2_TOKEN | |
( | |
TOKEN_ID INTEGER NOT NULL, | |
USER_ID VARCHAR(255) NOT NULL, | |
TOKEN VARCHAR(255) NOT NULL, | |
CREATE_DATE TIMESTAMP NOT NULL, | |
EXPIRE_TIME TIMESTAMP NOT NULL, | |
SCOPE VARCHAR(255), | |
TOKEN_TYPE VARCHAR(255), | |
CODE_TYPE VARCHAR(255), | |
PRIMARY KEY(TOKEN_ID) | |
); | |
CREATE SEQUENCE pk_oauth2_token INCREMENT 20; | |
ALTER SEQUENCE pk_oauth2_token OWNED BY OAUTH2_TOKEN.TOKEN_ID; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment