idpc/create-db.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;