diff options
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.jarBinary files differ deleted 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'; - | 
