SQLite format 3@ x. , k2R=%Q+indexsqlite_autoindex_webhook_headers_1webhook_headers ctablepactspacts CREATE TABLE `pacts`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY, `json_content` mediumtext DEFAULT (NULL) NULL, `version_id` integer DEFAULT (NULL) NOT NULL, `provider_id` integer DEFAULT (NULL) NOT NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL, FOREIGN KEY (`provider_id`) REFERENCES `pacticipants` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`version_id`) REFERENCES `versions` ON DELETE NO ACTION ON UPDATE NO ACTION)Q'_indexpacts_versioR"wtablewebhookswebhooks CREATE TABLE `webhooks` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `uuid` varchar(255) NOT NULL CONSTRAINT `uq_webhook_uuid` UNIQUE, `method` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `body` varchar(255), `is_json_request_body` Boolean, `consumer_id` integer NOT NULL CONSTRAINT `fk_webhooks_consumer` REFERENCES `pacticipants`, `provider_id` integer NOT NULL CONSTRAINT `fk_webhooks_provider` REFERENCES `pacticipants`)/#Cindexsqlite_autoindex_webhooks_1webhooks !QOindexpacts_version_id_provider_id_indexpactsCREATE UNIQUE INDEX `pacts_version_id_provider_id_index` ON `pacts` (`version_id`, `provider_id`)UWindexversions_pacticipant_id_number_indexversionsCREATE UNIQUE INDEX `versions_pacticipant_id_number_index` ON `versions` (`pacticipant_id`, `number`)] tableversionsversionsCREATE TABLE `versions`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY, `number` varchar(255) DEFAULT (NULL) NULL, `repository_ref` varchar(255) DEFAULT (NULL) NULL, `pacticipant_id` integer DEFAULT (NULL) NOT NULL, `order` integer DEFAULT (NULL) NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL, FOREIGN KEY (`pacticipant_id`) REFERENCES `pacticipants` ON DELETE NO ACTION ON UPDATE NO ACTION)7K%indexsqlite_autoindex_pacticipants_1pacticipants5%%-tablepacticipantspacticipantsCREATE TABLE `pacticipants`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY, `name` varchar(255) DEFAULT (NULL) NULL UNIQUE, `repository_url` varchar(255) DEFAULT (NULL) NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL)';indexsqlite_autoindex_tags_1tags ]tabletagstags CREATE TABLE `tags`(`name` varchar(255) DEFAULT (NULL) NULL, `version_id` integer DEFAULT (NULL) NOT NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL, PRIMARY KEY ('name', 'version_id'), FOREIGN KEY (`version_id`) REFERENCES `versions` ON DELETE NO ACTION ON UPDATE NO ACTION)=%%Aviewlatest_pactslatest_pactsCREATE VIEW `latest_pacts` AS select ap.* from all_pacts ap inner join latest_pact_consumer_version_orders lp on ap.consumer_id = lp.consumer_id and ap.provider_id = lp.provider_id and ap.consumer_version_order = latest_consumer_version_order SS+viewlatest_pact_consumer_version_orderslatest_pact_consumer_version_ordersCREATE VIEW `latest_pact_consumer_version_orders` AS select provider_id, consumer_id, max(consumer_version_order) as latest_consumer_version_order from all_pacts group by provider_id, consumer_id4;viewall_pactsall_pactsCREATE VIEW `all_pacts` AS select pact.id, c.id as consumer_id, c.name as consumer_name, cv.number as consumer_version_number, cv.`order` as consumer_version_order, p.id as provider_id, p.name as provider_name, pact.json_content from pacts pact join versions cv on pact.version_id = cv.id join pacticipants c on cv.pacticipant_id = c.id join pacticipants p on pact.provider_id = p.idP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)f##tableschema_infoschema_infoCREATE TABLE `schema_info` (`version` integer DEFAULT (0)B: $ s4=AAFoo2017-05-23 06:10:23.2390042017-05-23 06:10:23.239004=AABar2017-05-23 06:10:23.2358222017-05-23 06:10:23.235822AAAZoo App2014-11-18 06:28:36.2904662014-11-18 06:28:36.290466H)AAAnimal Service2014-11-18 06:28:36.2618682014-11-18 06:28:36.261868 FooBar Zoo App) Animal Service 'pact_versions/pact_publications  1.0.0 1.0.2 1.0.1  1.0.0 x3BAA1.0.02017-05-23 06:10:23.2430152017-05-23 06:10:23.245281CAA1.0.22016-11-08 22:45:37.2447312016-11-08 22:45:37.274760B AA1.0.12015-01-19 22:13:57.7439932015-01-19 22:13:57.746417BAA1.0.02014-11-18 06:28:36.2957502014-11-18 06:28:36.333021   1 % AA]{ "provider": { "name": "Animal Service" }, "consumer": { "name": "Zoo App" }, "interactions": [ { "description": "a request for an alligator", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Mary" } } }, { "description": "a request for an alligator", "provider_state": "there is not an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 404 } }, { "description": "a request for an alligator", "provider_state": "an error occurs retrieving an alligator", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 500, "headerd AA]2016-11-08 22:45:37.2918392016-11-08 22:45:37.29183915a22e805caa9d0153b815fc6566a0c03d4a82aed AA]2015-01-19 22:13:57.7586382015-01-19 22:15:10.96951823b64b5c5f5baf0e56dd92c4deddf9eb1e249d11c AA]2014-11-18 06:28:36.3400412014-11-18 06:28:36.34004115a22e805caa9d0153b8        E? ( K D h=%Q+indexsqlite_autoindex_webhook_headers_1webhook_headers =%Q+indexsqlite_autoindex_webhook_headers_1webhook_headers ctablepactspacts CREATE TABLE `pacts`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY, `json_content` mediumtext DEFAULT (NULL) NULL, `version_id` intf##tableschema_infoschema_infoCREATE TABLE `schema_info` (`version` integer DEFAULT (0) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)]tabletagstags CREATE TABLE `tags`(`name` varchar(255) DEFAULT (NULL) NULL, `version_id` integer DEFAULT (NULL) NOT NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL, PRIMARY KEY ('name', 'version_id'), FOREIGN KEY (`version_id`) REFERENCES `versions` ON DELETE NO ACTION ON UPDATE NO ACTION)';indexsqlite_autoindex_tags_1tags 5%%-tablepacticipantspacticipantsCREATE TABLE `pacticipants`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY, `name` varchar(255) DEFAULT (NULL) NULL UNIQUE, `repository_url` varchar(255) DEFAULT (NULL) NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL)7K%indexsqlite_autoindex_pacticipants_1pacticipants] tableversionsversionsCREATE TABLE `versions`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY, `number` varchar(255) DEFAULT (NULL) NULL, `repository_ref` varchar(255) DEFAULT (NULL) NULL, `pacticipant_id` integer DEFAULT (NULL) NOT NULL, `order` integer DEFAULT (NULL) NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL, FOREIGN KEY (`pacticipant_id`) REFERENCES `pacticipants` ON DELETE NO ACTION ON UPDATE NO ACTION)UWindexversions_pacticipant_id_number_indexversionsCREATE UNIQUE INDEX `versions_pacticipant_id_number_index` ON `versions` (`pacticipant_id`, `number`)4";tablewebhookswebhooks CREATE TABLE `webhooks` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `uuid` varchar(255) NOT NULL CONSTRAINT `uq_webhook_uuid` UNIQUE, `method` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `body` varchar(255), `is_json_request_body` Boolean, `consumer_id` integer NOT NULL CONSTRAINT `fk_webhooks_consumer` REFERENCES `pacticipants`, `provider_id` integer NOT NULL CONSTRAINT `fk_webhooks_provider` REFERENCES `pacticipants`, `created_at` timestamp, `updated_at` timestamp, `username` varchar(255), `password` varchar(255))/#Cindexsqlite_autoindex_webhooks_1webhooks $++wtablewebhook_headerswebhook_headersCREATE TABLE `webhook_headers` (`name` varchar(255) NOT NULL, `value` varchar(255), `webhook_id` integer NOT NULL CONSTRAINT `fk_webhookheaders_webhooks` REFERENCES `webhooks`, CONSTRAINT `webhooks_headers_pk` PRIMARY KEY (`webhook_id`, `name`))=%Q+indexsqlite_autoindex_webhook_headers_1webhook_headers:77%tablepact_version_contentspact_version_contents}://)tablepact_publicationspact_publicationsCREATE TABLE `pact_publications` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `consumer_version_id` integer NOT NULL REFERENCES `versions`, `provider_id` integer NOT NULL REFERENCES `pacticipants`, `revision_number` integer NOT NULL, `pact_version_id` integer NOT NULL REFERENCES `pact_versions`, `created_at` timestamp NOT NULL)95'Sindexunq_pvc_con_prov_shapact_versionsCREATE UNIQUE INDEX `unq_pvc_con_prov_sha` ON `pact_versions` (`consumer_id`, `provider_id`, `sha`)%8'' tablepact_versionspact_versionsCREATE TABLE `pact_versions`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `consumer_id` integer DEFAULT (NULL) NOT NULL, `provider_id` integer DEFAULT (NULL) NOT NULL, `sha` varchar(255) DEFAULT (NULL) NOT NULL, `content` mediumtext DEFAULT (NULL) NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, FOREIGN KEY (`consumer_id`) REFERENCES `pacticipants` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`provider_id`) REFERENCES `pacticipants` ON DELETE NO ACTION ON UPDATE NO ACTION)  c  W  z''tablepact_versionspact_versionsCREATE TABLE `pact_versions`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `consumer_id` integ!757cindexunq_pvc_con_prov_shapact_versions_backup0CREATE UNIQUE INDEX `unq_pvc_con_prov_sha` ON "p <)/Oindexcv_prov_iwuviewall_pactsall_pactsCREATE VIEW `all_pacts` AS SELECT `pacts`.`id`, `c`.`id` AS 'consumer_id', `c`.`name` AS 'consumer_name', `cv`.`id` AS 'consumer_version_id', `cv`.`number` AS 'consumer_version_number', `cv`.`order` AS 'consumer_version_order', `p`.`id` AS 'provider_id', `p`.`name` AS 'provider_name', `pvc`.`sha` AS 'pact_version_content_sha', `pacts`.`created_at`, `pacts`.`updated_at` FROM `pacts` INNER JOIN `versions` AS 'cv' ON (`cv`.`id` = `pacts`.`version_id`) ?BaaMviewlatest_tagged_pact_consumer_version_orderslatest_tagged_pact_consumer_version_ordersCREATE VIEW `latest_tagged_pact_consumer_version_orders` AS select provider_id, consumer_id, t.name as tag_name, max(consumer_version_order) as latest_consumer_version_order from latest_pact_publications_by_consumer_versions ap inner join tags t on t.version_id = ap.consumer_version_id group by provider_id, consumer_id, t.nameA==5viewlatest_pact_publicationslatest_pact_publicationsCREATE VIEW `latest_pact_publications` AS select lpcv.* from latest_pact_publications_by_consumer_versions lpcv inner join latest_pact_consumer_version_orders lp on lpcv.consumer_id = lp.consumer_id and lpcv.provider_id = lp.provider_id and lpcv.consumer_version_order = latest_consumer_version_order,@SSCviewlatest_pact_consumer_version_orderslatest_pact_consumer_version_ordersCREATE VIEW `latest_pact_consumer_version_orders` AS select provider_id, consumer_id, max(consumer_version_order) as latest_consumer_version_order from all_pact_publications group by provider_id, consumer_idh?ggviewlatest_pact_publications_by_consumer_versionslatest_pact_publications_by_consumer_versionsCREATE VIEW `latest_pact_publications_by_consumer_versions` AS select app.* from all_pact_publications app inner join latest_pact_publication_revision_numbers lr on app.consumer_id = lr.consumer_id and app.provider_id = lr.provider_id and app.consumer_version_order = lr.consumer_version_order and app.revision_number = lr.latest_revision_number]>]]viewlatest_pact_publication_revision_numberslatest_pact_publication_revision_numbersCREATE VIEW `latest_pact_publication_revision_numbers` AS select provider_id, consumer_id, consumer_version_order, max(revision_number) as latest_revision_number from all_pact_publications group by provider_id, consumer_id, consumer_version_order-;5/indexcv_prov_revision_unqpact_publicationsCREATE UNIQUE INDEX `cv_prov_revision_unq` ON `pact_publications` (`consumer_version_id`, `provider_id`, `revision_number`) <)/Oindexcv_prov_id_ndxpact_publicationsCREATE INDEX `cv_prov_id_ndx` ON `pact_publications` (`consumer_version_id`, `provider_id`, `id`)Z=77Wviewall_pact_publicationsall_pact_publicationsCREATE VIEW `all_pact_publications` AS SELECT `pact_publications`.`id`, `c`.`id` AS 'consumer_id', `c`.`name` AS 'consumer_name', `cv`.`id` AS 'consumer_version_id', `cv`.`number` AS 'consumer_version_number', `cv`.`order` AS 'consumer_version_order', `p`.`id` AS 'provider_id', `p`.`name` AS 'provider_name', `pact_publications`.`revision_number`, `pv`.`id` AS 'pact_version_id', `pv`.`sha` AS 'pact_version_sha', `pact_publications`.`created_at` FROM `pact_publications` INNER JOIN `versions` AS 'cv' ON (`cv`.`id` = `pact_publications`.`consumer_version_id`) INNER JOIN `pacticipants` AS 'c' ON (`c`.`id` = `cv`.`pacticipant_id`) INNER JOIN `pacticipants` AS 'p' ON (`p`.`id` = `pact_publications`.`provider_id`) INNER JOIN `pact_versions` AS 'pv' ON (`pv`.`id` = `pact_publications`.`pact_version_id`)   1.0.2 1.0.1 1.0.0 1.0.0  e]?A73cd294d54d900e5ebb313896b1df8d1da8914f9{ "consumer": { "name": "Foo" }, "provider": { "name": "Bar" }, "interactions": [ { "description": "a retrieve thing request", "request": { "method": "get", "path": "/thing" }, "response": { "status": 200, "headers": { "Content-Type": "application/json" }, "body": [ { "status": "4" } ], "matchingRules": { "$.body": { "min": 1 }, "$.body[*].*": { "match": "type" }, "$.body[*].status": { "match": "regex", "regex": "\\d+" } } } } ], "metadata": { "pactSpecification": { "version": "2.0.0" } } }2017-05-23 06:10:23.249813   ]A23b64b5c5f5baf0e56dd92c4deddf9eb1e249d11{ "provider": { "name": "Animal Service" }, "consumer": { "name": "Zoo App" }, "interactions": [ { "description": "a request for an alligator", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Mary" } } }, { "description": "a request for an alligator", "provider_state": "there is not an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 404 } }, { "description": "a request for an alligator", "provider_state": "an error occurs retrieving an alligator", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 500, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "error": "Argh!!!" } } }, { "description": "a request for an alligator's sister", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary/sister", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Sue" } } } ], "metadata": { "pactSpecificationVersion": "1.0.0" } }2015-01-19 22:15:10.964768 ]%A15a22e805caa9d0153b815fc6566a0c03d4a82ae{ "provider": { "name": "Animal Service" }, "consumer": { "name": "Zoo App" }, "interactions": [ { "description": "a request for an alligator", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Mary" } } }, { "description": "a request for an alligator", "provider_state": "there is not an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 404 } }, { "description": "a request for an alligator", "provider_state": "an error occurs retrieving an alligator", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 500, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "error": "Argh!!!" } } } ], "metadata": { "pactSpecificationVersion": "1.0.0" } }2014-11-18 06:28:36.340041 pp ]%A15a22e805caa9d0153b815fc6566a0c03d4a82ae{ "provider": { "name": "Animal Service" }, "consumer": { "name": "Zoo App" }, "interactions": [ { "description": "a request for an alligator", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Mary" } } }, { "description": "a request for an alligator", "provider_state": "there is not an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 404 } }, { "description": "a request for an alligator", "provider_state": "an error occurs retrieving an alligator", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 500, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "error": "Argh!!!" } } } ], "metadata": { "pactSpecificationVersion": "1.0.0" } }2014-11-18 06:28:36.340041]A2a5a86d7a9138aaa6f2ffbfe097a5b7f7000895f{ "provider": { "name": "Animal Service" }, "consumer": { "name": "Zoo App" }, "interactions": [ { "description": "a request for an alligator", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Mary" } } }, { "description": "a request for an alligator's sister", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary/sister", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Sue" } } }, { "description": "a request for an alligator", "provider_state": "there is not an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 404 } }, { "description": "a request for an alligator", "provider_state": "an error occurs retrieving an alligator", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 500, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { 0]73cd294d54d900e5ebb313896b1df8d1da8914f9/ ]23b64b5c5f5baf0e56dd92c4deddf9eb1e249d11. ] 15a22e805caa9d0153b815fc6566a0c03d4a82ae \] 15a22e805caa9d0153b815fc6566a0c03d4a82. ] 15a22e805caa9d0153b815fc6566a0c03d4a82ae/ ]23b64b5c5f5baf0e56dd92c4deddf9eb1e249d11/]2a5a86d     ]A23b64b5c5f5baf0e56dd92c4deddf9eb1e249d11{ "provider": { "name": "Animal Service" }, "consumer": { "name": "Zoo App" }, "interactions": [ { "description": "a request for an alligator", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Mary" } } }, { "description": "a request for an alligator", "provider_state": "there is not an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 404 } }, { "description": "a request for an alligator", "provider_state": "an error occurs retrieving an alligator", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 500, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "error": "Argh!!!" } } }, { "description": "a request for an alligator's sister", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary/sister", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Sue" } } } ], "metadata": { "pactSpecificationVersion": "1.0.0" } }2015-01-19 22:15:10.964768 ]%A15a22e805caa9d0153b815fc6566a0c03d4a82ae{ "provider": { "name": "Animal Service" }, "consumer": { "name": "Zoo App" }, "interactions": [ { "description": "a request for an alligator", "provider_state": "there is an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 200, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "name": "Mary" } } }, { "description": "a request for an alligator", "provider_state": "there is not an alligator named Mary", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 404 } }, { "description": "a request for an alligator", "provider_state": "an error occurs retrieving an alligator", "request": { "method": "get", "path": "/alligators/Mary", "headers": { "Accept": "application/json" } }, "response": { "status": 500, "headers": { "Content-Type": "application/json;charset=utf-8" }, "body": { "error": "Argh!!!" } } } ], "metadata": { "pactSpecificationVersion": "1.0.0" } }2014-11-18 06:28:36.3 nn$ A2017-05-23 06:10:23.252829" A2016-11-08 22:45:37.291839# A2015-01-19 22:15:10.969518! A2014-11-18 06:28:36.340041      Yd=w LJK%iindexndx_tag_nametagsCREATE INDEX `ndx_tag_name` ON `tags` (`name`)ZJ%%yindexndx_ppt_namepacticipantsCREATE INDEX `ndx_ppt_name` ON `pacticipants` (`name`)qI))indexuq_ver_ppt_ordversionsCREATE UNIQUE INDEX `uq_ver_ppt_ord` ON `versions` (`pacticipant_id`, `order`)QH#qindexndx_ver_ordversions CREATE INDEX `ndx_ver_ord` ON `versions` (`order`)RG#sindexndx_ver_numversionsCREATE INDEX `ndx_ver_num` ON `versions` (`number`)PF55Gviewlatest_verificationslatest_verificationsCREATE VIEW `latest_verifications` AS SELECT v.id, v.number, v.success, v.provider_version, v.build_url, v.pact_version_id, v.execution_date, v.created_at FROM verifications v INNER JOIN ( SELECT pact_version_id, MAX(number) latest_number FROM verifications GROUP BY pact_version_id ) lv ON v.pact_version_id = lv.pact_version_id AND v.number = lv.latest_number5Ea'oindexverifications_pact_version_id_number_indexverificationsCREATE UNIQUE INDEX `verifications_pact_version_id_number_index` ON `verifications` (`pact_version_id`, `number`)lD''tableverificationsverificationsCREATE TABLE `verifications` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `number` integer, `success` Boolean NOT NULL, `provider_version` varchar(255) NOT NULL, `build_url` varchar(255), `pact_version_id` integer NOT NULL REFERENCES `pact_versions`, `execution_date` timestamp NOT NULL, `created_at` timestamp NOT NULL)]]viewlatest_pact_publication_revision_numberslatest_pact_publication_revision_numbersCREATE VIEW `latest_pact_publication_revision_numbers` AS select provider_id, consumer_id, consumer_version_order, max(revision_number) as latest_revision_number from all_pact_publications group by provider_id, consumer_id, consumer_version_orderh?ggviewlatest_pact_publications_by_consumer_versionslatest_pact_publications_by_consumer_versionsCREATE VIEW `latest_pact_publications_by_consumer_versions` AS select app.* from all_pact_publications app inner join latest_pact_publication_revision_numbers lr on app.consumer_id = lr.consumer_id and app.provider_id = lr.provider_id and app.consumer_version_order = lr.consumer_version_order and app.revision_number = lr.latest_revision_number,@SSCviewlatest_pact_consumer_version_orderslatest_pact_consumer_version_ordersCREATE VIEW `latest_pact_consumer_version_orders` AS select provider_id, consumer_id, max(consumer_version_order) as latest_consumer_version_order from all_pact_publications group by provider_id, consumer_idA==5viewlatest_pact_publicationslatest_pact_publicationsCREATE VIEW `latest_pact_publications` AS select lpcv.* from latest_pact_publications_by_consumer_versions lpcv inner join latest_pact_consumer_version_orders lp on lpcv.consumer_id = lp.consumer_id and lpcv.provider_id = lp.provider_id and lpcv.consumer_version_order = latest_consumer_version_order?BaaMvie2L11tablewebhook_executionswebhook_executionsCREATE TABLE `webhook_executions` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `webhook_id` integer REFERENCES `webhooks`, `pact_publication_id` integer REFERENCES `pact_publications`, `consumer_id` integer NOT NULL REFERENCES `pacticipants`, `provider_id` integer NOT NULL REFERENCES `pacticipants`, `success` Boolean NOT NULL, `logs` mediumtext, `created_at` timestamp NOT NULL)$CKKCviewlatest_tagged_pact_publicationslatest_tagged_pact_publicationsCREATE VIEW `latest_tagged_pact_publications` AS select lp.*, o.tag_name from latest_pact_publications_by_consumer_versions lp inner join latest_tagged_pact_consumer_version_orders o on lp.consumer_id = o.consumer_id and lp.provider_id = o.provider_id and lp.consumer_version_order = latest_consumer_version_order     Zoo AppFooBar) Animal Service