Build #11,646

Deploys Reference Application SNAPSHOT to maven

Build: #11646 failed

Job: Build standalone failed

Stages & jobs

  1. Deploy Reference Application

  2. Deploy docker image

  3. Deploy to qa-refapp

  4. Validate

  5. Release

    Requires a user to start manually
  6. Set variables

  7. Release others

Build log

The build generated 15,156 lines of output.The output is too long and has been truncated to the last 1,000 lines. Download or view full build log

10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `report_schema_xml`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `report_schema_xml` (
10-Aug-2021 20:36:28   `report_schema_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:28   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `description` text NOT NULL,
10-Aug-2021 20:36:28   `xml_data` text NOT NULL,
10-Aug-2021 20:36:28   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   PRIMARY KEY (`report_schema_id`),
10-Aug-2021 20:36:28   UNIQUE KEY `report_schema_xml_uuid_index` (`uuid`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Dumping data for table `report_schema_xml`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 LOCK TABLES `report_schema_xml` WRITE
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `report_schema_xml` DISABLE KEYS */
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `report_schema_xml` ENABLE KEYS */
10-Aug-2021 20:36:28 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Table structure for table `reporting_report_design`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `reporting_report_design`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `reporting_report_design` (
10-Aug-2021 20:36:28   `id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:28   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `description` varchar(1000) DEFAULT NULL,
10-Aug-2021 20:36:28   `renderer_type` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `properties` text,
10-Aug-2021 20:36:28   `creator` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:28   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:28   `report_definition_uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   PRIMARY KEY (`id`),
10-Aug-2021 20:36:28   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:28   KEY `creator_for_reporting_report_design` (`creator`),
10-Aug-2021 20:36:28   KEY `changed_by_for_reporting_report_design` (`changed_by`),
10-Aug-2021 20:36:28   KEY `retired_by_for_reporting_report_design` (`retired_by`),
10-Aug-2021 20:36:28   KEY `report_definition_uuid_for_reporting_report_design` (`report_definition_uuid`),
10-Aug-2021 20:36:28   CONSTRAINT `changed_by_for_reporting_report_design` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:28   CONSTRAINT `creator_for_reporting_report_design` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:28   CONSTRAINT `retired_by_for_reporting_report_design` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Dumping data for table `reporting_report_design`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 LOCK TABLES `reporting_report_design` WRITE
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_design` DISABLE KEYS */
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_design` ENABLE KEYS */
10-Aug-2021 20:36:28 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Table structure for table `reporting_report_design_resource`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `reporting_report_design_resource`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `reporting_report_design_resource` (
10-Aug-2021 20:36:28   `id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:28   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `description` varchar(1000) DEFAULT NULL,
10-Aug-2021 20:36:28   `report_design_id` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `content_type` varchar(50) DEFAULT NULL,
10-Aug-2021 20:36:28   `extension` varchar(20) DEFAULT NULL,
10-Aug-2021 20:36:28   `contents` longblob,
10-Aug-2021 20:36:28   `creator` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:28   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:28   PRIMARY KEY (`id`),
10-Aug-2021 20:36:28   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:28   KEY `report_design_id_for_reporting_report_design_resource` (`report_design_id`),
10-Aug-2021 20:36:28   KEY `creator_for_reporting_report_design_resource` (`creator`),
10-Aug-2021 20:36:28   KEY `changed_by_for_reporting_report_design_resource` (`changed_by`),
10-Aug-2021 20:36:28   KEY `retired_by_for_reporting_report_design_resource` (`retired_by`),
10-Aug-2021 20:36:28   CONSTRAINT `retired_by_for_reporting_report_design_resource` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:28   CONSTRAINT `changed_by_for_reporting_report_design_resource` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:28   CONSTRAINT `creator_for_reporting_report_design_resource` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:28   CONSTRAINT `report_design_id_for_reporting_report_design_resource` FOREIGN KEY (`report_design_id`) REFERENCES `reporting_report_design` (`id`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Dumping data for table `reporting_report_design_resource`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 LOCK TABLES `reporting_report_design_resource` WRITE
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_design_resource` DISABLE KEYS */
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_design_resource` ENABLE KEYS */
10-Aug-2021 20:36:28 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Table structure for table `reporting_report_processor`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `reporting_report_processor`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `reporting_report_processor` (
10-Aug-2021 20:36:28   `id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:28   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `description` varchar(1000) DEFAULT NULL,
10-Aug-2021 20:36:28   `processor_type` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `configuration` mediumtext,
10-Aug-2021 20:36:28   `run_on_success` tinyint(1) NOT NULL DEFAULT '1',
10-Aug-2021 20:36:28   `run_on_error` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `creator` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:28   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:28   `report_design_id` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   `processor_mode` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:28   PRIMARY KEY (`id`),
10-Aug-2021 20:36:28   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:28   KEY `creator_for_reporting_report_processor` (`creator`),
10-Aug-2021 20:36:28   KEY `changed_by_for_reporting_report_processor` (`changed_by`),
10-Aug-2021 20:36:28   KEY `retired_by_for_reporting_report_processor` (`retired_by`),
10-Aug-2021 20:36:28   KEY `reporting_report_processor_report_design` (`report_design_id`),
10-Aug-2021 20:36:28   CONSTRAINT `changed_by_for_reporting_report_processor` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:28   CONSTRAINT `creator_for_reporting_report_processor` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:28   CONSTRAINT `reporting_report_processor_report_design` FOREIGN KEY (`report_design_id`) REFERENCES `reporting_report_design` (`id`),
10-Aug-2021 20:36:28   CONSTRAINT `retired_by_for_reporting_report_processor` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Dumping data for table `reporting_report_processor`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 LOCK TABLES `reporting_report_processor` WRITE
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_processor` DISABLE KEYS */
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_processor` ENABLE KEYS */
10-Aug-2021 20:36:28 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Table structure for table `reporting_report_request`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `reporting_report_request`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `reporting_report_request` (
10-Aug-2021 20:36:28   `id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:28   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   `base_cohort_uuid` char(38) DEFAULT NULL,
10-Aug-2021 20:36:28   `base_cohort_parameters` text,
10-Aug-2021 20:36:28   `report_definition_uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   `report_definition_parameters` text,
10-Aug-2021 20:36:28   `renderer_type` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `renderer_argument` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:28   `requested_by` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `request_datetime` datetime NOT NULL,
10-Aug-2021 20:36:28   `priority` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `status` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   `evaluation_start_datetime` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `evaluation_complete_datetime` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `render_complete_datetime` datetime DEFAULT NULL,
10-Aug-2021 20:36:28   `description` varchar(1000) DEFAULT NULL,
10-Aug-2021 20:36:28   `schedule` varchar(100) DEFAULT NULL,
10-Aug-2021 20:36:28   `process_automatically` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:28   `minimum_days_to_preserve` int(11) DEFAULT NULL,
10-Aug-2021 20:36:28   PRIMARY KEY (`id`),
10-Aug-2021 20:36:28   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:28   KEY `requested_by_for_reporting_report_request` (`requested_by`),
10-Aug-2021 20:36:28   CONSTRAINT `requested_by_for_reporting_report_request` FOREIGN KEY (`requested_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Dumping data for table `reporting_report_request`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 LOCK TABLES `reporting_report_request` WRITE
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_request` DISABLE KEYS */
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `reporting_report_request` ENABLE KEYS */
10-Aug-2021 20:36:28 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Table structure for table `role`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `role`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `role` (
10-Aug-2021 20:36:28   `role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 20:36:28   `description` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:28   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:28   PRIMARY KEY (`role`),
10-Aug-2021 20:36:28   UNIQUE KEY `role_uuid_index` (`uuid`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Dumping data for table `role`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 LOCK TABLES `role` WRITE
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `role` DISABLE KEYS */
10-Aug-2021 20:36:28 [INFO] INSERT INTO `role` VALUES ('Anonymous','Privileges for non-authenticated users.','774b2af3-6437-4e5a-a310-547554c7c65c'),('Application: Administers System','Administers system','0a7d9c09-95c5-4e1c-881e-0f61244019b1'),('Application: Configures Appointment Scheduling','Gives user the ability to add and edit appointment types','11d22975-9a36-4c42-bccc-4b15bd408fff'),('Application: Configures Forms','Manages forms and attaches them to the UI','88ad8832-0108-4209-b878-1a5779663f60'),('Application: Configures Metadata','Access to Configure Metadata app','04e2b110-7481-420c-b31b-21edbc7413ce'),('Application: Edits Existing Encounters','Gives user the ability to edit patient encounter','bbbc78f3-c44d-4ca6-a332-15aff95eae17'),('Application: Enters ADT Events','Enters ADT events','2c54ef03-43ba-4f1f-9b4f-3fad3c729a1b'),('Application: Enters Vitals','Enters vitals','aa381411-c70b-42a7-9035-dac0eb17be3d'),('Application: Has Super User Privileges','Extends the underlying System Developer API role','783088cf-2b44-40e1-86ab-33ea19819828'),('Application: Manages Atlas','Can configure whether/how this implementation is displayed on the OpenMRS Atlas','b045386d-25b6-4798-a873-fc4efa123aa1'),('Application: Manages Provider Schedules','Gives user ability to add and edit provider schedules','fffbfa21-d518-4913-8593-5f1a471a974e'),('Application: Records Allergies','Records and edits allergies','ed7c8f62-c7d1-4e50-9965-bef0c378949b'),('Application: Registers Patients','Registers patients','7760d8e6-e0f3-4e3e-8a20-8c6e6180f64f'),('Application: Requests Appointments','Gives user the ability to request appointments)','3ccb7327-d50d-4f9c-99da-1accf0f8e4d2'),('Application: Schedules And Overbooks Appointments','Gives user the ability to overbook appointments(In addition to being able to view appointment requests, view and schedule appointments)','92e94b7a-0d7a-4d41-a24e-ee41dc3bbf04'),('Application: Schedules Appointments','Gives user the ability to view appointment requests, view and schedule appointments','5789d510-d6c6-468b-8799-5b2070c137b2'),('Application: Sees Appointment Schedule','Gives user the ability to view appointment schedules (but not to modify them)','36746bdf-495f-4b96-91dc-f5c0778d9b86'),('Application: Uses Capture Vitals App','Uses capture vitals app','6d7d056e-d012-4715-ba08-80a6b7bcc302'),('Application: Uses Patient Summary','Uses patient summary','8f98d8ca-3f0e-48a0-8175-177a97cb97db'),('Application: Writes Clinical Notes','Writes clinical notes','b7da9707-5020-465b-a2f2-64aacf7a9a53'),('Authenticated','Privileges gained once authentication has been established.','f7fd42ef-880e-40c5-972d-e4ae7c990de2'),('Organizational: Doctor','Doctor','96eee795-fd12-41ce-bd54-b5bd5e5a86b7'),('Organizational: Hospital Administrator','Hospital Administrator','d3e11f79-7528-44c5-a014-8ef57ef24910'),('Organizational: Nurse','Nurse','d0b33fab-4827-4125-99e2-e906e80bbcae'),('Organizational: Registration Clerk','Registration Clerk','c9b69f6f-142b-49f5-af40-7ca90ff18100'),('Organizational: System Administrator','System Administrator','b86d654b-1d07-480c-b154-47372d23b5c0'),('Privilege Level: Full','A role that has all API privileges','ab2160f6-0941-430c-9752-6714353fbd3c'),('Provider','All users with the \'Provider\' role will appear as options in the default Infopath ','8d94f280-c2cc-11de-8d13-0010c6dffd0f'),('System Developer','Developers of the OpenMRS .. have additional access to change fundamental structure of the database model.','8d94f852-c2cc-11de-8d13-0010c6dffd0f')
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `role` ENABLE KEYS */
10-Aug-2021 20:36:28 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Table structure for table `role_privilege`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `role_privilege`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `role_privilege` (
10-Aug-2021 20:36:28   `role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 20:36:28   `privilege` varchar(255) NOT NULL,
10-Aug-2021 20:36:28   PRIMARY KEY (`privilege`,`role`),
10-Aug-2021 20:36:28   KEY `role_privilege_to_role` (`role`),
10-Aug-2021 20:36:28   CONSTRAINT `privilege_definitions` FOREIGN KEY (`privilege`) REFERENCES `privilege` (`privilege`),
10-Aug-2021 20:36:28   CONSTRAINT `role_privilege_to_role` FOREIGN KEY (`role`) REFERENCES `role` (`role`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Dumping data for table `role_privilege`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 LOCK TABLES `role_privilege` WRITE
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `role_privilege` DISABLE KEYS */
10-Aug-2021 20:36:28 [INFO] INSERT INTO `role_privilege` VALUES ('Application: Administers System','App: coreapps.systemAdministration'),('Application: Administers System','App: referenceapplication.legacyAdmin'),('Application: Configures Appointment Scheduling','App: appointmentschedulingui.appointmentTypes'),('Application: Configures Appointment Scheduling','App: appointmentschedulingui.home'),('Application: Configures Forms','App: coreapps.configuremetadata'),('Application: Configures Forms','App: formentryapp.forms'),('Application: Configures Metadata','App: coreapps.configuremetadata'),('Application: Edits Existing Encounters','Task: emr.patient.encounter.delete'),('Application: Edits Existing Encounters','Task: emr.patient.encounter.edit'),('Application: Enters ADT Events','App: coreapps.activeVisits'),('Application: Enters ADT Events','App: coreapps.findPatient'),('Application: Enters ADT Events','Task: coreapps.createRetrospectiveVisit'),('Application: Enters ADT Events','Task: coreapps.createVisit'),('Application: Enters ADT Events','Task: coreapps.endVisit'),('Application: Enters ADT Events','Task: coreapps.mergeVisits'),('Application: Enters ADT Events','Task: referenceapplication.simpleAdmission'),('Application: Enters ADT Events','Task: referenceapplication.simpleDischarge'),('Application: Enters ADT Events','Task: referenceapplication.simpleTransfer'),('Application: Enters Vitals','App: coreapps.activeVisits'),('Application: Enters Vitals','App: coreapps.findPatient'),('Application: Enters Vitals','Task: referenceapplication.vitals'),('Application: Manages Atlas','App: atlas.manage'),('Application: Manages Atlas','App: coreapps.systemAdministration'),('Application: Manages Provider Schedules','App: appointmentschedulingui.home'),('Application: Manages Provider Schedules','App: appointmentschedulingui.providerSchedules'),('Application: Records Allergies','Task: Modify Allergies'),('Application: Registers Patients','App: coreapps.activeVisits'),('Application: Registers Patients','App: coreapps.patientDashboard'),('Application: Registers Patients','App: registrationapp.registerPatient'),('Application: Requests Appointments','Task: appointmentschedulingui.requestAppointments'),('Application: Schedules And Overbooks Appointments','Task: appointmentschedulingui.overbookAppointments'),('Application: Schedules Appointments','Task: appointmentschedulingui.bookAppointments'),('Application: Schedules Appointments','Task: appointmentschedulingui.viewConfidential'),('Application: Sees Appointment Schedule','App: appointmentschedulingui.home'),('Application: Sees Appointment Schedule','App: appointmentschedulingui.viewAppointments'),('Application: Uses Capture Vitals App','App: referenceapplication.vitals'),('Application: Uses Patient Summary','App: coreapps.findPatient'),('Application: Uses Patient Summary','App: coreapps.patientDashboard'),('Application: Uses Patient Summary','App: coreapps.patientVisits'),('Application: Writes Clinical Notes','App: coreapps.activeVisits'),('Application: Writes Clinical Notes','App: coreapps.findPatient'),('Application: Writes Clinical Notes','Task: referenceapplication.simpleVisitNote'),('Authenticated','Get Concept Classes'),('Authenticated','Get Concept Datatypes'),('Authenticated','Get Encounter Types'),('Authenticated','Get Field Types'),('Authenticated','Get Global Properties'),('Authenticated','Get Identifier Types'),('Authenticated','Get Locations'),('Authenticated','Get Order Types'),('Authenticated','Get Person Attribute Types'),('Authenticated','Get Privileges'),('Authenticated','Get Relationship Types'),('Authenticated','Get Relationships'),('Authenticated','Get Roles'),('Authenticated','Patient Overview - View Relationships'),('Authenticated','View Concept Classes'),('Authenticated','View Concept Datatypes'),('Authenticated','View Encounter Types'),('Authenticated','View Field Types'),('Authenticated','View Global Properties'),('Authenticated','View Identifier Types'),('Authenticated','View Locations'),('Authenticated','View Order Types'),('Authenticated','View Person Attribute Types'),('Authenticated','View Privileges'),('Authenticated','View Relationship Types'),('Authenticated','View Relationships'),('Authenticated','View Roles'),('Privilege Level: Full','Add Allergies'),('Privilege Level: Full','Add Cohorts'),('Privilege Level: Full','Add Concept Proposals'),('Privilege Level: Full','Add Encounters'),('Privilege Level: Full','Add HL7 Inbound Archive'),('Privilege Level: Full','Add HL7 Inbound Exception'),('Privilege Level: Full','Add HL7 Inbound Queue'),('Privilege Level: Full','Add HL7 Source'),('Privilege Level: Full','Add Observations'),('Privilege Level: Full','Add Orders'),('Privilege Level: Full','Add Patient Identifiers'),('Privilege Level: Full','Add Patient Programs'),('Privilege Level: Full','Add Patients'),('Privilege Level: Full','Add People'),('Privilege Level: Full','Add Problems'),('Privilege Level: Full','Add Relationships'),('Privilege Level: Full','Add Report Objects'),('Privilege Level: Full','Add Reports'),('Privilege Level: Full','Add Users'),('Privilege Level: Full','Add Visits'),('Privilege Level: Full','Assign System Developer Role'),('Privilege Level: Full','Configure Visits'),('Privilege Level: Full','Delete Cohorts'),('Privilege Level: Full','Delete Concept Proposals'),('Privilege Level: Full','Delete Encounters'),('Privilege Level: Full','Delete HL7 Inbound Archive'),('Privilege Level: Full','Delete HL7 Inbound Exception'),('Privilege Level: Full','Delete HL7 Inbound Queue'),('Privilege Level: Full','Delete Notes'),('Privilege Level: Full','Delete Observations'),('Privilege Level: Full','Delete Orders'),('Privilege Level: Full','Delete Patient Identifiers'),('Privilege Level: Full','Delete Patient Programs'),('Privilege Level: Full','Delete Patients'),('Privilege Level: Full','Delete People'),('Privilege Level: Full','Delete Relationships'),('Privilege Level: Full','Delete Report Objects'),('Privilege Level: Full','Delete Reports'),('Privilege Level: Full','Delete Users'),('Privilege Level: Full','Delete Visits'),('Privilege Level: Full','Edit Allergies'),('Privilege Level: Full','Edit Cohorts'),('Privilege Level: Full','Edit Concept Proposals'),('Privilege Level: Full','Edit Encounters'),('Privilege Level: Full','Edit Notes'),('Privilege Level: Full','Edit Observations'),('Privilege Level: Full','Edit Orders'),('Privilege Level: Full','Edit Patient Identifiers'),('Privilege Level: Full','Edit Patient Programs'),('Privilege Level: Full','Edit Patients'),('Privilege Level: Full','Edit People'),('Privilege Level: Full','Edit Problems'),('Privilege Level: Full','Edit Relationships'),('Privilege Level: Full','Edit Report Objects'),('Privilege Level: Full','Edit Reports'),('Privilege Level: Full','Edit User Passwords'),('Privilege Level: Full','Edit Users'),('Privilege Level: Full','Edit Visits'),('Privilege Level: Full','Form Entry'),('Privilege Level: Full','Generate Batch of Identifiers'),('Privilege Level: Full','Get Allergies'),('Privilege Level: Full','Get Care Settings'),('Privilege Level: Full','Get Concept Attribute Types'),('Privilege Level: Full','Get Concept Classes'),('Privilege Level: Full','Get Concept Datatypes'),('Privilege Level: Full','Get Concept Map Types'),('Privilege Level: Full','Get Concept Proposals'),('Privilege Level: Full','Get Concept Reference Terms'),('Privilege Level: Full','Get Concept Sources'),('Privilege Level: Full','Get Concepts'),('Privilege Level: Full','Get Database Changes'),('Privilege Level: Full','Get Encounter Roles'),('Privilege Level: Full','Get Encounter Types'),('Privilege Level: Full','Get Encounters'),('Privilege Level: Full','Get Field Types'),('Privilege Level: Full','Get Forms'),('Privilege Level: Full','Get Global Properties'),('Privilege Level: Full','Get HL7 Inbound Archive'),('Privilege Level: Full','Get HL7 Inbound Exception'),('Privilege Level: Full','Get HL7 Inbound Queue'),('Privilege Level: Full','Get HL7 Source'),('Privilege Level: Full','Get Identifier Types'),('Privilege Level: Full','Get Location Attribute Types'),('Privilege Level: Full','Get Locations'),('Privilege Level: Full','Get Notes'),('Privilege Level: Full','Get Observations'),('Privilege Level: Full','Get Order Frequencies'),('Privilege Level: Full','Get Order Sets'),('Privilege Level: Full','Get Order Types'),('Privilege Level: Full','Get Orders'),('Privilege Level: Full','Get Patient Cohorts'),('Privilege Level: Full','Get Patient Identifiers'),('Privilege Level: Full','Get Patient Programs'),('Privilege Level: Full','Get Patients'),('Privilege Level: Full','Get People'),('Privilege Level: Full','Get Person Attribute Types'),('Privilege Level: Full','Get Privileges'),('Privilege Level: Full','Get Problems'),('Privilege Level: Full','Get Programs'),('Privilege Level: Full','Get Providers'),('Privilege Level: Full','Get Relationship Types'),('Privilege Level: Full','Get Relationships'),('Privilege Level: Full','Get Roles'),('Privilege Level: Full','Get Users'),('Privilege Level: Full','Get Visit Attribute Types'),('Privilege Level: Full','Get Visit Types'),('Privilege Level: Full','Get Visits'),('Privilege Level: Full','Manage Address Templates'),('Privilege Level: Full','Manage Alerts'),('Privilege Level: Full','Manage Appointment Types'),('Privilege Level: Full','Manage Appointments Settings'),('Privilege Level: Full','Manage Atlas Data'),('Privilege Level: Full','Manage Auto Generation Options'),('Privilege Level: Full','Manage Cohort Definitions'),('Privilege Level: Full','Manage Concept Attribute Types'),('Privilege Level: Full','Manage Concept Classes'),('Privilege Level: Full','Manage Concept Datatypes'),('Privilege Level: Full','Manage Concept Map Types'),('Privilege Level: Full','Manage Concept Name tags'),('Privilege Level: Full','Manage Concept Reference Terms'),('Privilege Level: Full','Manage Concept Sources'),('Privilege Level: Full','Manage Concept Stop Words'),('Privilege Level: Full','Manage Concepts'),('Privilege Level: Full','Manage Data Set Definitions'),('Privilege Level: Full','Manage Dimension Definitions'),('Privilege Level: Full','Manage Encounter Roles'),('Privilege Level: Full','Manage Encounter Types'),('Privilege Level: Full','Manage Field Types'),('Privilege Level: Full','Manage FormEntry XSN'),('Privilege Level: Full','Manage Forms'),('Privilege Level: Full','Manage Global Properties'),('Privilege Level: Full','Manage HL7 Messages'),('Privilege Level: Full','Manage Identifier Sources'),('Privilege Level: Full','Manage Identifier Types'),('Privilege Level: Full','Manage Implementation Id'),('Privilege Level: Full','Manage Indicator Definitions'),('Privilege Level: Full','Manage Location Attribute Types'),('Privilege Level: Full','Manage Location Tags'),('Privilege Level: Full','Manage Locations'),('Privilege Level: Full','Manage Metadata Mapping'),('Privilege Level: Full','Manage Modules'),('Privilege Level: Full','Manage Order Frequencies'),('Privilege Level: Full','Manage Order Sets'),('Privilege Level: Full','Manage Order Types'),('Privilege Level: Full','Manage OWA'),('Privilege Level: Full','Manage Person Attribute Types'),('Privilege Level: Full','Manage Privileges'),('Privilege Level: Full','Manage Programs'),('Privilege Level: Full','Manage Provider Schedules'),('Privilege Level: Full','Manage Providers'),('Privilege Level: Full','Manage Relationship Types'),('Privilege Level: Full','Manage Relationships'),('Privilege Level: Full','Manage Report Definitions'),('Privilege Level: Full','Manage Report Designs'),('Privilege Level: Full','Manage Reports'),('Privilege Level: Full','Manage RESTWS'),('Privilege Level: Full','Manage Roles'),('Privilege Level: Full','Manage Scheduled Report Tasks'),('Privilege Level: Full','Manage Scheduler'),('Privilege Level: Full','Manage Search Index'),('Privilege Level: Full','Manage synonym group'),('Privilege Level: Full','Manage Synonym Groups'),('Privilege Level: Full','Manage Token Registrations'),('Privilege Level: Full','Manage Visit Attribute Types'),('Privilege Level: Full','Manage Visit Types'),('Privilege Level: Full','Patient Dashboard - View Chart Search Section'),('Privilege Level: Full','Patient Dashboard - View Demographics Section'),('Privilege Level: Full','Patient Dashboard - View Encounters Section'),('Privilege Level: Full','Patient Dashboard - View Forms Section'),('Privilege Level: Full','Patient Dashboard - View Graphs Section'),('Privilege Level: Full','Patient Dashboard - View Overview Section'),('Privilege Level: Full','Patient Dashboard - View Patient Summary'),('Privilege Level: Full','Patient Dashboard - View Regimen Section'),('Privilege Level: Full','Patient Overview - View Allergies'),('Privilege Level: Full','Patient Overview - View Patient Actions'),('Privilege Level: Full','Patient Overview - View Problem List'),('Privilege Level: Full','Patient Overview - View Programs'),('Privilege Level: Full','Patient Overview - View Relationships'),('Privilege Level: Full','Provider Management - Admin'),('Privilege Level: Full','Provider Management API'),('Privilege Level: Full','Provider Management API - Read-only'),('Privilege Level: Full','Provider Management Dashboard - Edit Patients'),('Privilege Level: Full','Provider Management Dashboard - Edit Providers'),('Privilege Level: Full','Provider Management Dashboard - View Historical'),('Privilege Level: Full','Provider Management Dashboard - View Patients'),('Privilege Level: Full','Provider Management Dashboard - View Providers'),('Privilege Level: Full','Purge Field Types'),('Privilege Level: Full','Remove Allergies'),('Privilege Level: Full','Remove Problems'),('Privilege Level: Full','Request Appointments'),('Privilege Level: Full','Run Chart Search commands'),('Privilege Level: Full','Run Reports'),('Privilege Level: Full','Schedule Appointments'),('Privilege Level: Full','Share Metadata'),('Privilege Level: Full','Squeezing Appointments'),('Privilege Level: Full','Update Appointment Status'),('Privilege Level: Full','Update HL7 Inbound Archive'),('Privilege Level: Full','Update HL7 Inbound Exception'),('Privilege Level: Full','Update HL7 Inbound Queue'),('Privilege Level: Full','Update HL7 Source'),('Privilege Level: Full','Upload Batch of Identifiers'),('Privilege Level: Full','Upload XSN'),('Privilege Level: Full','View Administration Functions'),('Privilege Level: Full','View Allergies'),('Privilege Level: Full','View Appointment Types'),('Privilege Level: Full','View Appointments'),('Privilege Level: Full','View Appointments Blocks'),('Privilege Level: Full','View Appointments Statistics'),('Privilege Level: Full','View Calculations'),('Privilege Level: Full','View Concept Classes'),('Privilege Level: Full','View Concept Datatypes'),('Privilege Level: Full','View Concept Proposals'),('Privilege Level: Full','View Concept Sources'),('Privilege Level: Full','View Concepts'),('Privilege Level: Full','View Data Entry Statistics'),('Privilege Level: Full','View Encounter Types'),('Privilege Level: Full','View Encounters'),('Privilege Level: Full','View Field Types'),('Privilege Level: Full','View Forms'),('Privilege Level: Full','View Global Properties'),('Privilege Level: Full','View Identifier Types'),('Privilege Level: Full','View Locations'),('Privilege Level: Full','View Metadata Via Mapping'),('Privilege Level: Full','View Navigation Menu'),('Privilege Level: Full','View Observations'),('Privilege Level: Full','View Order Types'),('Privilege Level: Full','View Orders'),('Privilege Level: Full','View Patient Appointment History'),('Privilege Level: Full','View Patient Cohorts'),('Privilege Level: Full','View Patient Identifiers'),('Privilege Level: Full','View Patient Programs'),('Privilege Level: Full','View Patients'),('Privilege Level: Full','View People'),('Privilege Level: Full','View Person Attribute Types'),('Privilege Level: Full','View Privileges'),('Privilege Level: Full','View Problems'),('Privilege Level: Full','View Programs'),('Privilege Level: Full','View Provider Schedules'),('Privilege Level: Full','View Relationship Types'),('Privilege Level: Full','View Relationships'),('Privilege Level: Full','View Report Objects'),('Privilege Level: Full','View Reports'),('Privilege Level: Full','View RESTWS'),('Privilege Level: Full','View Roles'),('Privilege Level: Full','View Token Registrations'),('Privilege Level: Full','View Unpublished Forms'),('Privilege Level: Full','View Users')
10-Aug-2021 20:36:28 [INFO] /*!40000 ALTER TABLE `role_privilege` ENABLE KEYS */
10-Aug-2021 20:36:28 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:28 [INFO] --
10-Aug-2021 20:36:28 -- Table structure for table `role_role`
10-Aug-2021 20:36:28 --
10-Aug-2021 20:36:28
10-Aug-2021 20:36:28 DROP TABLE IF EXISTS `role_role`
10-Aug-2021 20:36:28 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:28 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:28 [INFO] CREATE TABLE `role_role` (
10-Aug-2021 20:36:28   `parent_role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 20:36:28   `child_role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 20:36:28   PRIMARY KEY (`parent_role`,`child_role`),
10-Aug-2021 20:36:28   KEY `inherited_role` (`child_role`),
10-Aug-2021 20:36:28   CONSTRAINT `inherited_role` FOREIGN KEY (`child_role`) REFERENCES `role` (`role`),
10-Aug-2021 20:36:28   CONSTRAINT `parent_role` FOREIGN KEY (`parent_role`) REFERENCES `role` (`role`)
10-Aug-2021 20:36:28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Dumping data for table `role_role`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 LOCK TABLES `role_role` WRITE
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `role_role` DISABLE KEYS */
10-Aug-2021 20:36:29 [INFO] INSERT INTO `role_role` VALUES ('Privilege Level: Full','Application: Administers System'),('Privilege Level: Full','Application: Configures Appointment Scheduling'),('Privilege Level: Full','Application: Configures Forms'),('Privilege Level: Full','Application: Configures Metadata'),('Privilege Level: Full','Application: Edits Existing Encounters'),('Privilege Level: Full','Application: Enters ADT Events'),('Privilege Level: Full','Application: Enters Vitals'),('Privilege Level: Full','Application: Has Super User Privileges'),('System Developer','Application: Has Super User Privileges'),('Privilege Level: Full','Application: Manages Atlas'),('Privilege Level: Full','Application: Manages Provider Schedules'),('Privilege Level: Full','Application: Records Allergies'),('Privilege Level: Full','Application: Registers Patients'),('Privilege Level: Full','Application: Requests Appointments'),('Application: Schedules Appointments','Application: Schedules And Overbooks Appointments'),('Privilege Level: Full','Application: Schedules And Overbooks Appointments'),('Application: Sees Appointment Schedule','Application: Schedules Appointments'),('Privilege Level: Full','Application: Schedules Appointments'),('Privilege Level: Full','Application: Sees Appointment Schedule'),('Privilege Level: Full','Application: Uses Capture Vitals App'),('Privilege Level: Full','Application: Uses Patient Summary'),('Privilege Level: Full','Application: Writes Clinical Notes'),('Application: Enters ADT Events','Organizational: Doctor'),('Application: Records Allergies','Organizational: Doctor'),('Application: Requests Appointments','Organizational: Doctor'),('Application: Sees Appointment Schedule','Organizational: Doctor'),('Application: Uses Patient Summary','Organizational: Doctor'),('Application: Writes Clinical Notes','Organizational: Doctor'),('Application: Configures Appointment Scheduling','Organizational: Hospital Administrator'),('Application: Manages Provider Schedules','Organizational: Hospital Administrator'),('Application: Requests Appointments','Organizational: Hospital Administrator'),('Application: Schedules And Overbooks Appointments','Organizational: Hospital Administrator'),('Application: Enters ADT Events','Organizational: Nurse'),('Application: Enters Vitals','Organizational: Nurse'),('Application: Records Allergies','Organizational: Nurse'),('Application: Requests Appointments','Organizational: Nurse'),('Application: Sees Appointment Schedule','Organizational: Nurse'),('Application: Uses Capture Vitals App','Organizational: Nurse'),('Application: Uses Patient Summary','Organizational: Nurse'),('Application: Registers Patients','Organizational: Registration Clerk'),('Application: Schedules Appointments','Organizational: Registration Clerk'),('Application: Sees Appointment Schedule','Organizational: Registration Clerk'),('Application: Administers System','Organizational: System Administrator'),('Application: Configures Appointment Scheduling','Organizational: System Administrator'),('Application: Configures Forms','Organizational: System Administrator'),('Application: Configures Metadata','Organizational: System Administrator'),('Application: Manages Atlas','Organizational: System Administrator'),('Application: Manages Provider Schedules','Organizational: System Administrator')
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `role_role` ENABLE KEYS */
10-Aug-2021 20:36:29 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Table structure for table `scheduler_task_config`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 DROP TABLE IF EXISTS `scheduler_task_config`
10-Aug-2021 20:36:29 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:29 [INFO] CREATE TABLE `scheduler_task_config` (
10-Aug-2021 20:36:29   `task_config_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:29   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:29   `description` varchar(1024) DEFAULT NULL,
10-Aug-2021 20:36:29   `schedulable_class` text,
10-Aug-2021 20:36:29   `start_time` datetime DEFAULT NULL,
10-Aug-2021 20:36:29   `start_time_pattern` varchar(50) DEFAULT NULL,
10-Aug-2021 20:36:29   `repeat_interval` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:29   `start_on_startup` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:29   `started` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:29   `created_by` int(11) DEFAULT '0',
10-Aug-2021 20:36:29   `date_created` datetime DEFAULT NULL,
10-Aug-2021 20:36:29   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:29   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:29   `last_execution_time` datetime DEFAULT NULL,
10-Aug-2021 20:36:29   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:29   PRIMARY KEY (`task_config_id`),
10-Aug-2021 20:36:29   UNIQUE KEY `scheduler_task_config_uuid_index` (`uuid`),
10-Aug-2021 20:36:29   KEY `scheduler_changer` (`changed_by`),
10-Aug-2021 20:36:29   KEY `scheduler_creator` (`created_by`),
10-Aug-2021 20:36:29   CONSTRAINT `scheduler_changer` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:29   CONSTRAINT `scheduler_creator` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:29 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Dumping data for table `scheduler_task_config`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29 -- Since updating Liquibase from version 2.0.5 to version 3.8.9, the insert statement leaves an 'in_use' entry
10-Aug-2021 20:36:29 -- in the MySQL database which breaks the build:
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29 --    mysql> show open tables where in_use>0;
10-Aug-2021 20:36:29 --    +-----------------------+-----------------------+--------+-------------+
10-Aug-2021 20:36:29 --    | Database              | Table                 | In_use | Name_locked |
10-Aug-2021 20:36:29 --    +-----------------------+-----------------------+--------+-------------+
10-Aug-2021 20:36:29 --    | openmrs_demo_database | scheduler_task_config |      1 |           0 |
10-Aug-2021 20:36:29 --    +-----------------------+-----------------------+--------+-------------+
10-Aug-2021 20:36:29 --    1 row in set (0.00 sec)
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29 -- The insert statement was commented out and replaced by an equivalent changeset in src/main/db/liquibase-demo-data.xml.
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29 --    LOCK TABLES `scheduler_task_config` WRITE;
10-Aug-2021 20:36:29 --    /*!40000 ALTER TABLE `scheduler_task_config` DISABLE KEYS */;
10-Aug-2021 20:36:29 --    INSERT INTO `scheduler_task_config` VALUES (2,'Auto Close Visits Task','Stops all active visits that match the visit type(s) specified by the value of the global property \'visits.autoCloseVisitType\'','org.openmrs.scheduler.tasks.AutoCloseVisitsTask','2011-11-28 23:59:59','MM/dd/yyyy HH:mm:ss',86400,0,0,1,'2017-05-02 15:30:14',NULL,NULL,NULL,'8c17b376-1a2b-11e1-a51a-00248140a5eb'),(3,'Process HL7 Task',NULL,'org.openmrs.scheduler.tasks.ProcessHL7InQueueTask','2017-05-02 15:45:38',NULL,5,1,1,2,'2017-05-02 15:45:38',2,'2017-05-02 15:47:23','2017-05-02 15:47:23','c8143724-9263-43ba-8250-162699eb6100');
10-Aug-2021 20:36:29 --    /*!40000 ALTER TABLE `scheduler_task_config` ENABLE KEYS */;
10-Aug-2021 20:36:29 --    UNLOCK TABLES;
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29 -- Table structure for table `scheduler_task_config_property`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 DROP TABLE IF EXISTS `scheduler_task_config_property`
10-Aug-2021 20:36:29 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:29 [INFO] CREATE TABLE `scheduler_task_config_property` (
10-Aug-2021 20:36:29   `task_config_property_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:29   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:29   `value` text,
10-Aug-2021 20:36:29   `task_config_id` int(11) DEFAULT NULL,
10-Aug-2021 20:36:29   PRIMARY KEY (`task_config_property_id`),
10-Aug-2021 20:36:29   KEY `task_config_for_property` (`task_config_id`),
10-Aug-2021 20:36:29   CONSTRAINT `task_config_for_property` FOREIGN KEY (`task_config_id`) REFERENCES `scheduler_task_config` (`task_config_id`)
10-Aug-2021 20:36:29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Dumping data for table `scheduler_task_config_property`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 LOCK TABLES `scheduler_task_config_property` WRITE
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `scheduler_task_config_property` DISABLE KEYS */
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `scheduler_task_config_property` ENABLE KEYS */
10-Aug-2021 20:36:29 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Table structure for table `serialized_object`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 DROP TABLE IF EXISTS `serialized_object`
10-Aug-2021 20:36:29 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:29 [INFO] CREATE TABLE `serialized_object` (
10-Aug-2021 20:36:29   `serialized_object_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:29   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:29   `description` varchar(5000) DEFAULT NULL,
10-Aug-2021 20:36:29   `type` varchar(255) NOT NULL,
10-Aug-2021 20:36:29   `subtype` varchar(255) NOT NULL,
10-Aug-2021 20:36:29   `serialization_class` varchar(255) NOT NULL,
10-Aug-2021 20:36:29   `serialized_data` mediumtext NOT NULL,
10-Aug-2021 20:36:29   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:29   `creator` int(11) NOT NULL,
10-Aug-2021 20:36:29   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:29   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:29   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:29   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 20:36:29   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:29   `retire_reason` varchar(1000) DEFAULT NULL,
10-Aug-2021 20:36:29   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:29   PRIMARY KEY (`serialized_object_id`),
10-Aug-2021 20:36:29   UNIQUE KEY `serialized_object_uuid_index` (`uuid`),
10-Aug-2021 20:36:29   KEY `serialized_object_creator` (`creator`),
10-Aug-2021 20:36:29   KEY `serialized_object_changed_by` (`changed_by`),
10-Aug-2021 20:36:29   KEY `serialized_object_retired_by` (`retired_by`),
10-Aug-2021 20:36:29   CONSTRAINT `serialized_object_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:29   CONSTRAINT `serialized_object_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:29   CONSTRAINT `serialized_object_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:29 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Dumping data for table `serialized_object`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 LOCK TABLES `serialized_object` WRITE
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `serialized_object` DISABLE KEYS */
10-Aug-2021 20:36:29 [INFO] INSERT INTO `serialized_object` VALUES (1,'appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments','appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments','org.openmrs.module.reporting.dataset.definition.DataSetDefinition','org.openmrs.module.appointmentscheduling.reporting.dataset.definition.AppointmentDataSetDefinition','org.openmrs.module.reporting.serializer.ReportingSerializer','<org.openmrs.module.appointmentscheduling.reporting.dataset.definition.AppointmentDataSetDefinition id=\"1\" uuid=\"c1bf0730-e69e-11e3-ac10-0800200c9a66\" retired=\"false\">\n  <name>appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments</name>\n  <description>appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments</description>\n  <creator id=\"2\" uuid=\"A4F30A1B-5EB9-11DF-A648-37A07F9C90FB\"/>\n  <dateCreated id=\"3\">2017-05-02 13:45:23 UTC</dateCreated>\n  <parameters id=\"4\">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id=\"5\">\n      <name>date</name>\n      <label>date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id=\"6\">\n      <name>location</name>\n      <label>location</label>\n      <type>org.openmrs.Location</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <columnDefinitions id=\"7\">\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"8\" uuid=\"724868a4-0de5-47b6-81f0-0e77f5181f4f\" retired=\"false\">\n      <name>identifier</name>\n      <parameters id=\"9\"/>\n      <dataDefinition id=\"10\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.PatientToAppointmentDataDefinition\" id=\"11\" uuid=\"8ce9d235-4adf-4ad4-9360-3952086f1456\" retired=\"false\">\n          <parameters id=\"12\"/>\n          <joinedDefinition class=\"org.openmrs.module.reporting.data.patient.definition.PatientIdentifierDataDefinition\" id=\"13\" retired=\"false\">\n            <parameters id=\"14\"/>\n            <types id=\"15\">\n              <patientIdentifierType id=\"16\" uuid=\"05a29f94-c0ed-11e2-94be-8c13b969e334\"/>\n            </types>\n            <includeFirstNonNullOnly>true</includeFirstNonNullOnly>\n          </joinedDefinition>\n        </parameterizable>\n        <parameterMappings id=\"17\"/>\n        <converters id=\"18\">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id=\"19\">\n            <typeToConvert>org.openmrs.PatientIdentifier</typeToConvert>\n            <propertyName>identifier</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n          <org.openmrs.module.reporting.data.converter.ObjectFormatter id=\"20\"/>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"21\" uuid=\"4412cd86-aefd-402c-822d-6b0edb0935b2\" retired=\"false\">\n      <name>telephoneNumber</name>\n      <parameters id=\"22\"/>\n      <dataDefinition id=\"23\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.PersonToAppointmentDataDefinition\" id=\"24\" uuid=\"ec47bf0e-3644-4e52-a6c7-d59752992dff\" retired=\"false\">\n          <parameters id=\"25\"/>\n          <joinedDefinition class=\"org.openmrs.module.reporting.data.person.definition.PersonAttributeDataDefinition\" id=\"26\" retired=\"false\">\n            <parameters id=\"27\"/>\n            <personAttributeType id=\"28\" uuid=\"14d4f066-15f5-102d-96e4-000c29c2a5d7\"/>\n          </joinedDefinition>\n        </parameterizable>\n        <parameterMappings id=\"29\"/>\n        <converters id=\"30\">\n          <org.openmrs.module.reporting.data.converter.ObjectFormatter reference=\"20\"/>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"31\" uuid=\"81fd20b5-d534-4a39-b88c-abd8759b9763\" retired=\"false\">\n      <name>provider</name>\n      <parameters id=\"32\"/>\n      <dataDefinition id=\"33\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentProviderDataDefinition\" id=\"34\" uuid=\"238d5183-d3af-49d7-8f52-f324568046d5\" retired=\"false\">\n          <parameters id=\"35\"/>\n        </parameterizable>\n        <parameterMappings id=\"36\"/>\n        <converters reference=\"30\"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"37\" uuid=\"e05cc181-711d-4f42-837e-863e3f6a520b\" retired=\"false\">\n      <name>providerUuid</name>\n      <parameters id=\"38\"/>\n      <dataDefinition id=\"39\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentProviderDataDefinition\" id=\"40\" uuid=\"ab268609-9a28-4720-b384-905528c4ab32\" retired=\"false\">\n          <parameters id=\"41\"/>\n        </parameterizable>\n        <parameterMappings id=\"42\"/>\n        <converters id=\"43\">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id=\"44\">\n            <typeToConvert>java.lang.String</typeToConvert>\n            <propertyName>uuid</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"45\" uuid=\"b7dfea97-9a2d-4d7e-b4d4-eeac2c029fdf\" retired=\"false\">\n      <name>appointmentType</name>\n      <parameters id=\"46\"/>\n      <dataDefinition id=\"47\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentTypeDataDefinition\" id=\"48\" uuid=\"45981eb8-cdd7-4d6f-8d85-a71832465f03\" retired=\"false\">\n          <parameters id=\"49\"/>\n        </parameterizable>\n        <parameterMappings id=\"50\"/>\n        <converters reference=\"30\"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"51\" uuid=\"1f276e26-4af6-4612-81ae-5c4f80c70ac3\" retired=\"false\">\n      <name>appointmentTypeUuid</name>\n      <parameters id=\"52\"/>\n      <dataDefinition id=\"53\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentTypeDataDefinition\" id=\"54\" uuid=\"29037b48-be09-4428-a1df-045f8aa7e310\" retired=\"false\">\n          <parameters id=\"55\"/>\n        </parameterizable>\n        <parameterMappings id=\"56\"/>\n        <converters id=\"57\">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id=\"58\">\n            <typeToConvert>java.lang.String</typeToConvert>\n            <propertyName>uuid</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"59\" uuid=\"9017953d-1913-4b33-8f18-7686fe017326\" retired=\"false\">\n      <name>providerUuid</name>\n      <parameters id=\"60\"/>\n      <dataDefinition id=\"61\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentProviderDataDefinition\" id=\"62\" uuid=\"45fd1f1b-186a-4015-8eb9-fd1f45afe87f\" retired=\"false\">\n          <parameters id=\"63\"/>\n        </parameterizable>\n        <parameterMappings id=\"64\"/>\n        <converters id=\"65\">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id=\"66\">\n            <typeToConvert>java.lang.String</typeToConvert>\n            <propertyName>uuid</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"67\" uuid=\"3b6ef3d7-8a6f-42a5-966a-c50fdeae089b\" retired=\"false\">\n      <name>statusType</name>\n      <parameters id=\"68\"/>\n      <dataDefinition id=\"69\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStatusDataDefinition\" id=\"70\" uuid=\"fbdcd164-e9e0-48ad-a160-44b1d6955955\" retired=\"false\">\n          <parameters id=\"71\"/>\n        </parameterizable>\n        <parameterMappings id=\"72\"/>\n        <converters id=\"73\">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id=\"74\">\n            <typeToConvert>org.openmrs.module.appointmentscheduling.Appointment$AppointmentStatusType</typeToConvert>\n            <propertyName>type</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"75\" uuid=\"d28dab4e-3663-47fc-b973-c221e86c69ce\" retired=\"false\">\n      <name>localizedStatusType</name>\n      <parameters id=\"76\"/>\n      <dataDefinition id=\"77\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStatusDataDefinition\" id=\"78\" uuid=\"161e0f92-7bb0-4865-8614-84184fa5dac8\" retired=\"false\">\n          <parameters id=\"79\"/>\n        </parameterizable>\n        <parameterMappings id=\"80\"/>\n        <converters id=\"81\">\n          <org.openmrs.module.appointmentschedulingui.reporting.converter.AppointmentStatusToLocalizedStatusTypeConverter id=\"82\"/>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"83\" uuid=\"3a326381-e55d-4121-8c8c-d9e871d4f79a\" retired=\"false\">\n      <name>patientName</name>\n      <parameters id=\"84\"/>\n      <dataDefinition id=\"85\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.PersonToAppointmentDataDefinition\" id=\"86\" uuid=\"9a1401c6-f13c-42e5-a46f-a7f06b2a7fba\" retired=\"false\">\n          <parameters id=\"87\"/>\n          <joinedDefinition class=\"org.openmrs.module.reporting.data.person.definition.PreferredNameDataDefinition\" id=\"88\" retired=\"false\">\n            <parameters id=\"89\"/>\n          </joinedDefinition>\n        </parameterizable>\n        <parameterMappings id=\"90\"/>\n        <converters reference=\"30\"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"91\" uuid=\"e0bd4b3e-da98-463f-a45b-5ceb51537863\" retired=\"false\">\n      <name>startDatetime</name>\n      <parameters id=\"92\"/>\n      <dataDefinition id=\"93\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStartDateDataDefinition\" id=\"94\" uuid=\"ccbdc550-5351-45e2-9272-5e88f4906e32\" retired=\"false\">\n          <parameters id=\"95\"/>\n        </parameterizable>\n        <parameterMappings id=\"96\"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"97\" uuid=\"15ea7d35-490c-46b2-9971-eb3c0a558996\" retired=\"false\">\n      <name>startTimeFormatted</name>\n      <parameters id=\"98\"/>\n      <dataDefinition id=\"99\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStartDateDataDefinition\" id=\"100\" uuid=\"724e469e-59b1-4c4f-9b30-8dc44d57c2d6\" retired=\"false\">\n          <parameters id=\"101\"/>\n        </parameterizable>\n        <parameterMappings id=\"102\"/>\n        <converters id=\"103\">\n          <org.openmrs.module.reporting.data.converter.DateConverter id=\"104\">\n            <dateFormat>hh:mm aa</dateFormat>\n          </org.openmrs.module.reporting.data.converter.DateConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id=\"105\" uuid=\"031794da-00f5-4200-a0e7-4b67b57c2532\" retired=\"false\">\n      <name>endTimeFormatted</name>\n      <parameters id=\"106\"/>\n      <dataDefinition id=\"107\">\n        <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentEndDateDataDefinition\" id=\"108\" uuid=\"891faf1a-536e-4f9d-9d4d-2efef12d1896\" retired=\"false\">\n          <parameters id=\"109\"/>\n        </parameterizable>\n        <parameterMappings id=\"110\"/>\n        <converters id=\"111\">\n          <org.openmrs.module.reporting.data.converter.DateConverter id=\"112\">\n            <dateFormat>hh:mm aa</dateFormat>\n          </org.openmrs.module.reporting.data.converter.DateConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n  </columnDefinitions>\n  <sortCriteria id=\"113\">\n    <sortElements id=\"114\">\n      <org.openmrs.module.reporting.common.SortCriteria_-SortElement id=\"115\">\n        <elementName>startDatetime</elementName>\n        <direction>ASC</direction>\n        <outer-class reference=\"113\"/>\n      </org.openmrs.module.reporting.common.SortCriteria_-SortElement>\n      <org.openmrs.module.reporting.common.SortCriteria_-SortElement id=\"116\">\n        <elementName>provider</elementName>\n        <direction>ASC</direction>\n        <outer-class reference=\"113\"/>\n      </org.openmrs.module.reporting.common.SortCriteria_-SortElement>\n    </sortElements>\n  </sortCriteria>\n  <rowFilters id=\"117\">\n    <org.openmrs.module.reporting.evaluation.parameter.Mapped id=\"118\">\n      <parameterizable class=\"org.openmrs.module.appointmentscheduling.reporting.query.definition.BasicAppointmentQuery\" id=\"119\" uuid=\"dae1c3a9-103f-4119-9a20-997fa53d6788\" retired=\"false\">\n        <parameters id=\"120\">\n          <org.openmrs.module.reporting.evaluation.parameter.Parameter id=\"121\">\n            <name>onOrAfter</name>\n            <label>On or after</label>\n            <type>java.util.Date</type>\n            <required>true</required>\n          </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n          <org.openmrs.module.reporting.evaluation.parameter.Parameter id=\"122\">\n            <name>onOrBefore</name>\n            <label>On or before</label>\n            <type>java.util.Date</type>\n            <required>true</required>\n          </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n          <org.openmrs.module.reporting.evaluation.parameter.Parameter reference=\"6\"/>\n        </parameters>\n      </parameterizable>\n      <parameterMappings id=\"123\">\n        <entry>\n          <string>onOrBefore</string>\n          <string>${date}</string>\n        </entry>\n        <entry>\n          <string>location</string>\n          <string>${location}</string>\n        </entry>\n        <entry>\n          <string>onOrAfter</string>\n          <string>${date}</string>\n        </entry>\n      </parameterMappings>\n    </org.openmrs.module.reporting.evaluation.parameter.Mapped>\n  </rowFilters>\n</org.openmrs.module.appointmentscheduling.reporting.dataset.definition.AppointmentDataSetDefinition>','2017-05-02 15:45:23',2,NULL,NULL,0,NULL,NULL,NULL,'c1bf0730-e69e-11e3-ac10-0800200c9a66')
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `serialized_object` ENABLE KEYS */
10-Aug-2021 20:36:29 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Table structure for table `test_order`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 DROP TABLE IF EXISTS `test_order`
10-Aug-2021 20:36:29 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:29 [INFO] CREATE TABLE `test_order` (
10-Aug-2021 20:36:29   `order_id` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:29   `specimen_source` int(11) DEFAULT NULL,
10-Aug-2021 20:36:29   `laterality` varchar(20) DEFAULT NULL,
10-Aug-2021 20:36:29   `clinical_history` text,
10-Aug-2021 20:36:29   `frequency` int(11) DEFAULT NULL,
10-Aug-2021 20:36:29   `number_of_repeats` int(11) DEFAULT NULL,
10-Aug-2021 20:36:29   PRIMARY KEY (`order_id`),
10-Aug-2021 20:36:29   KEY `test_order_specimen_source_fk` (`specimen_source`),
10-Aug-2021 20:36:29   KEY `test_order_frequency_fk` (`frequency`),
10-Aug-2021 20:36:29   CONSTRAINT `test_order_frequency_fk` FOREIGN KEY (`frequency`) REFERENCES `order_frequency` (`order_frequency_id`),
10-Aug-2021 20:36:29   CONSTRAINT `test_order_order_id_fk` FOREIGN KEY (`order_id`) REFERENCES `orders` (`order_id`),
10-Aug-2021 20:36:29   CONSTRAINT `test_order_specimen_source_fk` FOREIGN KEY (`specimen_source`) REFERENCES `concept` (`concept_id`)
10-Aug-2021 20:36:29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Dumping data for table `test_order`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 LOCK TABLES `test_order` WRITE
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `test_order` DISABLE KEYS */
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `test_order` ENABLE KEYS */
10-Aug-2021 20:36:29 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Table structure for table `uiframework_user_defined_page_view`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 DROP TABLE IF EXISTS `uiframework_user_defined_page_view`
10-Aug-2021 20:36:29 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:29 [INFO] CREATE TABLE `uiframework_user_defined_page_view` (
10-Aug-2021 20:36:29   `page_view_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:29   `name` varchar(100) NOT NULL,
10-Aug-2021 20:36:29   `template_type` varchar(50) NOT NULL,
10-Aug-2021 20:36:29   `template_text` mediumtext NOT NULL,
10-Aug-2021 20:36:29   `uuid` varchar(38) NOT NULL,
10-Aug-2021 20:36:29   `creator` int(11) NOT NULL,
10-Aug-2021 20:36:29   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:29   PRIMARY KEY (`page_view_id`),
10-Aug-2021 20:36:29   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:29   UNIQUE KEY `name` (`name`)
10-Aug-2021 20:36:29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Dumping data for table `uiframework_user_defined_page_view`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 LOCK TABLES `uiframework_user_defined_page_view` WRITE
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `uiframework_user_defined_page_view` DISABLE KEYS */
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `uiframework_user_defined_page_view` ENABLE KEYS */
10-Aug-2021 20:36:29 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Table structure for table `user_property`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 DROP TABLE IF EXISTS `user_property`
10-Aug-2021 20:36:29 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:29 [INFO] CREATE TABLE `user_property` (
10-Aug-2021 20:36:29   `user_id` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:29   `property` varchar(100) NOT NULL DEFAULT '',
10-Aug-2021 20:36:29   `property_value` varchar(255) NOT NULL DEFAULT '',
10-Aug-2021 20:36:29   PRIMARY KEY (`user_id`,`property`),
10-Aug-2021 20:36:29   CONSTRAINT `user_property_to_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Dumping data for table `user_property`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 LOCK TABLES `user_property` WRITE
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `user_property` DISABLE KEYS */
10-Aug-2021 20:36:29 [INFO] INSERT INTO `user_property` VALUES (3,'lockoutTimestamp',''),(3,'loginAttempts','0'),(4,'lockoutTimestamp',''),(4,'loginAttempts','0'),(5,'lockoutTimestamp',''),(5,'loginAttempts','0'),(6,'lockoutTimestamp',''),(6,'loginAttempts','0'),(7,'lockoutTimestamp',''),(7,'loginAttempts','0')
10-Aug-2021 20:36:29 [INFO] /*!40000 ALTER TABLE `user_property` ENABLE KEYS */
10-Aug-2021 20:36:29 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:29 [INFO] --
10-Aug-2021 20:36:29 -- Table structure for table `user_role`
10-Aug-2021 20:36:29 --
10-Aug-2021 20:36:29
10-Aug-2021 20:36:29 DROP TABLE IF EXISTS `user_role`
10-Aug-2021 20:36:29 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:29 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:29 [INFO] CREATE TABLE `user_role` (
10-Aug-2021 20:36:29   `user_id` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:29   `role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 20:36:29   PRIMARY KEY (`role`,`user_id`),
10-Aug-2021 20:36:29   KEY `user_role_to_users` (`user_id`),
10-Aug-2021 20:36:29   CONSTRAINT `role_definitions` FOREIGN KEY (`role`) REFERENCES `role` (`role`),
10-Aug-2021 20:36:29   CONSTRAINT `user_role_to_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:29 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Dumping data for table `user_role`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 LOCK TABLES `user_role` WRITE
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `user_role` DISABLE KEYS */
10-Aug-2021 20:36:30 [INFO] INSERT INTO `user_role` VALUES (1,'Provider'),(1,'System Developer'),(3,'Organizational: Registration Clerk'),(4,'Organizational: Nurse'),(5,'Organizational: Doctor'),(6,'Organizational: System Administrator'),(7,'System Developer')
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `user_role` ENABLE KEYS */
10-Aug-2021 20:36:30 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Table structure for table `users`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 DROP TABLE IF EXISTS `users`
10-Aug-2021 20:36:30 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:30 [INFO] CREATE TABLE `users` (
10-Aug-2021 20:36:30   `user_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:30   `system_id` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 20:36:30   `username` varchar(50) DEFAULT NULL,
10-Aug-2021 20:36:30   `password` varchar(128) DEFAULT NULL,
10-Aug-2021 20:36:30   `salt` varchar(128) DEFAULT NULL,
10-Aug-2021 20:36:30   `secret_question` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `secret_answer` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `creator` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:30   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:30   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `person_id` int(11) NOT NULL,
10-Aug-2021 20:36:30   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:30   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:30   PRIMARY KEY (`user_id`),
10-Aug-2021 20:36:30   KEY `user_who_changed_user` (`changed_by`),
10-Aug-2021 20:36:30   KEY `user_creator` (`creator`),
10-Aug-2021 20:36:30   KEY `user_who_retired_this_user` (`retired_by`),
10-Aug-2021 20:36:30   KEY `person_id_for_user` (`person_id`),
10-Aug-2021 20:36:30   CONSTRAINT `person_id_for_user` FOREIGN KEY (`person_id`) REFERENCES `person` (`person_id`),
10-Aug-2021 20:36:30   CONSTRAINT `user_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `user_who_changed_user` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `user_who_retired_this_user` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:30 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Dumping data for table `users`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 LOCK TABLES `users` WRITE
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `users` DISABLE KEYS */
10-Aug-2021 20:36:30 [INFO] INSERT INTO `users` VALUES (1,'admin','','d236e99e705d338e654fa8bac5168a685a23c4cb59d3b6de6448cfff1dad45af4100227aabd13edbaf83b71c225da90695a2bf9f06c4cfa3bf7ad56ec7028edc','31a6b07f52829bd3546da49cafede8f1691b958ea58fe26b4d831e4833167e3c6d67e369b08cfef1d7df1b3dfcffca85073438c31dd8ead2d35746bc7766c209',NULL,NULL,1,'2005-01-01 00:00:00',NULL,NULL,1,0,NULL,NULL,NULL,'5cc18975-2f3b-11e7-8ccb-28d2440db56c'),(2,'daemon','daemon',NULL,NULL,NULL,NULL,1,'2010-04-26 13:25:00',NULL,NULL,1,0,NULL,NULL,NULL,'A4F30A1B-5EB9-11DF-A648-37A07F9C90FB'),(3,'3-4','clerk','56f79548b5be34c6842730e8cf258bc8597e3c2e3f206577d89d4aac728372f49e7cbd0b34cad2bdfde661eb21fd0a3f9f24338f4b0fb0eb6357aa676539cd55','b1be2968a55fd05666c2a025d308318d80f2d181c6170ed1369579318c54350319951365a64980e1cc2e8d249068ff7c6d70f4ac511412998f04315ccf62e760',NULL,NULL,2,'2017-05-02 15:38:29',2,'2017-05-02 15:38:29',3,0,NULL,NULL,NULL,'4882dd60-0508-11e3-8ffd-0800200c9a66'),(4,'4-2','nurse','fccd785b1d1fc9aae40c39e4c35fa1ff764c889fe1bbaddb0538440e36d9b50fa4691ae841c363fa3c3fc723371f8d1bd4d36106cb2d12e431601485c89c5593','3fd54922b8e2dcc2929fc559251bf99b26fa24cd3c0812aa49ef1bcb6eae29b9bcadc6977ce0e149f7cb561690582bd4e30f0cc1313892441c49d8c12dec69d1',NULL,NULL,2,'2017-05-02 15:38:29',2,'2017-05-02 15:38:29',4,0,NULL,NULL,NULL,'564b2790-0508-11e3-8ffd-0800200c9a66'),(5,'5-9','doctor','8357507442dc1c09f053ede5713d4e6fa3fffa7a19c59536ff3a45821cc5a95f9c0d048e1fc1a3f847c3acb6d0cc1102796b50bbd959a1af7d82d8f18b78aed9','9fcc3578ca3fa07785294e98ec10f87d6d10ffd3b09fb1ca04cdb647c63053c3a838ef380805b7df9b8bf67b70c078a9132c491493d760a709ea62fbbb5499b5',NULL,NULL,2,'2017-05-02 15:38:29',2,'2017-05-02 15:38:29',5,0,NULL,NULL,NULL,'67bfd7f0-0508-11e3-8ffd-0800200c9a66'),(6,'6-7','sysadmin','6a4eb59e4ce921b764da7a17c37c8230bb7f89e335a0231bee992960ee9ebe2c609ac7c4358c3a0dbe71462bb71ec4ad17889d3a4dc799245c2b3976c269f596','1a98cf1b119f51e9ad86ca1ac1e7836ffc6e13ec2a078dd9a7036d2ec8702318b1a568bd8da7e382a3911c5993539f108146d912f0494bbfc97ebc87a53c5da1',NULL,NULL,2,'2017-05-02 15:38:29',2,'2017-05-02 15:38:29',6,0,NULL,NULL,NULL,'8295e796-4016-11e4-8e9b-2939a1809c8e'),(7,'7-5','scheduler','46ecebad9237bb4718e65f970cafe4674d039657cf25f70a3729e11366cb80c3adbd6c88ec30532fa981659241bbc85663ebc9ddf717afd8cb21e41a455e278f','319c2a336547fcbca636b70a12d6359be82823d9d8f6dd239c9403b95aec5b9dc99a418ca5ed56235aea2c30aa0f2a296c97a2fcf62a72a4e0c26a24b8620385',NULL,NULL,2,'2017-05-02 15:38:30',2,'2017-05-02 15:38:30',1,0,NULL,NULL,NULL,'0a3493e8-21f8-11e3-8ad1-1b02b898d14d')
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `users` ENABLE KEYS */
10-Aug-2021 20:36:30 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Table structure for table `visit`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 DROP TABLE IF EXISTS `visit`
10-Aug-2021 20:36:30 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:30 [INFO] CREATE TABLE `visit` (
10-Aug-2021 20:36:30   `visit_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:30   `patient_id` int(11) NOT NULL,
10-Aug-2021 20:36:30   `visit_type_id` int(11) NOT NULL,
10-Aug-2021 20:36:30   `date_started` datetime NOT NULL,
10-Aug-2021 20:36:30   `date_stopped` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `indication_concept_id` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `location_id` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `creator` int(11) NOT NULL,
10-Aug-2021 20:36:30   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:30   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `voided` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:30   `voided_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_voided` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `void_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:30   PRIMARY KEY (`visit_id`),
10-Aug-2021 20:36:30   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:30   KEY `visit_patient_index` (`patient_id`),
10-Aug-2021 20:36:30   KEY `visit_type_fk` (`visit_type_id`),
10-Aug-2021 20:36:30   KEY `visit_location_fk` (`location_id`),
10-Aug-2021 20:36:30   KEY `visit_creator_fk` (`creator`),
10-Aug-2021 20:36:30   KEY `visit_voided_by_fk` (`voided_by`),
10-Aug-2021 20:36:30   KEY `visit_changed_by_fk` (`changed_by`),
10-Aug-2021 20:36:30   KEY `visit_indication_concept_fk` (`indication_concept_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_changed_by_fk` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_creator_fk` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_indication_concept_fk` FOREIGN KEY (`indication_concept_id`) REFERENCES `concept` (`concept_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_location_fk` FOREIGN KEY (`location_id`) REFERENCES `location` (`location_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_patient_fk` FOREIGN KEY (`patient_id`) REFERENCES `patient` (`patient_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_type_fk` FOREIGN KEY (`visit_type_id`) REFERENCES `visit_type` (`visit_type_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_voided_by_fk` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:30 ) ENGINE=InnoDB AUTO_INCREMENT=509 DEFAULT CHARSET=utf8
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Dumping data for table `visit`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 LOCK TABLES `visit` WRITE
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit` DISABLE KEYS */
10-Aug-2021 20:36:30 [INFO] INSERT INTO `visit` VALUES (1,7,1,'2015-07-30 12:38:31','2015-07-30 14:55:31',NULL,1,2,'2017-05-02 15:38:32',2,'2017-05-02 15:38:33',0,NULL,NULL,NULL,'e8ffd8a7-664d-44f8-a3e4-0dd6fd45c9e0'),(2,7,1,'2015-09-13 12:38:33','2015-09-13 14:08:33',NULL,1,2,'2017-05-02 15:38:33',2,'2017-05-02 15:38:33',0,NULL,NULL,NULL,'119743c7-ed0c-4e3c-b00f-331b6f4eb016'),(3,7,1,'2015-05-23 12:38:33','2015-05-23 14:55:33',NULL,1,2,'2017-05-02 15:38:34',2,'2017-05-02 15:38:34',0,NULL,NULL,NULL,'37b191d3-b261-4f78-a21f-125e104d90df'),(4,7,1,'2015-10-06 12:38:34','2015-10-06 14:38:34',NULL,1,2,'2017-05-02 15:38:35',2,'2017-05-02 15:38:35',0,NULL,NULL,NULL,'47e2e290-b679-4c4b-aa5f-77ed7150b7eb'),(5,7,1,'2016-05-14 12:38:35','2016-05-14 14:13:35',NULL,1,2,'2017-05-02 15:38:36',2,'2017-05-02 15:38:36',0,NULL,NULL,NULL,'8693386f-0c3c-4618-b08e-9062c0d3551a'),(6,7,1,'2015-07-01 12:38:36','2015-07-01 14:37:36',NULL,1,2,'2017-05-02 15:38:36',2,'2017-05-02 15:38:37',0,NULL,NULL,NULL,'e8edb37e-8add-4bd3-8e5f-9fb64c86435a'),(7,7,1,'2015-11-05 12:38:37','2015-11-05 14:49:37',NULL,1,2,'2017-05-02 15:38:37',2,'2017-05-02 15:38:38',0,NULL,NULL,NULL,'77e70714-9819-4b0e-a95c-1ada4b8f1974'),(8,7,1,'2015-07-19 12:38:38','2015-07-19 14:53:38',NULL,1,2,'2017-05-02 15:38:38',2,'2017-05-02 15:38:39',0,NULL,NULL,NULL,'9a933548-687a-413a-9f21-d313e7dcb607'),(9,7,1,'2015-06-16 12:38:39','2015-06-19 13:58:39',NULL,1,2,'2017-05-02 15:38:39',2,'2017-05-02 15:38:40',0,NULL,NULL,NULL,'7f32f479-1442-4fb6-9c22-ea0477a92627'),(10,7,1,'2017-03-25 12:38:40','2017-03-26 14:13:40',NULL,1,2,'2017-05-02 15:38:40',2,'2017-05-02 15:38:41',0,NULL,NULL,NULL,'51e3d8fb-fa50-4a5d-bf42-a24caeb45a3c'),(11,8,1,'2017-01-20 12:38:41','2017-01-20 14:44:41',NULL,1,2,'2017-05-02 15:38:41',2,'2017-05-02 15:38:42',0,NULL,NULL,NULL,'073dd05b-b944-45d5-8c64-587a4bb26f87'),(12,8,1,'2017-01-13 12:38:42','2017-01-13 14:58:42',NULL,1,2,'2017-05-02 15:38:42',2,'2017-05-02 15:38:43',0,NULL,NULL,NULL,'08698ae6-b119-4f53-89ee-99f6280762f6'),(13,9,1,'2017-03-13 12:38:43','2017-03-13 14:15:43',NULL,1,2,'2017-05-02 15:38:43',2,'2017-05-02 15:38:44',0,NULL,NULL,NULL,'0e16cc5c-c55a-4bb0-b7d4-05d72c81573c'),(14,9,1,'2016-10-24 12:38:44','2016-10-24 14:26:44',NULL,1,2,'2017-05-02 15:38:44',2,'2017-05-02 15:38:45',0,NULL,NULL,NULL,'2b27e03c-bf70-46bb-bbee-e1694775ec5a'),(15,9,1,'2015-08-02 12:38:45','2015-08-02 14:25:45',NULL,1,2,'2017-05-02 15:38:45',2,'2017-05-02 15:38:46',0,NULL,NULL,NULL,'09604cc3-3efc-46b2-9fda-19bafb5528b8'),(16,9,1,'2016-10-24 12:38:46','2016-10-24 15:01:46',NULL,1,2,'2017-05-02 15:38:46',2,'2017-05-02 15:38:47',0,NULL,NULL,NULL,'5cfe66c7-a2a9-4f12-8ab2-bb76f19ecc76'),(17,9,1,'2016-08-10 12:38:47','2016-08-10 15:04:47',NULL,1,2,'2017-05-02 15:38:47',2,'2017-05-02 15:38:48',0,NULL,NULL,NULL,'a01cbd0f-fe1e-4742-8d76-171b6eed09eb'),(18,9,1,'2017-04-25 12:38:48','2017-04-25 14:30:48',NULL,1,2,'2017-05-02 15:38:48',2,'2017-05-02 15:38:49',0,NULL,NULL,NULL,'e4539fb9-60aa-4818-a2ae-868aa6f6ef6c'),(19,9,1,'2016-03-09 12:38:49','2016-03-10 14:00:49',NULL,1,2,'2017-05-02 15:38:49',2,'2017-05-02 15:38:50',0,NULL,NULL,NULL,'8b62b6be-22b8-4885-99fb-3b06e92090db'),(20,10,1,'2016-07-24 12:38:50','2016-07-24 15:01:50',NULL,1,2,'2017-05-02 15:38:50',2,'2017-05-02 15:38:51',0,NULL,NULL,NULL,'9b699627-0b91-4c3c-a387-98a4a420bddd'),(21,10,1,'2015-06-17 12:38:51','2015-06-17 14:09:51',NULL,1,2,'2017-05-02 15:38:52',2,'2017-05-02 15:38:53',0,NULL,NULL,NULL,'d5f68c0f-3f54-4068-8659-61481f5f7286'),(22,10,1,'2016-12-16 12:38:54','2016-12-16 14:32:54',NULL,1,2,'2017-05-02 15:38:56',2,'2017-05-02 15:38:58',0,NULL,NULL,NULL,'960ee8aa-6f54-40c4-8035-d76fef4f9548'),(23,10,1,'2016-09-30 12:38:58','2016-09-30 14:57:58',NULL,1,2,'2017-05-02 15:39:00',2,'2017-05-02 15:39:01',0,NULL,NULL,NULL,'a2ecb18b-c222-489b-8cb3-28b042974797'),(24,10,1,'2016-05-05 12:39:01','2016-05-06 13:57:01',NULL,1,2,'2017-05-02 15:39:02',2,'2017-05-02 15:39:02',0,NULL,NULL,NULL,'d361a873-f0ee-4b1f-a587-69bd44b59258'),(25,11,1,'2015-05-20 12:39:02','2015-05-20 14:41:02',NULL,1,2,'2017-05-02 15:39:02',2,'2017-05-02 15:39:03',0,NULL,NULL,NULL,'2eaaabef-9118-4fa6-94c1-2f48810c59c2'),(26,11,1,'2017-01-06 12:39:03','2017-01-06 14:28:03',NULL,1,2,'2017-05-02 15:39:04',2,'2017-05-02 15:39:04',0,NULL,NULL,NULL,'c9ac046e-aea3-420a-957c-6fc3a137f6db'),(27,12,1,'2015-05-20 12:39:04','2015-05-20 14:49:04',NULL,1,2,'2017-05-02 15:39:05',2,'2017-05-02 15:39:05',0,NULL,NULL,NULL,'ff965212-1048-4649-b0d7-8d24ae863ee6'),(28,12,1,'2016-09-09 12:39:05','2016-09-09 14:13:05',NULL,1,2,'2017-05-02 15:39:06',2,'2017-05-02 15:39:06',0,NULL,NULL,NULL,'bdfe45ba-1b2e-4437-b829-9bf05512483b'),(29,12,1,'2016-02-17 12:39:06','2016-02-17 14:15:06',NULL,1,2,'2017-05-02 15:39:06',2,'2017-05-02 15:39:07',0,NULL,NULL,NULL,'b64efcd5-1af7-429e-9fe2-e06decb17222'),(30,12,1,'2015-11-18 12:39:07','2015-11-18 14:28:07',NULL,1,2,'2017-05-02 15:39:07',2,'2017-05-02 15:39:08',0,NULL,NULL,NULL,'a32b310d-043b-4b41-b2b3-85e3fa4cbb00'),(31,12,1,'2016-12-26 12:39:08','2016-12-26 14:10:08',NULL,1,2,'2017-05-02 15:39:08',2,'2017-05-02 15:39:09',0,NULL,NULL,NULL,'b7802d33-a133-440b-9662-19fde9dac0a1'),(32,12,1,'2015-10-07 12:39:09','2015-10-09 13:58:09',NULL,1,2,'2017-05-02 15:39:09',2,'2017-05-02 15:39:10',0,NULL,NULL,NULL,'1d4d013b-0427-4d2d-b4a6-cbc0e16b0041'),(33,13,1,'2016-05-27 12:39:10','2016-05-27 15:04:10',NULL,1,2,'2017-05-02 15:39:11',2,'2017-05-02 15:39:11',0,NULL,NULL,NULL,'cedaf3de-bea9-4820-ab76-0decbc8aca31'),(34,13,1,'2015-11-11 12:39:11','2015-11-11 14:11:11',NULL,1,2,'2017-05-02 15:39:11',2,'2017-05-02 15:39:12',0,NULL,NULL,NULL,'f10cfe3a-a5f2-49af-8559-5c4e3069d8c2'),(35,13,1,'2015-08-26 12:39:12','2015-08-26 14:56:12',NULL,1,2,'2017-05-02 15:39:12',2,'2017-05-02 15:39:13',0,NULL,NULL,NULL,'f80d52e5-c655-4f2e-9d42-d91ad6b3e6d5'),(36,13,1,'2015-10-08 12:39:13','2015-10-08 15:08:13',NULL,1,2,'2017-05-02 15:39:13',2,'2017-05-02 15:39:14',0,NULL,NULL,NULL,'b7afdc79-3e5a-4269-88df-7992d3ba053a'),(37,13,1,'2016-11-18 12:39:14','2016-11-18 14:15:14',NULL,1,2,'2017-05-02 15:39:14',2,'2017-05-02 15:39:14',0,NULL,NULL,NULL,'5db42f3a-144a-430d-b562-82e9b4958971'),(38,13,1,'2015-10-20 12:39:14','2015-10-21 13:48:14',NULL,1,2,'2017-05-02 15:39:15',2,'2017-05-02 15:39:15',0,NULL,NULL,NULL,'645aca03-32e9-4293-aef8-e4d645b3fa01'),(39,14,1,'2016-11-13 12:39:16','2016-11-13 14:27:16',NULL,1,2,'2017-05-02 15:39:16',2,'2017-05-02 15:39:16',0,NULL,NULL,NULL,'8859cab0-9465-46cb-a35e-b248e89d6ea4'),(40,15,1,'2016-08-25 12:39:17','2016-08-25 14:35:17',NULL,1,2,'2017-05-02 15:39:17',2,'2017-05-02 15:39:17',0,NULL,NULL,NULL,'5e22f719-8632-4d5e-b562-d39113b11c8b'),(41,15,1,'2015-06-21 12:39:17','2015-06-21 14:32:17',NULL,1,2,'2017-05-02 15:39:17',2,'2017-05-02 15:39:18',0,NULL,NULL,NULL,'cd0c4b48-1d1d-4deb-8422-45a11c5f90ad'),(42,15,1,'2015-11-16 12:39:18','2015-11-16 14:33:18',NULL,1,2,'2017-05-02 15:39:18',2,'2017-05-02 15:39:19',0,NULL,NULL,NULL,'bbb59147-c8c2-4426-8c6e-f3a6d4dafc94'),(43,15,1,'2017-02-11 12:39:19','2017-02-11 14:13:19',NULL,1,2,'2017-05-02 15:39:19',2,'2017-05-02 15:39:20',0,NULL,NULL,NULL,'9fcd0cbb-5ed4-494f-8def-a7bd45d97aab'),(44,15,1,'2015-11-26 12:39:20','2015-11-26 14:30:20',NULL,1,2,'2017-05-02 15:39:20',2,'2017-05-02 15:39:21',0,NULL,NULL,NULL,'022a062e-9654-4b77-b9a6-d02242693781'),(45,15,1,'2015-05-28 12:39:21','2015-05-31 14:15:21',NULL,1,2,'2017-05-02 15:39:21',2,'2017-05-02 15:39:21',0,NULL,NULL,NULL,'95a6d168-40c9-44ce-bbe1-c57da92baf19'),(46,16,1,'2017-04-14 12:39:22','2017-04-14 14:57:22',NULL,1,2,'2017-05-02 15:39:22',2,'2017-05-02 15:39:22',0,NULL,NULL,NULL,'f11605bc-664c-4aec-bf16-842ff7387c4a'),(47,16,1,'2017-01-09 12:39:22','2017-01-09 14:40:22',NULL,1,2,'2017-05-02 15:39:23',2,'2017-05-02 15:39:23',0,NULL,NULL,NULL,'e7af7012-3e0e-4ccd-8c2d-cd38dfb48fc8'),(48,16,1,'2017-02-11 12:39:23','2017-02-11 14:15:23',NULL,1,2,'2017-05-02 15:39:23',2,'2017-05-02 15:39:24',0,NULL,NULL,NULL,'020c4262-b214-4bf1-b54c-e5b8224fce4f'),(49,16,1,'2016-10-03 12:39:24','2016-10-03 15:01:24',NULL,1,2,'2017-05-02 15:39:24',2,'2017-05-02 15:39:24',0,NULL,NULL,NULL,'b58c401d-8aa7-47ce-b39e-01c5cc322905'),(50,16,1,'2015-09-10 12:39:25','2015-09-10 14:33:25',NULL,1,2,'2017-05-02 15:39:25',2,'2017-05-02 15:39:25',0,NULL,NULL,NULL,'3282850a-e87c-4beb-b409-aa6eb0aa759a'),(51,16,1,'2016-07-15 12:39:25','2016-07-17 14:28:25',NULL,1,2,'2017-05-02 15:39:25',2,'2017-05-02 15:39:26',0,NULL,NULL,NULL,'7be46bc5-5e71-41d7-8bdf-bb64064c9625'),(52,17,1,'2015-08-02 12:39:26','2015-08-02 14:30:26',NULL,1,2,'2017-05-02 15:39:26',2,'2017-05-02 15:39:26',0,NULL,NULL,NULL,'60caf144-d8bf-47dd-bf06-b75809d6ef61'),(53,17,1,'2015-12-28 12:39:26','2015-12-28 14:14:26',NULL,1,2,'2017-05-02 15:39:27',2,'2017-05-02 15:39:27',0,NULL,NULL,NULL,'c15a2161-fbd1-4935-9493-b8df2e6769aa'),(54,17,1,'2016-09-03 12:39:27','2016-09-03 14:47:27',NULL,1,2,'2017-05-02 15:39:28',2,'2017-05-02 15:39:28',0,NULL,NULL,NULL,'06576c83-972b-4a79-8755-36bce481842f'),(55,17,1,'2016-05-14 12:39:28','2016-05-14 14:38:28',NULL,1,2,'2017-05-02 15:39:28',2,'2017-05-02 15:39:29',0,NULL,NULL,NULL,'11f678bb-23e6-4d3b-b26c-8761fb2dc222'),(56,17,1,'2016-06-11 12:39:29','2016-06-11 14:22:29',NULL,1,2,'2017-05-02 15:39:29',2,'2017-05-02 15:39:30',0,NULL,NULL,NULL,'c5afbaef-f5c4-4441-9bee-82c779bb9694'),(57,17,1,'2016-04-16 12:39:30','2016-04-18 13:52:30',NULL,1,2,'2017-05-02 15:39:30',2,'2017-05-02 15:39:30',0,NULL,NULL,NULL,'381ae2f0-c261-4fea-9211-4fbb45d8ff98'),(58,18,1,'2015-09-28 12:39:31','2015-09-28 14:57:31',NULL,1,2,'2017-05-02 15:39:31',2,'2017-05-02 15:39:31',0,NULL,NULL,NULL,'4de4abc2-ed35-46d8-8c46-e2740ec7fd55'),(59,18,1,'2015-06-08 12:39:31','2015-06-08 15:04:31',NULL,1,2,'2017-05-02 15:39:32',2,'2017-05-02 15:39:32',0,NULL,NULL,NULL,'4a265ff4-7e5d-4a46-8a96-9395e18ba773'),(60,18,1,'2015-12-05 12:39:32','2015-12-05 14:49:32',NULL,1,2,'2017-05-02 15:39:33',2,'2017-05-02 15:39:33',0,NULL,NULL,NULL,'1519f41e-6c93-413a-8fd3-f3bc4fb86008'),(61,18,1,'2017-01-20 12:39:33','2017-01-20 14:34:33',NULL,1,2,'2017-05-02 15:39:33',2,'2017-05-02 15:39:34',0,NULL,NULL,NULL,'fb66b272-c21f-4f35-b0a2-b80f1f80c126'),(62,18,1,'2017-01-03 12:39:34','2017-01-03 14:16:34',NULL,1,2,'2017-05-02 15:39:34',2,'2017-05-02 15:39:35',0,NULL,NULL,NULL,'ff3a906e-6c20-4574-af7b-7aafcf886b81'),(63,18,1,'2015-08-01 12:39:35','2015-08-01 15:05:35',NULL,1,2,'2017-05-02 15:39:35',2,'2017-05-02 15:39:35',0,NULL,NULL,NULL,'7c607c96-0b7c-4b84-a8f8-979b74ae21e9'),(64,18,1,'2016-02-16 12:39:35','2016-02-18 14:30:35',NULL,1,2,'2017-05-02 15:39:36',2,'2017-05-02 15:39:36',0,NULL,NULL,NULL,'111b4a2f-2d36-4657-9ced-6d88155d2948'),(65,18,1,'2017-03-23 12:39:36','2017-03-25 14:35:36',NULL,1,2,'2017-05-02 15:39:36',2,'2017-05-02 15:39:37',0,NULL,NULL,NULL,'000df5c0-61fb-4c55-a60d-38277f5bdbaa'),(66,19,1,'2017-04-13 12:39:37','2017-04-13 15:09:37',NULL,1,2,'2017-05-02 15:39:37',2,'2017-05-02 15:39:38',0,NULL,NULL,NULL,'f71459bb-4b25-4dcc-96ba-c7aa55243ff5'),(67,19,1,'2015-11-02 12:39:38','2015-11-02 14:38:38',NULL,1,2,'2017-05-02 15:39:38',2,'2017-05-02 15:39:39',0,NULL,NULL,NULL,'07e10187-584a-4dd3-96e2-744f60079d70'),(68,19,1,'2015-08-16 12:39:39','2015-08-16 14:50:39',NULL,1,2,'2017-05-02 15:39:39',2,'2017-05-02 15:39:39',0,NULL,NULL,NULL,'9d33c1c5-d670-4f84-9ae3-f1e0596e0102'),(69,19,1,'2016-07-27 12:39:39','2016-07-27 14:39:39',NULL,1,2,'2017-05-02 15:39:40',2,'2017-05-02 15:39:40',0,NULL,NULL,NULL,'50b4715c-7ea6-4c53-9dba-cb59f37033eb'),(70,19,1,'2015-12-24 12:39:40','2015-12-24 15:04:40',NULL,1,2,'2017-05-02 15:39:40',2,'2017-05-02 15:39:41',0,NULL,NULL,NULL,'49ab8630-e3f9-4ca4-9ca3-1911a5a66637'),(71,19,1,'2017-02-24 12:39:41','2017-02-24 14:46:41',NULL,1,2,'2017-05-02 15:39:41',2,'2017-05-02 15:39:42',0,NULL,NULL,NULL,'ee7ce56b-bd41-471b-b43c-80138cbfebd5'),(72,19,1,'2016-11-14 12:39:42','2016-11-14 14:14:42',NULL,1,2,'2017-05-02 15:39:42',2,'2017-05-02 15:39:42',0,NULL,NULL,NULL,'52d032c6-cb75-4c3d-9eaf-91a15afdff83'),(73,19,1,'2017-04-08 12:39:43','2017-04-08 14:57:43',NULL,1,2,'2017-05-02 15:39:43',2,'2017-05-02 15:39:43',0,NULL,NULL,NULL,'64190cc6-a266-4519-8835-3d39ef9f5cfb'),(74,19,1,'2017-04-11 12:39:43','2017-04-12 14:15:43',NULL,1,2,'2017-05-02 15:39:44',2,'2017-05-02 15:39:44',0,NULL,NULL,NULL,'7b309940-07e7-406f-bcdb-759768fbf0de'),(75,19,1,'2016-05-08 12:39:44','2016-05-11 13:59:44',NULL,1,2,'2017-05-02 15:39:45',2,'2017-05-02 15:39:45',0,NULL,NULL,NULL,'a90a278e-74fe-41b7-8e2b-e26130646f4f'),(76,20,1,'2017-03-18 12:39:45','2017-03-18 14:19:45',NULL,1,2,'2017-05-02 15:39:45',2,'2017-05-02 15:39:46',0,NULL,NULL,NULL,'a8cbf014-f78e-4c7c-aa1e-3cb874eaa33e'),(77,20,1,'2016-02-02 12:39:46','2016-02-02 15:00:46',NULL,1,2,'2017-05-02 15:39:46',2,'2017-05-02 15:39:47',0,NULL,NULL,NULL,'377f6aba-52e6-4f10-a74c-e906be771911'),(78,20,1,'2015-07-16 12:39:47','2015-07-16 14:12:47',NULL,1,2,'2017-05-02 15:39:47',2,'2017-05-02 15:39:48',0,NULL,NULL,NULL,'533a746a-d42e-4214-8419-d694609788bc'),(79,20,1,'2016-07-03 12:39:48','2016-07-03 14:28:48',NULL,1,2,'2017-05-02 15:39:48',2,'2017-05-02 15:39:48',0,NULL,NULL,NULL,'5f98d1a0-04b1-4bf4-a970-9acb07c18ca4'),(80,20,1,'2017-03-31 12:39:48','2017-04-03 13:53:48',NULL,1,2,'2017-05-02 15:39:49',2,'2017-05-02 15:39:49',0,NULL,NULL,NULL,'3849b531-3faa-4f5d-b2c8-18bd70dedd77'),(81,21,1,'2015-05-27 12:39:49','2015-05-27 14:39:49',NULL,1,2,'2017-05-02 15:39:49',2,'2017-05-02 15:39:50',0,NULL,NULL,NULL,'6c2a88fd-65d1-4921-b0f8-ed33f1ee3ed3'),(82,21,1,'2015-06-28 12:39:50','2015-06-28 15:04:50',NULL,1,2,'2017-05-02 15:39:50',2,'2017-05-02 15:39:51',0,NULL,NULL,NULL,'9606a3fa-2bf8-4e50-ad9b-98e7c77cfed1'),(83,21,1,'2017-03-10 12:39:51','2017-03-10 14:13:51',NULL,1,2,'2017-05-02 15:39:51',2,'2017-05-02 15:39:52',0,NULL,NULL,NULL,'2bf7ce58-f8f5-459f-aed4-2859191291c4'),(84,21,1,'2016-11-20 12:39:52','2016-11-20 14:44:52',NULL,1,2,'2017-05-02 15:39:52',2,'2017-05-02 15:39:52',0,NULL,NULL,NULL,'488a837e-1ddb-42e8-9d67-6bf8dc0ac6e8'),(85,21,1,'2017-02-15 12:39:52','2017-02-15 14:31:52',NULL,1,2,'2017-05-02 15:39:53',2,'2017-05-02 15:39:53',0,NULL,NULL,NULL,'0dd22547-94b3-4b43-8f81-4f9f930ff314'),(86,21,1,'2017-04-29 12:39:53','2017-04-29 15:08:53',NULL,1,2,'2017-05-02 15:39:53',2,'2017-05-02 15:39:54',0,NULL,NULL,NULL,'ddee3e10-3d5b-4a35-b692-f9ac10c4c885'),(87,21,1,'2015-10-26 12:39:54','2015-10-29 14:35:54',NULL,1,2,'2017-05-02 15:39:54',2,'2017-05-02 15:39:55',0,NULL,NULL,NULL,'4e0deebe-3c31-4eba-94e1-1b379ab9619c'),(88,21,1,'2016-11-21 12:39:55','2016-11-23 14:02:55',NULL,1,2,'2017-05-02 15:39:55',2,'2017-05-02 15:39:55',0,NULL,NULL,NULL,'8134ab83-ebc6-4394-881f-076f92f4e0a0'),(89,22,1,'2016-06-02 12:39:56','2016-06-02 14:27:56',NULL,1,2,'2017-05-02 15:39:56',2,'2017-05-02 15:39:56',0,NULL,NULL,NULL,'d7c8bff0-5fee-48d0-9e47-01a7a621d521'),(90,22,1,'2016-08-22 12:39:56','2016-08-22 14:10:56',NULL,1,2,'2017-05-02 15:39:56',2,'2017-05-02 15:39:57',0,NULL,NULL,NULL,'e5d8a75f-2f5e-48f1-a289-9f987f4e32a2'),(91,22,1,'2016-12-21 12:39:57','2016-12-21 14:43:57',NULL,1,2,'2017-05-02 15:39:57',2,'2017-05-02 15:39:58',0,NULL,NULL,NULL,'838f6332-88e7-49d2-955e-88d68a479c6b'),(92,22,1,'2016-02-02 12:39:58','2016-02-05 14:17:58',NULL,1,2,'2017-05-02 15:39:58',2,'2017-05-02 15:39:58',0,NULL,NULL,NULL,'4cd5c751-7dac-49fc-97a3-9039f405744f'),(93,23,1,'2015-08-09 12:39:59','2015-08-09 14:54:59',NULL,1,2,'2017-05-02 15:39:59',2,'2017-05-02 15:39:59',0,NULL,NULL,NULL,'e6361fab-255c-4592-bd36-a5a0708a823c'),(94,23,1,'2017-03-12 12:39:59','2017-03-12 14:13:59',NULL,1,2,'2017-05-02 15:39:59',2,'2017-05-02 15:40:00',0,NULL,NULL,NULL,'b6770c48-250c-4def-8db2-e91cd7ca16a7'),(95,23,1,'2015-08-18 12:40:00','2015-08-18 14:21:00',NULL,1,2,'2017-05-02 15:40:00',2,'2017-05-02 15:40:01',0,NULL,NULL,NULL,'ddf2b795-7510-49bd-960e-0ff09508ac90'),(96,23,1,'2015-10-28 12:40:01','2015-10-28 14:34:01',NULL,1,2,'2017-05-02 15:40:01',2,'2017-05-02 15:40:01',0,NULL,NULL,NULL,'b0c1f43b-f481-42e4-b325-57117d41f040'),(97,23,1,'2016-01-16 12:40:01','2016-01-16 14:57:01',NULL,1,2,'2017-05-02 15:40:01',2,'2017-05-02 15:40:02',0,NULL,NULL,NULL,'e660ef15-6ad1-4e9a-b911-8a489150786b'),(98,23,1,'2015-10-13 12:40:02','2015-10-13 14:44:02',NULL,1,2,'2017-05-02 15:40:02',2,'2017-05-02 15:40:02',0,NULL,NULL,NULL,'62f886d5-0b8d-4aef-b54d-0bc4a9720515'),(99,23,1,'2017-03-15 12:40:02','2017-03-15 14:37:02',NULL,1,2,'2017-05-02 15:40:03',2,'2017-05-02 15:40:03',0,NULL,NULL,NULL,'876fcae2-c485-4719-b4fc-b62184c0cb2c'),(100,23,1,'2016-07-27 12:40:03','2016-07-29 13:47:03',NULL,1,2,'2017-05-02 15:40:03',2,'2017-05-02 15:40:04',0,NULL,NULL,NULL,'ff7bb8e9-2531-46e5-878b-db810d7a9366'),(101,23,1,'2016-02-06 12:40:04','2016-02-09 13:58:04',NULL,1,2,'2017-05-02 15:40:04',2,'2017-05-02 15:40:05',0,NULL,NULL,NULL,'b2efe2f7-841e-4fec-a1e8-4571d2a8b924'),(102,24,1,'2015-06-04 12:40:05','2015-06-04 14:49:05',NULL,1,2,'2017-05-02 15:40:05',2,'2017-05-02 15:40:05',0,NULL,NULL,NULL,'39b7503b-bcb4-489a-bc0e-b245793bfd0f'),(103,24,1,'2016-12-12 12:40:05','2016-12-12 14:47:05',NULL,1,2,'2017-05-02 15:40:06',2,'2017-05-02 15:40:06',0,NULL,NULL,NULL,'4a4aafe7-f02b-418e-98dd-a97b57112afa'),(104,24,1,'2016-06-12 12:40:06','2016-06-12 14:47:06',NULL,1,2,'2017-05-02 15:40:07',2,'2017-05-02 15:40:07',0,NULL,NULL,NULL,'96d919e8-8785-4734-aa99-e26d13505dfe'),(105,24,1,'2016-11-29 12:40:07','2016-11-29 14:41:07',NULL,1,2,'2017-05-02 15:40:07',2,'2017-05-02 15:40:08',0,NULL,NULL,NULL,'d2db7f2c-f8dd-46a8-b9a9-17c3efa531b1'),(106,24,1,'2015-06-07 12:40:08','2015-06-07 14:51:08',NULL,1,2,'2017-05-02 15:40:08',2,'2017-05-02 15:40:08',0,NULL,NULL,NULL,'e4961951-521d-485e-a72b-6ad3cb71355d'),(107,24,1,'2016-01-26 12:40:08','2016-01-27 14:36:08',NULL,1,2,'2017-05-02 15:40:09',2,'2017-05-02 15:40:09',0,NULL,NULL,NULL,'e04895d2-3261-4eeb-acb1-bec849645a6f'),(108,25,1,'2016-03-11 12:40:09','2016-03-11 14:57:09',NULL,1,2,'2017-05-02 15:40:09',2,'2017-05-02 15:40:10',0,NULL,NULL,NULL,'586eb173-a27e-4e1e-a331-cd355c142aca'),(109,25,1,'2015-07-03 12:40:10','2015-07-03 14:35:10',NULL,1,2,'2017-05-02 15:40:10',2,'2017-05-02 15:40:10',0,NULL,NULL,NULL,'910513eb-4514-4eb3-bc64-cb701821ca15'),(110,25,1,'2017-01-18 12:40:10','2017-01-18 14:20:10',NULL,1,2,'2017-05-02 15:40:11',2,'2017-05-02 15:40:12',0,NULL,NULL,NULL,'e5336963-d307-4938-a648-aa9ecb6cc94c'),(111,25,1,'2015-08-31 12:40:12','2015-08-31 14:39:12',NULL,1,2,'2017-05-02 15:40:12',2,'2017-05-02 15:40:12',0,NULL,NULL,NULL,'57825dc9-1ce6-4502-b2ad-16c2fbfa8df4'),(112,25,1,'2017-02-25 12:40:12','2017-02-25 14:41:12',NULL,1,2,'2017-05-02 15:40:13',2,'2017-05-02 15:40:13',0,NULL,NULL,NULL,'228bf782-90e6-4cc1-8dce-d0be8476d713'),(113,25,1,'2016-08-21 12:40:13','2016-08-21 14:34:13',NULL,1,2,'2017-05-02 15:40:13',2,'2017-05-02 15:40:14',0,NULL,NULL,NULL,'eb7eb7ce-5a5e-491f-9422-e825de04d179'),(114,25,1,'2016-07-07 12:40:14','2016-07-07 14:55:14',NULL,1,2,'2017-05-02 15:40:14',2,'2017-05-02 15:40:15',0,NULL,NULL,NULL,'b9887a52-0854-41f2-8c76-ec9a129203b7'),(115,25,1,'2016-04-11 12:40:15','2016-04-13 13:53:15',NULL,1,2,'2017-05-02 15:40:15',2,'2017-05-02 15:40:16',0,NULL,NULL,NULL,'403bd1a6-99a7-4330-b4f6-18da89ba1b96'),(116,25,1,'2016-09-05 12:40:16','2016-09-08 14:36:16',NULL,1,2,'2017-05-02 15:40:16',2,'2017-05-02 15:40:17',0,NULL,NULL,NULL,'0168e25f-1963-418c-bff4-d0a40f84927a'),(117,26,1,'2017-01-20 12:40:17','2017-01-20 14:14:17',NULL,1,2,'2017-05-02 15:40:17',2,'2017-05-02 15:40:17',0,NULL,NULL,NULL,'f70a84e3-71cc-41ee-9ac3-f4e3c33a27b0'),(118,26,1,'2016-01-17 12:40:17','2016-01-17 14:51:17',NULL,1,2,'2017-05-02 15:40:17',2,'2017-05-02 15:40:18',0,NULL,NULL,NULL,'f7216abd-c6ad-4ed5-a007-3ef4378b677f'),(119,26,1,'2016-08-13 12:40:18','2016-08-13 14:42:18',NULL,1,2,'2017-05-02 15:40:18',2,'2017-05-02 15:40:19',0,NULL,NULL,NULL,'77f6e285-83ca-4627-9d11-c7ea2e61fe59'),(120,26,1,'2016-06-24 12:40:19','2016-06-24 15:02:19',NULL,1,2,'2017-05-02 15:40:19',2,'2017-05-02 15:40:20',0,NULL,NULL,NULL,'2d6197eb-a2bf-4d04-8957-6173c951d28a'),(121,26,1,'2016-08-27 12:40:20','2016-08-27 14:46:20',NULL,1,2,'2017-05-02 15:40:20',2,'2017-05-02 15:40:20',0,NULL,NULL,NULL,'214c7e79-cd0e-4899-9871-7fc6f5c8848c'),(122,26,1,'2015-09-12 12:40:20','2015-09-12 15:00:20',NULL,1,2,'2017-05-02 15:40:20',2,'2017-05-02 15:40:21',0,NULL,NULL,NULL,'89eb746d-f2ba-4819-9c90-52a1e264c6af'),(123,26,1,'2016-03-16 12:40:21','2016-03-16 14:47:21',NULL,1,2,'2017-05-02 15:40:21',2,'2017-05-02 15:40:22',0,NULL,NULL,NULL,'2f7c2a4c-5fe2-4561-899f-447e26dd0929'),(124,26,1,'2015-10-20 12:40:22','2015-10-22 14:15:22',NULL,1,2,'2017-05-02 15:40:22',2,'2017-05-02 15:40:23',0,NULL,NULL,NULL,'09f28ada-8e9e-470c-9cc8-6e9c17f1364c'),(125,26,1,'2015-07-01 12:40:23','2015-07-04 13:51:23',NULL,1,2,'2017-05-02 15:40:23',2,'2017-05-02 15:40:23',0,NULL,NULL,NULL,'8a548d55-b218-4e02-ae0e-92654ff6d2be'),(126,27,1,'2016-03-23 12:40:23','2016-03-23 14:46:23',NULL,1,2,'2017-05-02 15:40:24',2,'2017-05-02 15:40:24',0,NULL,NULL,NULL,'1f03d4b2-d587-4cc9-a230-dc86b2af67a0'),(127,27,1,'2017-04-28 12:40:24','2017-04-28 14:50:24',NULL,1,2,'2017-05-02 15:40:24',2,'2017-05-02 15:40:25',0,NULL,NULL,NULL,'319c147d-17e3-40cc-b642-a7e634cae3e7'),(128,27,1,'2017-04-15 12:40:25','2017-04-15 14:38:25',NULL,1,2,'2017-05-02 15:40:25',2,'2017-05-02 15:40:26',0,NULL,NULL,NULL,'b670d0b5-4039-4971-a1d2-73282e355dd4'),(129,27,1,'2015-12-30 12:40:26','2015-12-30 14:22:26',NULL,1,2,'2017-05-02 15:40:26',2,'2017-05-02 15:40:26',0,NULL,NULL,NULL,'deff94a6-b73f-4ca1-af8f-0b599a1b481c'),(130,27,1,'2015-05-19 12:40:26','2015-05-19 15:05:26',NULL,1,2,'2017-05-02 15:40:27',2,'2017-05-02 15:40:27',0,NULL,NULL,NULL,'e49d078f-5c2b-41d1-abae-07454d0bdfe2'),(131,27,1,'2015-10-08 12:40:27','2015-10-08 14:48:27',NULL,1,2,'2017-05-02 15:40:27',2,'2017-05-02 15:40:28',0,NULL,NULL,NULL,'ba15bf27-c7e0-4bf7-b166-b529d536797d'),(132,27,1,'2016-05-01 12:40:28','2016-05-04 14:05:28',NULL,1,2,'2017-05-02 15:40:28',2,'2017-05-02 15:40:28',0,NULL,NULL,NULL,'73382c74-b38b-4e13-8b14-05c9ebf0900a'),(133,28,1,'2016-03-20 12:40:28','2016-03-20 14:37:28',NULL,1,2,'2017-05-02 15:40:29',2,'2017-05-02 15:40:29',0,NULL,NULL,NULL,'c1af81a0-aa36-4839-abf5-9b92b6e97ecf'),(134,29,1,'2017-04-01 12:40:29','2017-04-01 14:47:29',NULL,1,2,'2017-05-02 15:40:29',2,'2017-05-02 15:40:30',0,NULL,NULL,NULL,'987136c9-d737-4efb-ad71-90b1b03308ed'),(135,29,1,'2016-08-24 12:40:30','2016-08-24 15:09:30',NULL,1,2,'2017-05-02 15:40:30',2,'2017-05-02 15:40:31',0,NULL,NULL,NULL,'14389f02-dd86-4aa6-90d3-49903a102df5'),(136,29,1,'2017-02-02 12:40:31','2017-02-02 14:43:31',NULL,1,2,'2017-05-02 15:40:31',2,'2017-05-02 15:40:32',0,NULL,NULL,NULL,'4bf781f5-ee30-49d3-abf5-e6219d38addf'),(137,29,1,'2016-09-03 12:40:32','2016-09-03 14:14:32',NULL,1,2,'2017-05-02 15:40:32',2,'2017-05-02 15:40:32',0,NULL,NULL,NULL,'f82e3491-adb8-4c1b-851f-48c6eae56d4a'),(138,29,1,'2016-09-16 12:40:32','2016-09-16 14:37:32',NULL,1,2,'2017-05-02 15:40:33',2,'2017-05-02 15:40:33',0,NULL,NULL,NULL,'d74f8fcb-331a-4e15-b2b8-3c4d39c65a82'),(139,29,1,'2017-02-07 12:40:33','2017-02-07 14:18:33',NULL,1,2,'2017-05-02 15:40:34',2,'2017-05-02 15:40:34',0,NULL,NULL,NULL,'722e69b8-586e-431b-b687-9b05829573aa'),(140,29,1,'2016-06-13 12:40:34','2016-06-14 13:58:34',NULL,1,2,'2017-05-02 15:40:34',2,'2017-05-02 15:40:35',0,NULL,NULL,NULL,'20e758c7-6a74-4a5d-921e-b009aed0b1ee'),(141,30,1,'2017-04-22 12:40:35','2017-04-22 14:36:35',NULL,1,2,'2017-05-02 15:40:35',2,'2017-05-02 15:40:36',0,NULL,NULL,NULL,'1a09dc59-e7a6-4100-82b0-07ab5606984f'),(142,31,1,'2016-02-24 12:40:36','2016-02-24 15:01:36',NULL,1,2,'2017-05-02 15:40:36',2,'2017-05-02 15:40:36',0,NULL,NULL,NULL,'80ccbe02-e21c-41e0-bb15-14a1fe47053c'),(143,31,1,'2016-10-02 12:40:36','2016-10-02 14:24:36',NULL,1,2,'2017-05-02 15:40:37',2,'2017-05-02 15:40:37',0,NULL,NULL,NULL,'4067f1ee-7a72-4f3c-8cd3-5438ad78280e'),(144,31,1,'2016-09-14 12:40:37','2016-09-14 14:39:37',NULL,1,2,'2017-05-02 15:40:38',2,'2017-05-02 15:40:38',0,NULL,NULL,NULL,'c761c7ce-5d92-49c9-867a-8562a98dd1d2'),(145,31,1,'2016-10-12 12:40:38','2016-10-12 14:29:38',NULL,1,2,'2017-05-02 15:40:38',2,'2017-05-02 15:40:39',0,NULL,NULL,NULL,'f65a6d61-eeea-4593-a5d1-7d25917bee32'),(146,31,1,'2017-03-02 12:40:39','2017-03-02 14:59:39',NULL,1,2,'2017-05-02 15:40:39',2,'2017-05-02 15:40:40',0,NULL,NULL,NULL,'cb152b4c-3ee0-4df0-85be-9d06a1aaeec6'),(147,31,1,'2015-05-15 12:40:40','2015-05-15 14:39:40',NULL,1,2,'2017-05-02 15:40:40',2,'2017-05-02 15:40:40',0,NULL,NULL,NULL,'b65d4a22-31f1-4ac3-a911-47c1ce42d522'),(148,31,1,'2015-08-16 12:40:40','2015-08-16 14:54:40',NULL,1,2,'2017-05-02 15:40:41',2,'2017-05-02 15:40:41',0,NULL,NULL,NULL,'4321e3cf-c474-49fd-96db-34211375985c'),(149,31,1,'2015-11-01 12:40:41','2015-11-02 14:21:41',NULL,1,2,'2017-05-02 15:40:42',2,'2017-05-02 15:40:42',0,NULL,NULL,NULL,'868a13d8-408b-4549-8f5a-9a922cccc9e2'),(150,31,1,'2016-07-04 12:40:42','2016-07-05 14:18:42',NULL,1,2,'2017-05-02 15:40:42',2,'2017-05-02 15:40:43',0,NULL,NULL,NULL,'cbf921a8-beca-4903-bb0e-fd6f9d9fb116'),(151,32,1,'2017-03-03 12:40:43','2017-03-03 14:49:43',NULL,1,2,'2017-05-02 15:40:43',2,'2017-05-02 15:40:44',0,NULL,NULL,NULL,'717e8812-6005-439b-848b-cd3a0f7b295f'),(152,33,1,'2016-03-09 12:40:44','2016-03-09 14:30:44',NULL,1,2,'2017-05-02 15:40:44',2,'2017-05-02 15:40:44',0,NULL,NULL,NULL,'9368a0af-be1e-48b7-897f-fd97daee8a09'),(153,33,1,'2016-03-28 12:40:44','2016-03-28 14:58:44',NULL,1,2,'2017-05-02 15:40:45',2,'2017-05-02 15:40:45',0,NULL,NULL,NULL,'1abcdf88-42ef-487f-aab3-144f1cf6abf4'),(154,34,1,'2016-03-13 12:40:45','2016-03-13 14:21:45',NULL,1,2,'2017-05-02 15:40:45',2,'2017-05-02 15:40:46',0,NULL,NULL,NULL,'d9bc4a0e-7440-4981-b47b-fb3d02f1acd0'),(155,34,1,'2015-12-29 12:40:46','2015-12-29 14:34:46',NULL,1,2,'2017-05-02 15:40:46',2,'2017-05-02 15:40:47',0,NULL,NULL,NULL,'036854a8-025d-402c-92ce-335f9318be7f'),(156,34,1,'2015-07-23 12:40:47','2015-07-23 14:32:47',NULL,1,2,'2017-05-02 15:40:47',2,'2017-05-02 15:40:47',0,NULL,NULL,NULL,'14b78d8a-bb16-43fe-8bca-e73fa5b92ce8'),(157,34,1,'2016-03-09 12:40:47','2016-03-09 15:07:47',NULL,1,2,'2017-05-02 15:40:47',2,'2017-05-02 15:40:48',0,NULL,NULL,NULL,'406a7846-6895-44a8-96a0-87414412e1ff'),(158,34,1,'2017-03-18 12:40:48','2017-03-20 14:20:48',NULL,1,2,'2017-05-02 15:40:48',2,'2017-05-02 15:40:49',0,NULL,NULL,NULL,'abb60dcb-e0d3-4e1e-bd76-ed66bc1c41c2'),(159,35,1,'2017-01-16 12:40:49','2017-01-16 14:42:49',NULL,1,2,'2017-05-02 15:40:49',2,'2017-05-02 15:40:50',0,NULL,NULL,NULL,'687eea80-36fb-4e05-a86f-5b4f446e4b62'),(160,35,1,'2016-04-06 12:40:50','2016-04-06 14:27:50',NULL,1,2,'2017-05-02 15:40:50',2,'2017-05-02 15:40:50',0,NULL,NULL,NULL,'c20024ef-36fa-4ec5-98d4-d3da59421b40'),(161,36,1,'2015-09-28 12:40:50','2015-09-28 14:40:50',NULL,1,2,'2017-05-02 15:40:50',2,'2017-05-02 15:40:51',0,NULL,NULL,NULL,'8f1b01fb-0522-4b6e-9245-8220cf1e8f0d'),(162,36,1,'2016-01-12 12:40:51','2016-01-12 14:11:51',NULL,1,2,'2017-05-02 15:40:51',2,'2017-05-02 15:40:52',0,NULL,NULL,NULL,'2cf0da87-25cc-4f2f-940f-0d269460c38c'),(163,36,1,'2016-02-22 12:40:52','2016-02-22 14:57:52',NULL,1,2,'2017-05-02 15:40:52',2,'2017-05-02 15:40:52',0,NULL,NULL,NULL,'b5a609e5-9e0b-46e3-9188-ac9981380726'),(164,36,1,'2015-12-11 12:40:52','2015-12-11 15:04:52',NULL,1,2,'2017-05-02 15:40:53',2,'2017-05-02 15:40:54',0,NULL,NULL,NULL,'4121de53-8129-4c01-8e8e-fbdcbdda980e'),(165,36,1,'2016-04-08 12:40:54','2016-04-08 14:53:54',NULL,1,2,'2017-05-02 15:40:54',2,'2017-05-02 15:40:54',0,NULL,NULL,NULL,'d7a88c92-7a2a-4385-a6ad-58590b8b613b'),(166,36,1,'2016-02-25 12:40:54','2016-02-26 13:40:54',NULL,1,2,'2017-05-02 15:40:55',2,'2017-05-02 15:40:55',0,NULL,NULL,NULL,'0441c206-1694-4cf3-9888-5e1ff52b3e8d'),(167,37,1,'2015-12-07 12:40:55','2015-12-07 15:10:55',NULL,1,2,'2017-05-02 15:40:55',2,'2017-05-02 15:40:56',0,NULL,NULL,NULL,'654206cc-6fbe-43d8-a056-287473da30c6'),(168,37,1,'2016-08-28 12:40:56','2016-08-28 14:53:56',NULL,1,2,'2017-05-02 15:40:56',2,'2017-05-02 15:40:57',0,NULL,NULL,NULL,'1b9f71dc-b649-4d5c-825c-e31e736a5a44'),(169,38,1,'2016-10-17 12:40:57','2016-10-17 14:31:57',NULL,1,2,'2017-05-02 15:40:57',2,'2017-05-02 15:40:57',0,NULL,NULL,NULL,'24857948-5b26-49c1-b423-2b09bea7939c'),(170,38,1,'2015-11-03 12:40:57','2015-11-03 15:05:57',NULL,1,2,'2017-05-02 15:40:58',2,'2017-05-02 15:40:58',0,NULL,NULL,NULL,'b90af8e2-05dc-4cda-b0f4-40a4d618dcc8'),(171,38,1,'2016-06-03 12:40:58','2016-06-03 14:35:58',NULL,1,2,'2017-05-02 15:40:59',2,'2017-05-02 15:40:59',0,NULL,NULL,NULL,'0d4c2e63-1811-4037-bdff-f6b075fb3f5a'),(172,38,1,'2016-10-18 12:40:59','2016-10-18 14:15:59',NULL,1,2,'2017-05-02 15:40:59',2,'2017-05-02 15:41:00',0,NULL,NULL,NULL,'2309b3ed-59bc-4c96-bcdf-9bc1eefe07b5'),(173,38,1,'2015-07-05 12:41:00','2015-07-05 14:39:00',NULL,1,2,'2017-05-02 15:41:00',2,'2017-05-02 15:41:00',0,NULL,NULL,NULL,'79fc5ec1-3cbb-4cdf-a2fb-4b300f9100f4'),(174,38,1,'2016-01-22 12:41:00','2016-01-24 14:20:00',NULL,1,2,'2017-05-02 15:41:01',2,'2017-05-02 15:41:01',0,NULL,NULL,NULL,'365b7274-30d8-460d-a6dd-a0c6a0fffada'),(175,39,1,'2017-02-02 12:41:01','2017-02-02 14:55:01',NULL,1,2,'2017-05-02 15:41:01',2,'2017-05-02 15:41:02',0,NULL,NULL,NULL,'e4eae7bd-0c9d-40b9-922d-349cda649b4b'),(176,39,1,'2016-02-04 12:41:02','2016-02-04 14:42:02',NULL,1,2,'2017-05-02 15:41:02',2,'2017-05-02 15:41:02',0,NULL,NULL,NULL,'14b8dc0f-612b-4d96-8db5-dfa2dd3cd8ba'),(177,40,1,'2017-04-13 12:41:03','2017-04-13 14:44:03',NULL,1,2,'2017-05-02 15:41:03',2,'2017-05-02 15:41:03',0,NULL,NULL,NULL,'2a04f825-a533-4fc2-81d7-db96af797a76'),(178,41,1,'2016-10-19 12:41:03','2016-10-19 15:02:03',NULL,1,2,'2017-05-02 15:41:04',2,'2017-05-02 15:41:04',0,NULL,NULL,NULL,'6e276c77-619f-4734-a66b-214fe3e3395e'),(179,41,1,'2016-05-15 12:41:04','2016-05-15 14:29:04',NULL,1,2,'2017-05-02 15:41:05',2,'2017-05-02 15:41:05',0,NULL,NULL,NULL,'de1e84fb-b439-4061-900b-0c969fc5c501'),(180,41,1,'2017-01-05 12:41:05','2017-01-05 15:02:05',NULL,1,2,'2017-05-02 15:41:05',2,'2017-05-02 15:41:06',0,NULL,NULL,NULL,'d688d10a-5893-4517-859e-d7c18f681a9f'),(181,41,1,'2015-09-23 12:41:06','2015-09-23 15:04:06',NULL,1,2,'2017-05-02 15:41:06',2,'2017-05-02 15:41:06',0,NULL,NULL,NULL,'8f8e7676-e041-4b67-a1bb-68adb9b54b45'),(182,41,1,'2017-01-16 12:41:06','2017-01-16 14:35:06',NULL,1,2,'2017-05-02 15:41:06',2,'2017-05-02 15:41:07',0,NULL,NULL,NULL,'b2ed927d-dd92-43bd-90b3-e731b2e134f3'),(183,41,1,'2015-09-04 12:41:07','2015-09-04 14:56:07',NULL,1,2,'2017-05-02 15:41:07',2,'2017-05-02 15:41:07',0,NULL,NULL,NULL,'8c4c5eb3-8815-4f26-a49e-5b66f3fdfd87'),(184,41,1,'2016-04-06 12:41:07','2016-04-06 14:34:07',NULL,1,2,'2017-05-02 15:41:08',2,'2017-05-02 15:41:08',0,NULL,NULL,NULL,'1bf461bf-dd43-41b2-b6cb-7b08eca8754e'),(185,41,1,'2016-03-02 12:41:08','2016-03-05 14:18:08',NULL,1,2,'2017-05-02 15:41:09',2,'2017-05-02 15:41:09',0,NULL,NULL,NULL,'ea8e3638-a485-4a75-b8bb-6b84ad5a4f30'),(186,41,1,'2016-09-17 12:41:09','2016-09-20 13:47:09',NULL,1,2,'2017-05-02 15:41:09',2,'2017-05-02 15:41:10',0,NULL,NULL,NULL,'277bee1e-0496-481c-b115-92ce2b431e4d'),(187,42,1,'2016-09-01 12:41:10','2016-09-01 14:31:10',NULL,1,2,'2017-05-02 15:41:10',2,'2017-05-02 15:41:11',0,NULL,NULL,NULL,'4a147b60-3c3b-46be-a9d1-70bea0c02f16'),(188,42,1,'2017-02-19 12:41:11','2017-02-19 15:09:11',NULL,1,2,'2017-05-02 15:41:11',2,'2017-05-02 15:41:11',0,NULL,NULL,NULL,'7155b311-4446-49a7-93c8-5bc9e7ff88cc'),(189,42,1,'2017-02-15 12:41:11','2017-02-15 15:11:11',NULL,1,2,'2017-05-02 15:41:11',2,'2017-05-02 15:41:12',0,NULL,NULL,NULL,'0f7975a3-f84a-45c7-aa12-d490b0a17e83'),(190,42,1,'2016-03-18 12:41:12','2016-03-18 14:15:12',NULL,1,2,'2017-05-02 15:41:12',2,'2017-05-02 15:41:12',0,NULL,NULL,NULL,'4da190b6-1deb-4e3d-9472-fb87dd04fce4'),(191,42,1,'2015-07-30 12:41:12','2015-07-30 14:31:12',NULL,1,2,'2017-05-02 15:41:13',2,'2017-05-02 15:41:13',0,NULL,NULL,NULL,'349878cc-1050-44cf-9995-5cdc0cbbde13'),(192,42,1,'2015-05-17 12:41:13','2015-05-19 13:45:13',NULL,1,2,'2017-05-02 15:41:13',2,'2017-05-02 15:41:14',0,NULL,NULL,NULL,'cbd3c5ec-ee5d-461c-b07d-c659639be81d'),(193,43,1,'2016-02-10 12:41:14','2016-02-10 14:16:14',NULL,1,2,'2017-05-02 15:41:14',2,'2017-05-02 15:41:15',0,NULL,NULL,NULL,'d57ae680-5782-4011-a432-40cfd11849a6'),(194,43,1,'2016-10-21 12:41:15','2016-10-21 14:44:15',NULL,1,2,'2017-05-02 15:41:15',2,'2017-05-02 15:41:16',0,NULL,NULL,NULL,'951779ed-dd03-414f-9c76-0adf898384d5'),(195,43,1,'2017-02-08 12:41:16','2017-02-08 14:20:16',NULL,1,2,'2017-05-02 15:41:16',2,'2017-05-02 15:41:17',0,NULL,NULL,NULL,'2819f21b-3962-4231-a0a7-5004a6368ab1'),(196,43,1,'2017-03-22 12:41:17','2017-03-22 15:10:17',NULL,1,2,'2017-05-02 15:41:17',2,'2017-05-02 15:41:17',0,NULL,NULL,NULL,'0a3c8686-0c7a-4065-97a0-400c2400d846'),(197,43,1,'2016-08-26 12:41:17','2016-08-27 14:24:17',NULL,1,2,'2017-05-02 15:41:18',2,'2017-05-02 15:41:18',0,NULL,NULL,NULL,'ece69f59-82f2-4736-aad5-134026da4f6b'),(198,44,1,'2015-05-21 12:41:18','2015-05-21 15:02:18',NULL,1,2,'2017-05-02 15:41:18',2,'2017-05-02 15:41:19',0,NULL,NULL,NULL,'76f0dd77-751c-45ff-84f0-5f88f6767ec4'),(199,44,1,'2015-10-27 12:41:19','2015-10-27 14:36:19',NULL,1,2,'2017-05-02 15:41:19',2,'2017-05-02 15:41:19',0,NULL,NULL,NULL,'77d22650-2ee5-4255-adae-0519778a4982'),(200,44,1,'2016-04-12 12:41:19','2016-04-12 14:43:19',NULL,1,2,'2017-05-02 15:41:20',2,'2017-05-02 15:41:20',0,NULL,NULL,NULL,'4120869f-16b2-4056-bc3d-cb703233bbc8'),(201,44,1,'2015-08-28 12:41:20','2015-08-28 14:58:20',NULL,1,2,'2017-05-02 15:41:20',2,'2017-05-02 15:41:21',0,NULL,NULL,NULL,'ce19d06c-5c92-4ec4-b026-6a58f88ee553'),(202,44,1,'2016-11-30 12:41:21','2016-11-30 14:52:21',NULL,1,2,'2017-05-02 15:41:21',2,'2017-05-02 15:41:21',0,NULL,NULL,NULL,'67397e51-8031-41d8-b2ce-e6fc19881fcf'),(203,44,1,'2015-06-23 12:41:21','2015-06-26 14:19:21',NULL,1,2,'2017-05-02 15:41:22',2,'2017-05-02 15:41:22',0,NULL,NULL,NULL,'58a96255-2e67-4536-a253-3411528ac86f'),(204,45,1,'2015-10-09 12:41:22','2015-10-09 14:37:22',NULL,1,2,'2017-05-02 15:41:22',2,'2017-05-02 15:41:23',0,NULL,NULL,NULL,'3dfb296b-7f18-4f17-b5fb-24394b7850e1'),(205,45,1,'2015-07-05 12:41:23','2015-07-05 14:17:23',NULL,1,2,'2017-05-02 15:41:23',2,'2017-05-02 15:41:24',0,NULL,NULL,NULL,'840fc21b-61b3-4c05-96c8-712856db062f'),(206,45,1,'2015-08-12 12:41:24','2015-08-12 14:28:24',NULL,1,2,'2017-05-02 15:41:24',2,'2017-05-02 15:41:24',0,NULL,NULL,NULL,'ad075346-1a02-4a84-939d-4ad7cf4c6955'),(207,45,1,'2015-05-15 12:41:24','2015-05-15 15:06:24',NULL,1,2,'2017-05-02 15:41:25',2,'2017-05-02 15:41:25',0,NULL,NULL,NULL,'d23fae3f-3d66-42a5-b731-3f998b68bcbf'),(208,45,1,'2017-01-04 12:41:25','2017-01-04 14:29:25',NULL,1,2,'2017-05-02 15:41:25',2,'2017-05-02 15:41:26',0,NULL,NULL,NULL,'ef25804e-6ea3-4552-8195-cc0b45b52253'),(209,45,1,'2015-05-26 12:41:26','2015-05-26 14:32:26',NULL,1,2,'2017-05-02 15:41:26',2,'2017-05-02 15:41:27',0,NULL,NULL,NULL,'368400e5-73dd-4294-958a-09a3d356c10f'),(210,45,1,'2016-09-16 12:41:27','2016-09-16 14:19:27',NULL,1,2,'2017-05-02 15:41:27',2,'2017-05-02 15:41:27',0,NULL,NULL,NULL,'1c4d4884-4cc3-4819-a0b6-e7ffa0c2335c'),(211,45,1,'2016-10-07 12:41:27','2016-10-07 14:42:27',NULL,1,2,'2017-05-02 15:41:28',2,'2017-05-02 15:41:28',0,NULL,NULL,NULL,'0afc54e9-1cc3-415c-aad3-4af3538e7527'),(212,45,1,'2017-04-16 12:41:28','2017-04-17 13:49:28',NULL,1,2,'2017-05-02 15:41:29',2,'2017-05-02 15:41:29',0,NULL,NULL,NULL,'fb0ccd51-5b7e-44e0-9bb8-cfa6a63ccf51'),(213,45,1,'2016-04-01 12:41:29','2016-04-04 14:08:29',NULL,1,2,'2017-05-02 15:41:30',2,'2017-05-02 15:41:30',0,NULL,NULL,NULL,'cd052e38-27c3-46ef-a2c9-fa111e4c5d48'),(214,46,1,'2015-09-09 12:41:30','2015-09-09 14:29:30',NULL,1,2,'2017-05-02 15:41:30',2,'2017-05-02 15:41:31',0,NULL,NULL,NULL,'9230de0b-c3e0-4bbf-9b17-fa483ab0bad9'),(215,46,1,'2015-12-21 12:41:31','2015-12-21 14:55:31',NULL,1,2,'2017-05-02 15:41:31',2,'2017-05-02 15:41:32',0,NULL,NULL,NULL,'9346dda0-aef3-422f-ba3a-ea3ae38fba0d'),(216,46,1,'2016-02-08 12:41:32','2016-02-08 14:25:32',NULL,1,2,'2017-05-02 15:41:32',2,'2017-05-02 15:41:33',0,NULL,NULL,NULL,'bea54ef8-7189-458b-934a-5d0977dfd615'),(217,46,1,'2017-01-11 12:41:33','2017-01-11 15:01:33',NULL,1,2,'2017-05-02 15:41:33',2,'2017-05-02 15:41:34',0,NULL,NULL,NULL,'2fcbea3f-b28d-4459-aafd-c7c175133ee5'),(218,46,1,'2017-04-08 12:41:34','2017-04-08 15:11:34',NULL,1,2,'2017-05-02 15:41:34',2,'2017-05-02 15:41:35',0,NULL,NULL,NULL,'a2b5edd6-f5a0-4b9a-b61a-0d0a9a95d0af'),(219,46,1,'2017-03-14 12:41:35','2017-03-16 14:31:35',NULL,1,2,'2017-05-02 15:41:35',2,'2017-05-02 15:41:35',0,NULL,NULL,NULL,'7f74dfe6-68a1-4e1c-9377-584c45a8e428'),(220,47,1,'2015-11-25 12:41:35','2015-11-25 14:23:35',NULL,1,2,'2017-05-02 15:41:36',2,'2017-05-02 15:41:36',0,NULL,NULL,NULL,'c6b37cae-f3ef-428a-be05-c24229b4d2c2'),(221,47,1,'2015-05-16 12:41:36','2015-05-16 14:38:36',NULL,1,2,'2017-05-02 15:41:36',2,'2017-05-02 15:41:37',0,NULL,NULL,NULL,'0bb11f89-a6b2-4fd1-bc5e-4f927497b50a'),(222,47,1,'2017-02-13 12:41:37','2017-02-13 14:33:37',NULL,1,2,'2017-05-02 15:41:37',2,'2017-05-02 15:41:37',0,NULL,NULL,NULL,'00f5ae18-15fd-4787-8d24-bc45283c3c37'),(223,47,1,'2015-06-30 12:41:37','2015-07-01 13:42:37',NULL,1,2,'2017-05-02 15:41:38',2,'2017-05-02 15:41:38',0,NULL,NULL,NULL,'f17d718b-9454-4114-9424-0f2017d73f06'),(224,48,1,'2017-02-28 12:41:38','2017-02-28 15:01:38',NULL,1,2,'2017-05-02 15:41:38',2,'2017-05-02 15:41:39',0,NULL,NULL,NULL,'be1e448e-8f61-40b9-b18e-7e4c76b06c54'),(225,48,1,'2016-04-07 12:41:39','2016-04-07 14:38:39',NULL,1,2,'2017-05-02 15:41:39',2,'2017-05-02 15:41:39',0,NULL,NULL,NULL,'614556ea-67d1-42b5-8ade-377db03cfb1a'),(226,48,1,'2016-09-20 12:41:40','2016-09-20 15:02:40',NULL,1,2,'2017-05-02 15:41:40',2,'2017-05-02 15:41:40',0,NULL,NULL,NULL,'32a24213-4647-436e-b5d3-b9ee108c2beb'),(227,48,1,'2015-05-17 12:41:40','2015-05-17 14:45:40',NULL,1,2,'2017-05-02 15:41:40',2,'2017-05-02 15:41:41',0,NULL,NULL,NULL,'cbb2e1d0-c5ae-4b74-b257-792e98b61c36'),(228,48,1,'2015-06-23 12:41:41','2015-06-25 13:57:41',NULL,1,2,'2017-05-02 15:41:41',2,'2017-05-02 15:41:42',0,NULL,NULL,NULL,'a3ce6b7f-c82b-4e17-9731-c89d247f81bf'),(229,49,1,'2016-07-11 12:41:42','2016-07-11 14:14:42',NULL,1,2,'2017-05-02 15:41:42',2,'2017-05-02 15:41:43',0,NULL,NULL,NULL,'c5fe00ea-d5e8-4f55-9dee-3fb435ac2d53'),(230,49,1,'2016-01-05 12:41:43','2016-01-05 14:39:43',NULL,1,2,'2017-05-02 15:41:43',2,'2017-05-02 15:41:44',0,NULL,NULL,NULL,'d3f16a06-5043-439a-9699-65c0b991c76d'),(231,49,1,'2016-08-21 12:41:44','2016-08-21 14:51:44',NULL,1,2,'2017-05-02 15:41:44',2,'2017-05-02 15:41:45',0,NULL,NULL,NULL,'264ffc14-9b13-41a0-9d95-4623aad79126'),(232,49,1,'2015-09-06 12:41:45','2015-09-06 14:50:45',NULL,1,2,'2017-05-02 15:41:45',2,'2017-05-02 15:41:45',0,NULL,NULL,NULL,'8dec5bf6-fc92-44f4-8d13-ab3be502fe37'),(233,49,1,'2015-10-27 12:41:45','2015-10-27 15:00:45',NULL,1,2,'2017-05-02 15:41:46',2,'2017-05-02 15:41:46',0,NULL,NULL,NULL,'9a8fc7f1-aafe-4719-84c9-df8db634ee09'),(234,49,1,'2017-04-13 12:41:46','2017-04-14 13:41:46',NULL,1,2,'2017-05-02 15:41:46',2,'2017-05-02 15:41:47',0,NULL,NULL,NULL,'3fa8e729-2943-4f73-a075-0f442222cca2'),(235,50,1,'2015-08-14 12:41:47','2015-08-14 15:05:47',NULL,1,2,'2017-05-02 15:41:48',2,'2017-05-02 15:41:48',0,NULL,NULL,NULL,'ab712daa-5822-45ca-8019-22cfeef0ad5b'),(236,50,1,'2016-03-08 12:41:48','2016-03-08 14:36:48',NULL,1,2,'2017-05-02 15:41:48',2,'2017-05-02 15:41:48',0,NULL,NULL,NULL,'b695ad2d-09c6-4bce-aff1-544de9ba7d08'),(237,50,1,'2016-03-22 12:41:48','2016-03-22 14:25:48',NULL,1,2,'2017-05-02 15:41:49',2,'2017-05-02 15:41:49',0,NULL,NULL,NULL,'b0049445-ddad-4eee-b8a0-cd96ac865986'),(238,50,1,'2016-01-14 12:41:49','2016-01-14 14:19:49',NULL,1,2,'2017-05-02 15:41:50',2,'2017-05-02 15:41:50',0,NULL,NULL,NULL,'ffce434e-ece8-40ba-aa84-8abd219a681b'),(239,50,1,'2016-11-05 12:41:50','2016-11-08 13:56:50',NULL,1,2,'2017-05-02 15:41:50',2,'2017-05-02 15:41:51',0,NULL,NULL,NULL,'2c0de307-883a-4e5a-9875-c73b3ad72a90'),(240,51,1,'2016-01-10 12:41:51','2016-01-10 14:36:51',NULL,1,2,'2017-05-02 15:41:51',2,'2017-05-02 15:41:52',0,NULL,NULL,NULL,'ca070345-c879-4c5c-a9ea-bf6f3ca5032d'),(241,51,1,'2016-12-29 12:41:52','2016-12-29 15:08:52',NULL,1,2,'2017-05-02 15:41:52',2,'2017-05-02 15:41:53',0,NULL,NULL,NULL,'b68a9777-f50c-4eea-8c01-9eec396a50fa'),(242,51,1,'2016-02-20 12:41:53','2016-02-20 15:04:53',NULL,1,2,'2017-05-02 15:41:53',2,'2017-05-02 15:41:53',0,NULL,NULL,NULL,'761d002b-1d79-45a2-8458-c2158d4b5f81'),(243,51,1,'2016-11-10 12:41:53','2016-11-10 14:58:53',NULL,1,2,'2017-05-02 15:41:54',2,'2017-05-02 15:41:54',0,NULL,NULL,NULL,'a37c150e-9999-4fab-9b82-40c2a8cc1ac6'),(244,51,1,'2017-02-12 12:41:54','2017-02-13 14:08:54',NULL,1,2,'2017-05-02 15:41:54',2,'2017-05-02 15:41:55',0,NULL,NULL,NULL,'fbbfdd69-371e-4d1e-bd5f-b3da1022c589'),(245,52,1,'2016-01-15 12:41:55','2016-01-15 14:19:55',NULL,1,2,'2017-05-02 15:41:55',2,'2017-05-02 15:41:56',0,NULL,NULL,NULL,'b5b49648-f5d3-406a-84ba-e7c3582261f8'),(246,53,1,'2016-10-19 12:41:56','2016-10-19 14:34:56',NULL,1,2,'2017-05-02 15:41:56',2,'2017-05-02 15:41:57',0,NULL,NULL,NULL,'16f828e1-8544-410f-b7f3-5d2bfc0f8550'),(247,53,1,'2016-10-27 12:41:57','2016-10-27 15:02:57',NULL,1,2,'2017-05-02 15:41:57',2,'2017-05-02 15:41:58',0,NULL,NULL,NULL,'1888ea74-3dd8-4782-b3bf-cbe2291b3c52'),(248,53,1,'2017-02-15 12:41:58','2017-02-15 15:09:58',NULL,1,2,'2017-05-02 15:41:58',2,'2017-05-02 15:41:59',0,NULL,NULL,NULL,'3f17dfb6-3622-4ba0-91db-c42d887fc8d8'),(249,53,1,'2015-12-24 12:41:59','2015-12-25 14:14:59',NULL,1,2,'2017-05-02 15:41:59',2,'2017-05-02 15:42:00',0,NULL,NULL,NULL,'b1b76bce-095e-46fb-9625-3be9d47b5ea5'),(250,54,1,'2017-04-18 12:42:00','2017-04-18 14:50:00',NULL,1,2,'2017-05-02 15:42:00',2,'2017-05-02 15:42:01',0,NULL,NULL,NULL,'0b34eed4-d892-406a-9a0f-f002921a9cb9'),(251,54,1,'2016-04-10 12:42:01','2016-04-10 14:17:01',NULL,1,2,'2017-05-02 15:42:01',2,'2017-05-02 15:42:02',0,NULL,NULL,NULL,'f0b80591-26c4-4c22-94bb-f64aa0d01fa2'),(252,54,1,'2015-05-13 12:42:02','2015-05-13 14:39:02',NULL,1,2,'2017-05-02 15:42:03',2,'2017-05-02 15:42:04',0,NULL,NULL,NULL,'de9d8dec-d942-4c87-869a-c2b726423518'),(253,54,1,'2015-09-04 12:42:04','2015-09-04 14:22:04',NULL,1,2,'2017-05-02 15:42:04',2,'2017-05-02 15:42:05',0,NULL,NULL,NULL,'1c928e56-5cae-4549-8acc-9b81e41daf53'),(254,54,1,'2017-04-30 12:42:05','2017-04-30 15:07:05',NULL,1,2,'2017-05-02 15:42:05',2,'2017-05-02 15:42:06',0,NULL,NULL,NULL,'32516b63-9a12-4332-9dae-e581e7c30a28'),(255,54,1,'2016-06-27 12:42:06','2016-06-27 15:08:06',NULL,1,2,'2017-05-02 15:42:06',2,'2017-05-02 15:42:06',0,NULL,NULL,NULL,'0a824c9b-f366-40fe-b9f5-b53f82a5c85a'),(256,54,1,'2015-06-16 12:42:06','2015-06-17 14:39:06',NULL,1,2,'2017-05-02 15:42:07',2,'2017-05-02 15:42:07',0,NULL,NULL,NULL,'8c95ad30-bf6c-48aa-9eb0-6eb9b02b3ed2'),(257,56,1,'2015-07-26 12:42:08','2015-07-26 15:11:08',NULL,1,2,'2017-05-02 15:42:08',2,'2017-05-02 15:42:08',0,NULL,NULL,NULL,'27bd4433-3de7-4b5d-95a1-e4952cdc8deb'),(258,56,1,'2016-12-26 12:42:08','2016-12-26 14:31:08',NULL,1,2,'2017-05-02 15:42:09',2,'2017-05-02 15:42:09',0,NULL,NULL,NULL,'30464127-8ce0-4728-8234-6ee9aa456500'),(259,56,1,'2015-11-28 12:42:09','2015-11-28 14:27:09',NULL,1,2,'2017-05-02 15:42:09',2,'2017-05-02 15:42:10',0,NULL,NULL,NULL,'d8fe4dfc-ee31-480f-9bb3-2ecab15bd18f'),(260,56,1,'2015-07-24 12:42:10','2015-07-24 14:27:10',NULL,1,2,'2017-05-02 15:42:10',2,'2017-05-02 15:42:11',0,NULL,NULL,NULL,'8ac7ecb5-cb00-46f2-9eae-adb17b33722a'),(261,56,1,'2016-02-25 12:42:11','2016-02-25 14:13:11',NULL,1,2,'2017-05-02 15:42:11',2,'2017-05-02 15:42:11',0,NULL,NULL,NULL,'20c94094-cfa4-4e49-8e2a-ddf17ecac1c9'),(262,56,1,'2016-09-07 12:42:11','2016-09-09 14:25:11',NULL,1,2,'2017-05-02 15:42:12',2,'2017-05-02 15:42:12',0,NULL,NULL,NULL,'4478e76a-5863-48a9-89d1-5cd44614d225'),(263,57,1,'2015-09-10 12:42:12','2015-09-10 15:06:12',NULL,1,2,'2017-05-02 15:42:13',2,'2017-05-02 15:42:13',0,NULL,NULL,NULL,'4307c16a-9c8c-4249-b73d-6b437751b779'),(264,57,1,'2015-10-15 12:42:13','2015-10-15 14:55:13',NULL,1,2,'2017-05-02 15:42:13',2,'2017-05-02 15:42:14',0,NULL,NULL,NULL,'dc6406ca-2efe-4b48-b249-78802835e4d5'),(265,57,1,'2016-11-21 12:42:14','2016-11-21 14:38:14',NULL,1,2,'2017-05-02 15:42:14',2,'2017-05-02 15:42:14',0,NULL,NULL,NULL,'718b4dd2-b7e2-4269-8d74-3f178c022c50'),(266,57,1,'2016-10-26 12:42:15','2016-10-26 14:51:15',NULL,1,2,'2017-05-02 15:42:15',2,'2017-05-02 15:42:15',0,NULL,NULL,NULL,'24ee8c1b-9e4b-44bb-b912-32bc214d9387'),(267,57,1,'2017-01-18 12:42:15','2017-01-18 14:33:15',NULL,1,2,'2017-05-02 15:42:16',2,'2017-05-02 15:42:16',0,NULL,NULL,NULL,'21582e61-55e9-4e99-a44e-b54a4be1d83f'),(268,57,1,'2017-02-22 12:42:16','2017-02-22 14:45:16',NULL,1,2,'2017-05-02 15:42:17',2,'2017-05-02 15:42:17',0,NULL,NULL,NULL,'48261ac9-03c5-441c-9be9-b70c03f6ee1e'),(269,57,1,'2016-07-15 12:42:17','2016-07-17 14:29:17',NULL,1,2,'2017-05-02 15:42:18',2,'2017-05-02 15:42:18',0,NULL,NULL,NULL,'745dfa16-5936-4866-84b0-977d7d520676'),(270,57,1,'2015-05-12 12:42:18','2015-05-14 14:38:18',NULL,1,2,'2017-05-02 15:42:18',2,'2017-05-02 15:42:19',0,NULL,NULL,NULL,'667225b9-64a4-499a-a925-cf4778eb0ca8'),(271,58,1,'2017-04-21 12:42:19','2017-04-21 14:31:19',NULL,1,2,'2017-05-02 15:42:19',2,'2017-05-02 15:42:20',0,NULL,NULL,NULL,'13cbac22-f1ec-47a5-8ed6-efe344f88569'),(272,58,1,'2015-06-12 12:42:20','2015-06-12 15:07:20',NULL,1,2,'2017-05-02 15:42:20',2,'2017-05-02 15:42:21',0,NULL,NULL,NULL,'e34056d1-c29c-4e39-ac29-a92ab330130f'),(273,58,1,'2016-07-26 12:42:21','2016-07-26 14:36:21',NULL,1,2,'2017-05-02 15:42:21',2,'2017-05-02 15:42:22',0,NULL,NULL,NULL,'afd3b92c-a9df-4ff2-8da5-a4af8c73a8f5'),(274,58,1,'2016-08-06 12:42:22','2016-08-06 14:15:22',NULL,1,2,'2017-05-02 15:42:22',2,'2017-05-02 15:42:23',0,NULL,NULL,NULL,'d097bcfb-5c90-492e-aab4-d7216ce57f41'),(275,58,1,'2016-02-11 12:42:23','2016-02-11 14:28:23',NULL,1,2,'2017-05-02 15:42:23',2,'2017-05-02 15:42:23',0,NULL,NULL,NULL,'a140c3dc-1b7f-4385-8af1-a915398f224c'),(276,58,1,'2016-11-19 12:42:23','2016-11-19 15:11:23',NULL,1,2,'2017-05-02 15:42:24',2,'2017-05-02 15:42:24',0,NULL,NULL,NULL,'272ded44-2344-43d2-b8e7-4ee3f145080c'),(277,58,1,'2017-04-26 12:42:24','2017-04-27 13:50:24',NULL,1,2,'2017-05-02 15:42:24',2,'2017-05-02 15:42:25',0,NULL,NULL,NULL,'61d75bc6-c9be-4cfb-a7f9-b0186ca1598c'),(278,59,1,'2015-12-15 12:42:25','2015-12-15 14:58:25',NULL,1,2,'2017-05-02 15:42:25',2,'2017-05-02 15:42:26',0,NULL,NULL,NULL,'54effd1a-dba1-42e1-9a51-ac310a38c5f4'),(279,59,1,'2017-02-18 12:42:26','2017-02-18 14:40:26',NULL,1,2,'2017-05-02 15:42:26',2,'2017-05-02 15:42:26',0,NULL,NULL,NULL,'53fd7758-06cd-415f-b119-157aa06b26f2'),(280,59,1,'2015-10-05 12:42:26','2015-10-05 14:41:26',NULL,1,2,'2017-05-02 15:42:27',2,'2017-05-02 15:42:27',0,NULL,NULL,NULL,'0ff05187-9c49-41a7-bb99-14db40b92aac'),(281,59,1,'2016-10-31 12:42:27','2016-10-31 14:53:27',NULL,1,2,'2017-05-02 15:42:27',2,'2017-05-02 15:42:28',0,NULL,NULL,NULL,'9d32d876-9cc1-4fa8-a4d6-7aeaf53c25dc'),(282,59,1,'2015-11-28 12:42:28','2015-11-28 14:50:28',NULL,1,2,'2017-05-02 15:42:28',2,'2017-05-02 15:42:28',0,NULL,NULL,NULL,'b9d9bc77-0f82-40f8-9c02-0ce1efe33763'),(283,59,1,'2015-09-24 12:42:28','2015-09-24 14:12:28',NULL,1,2,'2017-05-02 15:42:28',2,'2017-05-02 15:42:29',0,NULL,NULL,NULL,'8bf38efb-2366-4733-ab7c-fbcdcd7f3824'),(284,59,1,'2015-12-17 12:42:29','2015-12-20 13:45:29',NULL,1,2,'2017-05-02 15:42:29',2,'2017-05-02 15:42:30',0,NULL,NULL,NULL,'16db93a0-2e9a-49cb-8749-cc0c8b11e53f'),(285,59,1,'2016-02-17 12:42:30','2016-02-18 14:33:30',NULL,1,2,'2017-05-02 15:42:30',2,'2017-05-02 15:42:31',0,NULL,NULL,NULL,'b360039e-f088-4b6c-b5a2-56f6d44cc4b8'),(286,60,1,'2017-02-10 12:42:31','2017-02-10 15:11:31',NULL,1,2,'2017-05-02 15:42:31',2,'2017-05-02 15:42:31',0,NULL,NULL,NULL,'38773afc-d1c4-4d92-afb0-f4234f923eea'),(287,60,1,'2016-03-19 12:42:31','2016-03-19 14:23:31',NULL,1,2,'2017-05-02 15:42:32',2,'2017-05-02 15:42:32',0,NULL,NULL,NULL,'1509ea13-e217-4c4e-a701-2b1d3d036cd3'),(288,60,1,'2017-01-16 12:42:32','2017-01-16 14:37:32',NULL,1,2,'2017-05-02 15:42:32',2,'2017-05-02 15:42:33',0,NULL,NULL,NULL,'12829dbc-98bc-45ed-b35d-f873e290f71d'),(289,60,1,'2015-05-06 12:42:33','2015-05-06 14:43:33',NULL,1,2,'2017-05-02 15:42:33',2,'2017-05-02 15:42:34',0,NULL,NULL,NULL,'732988cb-c8eb-4017-82f0-1ceee3b2df82'),(290,60,1,'2016-10-05 12:42:34','2016-10-05 14:58:34',NULL,1,2,'2017-05-02 15:42:34',2,'2017-05-02 15:42:35',0,NULL,NULL,NULL,'df74801b-4466-4202-abbd-33d07e93f28b'),(291,60,1,'2016-04-09 12:42:35','2016-04-09 14:55:35',NULL,1,2,'2017-05-02 15:42:35',2,'2017-05-02 15:42:35',0,NULL,NULL,NULL,'7702a85c-9f9c-49e7-a9b1-43cc75a2f4e2'),(292,60,1,'2015-11-02 12:42:35','2015-11-03 14:33:35',NULL,1,2,'2017-05-02 15:42:36',2,'2017-05-02 15:42:36',0,NULL,NULL,NULL,'d5a6e578-8daa-4c36-a482-d3eef0150473'),(293,61,1,'2016-02-12 12:42:36','2016-02-12 14:16:36',NULL,1,2,'2017-05-02 15:42:37',2,'2017-05-02 15:42:37',0,NULL,NULL,NULL,'e9928c2d-c163-4eb0-b3a2-1d72fd845695'),(294,61,1,'2016-05-27 12:42:37','2016-05-27 14:42:37',NULL,1,2,'2017-05-02 15:42:37',2,'2017-05-02 15:42:38',0,NULL,NULL,NULL,'3cdec335-3a8a-46f4-b3b7-c94c4d17316f'),(295,61,1,'2016-09-15 12:42:38','2016-09-15 14:27:38',NULL,1,2,'2017-05-02 15:42:38',2,'2017-05-02 15:42:39',0,NULL,NULL,NULL,'bc29831b-3d84-4098-a6ce-58260f750030'),(296,61,1,'2016-04-30 12:42:39','2016-04-30 14:48:39',NULL,1,2,'2017-05-02 15:42:39',2,'2017-05-02 15:42:39',0,NULL,NULL,NULL,'4834d407-752e-4dd7-ac1b-d26b163e4413'),(297,61,1,'2015-12-19 12:42:39','2015-12-19 14:57:39',NULL,1,2,'2017-05-02 15:42:40',2,'2017-05-02 15:42:40',0,NULL,NULL,NULL,'620dbda0-1742-4f8a-96d6-53ed59063c48'),(298,61,1,'2015-11-12 12:42:40','2015-11-14 14:20:40',NULL,1,2,'2017-05-02 15:42:41',2,'2017-05-02 15:42:41',0,NULL,NULL,NULL,'b93310e5-d536-47b5-bf76-3b32daba2b23'),(299,63,1,'2016-09-15 12:42:42','2016-09-15 14:32:42',NULL,1,2,'2017-05-02 15:42:42',2,'2017-05-02 15:42:42',0,NULL,NULL,NULL,'25f93e47-7d4c-4462-b0b7-a962b9c137e5'),(300,63,1,'2015-05-11 12:42:42','2015-05-11 14:29:42',NULL,1,2,'2017-05-02 15:42:42',2,'2017-05-02 15:42:43',0,NULL,NULL,NULL,'4da26648-7792-443c-9f9e-b97c75ab4ef5'),(301,63,1,'2016-12-01 12:42:43','2016-12-01 15:10:43',NULL,1,2,'2017-05-02 15:42:43',2,'2017-05-02 15:42:43',0,NULL,NULL,NULL,'91893cb4-aa8d-46f1-8f5e-659a5de7a1bf'),(302,63,1,'2016-01-11 12:42:44','2016-01-13 14:38:44',NULL,1,2,'2017-05-02 15:42:44',2,'2017-05-02 15:42:44',0,NULL,NULL,NULL,'ad70ead2-1697-443b-9bb4-1f0932cc96bc'),(303,64,1,'2016-07-12 12:42:44','2016-07-12 14:23:44',NULL,1,2,'2017-05-02 15:42:45',2,'2017-05-02 15:42:45',0,NULL,NULL,NULL,'cbc42eb7-6456-4a36-8e32-0b0377c79943'),(304,64,1,'2015-05-12 12:42:45','2015-05-12 15:02:45',NULL,1,2,'2017-05-02 15:42:45',2,'2017-05-02 15:42:46',0,NULL,NULL,NULL,'050a7679-fc89-427d-896e-64053930581f'),(305,64,1,'2015-11-12 12:42:46','2015-11-12 14:36:46',NULL,1,2,'2017-05-02 15:42:46',2,'2017-05-02 15:42:46',0,NULL,NULL,NULL,'13b12fbd-d0c3-4356-af15-b77f38fd1832'),(306,64,1,'2016-01-18 12:42:46','2016-01-18 15:00:46',NULL,1,2,'2017-05-02 15:42:46',2,'2017-05-02 15:42:47',0,NULL,NULL,NULL,'ca4179b3-a61a-471d-901e-6c008ae072fd'),(307,64,1,'2015-07-05 12:42:47','2015-07-05 14:20:47',NULL,1,2,'2017-05-02 15:42:47',2,'2017-05-02 15:42:48',0,NULL,NULL,NULL,'2c70b285-1f46-4eb9-852a-ca6746c3375c'),(308,64,1,'2016-01-15 12:42:48','2016-01-15 14:15:48',NULL,1,2,'2017-05-02 15:42:48',2,'2017-05-02 15:42:49',0,NULL,NULL,NULL,'2dcec0d5-7211-4ae7-9e01-f2aa9f749323'),(309,64,1,'2015-12-21 12:42:49','2015-12-22 13:47:49',NULL,1,2,'2017-05-02 15:42:49',2,'2017-05-02 15:42:50',0,NULL,NULL,NULL,'e930cbdb-b41e-4a01-854e-61de6767c578'),(310,64,1,'2015-05-02 12:42:50','2015-05-05 13:52:50',NULL,1,2,'2017-05-02 15:42:50',2,'2017-05-02 15:42:50',0,NULL,NULL,NULL,'f2bde17e-1554-4299-a0b9-4a8057a617aa'),(311,66,1,'2016-11-19 12:42:51','2016-11-19 14:51:51',NULL,1,2,'2017-05-02 15:42:51',2,'2017-05-02 15:42:51',0,NULL,NULL,NULL,'332ad8e3-1bc5-4932-9be6-787343190451'),(312,66,1,'2016-04-27 12:42:51','2016-04-27 15:02:51',NULL,1,2,'2017-05-02 15:42:51',2,'2017-05-02 15:42:52',0,NULL,NULL,NULL,'6ce20d20-da75-49ba-b2c4-2e2fab2b1c73'),(313,66,1,'2017-03-14 12:42:52','2017-03-14 15:11:52',NULL,1,2,'2017-05-02 15:42:52',2,'2017-05-02 15:42:52',0,NULL,NULL,NULL,'188d32b2-4924-4e9b-88d7-cd66612943c9'),(314,67,1,'2016-09-05 12:42:53','2016-09-05 14:27:53',NULL,1,2,'2017-05-02 15:42:53',2,'2017-05-02 15:42:53',0,NULL,NULL,NULL,'57d2aac1-be19-480f-9624-aa8776f2d465'),(315,67,1,'2015-11-12 12:42:53','2015-11-12 14:48:53',NULL,1,2,'2017-05-02 15:42:54',2,'2017-05-02 15:42:54',0,NULL,NULL,NULL,'d21cb899-03fc-4ca6-aa95-44f16c7dfca5'),(316,67,1,'2015-06-12 12:42:54','2015-06-12 14:29:54',NULL,1,2,'2017-05-02 15:42:54',2,'2017-05-02 15:42:55',0,NULL,NULL,NULL,'108f780c-c00b-432b-99d0-872e3b5b53db'),(317,67,1,'2015-10-05 12:42:55','2015-10-07 14:33:55',NULL,1,2,'2017-05-02 15:42:56',2,'2017-05-02 15:42:56',0,NULL,NULL,NULL,'ae90b56f-6e23-4fae-b2a9-ac2bbce2ff29'),(318,69,1,'2016-07-10 12:42:56','2016-07-10 14:30:56',NULL,1,2,'2017-05-02 15:42:56',2,'2017-05-02 15:42:57',0,NULL,NULL,NULL,'43f542c3-eda5-401f-ad8f-532e836f96a4'),(319,69,1,'2015-11-14 12:42:57','2015-11-14 14:55:57',NULL,1,2,'2017-05-02 15:42:57',2,'2017-05-02 15:42:58',0,NULL,NULL,NULL,'4111e4ea-0be8-4b0a-82b3-5d69b20d37f7'),(320,69,1,'2015-08-25 12:42:58','2015-08-25 14:35:58',NULL,1,2,'2017-05-02 15:42:58',2,'2017-05-02 15:42:58',0,NULL,NULL,NULL,'6a5ea6cb-3624-40ed-b0a9-3b366b3541af'),(321,69,1,'2016-04-09 12:42:58','2016-04-09 15:01:58',NULL,1,2,'2017-05-02 15:42:58',2,'2017-05-02 15:42:59',0,NULL,NULL,NULL,'b54fe787-8e14-4975-8777-75a8ada052c3'),(322,69,1,'2016-10-25 12:42:59','2016-10-25 14:16:59',NULL,1,2,'2017-05-02 15:42:59',2,'2017-05-02 15:42:59',0,NULL,NULL,NULL,'34c607fa-5c69-4d2d-8eb8-449b2f76fa08'),(323,69,1,'2016-02-11 12:42:59','2016-02-11 14:48:59',NULL,1,2,'2017-05-02 15:42:59',2,'2017-05-02 15:43:00',0,NULL,NULL,NULL,'d82eb8c3-fe35-462b-ae6a-bbf2a97d0246'),(324,69,1,'2016-12-19 12:43:00','2016-12-19 14:21:00',NULL,1,2,'2017-05-02 15:43:00',2,'2017-05-02 15:43:01',0,NULL,NULL,NULL,'a138dbe3-f3ef-4860-9d63-d7c85f3a00eb'),(325,69,1,'2016-02-06 12:43:01','2016-02-06 14:13:01',NULL,1,2,'2017-05-02 15:43:01',2,'2017-05-02 15:43:01',0,NULL,NULL,NULL,'052a3867-0e57-4409-b910-6aaf07b9ef4e'),(326,69,1,'2015-09-04 12:43:01','2015-09-06 14:17:01',NULL,1,2,'2017-05-02 15:43:02',2,'2017-05-02 15:43:02',0,NULL,NULL,NULL,'e8eb6573-878a-46c6-948a-2aa8e3def738'),(327,69,1,'2017-01-14 12:43:02','2017-01-16 13:48:02',NULL,1,2,'2017-05-02 15:43:02',2,'2017-05-02 15:43:03',0,NULL,NULL,NULL,'cecaa875-ed2a-45c1-b9c7-244707267e3a'),(328,70,1,'2017-02-04 12:43:03','2017-02-04 14:29:03',NULL,1,2,'2017-05-02 15:43:03',2,'2017-05-02 15:43:03',0,NULL,NULL,NULL,'1d3b6c61-6c17-4f90-adb3-fd5151d1d900'),(329,70,1,'2017-04-23 12:43:03','2017-04-23 14:24:03',NULL,1,2,'2017-05-02 15:43:04',2,'2017-05-02 15:43:04',0,NULL,NULL,NULL,'591a40e1-d59d-46d9-8bc8-c3e4c492f3dd'),(330,70,1,'2016-01-23 12:43:04','2016-01-23 15:12:04',NULL,1,2,'2017-05-02 15:43:04',2,'2017-05-02 15:43:05',0,NULL,NULL,NULL,'c7dcc0e3-9110-4809-a1f0-564997254e00'),(331,70,1,'2015-06-20 12:43:05','2015-06-22 14:04:05',NULL,1,2,'2017-05-02 15:43:05',2,'2017-05-02 15:43:06',0,NULL,NULL,NULL,'84c9a14d-3ddd-486e-90d8-16f613834071'),(332,71,1,'2015-06-06 12:43:06','2015-06-06 15:13:06',NULL,1,2,'2017-05-02 15:43:06',2,'2017-05-02 15:43:07',0,NULL,NULL,NULL,'a855ad5d-e072-4693-93ea-6ebd4024bf2c'),(333,71,1,'2015-06-14 12:43:07','2015-06-14 15:06:07',NULL,1,2,'2017-05-02 15:43:07',2,'2017-05-02 15:43:07',0,NULL,NULL,NULL,'b3ced551-16c3-4201-9fb4-99abb16277f6'),(334,71,1,'2016-05-16 12:43:07','2016-05-16 14:34:07',NULL,1,2,'2017-05-02 15:43:08',2,'2017-05-02 15:43:08',0,NULL,NULL,NULL,'8b76b447-80a4-4e47-b876-0a1031c7c67d'),(335,71,1,'2016-07-08 12:43:08','2016-07-08 14:52:08',NULL,1,2,'2017-05-02 15:43:08',2,'2017-05-02 15:43:08',0,NULL,NULL,NULL,'cc69e45f-ba79-4dd5-ae8b-d4005b20ab33'),(336,71,1,'2015-07-25 12:43:08','2015-07-25 14:47:08',NULL,1,2,'2017-05-02 15:43:09',2,'2017-05-02 15:43:09',0,NULL,NULL,NULL,'fa385ff3-db78-4f91-85eb-9a57991a08fc'),(337,71,1,'2017-03-22 12:43:09','2017-03-22 15:03:09',NULL,1,2,'2017-05-02 15:43:09',2,'2017-05-02 15:43:10',0,NULL,NULL,NULL,'c0a23887-a5df-4429-9634-35b8ee96a27c'),(338,71,1,'2017-01-29 12:43:10','2017-01-29 14:41:10',NULL,1,2,'2017-05-02 15:43:10',2,'2017-05-02 15:43:10',0,NULL,NULL,NULL,'909556c3-3b0a-4744-87ff-bb29f5754697'),(339,71,1,'2017-03-14 12:43:10','2017-03-16 14:21:10',NULL,1,2,'2017-05-02 15:43:10',2,'2017-05-02 15:43:11',0,NULL,NULL,NULL,'8244691a-9338-4443-833b-e959da53c751'),(340,71,1,'2015-11-24 12:43:11','2015-11-27 13:51:11',NULL,1,2,'2017-05-02 15:43:11',2,'2017-05-02 15:43:12',0,NULL,NULL,NULL,'ce72e8c9-9792-45ed-a538-8b9fe006f341'),(341,72,1,'2017-01-08 12:43:12','2017-01-08 14:14:12',NULL,1,2,'2017-05-02 15:43:12',2,'2017-05-02 15:43:12',0,NULL,NULL,NULL,'08714e71-e474-443e-8410-6830c41c7074'),(342,72,1,'2016-10-24 12:43:12','2016-10-24 14:24:12',NULL,1,2,'2017-05-02 15:43:13',2,'2017-05-02 15:43:13',0,NULL,NULL,NULL,'717e7829-dd30-4a66-84d3-c8ca5ac25526'),(343,72,1,'2015-09-07 12:43:13','2015-09-07 14:20:13',NULL,1,2,'2017-05-02 15:43:13',2,'2017-05-02 15:43:14',0,NULL,NULL,NULL,'7187d0ee-fd0a-4ce4-9350-4f349155ffcf'),(344,73,1,'2015-06-30 12:43:14','2015-06-30 15:03:14',NULL,1,2,'2017-05-02 15:43:14',2,'2017-05-02 15:43:15',0,NULL,NULL,NULL,'026e2df9-a61e-4655-96e8-2a84d49ed6cf'),(345,73,1,'2015-07-22 12:43:15','2015-07-22 14:32:15',NULL,1,2,'2017-05-02 15:43:15',2,'2017-05-02 15:43:15',0,NULL,NULL,NULL,'175a3657-eedf-459a-9809-f4c83b6098c6'),(346,73,1,'2017-01-14 12:43:16','2017-01-14 14:58:16',NULL,1,2,'2017-05-02 15:43:16',2,'2017-05-02 15:43:16',0,NULL,NULL,NULL,'e2b9dc94-9077-4e6b-bd94-a2049bec95e4'),(347,73,1,'2016-06-11 12:43:16','2016-06-12 14:23:16',NULL,1,2,'2017-05-02 15:43:17',2,'2017-05-02 15:43:17',0,NULL,NULL,NULL,'faa91106-b67c-48a6-b59a-049f70cb8cb6'),(348,74,1,'2015-07-03 12:43:17','2015-07-03 14:20:17',NULL,1,2,'2017-05-02 15:43:17',2,'2017-05-02 15:43:18',0,NULL,NULL,NULL,'c01e0d3f-3047-45de-8c9f-1d815b59f25b'),(349,74,1,'2017-01-16 12:43:18','2017-01-16 14:47:18',NULL,1,2,'2017-05-02 15:43:18',2,'2017-05-02 15:43:19',0,NULL,NULL,NULL,'f726c300-eca8-4c4c-8e43-b9c3792989d3'),(350,74,1,'2017-04-11 12:43:19','2017-04-11 14:46:19',NULL,1,2,'2017-05-02 15:43:19',2,'2017-05-02 15:43:19',0,NULL,NULL,NULL,'2e950555-27e0-4a63-9b47-b62e8957675e'),(351,74,1,'2015-10-18 12:43:19','2015-10-18 14:52:19',NULL,1,2,'2017-05-02 15:43:19',2,'2017-05-02 15:43:20',0,NULL,NULL,NULL,'620b2c27-8aaa-4a3c-96bf-0644a050d863'),(352,74,1,'2016-01-18 12:43:20','2016-01-18 14:40:20',NULL,1,2,'2017-05-02 15:43:20',2,'2017-05-02 15:43:21',0,NULL,NULL,NULL,'56f7e1bd-9d6b-4454-91b3-84e39ba5dee2'),(353,74,1,'2015-07-31 12:43:21','2015-07-31 14:57:21',NULL,1,2,'2017-05-02 15:43:21',2,'2017-05-02 15:43:21',0,NULL,NULL,NULL,'a1394139-6e18-4d5a-8517-933f591ce317'),(354,74,1,'2016-06-23 12:43:21','2016-06-24 13:52:21',NULL,1,2,'2017-05-02 15:43:22',2,'2017-05-02 15:43:22',0,NULL,NULL,NULL,'6f79f8b2-49d5-4790-b5c3-dbebf8ab2214'),(355,74,1,'2017-02-18 12:43:22','2017-02-19 13:44:22',NULL,1,2,'2017-05-02 15:43:23',2,'2017-05-02 15:43:23',0,NULL,NULL,NULL,'8bbf9072-5579-45de-903c-ae10768160a6'),(356,75,1,'2016-04-06 12:43:23','2016-04-06 14:46:23',NULL,1,2,'2017-05-02 15:43:24',2,'2017-05-02 15:43:24',0,NULL,NULL,NULL,'945338f9-3355-4d4f-8569-70b7ce904fe1'),(357,75,1,'2015-07-24 12:43:24','2015-07-24 14:51:24',NULL,1,2,'2017-05-02 15:43:24',2,'2017-05-02 15:43:25',0,NULL,NULL,NULL,'5bcb602c-f026-4ed4-b48d-9d94c1ae8a93'),(358,75,1,'2017-03-21 12:43:25','2017-03-21 15:02:25',NULL,1,2,'2017-05-02 15:43:25',2,'2017-05-02 15:43:26',0,NULL,NULL,NULL,'cc6c1793-9a67-4039-bcab-8066144242e3'),(359,75,1,'2016-07-18 12:43:26','2016-07-18 15:05:26',NULL,1,2,'2017-05-02 15:43:26',2,'2017-05-02 15:43:26',0,NULL,NULL,NULL,'e7b9234b-91d1-4220-b496-882aff0c6244'),(360,75,1,'2016-10-01 12:43:26','2016-10-01 14:21:26',NULL,1,2,'2017-05-02 15:43:27',2,'2017-05-02 15:43:27',0,NULL,NULL,NULL,'8cc08308-566b-40ae-8ed7-f07f9e196132'),(361,75,1,'2016-01-24 12:43:27','2016-01-25 14:13:27',NULL,1,2,'2017-05-02 15:43:28',2,'2017-05-02 15:43:28',0,NULL,NULL,NULL,'432a6dad-d40e-4c33-a27f-903510fb9b42'),(362,76,1,'2016-11-27 12:43:28','2016-11-27 14:25:28',NULL,1,2,'2017-05-02 15:43:29',2,'2017-05-02 15:43:29',0,NULL,NULL,NULL,'2823e4b0-c16c-4358-8cd7-2e8d31a31aab'),(363,76,1,'2015-05-27 12:43:29','2015-05-27 14:30:29',NULL,1,2,'2017-05-02 15:43:29',2,'2017-05-02 15:43:30',0,NULL,NULL,NULL,'87f9392b-ac14-486c-96ab-f3cdb62efe53'),(364,76,1,'2016-11-27 12:43:30','2016-11-27 15:07:30',NULL,1,2,'2017-05-02 15:43:30',2,'2017-05-02 15:43:30',0,NULL,NULL,NULL,'ec224fd3-23ee-494e-9e14-0cada918aec5'),(365,76,1,'2017-03-06 12:43:30','2017-03-06 14:24:30',NULL,1,2,'2017-05-02 15:43:31',2,'2017-05-02 15:43:31',0,NULL,NULL,NULL,'9df8d2ab-f982-4f51-95ae-cf043295f944'),(366,76,1,'2017-03-28 12:43:31','2017-03-28 14:47:31',NULL,1,2,'2017-05-02 15:43:31',2,'2017-05-02 15:43:32',0,NULL,NULL,NULL,'69a0e08c-32ef-401d-a737-09ae36619880'),(367,76,1,'2017-03-03 12:43:32','2017-03-03 14:16:32',NULL,1,2,'2017-05-02 15:43:32',2,'2017-05-02 15:43:32',0,NULL,NULL,NULL,'ab6dbc70-6b30-4cf0-9cf6-a3ea1280bce8'),(368,76,1,'2016-01-18 12:43:32','2016-01-21 14:40:32',NULL,1,2,'2017-05-02 15:43:32',2,'2017-05-02 15:43:33',0,NULL,NULL,NULL,'32207d61-6c07-4354-a0ab-15356082f83a'),(369,77,1,'2015-12-23 12:43:33','2015-12-23 14:27:33',NULL,1,2,'2017-05-02 15:43:33',2,'2017-05-02 15:43:34',0,NULL,NULL,NULL,'09b25613-b526-4057-b01a-cad724e7b40b'),(370,77,1,'2016-11-20 12:43:34','2016-11-20 14:40:34',NULL,1,2,'2017-05-02 15:43:34',2,'2017-05-02 15:43:34',0,NULL,NULL,NULL,'d1f8cdf3-bf7f-4958-816d-bfb5e56e09c9'),(371,77,1,'2016-10-14 12:43:34','2016-10-14 14:17:34',NULL,1,2,'2017-05-02 15:43:35',2,'2017-05-02 15:43:35',0,NULL,NULL,NULL,'d3f31f11-7135-44ba-a7ec-10837a5dae6d'),(372,77,1,'2015-07-10 12:43:35','2015-07-10 14:33:35',NULL,1,2,'2017-05-02 15:43:35',2,'2017-05-02 15:43:36',0,NULL,NULL,NULL,'55c5381d-97d3-4999-9d55-cdccede8c0ea'),(373,77,1,'2015-07-09 12:43:36','2015-07-09 14:55:36',NULL,1,2,'2017-05-02 15:43:36',2,'2017-05-02 15:43:36',0,NULL,NULL,NULL,'4172f138-3dfb-4a1c-b185-6ff459478bdb'),(374,77,1,'2016-09-09 12:43:36','2016-09-10 14:07:36',NULL,1,2,'2017-05-02 15:43:37',2,'2017-05-02 15:43:37',0,NULL,NULL,NULL,'677e947e-9dd6-478c-8d47-3f36dacfc6fa'),(375,78,1,'2016-06-17 12:43:37','2016-06-17 14:32:37',NULL,1,2,'2017-05-02 15:43:38',2,'2017-05-02 15:43:38',0,NULL,NULL,NULL,'6cdb3f11-40d5-4b8f-a68b-48c0e10a5b36'),(376,78,1,'2016-01-20 12:43:38','2016-01-20 14:57:38',NULL,1,2,'2017-05-02 15:43:38',2,'2017-05-02 15:43:39',0,NULL,NULL,NULL,'308266e6-1630-4b77-bf83-c5fac0b053c0'),(377,78,1,'2016-05-30 12:43:39','2016-05-30 14:22:39',NULL,1,2,'2017-05-02 15:43:39',2,'2017-05-02 15:43:40',0,NULL,NULL,NULL,'01829056-65db-4c56-b0fb-5f6c143722c4'),(378,78,1,'2016-09-27 12:43:40','2016-09-27 14:52:40',NULL,1,2,'2017-05-02 15:43:40',2,'2017-05-02 15:43:40',0,NULL,NULL,NULL,'84a197a7-3834-4101-936d-f37b6209844d'),(379,78,1,'2016-02-05 12:43:40','2016-02-05 15:05:40',NULL,1,2,'2017-05-02 15:43:41',2,'2017-05-02 15:43:41',0,NULL,NULL,NULL,'f30f8dd5-7a20-46fd-905e-4298fda7844b'),(380,78,1,'2016-12-22 12:43:41','2016-12-23 14:43:41',NULL,1,2,'2017-05-02 15:43:41',2,'2017-05-02 15:43:42',0,NULL,NULL,NULL,'74089aa7-9b3f-436a-8003-eeb4cdbfbb95'),(381,79,1,'2016-02-21 12:43:42','2016-02-21 14:38:42',NULL,1,2,'2017-05-02 15:43:42',2,'2017-05-02 15:43:43',0,NULL,NULL,NULL,'e128794b-94cf-48da-ab44-7ca9d2a307ff'),(382,80,1,'2016-05-17 12:43:43','2016-05-17 14:46:43',NULL,1,2,'2017-05-02 15:43:43',2,'2017-05-02 15:43:43',0,NULL,NULL,NULL,'4b9160f3-64e1-4765-a8c3-9b1280d5d10e'),(383,80,1,'2015-11-22 12:43:44','2015-11-22 14:23:44',NULL,1,2,'2017-05-02 15:43:44',2,'2017-05-02 15:43:44',0,NULL,NULL,NULL,'72090aa0-444a-450c-abfa-63227acdf2ba'),(384,80,1,'2015-12-04 12:43:44','2015-12-04 14:42:44',NULL,1,2,'2017-05-02 15:43:45',2,'2017-05-02 15:43:45',0,NULL,NULL,NULL,'3755fe10-12f2-48e1-971d-9985c156e7ee'),(385,80,1,'2016-01-16 12:43:45','2016-01-16 14:23:45',NULL,1,2,'2017-05-02 15:43:45',2,'2017-05-02 15:43:45',0,NULL,NULL,NULL,'df8f5dec-5abb-4dec-a5db-5d7278c40ccb'),(386,80,1,'2016-09-03 12:43:45','2016-09-06 14:13:45',NULL,1,2,'2017-05-02 15:43:46',2,'2017-05-02 15:43:46',0,NULL,NULL,NULL,'58d21f7e-746a-4cdb-ad07-032ef354f589'),(387,81,1,'2016-06-20 12:43:46','2016-06-20 14:44:46',NULL,1,2,'2017-05-02 15:43:47',2,'2017-05-02 15:43:47',0,NULL,NULL,NULL,'1a9afc9e-da49-43a7-b906-3293d6f169c7'),(388,81,1,'2015-08-31 12:43:47','2015-08-31 14:59:47',NULL,1,2,'2017-05-02 15:43:47',2,'2017-05-02 15:43:48',0,NULL,NULL,NULL,'35a6f3bd-6aff-4cb7-83ad-b13a54bb777e'),(389,81,1,'2016-05-29 12:43:48','2016-05-29 14:26:48',NULL,1,2,'2017-05-02 15:43:48',2,'2017-05-02 15:43:49',0,NULL,NULL,NULL,'06827fe4-50e8-408f-b30b-b6c67515567c'),(390,81,1,'2016-11-08 12:43:49','2016-11-08 14:41:49',NULL,1,2,'2017-05-02 15:43:49',2,'2017-05-02 15:43:49',0,NULL,NULL,NULL,'df4cb4cf-ecd4-413f-932a-07d892fe1b09'),(391,81,1,'2017-02-15 12:43:49','2017-02-15 15:05:49',NULL,1,2,'2017-05-02 15:43:50',2,'2017-05-02 15:43:50',0,NULL,NULL,NULL,'859d2a52-b50c-4b66-b85f-35257e769a2f'),(392,81,1,'2015-05-27 12:43:50','2015-05-28 13:52:50',NULL,1,2,'2017-05-02 15:43:50',2,'2017-05-02 15:43:51',0,NULL,NULL,NULL,'80cd113d-1257-4fff-9fc0-73148efb94a8'),(393,82,1,'2015-12-31 12:43:51','2015-12-31 14:20:51',NULL,1,2,'2017-05-02 15:43:51',2,'2017-05-02 15:43:52',0,NULL,NULL,NULL,'d9393fac-9246-41b7-90a8-ff4f66e71845'),(394,82,1,'2016-08-30 12:43:52','2016-08-30 15:01:52',NULL,1,2,'2017-05-02 15:43:52',2,'2017-05-02 15:43:52',0,NULL,NULL,NULL,'aa25937e-b5fd-4a82-be19-28141080cf08'),(395,82,1,'2015-07-18 12:43:52','2015-07-18 14:19:52',NULL,1,2,'2017-05-02 15:43:53',2,'2017-05-02 15:43:53',0,NULL,NULL,NULL,'7cd7fe7a-6081-40fe-b8a3-71e332f7e763'),(396,82,1,'2017-03-08 12:43:53','2017-03-08 14:54:53',NULL,1,2,'2017-05-02 15:43:53',2,'2017-05-02 15:43:54',0,NULL,NULL,NULL,'ac67ca50-9ea6-42a9-842d-63fa446509a0'),(397,82,1,'2017-03-03 12:43:54','2017-03-03 14:36:54',NULL,1,2,'2017-05-02 15:43:54',2,'2017-05-02 15:43:55',0,NULL,NULL,NULL,'aceed998-748c-4eac-9a2a-2e3a28cf120a'),(398,82,1,'2016-07-07 12:43:55','2016-07-10 14:43:55',NULL,1,2,'2017-05-02 15:43:55',2,'2017-05-02 15:43:55',0,NULL,NULL,NULL,'4a11a2fe-aefa-4cfd-880e-219f682708c2'),(399,83,1,'2016-09-09 12:43:55','2016-09-09 14:25:55',NULL,1,2,'2017-05-02 15:43:56',2,'2017-05-02 15:43:56',0,NULL,NULL,NULL,'89a27cd8-941e-4e74-ad64-83e7ed70a061'),(400,83,1,'2017-04-01 12:43:56','2017-04-01 14:29:56',NULL,1,2,'2017-05-02 15:43:57',2,'2017-05-02 15:43:57',0,NULL,NULL,NULL,'639b792f-f438-41e4-9edf-e21cc3cc77c5'),(401,83,1,'2016-01-05 12:43:57','2016-01-05 15:01:57',NULL,1,2,'2017-05-02 15:43:57',2,'2017-05-02 15:43:58',0,NULL,NULL,NULL,'2301c2f0-23e9-4f7c-a925-d92f3e6c5466'),(402,83,1,'2016-07-31 12:43:58','2016-07-31 14:13:58',NULL,1,2,'2017-05-02 15:43:58',2,'2017-05-02 15:43:59',0,NULL,NULL,NULL,'312ec158-7759-426e-b288-f0b08afac537'),(403,83,1,'2016-05-20 12:43:59','2016-05-20 15:05:59',NULL,1,2,'2017-05-02 15:43:59',2,'2017-05-02 15:43:59',0,NULL,NULL,NULL,'d919b864-6197-44ef-a697-929a3bb6aaf9'),(404,83,1,'2016-08-31 12:43:59','2016-08-31 14:26:59',NULL,1,2,'2017-05-02 15:44:00',2,'2017-05-02 15:44:00',0,NULL,NULL,NULL,'4802e841-4685-4f7c-acda-d2db16fdef5d'),(405,83,1,'2016-04-13 12:44:00','2016-04-13 14:49:00',NULL,1,2,'2017-05-02 15:44:00',2,'2017-05-02 15:44:01',0,NULL,NULL,NULL,'52172f1b-e7d3-4998-aa9e-e0a3f8862fb5'),(406,83,1,'2016-10-11 12:44:01','2016-10-12 13:53:01',NULL,1,2,'2017-05-02 15:44:01',2,'2017-05-02 15:44:01',0,NULL,NULL,NULL,'48bc23d4-7329-4db6-8dc5-cb8a255ccfb8'),(407,83,1,'2016-06-26 12:44:01','2016-06-27 14:39:01',NULL,1,2,'2017-05-02 15:44:02',2,'2017-05-02 15:44:02',0,NULL,NULL,NULL,'fdd1bfee-1c54-45d9-9255-fcc0933861cf'),(408,84,1,'2015-07-17 12:44:02','2015-07-17 14:17:02',NULL,1,2,'2017-05-02 15:44:03',2,'2017-05-02 15:44:03',0,NULL,NULL,NULL,'4479a3c0-2cb9-4a97-97d9-a33cda70ae0a'),(409,84,1,'2015-10-31 12:44:03','2015-10-31 14:19:03',NULL,1,2,'2017-05-02 15:44:03',2,'2017-05-02 15:44:04',0,NULL,NULL,NULL,'97735ec0-134b-4a45-9487-275ab4a6d947'),(410,84,1,'2016-10-29 12:44:04','2016-10-29 14:48:04',NULL,1,2,'2017-05-02 15:44:04',2,'2017-05-02 15:44:05',0,NULL,NULL,NULL,'1b59249c-5732-4ced-b528-0b9f55595031'),(411,84,1,'2017-01-04 12:44:05','2017-01-04 14:41:05',NULL,1,2,'2017-05-02 15:44:05',2,'2017-05-02 15:44:05',0,NULL,NULL,NULL,'010de55a-a351-4f61-9e89-8d7a94f8072b'),(412,84,1,'2015-05-09 12:44:05','2015-05-11 14:19:05',NULL,1,2,'2017-05-02 15:44:05',2,'2017-05-02 15:44:06',0,NULL,NULL,NULL,'fc52e4fe-d7ab-4aeb-9176-2d4dbc768d38'),(413,85,1,'2016-08-02 12:44:06','2016-08-02 14:42:06',NULL,1,2,'2017-05-02 15:44:06',2,'2017-05-02 15:44:07',0,NULL,NULL,NULL,'2a6794ca-04dc-42b9-9bf8-484e5ff64b24'),(414,85,1,'2015-06-02 12:44:07','2015-06-02 14:43:07',NULL,1,2,'2017-05-02 15:44:07',2,'2017-05-02 15:44:08',0,NULL,NULL,NULL,'ba3618ad-4469-4068-ab3b-4d738bb8e6e2'),(415,85,1,'2015-12-03 12:44:08','2015-12-03 15:09:08',NULL,1,2,'2017-05-02 15:44:08',2,'2017-05-02 15:44:09',0,NULL,NULL,NULL,'e8647c0e-2b40-4c3e-84e5-3e4974fbca9e'),(416,85,1,'2015-09-10 12:44:09','2015-09-10 14:53:09',NULL,1,2,'2017-05-02 15:44:09',2,'2017-05-02 15:44:09',0,NULL,NULL,NULL,'4445a450-d6fc-486d-b576-96c11de74450'),(417,85,1,'2015-07-24 12:44:09','2015-07-24 15:14:09',NULL,1,2,'2017-05-02 15:44:10',2,'2017-05-02 15:44:10',0,NULL,NULL,NULL,'09c70d02-f45c-4399-86cd-e724bab77110'),(418,85,1,'2015-09-10 12:44:10','2015-09-13 14:26:10',NULL,1,2,'2017-05-02 15:44:10',2,'2017-05-02 15:44:11',0,NULL,NULL,NULL,'63d3e2c8-a718-4b04-b196-2ec6e805067a'),(419,86,1,'2015-10-24 12:44:11','2015-10-24 15:07:11',NULL,1,2,'2017-05-02 15:44:11',2,'2017-05-02 15:44:12',0,NULL,NULL,NULL,'a27b776f-f76f-4f7b-99d3-8c6e9223ad9d'),(420,87,1,'2016-04-25 12:44:12','2016-04-25 14:45:12',NULL,1,2,'2017-05-02 15:44:12',2,'2017-05-02 15:44:12',0,NULL,NULL,NULL,'79f67c91-457a-4530-9076-95641699bcfc'),(421,87,1,'2016-06-09 12:44:12','2016-06-09 14:23:12',NULL,1,2,'2017-05-02 15:44:13',2,'2017-05-02 15:44:13',0,NULL,NULL,NULL,'c6eba078-d80b-45fc-be51-1a30663fadc8'),(422,87,1,'2016-05-16 12:44:13','2016-05-16 14:36:13',NULL,1,2,'2017-05-02 15:44:13',2,'2017-05-02 15:44:14',0,NULL,NULL,NULL,'c8e1f056-6f11-4b4e-97b0-36dc1fc63215'),(423,88,1,'2017-03-13 12:44:14','2017-03-13 14:25:14',NULL,1,2,'2017-05-02 15:44:14',2,'2017-05-02 15:44:15',0,NULL,NULL,NULL,'db41be1f-def2-468c-bc9d-2e2ade1e875a'),(424,88,1,'2017-02-05 12:44:15','2017-02-05 14:16:15',NULL,1,2,'2017-05-02 15:44:15',2,'2017-05-02 15:44:16',0,NULL,NULL,NULL,'56d38341-d02e-48a2-b83a-6028f2ece452'),(425,88,1,'2015-11-08 12:44:16','2015-11-08 14:46:16',NULL,1,2,'2017-05-02 15:44:16',2,'2017-05-02 15:44:16',0,NULL,NULL,NULL,'608498e9-1f1d-4272-9bc5-b34d90453cce'),(426,88,1,'2015-11-12 12:44:16','2015-11-12 14:54:16',NULL,1,2,'2017-05-02 15:44:17',2,'2017-05-02 15:44:17',0,NULL,NULL,NULL,'a48111b9-80a6-42a9-85ce-aecfde153a52'),(427,88,1,'2016-10-02 12:44:17','2016-10-02 14:46:17',NULL,1,2,'2017-05-02 15:44:18',2,'2017-05-02 15:44:18',0,NULL,NULL,NULL,'fd5117e7-5493-4b5f-8573-d6eb4bd9f9ba'),(428,88,1,'2017-02-11 12:44:18','2017-02-11 14:45:18',NULL,1,2,'2017-05-02 15:44:18',2,'2017-05-02 15:44:19',0,NULL,NULL,NULL,'c68c6b71-c50c-4c9d-a7c2-0d4cb8479599'),(429,88,1,'2016-12-29 12:44:19','2016-12-29 14:55:19',NULL,1,2,'2017-05-02 15:44:19',2,'2017-05-02 15:44:20',0,NULL,NULL,NULL,'e1c51c16-9383-419f-9676-d69059382d7d'),(430,88,1,'2016-07-17 12:44:20','2016-07-17 14:31:20',NULL,1,2,'2017-05-02 15:44:20',2,'2017-05-02 15:44:20',0,NULL,NULL,NULL,'e80ad6fc-b53e-4b3c-a4e0-84b5f9636ef9'),(431,88,1,'2017-01-20 12:44:20','2017-01-22 13:56:20',NULL,1,2,'2017-05-02 15:44:21',2,'2017-05-02 15:44:21',0,NULL,NULL,NULL,'eebfe147-fb96-4261-ba88-632ad3d69937'),(432,88,1,'2016-01-25 12:44:21','2016-01-28 14:01:21',NULL,1,2,'2017-05-02 15:44:21',2,'2017-05-02 15:44:22',0,NULL,NULL,NULL,'5caccde9-cdcd-4f58-b1c4-b3d8d272331f'),(433,89,1,'2016-12-30 12:44:22','2016-12-30 14:52:22',NULL,1,2,'2017-05-02 15:44:22',2,'2017-05-02 15:44:23',0,NULL,NULL,NULL,'153b4fff-2ac5-46c6-926a-062b0219c030'),(434,89,1,'2016-01-26 12:44:23','2016-01-26 14:28:23',NULL,1,2,'2017-05-02 15:44:23',2,'2017-05-02 15:44:23',0,NULL,NULL,NULL,'1cca0dbf-cfab-4b04-8ff7-93023585e933'),(435,89,1,'2016-03-09 12:44:23','2016-03-09 14:58:23',NULL,1,2,'2017-05-02 15:44:24',2,'2017-05-02 15:44:25',0,NULL,NULL,NULL,'12a95a98-d4e2-4ced-8af2-b4d860b58ab5'),(436,90,1,'2016-09-02 12:44:25','2016-09-02 14:15:25',NULL,1,2,'2017-05-02 15:44:25',2,'2017-05-02 15:44:25',0,NULL,NULL,NULL,'ace9cdf6-7654-4066-8806-854312d9183a'),(437,90,1,'2016-06-15 12:44:25','2016-06-15 14:23:25',NULL,1,2,'2017-05-02 15:44:26',2,'2017-05-02 15:44:26',0,NULL,NULL,NULL,'529e80a4-f474-44d8-9cd9-64ba2c3c816f'),(438,90,1,'2016-05-20 12:44:26','2016-05-20 14:43:26',NULL,1,2,'2017-05-02 15:44:26',2,'2017-05-02 15:44:27',0,NULL,NULL,NULL,'7e71dc9c-f213-41a6-991c-c1eed09db4a8'),(439,90,1,'2015-12-21 12:44:27','2015-12-21 14:50:27',NULL,1,2,'2017-05-02 15:44:27',2,'2017-05-02 15:44:28',0,NULL,NULL,NULL,'934af4f4-d88b-49d2-9102-81783000e07a'),(440,90,1,'2016-01-20 12:44:28','2016-01-20 14:38:28',NULL,1,2,'2017-05-02 15:44:28',2,'2017-05-02 15:44:29',0,NULL,NULL,NULL,'6a12ce24-c899-43f5-81e5-228dc6d07d92'),(441,90,1,'2015-08-09 12:44:29','2015-08-09 15:01:29',NULL,1,2,'2017-05-02 15:44:29',2,'2017-05-02 15:44:29',0,NULL,NULL,NULL,'c11f5af2-1c9a-4b58-a0b7-69baec449842'),(442,90,1,'2015-09-17 12:44:29','2015-09-17 15:14:29',NULL,1,2,'2017-05-02 15:44:30',2,'2017-05-02 15:44:30',0,NULL,NULL,NULL,'58acc2be-1510-4e17-a75b-bfd089c1795c'),(443,90,1,'2016-04-09 12:44:30','2016-04-12 13:55:30',NULL,1,2,'2017-05-02 15:44:30',2,'2017-05-02 15:44:31',0,NULL,NULL,NULL,'df0ff6da-1a39-40e7-b0d0-d4f9b4796347'),(444,90,1,'2015-10-16 12:44:31','2015-10-18 14:25:31',NULL,1,2,'2017-05-02 15:44:31',2,'2017-05-02 15:44:32',0,NULL,NULL,NULL,'4d085c8a-f0d8-45c2-bbc7-0d6417b88fd9'),(445,91,1,'2017-02-27 12:44:32','2017-02-27 14:49:32',NULL,1,2,'2017-05-02 15:44:32',2,'2017-05-02 15:44:32',0,NULL,NULL,NULL,'037e3b74-48dd-4fa3-b722-17a1fa5a4fea'),(446,91,1,'2016-09-28 12:44:32','2016-09-28 14:46:32',NULL,1,2,'2017-05-02 15:44:33',2,'2017-05-02 15:44:33',0,NULL,NULL,NULL,'b94b8d4d-c73e-4909-8ff8-4a7e0a7b465d'),(447,91,1,'2016-08-02 12:44:33','2016-08-02 15:08:33',NULL,1,2,'2017-05-02 15:44:34',2,'2017-05-02 15:44:34',0,NULL,NULL,NULL,'2c47dc75-de4e-46dd-afcf-878f2cd8ab30'),(448,92,1,'2015-12-23 12:44:34','2015-12-23 14:42:34',NULL,1,2,'2017-05-02 15:44:35',2,'2017-05-02 15:44:35',0,NULL,NULL,NULL,'9d59e5c2-9fcc-478c-a95b-27d4d6f9fe8d'),(449,93,1,'2016-05-16 12:44:35','2016-05-16 14:34:35',NULL,1,2,'2017-05-02 15:44:36',2,'2017-05-02 15:44:36',0,NULL,NULL,NULL,'04eefd2b-81bd-42d0-9da8-1ddd64df99b9'),(450,93,1,'2015-11-20 12:44:36','2015-11-20 15:04:36',NULL,1,2,'2017-05-02 15:44:37',2,'2017-05-02 15:44:37',0,NULL,NULL,NULL,'268db1ee-78b0-4ccd-a67d-26d52f208973'),(451,93,1,'2015-11-29 12:44:38','2015-11-29 15:14:38',NULL,1,2,'2017-05-02 15:44:38',2,'2017-05-02 15:44:38',0,NULL,NULL,NULL,'89cd42cd-5425-48dc-8fdd-71c1bc78d8ae'),(452,93,1,'2016-01-27 12:44:38','2016-01-29 14:16:38',NULL,1,2,'2017-05-02 15:44:39',2,'2017-05-02 15:44:39',0,NULL,NULL,NULL,'f020748c-5a5a-485b-8b82-81578d2eb156'),(453,94,1,'2017-04-21 12:44:39','2017-04-21 14:47:39',NULL,1,2,'2017-05-02 15:44:40',2,'2017-05-02 15:44:40',0,NULL,NULL,NULL,'cb108d9f-f756-4786-8bf9-d7c200fb90b1'),(454,94,1,'2016-06-26 12:44:40','2016-06-26 14:56:40',NULL,1,2,'2017-05-02 15:44:40',2,'2017-05-02 15:44:41',0,NULL,NULL,NULL,'980569d9-b24c-40b8-9912-61749111fee4'),(455,94,1,'2016-06-06 12:44:41','2016-06-06 14:47:41',NULL,1,2,'2017-05-02 15:44:41',2,'2017-05-02 15:44:41',0,NULL,NULL,NULL,'04105814-4327-4c2d-a830-4be89c6916d6'),(456,94,1,'2016-06-14 12:44:41','2016-06-14 14:18:41',NULL,1,2,'2017-05-02 15:44:42',2,'2017-05-02 15:44:42',0,NULL,NULL,NULL,'39d79195-bd4b-4d18-9acc-ce54c419472c'),(457,94,1,'2016-01-29 12:44:42','2016-01-29 14:15:42',NULL,1,2,'2017-05-02 15:44:43',2,'2017-05-02 15:44:43',0,NULL,NULL,NULL,'b61543e8-9aee-4cf5-938f-8f237e8cb5b1'),(458,94,1,'2015-12-08 12:44:43','2015-12-08 14:27:43',NULL,1,2,'2017-05-02 15:44:43',2,'2017-05-02 15:44:44',0,NULL,NULL,NULL,'faa3ab09-f54a-495c-90df-c64318f6352a'),(459,94,1,'2016-09-08 12:44:44','2016-09-10 14:11:44',NULL,1,2,'2017-05-02 15:44:44',2,'2017-05-02 15:44:44',0,NULL,NULL,NULL,'cc9874af-f712-41bb-9a00-9546ad214d40'),(460,94,1,'2015-08-24 12:44:44','2015-08-25 14:08:44',NULL,1,2,'2017-05-02 15:44:45',2,'2017-05-02 15:44:45',0,NULL,NULL,NULL,'0df9f871-1bdf-4b65-b63b-aad9ceca32a1'),(461,95,1,'2015-12-14 12:44:45','2015-12-14 14:54:45',NULL,1,2,'2017-05-02 15:44:45',2,'2017-05-02 15:44:46',0,NULL,NULL,NULL,'ed7c3fe0-6ec2-4da7-a724-0e2a8979b866'),(462,95,1,'2015-08-07 12:44:46','2015-08-07 14:37:46',NULL,1,2,'2017-05-02 15:44:46',2,'2017-05-02 15:44:47',0,NULL,NULL,NULL,'71221749-1aff-4883-98e2-1ebc9bab6207'),(463,95,1,'2015-12-01 12:44:47','2015-12-01 14:42:47',NULL,1,2,'2017-05-02 15:44:47',2,'2017-05-02 15:44:47',0,NULL,NULL,NULL,'a34f93c1-d4ff-4423-b8a7-05d25ed86fce'),(464,95,1,'2016-05-28 12:44:47','2016-05-28 15:04:47',NULL,1,2,'2017-05-02 15:44:48',2,'2017-05-02 15:44:48',0,NULL,NULL,NULL,'47fa1f83-83df-4d71-aaf8-22162d409c28'),(465,95,1,'2017-01-01 12:44:48','2017-01-04 14:29:48',NULL,1,2,'2017-05-02 15:44:49',2,'2017-05-02 15:44:49',0,NULL,NULL,NULL,'7a50240b-f60b-4818-ae78-12db0d0c073a'),(466,96,1,'2016-05-18 12:44:49','2016-05-18 15:03:49',NULL,1,2,'2017-05-02 15:44:50',2,'2017-05-02 15:44:50',0,NULL,NULL,NULL,'7acda3b8-58db-4efc-b69d-0083517d7a6e'),(467,96,1,'2017-02-15 12:44:50','2017-02-15 14:20:50',NULL,1,2,'2017-05-02 15:44:50',2,'2017-05-02 15:44:50',0,NULL,NULL,NULL,'cbc04fdd-0510-45b4-b7d2-ea85849b51b6'),(468,96,1,'2015-11-13 12:44:50','2015-11-13 15:10:50',NULL,1,2,'2017-05-02 15:44:51',2,'2017-05-02 15:44:51',0,NULL,NULL,NULL,'4dd4b9a3-f6f5-4a63-86a8-8efee315bde2'),(469,96,1,'2016-03-12 12:44:51','2016-03-15 13:51:51',NULL,1,2,'2017-05-02 15:44:51',2,'2017-05-02 15:44:52',0,NULL,NULL,NULL,'900e7e04-1cca-4e75-aeb9-b02e0198ac43'),(470,97,1,'2015-12-05 12:44:52','2015-12-05 14:26:52',NULL,1,2,'2017-05-02 15:44:52',2,'2017-05-02 15:44:52',0,NULL,NULL,NULL,'51c72217-c4dd-4a85-8aa0-43eaf66b8fa3'),(471,97,1,'2015-09-16 12:44:52','2015-09-16 14:48:52',NULL,1,2,'2017-05-02 15:44:52',2,'2017-05-02 15:44:53',0,NULL,NULL,NULL,'f9728814-aa68-4520-987d-89aa655552dc'),(472,97,1,'2015-12-11 12:44:53','2015-12-11 14:31:53',NULL,1,2,'2017-05-02 15:44:53',2,'2017-05-02 15:44:54',0,NULL,NULL,NULL,'d39c9bb4-2796-4d09-8c2a-72acf9eeb761'),(473,97,1,'2016-12-30 12:44:54','2017-01-02 14:44:54',NULL,1,2,'2017-05-02 15:44:54',2,'2017-05-02 15:44:55',0,NULL,NULL,NULL,'025dfb01-bda1-4e6f-a8c7-b9f79bac8f55'),(474,99,1,'2017-02-26 12:44:55','2017-02-26 14:45:55',NULL,1,2,'2017-05-02 15:44:55',2,'2017-05-02 15:44:56',0,NULL,NULL,NULL,'e0891cb1-a6af-45d7-af5e-a370cb71689b'),(475,99,1,'2016-11-21 12:44:56','2016-11-21 14:34:56',NULL,1,2,'2017-05-02 15:44:56',2,'2017-05-02 15:44:56',0,NULL,NULL,NULL,'a55f2499-d51b-414c-b752-023299a3f66b'),(476,100,1,'2016-07-16 12:44:56','2016-07-16 15:07:56',NULL,1,2,'2017-05-02 15:44:56',2,'2017-05-02 15:44:57',0,NULL,NULL,NULL,'a710a5c6-19ea-4444-a0aa-40ff7594f7c9'),(477,100,1,'2016-08-27 12:44:57','2016-08-27 14:20:57',NULL,1,2,'2017-05-02 15:44:57',2,'2017-05-02 15:44:57',0,NULL,NULL,NULL,'c5052d39-dbcf-4413-8f36-a9c298e171ee'),(478,100,1,'2017-02-07 12:44:57','2017-02-07 14:15:57',NULL,1,2,'2017-05-02 15:44:58',2,'2017-05-02 15:44:58',0,NULL,NULL,NULL,'fbabafaa-26b7-4142-80cb-b382542abf4b'),(479,100,1,'2016-08-25 12:44:58','2016-08-26 14:10:58',NULL,1,2,'2017-05-02 15:44:58',2,'2017-05-02 15:44:59',0,NULL,NULL,NULL,'b4febea3-660f-49ee-ba87-e657100e1dc7'),(480,101,1,'2016-06-16 12:44:59','2016-06-16 14:53:59',NULL,1,2,'2017-05-02 15:44:59',2,'2017-05-02 15:45:00',0,NULL,NULL,NULL,'b46b10c0-dfb0-41da-a7d6-ce3f50ef30d7'),(481,101,1,'2017-03-21 12:45:00','2017-03-21 14:26:00',NULL,1,2,'2017-05-02 15:45:00',2,'2017-05-02 15:45:01',0,NULL,NULL,NULL,'e99cd228-a919-40c5-b2a5-33d9eb20d48d'),(482,101,1,'2017-03-27 12:45:01','2017-03-27 14:47:01',NULL,1,2,'2017-05-02 15:45:01',2,'2017-05-02 15:45:02',0,NULL,NULL,NULL,'de4509ec-6c93-420f-abad-52cfb3eb46f0'),(483,101,1,'2016-09-23 12:45:02','2016-09-23 14:37:02',NULL,1,2,'2017-05-02 15:45:02',2,'2017-05-02 15:45:03',0,NULL,NULL,NULL,'74e0c91d-0583-43ca-94c3-dd50ccc1a260'),(484,101,1,'2015-11-24 12:45:03','2015-11-24 14:28:03',NULL,1,2,'2017-05-02 15:45:03',2,'2017-05-02 15:45:03',0,NULL,NULL,NULL,'6a60dd43-1438-4fd5-afb4-e1b1018206c9'),(485,101,1,'2016-12-30 12:45:03','2016-12-30 14:29:03',NULL,1,2,'2017-05-02 15:45:04',2,'2017-05-02 15:45:04',0,NULL,NULL,NULL,'a8f58513-3706-4668-9621-3945ad563742'),(486,101,1,'2016-06-01 12:45:04','2016-06-03 14:32:04',NULL,1,2,'2017-05-02 15:45:05',2,'2017-05-02 15:45:05',0,NULL,NULL,NULL,'270474db-acba-4a76-aee3-c4a385340d80'),(487,101,1,'2015-05-07 12:45:05','2015-05-09 14:35:05',NULL,1,2,'2017-05-02 15:45:05',2,'2017-05-02 15:45:06',0,NULL,NULL,NULL,'ec2890f1-9dbd-4725-85c4-0a1cf75a2a79'),(488,102,1,'2017-01-17 12:45:06','2017-01-17 14:55:06',NULL,1,2,'2017-05-02 15:45:06',2,'2017-05-02 15:45:07',0,NULL,NULL,NULL,'05b7fdfd-5366-43f7-b3ee-33cda5489b91'),(489,102,1,'2016-02-08 12:45:07','2016-02-08 15:05:07',NULL,1,2,'2017-05-02 15:45:07',2,'2017-05-02 15:45:08',0,NULL,NULL,NULL,'4645b354-aca5-4913-8580-dbb0052aec15'),(490,103,1,'2015-09-17 12:45:08','2015-09-17 15:09:08',NULL,1,2,'2017-05-02 15:45:08',2,'2017-05-02 15:45:08',0,NULL,NULL,NULL,'f85e2aa5-0dfd-4ec1-9b0a-8bf14ab7217f'),(491,103,1,'2016-12-06 12:45:08','2016-12-06 14:38:08',NULL,1,2,'2017-05-02 15:45:09',2,'2017-05-02 15:45:09',0,NULL,NULL,NULL,'38fe2940-89d2-4931-8d9e-7c850b7ae7e5'),(492,103,1,'2016-11-23 12:45:09','2016-11-23 14:38:09',NULL,1,2,'2017-05-02 15:45:09',2,'2017-05-02 15:45:09',0,NULL,NULL,NULL,'5fdfc00f-0660-4f15-a8e5-3cc1568c1ebd'),(493,104,1,'2016-06-25 12:45:10','2016-06-25 15:08:10',NULL,1,2,'2017-05-02 15:45:10',2,'2017-05-02 15:45:10',0,NULL,NULL,NULL,'063b1639-23fa-4121-80b1-cf8bc2247578'),(494,104,1,'2015-11-05 12:45:10','2015-11-05 14:46:10',NULL,1,2,'2017-05-02 15:45:10',2,'2017-05-02 15:45:11',0,NULL,NULL,NULL,'d5c1bac4-32e6-4acf-98d8-c9a4584aab4f'),(495,104,1,'2016-09-10 12:45:11','2016-09-10 14:49:11',NULL,1,2,'2017-05-02 15:45:11',2,'2017-05-02 15:45:12',0,NULL,NULL,NULL,'bb06449a-8a46-4ad1-aa05-5bd57eb3e216'),(496,104,1,'2016-09-12 12:45:12','2016-09-12 14:38:12',NULL,1,2,'2017-05-02 15:45:12',2,'2017-05-02 15:45:12',0,NULL,NULL,NULL,'10860848-9f5a-4f1a-b055-5780ef4e1514'),(497,104,1,'2016-09-11 12:45:12','2016-09-11 14:32:12',NULL,1,2,'2017-05-02 15:45:13',2,'2017-05-02 15:45:13',0,NULL,NULL,NULL,'28de978e-e48f-4877-98db-d17a653747d4'),(498,104,1,'2017-01-08 12:45:13','2017-01-08 14:41:13',NULL,1,2,'2017-05-02 15:45:13',2,'2017-05-02 15:45:14',0,NULL,NULL,NULL,'e64675a1-77b5-4614-9ad0-933d8158f879'),(499,104,1,'2016-05-03 12:45:14','2016-05-06 14:12:14',NULL,1,2,'2017-05-02 15:45:14',2,'2017-05-02 15:45:15',0,NULL,NULL,NULL,'6db50510-7390-45ba-9a44-28968d8b325b'),(500,105,1,'2016-04-11 12:45:15','2016-04-11 14:18:15',NULL,1,2,'2017-05-02 15:45:15',2,'2017-05-02 15:45:15',0,NULL,NULL,NULL,'6b19b71b-6418-4454-a726-fa34ddaad3ab'),(501,106,1,'2016-09-01 12:45:16','2016-09-01 14:41:16',NULL,1,2,'2017-05-02 15:45:16',2,'2017-05-02 15:45:16',0,NULL,NULL,NULL,'201d7d78-5a98-4dd7-8333-784e99004edf'),(502,106,1,'2017-01-03 12:45:16','2017-01-03 15:08:16',NULL,1,2,'2017-05-02 15:45:17',2,'2017-05-02 15:45:17',0,NULL,NULL,NULL,'e69802dc-d939-4a97-9c29-9f7d806b21ff'),(503,106,1,'2016-02-20 12:45:17','2016-02-20 14:15:17',NULL,1,2,'2017-05-02 15:45:17',2,'2017-05-02 15:45:18',0,NULL,NULL,NULL,'848d3464-706a-486a-adf4-8807870648c7'),(504,106,1,'2017-02-04 12:45:18','2017-02-04 14:35:18',NULL,1,2,'2017-05-02 15:45:18',2,'2017-05-02 15:45:19',0,NULL,NULL,NULL,'0423e516-fed1-4a43-8c76-56e205f53df6'),(505,106,1,'2015-08-08 12:45:19','2015-08-08 14:56:19',NULL,1,2,'2017-05-02 15:45:19',2,'2017-05-02 15:45:20',0,NULL,NULL,NULL,'77e2e626-d971-4125-a3b0-140c0871710f'),(506,106,1,'2016-05-15 12:45:20','2016-05-15 14:52:20',NULL,1,2,'2017-05-02 15:45:20',2,'2017-05-02 15:45:20',0,NULL,NULL,NULL,'43f62efb-43c6-4581-a481-3208eb80fba2'),(507,106,1,'2015-11-09 12:45:20','2015-11-12 13:57:20',NULL,1,2,'2017-05-02 15:45:21',2,'2017-05-02 15:45:21',0,NULL,NULL,NULL,'bdcae1a8-90fe-4384-b988-d25f0c890d65'),(508,106,1,'2016-05-06 12:45:21','2016-05-09 14:34:21',NULL,1,2,'2017-05-02 15:45:21',2,'2017-05-02 15:45:22',0,NULL,NULL,NULL,'b127c9cd-c05a-425f-962c-d1292a01b60a')
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit` ENABLE KEYS */
10-Aug-2021 20:36:30 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Table structure for table `visit_attribute`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 DROP TABLE IF EXISTS `visit_attribute`
10-Aug-2021 20:36:30 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:30 [INFO] CREATE TABLE `visit_attribute` (
10-Aug-2021 20:36:30   `visit_attribute_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:30   `visit_id` int(11) NOT NULL,
10-Aug-2021 20:36:30   `attribute_type_id` int(11) NOT NULL,
10-Aug-2021 20:36:30   `value_reference` text NOT NULL,
10-Aug-2021 20:36:30   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:30   `creator` int(11) NOT NULL,
10-Aug-2021 20:36:30   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:30   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `voided` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:30   `voided_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_voided` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `void_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   PRIMARY KEY (`visit_attribute_id`),
10-Aug-2021 20:36:30   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:30   KEY `visit_attribute_visit_fk` (`visit_id`),
10-Aug-2021 20:36:30   KEY `visit_attribute_attribute_type_id_fk` (`attribute_type_id`),
10-Aug-2021 20:36:30   KEY `visit_attribute_creator_fk` (`creator`),
10-Aug-2021 20:36:30   KEY `visit_attribute_changed_by_fk` (`changed_by`),
10-Aug-2021 20:36:30   KEY `visit_attribute_voided_by_fk` (`voided_by`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_attribute_type_id_fk` FOREIGN KEY (`attribute_type_id`) REFERENCES `visit_attribute_type` (`visit_attribute_type_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_changed_by_fk` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_creator_fk` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_visit_fk` FOREIGN KEY (`visit_id`) REFERENCES `visit` (`visit_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_voided_by_fk` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Dumping data for table `visit_attribute`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 LOCK TABLES `visit_attribute` WRITE
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit_attribute` DISABLE KEYS */
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit_attribute` ENABLE KEYS */
10-Aug-2021 20:36:30 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Table structure for table `visit_attribute_type`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 DROP TABLE IF EXISTS `visit_attribute_type`
10-Aug-2021 20:36:30 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:30 [INFO] CREATE TABLE `visit_attribute_type` (
10-Aug-2021 20:36:30   `visit_attribute_type_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:30   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:30   `description` varchar(1024) DEFAULT NULL,
10-Aug-2021 20:36:30   `datatype` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `datatype_config` text,
10-Aug-2021 20:36:30   `preferred_handler` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `handler_config` text,
10-Aug-2021 20:36:30   `min_occurs` int(11) NOT NULL,
10-Aug-2021 20:36:30   `max_occurs` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `creator` int(11) NOT NULL,
10-Aug-2021 20:36:30   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:30   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:30   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:30   PRIMARY KEY (`visit_attribute_type_id`),
10-Aug-2021 20:36:30   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:30   KEY `visit_attribute_type_creator_fk` (`creator`),
10-Aug-2021 20:36:30   KEY `visit_attribute_type_changed_by_fk` (`changed_by`),
10-Aug-2021 20:36:30   KEY `visit_attribute_type_retired_by_fk` (`retired_by`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_type_changed_by_fk` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_type_creator_fk` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_attribute_type_retired_by_fk` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Dumping data for table `visit_attribute_type`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 LOCK TABLES `visit_attribute_type` WRITE
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit_attribute_type` DISABLE KEYS */
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit_attribute_type` ENABLE KEYS */
10-Aug-2021 20:36:30 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Table structure for table `visit_type`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 DROP TABLE IF EXISTS `visit_type`
10-Aug-2021 20:36:30 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 20:36:30 [INFO] CREATE TABLE `visit_type` (
10-Aug-2021 20:36:30   `visit_type_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 20:36:30   `name` varchar(255) NOT NULL,
10-Aug-2021 20:36:30   `description` varchar(1024) DEFAULT NULL,
10-Aug-2021 20:36:30   `creator` int(11) NOT NULL,
10-Aug-2021 20:36:30   `date_created` datetime NOT NULL,
10-Aug-2021 20:36:30   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 20:36:30   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 20:36:30   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 20:36:30   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 20:36:30   `uuid` char(38) NOT NULL,
10-Aug-2021 20:36:30   PRIMARY KEY (`visit_type_id`),
10-Aug-2021 20:36:30   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 20:36:30   KEY `visit_type_creator` (`creator`),
10-Aug-2021 20:36:30   KEY `visit_type_changed_by` (`changed_by`),
10-Aug-2021 20:36:30   KEY `visit_type_retired_by` (`retired_by`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_type_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_type_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 20:36:30   CONSTRAINT `visit_type_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 20:36:30 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
10-Aug-2021 20:36:30 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 20:36:30 [INFO] --
10-Aug-2021 20:36:30 -- Dumping data for table `visit_type`
10-Aug-2021 20:36:30 --
10-Aug-2021 20:36:30
10-Aug-2021 20:36:30 LOCK TABLES `visit_type` WRITE
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit_type` DISABLE KEYS */
10-Aug-2021 20:36:30 [INFO] INSERT INTO `visit_type` VALUES (1,'Facility Visit','Patient visits the clinic/hospital (as opposed to a home visit, or telephone contact)',2,'2013-08-02 02:39:43',2,'2017-05-02 15:38:27',0,NULL,NULL,NULL,'7b0f5697-27e3-40c4-8bae-f4049abfb4ed')
10-Aug-2021 20:36:30 [INFO] /*!40000 ALTER TABLE `visit_type` ENABLE KEYS */
10-Aug-2021 20:36:30 [INFO] UNLOCK TABLES
10-Aug-2021 20:36:30 [INFO] /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET SQL_MODE=@OLD_SQL_MODE */
10-Aug-2021 20:36:30 [INFO] /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */
10-Aug-2021 20:36:30 [INFO] /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */
10-Aug-2021 20:36:30 [INFO] /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */
10-Aug-2021 20:36:30 [INFO] /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */
10-Aug-2021 20:36:30 [INFO] -- Dump completed on 2017-05-02 15:47:26
10-Aug-2021 20:36:30 [INFO] SQL in file src/main/db/demo-db-2.6.0.sql executed
10-Aug-2021 20:36:30 [INFO] ChangeSet src/main/db/liquibase-demo-data.xml::20170502-1600::standalone ran successfully in 14726ms
10-Aug-2021 20:36:30 [INFO] SELECT MAX(ORDEREXECUTED) FROM liquibasechangelog
10-Aug-2021 20:36:30 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('20170502-1600', 'standalone', 'src/main/db/liquibase-demo-data.xml', NOW(), 10791, '8:7aaa2171180dd2c59c22070827e3bb2b', 'sqlFile', 'Adding static demo data', 'EXECUTED', NULL, NULL, '3.8.9', '8627775958')
10-Aug-2021 20:36:30 [INFO] INSERT INTO scheduler_task_config (task_config_id, name, `description`, schedulable_class, start_time, start_time_pattern, repeat_interval, start_on_startup, started, created_by, date_created, changed_by, date_changed, last_execution_time, uuid) VALUES (2, 'Auto Close Visits Task', 'Stops all active visits that match the visit type(s) specified by the value of the global property ''visits.autoCloseVisitType''', 'org.openmrs.scheduler.tasks.AutoCloseVisitsTask', '2011-11-28 23:59:59', 'MM/dd/yyyy HH:mm:ss', 86400, 0, 0, 1, '2018-06-04 18:30:16', NULL, NULL, NULL, '8c17b376-1a2b-11e1-a51a-00248140a5eb')
10-Aug-2021 20:36:30 [INFO] New row inserted into scheduler_task_config
10-Aug-2021 20:36:30 [INFO] INSERT INTO scheduler_task_config (task_config_id, name, `description`, schedulable_class, start_time, start_time_pattern, repeat_interval, start_on_startup, started, created_by, date_created, changed_by, date_changed, last_execution_time, uuid) VALUES (3, 'Process HL7 Task', '', 'org.openmrs.scheduler.tasks.ProcessHL7InQueueTask', '2017-05-02 15:45:38', '', 5, 0, 0, 2, '2017-05-02 15:47:23', 2, '2017-05-02 15:47:23', '2017-05-02 15:47:23', 'c8143724-9263-43ba-8250-162699eb6100')
10-Aug-2021 20:36:30 [INFO] New row inserted into scheduler_task_config
10-Aug-2021 20:36:31 [INFO] ChangeSet src/main/db/liquibase-demo-data.xml::1582473679024-24::wolf (hand-rolled) ran successfully in 331ms
10-Aug-2021 20:36:31 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1582473679024-24', 'wolf (hand-rolled)', 'src/main/db/liquibase-demo-data.xml', NOW(), 10792, '8:6e96fff01ac74d54ad13e9c5d8c820be', 'insert tableName=scheduler_task_config; insert tableName=scheduler_task_config', '', 'EXECUTED', NULL, NULL, '3.8.9', '8627775958')
10-Aug-2021 20:36:31 [INFO] Successfully released change log lock
10-Aug-2021 20:36:31 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:31 [INFO]
10-Aug-2021 20:36:31 [INFO]
10-Aug-2021 20:36:31 [INFO] --- liquibase-maven-plugin:3.8.9:update (demo-database-update-to-latest) @ referenceapplication-standalone ---
10-Aug-2021 20:36:31 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:31 [INFO] Loading artifacts into URLClassLoader
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-catalina/7.0.50/tomcat-catalina-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-servlet-api/7.0.50/tomcat-servlet-api-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-juli/7.0.50/tomcat-juli-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-annotations-api/7.0.50/tomcat-annotations-api-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-api/7.0.50/tomcat-api-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-util/7.0.50/tomcat-util-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-coyote/7.0.50/tomcat-coyote-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-jasper/7.0.50/tomcat-jasper-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-jsp-api/7.0.50/tomcat-jsp-api-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-el-api/7.0.50/tomcat-el-api-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/eclipse/jdt/core/compiler/ecj/4.3.1/ecj-4.3.1.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-jasper-el/7.0.50/tomcat-jasper-el-7.0.50.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/mysql/mysql-connector-java/5.1.28/mysql-connector-java-5.1.28.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/mysql/mysql-connector-mxj-fixed/5.0.12/mysql-connector-mxj-fixed-5.0.12.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/mysql/mysql-connector-mxj-db-files-fixed/5.0.12-20170418/mysql-connector-mxj-db-files-fixed-5.0.12-20170418.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/javax/inject/javax.inject/1/javax.inject-1.jar
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/classes
10-Aug-2021 20:36:31 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/test-classes
10-Aug-2021 20:36:31 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:31 [INFO]
10-Aug-2021 20:36:31 [INFO]
10-Aug-2021 20:36:31 [INFO] Liquibase Community 3.8.9 by Datical
10-Aug-2021 20:36:31 [INFO] Starting Liquibase at Tue, 10 Aug 2021 20:36:31 UTC (version 3.8.9 #73 built at Mon Apr 06 09:32:58 UTC 2020)
10-Aug-2021 20:36:31 [INFO] Settings
10-Aug-2021 20:36:31 ----------------------------
10-Aug-2021 20:36:31 [INFO]     driver: com.mysql.jdbc.Driver
10-Aug-2021 20:36:31 [INFO]     url: jdbc:mysql:mxj://127.0.0.1:33328/openmrs?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8&server.initialize-user=true&createDatabaseIfNotExist=true&server.basedir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase&server.datadir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase/data&server.collation-server=utf8_general_ci&server.character-set-server=utf8&server.max_allowed_packet=32M
10-Aug-2021 20:36:31 [INFO]     username: openmrs
10-Aug-2021 20:36:31 [INFO]     password: *****
10-Aug-2021 20:36:31 [INFO]     use empty password: false
10-Aug-2021 20:36:31 [INFO]     properties file: null
10-Aug-2021 20:36:31 [INFO]     properties file will override? false
10-Aug-2021 20:36:31 [INFO]     prompt on non-local database? true
10-Aug-2021 20:36:31 [INFO]     clear checksums? false
10-Aug-2021 20:36:31 [INFO]     changeLogDirectory: null
10-Aug-2021 20:36:31 [INFO]     changeLogFile: liquibase-update-to-latest.xml
10-Aug-2021 20:36:31 [INFO]     context(s): null
10-Aug-2021 20:36:31 [INFO]     label(s): null
10-Aug-2021 20:36:31 [INFO]     number of changes to apply: 0
10-Aug-2021 20:36:31 [INFO]     drop first? false
10-Aug-2021 20:36:31 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:31 [INFO] Executing on Database: jdbc:mysql:mxj://127.0.0.1:33328/openmrs?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8&server.initialize-user=true&createDatabaseIfNotExist=true&server.basedir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase&server.datadir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase/data&server.collation-server=utf8_general_ci&server.character-set-server=utf8&server.max_allowed_packet=32M
10-Aug-2021 20:36:31 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 20:36:31 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 20:36:31 [INFO] SELECT `LOCKED` FROM liquibasechangeloglock WHERE ID=1
10-Aug-2021 20:36:31 [INFO] Successfully acquired change log lock
10-Aug-2021 20:36:31 [INFO] SELECT MD5SUM FROM liquibasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1
10-Aug-2021 20:36:31 [INFO] UPDATE liquibasechangelog SET MD5SUM = NULL
10-Aug-2021 20:36:31 [INFO] SELECT COUNT(*) FROM liquibasechangelog
10-Aug-2021 20:36:31 [INFO] Reading from liquibasechangelog
10-Aug-2021 20:36:31 [INFO] SELECT * FROM liquibasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
10-Aug-2021 20:36:32 [INFO] ALTER TABLE order_group ADD order_group_reason INT NULL
10-Aug-2021 20:36:32 [INFO] Columns order_group_reason(int) added to order_group
10-Aug-2021 20:36:32 [INFO] ALTER TABLE order_group ADD CONSTRAINT order_group_order_group_reason_fk FOREIGN KEY (order_group_reason) REFERENCES concept (concept_id)
10-Aug-2021 20:36:32 [INFO] Foreign key constraint added to order_group (order_group_reason)
10-Aug-2021 20:36:32 [INFO] ChangeSet liquibase-update-to-latest.xml::20190815-Trunk-5412::gitacliff ran successfully in 619ms
10-Aug-2021 20:36:32 [INFO] SELECT MAX(ORDEREXECUTED) FROM liquibasechangelog
10-Aug-2021 20:36:32 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('20190815-Trunk-5412', 'gitacliff', 'liquibase-update-to-latest.xml', NOW(), 10793, '8:097971ad4b683c624ef7b5d9afb8faea', 'addColumn tableName=order_group; addForeignKeyConstraint baseTableName=order_group, constraintName=order_group_order_group_reason_fk, referencedTableName=concept', 'Adding "order_group_reason" column to order_group table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:32 [INFO] ALTER TABLE order_group ADD parent_order_group INT NULL
10-Aug-2021 20:36:32 [INFO] Columns parent_order_group(int) added to order_group
10-Aug-2021 20:36:32 [INFO] ALTER TABLE order_group ADD CONSTRAINT order_group_parent_order_group_fk FOREIGN KEY (parent_order_group) REFERENCES order_group (order_group_id)
10-Aug-2021 20:36:33 [INFO] Foreign key constraint added to order_group (parent_order_group)
10-Aug-2021 20:36:33 [INFO] ChangeSet liquibase-update-to-latest.xml::20190815-Trunk-5650::gitacliff ran successfully in 437ms
10-Aug-2021 20:36:33 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('20190815-Trunk-5650', 'gitacliff', 'liquibase-update-to-latest.xml', NOW(), 10794, '8:683558c2e7716af357494252a94aee20', 'addColumn tableName=order_group; addForeignKeyConstraint baseTableName=order_group, constraintName=order_group_parent_order_group_fk, referencedTableName=order_group', 'Adding "parent_order_group" column to order_group table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:33 [INFO] ALTER TABLE conditions ADD encounter_id INT NULL
10-Aug-2021 20:36:33 [INFO] Columns encounter_id(int) added to conditions
10-Aug-2021 20:36:33 [INFO] ALTER TABLE conditions ADD CONSTRAINT conditions_encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES encounter (encounter_id)
10-Aug-2021 20:36:33 [INFO] Foreign key constraint added to conditions (encounter_id)
10-Aug-2021 20:36:33 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5728-2020-05-20::samuel34 ran successfully in 472ms
10-Aug-2021 20:36:33 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('TRUNK-5728-2020-05-20', 'samuel34', 'liquibase-update-to-latest.xml', NOW(), 10795, '8:2a90bedc8b02e4c89e1a37dc1110014b', 'addColumn tableName=conditions; addForeignKeyConstraint baseTableName=conditions, constraintName=conditions_encounter_id_fk, referencedTableName=encounter', 'Adding ''encounter_id'' column to ''conditions'' table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:33 [INFO] ALTER TABLE order_group ADD previous_order_group INT NULL
10-Aug-2021 20:36:33 [INFO] Columns previous_order_group(int) added to order_group
10-Aug-2021 20:36:33 [INFO] ALTER TABLE order_group ADD CONSTRAINT order_group_previous_order_group_fk FOREIGN KEY (previous_order_group) REFERENCES order_group (order_group_id)
10-Aug-2021 20:36:33 [INFO] Foreign key constraint added to order_group (previous_order_group)
10-Aug-2021 20:36:33 [INFO] ChangeSet liquibase-update-to-latest.xml::20190815-Trunk-5651::gitacliff ran successfully in 103ms
10-Aug-2021 20:36:33 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('20190815-Trunk-5651', 'gitacliff', 'liquibase-update-to-latest.xml', NOW(), 10796, '8:f57b630542abaf86eb5f11cb4c3e9ad5', 'addColumn tableName=order_group; addForeignKeyConstraint baseTableName=order_group, constraintName=order_group_previous_order_group_fk, referencedTableName=order_group', 'Adding "previous_order_group" column to order_group table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:33 [INFO] ALTER TABLE conditions ADD form_namespace_and_path VARCHAR(255) NULL
10-Aug-2021 20:36:33 [INFO] Columns form_namespace_and_path(varchar(255)) added to conditions
10-Aug-2021 20:36:33 [INFO] ChangeSet liquibase-update-to-latest.xml::20200714-Trunk-5862::loliveira ran successfully in 48ms
10-Aug-2021 20:36:33 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('20200714-Trunk-5862', 'loliveira', 'liquibase-update-to-latest.xml', NOW(), 10797, '8:c2d4c311dcab0c2c9507b75bfdd78a3c', 'addColumn tableName=conditions', 'Adding "form_namespace_and_path" column to conditions table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:33 [INFO] CREATE TABLE order_set_attribute_type (order_set_attribute_type_id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, `description` VARCHAR(1024) NULL, datatype VARCHAR(255) NULL, datatype_config TEXT NULL, preferred_handler VARCHAR(255) NULL, handler_config TEXT NULL, min_occurs INT NOT NULL, max_occurs INT NULL, creator INT NOT NULL, date_created datetime NOT NULL, changed_by INT NULL, date_changed datetime NULL, retired TINYINT(1) DEFAULT 0 NOT NULL, retired_by INT NULL, date_retired datetime NULL, retire_reason VARCHAR(255) DEFAULT null NULL, uuid CHAR(38) NOT NULL, CONSTRAINT PK_ORDER_SET_ATTRIBUTE_TYPE PRIMARY KEY (order_set_attribute_type_id), UNIQUE (uuid), UNIQUE (name))
10-Aug-2021 20:36:34 [INFO] Table order_set_attribute_type created
10-Aug-2021 20:36:34 [INFO] ALTER TABLE order_set_attribute_type ADD CONSTRAINT order_set_attribute_type_creator_fk FOREIGN KEY (creator) REFERENCES users (user_id)
10-Aug-2021 20:36:34 [INFO] Foreign key constraint added to order_set_attribute_type (creator)
10-Aug-2021 20:36:34 [INFO] ALTER TABLE order_set_attribute_type ADD CONSTRAINT order_set_attribute_type_changed_by_fk FOREIGN KEY (changed_by) REFERENCES users (user_id)
10-Aug-2021 20:36:34 [INFO] Foreign key constraint added to order_set_attribute_type (changed_by)
10-Aug-2021 20:36:34 [INFO] ALTER TABLE order_set_attribute_type ADD CONSTRAINT order_set_attribute_type_retired_by_fk FOREIGN KEY (retired_by) REFERENCES users (user_id)
10-Aug-2021 20:36:34 [INFO] Foreign key constraint added to order_set_attribute_type (retired_by)
10-Aug-2021 20:36:34 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5835-2020-07-09-1600::gitacliff ran successfully in 624ms
10-Aug-2021 20:36:34 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('TRUNK-5835-2020-07-09-1600', 'gitacliff', 'liquibase-update-to-latest.xml', NOW(), 10798, '8:b744e5bfec82a26f3ed1e8a71fc8d5e5', 'createTable tableName=order_set_attribute_type; addForeignKeyConstraint baseTableName=order_set_attribute_type, constraintName=order_set_attribute_type_creator_fk, referencedTableName=users; addForeignKeyConstraint baseTableName=order_set_attribut...', 'Creating order_set_attribute_type table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:34 [INFO] CREATE TABLE order_set_attribute (order_set_attribute_id INT AUTO_INCREMENT NOT NULL, order_set_id INT NOT NULL, attribute_type_id INT NOT NULL, value_reference TEXT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created datetime NOT NULL, changed_by INT NULL, date_changed datetime NULL, voided TINYINT(1) DEFAULT 0 NOT NULL, voided_by INT NULL, date_voided datetime NULL, void_reason VARCHAR(255) DEFAULT null NULL, CONSTRAINT PK_ORDER_SET_ATTRIBUTE PRIMARY KEY (order_set_attribute_id), UNIQUE (uuid))
10-Aug-2021 20:36:34 [INFO] Table order_set_attribute created
10-Aug-2021 20:36:34 [INFO] ALTER TABLE order_set_attribute ADD CONSTRAINT order_set_attribute_order_set_fk FOREIGN KEY (order_set_id) REFERENCES order_set (order_set_id)
10-Aug-2021 20:36:34 [INFO] Foreign key constraint added to order_set_attribute (order_set_id)
10-Aug-2021 20:36:34 [INFO] ALTER TABLE order_set_attribute ADD CONSTRAINT order_set_attribute_attribute_type_id_fk FOREIGN KEY (attribute_type_id) REFERENCES order_set_attribute_type (order_set_attribute_type_id)
10-Aug-2021 20:36:34 [INFO] Foreign key constraint added to order_set_attribute (attribute_type_id)
10-Aug-2021 20:36:34 [INFO] ALTER TABLE order_set_attribute ADD CONSTRAINT order_set_attribute_creator_fk FOREIGN KEY (creator) REFERENCES users (user_id)
10-Aug-2021 20:36:35 [INFO] Foreign key constraint added to order_set_attribute (creator)
10-Aug-2021 20:36:35 [INFO] ALTER TABLE order_set_attribute ADD CONSTRAINT order_set_attribute_changed_by_fk FOREIGN KEY (changed_by) REFERENCES users (user_id)
10-Aug-2021 20:36:35 [INFO] Foreign key constraint added to order_set_attribute (changed_by)
10-Aug-2021 20:36:35 [INFO] ALTER TABLE order_set_attribute ADD CONSTRAINT order_set_attribute_voided_by_fk FOREIGN KEY (voided_by) REFERENCES users (user_id)
10-Aug-2021 20:36:35 [INFO] Foreign key constraint added to order_set_attribute (voided_by)
10-Aug-2021 20:36:35 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5835-2020-07-09-1700::gitacliff ran successfully in 655ms
10-Aug-2021 20:36:35 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('TRUNK-5835-2020-07-09-1700', 'gitacliff', 'liquibase-update-to-latest.xml', NOW(), 10799, '8:8877d8978506c3107937fb42e6c6634b', 'createTable tableName=order_set_attribute; addForeignKeyConstraint baseTableName=order_set_attribute, constraintName=order_set_attribute_order_set_fk, referencedTableName=order_set; addForeignKeyConstraint baseTableName=order_set_attribute, constr...', 'Creating order_set_attribute table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:35 [INFO] CREATE TABLE order_group_attribute_type (order_group_attribute_type_id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, `description` VARCHAR(1024) NULL, datatype VARCHAR(255) NULL, datatype_config TEXT NULL, preferred_handler VARCHAR(255) NULL, handler_config TEXT NULL, min_occurs INT NOT NULL, max_occurs INT NULL, creator INT NOT NULL, date_created datetime NOT NULL, changed_by INT NULL, date_changed datetime NULL, retired TINYINT(1) DEFAULT 0 NOT NULL, retired_by INT NULL, date_retired datetime NULL, retire_reason VARCHAR(255) DEFAULT null NULL, uuid CHAR(38) NOT NULL, CONSTRAINT PK_ORDER_GROUP_ATTRIBUTE_TYPE PRIMARY KEY (order_group_attribute_type_id), UNIQUE (uuid), UNIQUE (name))
10-Aug-2021 20:36:35 [INFO] Table order_group_attribute_type created
10-Aug-2021 20:36:35 [INFO] ALTER TABLE order_group_attribute_type ADD CONSTRAINT order_group_attribute_type_creator_fk FOREIGN KEY (creator) REFERENCES users (user_id)
10-Aug-2021 20:36:35 [INFO] Foreign key constraint added to order_group_attribute_type (creator)
10-Aug-2021 20:36:35 [INFO] ALTER TABLE order_group_attribute_type ADD CONSTRAINT order_group_attribute_type_changed_by_fk FOREIGN KEY (changed_by) REFERENCES users (user_id)
10-Aug-2021 20:36:35 [INFO] Foreign key constraint added to order_group_attribute_type (changed_by)
10-Aug-2021 20:36:35 [INFO] ALTER TABLE order_group_attribute_type ADD CONSTRAINT order_group_attribute_type_retired_by_fk FOREIGN KEY (retired_by) REFERENCES users (user_id)
10-Aug-2021 20:36:35 [INFO] Foreign key constraint added to order_group_attribute_type (retired_by)
10-Aug-2021 20:36:35 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5410::tendomart ran successfully in 189ms
10-Aug-2021 20:36:35 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('TRUNK-5410', 'tendomart', 'liquibase-update-to-latest.xml', NOW(), 10800, '8:7a314d2f15c425b8fc40545505441ce3', 'createTable tableName=order_group_attribute_type; addForeignKeyConstraint baseTableName=order_group_attribute_type, constraintName=order_group_attribute_type_creator_fk, referencedTableName=users; addForeignKeyConstraint baseTableName=order_group_...', 'Creating order_group_attribute_type table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:35 [INFO] CREATE TABLE order_group_attribute (order_group_attribute_id INT AUTO_INCREMENT NOT NULL, order_group_id INT NOT NULL, attribute_type_id INT NOT NULL, value_reference TEXT NOT NULL, uuid CHAR(38) NOT NULL, creator INT NOT NULL, date_created datetime NOT NULL, changed_by INT NULL, date_changed datetime NULL, voided TINYINT(1) DEFAULT 0 NOT NULL, voided_by INT NULL, date_voided datetime NULL, void_reason VARCHAR(255) DEFAULT null NULL, CONSTRAINT PK_ORDER_GROUP_ATTRIBUTE PRIMARY KEY (order_group_attribute_id), UNIQUE (uuid))
10-Aug-2021 20:36:35 [INFO] Table order_group_attribute created
10-Aug-2021 20:36:35 [INFO] ALTER TABLE order_group_attribute ADD CONSTRAINT order_group_attribute_order_group_fk FOREIGN KEY (order_group_id) REFERENCES order_group (order_group_id)
10-Aug-2021 20:36:35 [INFO] Foreign key constraint added to order_group_attribute (order_group_id)
10-Aug-2021 20:36:35 [INFO] ALTER TABLE order_group_attribute ADD CONSTRAINT order_group_attribute_attribute_type_id_fk FOREIGN KEY (attribute_type_id) REFERENCES order_group_attribute_type (order_group_attribute_type_id)
10-Aug-2021 20:36:36 [INFO] Foreign key constraint added to order_group_attribute (attribute_type_id)
10-Aug-2021 20:36:36 [INFO] ALTER TABLE order_group_attribute ADD CONSTRAINT order_group_attribute_creator_fk FOREIGN KEY (creator) REFERENCES users (user_id)
10-Aug-2021 20:36:36 [INFO] Foreign key constraint added to order_group_attribute (creator)
10-Aug-2021 20:36:36 [INFO] ALTER TABLE order_group_attribute ADD CONSTRAINT order_group_attribute_changed_by_fk FOREIGN KEY (changed_by) REFERENCES users (user_id)
10-Aug-2021 20:36:36 [INFO] Foreign key constraint added to order_group_attribute (changed_by)
10-Aug-2021 20:36:36 [INFO] ALTER TABLE order_group_attribute ADD CONSTRAINT order_group_attribute_voided_by_fk FOREIGN KEY (voided_by) REFERENCES users (user_id)
10-Aug-2021 20:36:36 [INFO] Foreign key constraint added to order_group_attribute (voided_by)
10-Aug-2021 20:36:36 [INFO] ChangeSet liquibase-update-to-latest.xml::20200723-TRUNK-5410::tendomart ran successfully in 1038ms
10-Aug-2021 20:36:36 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('20200723-TRUNK-5410', 'tendomart', 'liquibase-update-to-latest.xml', NOW(), 10801, '8:47b18620e5dd10a8c0f7a13281af80ce', 'createTable tableName=order_group_attribute; addForeignKeyConstraint baseTableName=order_group_attribute, constraintName=order_group_attribute_order_group_fk, referencedTableName=order_group; addForeignKeyConstraint baseTableName=order_group_attri...', 'Creating order_group_attribute table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:36 [INFO] CREATE INDEX orders_order_number ON orders(order_number)
10-Aug-2021 20:36:37 [INFO] Index orders_order_number created
10-Aug-2021 20:36:37 [INFO] ChangeSet liquibase-update-to-latest.xml::2020-08-31-2200-TRUNK-5821::miirochristopher ran successfully in 548ms
10-Aug-2021 20:36:37 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2020-08-31-2200-TRUNK-5821', 'miirochristopher', 'liquibase-update-to-latest.xml', NOW(), 10802, '8:b19d78a89af7cbbc1146acfdc3bc9ee5', 'createIndex indexName=orders_order_number, tableName=orders', 'Adding index to order_number column in Orders table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:37 [INFO] CREATE INDEX orders_accession_number ON orders(accession_number)
10-Aug-2021 20:36:37 [INFO] Index orders_accession_number created
10-Aug-2021 20:36:37 [INFO] ChangeSet liquibase-update-to-latest.xml::2020-08-32-100-TRUNK-5821::miirochristopher ran successfully in 299ms
10-Aug-2021 20:36:37 [INFO] INSERT INTO liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2020-08-32-100-TRUNK-5821', 'miirochristopher', 'liquibase-update-to-latest.xml', NOW(), 10803, '8:ebab8d61ca65d04b73dbed42acebbe6e', 'createIndex indexName=orders_accession_number, tableName=orders', 'Adding index to accession_number column in Orders table', 'EXECUTED', NULL, NULL, '3.8.9', '8627791933')
10-Aug-2021 20:36:37 [INFO] Successfully released change log lock
10-Aug-2021 20:36:37 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:37 [INFO]
10-Aug-2021 20:36:37 [INFO]
10-Aug-2021 20:36:37 [INFO] --- liquibase-maven-plugin:3.8.9:update (demo-database-add-standalone-data) @ referenceapplication-standalone ---
10-Aug-2021 20:36:37 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:37 [INFO] Loading artifacts into URLClassLoader
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-catalina/7.0.50/tomcat-catalina-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-servlet-api/7.0.50/tomcat-servlet-api-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-juli/7.0.50/tomcat-juli-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-annotations-api/7.0.50/tomcat-annotations-api-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-api/7.0.50/tomcat-api-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-util/7.0.50/tomcat-util-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-coyote/7.0.50/tomcat-coyote-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-jasper/7.0.50/tomcat-jasper-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-jsp-api/7.0.50/tomcat-jsp-api-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-el-api/7.0.50/tomcat-el-api-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/eclipse/jdt/core/compiler/ecj/4.3.1/ecj-4.3.1.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/org/apache/tomcat/tomcat-jasper-el/7.0.50/tomcat-jasper-el-7.0.50.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/mysql/mysql-connector-java/5.1.28/mysql-connector-java-5.1.28.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/mysql/mysql-connector-mxj-fixed/5.0.12/mysql-connector-mxj-fixed-5.0.12.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/mysql/mysql-connector-mxj-db-files-fixed/5.0.12-20170418/mysql-connector-mxj-db-files-fixed-5.0.12-20170418.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/javax/inject/javax.inject/1/javax.inject-1.jar
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/classes
10-Aug-2021 20:36:37 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/test-classes
10-Aug-2021 20:36:37 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:37 [INFO]
10-Aug-2021 20:36:37 [INFO]
10-Aug-2021 20:36:37 [INFO] Liquibase Community 3.8.9 by Datical
10-Aug-2021 20:36:37 [INFO] Starting Liquibase at Tue, 10 Aug 2021 20:36:37 UTC (version 3.8.9 #73 built at Mon Apr 06 09:32:58 UTC 2020)
10-Aug-2021 20:36:37 [INFO] Settings
10-Aug-2021 20:36:37 ----------------------------
10-Aug-2021 20:36:37 [INFO]     driver: com.mysql.jdbc.Driver
10-Aug-2021 20:36:37 [INFO]     url: jdbc:mysql:mxj://127.0.0.1:33328/openmrs?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8&server.initialize-user=true&createDatabaseIfNotExist=true&server.basedir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase&server.datadir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase/data&server.collation-server=utf8_general_ci&server.character-set-server=utf8&server.max_allowed_packet=32M
10-Aug-2021 20:36:37 [INFO]     username: openmrs
10-Aug-2021 20:36:37 [INFO]     password: *****
10-Aug-2021 20:36:37 [INFO]     use empty password: false
10-Aug-2021 20:36:37 [INFO]     properties file: null
10-Aug-2021 20:36:37 [INFO]     properties file will override? false
10-Aug-2021 20:36:37 [INFO]     prompt on non-local database? true
10-Aug-2021 20:36:37 [INFO]     clear checksums? false
10-Aug-2021 20:36:37 [INFO]     changeLogDirectory: null
10-Aug-2021 20:36:37 [INFO]     changeLogFile: src/main/db/liquibase-standalone-data.xml
10-Aug-2021 20:36:37 [INFO]     context(s): null
10-Aug-2021 20:36:37 [INFO]     label(s): null
10-Aug-2021 20:36:37 [INFO]     number of changes to apply: 0
10-Aug-2021 20:36:37 [INFO]     drop first? false
10-Aug-2021 20:36:37 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:37 [INFO] Executing on Database: jdbc:mysql:mxj://127.0.0.1:33328/openmrs?autoReconnect=true&sessionVariables=storage_engine=InnoDB&useUnicode=true&characterEncoding=UTF-8&server.initialize-user=true&createDatabaseIfNotExist=true&server.basedir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase&server.datadir=/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase/data&server.collation-server=utf8_general_ci&server.character-set-server=utf8&server.max_allowed_packet=32M
10-Aug-2021 20:36:37 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 20:36:37 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 20:36:37 [INFO] SELECT `LOCKED` FROM liquibasechangeloglock WHERE ID=1
10-Aug-2021 20:36:37 [INFO] Successfully acquired change log lock
10-Aug-2021 20:36:37 [INFO] SELECT MD5SUM FROM liquibasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1
10-Aug-2021 20:36:37 [INFO] SELECT COUNT(*) FROM liquibasechangelog
10-Aug-2021 20:36:37 [INFO] Reading from liquibasechangelog
10-Aug-2021 20:36:37 [INFO] SELECT * FROM liquibasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
10-Aug-2021 20:36:37 [INFO] UPDATE liquibasechangelog SET MD5SUM = '8:09633454c8c1886bef9d023e65afe738' WHERE ID = 'referenceapp-set-admin-password' AND AUTHOR = 'raff' AND FILENAME = 'src/main/db/liquibase-standalone-data.xml'
10-Aug-2021 20:36:37 [INFO] UPDATE liquibasechangelog SET MD5SUM = '8:def7344e6bde8a1ef2cbbe7bb95aad91' WHERE ID = 'referenceapp-set-scheduler-username' AND AUTHOR = 'raff' AND FILENAME = 'src/main/db/liquibase-standalone-data.xml'
10-Aug-2021 20:36:37 [INFO] UPDATE liquibasechangelog SET MD5SUM = '8:56237c4576edb5a1f2528136265bb72b' WHERE ID = 'referenceapp-set-scheduler-password' AND AUTHOR = 'raff' AND FILENAME = 'src/main/db/liquibase-standalone-data.xml'
10-Aug-2021 20:36:37 [INFO] SELECT COUNT(*) FROM liquibasechangelog
10-Aug-2021 20:36:37 [INFO] Reading from liquibasechangelog
10-Aug-2021 20:36:37 [INFO] SELECT * FROM liquibasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
10-Aug-2021 20:36:37 [INFO] Successfully released change log lock
10-Aug-2021 20:36:37 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:36:37 [INFO]
10-Aug-2021 20:36:37 [INFO]
10-Aug-2021 20:36:37 [INFO] --- openmrs-sdk-maven-plugin:3.9.0:build-distro (build-distro) @ referenceapplication-standalone ---
10-Aug-2021 20:36:40 [INFO] Configured Artifact: org.openmrs.distro:referenceapplication-package:2.12.0-SNAPSHOT:jar
10-Aug-2021 20:36:41 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/distro/referenceapplication-package/2.12.0-SNAPSHOT/maven-metadata.xml
10-Aug-2021 20:43:03 [WARNING] Could not transfer metadata org.openmrs.distro:referenceapplication-package:2.12.0-SNAPSHOT/maven-metadata.xml from/to openmrs-repo (http://mavenrepo.openmrs.org/nexus/content/repositories/public): Connect to openmrs.jfrog.io:443 [openmrs.jfrog.io/54.229.110.245, openmrs.jfrog.io/54.170.66.44, openmrs.jfrog.io/54.195.244.87] failed: Connection timed out (Connection timed out)
10-Aug-2021 20:43:03 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/distro/referenceapplication-package/2.12.0-SNAPSHOT/referenceapplication-package-2.12.0-SNAPSHOT.jar
10-Aug-2021 20:49:25 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:49:25 [INFO] BUILD FAILURE
10-Aug-2021 20:49:25 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:49:25 [INFO] Total time: 15:30 min
10-Aug-2021 20:49:25 [INFO] Finished at: 2021-08-10T20:49:25+00:00
10-Aug-2021 20:49:26 [INFO] Final Memory: 48M/1251M
10-Aug-2021 20:49:26 [INFO] ------------------------------------------------------------------------
10-Aug-2021 20:49:26 [ERROR] Failed to execute goal org.openmrs.maven.plugins:openmrs-sdk-maven-plugin:3.9.0:build-distro (build-distro) on project referenceapplication-standalone: Unable to execute mojo: Unable to resolve artifact. Could not transfer artifact org.openmrs.distro:referenceapplication-package:jar:2.12.0-SNAPSHOT from/to openmrs-repo (http://mavenrepo.openmrs.org/nexus/content/repositories/public): Connect to openmrs.jfrog.io:443 [openmrs.jfrog.io/54.195.244.87, openmrs.jfrog.io/54.170.66.44, openmrs.jfrog.io/54.229.110.245] failed: Connection timed out (Connection timed out)
10-Aug-2021 20:49:26 [ERROR] org.openmrs.distro:referenceapplication-package:jar:2.12.0-SNAPSHOT
10-Aug-2021 20:49:26 [ERROR]
10-Aug-2021 20:49:26 [ERROR] from the specified remote repositories:
10-Aug-2021 20:49:26 [ERROR] openmrs-repo (http://mavenrepo.openmrs.org/nexus/content/repositories/public, releases=true, snapshots=true),
10-Aug-2021 20:49:26 [ERROR] central (https://repo.maven.apache.org/maven2, releases=true, snapshots=false)
10-Aug-2021 20:49:26 [ERROR] -> [Help 1]
10-Aug-2021 20:49:26 [ERROR]
10-Aug-2021 20:49:26 [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
10-Aug-2021 20:49:26 [ERROR] Re-run Maven using the -X switch to enable full debug logging.
10-Aug-2021 20:49:26 [ERROR]
10-Aug-2021 20:49:26 [ERROR] For more information about the errors and possible solutions, please read the following articles:
10-Aug-2021 20:49:26 [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
10-Aug-2021 20:49:26 Failing task since return code of [/usr/share/apache-maven-3.3.9/bin/mvn --batch-mode -Djava.io.tmpdir=/home/bamboo-agent/bamboo-agent/.agent_tmp/REFAPP-OMODDISTRO-TS clean package -Dopenmrs.version=2.4.0 -Drefapp.version=2.12.0-SNAPSHOT -U] was 1 while expected 0
10-Aug-2021 20:49:26 Finished task 'Package Standalone' with result: Failed
10-Aug-2021 20:49:26 Running post build plugin 'Docker Container Cleanup'
10-Aug-2021 20:49:26 Running post build plugin 'NCover Results Collector'
10-Aug-2021 20:49:26 Running post build plugin 'Clover Results Collector'
10-Aug-2021 20:49:26 Running post build plugin 'Sauce OnDemand Post Runner'
10-Aug-2021 20:49:26 Running post build plugin 'npm Cache Cleanup'
10-Aug-2021 20:49:26 Running post build plugin 'Artifact Copier'
10-Aug-2021 20:49:26 Publishing an artifact: referenceapplication-standalone-snapshot
10-Aug-2021 20:49:26 Unable to publish artifact [referenceapplication-standalone-snapshot]:
10-Aug-2021 20:49:26 The artifact hasn't been successfully published after 17.55 ms
10-Aug-2021 20:49:26 Finalising the build...
10-Aug-2021 20:49:26 Stopping timer.
10-Aug-2021 20:49:26 Build REFAPP-OMODDISTRO-TS-11646 completed.
10-Aug-2021 20:49:26 Running on server: post build plugin 'NCover Results Collector'
10-Aug-2021 20:49:26 Running on server: post build plugin 'Build Hanging Detection Configuration'
10-Aug-2021 20:49:26 Running on server: post build plugin 'Clover Delta Calculator'
10-Aug-2021 20:49:27 Running on server: post build plugin 'Maven Dependencies Postprocessor'
10-Aug-2021 20:49:27 All post build plugins have finished
10-Aug-2021 20:49:27 Generating build results summary...
10-Aug-2021 20:49:27 Saving build results to disk...
10-Aug-2021 20:49:27 Logging substituted variables...
10-Aug-2021 20:49:27 Indexing build results...
10-Aug-2021 20:49:27 Finished building REFAPP-OMODDISTRO-TS-11646.