25 lines
588 B
SQL
25 lines
588 B
SQL
::
|
|
|
|
CREATE USER idpc PASSWORD 'pass';
|
|
|
|
CREATE TABLE nameidentifiers (
|
|
name_identifier varchar(100) primary key,
|
|
user_id varchar(100)
|
|
);
|
|
|
|
CREATE TABLE users (
|
|
user_id varchar(100) primary key,
|
|
identity_dump text,
|
|
session_dump text
|
|
);
|
|
|
|
CREATE TABLE artifacts (
|
|
artifact varchar(100) primary key,
|
|
user_id varchar(100),
|
|
provider_id text
|
|
);
|
|
|
|
GRANT DELETE, INSERT, SELECT, UPDATE ON nameidentifiers TO idpc;
|
|
GRANT DELETE, INSERT, SELECT, UPDATE ON users TO idpc;
|
|
GRANT DELETE, INSERT, SELECT, UPDATE ON artifacts TO idpc;
|