SQLite format 3@ MTM-æûûž ¼ ™Yõ̆M¬¬­ƒk‡)tableversionsversionsCREATE TABLE `versions`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `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) ËU-gindexvers ˃x ''‡/tablepacts_backup0pacts_backup0 CREATE TABLE "pacts_backup0"(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `json_content` mediumtext DEFAULT (NULL) NULL, `version_id` integer DEFAULT (NULL) NOT NULL, `provider_id` integer DEFAULT (NULL) NOT NULL, `created_at` timestamp, `updated_at` timestamp, 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)UWindexversions_pacticipant_id_number_indexversionsCREATE UNIQUE INDEX `versions_pacticipant_id_number_index` ON `versions` (`pacticipant_id`, `number`)7K%indexsqlite_autoindex_pacticipants_1pacticipants‚C%%„ItablepacticipantspacticipantsCREATE TABLE `pacticipants`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `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 ‚a…%tabletagstags CREATE TABLE `tags`(`name` varchar(255) DEFAULT (NULL) NOT 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_id„ ‡kviewall_pactsall_pactsCREATE VIEW `all_pacts` AS SELECT `pacts`.`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', `pacts`.`json_content` FROM `pacts` INNER JOIN `versions` AS 'cv' ON (`cv`.`id` = `pacts`.`version_id`) INNER JOIN `pacticipants` AS 'c' ON (`c`.`id` = `cv`.`pacticipant_id`) INNER JOIN `pacticipants` AS 'p' ON (`p`.`id` = `pacts`.`provider_id`)ÓQOindexpacts_version_id_provider_id_indexpactsCREATE UNIQUE INDEX `pacts_version_id_provider_id_index` ON `pacts` (`version_id`, `provider_id`)ã‡tablepactspacts CREATE TABLE `pacts`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `json_content` mediumtext DEFAULT (NULL) NULL, `version_id` integer DEFAULT (NULL) NOT NULL, `provider_id` integer DEFAULT (NULL) NOT NULL, `created_at` timestamp, `updated_at` timestamp, FOREIGN KEY (`pr%Q'_indexpacts_version_id_provider_id_indexpacts_backup0CREATE UNIQUE INDEX `pacts_version_id_provider_id_index` ON "pacts_backup0" (`version_id`, `provider_id`)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)f##tableschema_infoschema_infoCREATE TABLE `schema_info` (`version` integer DEFAULT (0) NOT * ûû tºtD!AAA Consumer2017-04-02 22:24:49.6836802017-04-02 22:24:49.683680D!AAA Provider2017-04-02 22:24:49.6806802017-04-02 22:24:49.680680 ããò!A Consumer ! A Provider äÒÒóéäîversionsîp%pacticipants  pacts  versions õõ  1.0.0 ¼¼BAA1.0.02017-04-02 22:24:49.6858252017-04-02 22:24:49.687351 ûû  ››c AA]2017-04-02 22:24:49.6946142017-04-02 22:24:49.694614dfdf052a33fae8d144e48eb559a067b469c0ea2a øJ®×V D å  Mp¯µˆEE=%Q+indexsqlite_autoindex_webhook_headers_1webhook_headers/#Cindexsqlite_autoindex_webhooks_1webhooksƒR"†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`)!QOindexpacts_version_id_provider_id_indexpactsCREATE UNIQUE INDEX `pacts_version_id_provider_id_index` ON `pacts` (`version_id`, `provider_id`)„ ‡tablepactspacts CREATE TABLE `pacts`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `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 (`pf##tableschema_infoschema_infoCREATE TABLE `schema_info` (`version` integer DEFAULT (0) NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚a…%tabletagstags CREATE TABLE `tags`(`name` varchar(255) DEFAULT (NULL) NOT 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 ‚C%%„ItablepacticipantspacticipantsCREATE TABLE `pacticipants`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `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ƒk‡)tableversionsversionsCREATE TABLE `versions`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `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_contentsCREATE TABLE `pact_version_contents` (`sha` varchar(255) NOT NULL CONSTRAINT `pk_pact_version_contents` PRIMARY KEY, `content` mediumtext, `created_at` timestamp NOT NULL, `updated_at` timestamp NOT NULL)I*]7indexsqlite_autoindex_pact_version_contents_1pact_version_contents      ––0È œ ¿ ÿª>Û=9ƒ2aa…viewlatest_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 all_pacts ap inner join tags t on t.version_id = ap.consumer_version_id group by provider_id, consumer_id, t.name‚=1%%„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‚ 0SSƒ+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_id…Q/Šuviewall_pactsall_pactsCREATE VIEW `all_pacts` AS SELECT `pacts`.`id`, `c`.`id`…-Š tablepactspacts CREATE TABLE `pacts`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `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, `pact_version_content_sha` varchar(255) DEFAULT (NULL) NOT NULL, FOREIGN KEY (`pact_version_content_sha`) REFERENCES `pact_version_contents` ON DELETE NO ACTION ON UPDATE NO ACTION, 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).QOindexpacts_version_id_provider_id_indexpactsCREATE UNIQUE INDEX `pacts_version_id_provider_id_index` ON `pacts` (`version_id`, `provider_id`)…Q/Šuviewall_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`) INNER JOIN `pacticipants` AS 'c' ON (`c`.`id` = `cv`.`pacticipant_id`) INNER JOIN `pacticipants` AS 'p' ON (`p`.`id` = `pacts`.`provider_id`) INNER JOIN `pact_version_contents` AS 'pvc' ON (`pvc`.`sha` = `pacts`.`pact_version_content_sha`)‚ 0SSƒ+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_id‚=1%%„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ƒ2aa…viewlatest_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 all_pacts ap inner join tags t on t.version_id = ap.consumer_version_id group by provider_id, consumer_id, t.name‚`333„kviewlatest_tagged_pactslatest_tagged_pactsCREATE VIEW `latest_tagged_pacts` AS select ap.*, lp.tag_name from all_pacts ap inner join latest_tagged_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 ;;ƒB]…MAAdfdf052a33fae8d144e48eb559a067b469c0ea2a{ "consumer": { "name": "A Consumer" }, "provider": { "name": "A Provider" }, "interactions": [ { "description" : "a request for something", "provider_state": null, "request": { "method": "get", "path" : "/something" }, "response": { "status": 200, "body" : "something" } } ]}2017-04-02 22:24:49.6919792017-04-02 22:24:49.691979 ÔÔ+] dfdf052a33fae8d144e48eb559a067b469c0ea2a