-- MySQL dump 10.11
--
-- Host: localhost    Database: auditlog
-- ------------------------------------------------------
-- 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 */;

--
-- Table structure for table `eventlog`
--

DROP TABLE IF EXISTS `eventlog`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `eventlog` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `timeStamp` datetime default NULL,
  `userId` varchar(100) default NULL,
  `participationTypeCode` smallint(5) unsigned default NULL,
  `participationTypeCodeRole` smallint(5) unsigned default NULL,
  `participationIDTypeCode` varchar(100) default NULL,
  `patientId` varchar(100) default NULL,
  `message` blob,
  `communityId` varchar(255) default NULL,
  PRIMARY KEY  USING BTREE (`id`),
  KEY `userId_index` USING BTREE (`userId`),
  KEY `communityId_index` (`communityId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `eventlog`
--

LOCK TABLES `eventlog` WRITE;
/*!40000 ALTER TABLE `eventlog` DISABLE KEYS */;
INSERT INTO `eventlog` VALUES (1,NULL,'uId999',7,7,'IDTypeCd999','PID999',NULL,'CommId999'),(2,'2008-07-18 13:40:46','',5,6,'webId123','web123',NULL,'WebComm123'),(3,NULL,'',7,8,'SOAPId123','soap123',NULL,'SOAPComm123'),(4,NULL,'',9,10,'SOAPId456','soap123',NULL,'SOAPComm456'),(5,NULL,'valluripallis',9,10,'SOAPId456','soap123',NULL,'SOAPComm456'),(6,'2008-07-18 00:30:47','valluripallis',9,10,'SOAPId456','soap123',NULL,'SOAPComm456'),(7,'2008-07-21 21:56:11','valluripallis',7,8,'webId456','web456',NULL,'WebComm456'),(8,'2008-07-23 14:27:41','valluripallis',9,1,'webId789','web789','<!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by Glen F. Marshall (HL7 Technical Steering Committee) -->\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n	<xs:element name=\"AuditMessage\">\n		<xs:complexType>\n			<xs:sequence>\n				<xs:element name=\"EventIdentification\" type=\"EventIdentificationType\"/>\n				<xs:element name=\"ActiveParticipant\" maxOccurs=\"unbounded\">\n					<xs:complexType>\n						<xs:complexContent>\n							<xs:extension base=\"ActiveParticipantType\"/>\n						</xs:complexContent>\n					</xs:complexType>\n				</xs:element>\n				<xs:element name=\"AuditSourceIdentification\" type=\"AuditSourceIdentificationType\" maxOccurs=\"unbounded\"/>\n				<xs:element name=\"ParticipantObjectIdentification\" type=\"ParticipantObjectIdentificationType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n			</xs:sequence>\n		</xs:complexType>\n	</xs:element>\n	<xs:complexType name=\"EventIdentificationType\">\n		<xs:sequence>\n			<xs:element name=\"EventID\" type=\"CodedValueType\"/>\n			<xs:element name=\"EventTypeCode\" type=\"CodedValueType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n		</xs:sequence>\n		<xs:attribute name=\"EventActionCode\" use=\"optional\">\n			<xs:simpleType>\n				<xs:restriction base=\"xs:string\">\n					<xs:enumeration value=\"C\">\n						<xs:annotation>\n							<xs:appinfo>Create</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"R\">\n						<xs:annotation>\n							<xs:appinfo>Read</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"U\">\n						<xs:annotation>\n							<xs:appinfo>Update</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"D\">\n						<xs:annotation>\n							<xs:appinfo>Delete</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"E\">\n						<xs:annotation>\n							<xs:documentation>Execute</xs:documentation>\n						</xs:annotation>\n					</xs:enumeration>\n				</xs:restriction>\n			</xs:simpleType>\n		</xs:attribute>\n		<xs:attribute name=\"EventDateTime\" type=\"xs:dateTime\" use=\"required\"/>\n		<xs:attribute name=\"EventOutcomeIndicator\" use=\"required\">\n			<xs:simpleType>\n				<xs:restriction base=\"xs:integer\">\n					<xs:enumeration value=\"0\">\n						<xs:annotation>\n							<xs:appinfo>Success</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"4\">\n						<xs:annotation>\n							<xs:appinfo>Minor failure</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"8\">\n						<xs:annotation>\n							<xs:appinfo>Serious failure</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"12\">\n						<xs:annotation>\n							<xs:appinfo>Major failure; action made unavailable \n          </xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n				</xs:restriction>\n			</xs:simpleType>\n		</xs:attribute>\n	</xs:complexType>\n	<xs:complexType name=\"AuditSourceIdentificationType\">\n		<xs:sequence>\n			<xs:element name=\"AuditSourceTypeCode\" type=\"CodedValueType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n		</xs:sequence>\n		<xs:attribute name=\"AuditEnterpriseSiteID\" type=\"xs:string\" use=\"optional\"/>\n		<xs:attribute name=\"AuditSourceID\" type=\"xs:string\" use=\"required\"/>\n	</xs:complexType>\n	<xs:complexType name=\"ActiveParticipantType\">\n		<xs:sequence minOccurs=\"0\">\n			<xs:element name=\"RoleIDCode\" type=\"CodedValueType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n		</xs:sequence>\n		<xs:attribute name=\"UserID\" type=\"xs:string\" use=\"required\"/>\n		<xs:attribute name=\"AlternativeUserID\" type=\"xs:string\" use=\"optional\"/>\n		<xs:attribute name=\"UserName\" type=\"xs:string\" use=\"optional\"/>\n		<xs:attribute name=\"UserIsRequestor\" type=\"xs:boolean\" use=\"optional\" default=\"true\"/>\n		<xs:attribute name=\"NetworkAccessPointID\" type=\"xs:string\" use=\"optional\"/>\n		<xs:attribute name=\"NetworkAccessPointTypeCode\" use=\"optional\">\n			<xs:simpleType>\n				<xs:restriction base=\"xs:unsignedByte\">\n					<xs:enumeration value=\"1\">\n						<xs:annotation>\n							<xs:appinfo>Machine Name, including DNS name</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"2\">\n						<xs:annotation>\n							<xs:appinfo>IP Address</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"3\">\n						<xs:annotation>\n							<xs:appinfo>Telephone Number</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n				</xs:restriction>\n			</xs:simpleType>\n		</xs:attribute>\n	</xs:complexType>\n	<xs:complexType name=\"ParticipantObjectIdentificationType\">\n		<xs:sequence>\n			<xs:element name=\"ParticipantObjectIDTypeCode\" type=\"CodedValueType\"/>\n			<xs:choice minOccurs=\"0\">\n				<xs:element name=\"ParticipantObjectName\" type=\"xs:string\" minOccurs=\"0\"/>\n				<xs:element name=\"ParticipantObjectQuery\" type=\"xs:base64Binary\" minOccurs=\"0\"/>\n			</xs:choice>\n			<xs:element name=\"ParticipantObjectDetail\" type=\"TypeValuePairType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n		</xs:sequence>\n		<xs:attribute name=\"ParticipantObjectID\" type=\"xs:string\" use=\"required\"/>\n		<xs:attribute name=\"ParticipantObjectTypeCode\" use=\"optional\">\n			<xs:simpleType>\n				<xs:restriction base=\"xs:unsignedByte\">\n					<xs:enumeration value=\"1\">\n						<xs:annotation>\n							<xs:appinfo>Person</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"2\">\n						<xs:annotation>\n							<xs:appinfo>System object</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"3\">\n						<xs:annotation>\n							<xs:appinfo>Organization</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"4\">\n						<xs:annotation>\n							<xs:appinfo>Other</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n				</xs:restriction>\n			</xs:simpleType>\n		</xs:attribute>\n		<xs:attribute name=\"ParticipantObjectTypeCodeRole\" use=\"optional\">\n			<xs:simpleType>\n				<xs:restriction base=\"xs:unsignedByte\">\n					<xs:enumeration value=\"1\">\n						<xs:annotation>\n							<xs:appinfo>Patient</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"2\">\n						<xs:annotation>\n							<xs:appinfo>Location</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"3\">\n						<xs:annotation>\n							<xs:appinfo> Report</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"4\">\n						<xs:annotation>\n							<xs:appinfo>Resource</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"5\">\n						<xs:annotation>\n							<xs:appinfo>Master file</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"6\">\n						<xs:annotation>\n							<xs:appinfo>User</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"7\">\n						<xs:annotation>\n							<xs:appinfo>List</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"8\">\n						<xs:annotation>\n							<xs:appinfo>Doctor</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"9\">\n						<xs:annotation>\n							<xs:appinfo>Subscriber</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"10\">\n						<xs:annotation>\n							<xs:appinfo>Guarantor</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"11\">\n						<xs:annotation>\n							<xs:appinfo>Security User Entity</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"12\">\n						<xs:annotation>\n							<xs:appinfo>Security User Group</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"13\">\n						<xs:annotation>\n							<xs:appinfo>Security Resource</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"14\">\n						<xs:annotation>\n							<xs:appinfo>Security Granualarity Definition</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"15\">\n						<xs:annotation>\n							<xs:appinfo>Provider</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"16\">\n						<xs:annotation>\n							<xs:appinfo>Report Destination</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"17\">\n						<xs:annotation>\n							<xs:appinfo>Report Library</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"18\">\n						<xs:annotation>\n							<xs:appinfo>Schedule</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"19\">\n						<xs:annotation>\n							<xs:appinfo>Customer</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"20\">\n						<xs:annotation>\n							<xs:appinfo>Job</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"21\">\n						<xs:annotation>\n							<xs:appinfo>Job Stream</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"22\">\n						<xs:annotation>\n							<xs:appinfo>Table</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"23\">\n						<xs:annotation>\n							<xs:appinfo>Routing Criteria</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"24\">\n						<xs:annotation>\n							<xs:appinfo>Query</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n				</xs:restriction>\n			</xs:simpleType>\n		</xs:attribute>\n		<xs:attribute name=\"ParticipantObjectDataLifeCycle\" use=\"optional\">\n			<xs:simpleType>\n				<xs:restriction base=\"xs:unsignedByte\">\n					<xs:enumeration value=\"1\">\n						<xs:annotation>\n							<xs:appinfo>Origination / Creation</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"2\">\n						<xs:annotation>\n							<xs:appinfo>Import / Copy from original </xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"3\">\n						<xs:annotation>\n							<xs:appinfo>Amendment</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"4\">\n						<xs:annotation>\n							<xs:appinfo>Verification</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"5\">\n						<xs:annotation>\n							<xs:appinfo>Translation</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"6\">\n						<xs:annotation>\n							<xs:appinfo>Access / Use</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"7\">\n						<xs:annotation>\n							<xs:appinfo>De-identification</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"8\">\n						<xs:annotation>\n							<xs:appinfo>Aggregation, summarization, derivation</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"9\">\n						<xs:annotation>\n							<xs:appinfo>Report</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"10\">\n						<xs:annotation>\n							<xs:appinfo>Export / Copy to target</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"11\">\n						<xs:annotation>\n							<xs:appinfo>Disclosure</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"12\">\n						<xs:annotation>\n							<xs:appinfo>Receipt of disclosure</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"13\">\n						<xs:annotation>\n							<xs:appinfo>Archiving</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"14\">\n						<xs:annotation>\n							<xs:appinfo>Logical deletion</xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n					<xs:enumeration value=\"15\">\n						<xs:annotation>\n							<xs:appinfo>Permanent erasure / Physical destruction </xs:appinfo>\n						</xs:annotation>\n					</xs:enumeration>\n				</xs:restriction>\n			</xs:simpleType>\n		</xs:attribute>\n		<xs:attribute name=\"ParticipantObjectSensitivity\" type=\"xs:string\" use=\"optional\"/>\n	</xs:complexType>\n	<xs:complexType name=\"CodedValueType\">\n		<xs:attribute name=\"code\" type=\"xs:string\" use=\"required\"/>\n		<xs:attributeGroup ref=\"CodeSystem\"/>\n		<xs:attribute name=\"displayName\" type=\"xs:string\" use=\"optional\"/>\n		<xs:attribute name=\"originalText\" type=\"xs:string\" use=\"optional\"/>\n	</xs:complexType>\n	<xs:complexType name=\"TypeValuePairType\">\n		<xs:attribute name=\"type\" type=\"xs:string\" use=\"required\"/>\n		<xs:attribute name=\"value\" type=\"xs:base64Binary\" use=\"required\"/>\n	</xs:complexType>\n	<xs:attributeGroup name=\"CodeSystem\">\n		<xs:attribute name=\"codeSystem\" type=\"OID\" use=\"optional\"/>\n		<xs:attribute name=\"codeSystemName\" type=\"xs:string\" use=\"optional\"/>\n	</xs:attributeGroup>\n	<xs:simpleType name=\"OID\">\n		<xs:restriction base=\"xs:string\">\n			<xs:whiteSpace value=\"collapse\"/>\n		</xs:restriction>\n	</xs:simpleType>\n</xs:schema>\n','WebComm789');
/*!40000 ALTER TABLE `eventlog` 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 2008-07-28 18:45:53
