Skip to content

Instantly share code, notes, and snippets.

@tomoumi-n
Created March 12, 2015 01:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tomoumi-n/ea6aef86d76817ffaf71 to your computer and use it in GitHub Desktop.
Save tomoumi-n/ea6aef86d76817ffaf71 to your computer and use it in GitHub Desktop.
SQL to add oauth2 table to aipo-database org001
-- 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