1 files changed, 11 insertions, 0 deletions
diff --git a/idp/shibboleth.db.ddl b/idp/shibboleth.db.ddl
new file mode 100644
index 0000000..3799b91
--- /dev/null
+++ b/idp/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)
+);