text: BEGIN TRANSACTION;
  INSERT INTO pacticipants VALUES(1,'Animal Service',NULL,'2014-11-18 06:28:36.261868','2014-11-18 06:28:36.261868');
  INSERT INTO pacticipants VALUES(2,'Zoo App',NULL,'2014-11-18 06:28:36.290466','2014-11-18 06:28:36.290466');
  INSERT INTO pacticipants VALUES(3,'Bar',NULL,'2017-05-23 06:10:23.235822','2017-05-23 06:10:23.235822');
  INSERT INTO pacticipants VALUES(4,'Foo',NULL,'2017-05-23 06:10:23.239004','2017-05-23 06:10:23.239004');
  INSERT INTO versions VALUES(1,'1.0.0',NULL,2,0,'2014-11-18 06:28:36.295750','2014-11-18 06:28:36.333021');
  INSERT INTO versions VALUES(2,'1.0.1',NULL,2,1,'2015-01-19 22:13:57.743993','2015-01-19 22:13:57.746417');
  INSERT INTO versions VALUES(3,'1.0.2',NULL,2,2,'2016-11-08 22:45:37.244731','2016-11-08 22:45:37.274760');
  INSERT INTO versions VALUES(4,'1.0.0',NULL,4,0,'2017-05-23 06:10:23.243015','2017-05-23 06:10:23.245281');
  INSERT INTO pact_versions VALUES(1,2,1,'15a22e805caa9d0153b815fc6566a0c03d4a82ae',replace('{\n  "provider": {\n    "name": "Animal Service"\n  },\n  "consumer": {\n    "name": "Zoo App"\n  },\n  "interactions": [\n    {\n      "description": "a request for an alligator",\n      "provider_state": "there is an alligator named Mary",\n      "request": {\n        "method": "get",\n        "path": "/alligators/Mary",\n        "headers": {\n          "Accept": "application/json"\n        }\n      },\n      "response": {\n        "status": 200,\n        "headers": {\n          "Content-Type": "application/json;charset=utf-8"\n        },\n        "body": {\n          "name": "Mary"\n        }\n      }\n    },\n    {\n      "description": "a request for an alligator",\n      "provider_state": "there is not an alligator named Mary",\n      "request": {\n        "method": "get",\n        "path": "/alligators/Mary",\n        "headers": {\n          "Accept": "application/json"\n        }\n      },\n      "response": {\n        "status": 404\n      }\n    },\n    {\n      "description": "a request for an alligator",\n      "provider_state": "an error occurs retrieving an alligator",\n      "request": {\n        "method": "get",\n        "path": "/alligators/Mary",\n        "headers": {\n          "Accept": "application/json"\n        }\n      },\n      "response": {\n        "status": 500,\n        "headers": {\n          "Content-Type": "application/json;charset=utf-8"\n        },\n        "body": {\n          "error": "Argh!!!"\n        }\n      }\n    }\n  ],\n  "metadata": {\n    "pactSpecificationVersion": "1.0.0"\n  }\n}','\n',''),'2014-11-18 06:28:36.340041');
  INSERT INTO pact_versions VALUES(3,2,1,'23b64b5c5f5baf0e56dd92c4deddf9eb1e249d11',replace('{\n  "provider": {\n    "name": "Animal Service"\n  },\n  "consumer": {\n    "name": "Zoo App"\n  },\n  "interactions": [\n    {\n      "description": "a request for an alligator",\n      "provider_state": "there is an alligator named Mary",\n      "request": {\n        "method": "get",\n        "path": "/alligators/Mary",\n        "headers": {\n          "Accept": "application/json"\n        }\n      },\n      "response": {\n        "status": 200,\n        "headers": {\n          "Content-Type": "application/json;charset=utf-8"\n        },\n        "body": {\n          "name": "Mary"\n        }\n      }\n    },\n    {\n      "description": "a request for an alligator",\n      "provider_state": "there is not an alligator named Mary",\n      "request": {\n        "method": "get",\n        "path": "/alligators/Mary",\n        "headers": {\n          "Accept": "application/json"\n        }\n      },\n      "response": {\n        "status": 404\n      }\n    },\n    {\n      "description": "a request for an alligator",\n      "provider_state": "an error occurs retrieving an alligator",\n      "request": {\n        "method": "get",\n        "path": "/alligators/Mary",\n        "headers": {\n          "Accept": "application/json"\n        }\n      },\n      "response": {\n        "status": 500,\n        "headers": {\n          "Content-Type": "application/json;charset=utf-8"\n        },\n        "body": {\n          "error": "Argh!!!"\n        }\n      }\n    },\n    {\n      "description": "a request for an alligator''s sister",\n      "provider_state": "there is an alligator named Mary",\n      "request": {\n        "method": "get",\n        "path": "/alligators/Mary/sister",\n        "headers": {\n          "Accept": "application/json"\n        }\n      },\n      "response": {\n        "status": 200,\n        "headers": {\n          "Content-Type": "application/json;charset=utf-8"\n        },\n        "body": {\n          "name": "Sue"\n        }\n      }\n    }\n  ],\n  "metadata": {\n    "pactSpecificationVersion": "1.0.0"\n  }\n}','\n',''),'2015-01-19 22:15:10.964768');
  INSERT INTO pact_versions VALUES(4,4,3,'73cd294d54d900e5ebb313896b1df8d1da8914f9',replace('{\n  "consumer": {\n    "name": "Foo"\n  },\n  "provider": {\n    "name": "Bar"\n  },\n  "interactions": [\n    {\n      "description": "a retrieve thing request",\n      "request": {\n        "method": "get",\n        "path": "/thing"\n      },\n      "response": {\n        "status": 200,\n        "headers": {\n          "Content-Type": "application/json"\n        },\n        "body": [\n          {\n            "status": "4"\n          }\n        ],\n        "matchingRules": {\n          "$.body": {\n            "min": 1\n          },\n          "$.body[*].*": {\n            "match": "type"\n          },\n          "$.body[*].status": {\n            "match": "regex",\n            "regex": "\\d+"\n          }\n        }\n      }\n    }\n  ],\n  "metadata": {\n    "pactSpecification": {\n      "version": "2.0.0"\n    }\n  }\n}','\n',''),'2017-05-23 06:10:23.249813');
  INSERT INTO pact_publications VALUES(1,1,1,1,1,'2014-11-18 06:28:36.340041');
  INSERT INTO pact_publications VALUES(2,2,1,1,3,'2015-01-19 22:15:10.969518');
  INSERT INTO pact_publications VALUES(3,3,1,1,1,'2016-11-08 22:45:37.291839');
  INSERT INTO pact_publications VALUES(4,4,3,1,4,'2017-05-23 06:10:23.252829');
  COMMIT;
  