shib-ss-db.sql

SET NAMES 'utf8';

SET CHARACTER SET utf8;

CREATE DATABASE IF NOT EXISTS storageservice CHARACTER SET=utf8;

GRANT ALL PRIVILEGES ON storageservice.* TO 'root'@'localhost';

-- ##_SS-DB_USER-PASSWORD-CHANGEME_## can't contain the characters:  ;   &   #   <
CREATE USER IF NOT EXISTS '###_SS-USERNAME-CHANGEME_###'@'localhost' IDENTIFIED BY '###_SS-DB-USER-PASSWORD-CHANGEME_###';
GRANT ALL PRIVILEGES ON storageservice.* TO '###_SS-USERNAME-CHANGEME_###'@'localhost';

FLUSH PRIVILEGES;

USE storageservice;

CREATE TABLE IF NOT EXISTS shibpid
(
localEntity VARCHAR(255) NOT NULL,
peerEntity VARCHAR(255) NOT NULL,
persistentId VARCHAR(50) NOT NULL,
principalName VARCHAR(50) NOT NULL,
localId VARCHAR(50) NOT NULL,
peerProvidedId VARCHAR(50) NULL,
creationDate TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
deactivationDate TIMESTAMP NULL default NULL,
PRIMARY KEY (localEntity, peerEntity, persistentId)
);
CREATE TABLE IF NOT EXISTS StorageRecords
(
context VARCHAR(255) NOT NULL,
id VARCHAR(255) NOT NULL,
expires BIGINT(20) DEFAULT NULL,
value LONGTEXT NOT NULL,
version BIGINT(20) NOT NULL,
PRIMARY KEY (context, id)
);

quit