-- MySQL dump 10.11 -- -- Host: localhost Database: aggregator -- ------------------------------------------------------ -- Server version 5.0.51b-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `aggregator` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `aggregator` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `aggregator`; -- -- Table structure for table `agg_message_results` -- DROP TABLE IF EXISTS `agg_message_results`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `agg_message_results` ( `MessageId` varchar(32) NOT NULL COMMENT 'This will be a UUID.', `TransactionId` varchar(32) NOT NULL COMMENT 'This will be a UUID. - Foreign Key to the agg_transaction table.', `MessageKey` varchar(1000) NOT NULL COMMENT 'This is the key used to tie the response to the original request.', `MessageOutTime` datetime default NULL COMMENT 'This is the date/time when the outbound request was recorded. Format of YYYYMMDDHHMMSS', `ResponseReceivedTime` datetime default NULL COMMENT 'This is the date/time when the response was recorded. Format of YYYYMMDDHHMMSS', `ResponseMessageType` varchar(100) default NULL COMMENT 'This is the name of the outer layer JAXB class for the response message.', `ResponseMessage` longtext COMMENT 'The response message in XML - Based on marshalling using JAXB', PRIMARY KEY (`MessageId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `agg_message_results` -- LOCK TABLES `agg_message_results` WRITE; /*!40000 ALTER TABLE `agg_message_results` DISABLE KEYS */; /*!40000 ALTER TABLE `agg_message_results` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agg_transaction` -- DROP TABLE IF EXISTS `agg_transaction`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `agg_transaction` ( `TransactionId` varchar(32) NOT NULL COMMENT 'This will be a UUID', `ServiceType` varchar(64) NOT NULL, `TransactionStartTime` datetime default NULL COMMENT 'Format of YYYYMMDDHHMMSS', PRIMARY KEY (`TransactionId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `agg_transaction` -- LOCK TABLES `agg_transaction` WRITE; /*!40000 ALTER TABLE `agg_transaction` DISABLE KEYS */; /*!40000 ALTER TABLE `agg_transaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `assigningauthoritydb` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `assigningauthoritydb` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `assigningauthoritydb`; -- -- Table structure for table `assigningauthoritytohomecommunitymapping` -- DROP TABLE IF EXISTS `assigningauthoritytohomecommunitymapping`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `assigningauthoritytohomecommunitymapping` ( `id` int(10) unsigned NOT NULL auto_increment, `assigningauthorityid` varchar(45) NOT NULL, `homecommunityid` varchar(45) NOT NULL, PRIMARY KEY (`id`,`assigningauthorityid`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `assigningauthoritytohomecommunitymapping` -- LOCK TABLES `assigningauthoritytohomecommunitymapping` WRITE; /*!40000 ALTER TABLE `assigningauthoritytohomecommunitymapping` DISABLE KEYS */; INSERT INTO `assigningauthoritytohomecommunitymapping` VALUES (1,'1.1','1.2.3.4.55.500'),(2,'1.2','1.2.3.4.55.501'),(3,'1.3','2.16.840.1.113883.3.200'),(4,'1.4','2.16.840.1.113883.3.198'),(5,'1.5','2.16.840.1.113883.3.184'); /*!40000 ALTER TABLE `assigningauthoritytohomecommunitymapping` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `auditrepo` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `auditrepo` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `auditrepo`; -- -- Table structure for table `auditrepository` -- DROP TABLE IF EXISTS `auditrepository`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `auditrepository` ( `id` bigint(20) NOT NULL auto_increment, `timestamp` datetime default NULL, `eventId` bigint(20) NOT NULL, `userId` varchar(100) default NULL, `participationTypeCode` smallint(6) default NULL, `participationTypeCodeRole` smallint(6) default NULL, `participationIDTypeCode` varchar(100) default NULL, `receiverPatientId` varchar(100) default NULL, `senderPatientId` varchar(100) default NULL, `communityId` varchar(255) default NULL, `messageType` varchar(100) NOT NULL, `message` blob, PRIMARY KEY (`id`), UNIQUE KEY `UQ_eventlog_id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `auditrepository` -- LOCK TABLES `auditrepository` WRITE; /*!40000 ALTER TABLE `auditrepository` DISABLE KEYS */; INSERT INTO `auditrepository` VALUES (1,'2009-02-20 13:18:44',0,'Alexandra Rodriquez',1,1,'2','65456^^^&2.16.840.1.113883.3.192&ISO',NULL,'2.16.840.1.113883.3.192','logAdhocQueryRequest','PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxBZGhvY1F1ZXJ5UmVxdWVzdCB4bWxucz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cXVlcnk6My4wIiB4bWxuczpuczI9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJpbTozLjAiIHhtbG5zOm5zMz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cnM6My4wIiB4bWxuczpuczQ9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOmxjbTozLjAiIG1heFJlc3VsdHM9Ii0xIiBzdGFydEluZGV4PSIwIiBmZWRlcmF0aW9uPSI/IiBmZWRlcmF0ZWQ9ImZhbHNlIiBjb21tZW50PSI/IiBpZD0iPyI+PFJlc3BvbnNlT3B0aW9uIHJldHVybkNvbXBvc2VkT2JqZWN0cz0iZmFsc2UiIHJldHVyblR5cGU9IlJlZ2lzdHJ5T2JqZWN0Ii8+PG5zMjpBZGhvY1F1ZXJ5IHN0YXR1cz0iPyIgb2JqZWN0VHlwZT0iPyIgbGlkPSI/IiBob21lPSI/IiBpZD0iPyIvPjwvQWRob2NRdWVyeVJlcXVlc3Q+'),(2,'2009-02-20 13:19:38',0,'Phillip Kirkman',1,1,'2','989898^^^&2.16.840.1.113883.3.185&ISO',NULL,'2.16.840.1.113883.3.185','logAdhocQueryResponse','PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxBZGhvY1F1ZXJ5UmVzcG9uc2UgeG1sbnM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnF1ZXJ5OjMuMCIgeG1sbnM6bnMyPSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOnhzZDpyaW06My4wIiB4bWxuczpuczM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJzOjMuMCIgeG1sbnM6bnM0PSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOnhzZDpsY206My4wIiB0b3RhbFJlc3VsdENvdW50PSIxIiBzdGFydEluZGV4PSIwIiByZXF1ZXN0SWQ9Ij8iIHN0YXR1cz0iPyI+PG5zMjpSZWdpc3RyeU9iamVjdExpc3Q+PG5zMjpJZGVudGlmaWFibGUgaG9tZT0iMi4xNi44NDAuMS4xMTM4ODMuMy4xODUiIGlkPSJEZWxhd2FyZSBSZWdpb24iLz48bnMyOkV4dHJpbnNpY09iamVjdCBpc09wYXF1ZT0iZmFsc2UiIG1pbWVUeXBlPSJ0ZXh0L3htbCIgc3RhdHVzPSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOlN0YXR1c1R5cGU6QXBwcm92ZWQiIG9iamVjdFR5cGU9InVybjp1dWlkOjdlZGNhODJmLTA1NGQtNDdmMi1hMDMyLTliMmE1YjUxODZjMSIgaG9tZT0idXJuOm9pZDoyLjE2Ljg0MC4xLjExMzg4My4zLjE4NSIgaWQ9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiI+PG5zMjpTbG90IG5hbWU9ImNyZWF0aW9uVGltZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT4yMDA4MDEyMDA1MDUwNS0wNzAwPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9Imhhc2giPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+MTU2OTYwODk0MDwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJpbnRlbmRlZFJlY2lwaWVudCI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5pbnRlbmRlZFJlY2lwaWVudFBlcnNvbl92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJsYW5ndWFnZUNvZGUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+bGFuZ3VhZ2VDb2RlX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9ImxlZ2FsQXV0aGVudGljYXRvciI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5sZWdhbEF1dGhlbnRpY2F0b3JfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0ic2VydmljZVN0YXJ0VGltZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT4yMDA4MDUwMTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJzZXJ2aWNlU3RvcFRpbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+MjAwODA1MTU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0ic2l6ZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT4xMjM0PC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9InNvdXJjZVBhdGllbnRJZCI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5zb3VyY2VQYXRpZW50SWRfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0ic291cmNlUGF0aWVudEluZm8iPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+UElELTN8cGlkM192YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTV8cGlkNV92YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTd8cGlkN192YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTh8cGlkOF92YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTExfHBpZDExX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9IlVSSSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5kb2N1bWVudFVyaV92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJyZXBvc2l0b3J5VW5pcXVlSWQiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+MTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iQkhJRSBEb2N1bWVudCAxIi8+PC9uczI6TmFtZT48bnMyOkRlc2NyaXB0aW9uPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJEb2N1bWVudCAxIGNvbW1lbnRzIi8+PC9uczI6RGVzY3JpcHRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249IiIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6OTM2MDZiY2YtOTQ5NC00M2VjLTliNGUtYTc3NDhkMWE4MzhkIiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iYXV0aG9yUGVyc29uIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPkJvYiBEaWxsYW48L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0iYXV0aG9ySW5zdGl0dXRpb24iPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+RGlsbGFuIEluc3RpdHV0ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJhdXRob3JSb2xlIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPlJldmVpd2VyPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9ImF1dGhvclNwZWNpYWx0eSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5hdXRob3JTcGVjaWFsdHlfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0iQ2xhc3NfMTExIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDo0MWE1ODg3Zi04ODY1LTRjMDktYWRmNy1lMzYyNDc1YjE0M2EiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+Q2xhc3Nfc2NoZW1lXzExMTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iY2xhc3NDb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJjb25maWRlbnRpYWxpdHlDb2RlX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDpmNGY4NWVhYy1lNmNiLTQ4ODMtYjUyNC1mMjcwNTM5NDg0MGYiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+Y29uZmlkZW50aWFsaXR5Q29kZVNjaGVtZV92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iY29uZmlkZW50aWFsaXR5Q29kZURpc3BsYXlOYW1lX3ZhbHVlIi8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0iY29kZV92YWx1ZSIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6MmM2YjhjYjctOGIyYS00MDUxLWIyOTEtYjFhZTZhNTc1ZWY0IiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iY29kaW5nU2NoZW1lIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPmNvZGVTY2hlbWFfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9ImNvZGVEaXNwbGF5TmFtZV92YWx1ZSIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249InRlc3QiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOjJjNmI4Y2I3LThiMmEtNDA1MS1iMjkxLWIxYWU2YTU3NWVmNCIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT50ZXN0PC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJ0ZXN0Ii8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0idGVzdCIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6MmM2YjhjYjctOGIyYS00MDUxLWIyOTEtYjFhZTZhNTc1ZWY0IiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iY29kaW5nU2NoZW1lIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPnRlc3Q8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9InRlc3QiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJ0ZXN0IiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDoyYzZiOGNiNy04YjJhLTQwNTEtYjI5MS1iMWFlNmE1NzVlZjQiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+dGVzdDwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0idGVzdCIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249ImNvZGVfdmFsdWUiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOjJjNmI4Y2I3LThiMmEtNDA1MS1iMjkxLWIxYWU2YTU3NWVmNCIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5jb2RlU2NoZW1hX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJjb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJjb2RlX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDoyYzZiOGNiNy04YjJhLTQwNTEtYjI5MS1iMWFlNmE1NzVlZjQiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+Y29kZVNjaGVtYV92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iY29kZURpc3BsYXlOYW1lX3ZhbHVlIi8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0iY29kZV92YWx1ZSIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6MmM2YjhjYjctOGIyYS00MDUxLWIyOTEtYjFhZTZhNTc1ZWY0IiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iY29kaW5nU2NoZW1lIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPmNvZGVTY2hlbWFfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9ImNvZGVEaXNwbGF5TmFtZV92YWx1ZSIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249ImZvcm1hdENvZGVfdmFsdWUiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOmEwOWQ1ODQwLTM4NmMtNDZmMi1iNWFkLTljMzY5OWE0MzA5ZCIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5mb3JtYXRDb2RlU2NoZW1lX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJmb3JtYXRDb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJmYWNpbGl0eUNvZGVfdmFsdWUiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOmYzM2ZiOGFjLTE4YWYtNDJjYy1hZTBlLWVkMGIwYmRiOTFlMSIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5mYWNpbGl0eUNvZGVTY2hlbWVfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9ImZhY2lsaXR5Q29kZURpc3BsYXlOYW1lX3ZhbHVlIi8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0icHJhY3RpY2VTZXR0aW5nX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDpjY2NmNTU5OC04YjA3LTRiNzctYTA1ZS1hZTk1MmM3ODVlYWQiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+cHJhY3RpY2VTZXR0aW5nU2NoZW1lX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJwcmFjdGljZVNldHRpbmdEaXNwbGF5TmFtZV92YWx1ZSIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249InR5cGVDb2RlX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDpmMDMwNmY1MS05NzVmLTQzNGUtYTYxYy1jNTk2NTFkMzM5ODMiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+dHlwZUNvZGVTY2hlbWVfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9InR5cGVDb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6RXh0ZXJuYWxJZGVudGlmaWVyIHZhbHVlPSInMTIzNF5eXiZhbXA7MS4xJmFtcDtJU08nIiBpZGVudGlmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6NThhNmY4NDEtODdiMy00YTNlLTkyZmQtYThmZmVmZjk4NDI3IiByZWdpc3RyeU9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBpZD0iIj48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9IlhEU0RvY3VtZW50RW50cnkucGF0aWVudElkIi8+PC9uczI6TmFtZT48L25zMjpFeHRlcm5hbElkZW50aWZpZXI+PG5zMjpFeHRlcm5hbElkZW50aWZpZXIgdmFsdWU9IjExMTExMTExMSIgaWRlbnRpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOjJlODJjMWY2LWEwODUtNGM3Mi05ZGEzLTg2NDBhMzJlNDJhYiIgcmVnaXN0cnlPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgaWQ9IiI+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJYRFNEb2N1bWVudEVudHJ5LnVuaXF1ZUlkIi8+PC9uczI6TmFtZT48L25zMjpFeHRlcm5hbElkZW50aWZpZXI+PC9uczI6RXh0cmluc2ljT2JqZWN0PjwvbnMyOlJlZ2lzdHJ5T2JqZWN0TGlzdD48L0FkaG9jUXVlcnlSZXNwb25zZT4='),(3,'2009-02-20 13:20:05',0,'Alexandra Rodriquez',1,1,'2','65456^^^&2.16.840.1.113883.3.192&ISO',NULL,'2.16.840.1.113883.3.192','logAdhocQueryRequest','PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxBZGhvY1F1ZXJ5UmVxdWVzdCB4bWxucz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cXVlcnk6My4wIiB4bWxuczpuczI9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJpbTozLjAiIHhtbG5zOm5zMz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cnM6My4wIiB4bWxuczpuczQ9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOmxjbTozLjAiIG1heFJlc3VsdHM9Ii0xIiBzdGFydEluZGV4PSIwIiBmZWRlcmF0aW9uPSI/IiBmZWRlcmF0ZWQ9ImZhbHNlIiBjb21tZW50PSI/IiBpZD0iPyI+PFJlc3BvbnNlT3B0aW9uIHJldHVybkNvbXBvc2VkT2JqZWN0cz0iZmFsc2UiIHJldHVyblR5cGU9IlJlZ2lzdHJ5T2JqZWN0Ii8+PG5zMjpBZGhvY1F1ZXJ5IHN0YXR1cz0iPyIgb2JqZWN0VHlwZT0iPyIgbGlkPSI/IiBob21lPSI/IiBpZD0iPyIvPjwvQWRob2NRdWVyeVJlcXVlc3Q+'),(4,'2009-02-22 12:44:52',0,'mfranklin',1,1,'2','1000000008^^^&2.16.840.1.113883.3.198&ISO',NULL,'2.16.840.1.113883.3.198','logRetrieveDocumentSetRequest','PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxuczQ6UmV0cmlldmVEb2N1bWVudFNldFJlcXVlc3QgeG1sbnM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJpbTozLjAiIHhtbG5zOm5zMj0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cnM6My4wIiB4bWxuczpuczM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOmxjbTozLjAiIHhtbG5zOm5zND0idXJuOmloZTppdGk6eGRzLWI6MjAwNyIgeG1sbnM6bnM1PSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOnhzZDpxdWVyeTozLjAiPjxuczQ6RG9jdW1lbnRSZXF1ZXN0PjxuczQ6SG9tZUNvbW11bml0eUlkPnVybjpvaWQ6MS4xPC9uczQ6SG9tZUNvbW11bml0eUlkPjxuczQ6UmVwb3NpdG9yeVVuaXF1ZUlkPjE8L25zNDpSZXBvc2l0b3J5VW5pcXVlSWQ+PG5zNDpEb2N1bWVudFVuaXF1ZUlkPjEyMzQ8L25zNDpEb2N1bWVudFVuaXF1ZUlkPjwvbnM0OkRvY3VtZW50UmVxdWVzdD48L25zNDpSZXRyaWV2ZURvY3VtZW50U2V0UmVxdWVzdD4='); /*!40000 ALTER TABLE `auditrepository` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `docrepository` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `docrepository` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `docrepository`; -- -- Table structure for table `document` -- DROP TABLE IF EXISTS `document`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `document` ( `documentid` int(11) NOT NULL, `DocumentUniqueId` varchar(64) NOT NULL, `DocumentTitle` varchar(128) default NULL, `authorPerson` varchar(64) default NULL, `authorInstitution` varchar(64) default NULL, `authorRole` varchar(64) default NULL, `authorSpecialty` varchar(64) default NULL, `AvailabilityStatus` varchar(64) default NULL, `ClassCode` varchar(64) default NULL, `ClassCodeScheme` varchar(64) default NULL, `ClassCodeDisplayName` varchar(64) default NULL, `ConfidentialityCode` varchar(64) default NULL, `ConfidentialityCodeScheme` varchar(64) default NULL, `ConfidentialityCodeDisplayName` varchar(64) default NULL, `CreationTime` datetime default NULL COMMENT 'Date format expected: MM/dd/yyyy.HH:mm:ss', `FormatCode` varchar(64) default NULL, `FormatCodeScheme` varchar(64) default NULL, `FormatCodeDisplayName` varchar(64) default NULL, `PatientId` varchar(64) default NULL COMMENT 'Format of HL7 2.x CX', `ServiceStartTime` datetime default NULL COMMENT 'Format of YYYYMMDDHHMMSS', `ServiceStopTime` datetime default NULL COMMENT 'Format of YYYYMMDDHHMMSS', `Status` varchar(64) default NULL, `Comments` varchar(256) default NULL, `Hash` varchar(1028) default NULL COMMENT 'Might be better to derive', `FacilityCode` varchar(64) default NULL, `FacilityCodeScheme` varchar(64) default NULL, `FacilityCodeDisplayName` varchar(64) default NULL, `IntendedRecipientPerson` varchar(128) default NULL COMMENT 'Format of HL7 2.x XCN', `IntendedRecipientOrganization` varchar(128) default NULL COMMENT 'Format of HL7 2.x XON', `LanguageCode` varchar(64) default NULL, `LegalAuthenticator` varchar(128) default NULL COMMENT 'Format of HL7 2.x XCN', `MimeType` varchar(32) default NULL, `ParentDocumentId` varchar(64) default NULL, `ParentDocumentRelationship` varchar(64) default NULL, `PracticeSetting` varchar(64) default NULL, `PracticeSettingScheme` varchar(64) default NULL, `PracticeSettingDisplayName` varchar(64) default NULL, `Size` int(11) default NULL, `SourcePatientId` varchar(128) default NULL COMMENT 'Format of HL7 2.x CX', `Pid3` varchar(128) default NULL, `Pid5` varchar(128) default NULL, `Pid7` varchar(128) default NULL, `Pid8` varchar(128) default NULL, `Pid11` varchar(128) default NULL, `TypeCode` varchar(64) default NULL, `TypeCodeScheme` varchar(64) default NULL, `TypeCodeDisplayName` varchar(64) default NULL, `DocumentUri` varchar(128) default NULL COMMENT 'May derive this value', `RawData` blob, `Persistent` int(11) NOT NULL, PRIMARY KEY (`documentid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `document` -- LOCK TABLES `document` WRITE; /*!40000 ALTER TABLE `document` DISABLE KEYS */; /*!40000 ALTER TABLE `document` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `eventcode` -- DROP TABLE IF EXISTS `eventcode`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `eventcode` ( `eventcodeid` int(11) NOT NULL, `documentid` int(11) NOT NULL COMMENT 'Foriegn key to document table', `EventCode` varchar(64) default NULL, `EventCodeScheme` varchar(64) default NULL, `EventCodeDisplayName` varchar(64) default NULL, PRIMARY KEY (`eventcodeid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `eventcode` -- LOCK TABLES `eventcode` WRITE; /*!40000 ALTER TABLE `eventcode` DISABLE KEYS */; /*!40000 ALTER TABLE `eventcode` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `patientcorrelationdb` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patientcorrelationdb` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `patientcorrelationdb`; -- -- Table structure for table `correlatedidentifiers` -- DROP TABLE IF EXISTS `correlatedidentifiers`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `correlatedidentifiers` ( `correlationId` int(10) unsigned NOT NULL auto_increment, `PatientAssigningAuthorityId` varchar(45) NOT NULL, `PatientId` varchar(45) NOT NULL, `CorrelatedPatientAssigningAuthorityId` varchar(45) NOT NULL, `CorrelatedPatientId` varchar(45) NOT NULL, PRIMARY KEY (`correlationId`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `correlatedidentifiers` -- LOCK TABLES `correlatedidentifiers` WRITE; /*!40000 ALTER TABLE `correlatedidentifiers` DISABLE KEYS */; INSERT INTO `correlatedidentifiers` VALUES (1,'AA1','MRN-1','AA2','MRN-2'),(2,'2.16.840.1.113883.4.1','123456789','2.16.840.1.113883.3.198','D123401'),(3,'2.16.840.1.113883.3.200','500000000','2.16.840.1.113883.3.192','1018'),(4,'2.16.840.1.113883.3.200','500000000','2.16.840.1.113883.4.1','123456789'); /*!40000 ALTER TABLE `correlatedidentifiers` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2009-02-22 21:44:12