From 07c6114a266a67abd404bac8703c1a17e035d69d Mon Sep 17 00:00:00 2001
From: Thomas Lenz <tlenz@iaik.tugraz.at>
Date: Wed, 17 Feb 2016 07:00:09 +0100
Subject: remove STORK code --> MOA-ID >= 3.2 only supports eIDAS protocol

---
 DocumentService/DBSQL/tables.sql | 59 ----------------------------------------
 1 file changed, 59 deletions(-)
 delete mode 100644 DocumentService/DBSQL/tables.sql

(limited to 'DocumentService/DBSQL/tables.sql')

diff --git a/DocumentService/DBSQL/tables.sql b/DocumentService/DBSQL/tables.sql
deleted file mode 100644
index 3fa912357..000000000
--- a/DocumentService/DBSQL/tables.sql
+++ /dev/null
@@ -1,59 +0,0 @@
-CREATE DATABASE STORKTRANSFER;
-
-USE STORKTRANSFER;
-
-CREATE TABLE `document` (
-  `DOCID` varchar(255) NOT NULL,
-  `DOCUMENT` longblob,
-  `FILENAME` varchar(255) DEFAULT NULL,
-  `MIMETYPE` longtext,
-  `CREATED` datetime DEFAULT NULL,
-  `UPDATED` datetime DEFAULT NULL,
-  `DELETED` datetime DEFAULT NULL,
-  `RECEIVERCERT` longtext,
-  `ENCKEY` longtext,
-  `ENCIV` longtext,
-  PRIMARY KEY (`DOCID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-
-CREATE TABLE `request` (
-  `REQUESTID` varchar(255) NOT NULL,
-  `DOCID` varchar(255) DEFAULT NULL,
-  `DESTCOUNTRY` varchar(10) NOT NULL,
-  `SPCOUNTRY` varchar(10) NOT NULL,
-  `SPID` varchar(255) NOT NULL,
-  `XMLREQUEST` longtext,
-  `XMLRESPONSE` longtext,
-  `REQTIMESTAMP` datetime DEFAULT NULL,
-  `RESTIMESTAMP` datetime DEFAULT NULL,
-  PRIMARY KEY (`REQUESTID`),
-  KEY `docid_idx` (`DOCID`),
-  CONSTRAINT `docidindex` FOREIGN KEY (`DOCID`) REFERENCES `document` (`DOCID`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-CREATE TABLE `spid` (
-  `ID` int(11) NOT NULL AUTO_INCREMENT,
-  `SPID` varchar(45) NOT NULL,
-  `NAME` varchar(100) DEFAULT NULL,
-  `DESC` varchar(500) DEFAULT NULL,
-  PRIMARY KEY (`ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-SELECT * FROM STORKTRANSFER.spid;
-
-CREATE TABLE `temp_document` (
-  `DOCID` varchar(255) NOT NULL,
-  `DOCUMENT` longblob,
-  `MIMETYPE` longtext,
-  `CREATED` datetime DEFAULT NULL,
-  `FETCHED` datetime DEFAULT NULL,
-  `DELETED` datetime DEFAULT NULL,
-  `RECEIVERCERT` longtext,
-  `ENCKEY` longtext,
-  `ENCIV` longtext,
-  `SPID` int(11) DEFAULT NULL,
-  PRIMARY KEY (`DOCID`),
-  KEY `SPconstraint_idx` (`SPID`),
-  CONSTRAINT `SPconstraint` FOREIGN KEY (`SPID`) REFERENCES `spid` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Temp table for SP documents';
-
-- 
cgit v1.2.3