diff options
author | Thomas Lenz <tlenz@iaik.tugraz.at> | 2016-02-17 07:00:09 +0100 |
---|---|---|
committer | Thomas Lenz <tlenz@iaik.tugraz.at> | 2016-02-17 07:00:09 +0100 |
commit | 07c6114a266a67abd404bac8703c1a17e035d69d (patch) | |
tree | 893d8a4873566b2bf3d4dc8d35d02e636a9d38cd /DocumentService/DBSQL | |
parent | 274a85e53fa8c06a869f2bb3a7bd24300ee9b3fd (diff) | |
download | moa-id-spss-07c6114a266a67abd404bac8703c1a17e035d69d.tar.gz moa-id-spss-07c6114a266a67abd404bac8703c1a17e035d69d.tar.bz2 moa-id-spss-07c6114a266a67abd404bac8703c1a17e035d69d.zip |
remove STORK code --> MOA-ID >= 3.2 only supports eIDAS protocol
Diffstat (limited to 'DocumentService/DBSQL')
-rw-r--r-- | DocumentService/DBSQL/mysql-connector-java-5.1.27-bin.jar | bin | 872303 -> 0 bytes | |||
-rw-r--r-- | DocumentService/DBSQL/tables.sql | 59 |
2 files changed, 0 insertions, 59 deletions
diff --git a/DocumentService/DBSQL/mysql-connector-java-5.1.27-bin.jar b/DocumentService/DBSQL/mysql-connector-java-5.1.27-bin.jar Binary files differdeleted file mode 100644 index a10268c92..000000000 --- a/DocumentService/DBSQL/mysql-connector-java-5.1.27-bin.jar +++ /dev/null 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'; - |