From 1649e618431538f93dabdeb9517aeab04c5b9330 Mon Sep 17 00:00:00 2001
From: Jesper Brix Rosenkilde <jbr@nordu.net>
Date: Thu, 6 Jul 2017 14:35:12 +0200
Subject: Initial commit

---
 shibboleth.db.ddl | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 shibboleth.db.ddl

(limited to 'shibboleth.db.ddl')

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)
+);
-- 
cgit v1.1