19 lines
1.3 KiB
SQL
19 lines
1.3 KiB
SQL
-- This SQL contains a "create table" that can be used to create a table that JdbcUsersConnectionRepository can persist
|
|
-- connection in. It is, however, not to be assumed to be production-ready, all-purpose SQL. It is merely representative
|
|
-- of the kind of table that JdbcUsersConnectionRepository works with. The table and column names, as well as the general
|
|
-- column types, are what is important. Specific column types and sizes that work may vary across database vendors and
|
|
-- the required sizes may vary across API providers.
|
|
USE micro;
|
|
create table upms_UserConnection (userId varchar(255) not null,
|
|
providerId varchar(255) not null,
|
|
providerUserId varchar(255),
|
|
rank int not null,
|
|
displayName varchar(255),
|
|
profileUrl varchar(512),
|
|
imageUrl varchar(512),
|
|
accessToken varchar(512) not null,
|
|
secret varchar(512),
|
|
refreshToken varchar(512),
|
|
expireTime bigint,
|
|
primary key (userId, providerId, providerUserId));
|
|
create unique index UserConnectionRank on upms_UserConnection(userId, providerId, rank); |