aboutsummaryrefslogtreecommitdiff
path: root/DocumentService/DBSQL
diff options
context:
space:
mode:
authorThomas Lenz <tlenz@iaik.tugraz.at>2016-04-08 07:50:20 +0200
committerThomas Lenz <tlenz@iaik.tugraz.at>2016-04-08 07:50:20 +0200
commit50c500dd107d88988cbee8207c91a16b321d6136 (patch)
tree6abd06e3f126866534e155e40c2f7e933b5357d3 /DocumentService/DBSQL
parentec62813f4c0e8b3002d46f7bc315e7a27d720125 (diff)
parent41882a0c5601dda478c2749ac99c2087b864c912 (diff)
downloadmoa-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.jarbin872303 -> 0 bytes
-rw-r--r--DocumentService/DBSQL/tables.sql59
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
deleted file mode 100644
index a10268c92..000000000
--- a/DocumentService/DBSQL/mysql-connector-java-5.1.27-bin.jar
+++ /dev/null
Binary files differ
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';
-