diff options
| author | Jesper Brix Rosenkilde <jbr@nordu.net> | 2017-07-06 14:35:12 +0200 |
|---|---|---|
| committer | Jesper Brix Rosenkilde <jbr@nordu.net> | 2017-07-06 14:35:12 +0200 |
| commit | 1649e618431538f93dabdeb9517aeab04c5b9330 (patch) | |
| tree | f9ff3029cb2fdb2ded8b2ba0893c32f05aeb40f5 /shibboleth.db.ddl | |
Initial commit
Diffstat (limited to 'shibboleth.db.ddl')
| -rw-r--r-- | shibboleth.db.ddl | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/shibboleth.db.ddl b/shibboleth.db.ddl new file mode 100644 index 0000000..3799b91 --- /dev/null +++ b/shibboleth.db.ddl @@ -0,0 +1,11 @@ +CREATE TABLE 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, + deactivationDate TIMESTAMP NULL, + PRIMARY KEY (localEntity, peerEntity, persistentId) +); |