Build #11,647

Deploys Reference Application SNAPSHOT to maven

Build: #11647 was successful

Job: Build standalone was successful

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,399 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 22:50:52 [INFO] /*!40000 ALTER TABLE `role_privilege` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `role_role`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `role_role`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `role_role` (
10-Aug-2021 22:50:52   `parent_role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 22:50:52   `child_role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 22:50:52   PRIMARY KEY (`parent_role`,`child_role`),
10-Aug-2021 22:50:52   KEY `inherited_role` (`child_role`),
10-Aug-2021 22:50:52   CONSTRAINT `inherited_role` FOREIGN KEY (`child_role`) REFERENCES `role` (`role`),
10-Aug-2021 22:50:52   CONSTRAINT `parent_role` FOREIGN KEY (`parent_role`) REFERENCES `role` (`role`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `role_role`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `role_role` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `role_role` DISABLE KEYS */
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] /*!40000 ALTER TABLE `role_role` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `scheduler_task_config`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `scheduler_task_config`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `scheduler_task_config` (
10-Aug-2021 22:50:52   `task_config_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `name` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `description` varchar(1024) DEFAULT NULL,
10-Aug-2021 22:50:52   `schedulable_class` text,
10-Aug-2021 22:50:52   `start_time` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `start_time_pattern` varchar(50) DEFAULT NULL,
10-Aug-2021 22:50:52   `repeat_interval` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `start_on_startup` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `started` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `created_by` int(11) DEFAULT '0',
10-Aug-2021 22:50:52   `date_created` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `last_execution_time` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `uuid` char(38) NOT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`task_config_id`),
10-Aug-2021 22:50:52   UNIQUE KEY `scheduler_task_config_uuid_index` (`uuid`),
10-Aug-2021 22:50:52   KEY `scheduler_changer` (`changed_by`),
10-Aug-2021 22:50:52   KEY `scheduler_creator` (`created_by`),
10-Aug-2021 22:50:52   CONSTRAINT `scheduler_changer` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `scheduler_creator` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `scheduler_task_config`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52 -- Since updating Liquibase from version 2.0.5 to version 3.8.9, the insert statement leaves an 'in_use' entry
10-Aug-2021 22:50:52 -- in the MySQL database which breaks the build:
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52 --    mysql> show open tables where in_use>0;
10-Aug-2021 22:50:52 --    +-----------------------+-----------------------+--------+-------------+
10-Aug-2021 22:50:52 --    | Database              | Table                 | In_use | Name_locked |
10-Aug-2021 22:50:52 --    +-----------------------+-----------------------+--------+-------------+
10-Aug-2021 22:50:52 --    | openmrs_demo_database | scheduler_task_config |      1 |           0 |
10-Aug-2021 22:50:52 --    +-----------------------+-----------------------+--------+-------------+
10-Aug-2021 22:50:52 --    1 row in set (0.00 sec)
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52 -- The insert statement was commented out and replaced by an equivalent changeset in src/main/db/liquibase-demo-data.xml.
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52 --    LOCK TABLES `scheduler_task_config` WRITE;
10-Aug-2021 22:50:52 --    /*!40000 ALTER TABLE `scheduler_task_config` DISABLE KEYS */;
10-Aug-2021 22:50:52 --    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 22:50:52 --    /*!40000 ALTER TABLE `scheduler_task_config` ENABLE KEYS */;
10-Aug-2021 22:50:52 --    UNLOCK TABLES;
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52 -- Table structure for table `scheduler_task_config_property`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `scheduler_task_config_property`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `scheduler_task_config_property` (
10-Aug-2021 22:50:52   `task_config_property_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `name` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `value` text,
10-Aug-2021 22:50:52   `task_config_id` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`task_config_property_id`),
10-Aug-2021 22:50:52   KEY `task_config_for_property` (`task_config_id`),
10-Aug-2021 22:50:52   CONSTRAINT `task_config_for_property` FOREIGN KEY (`task_config_id`) REFERENCES `scheduler_task_config` (`task_config_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `scheduler_task_config_property`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `scheduler_task_config_property` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `scheduler_task_config_property` DISABLE KEYS */
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `scheduler_task_config_property` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `serialized_object`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `serialized_object`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `serialized_object` (
10-Aug-2021 22:50:52   `serialized_object_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `name` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `description` varchar(5000) DEFAULT NULL,
10-Aug-2021 22:50:52   `type` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `subtype` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `serialization_class` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `serialized_data` mediumtext NOT NULL,
10-Aug-2021 22:50:52   `date_created` datetime NOT NULL,
10-Aug-2021 22:50:52   `creator` int(11) NOT NULL,
10-Aug-2021 22:50:52   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `retire_reason` varchar(1000) DEFAULT NULL,
10-Aug-2021 22:50:52   `uuid` char(38) NOT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`serialized_object_id`),
10-Aug-2021 22:50:52   UNIQUE KEY `serialized_object_uuid_index` (`uuid`),
10-Aug-2021 22:50:52   KEY `serialized_object_creator` (`creator`),
10-Aug-2021 22:50:52   KEY `serialized_object_changed_by` (`changed_by`),
10-Aug-2021 22:50:52   KEY `serialized_object_retired_by` (`retired_by`),
10-Aug-2021 22:50:52   CONSTRAINT `serialized_object_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `serialized_object_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `serialized_object_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `serialized_object`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `serialized_object` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `serialized_object` DISABLE KEYS */
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] /*!40000 ALTER TABLE `serialized_object` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `test_order`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `test_order`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `test_order` (
10-Aug-2021 22:50:52   `order_id` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `specimen_source` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `laterality` varchar(20) DEFAULT NULL,
10-Aug-2021 22:50:52   `clinical_history` text,
10-Aug-2021 22:50:52   `frequency` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `number_of_repeats` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`order_id`),
10-Aug-2021 22:50:52   KEY `test_order_specimen_source_fk` (`specimen_source`),
10-Aug-2021 22:50:52   KEY `test_order_frequency_fk` (`frequency`),
10-Aug-2021 22:50:52   CONSTRAINT `test_order_frequency_fk` FOREIGN KEY (`frequency`) REFERENCES `order_frequency` (`order_frequency_id`),
10-Aug-2021 22:50:52   CONSTRAINT `test_order_order_id_fk` FOREIGN KEY (`order_id`) REFERENCES `orders` (`order_id`),
10-Aug-2021 22:50:52   CONSTRAINT `test_order_specimen_source_fk` FOREIGN KEY (`specimen_source`) REFERENCES `concept` (`concept_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `test_order`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `test_order` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `test_order` DISABLE KEYS */
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `test_order` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `uiframework_user_defined_page_view`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `uiframework_user_defined_page_view`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `uiframework_user_defined_page_view` (
10-Aug-2021 22:50:52   `page_view_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `name` varchar(100) NOT NULL,
10-Aug-2021 22:50:52   `template_type` varchar(50) NOT NULL,
10-Aug-2021 22:50:52   `template_text` mediumtext NOT NULL,
10-Aug-2021 22:50:52   `uuid` varchar(38) NOT NULL,
10-Aug-2021 22:50:52   `creator` int(11) NOT NULL,
10-Aug-2021 22:50:52   `date_created` datetime NOT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`page_view_id`),
10-Aug-2021 22:50:52   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 22:50:52   UNIQUE KEY `name` (`name`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `uiframework_user_defined_page_view`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `uiframework_user_defined_page_view` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `uiframework_user_defined_page_view` DISABLE KEYS */
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `uiframework_user_defined_page_view` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `user_property`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `user_property`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `user_property` (
10-Aug-2021 22:50:52   `user_id` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `property` varchar(100) NOT NULL DEFAULT '',
10-Aug-2021 22:50:52   `property_value` varchar(255) NOT NULL DEFAULT '',
10-Aug-2021 22:50:52   PRIMARY KEY (`user_id`,`property`),
10-Aug-2021 22:50:52   CONSTRAINT `user_property_to_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `user_property`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `user_property` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `user_property` DISABLE KEYS */
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] /*!40000 ALTER TABLE `user_property` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `user_role`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `user_role`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `user_role` (
10-Aug-2021 22:50:52   `user_id` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `role` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 22:50:52   PRIMARY KEY (`role`,`user_id`),
10-Aug-2021 22:50:52   KEY `user_role_to_users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `role_definitions` FOREIGN KEY (`role`) REFERENCES `role` (`role`),
10-Aug-2021 22:50:52   CONSTRAINT `user_role_to_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `user_role`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `user_role` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `user_role` DISABLE KEYS */
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] /*!40000 ALTER TABLE `user_role` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `users`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `users`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `users` (
10-Aug-2021 22:50:52   `user_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `system_id` varchar(50) NOT NULL DEFAULT '',
10-Aug-2021 22:50:52   `username` varchar(50) DEFAULT NULL,
10-Aug-2021 22:50:52   `password` varchar(128) DEFAULT NULL,
10-Aug-2021 22:50:52   `salt` varchar(128) DEFAULT NULL,
10-Aug-2021 22:50:52   `secret_question` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `secret_answer` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `creator` int(11) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `date_created` datetime NOT NULL,
10-Aug-2021 22:50:52   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `person_id` int(11) NOT NULL,
10-Aug-2021 22:50:52   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `uuid` char(38) NOT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`user_id`),
10-Aug-2021 22:50:52   KEY `user_who_changed_user` (`changed_by`),
10-Aug-2021 22:50:52   KEY `user_creator` (`creator`),
10-Aug-2021 22:50:52   KEY `user_who_retired_this_user` (`retired_by`),
10-Aug-2021 22:50:52   KEY `person_id_for_user` (`person_id`),
10-Aug-2021 22:50:52   CONSTRAINT `person_id_for_user` FOREIGN KEY (`person_id`) REFERENCES `person` (`person_id`),
10-Aug-2021 22:50:52   CONSTRAINT `user_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `user_who_changed_user` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `user_who_retired_this_user` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `users`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `users` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `users` DISABLE KEYS */
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] /*!40000 ALTER TABLE `users` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `visit`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `visit`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `visit` (
10-Aug-2021 22:50:52   `visit_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `patient_id` int(11) NOT NULL,
10-Aug-2021 22:50:52   `visit_type_id` int(11) NOT NULL,
10-Aug-2021 22:50:52   `date_started` datetime NOT NULL,
10-Aug-2021 22:50:52   `date_stopped` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `indication_concept_id` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `location_id` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `creator` int(11) NOT NULL,
10-Aug-2021 22:50:52   `date_created` datetime NOT NULL,
10-Aug-2021 22:50:52   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `voided` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `voided_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_voided` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `void_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `uuid` char(38) NOT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`visit_id`),
10-Aug-2021 22:50:52   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 22:50:52   KEY `visit_patient_index` (`patient_id`),
10-Aug-2021 22:50:52   KEY `visit_type_fk` (`visit_type_id`),
10-Aug-2021 22:50:52   KEY `visit_location_fk` (`location_id`),
10-Aug-2021 22:50:52   KEY `visit_creator_fk` (`creator`),
10-Aug-2021 22:50:52   KEY `visit_voided_by_fk` (`voided_by`),
10-Aug-2021 22:50:52   KEY `visit_changed_by_fk` (`changed_by`),
10-Aug-2021 22:50:52   KEY `visit_indication_concept_fk` (`indication_concept_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_changed_by_fk` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_creator_fk` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_indication_concept_fk` FOREIGN KEY (`indication_concept_id`) REFERENCES `concept` (`concept_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_location_fk` FOREIGN KEY (`location_id`) REFERENCES `location` (`location_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_patient_fk` FOREIGN KEY (`patient_id`) REFERENCES `patient` (`patient_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_type_fk` FOREIGN KEY (`visit_type_id`) REFERENCES `visit_type` (`visit_type_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_voided_by_fk` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB AUTO_INCREMENT=509 DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `visit`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `visit` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `visit` DISABLE KEYS */
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] /*!40000 ALTER TABLE `visit` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `visit_attribute`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `visit_attribute`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `visit_attribute` (
10-Aug-2021 22:50:52   `visit_attribute_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `visit_id` int(11) NOT NULL,
10-Aug-2021 22:50:52   `attribute_type_id` int(11) NOT NULL,
10-Aug-2021 22:50:52   `value_reference` text NOT NULL,
10-Aug-2021 22:50:52   `uuid` char(38) NOT NULL,
10-Aug-2021 22:50:52   `creator` int(11) NOT NULL,
10-Aug-2021 22:50:52   `date_created` datetime NOT NULL,
10-Aug-2021 22:50:52   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `voided` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `voided_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_voided` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `void_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`visit_attribute_id`),
10-Aug-2021 22:50:52   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 22:50:52   KEY `visit_attribute_visit_fk` (`visit_id`),
10-Aug-2021 22:50:52   KEY `visit_attribute_attribute_type_id_fk` (`attribute_type_id`),
10-Aug-2021 22:50:52   KEY `visit_attribute_creator_fk` (`creator`),
10-Aug-2021 22:50:52   KEY `visit_attribute_changed_by_fk` (`changed_by`),
10-Aug-2021 22:50:52   KEY `visit_attribute_voided_by_fk` (`voided_by`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_attribute_type_id_fk` FOREIGN KEY (`attribute_type_id`) REFERENCES `visit_attribute_type` (`visit_attribute_type_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_changed_by_fk` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_creator_fk` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_visit_fk` FOREIGN KEY (`visit_id`) REFERENCES `visit` (`visit_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_voided_by_fk` FOREIGN KEY (`voided_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `visit_attribute`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `visit_attribute` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `visit_attribute` DISABLE KEYS */
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `visit_attribute` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `visit_attribute_type`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `visit_attribute_type`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `visit_attribute_type` (
10-Aug-2021 22:50:52   `visit_attribute_type_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `name` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `description` varchar(1024) DEFAULT NULL,
10-Aug-2021 22:50:52   `datatype` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `datatype_config` text,
10-Aug-2021 22:50:52   `preferred_handler` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `handler_config` text,
10-Aug-2021 22:50:52   `min_occurs` int(11) NOT NULL,
10-Aug-2021 22:50:52   `max_occurs` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `creator` int(11) NOT NULL,
10-Aug-2021 22:50:52   `date_created` datetime NOT NULL,
10-Aug-2021 22:50:52   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `uuid` char(38) NOT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`visit_attribute_type_id`),
10-Aug-2021 22:50:52   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 22:50:52   KEY `visit_attribute_type_creator_fk` (`creator`),
10-Aug-2021 22:50:52   KEY `visit_attribute_type_changed_by_fk` (`changed_by`),
10-Aug-2021 22:50:52   KEY `visit_attribute_type_retired_by_fk` (`retired_by`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_type_changed_by_fk` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_type_creator_fk` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_attribute_type_retired_by_fk` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `visit_attribute_type`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `visit_attribute_type` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `visit_attribute_type` DISABLE KEYS */
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `visit_attribute_type` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Table structure for table `visit_type`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 DROP TABLE IF EXISTS `visit_type`
10-Aug-2021 22:50:52 [INFO] /*!40101 SET @saved_cs_client     = @@character_set_client */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = utf8 */
10-Aug-2021 22:50:52 [INFO] CREATE TABLE `visit_type` (
10-Aug-2021 22:50:52   `visit_type_id` int(11) NOT NULL AUTO_INCREMENT,
10-Aug-2021 22:50:52   `name` varchar(255) NOT NULL,
10-Aug-2021 22:50:52   `description` varchar(1024) DEFAULT NULL,
10-Aug-2021 22:50:52   `creator` int(11) NOT NULL,
10-Aug-2021 22:50:52   `date_created` datetime NOT NULL,
10-Aug-2021 22:50:52   `changed_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_changed` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `retired` tinyint(1) NOT NULL DEFAULT '0',
10-Aug-2021 22:50:52   `retired_by` int(11) DEFAULT NULL,
10-Aug-2021 22:50:52   `date_retired` datetime DEFAULT NULL,
10-Aug-2021 22:50:52   `retire_reason` varchar(255) DEFAULT NULL,
10-Aug-2021 22:50:52   `uuid` char(38) NOT NULL,
10-Aug-2021 22:50:52   PRIMARY KEY (`visit_type_id`),
10-Aug-2021 22:50:52   UNIQUE KEY `uuid` (`uuid`),
10-Aug-2021 22:50:52   KEY `visit_type_creator` (`creator`),
10-Aug-2021 22:50:52   KEY `visit_type_changed_by` (`changed_by`),
10-Aug-2021 22:50:52   KEY `visit_type_retired_by` (`retired_by`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_type_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_type_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
10-Aug-2021 22:50:52   CONSTRAINT `visit_type_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
10-Aug-2021 22:50:52 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
10-Aug-2021 22:50:52 [INFO] /*!40101 SET character_set_client = @saved_cs_client */
10-Aug-2021 22:50:52 [INFO] --
10-Aug-2021 22:50:52 -- Dumping data for table `visit_type`
10-Aug-2021 22:50:52 --
10-Aug-2021 22:50:52
10-Aug-2021 22:50:52 LOCK TABLES `visit_type` WRITE
10-Aug-2021 22:50:52 [INFO] /*!40000 ALTER TABLE `visit_type` DISABLE KEYS */
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] /*!40000 ALTER TABLE `visit_type` ENABLE KEYS */
10-Aug-2021 22:50:52 [INFO] UNLOCK TABLES
10-Aug-2021 22:50:52 [INFO] /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET SQL_MODE=@OLD_SQL_MODE */
10-Aug-2021 22:50:52 [INFO] /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */
10-Aug-2021 22:50:52 [INFO] /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */
10-Aug-2021 22:50:52 [INFO] /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */
10-Aug-2021 22:50:52 [INFO] /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */
10-Aug-2021 22:50:52 [INFO] -- Dump completed on 2017-05-02 15:47:26
10-Aug-2021 22:50:52 [INFO] SQL in file src/main/db/demo-db-2.6.0.sql executed
10-Aug-2021 22:50:52 [INFO] ChangeSet src/main/db/liquibase-demo-data.xml::20170502-1600::standalone ran successfully in 15064ms
10-Aug-2021 22:50:52 [INFO] SELECT MAX(ORDEREXECUTED) FROM liquibasechangelog
10-Aug-2021 22:50:52 [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', '8635837615')
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] New row inserted into scheduler_task_config
10-Aug-2021 22:50:52 [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 22:50:52 [INFO] New row inserted into scheduler_task_config
10-Aug-2021 22:50:52 [INFO] ChangeSet src/main/db/liquibase-demo-data.xml::1582473679024-24::wolf (hand-rolled) ran successfully in 10ms
10-Aug-2021 22:50:52 [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', '8635837615')
10-Aug-2021 22:50:52 [INFO] Successfully released change log lock
10-Aug-2021 22:50:52 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:52 [INFO]
10-Aug-2021 22:50:52 [INFO]
10-Aug-2021 22:50:52 [INFO] --- liquibase-maven-plugin:3.8.9:update (demo-database-update-to-latest) @ referenceapplication-standalone ---
10-Aug-2021 22:50:52 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:52 [INFO] Loading artifacts into URLClassLoader
10-Aug-2021 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [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 22:50:52 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/javax/inject/javax.inject/1/javax.inject-1.jar
10-Aug-2021 22:50:52 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/classes
10-Aug-2021 22:50:52 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/test-classes
10-Aug-2021 22:50:52 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:52 [INFO]
10-Aug-2021 22:50:52 [INFO]
10-Aug-2021 22:50:52 [INFO] Liquibase Community 3.8.9 by Datical
10-Aug-2021 22:50:52 [INFO] Starting Liquibase at Tue, 10 Aug 2021 22:50:52 UTC (version 3.8.9 #73 built at Mon Apr 06 09:32:58 UTC 2020)
10-Aug-2021 22:50:52 [INFO] Settings
10-Aug-2021 22:50:52 ----------------------------
10-Aug-2021 22:50:52 [INFO]     driver: com.mysql.jdbc.Driver
10-Aug-2021 22:50:52 [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 22:50:52 [INFO]     username: openmrs
10-Aug-2021 22:50:52 [INFO]     password: *****
10-Aug-2021 22:50:52 [INFO]     use empty password: false
10-Aug-2021 22:50:52 [INFO]     properties file: null
10-Aug-2021 22:50:52 [INFO]     properties file will override? false
10-Aug-2021 22:50:52 [INFO]     prompt on non-local database? true
10-Aug-2021 22:50:52 [INFO]     clear checksums? false
10-Aug-2021 22:50:52 [INFO]     changeLogDirectory: null
10-Aug-2021 22:50:52 [INFO]     changeLogFile: liquibase-update-to-latest.xml
10-Aug-2021 22:50:52 [INFO]     context(s): null
10-Aug-2021 22:50:52 [INFO]     label(s): null
10-Aug-2021 22:50:52 [INFO]     number of changes to apply: 0
10-Aug-2021 22:50:52 [INFO]     drop first? false
10-Aug-2021 22:50:52 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:53 [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 22:50:53 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 22:50:53 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 22:50:53 [INFO] SELECT `LOCKED` FROM liquibasechangeloglock WHERE ID=1
10-Aug-2021 22:50:53 [INFO] Successfully acquired change log lock
10-Aug-2021 22:50:53 [INFO] SELECT MD5SUM FROM liquibasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1
10-Aug-2021 22:50:53 [INFO] UPDATE liquibasechangelog SET MD5SUM = NULL
10-Aug-2021 22:50:53 [INFO] SELECT COUNT(*) FROM liquibasechangelog
10-Aug-2021 22:50:53 [INFO] Reading from liquibasechangelog
10-Aug-2021 22:50:53 [INFO] SELECT * FROM liquibasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
10-Aug-2021 22:50:53 [INFO] ALTER TABLE order_group ADD order_group_reason INT NULL
10-Aug-2021 22:50:53 [INFO] Columns order_group_reason(int) added to order_group
10-Aug-2021 22:50:53 [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 22:50:53 [INFO] Foreign key constraint added to order_group (order_group_reason)
10-Aug-2021 22:50:53 [INFO] ChangeSet liquibase-update-to-latest.xml::20190815-Trunk-5412::gitacliff ran successfully in 273ms
10-Aug-2021 22:50:53 [INFO] SELECT MAX(ORDEREXECUTED) FROM liquibasechangelog
10-Aug-2021 22:50:53 [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', '8635853501')
10-Aug-2021 22:50:53 [INFO] ALTER TABLE order_group ADD parent_order_group INT NULL
10-Aug-2021 22:50:53 [INFO] Columns parent_order_group(int) added to order_group
10-Aug-2021 22:50:53 [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 22:50:53 [INFO] Foreign key constraint added to order_group (parent_order_group)
10-Aug-2021 22:50:53 [INFO] ChangeSet liquibase-update-to-latest.xml::20190815-Trunk-5650::gitacliff ran successfully in 66ms
10-Aug-2021 22:50:53 [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', '8635853501')
10-Aug-2021 22:50:53 [INFO] ALTER TABLE conditions ADD encounter_id INT NULL
10-Aug-2021 22:50:54 [INFO] Columns encounter_id(int) added to conditions
10-Aug-2021 22:50:54 [INFO] ALTER TABLE conditions ADD CONSTRAINT conditions_encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES encounter (encounter_id)
10-Aug-2021 22:50:54 [INFO] Foreign key constraint added to conditions (encounter_id)
10-Aug-2021 22:50:54 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5728-2020-05-20::samuel34 ran successfully in 45ms
10-Aug-2021 22:50:54 [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', '8635853501')
10-Aug-2021 22:50:54 [INFO] ALTER TABLE order_group ADD previous_order_group INT NULL
10-Aug-2021 22:50:54 [INFO] Columns previous_order_group(int) added to order_group
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_group (previous_order_group)
10-Aug-2021 22:50:54 [INFO] ChangeSet liquibase-update-to-latest.xml::20190815-Trunk-5651::gitacliff ran successfully in 48ms
10-Aug-2021 22:50:54 [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', '8635853501')
10-Aug-2021 22:50:54 [INFO] ALTER TABLE conditions ADD form_namespace_and_path VARCHAR(255) NULL
10-Aug-2021 22:50:54 [INFO] Columns form_namespace_and_path(varchar(255)) added to conditions
10-Aug-2021 22:50:54 [INFO] ChangeSet liquibase-update-to-latest.xml::20200714-Trunk-5862::loliveira ran successfully in 46ms
10-Aug-2021 22:50:54 [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', '8635853501')
10-Aug-2021 22:50:54 [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 (name), UNIQUE (uuid))
10-Aug-2021 22:50:54 [INFO] Table order_set_attribute_type created
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_set_attribute_type (creator)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_set_attribute_type (changed_by)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_set_attribute_type (retired_by)
10-Aug-2021 22:50:54 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5835-2020-07-09-1600::gitacliff ran successfully in 100ms
10-Aug-2021 22:50:54 [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', '8635853501')
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Table order_set_attribute created
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_set_attribute (order_set_id)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_set_attribute (attribute_type_id)
10-Aug-2021 22:50:54 [INFO] ALTER TABLE order_set_attribute ADD CONSTRAINT order_set_attribute_creator_fk FOREIGN KEY (creator) REFERENCES users (user_id)
10-Aug-2021 22:50:54 [INFO] Foreign key constraint added to order_set_attribute (creator)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_set_attribute (changed_by)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_set_attribute (voided_by)
10-Aug-2021 22:50:54 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5835-2020-07-09-1700::gitacliff ran successfully in 148ms
10-Aug-2021 22:50:54 [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', '8635853501')
10-Aug-2021 22:50:54 [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 (name), UNIQUE (uuid))
10-Aug-2021 22:50:54 [INFO] Table order_group_attribute_type created
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_group_attribute_type (creator)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_group_attribute_type (changed_by)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_group_attribute_type (retired_by)
10-Aug-2021 22:50:54 [INFO] ChangeSet liquibase-update-to-latest.xml::TRUNK-5410::tendomart ran successfully in 493ms
10-Aug-2021 22:50:54 [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', '8635853501')
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Table order_group_attribute created
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_group_attribute (order_group_id)
10-Aug-2021 22:50:54 [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 22:50:54 [INFO] Foreign key constraint added to order_group_attribute (attribute_type_id)
10-Aug-2021 22:50:55 [INFO] ALTER TABLE order_group_attribute ADD CONSTRAINT order_group_attribute_creator_fk FOREIGN KEY (creator) REFERENCES users (user_id)
10-Aug-2021 22:50:55 [INFO] Foreign key constraint added to order_group_attribute (creator)
10-Aug-2021 22:50:55 [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 22:50:55 [INFO] Foreign key constraint added to order_group_attribute (changed_by)
10-Aug-2021 22:50:55 [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 22:50:55 [INFO] Foreign key constraint added to order_group_attribute (voided_by)
10-Aug-2021 22:50:55 [INFO] ChangeSet liquibase-update-to-latest.xml::20200723-TRUNK-5410::tendomart ran successfully in 142ms
10-Aug-2021 22:50:55 [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', '8635853501')
10-Aug-2021 22:50:55 [INFO] CREATE INDEX orders_order_number ON orders(order_number)
10-Aug-2021 22:50:56 [INFO] Index orders_order_number created
10-Aug-2021 22:50:56 [INFO] ChangeSet liquibase-update-to-latest.xml::2020-08-31-2200-TRUNK-5821::miirochristopher ran successfully in 1165ms
10-Aug-2021 22:50:56 [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', '8635853501')
10-Aug-2021 22:50:56 [INFO] CREATE INDEX orders_accession_number ON orders(accession_number)
10-Aug-2021 22:50:56 [INFO] Index orders_accession_number created
10-Aug-2021 22:50:56 [INFO] ChangeSet liquibase-update-to-latest.xml::2020-08-32-100-TRUNK-5821::miirochristopher ran successfully in 319ms
10-Aug-2021 22:50:56 [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', '8635853501')
10-Aug-2021 22:50:56 [INFO] Successfully released change log lock
10-Aug-2021 22:50:56 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:56 [INFO]
10-Aug-2021 22:50:56 [INFO]
10-Aug-2021 22:50:56 [INFO] --- liquibase-maven-plugin:3.8.9:update (demo-database-add-standalone-data) @ referenceapplication-standalone ---
10-Aug-2021 22:50:56 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:56 [INFO] Loading artifacts into URLClassLoader
10-Aug-2021 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [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 22:50:56 [INFO]   artifact: file:/home/bamboo-agent/.m2/repository/javax/inject/javax.inject/1/javax.inject-1.jar
10-Aug-2021 22:50:56 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/classes
10-Aug-2021 22:50:56 [INFO]   artifact: file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/test-classes
10-Aug-2021 22:50:56 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:56 [INFO]
10-Aug-2021 22:50:56 [INFO]
10-Aug-2021 22:50:56 [INFO] Liquibase Community 3.8.9 by Datical
10-Aug-2021 22:50:56 [INFO] Starting Liquibase at Tue, 10 Aug 2021 22:50:56 UTC (version 3.8.9 #73 built at Mon Apr 06 09:32:58 UTC 2020)
10-Aug-2021 22:50:56 [INFO] Settings
10-Aug-2021 22:50:56 ----------------------------
10-Aug-2021 22:50:56 [INFO]     driver: com.mysql.jdbc.Driver
10-Aug-2021 22:50:56 [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 22:50:56 [INFO]     username: openmrs
10-Aug-2021 22:50:56 [INFO]     password: *****
10-Aug-2021 22:50:56 [INFO]     use empty password: false
10-Aug-2021 22:50:56 [INFO]     properties file: null
10-Aug-2021 22:50:56 [INFO]     properties file will override? false
10-Aug-2021 22:50:56 [INFO]     prompt on non-local database? true
10-Aug-2021 22:50:56 [INFO]     clear checksums? false
10-Aug-2021 22:50:56 [INFO]     changeLogDirectory: null
10-Aug-2021 22:50:56 [INFO]     changeLogFile: src/main/db/liquibase-standalone-data.xml
10-Aug-2021 22:50:56 [INFO]     context(s): null
10-Aug-2021 22:50:56 [INFO]     label(s): null
10-Aug-2021 22:50:56 [INFO]     number of changes to apply: 0
10-Aug-2021 22:50:56 [INFO]     drop first? false
10-Aug-2021 22:50:56 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:56 [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 22:50:56 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 22:50:56 [INFO] SELECT COUNT(*) FROM liquibasechangeloglock
10-Aug-2021 22:50:56 [INFO] SELECT `LOCKED` FROM liquibasechangeloglock WHERE ID=1
10-Aug-2021 22:50:56 [INFO] Successfully acquired change log lock
10-Aug-2021 22:50:56 [INFO] SELECT MD5SUM FROM liquibasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1
10-Aug-2021 22:50:56 [INFO] SELECT COUNT(*) FROM liquibasechangelog
10-Aug-2021 22:50:56 [INFO] Reading from liquibasechangelog
10-Aug-2021 22:50:56 [INFO] SELECT * FROM liquibasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
10-Aug-2021 22:50:57 [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 22:50:57 [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 22:50:57 [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 22:50:57 [INFO] SELECT COUNT(*) FROM liquibasechangelog
10-Aug-2021 22:50:57 [INFO] Reading from liquibasechangelog
10-Aug-2021 22:50:57 [INFO] SELECT * FROM liquibasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
10-Aug-2021 22:50:57 [INFO] Successfully released change log lock
10-Aug-2021 22:50:57 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:50:57 [INFO]
10-Aug-2021 22:50:57 [INFO]
10-Aug-2021 22:50:57 [INFO] --- openmrs-sdk-maven-plugin:3.9.0:build-distro (build-distro) @ referenceapplication-standalone ---
10-Aug-2021 22:51:01 [INFO] Configured Artifact: org.openmrs.distro:referenceapplication-package:2.12.0-SNAPSHOT:jar
10-Aug-2021 22:51:02 [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 22:51:04 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/distro/referenceapplication-package/2.12.0-SNAPSHOT/maven-metadata.xml (2 KB at 0.7 KB/sec)
10-Aug-2021 22:51:04 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/distro/referenceapplication-package/2.12.0-SNAPSHOT/referenceapplication-package-2.12.0-20210810.223344-992.jar
10-Aug-2021 22:51:06 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/distro/referenceapplication-package/2.12.0-SNAPSHOT/referenceapplication-package-2.12.0-20210810.223344-992.jar (286 KB at 201.0 KB/sec)
10-Aug-2021 22:51:06 [INFO] Copying referenceapplication-package-2.12.0-SNAPSHOT.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/openmrs-distro.jar
10-Aug-2021 22:51:06
10-Aug-2021 22:51:06 Downloading modules...
10-Aug-2021 22:51:06
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.web:openmrs-webapp:2.4.0:war
10-Aug-2021 22:51:06 [INFO] Copying openmrs-webapp-2.4.0.war to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/openmrs-2.4.0.war
10-Aug-2021 22:51:06 file:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/openmrs-2.4.0.war
10-Aug-2021 22:51:06 target:/home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:addresshierarchy-omod:2.14.2:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:legacyui-omod:1.8.3:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:openconceptlab-omod:1.2.6:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:metadatadeploy-omod:1.13.0:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:reportingrest-omod:1.12.0:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:owa-omod:1.13.0:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:fhir2-omod:1.2.2:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:serialization.xstream-omod:0.2.15:omod
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs.module:registrationapp-omod:1.24.0:jar
10-Aug-2021 22:51:06 [INFO] Configured Artifact: org.openmrs:event-omod:2.10.0-SNAPSHOT:jar
10-Aug-2021 22:51:06 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/event-omod/2.10.0-SNAPSHOT/maven-metadata.xml
10-Aug-2021 22:51:06 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/event-omod/2.10.0-SNAPSHOT/maven-metadata.xml (987 B at 3.2 KB/sec)
10-Aug-2021 22:51:06 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/event-omod/2.10.0-SNAPSHOT/event-omod-2.10.0-20210702.124301-3.jar
10-Aug-2021 22:51:08 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/event-omod/2.10.0-SNAPSHOT/event-omod-2.10.0-20210702.124301-3.jar (4666 KB at 3814.9 KB/sec)
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:uilibrary-omod:2.0.7:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:htmlwidgets-omod:1.10.0:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:dataexchange-omod:1.3.7:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:appui-omod:1.14.0:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:allergyui-omod:1.8.4:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:providermanagement-omod:2.13.0:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:appointmentschedulingui-omod:1.12.0:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:attachments-omod:2.5.0:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:formentryapp-omod:1.4.2:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:idgen-omod:4.7.0:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:metadatamapping-omod:1.4.0:jar
10-Aug-2021 22:51:08 [INFO] Configured Artifact: org.openmrs.module:htmlformentryui-omod:2.0.0-SNAPSHOT:jar
10-Aug-2021 22:51:08 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/htmlformentryui-omod/2.0.0-SNAPSHOT/maven-metadata.xml
10-Aug-2021 22:51:08 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/htmlformentryui-omod/2.0.0-SNAPSHOT/maven-metadata.xml (1008 B at 1.9 KB/sec)
10-Aug-2021 22:51:08 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/htmlformentryui-omod/2.0.0-SNAPSHOT/htmlformentryui-omod-2.0.0-20210810.213404-165.jar
10-Aug-2021 22:51:09 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/htmlformentryui-omod/2.0.0-SNAPSHOT/htmlformentryui-omod-2.0.0-20210810.213404-165.jar (1430 KB at 1886.4 KB/sec)
10-Aug-2021 22:51:09 [INFO] Configured Artifact: org.openmrs.module:referencedemodata-omod:1.4.7-SNAPSHOT:jar
10-Aug-2021 22:51:09 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencedemodata-omod/1.4.7-SNAPSHOT/maven-metadata.xml
10-Aug-2021 22:51:09 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencedemodata-omod/1.4.7-SNAPSHOT/maven-metadata.xml (796 B at 2.8 KB/sec)
10-Aug-2021 22:51:09 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencedemodata-omod/1.4.7-SNAPSHOT/referencedemodata-omod-1.4.7-20210810.222320-219.jar
10-Aug-2021 22:51:10 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencedemodata-omod/1.4.7-SNAPSHOT/referencedemodata-omod-1.4.7-20210810.222320-219.jar (56 KB at 118.1 KB/sec)
10-Aug-2021 22:51:10 [INFO] Configured Artifact: org.openmrs.module:emrapi-omod:1.32.0:jar
10-Aug-2021 22:51:10 [INFO] Configured Artifact: org.openmrs.module:referenceapplication-omod:2.12.0-SNAPSHOT:jar
10-Aug-2021 22:51:10 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referenceapplication-omod/2.12.0-SNAPSHOT/maven-metadata.xml
10-Aug-2021 22:51:10 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referenceapplication-omod/2.12.0-SNAPSHOT/maven-metadata.xml (802 B at 3.0 KB/sec)
10-Aug-2021 22:51:10 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referenceapplication-omod/2.12.0-SNAPSHOT/referenceapplication-omod-2.12.0-20210810.222631-230.jar
10-Aug-2021 22:51:11 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referenceapplication-omod/2.12.0-SNAPSHOT/referenceapplication-omod-2.12.0-20210810.222631-230.jar (1900 KB at 2638.8 KB/sec)
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:htmlformentry-omod:4.1.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:appframework-omod:2.16.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:referencemetadata-omod:2.12.0-SNAPSHOT:jar
10-Aug-2021 22:51:11 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencemetadata-omod/2.12.0-SNAPSHOT/maven-metadata.xml
10-Aug-2021 22:51:11 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencemetadata-omod/2.12.0-SNAPSHOT/maven-metadata.xml (799 B at 3.0 KB/sec)
10-Aug-2021 22:51:11 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencemetadata-omod/2.12.0-SNAPSHOT/referencemetadata-omod-2.12.0-20210810.212954-224.jar
10-Aug-2021 22:51:11 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/referencemetadata-omod/2.12.0-SNAPSHOT/referencemetadata-omod-2.12.0-20210810.212954-224.jar (525 KB at 831.5 KB/sec)
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:reportingui-omod:1.8.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:coreapps-omod:1.33.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:reportingcompatibility-omod:2.0.8:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:reporting-omod:1.23.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:adminui-omod:1.5.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:registrationcore-omod:1.11.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:appointmentscheduling-omod:1.16.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:atlas-omod:2.2.5:omod
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:calculation-omod:1.3.0:jar
10-Aug-2021 22:51:11 [INFO] Configured Artifact: org.openmrs.module:webservices.rest-omod:2.32.0-SNAPSHOT:jar
10-Aug-2021 22:51:11 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/webservices.rest-omod/2.32.0-SNAPSHOT/maven-metadata.xml
10-Aug-2021 22:51:12 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/webservices.rest-omod/2.32.0-SNAPSHOT/maven-metadata.xml (1009 B at 3.3 KB/sec)
10-Aug-2021 22:51:12 [INFO] Downloading: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/webservices.rest-omod/2.32.0-SNAPSHOT/webservices.rest-omod-2.32.0-20210810.210249-35.jar
10-Aug-2021 22:51:23 [INFO] Downloaded: http://mavenrepo.openmrs.org/nexus/content/repositories/public/org/openmrs/module/webservices.rest-omod/2.32.0-SNAPSHOT/webservices.rest-omod-2.32.0-20210810.210249-35.jar (6750 KB at 581.3 KB/sec)
10-Aug-2021 22:51:23 [INFO] Configured Artifact: org.openmrs.module:spa-omod:1.0.8:jar
10-Aug-2021 22:51:23 [INFO] Configured Artifact: org.openmrs.module:uicommons-omod:2.18.0:jar
10-Aug-2021 22:51:23 [INFO] Configured Artifact: org.openmrs.module:uiframework-omod:3.21.0:jar
10-Aug-2021 22:51:23 [INFO] Configured Artifact: org.openmrs.module:metadatasharing-omod:1.8.0:jar
10-Aug-2021 22:51:23 [INFO] Copying addresshierarchy-omod-2.14.2.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/addresshierarchy-2.14.2.omod
10-Aug-2021 22:51:23 [INFO] Copying legacyui-omod-1.8.3.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/legacyui-1.8.3.omod
10-Aug-2021 22:51:23 [INFO] Copying openconceptlab-omod-1.2.6.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/openconceptlab-1.2.6.omod
10-Aug-2021 22:51:23 [INFO] Copying metadatadeploy-omod-1.13.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/metadatadeploy-1.13.0.omod
10-Aug-2021 22:51:23 [INFO] Copying reportingrest-omod-1.12.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/reportingrest-1.12.0.omod
10-Aug-2021 22:51:23 [INFO] Copying owa-omod-1.13.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/owa-1.13.0.omod
10-Aug-2021 22:51:23 [INFO] Copying fhir2-omod-1.2.2.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/fhir2-1.2.2.omod
10-Aug-2021 22:51:24 [INFO] Copying serialization.xstream-omod-0.2.15.omod to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/serialization.xstream-0.2.15.omod
10-Aug-2021 22:51:24 [INFO] Copying registrationapp-omod-1.24.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/registrationapp-1.24.0.omod
10-Aug-2021 22:51:24 [INFO] Copying event-omod-2.10.0-SNAPSHOT.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/event-2.10.0-SNAPSHOT.omod
10-Aug-2021 22:51:24 [INFO] Copying uilibrary-omod-2.0.7.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/uilibrary-2.0.7.omod
10-Aug-2021 22:51:24 [INFO] Copying htmlwidgets-omod-1.10.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/htmlwidgets-1.10.0.omod
10-Aug-2021 22:51:24 [INFO] Copying dataexchange-omod-1.3.7.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/dataexchange-1.3.7.omod
10-Aug-2021 22:51:24 [INFO] Copying appui-omod-1.14.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/appui-1.14.0.omod
10-Aug-2021 22:51:24 [INFO] Copying allergyui-omod-1.8.4.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/allergyui-1.8.4.omod
10-Aug-2021 22:51:24 [INFO] Copying providermanagement-omod-2.13.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/providermanagement-2.13.0.omod
10-Aug-2021 22:51:24 [INFO] Copying appointmentschedulingui-omod-1.12.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/appointmentschedulingui-1.12.0.omod
10-Aug-2021 22:51:24 [INFO] Copying attachments-omod-2.5.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/attachments-2.5.0.omod
10-Aug-2021 22:51:24 [INFO] Copying formentryapp-omod-1.4.2.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/formentryapp-1.4.2.omod
10-Aug-2021 22:51:24 [INFO] Copying idgen-omod-4.7.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/idgen-4.7.0.omod
10-Aug-2021 22:51:24 [INFO] Copying metadatamapping-omod-1.4.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/metadatamapping-1.4.0.omod
10-Aug-2021 22:51:24 [INFO] Copying htmlformentryui-omod-2.0.0-SNAPSHOT.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/htmlformentryui-2.0.0-SNAPSHOT.omod
10-Aug-2021 22:51:24 [INFO] Copying referencedemodata-omod-1.4.7-SNAPSHOT.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/referencedemodata-1.4.7-SNAPSHOT.omod
10-Aug-2021 22:51:24 [INFO] Copying emrapi-omod-1.32.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/emrapi-1.32.0.omod
10-Aug-2021 22:51:24 [INFO] Copying referenceapplication-omod-2.12.0-SNAPSHOT.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/referenceapplication-2.12.0-SNAPSHOT.omod
10-Aug-2021 22:51:24 [INFO] Copying htmlformentry-omod-4.1.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/htmlformentry-4.1.0.omod
10-Aug-2021 22:51:24 [INFO] Copying appframework-omod-2.16.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/appframework-2.16.0.omod
10-Aug-2021 22:51:24 [INFO] Copying referencemetadata-omod-2.12.0-SNAPSHOT.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/referencemetadata-2.12.0-SNAPSHOT.omod
10-Aug-2021 22:51:24 [INFO] Copying reportingui-omod-1.8.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/reportingui-1.8.0.omod
10-Aug-2021 22:51:24 [INFO] Copying coreapps-omod-1.33.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/coreapps-1.33.0.omod
10-Aug-2021 22:51:24 [INFO] Copying reportingcompatibility-omod-2.0.8.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/reportingcompatibility-2.0.8.omod
10-Aug-2021 22:51:24 [INFO] Copying reporting-omod-1.23.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/reporting-1.23.0.omod
10-Aug-2021 22:51:24 [INFO] Copying adminui-omod-1.5.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/adminui-1.5.0.omod
10-Aug-2021 22:51:24 [INFO] Copying registrationcore-omod-1.11.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/registrationcore-1.11.0.omod
10-Aug-2021 22:51:24 [INFO] Copying appointmentscheduling-omod-1.16.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/appointmentscheduling-1.16.0.omod
10-Aug-2021 22:51:24 [INFO] Copying atlas-omod-2.2.5.omod to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/atlas-2.2.5.omod
10-Aug-2021 22:51:24 [INFO] Copying calculation-omod-1.3.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/calculation-1.3.0.omod
10-Aug-2021 22:51:24 [INFO] Copying webservices.rest-omod-2.32.0-SNAPSHOT.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/webservices.rest-2.32.0-SNAPSHOT.omod
10-Aug-2021 22:51:24 [INFO] Copying spa-omod-1.0.8.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/spa-1.0.8.omod
10-Aug-2021 22:51:24 [INFO] Copying uicommons-omod-2.18.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/uicommons-2.18.0.omod
10-Aug-2021 22:51:24 [INFO] Copying uiframework-omod-3.21.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/uiframework-3.21.0.omod
10-Aug-2021 22:51:24 [INFO] Copying metadatasharing-omod-1.8.0.jar to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro/web/modules/metadatasharing-1.8.0.omod
10-Aug-2021 22:51:24
10-Aug-2021 22:51:24 Creating Docker Compose configuration...
10-Aug-2021 22:51:24
10-Aug-2021 22:51:24
10-Aug-2021 22:51:24 The 'referenceapplication' distribution created! To start up the server run 'docker-compose up' from /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/distro
10-Aug-2021 22:51:24
10-Aug-2021 22:51:24 [INFO]
10-Aug-2021 22:51:24 [INFO] --- maven-resources-plugin:2.7:resources (default-resources) @ referenceapplication-standalone ---
10-Aug-2021 22:51:25 [INFO] Using 'UTF-8' encoding to copy filtered resources.
10-Aug-2021 22:51:25 [INFO] Copying 4 resources
10-Aug-2021 22:51:25 [INFO] Copying 1 resource
10-Aug-2021 22:51:25 [INFO]
10-Aug-2021 22:51:25 [INFO] --- maven-compiler-plugin:2.3.2:compile (default-compile) @ referenceapplication-standalone ---
10-Aug-2021 22:51:25 [INFO] Compiling 14 source files to /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/classes
10-Aug-2021 22:51:29 [INFO]
10-Aug-2021 22:51:29 [INFO] >>> exec-maven-plugin:1.2.1:java (stop-liquibase-mysql) > validate @ referenceapplication-standalone >>>
10-Aug-2021 22:51:29 [INFO]
10-Aug-2021 22:51:29 [INFO] --- maven-enforcer-plugin:1.0:enforce (enforce-property) @ referenceapplication-standalone ---
10-Aug-2021 22:51:29 [INFO]
10-Aug-2021 22:51:29 [INFO] <<< exec-maven-plugin:1.2.1:java (stop-liquibase-mysql) < validate @ referenceapplication-standalone <<<
10-Aug-2021 22:51:29 [INFO]
10-Aug-2021 22:51:29 [INFO] --- exec-maven-plugin:1.2.1:java (stop-liquibase-mysql) @ referenceapplication-standalone ---
10-Aug-2021 22:51:29 [MysqldResource] stopping mysqld (process: 7372)
10-Aug-2021 22:51:29 210810 22:51:29 [Note] /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase/bin/mysqld: Normal shutdown
10-Aug-2021 22:51:29
10-Aug-2021 22:51:29 210810 22:51:29 [Note] Event Scheduler: Purging the queue. 0 events
10-Aug-2021 22:51:29 210810 22:51:29  InnoDB: Starting shutdown...
10-Aug-2021 22:51:30 210810 22:51:30  InnoDB: Shutdown completed; log sequence number 24071222
10-Aug-2021 22:51:30 210810 22:51:30 [Note] /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase/bin/mysqld: Shutdown complete
10-Aug-2021 22:51:30
10-Aug-2021 22:51:31 [MysqldResource] shutdown complete
10-Aug-2021 22:51:31 [MysqldResource] stopping mysqld (process: 6765)
10-Aug-2021 22:51:31 210810 22:51:31 [Note] /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/emptydatabase/bin/mysqld: Normal shutdown
10-Aug-2021 22:51:31
10-Aug-2021 22:51:31 210810 22:51:31 [Note] Event Scheduler: Purging the queue. 0 events
10-Aug-2021 22:51:31 210810 22:51:31  InnoDB: Starting shutdown...
10-Aug-2021 22:51:32 210810 22:51:32  InnoDB: Shutdown completed; log sequence number 11938143
10-Aug-2021 22:51:32 210810 22:51:32 [Note] /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/emptydatabase/bin/mysqld: Shutdown complete
10-Aug-2021 22:51:32
10-Aug-2021 22:51:33 [MysqldResource] shutdown complete
10-Aug-2021 22:51:33 [INFO]
10-Aug-2021 22:51:33 [INFO] --- maven-resources-plugin:2.7:testResources (default-testResources) @ referenceapplication-standalone ---
10-Aug-2021 22:51:33 [INFO] Using 'UTF-8' encoding to copy filtered resources.
10-Aug-2021 22:51:33 [INFO] skip non existing resourceDirectory /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/src/test/resources
10-Aug-2021 22:51:33 [INFO]
10-Aug-2021 22:51:33 [INFO] --- maven-compiler-plugin:2.3.2:testCompile (default-testCompile) @ referenceapplication-standalone ---
10-Aug-2021 22:51:33 [INFO] No sources to compile
10-Aug-2021 22:51:33 [INFO]
10-Aug-2021 22:51:33 [INFO] --- maven-surefire-plugin:2.12.4:test (default-test) @ referenceapplication-standalone ---
10-Aug-2021 22:51:33 [INFO] No tests to run.
10-Aug-2021 22:51:33 [INFO]
10-Aug-2021 22:51:33 [INFO] --- maven-assembly-plugin:2.3:single (package-jar-with-dependencies) @ referenceapplication-standalone ---
10-Aug-2021 22:51:34 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:34 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:34 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] Building jar: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/openmrs-standalone.jar
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:35 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/NOTICE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/LICENSE already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:51:36 [INFO] META-INF/MANIFEST.MF already added, skipping
10-Aug-2021 22:52:04 [WARNING] Configuration options: 'appendAssemblyId' is set to false, and 'classifier' is missing.
10-Aug-2021 22:52:04 Instead of attaching the assembly file: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/openmrs-standalone.jar, it will become the file for main project artifact.
10-Aug-2021 22:52:04 NOTE: If multiple descriptors or descriptor-formats are provided for this project, the value of this file will be non-deterministic!
10-Aug-2021 22:52:04 [WARNING] Replacing pre-existing project main-artifact file: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/classes
10-Aug-2021 22:52:04 with assembly file: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/openmrs-standalone.jar
10-Aug-2021 22:52:04 [INFO]
10-Aug-2021 22:52:04 [INFO] --- maven-assembly-plugin:2.3:single (zip-demo-database) @ referenceapplication-standalone ---
10-Aug-2021 22:52:04 [INFO] Reading assembly descriptor: src/main/assembly/zip-demo-database.xml
10-Aug-2021 22:52:05 [INFO] Building zip: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/demodatabase.zip
10-Aug-2021 22:52:06 [INFO]
10-Aug-2021 22:52:06 [INFO] --- maven-assembly-plugin:2.3:single (zip-empty-database) @ referenceapplication-standalone ---
10-Aug-2021 22:52:06 [INFO] Reading assembly descriptor: src/main/assembly/zip-empty-database.xml
10-Aug-2021 22:52:06 [INFO] Building zip: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/emptydatabase.zip
10-Aug-2021 22:52:07 [INFO]
10-Aug-2021 22:52:07 [INFO] --- maven-jar-plugin:2.4:jar (default-jar) @ referenceapplication-standalone ---
10-Aug-2021 22:52:08 [INFO] Building jar: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/referenceapplication-standalone-2.12.0-SNAPSHOT.jar
10-Aug-2021 22:52:08 [INFO]
10-Aug-2021 22:52:08 [INFO] --- maven-assembly-plugin:2.3:single (zip-standalone) @ referenceapplication-standalone ---
10-Aug-2021 22:52:08 [INFO] Reading assembly descriptor: src/main/assembly/zip-standalone.xml
10-Aug-2021 22:52:08 [INFO] Building zip: /home/bamboo-agent/bamboo-agent/xml-data/build-dir/REFAPP-OMODDISTRO-TS/standalone/target/referenceapplication-standalone-2.12.0-SNAPSHOT.zip
10-Aug-2021 22:52:26 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:52:26 [INFO] BUILD SUCCESS
10-Aug-2021 22:52:26 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:52:26 [INFO] Total time: 04:21 min
10-Aug-2021 22:52:26 [INFO] Finished at: 2021-08-10T22:52:26+00:00
10-Aug-2021 22:52:27 [INFO] Final Memory: 57M/1247M
10-Aug-2021 22:52:27 [INFO] ------------------------------------------------------------------------
10-Aug-2021 22:52:27 Finished task 'Package Standalone' with result: Success
10-Aug-2021 22:52:27 Running post build plugin 'Docker Container Cleanup'
10-Aug-2021 22:52:27 Running post build plugin 'NCover Results Collector'
10-Aug-2021 22:52:27 Running post build plugin 'Clover Results Collector'
10-Aug-2021 22:52:27 Running post build plugin 'Sauce OnDemand Post Runner'
10-Aug-2021 22:52:27 Running post build plugin 'npm Cache Cleanup'
10-Aug-2021 22:52:27 Running post build plugin 'Artifact Copier'
10-Aug-2021 22:52:27 Publishing an artifact: referenceapplication-standalone-snapshot
10-Aug-2021 22:52:32 Finished publishing of artifact Non required shared artifact: [referenceapplication-standalone-snapshot], pattern: [referenceapplication-standalone-*.zip] anchored at: [standalone/target] in 4.859 s
10-Aug-2021 22:52:32 Finalising the build...
10-Aug-2021 22:52:32 Stopping timer.
10-Aug-2021 22:52:32 Build REFAPP-OMODDISTRO-TS-11647 completed.
10-Aug-2021 22:52:32 Running on server: post build plugin 'NCover Results Collector'
10-Aug-2021 22:52:32 Running on server: post build plugin 'Build Hanging Detection Configuration'
10-Aug-2021 22:52:32 Running on server: post build plugin 'Clover Delta Calculator'
10-Aug-2021 22:52:32 Running on server: post build plugin 'Maven Dependencies Postprocessor'
10-Aug-2021 22:52:32 All post build plugins have finished
10-Aug-2021 22:52:32 Generating build results summary...
10-Aug-2021 22:52:32 Saving build results to disk...
10-Aug-2021 22:52:32 Logging substituted variables...
10-Aug-2021 22:52:32 Indexing build results...
10-Aug-2021 22:52:32 Finished building REFAPP-OMODDISTRO-TS-11647.