diff options
author | Thomas Lenz <tlenz@iaik.tugraz.at> | 2016-04-08 07:50:20 +0200 |
---|---|---|
committer | Thomas Lenz <tlenz@iaik.tugraz.at> | 2016-04-08 07:50:20 +0200 |
commit | 50c500dd107d88988cbee8207c91a16b321d6136 (patch) | |
tree | 6abd06e3f126866534e155e40c2f7e933b5357d3 /DocumentService/DBSQL | |
parent | ec62813f4c0e8b3002d46f7bc315e7a27d720125 (diff) | |
parent | 41882a0c5601dda478c2749ac99c2087b864c912 (diff) | |
download | moa-id-spss-50c500dd107d88988cbee8207c91a16b321d6136.tar.gz moa-id-spss-50c500dd107d88988cbee8207c91a16b321d6136.tar.bz2 moa-id-spss-50c500dd107d88988cbee8207c91a16b321d6136.zip |
Merge tag 'MOA-ID-3.1.0' into development_preview
JoinUp Release
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'; - |