SQLite format 3@  NJI . M3--1tableversions_backup0versions_backup0 CREATE TABLE "versions_backup0"(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `number` varchar(255) DEFAULT (NULL) NULL, `repository_ref` varchar(255) DEFAULT (NULL) NULL, `p/$Cindexsqlite_autoindex_webhooks_1webhooks"QOindexpacts_version_id_provider_id_indexpacts CREATE 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 (`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`)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)7K%indexsqlite_autoindex_pacticipants_1pacticipantsC%%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_1tagsa%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`)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations~//+tableschema_migrationsschema_migrationsCREATE TABLE `sD :5n4V+M$D6t!M ;NxOlI$ ] , c ;  s ?  x U /  z V .b<!^5V,\-Kb~E\) ,Wa20180723_create_latest_verification_ids.rbVA20180722_recreate_views.rb1Uk20180721_migrate_latest_pact_publication_ids.rb0Ti20180720_create_latest_pact_publication_ids.rb8Sy20180616_migrate_consumer_ids_for_pact_publications.rb2Rm20180615_add_consumer_id_to_pact_publications.rbGQ20180614_update_latest_verification_ids_for_consumer_and_provider.rb7Pw20180613_migrate_pacticipant_ids_for_verifications.rb2Om20180612_add_pacticipant_ids_to_verifications.rb3No20180611_make_webhook_pacticipant_ids_optional.rb3Mo20180608_add_verification_to_triggered_webhook.rbDL20180524_create_latest_verifications_for_consumer_and_provider.rbDK20180523_create_latest_verifications_for_consumer_version_tags.rbJA20180330_refresh_matrix.rb*I]20180315_create_verification_sequence.rb"HM20180311_optimise_head_matrix.rb3Go20180210_fix_latest_matrix_for_cv_and_pv_again.rb=F20180209_recreate_latest_matrix_for_cv_and_pv_union_all.rb6Eu20180208_add_cv_tag_name_index_to_mat_head_matrix.rb,Da20180207_recreate_head_matrix_union_all.rb;C20180206_recreate_head_matrix_rename_consumer_tag_name.rb-Bc20180205_drop_materialized_latest_matrix.rb-Ac20180204_fix_latest_matrix_for_cv_and_pv.rb@C20180203_fix_head_matrix.rb-?c20180202_create_materialized_head_matrix.rb >I20180201_create_head_matrix.rb/=g20180131_create_materialized_latest_matrix.rb(<Y20180130_create_materialized_matrix.rb0;i20180129_create_latest_matrix_for_cv_and_pv.rb*:]20180123_create_tags_with_latest_flag.rb+9_20180122_create_head_pact_publications.rb.8e20180119_update_latest_triggered_webhooks.rb"7M20180109_migrate_trigger_type.rb'6W20180108_create_certificates_table.rb#5O20171118_create_webhook_events.rb#4O20171117_create_webhook_events.rb3E20171112_add_test_results.rb 2I000050_create_latest_matrix.rb51s000049_create_latest_verifications_for_cv_and_pv.rb0;000048_create_matrix.rb$/Q000047_create_all_verifications.rb).[000046_recreate_latest_verifications.rb5-s000045_set_verification_provider_number_nullable.rb6,u000044_populate_verifications_provider_version_id.rb0+i000043_add_provider_version_to_verification.rb&*U000042_delete_orphan_webhook_data.rb")M000041_migrate_execution_data.rb1(k000040_create_latest_triggered_webhooks_view.rb2'm000039_add_triggered_webhooks_fk_to_execution.rb+&_000038_create_triggered_webhooks_table.rb%G000037_create_labels_table.rb$$Q000036_create_webhook_execution.rb!#K000035_create_index_on_names.rb2"m000034_create_index_on_consumer_version_order.rb!G000033_create_config_table.rb' W000032_create_latest_verifications.rb I000031_create_verifications.rb%S000030_drop_old_tables_and_views.rb2m000029_create_latest_tagged_pact_publications.rb(Y000028_create_all_pact_publications.rb&U000027_populate_pact_publications.rb$Q000026_create_pact_publications.rb*]000025_make_pv_pacticipants_mandatory.rb"M000024_populate_pact_versions.rb&U000023_create_pact_versions_table.rb+_000022_create_latest_tagged_pacts_view.rb&U000021_recreate_latest_pacts_view.rb:}000020_add_pact_version_content_sha_to_all_pacts_view.rb6u000019_make_pact_version_content_sha_not_nullable.rb/g000018_drop_json_content_column_from_pacts.rb?000017_migrate_json_content_to_pact_version_content_table.rb1k000016_add_pact_content_foreign_key_to_pacts.rb'W000015_create_pact_version_content.rb(Y000014_add_timestamps_to_pact_views.rb# O000013_add_columns_to_webhooks.rb! K000012_create_webhooks_table.rb% S000011_made_timestamps_mandatory.rb G000010_populate_timestamps.rb =000009_add_timestamps.rb#O000008_create_latest_pact_view.rb(Y000007_increase_json_content_length.rb.e000006_make_version_foreign_key_mandatory.rb'W000005_add_order_column_to_version.rbC000004_create_tags_table.rbE000003_create_pacts_table.rb!K000002_create_versions_table.rb$Q000001_create_pacticipant_tabLWKuKb> M  | N % X # W 3 S . a5vP*|OlLF~_e0w< A20180722_recreate_views.rbV3k20180721_migrate_latest_pact_publication_ids.rbU2i20180720_create_latest_pact_publication_ids.rbT:y20180616_migrate_consumer_ids_for_pact_publications.rbS4m20180615_add_consumer_id_to_pact_publications.rbRI20180614_update_latest_verification_ids_for_consumer_and_provider.rbQ9w20180613_migrate_pacticipant_ids_for_verifications.rbP4m20180612_add_pacticipant_ids_to_verifications.rbO5o20180611_make_webhook_pacticipant_ids_optional.rbN5o20180608_add_verification_to_triggered_webhook.rbMF20180524_create_latest_verifications_for_consumer_and_provider.rbLF20180523_create_latest_verifications_for_consumer_version_tags.rbKA20180330_refresh_matrix.rbJ,]20180315_create_verification_sequence.rbI$M20180311_optimise_head_matrix.rbH5o20180210_fix_latest_matrix_for_cv_and_pv_again.rbG?20180209_recreate_latest_matrix_for_cv_and_pv_union_all.rbF8u20180208_add_cv_tag_name_index_to_mat_head_matrix.rbE.a20180207_recreate_head_matrix_union_all.rbD=20180206_recreate_head_matrix_rename_consumer_tag_name.rbC/c20180205_drop_materialized_latest_matrix.rbB/c20180204_fix_latest_matrix_for_cv_and_pv.rbAC20180203_fix_head_matrix.rb@/c20180202_create_materialized_head_matrix.rb?"I20180201_create_head_matrix.rb>1g20180131_create_materialized_latest_matrix.rb=*Y20180130_create_materialized_matrix.rb<2i20180129_create_latest_matrix_for_cv_and_pv.rb;,]20180123_create_tags_with_latest_flag.rb:-_20180122_create_head_pact_publications.rb90e20180119_update_latest_triggered_webhooks.rb8$M20180109_migrate_trigger_type.rb7)W20180108_create_certificates_table.rb6%O20171118_create_webhook_events.rb5%O20171117_create_webhook_events.rb4 E20171112_add_test_results.rb3"I000050_create_latest_matrix.rb27s000049_create_latest_verifications_for_cv_and_pv.rb1;000048_create_matrix.rb0&Q000047_create_all_verifications.rb/+[000046_recreate_latest_verifications.rb.7s000045_set_verification_provider_number_nullable.rb-8u000044_populate_verifications_provider_version_id.rb,2i000043_add_provider_version_to_verification.rb+(U000042_delete_orphan_webhook_data.rb*$M000041_migrate_execution_data.rb)3k000040_create_latest_triggered_webhooks_view.rb(4m000039_add_triggered_webhooks_fk_to_execution.rb'-_000038_create_triggered_webhooks_table.rb&!G000037_create_labels_table.rb%&Q000036_create_webhook_execution.rb$#K000035_create_index_on_names.rb#4m000034_create_index_on_consumer_version_order.rb"!G000033_create_config_table.rb!)W000032_create_latest_verifications.rb "I000031_create_verifications.rb'S000030_drop_old_tables_and_views.rb4m000029_create_latest_tagged_pact_publications.rb*Y000028_create_all_pact_publications.rb(U000027_populate_pact_publications.rb&Q000026_create_pact_publications.rb,]000025_make_pv_pacticipants_mandatory.rb$M000024_populate_pact_versions.rb(U000023_create_pact_versions_table.rb-_000022_create_latest_tagged_pacts_view.rb(U000021_recreate_latest_pacts_view.rb<}000020_add_pact_version_content_sha_to_all_pacts_view.rb8u000019_make_pact_version_content_sha_not_nullable.rb1g000018_drop_json_content_column_from_pacts.rbA000017_migrate_json_content_to_pact_version_content_table.rb3k000016_add_pact_content_foreign_key_to_pacts.rb)W000015_create_pact_version_content.rb*Y000014_add_timestamps_to_pact_views.rb%O000013_add_columns_to_webhooks.rb #K000012_create_webhooks_table.rb 'S000011_made_timestamps_mandatory.rb !G000010_populate_timestamps.rb =000009_add_timestamps.rb %O000008_create_latest_pact_view.rb*Y000007_increase_json_content_length.rb0e000006_make_version_foreign_key_mandatory.rb)W000005_add_order_column_to_version.rbC000004_create_tags_table.rb E000003_create_pacts_table.rb#K000002_create_versions_tablI&Q000047_create_all_verifications.rb/   T=s=Q1triggered_webhooksO7T-webhooks_backup01webhook_executions UwebhooksR'verificationsK/pact_publications versions%pacticipants pacts 'pact_versions      = ,  # 8 S-indexsqlite_autoindex_webhooks_backup0_1webhooks_backup0 O--Ktablewebhooks_backup0webhooks_backup0 CREATE TABLE "webhooks_backup0" (`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, ??tablepact_publications_backup0pact_publications_backup0CREATE TABLE "pact_publications_backup0" (`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, `consumer_id` integer REFERENCES `pacticipants`):5'Sindexunq_pvc_con_prov_shapact_versionsCREATE UNIQUE INDEX `unq_pvc_con_prov_sha` ON `pact_versions` (`consumer_id`, `provider_id`, `sha`)%9'' 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%%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_1tagsa%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)=&Q+indexsqlite_autoindex_webhook_headers_1webhook_headers %++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`))1Cindexsqlite_autoindex_webhooks_1webhooksUWindexversions_pacticipant_id_number_indexversionsCREATE UNIQUE INDEX `versions_pacticipant_id_number_index` ON `versions` (`pacticipant_id`, `number`)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)7K%indexsqlite_autoindex_pacticipants_1pacticipantsP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations~//+tableschema_migrationsschema_migrationsCREATE TABLE `schema_migrations` (`filename` varchar(255) NOT NULL PRIMARY KEY)      c WRRK#sindexndx_ver_numversionsCREATE INDEX `ndx_ver_num` ON `versions` (`number`)\J+indexunq_config_nameconfig CREATE UNIQUE INDEX `unq_config_name` ON `config` (`name`)rI?tableconfigconfigCREATE TABLE `config` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `value` mediumtext, `created_at` timestamp NOT NULL, `updated_at` timestamp NOT NULL)$DKKCviewlatest_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_orderJaaMviewlatest_tagged_pact_consumer_version_orderslatest_tagged_pactqM))indexuq_ver_ppt_ordversionsCREATE UNIQUE INDEX `uq_ver_ppt_ord` ON `versions` (`pacticipant_id`, `order`)QL#qindexndx_ver_ordversionsCREATE INDEX `ndx_ver_ord` ON `versions` (`order`)RK#sindexndx_ver_numversionsCREATE INDEX `ndx_ver_num` ON `versions` (`number`)\J+indexunq_config_nameconfig CREATE UNIQUE INDEX `unq_config_name` ON `config` (`name`)B==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_orderSSCviewlatest_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_idggviewlatest_pact_publications_by_consumer_versionslatest_pact_publications_by_consumer_versionsCREATE VIEW `latest_pact_publicatio=)?_indexcv_prov_id_ndxpact_publications_backup0CREATE INDEX `cv_prov_id_ndx` ON "pact_publications_backup0" (`consumer_version_id`, `provider_id`, `id`)5?indexcv_prov_revision_unqpact_publications_backup0CREATE UNIQUE INDEX `cv_prov_revision_unq` ON "pact_publications_backup0" (`consumer_version_id`, `provider_id`, `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_orderZ>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`)@)/Oindexcv_prov_id_ndxpact_publicationsCREATE INDEX `cv_prov_id_ndx` ON `pact_publications` (`consumer_version_id`, `provider_id`, `id`)5/indexcv_prov_revision_unqpact_publicationsCREATE UNIQUE INDEX `cv_prov_revision_unq` ON `pact_publications` (`consumer_version_id`, `provider_id`, `revision_number`)         XJ -5`5?indexcv_prov_revision_unqpact_publications_backup0CREATE UNIQUE INDEX `cv_prov_revision_unq` ON "pact_publications_backup0" (`consumer_version_id`, `provider_id`, `revision_number`)??tablepact_pub !)/Oindexcv_prov_id_ndxpact_publicationsCREATE INDEX `cv_prov_id_ndx` ON `pact_publications` (`consumer_version_id`, `provider_id`, `id`)- 5/indexcv_prov_revision_unqpact_publicationsCREATE UNIQUE INDEX `cv_prov_revision_unq` ON `pact_publications` (`consumer_version_id`, `provider_id`, `revision_number`)b//stablepact_publicationspact_publicationsCREATE TABLE `pact_publications`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `consumer_version_id` integer DEFAULT (NULL) NOT NULL, `provider_id` integer DEFAULT (NULL) NOT NULL, `revision_number` integer DEFAULT (NULL) NOT NULL, `pact_version_id` integer DEFAULT (NULL) NOT NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `consumer_id` integer REFERENCES `pacticipants`, FOREIGN KEY (`consumer_version_id`) REFERENCES `versions` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`provider_id`) REFERENCES `pacticipants` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`pact_version_id`) REFERENCES `pact_versions` ON DELETE NO ACTION ON UPDATE NO ACTION)+aakviewlatest_verifications_for_provider_versionslatest_verifications_for_provider_versionsCREATE VIEW `latest_verifications_for_provider_versions` AS SELECT `verifications`.`id`, `verifications`.`number`, `verifications`.`success`, `verifications`.`build_url`, `verifications`.`pact_version_id`, `verifications`.`execution_date`, `verifications`.`created_at`, `verifications`.`provider_version_id`, `s`.`number` AS 'provider_version_number', `s`.`order` AS 'provider_version_order' FROM `verifications` INNER JOIN `latest_verification_ids_for_provider_versions` AS 'lv' ON ((`verifications`.`pact_version_id` = `lv`.`pact_version_id`) AND (`verifications`.`id` = `lv`.`latest_verification_id`)) INNER JOIN `versions` AS 's' ON (`verifications`.`provider_version_id` = `s`.`id`)mY11tablewebhook_executionswebhook_executions CREATE TABLE `webhook_executions`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `webhook_id` integer DEFAULT (NULL) NULL, `pact_publication_id` integer DEFAULT (NULL) NULL, `consumer_id` integer DEFAULT (NULL) NULL, `provider_id` integer DEFAULT (NULL) NULL, `success` Boolean DEFAULT (NULL) NOT NULL, `logs` mediumtext DEFAULT (NULL) NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `triggered_webhook_id` integer DEFAULT (NULL) NULL, FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`pact_publication_id`) REFERENCES `pact_publications` ON DELETE NO ACTION ON UPDATE NO ACTION, 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, FOREIGN KEY (`triggered_webhook_id`) REFERENCES `triggered_webhooks` ON DELETE NO ACTION ON UPDATE NO ACTION)+R?indexsqlite_autoindex_labels_1labels" Qqtablelabelslabels!CREATE TABLE `labels` (`name` varchar(255) NOT NULL, `pacticipant_id` integer NOT NULL REFERENCES `pacticipants`, `created_at` timestamp NOT NULL, `updated_at` timestamp NOT NULL, CONSTRAINT `labels_pk` PRIMARY KEY (`pacticipant_id`, `name`))JO%iindexndx_tag_nametagsCREATE INDEX `ndx_tag_name` ON `tags` (`name`)ZN%%yindexndx_ppt_namepacticipantsCREATE INDEX `ndx_ppt_name` ON `pacticipants` (`name`)           % hf ?B--/tablewebhooks_backup0webhooks_backup0;CREATE TABLE "webhooks_backup0"(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `uuid` varchar(255) DEFAULT (NULL) NOT NULL UNIQUE, `method` varchar(255) DEFAULT (NULL) NOT NULL, `url` varchar(255) DEFAULT (NU3D//viewall_verificationsall_verificationsCREATE VIEW `all_verifications` AS SELECT `verifications`.`id`, `verifications`.`number`, `success`, `provider_version_id`, `v`.`number` AS 'provider_version_number', `v`.`order` AS 'provider_version_order', `build_url`, `pact_version_id`, `execution_date`, `verifications`.`created_at` FROM `verifications` INNER JOIN `versions` AS 'v' ON (`v`.`id` = `verifications`.`provider_version_id`)_BCCIviewlatest_verification_numberslatest_verification_numbersCREATE VIEW `latest_verification_numbers` AS SELECT pact_version_id, MAX(number) latest_number FROM verifications GROUP BY pact_version_id5Aa'oindexverifications_pact_version_id_number_indexverifications CREATE UNIQUE INDEX `verifications_pact_version_id_number_index` ON `verifications` (`pact_version_id`, `number`)E@''ItableverificationsverificationsCREATE TABLE `verifications`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `number` integer DEFAULT (NULL) NULL, `success` Boolean DEFAULT (NULL) NOT NULL, `provider_version` varchar(255) DEFAULT (NULL) NULL, `build_url` varchar(255) DEFAULT (NULL) NULL, `pact_version_id` integer DEFAULT (NULL) NOT NULL, `execution_date` timestamp DEFAULT (NULL) NOT NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `provider_version_id` integer DEFAULT (NULL) NULL, `test_results` mediumtext, `consumer_id` integer REFERENCES `pacticipants`, `provider_id` integer REFERENCES `pacticipants`, FOREIGN KEY (`pact_version_id`) REFERENCES `pact_versions` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`provider_version_id`) REFERENCES `versions` ON DELETE NO ACTION ON UPDATE NO ACTION)90C1 indexuq_triggered_webhook_ppi_witriggered_webhooks#CREATE UNIQUE INDEX `uq_triggered_webhook_ppi_wi` ON `triggered_webhooks` (`pact_publication_id`, `webhook_id`, `trigger_uuid`)/;1Uindexuq_triggered_webhook_witriggered_webhooks CREATE UNIQUE INDEX `uq_triggered_webhook_wi` ON `triggered_webhooks` (`webhook_id`, `trigger_uuid`)9.11tabletriggered_webhookstriggered_webhooks%CREATE TABLE `triggered_webhooks`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `trigger_uuid` varchar(255) DEFAULT (NULL) NOT NULL, `trigger_type` varchar(255) DEFAULT (NULL) NOT NULL, `pact_publication_id` integer DEFAULT (NULL) NOT NULL, `webhook_id` integer DEFAULT (NULL) NULL, `webhook_uuid` varchar(255) DEFAULT (NULL) NOT NULL, `consumer_id` integer DEFAULT (NULL) NOT NULL, `provider_id` integer DEFAULT (NULL) NOT NULL, `status` varchar(255) DEFAULT (NULL) NOT NULL, `created_at` timestamp DEFAULT (NULL) NOT NULL, `updated_at` timestamp DEFAULT (NULL) NOT NULL, `verification_id` integer REFERENCES `verifications`, FOREIGN KEY (`pact_publication_id`) REFERENCES `pact_publications` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`webhook_id`) REFERENCES `webhooks` ON DELETE NO ACTION ON UPDATE NO ACTION, 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)       l [hd 0F  Sviewlatest_verification_id_for_consumer_version_and_provider_versionlatest_verification_id_for_consumer_version_and_provider_versionCREATE VIEW `latest_verification_id_for_consumer_version_and_provider_version` AS select consumer_version_id, provider_version_id, max(verification_id) as latest_veriMEE-viewlatest_triggered_webhook_idslatest_triggered_webhook_idsCREATE VIEW `latest_triggered_webhook_ids` AS select tw.webhook_uuid, tw.consumer_id, tw.provider_id, ltwcd.latest_triggered_webhook_created_at, max(tw.id) as latest_triggered_webhook_id from latest_triggered_webhook_creation_dates ltwcd inner join triggered_webhooks tw on tw.consumer_id = ltwcd.consumer_id and tw.provider_id = ltwcd.provider_id and tw.webhook_uuid = ltwcd.webhook_uuid and tw.created_at = ltwcd.latest_triggered_webhook_created_at group by tw.webhook_uuid, tw.consumer_id, tw.provider_id, ltwcd.latest_triggered_webhook_created_atKL[[qviewlatest_triggered_webhook_creation_dateslatest_triggered_webhook_creation_datesCREATE VIEW `latest_triggered_webhook_creation_dates` AS select webhook_uuid, consumer_id, provider_id, max(created_at) as latest_triggered_webhook_created_at from triggered_webhooks group by webhook_uuid, consumer_id, provider_id7KK%indexsqlite_autoindex_certificates_1certificates(:J%%7tablecertificatescertificates'CREATE TABLE `certificates` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `uuid` varchar(255) NOT NULL CONSTRAINT `uq_certificate_uuid` UNIQUE, `description` varchar(255) NULL, `content` mediumtext NOT NULL, `created_at` timestamp NOT NULL, `updated_at` timestamp NOT NULL)xI1)#indexuq_webhook_id_namewebhook_events&CREATE UNIQUE INDEX `uq_webhook_id_name` ON `webhook_events` (`id`, `name`) H))Utablewebhook_eventswebhook_eventsCREATE TABLE `webhook_events` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `webhook_id` integer REFERENCES `webhooks` ON DELETE CASCADE, `name` varchar(255), `created_at` timestamp NOT NULL, `updated_at` timestamp NOT NULL)  Sviewlatest_verification_id_for_consumer_version_and_provider_versionlatest_verification_id_for_consumer_version_and_provider_versionCREATE VIEW `latest_verification_id_for_consumer_version_and_provider_version` AS select consumer_version_id, provider_version_id, max(verification_id) as latest_verification_id from matrix inner join latest_pact_publication_revision_numbers lr on matrix.consumer_id = lr.consumer_id and matrix.provider_id = lr.provider_id and matrix.consumer_version_order = lr.consumer_version_order and matrix.pact_revision_number = lr.latest_revision_number group by consumer_version_id, provider_version_id\EviewmatrixmatrixCREATE VIEW `matrix` AS SELECT `all_pact_publications`.`consumer_id`, `all_pact_publications`.`consumer_name`, `all_pact_publications`.`consumer_version_id`, `all_pact_publications`.`consumer_version_number`, `all_pact_publications`.`consumer_version_order`, `all_pact_publications`.`id` AS 'pact_publication_id', `all_pact_publications`.`pact_version_id`, `all_pact_publications`.`pact_version_sha`, `all_pact_publications`.`revision_number` AS 'pact_revision_number', `all_pact_publications`.`created_at` AS 'pact_created_at', `all_pact_publications`.`provider_id`, `all_pact_publications`.`provider_name`, `versions`.`id` AS 'provider_version_id', `versions`.`number` AS 'provider_version_number', `versions`.`order` AS 'provider_version_order', `verifications`.`id` AS 'verification_id', `verifications`.`success`, `verifications`.`number` AS 'verification_number', `verifications`.`execution_date` AS 'verification_executed_at', `verifications`.`build_url` AS 'verification_build_url' FROM `all_pact_publications` LEFT OUTER JOIN `verifications` ON (`verifications`.`pact_version_id` = `all_pact_publications`.`pact_version_id`) LEFT OUTER JOIN `versions` ON (`versions`.`id` = `verifications`.`provider_version_id`)         '7  2& '13!indexndx_mm_provider_idmaterialized_matrix-CREATE INDEX `ndx_mm_provider_id` ON `materialized_matrix` (`provider_id`)Q77?viewtags_with_latest_flagtags_with_latest_flagCREATE VIEW `tags_with_latest_flag` AS select t.*, ltvo.latest from tags t inner join versions v on v.id = t.version_id left outer join latest_tagged_version_orders ltvo on t.name = ltvo.tag_name and v.pacticipant_id = ltvo.pacticipant_id and v.`order` = ltvo.latest_version_orderUPEE1viewlatest_tagged_version_orderslatest_tagged_version_ordersCREATE VIEW `latest_tagged_version_orders` AS select v.pacticipant_id, t.name as tag_name, max(v.`order`) as latest_version_order, 1 as latest from tags t inner join versions v on v.id = t.version_id group by v.pacticipant_id, t.nameO99?viewhead_pact_publicationshead_pact_publicationsCREATE VIEW `head_pact_publications` AS select lp.*, null as tag_name, 1 as latest from latest_pact_publications lp UNION select ltp.*, null as latest from latest_tagged_pact_publications ltpN??viewlatest_triggered_webhookslatest_triggered_webhooksCREATE VIEW `latest_triggered_webhooks` AS select tw.* from triggered_webhooks tw inner join latest_triggered_webhook_ids ltwi on tw.consumer_id = ltwi.consumer_id and tw.provider_id = ltwi.provider_id and tw.webhook_uuid = ltwi.webhook_uuid and tw.id = ltwi.latest_triggered_webhook_id EE-|V13!indexndx_mm_consumer_idmaterialized_matrix,CREATE INDEX `ndx_mm_consumer_id` ON `materialized_matrix` (`consumer_id`)yT''5viewlatest_matrixlatest_matrixCREATE VIEW `latest_matrix` AS SELECT matrix.* FROM latest_matrix_for_consumer_version_and_provider_version matrix INNER JOIN latest_pact_consumer_version_orders lpcvo ON matrix.consumer_id = lpcvo.consumer_id AND matrix.provider_id = lpcvo.provider_id AND matrix.consumer_version_order = lpcvo.latest_consumer_version_order INNER JOIN latest_verification_id_for_consumer_version_and_provider AS lv ON ((matrix.consumer_version_id = lv.consumer_version_id) AND (matrix.provider_id = lv.provider_id) AND ((matrix.verification_id = lv.latest_verification_id))) UNION SELECT matrix.* FROM latest_matrix_for_consumer_version_and_provider_version matrix INNER JOIN latest_pact_consumer_version_orders lpcvo ON matrix.consumer_id = lpcvo.consumer_id AND matrix.provider_id = lpcvo.provider_id AND matrix.consumer_version_order = lpcvo.latest_consumer_version_order where verification_id is nullaS}}Yviewlatest_verification_id_for_consumer_version_and_providerlatest_verification_id_for_consumer_version_and_providerCREATE VIEW `latest_verification_id_for_consumer_version_and_provider` AS select matrix.consumer_version_id, matrix.provider_id, max(verification_id) as latest_verification_id from latest_matrix_for_consumer_version_and_provider_version matrix where matrix.verification_id is not null group by matrix.consumer_version_id, matrix.provider_id9{{mviewlatest_matrix_for_consumer_version_and_pro0U33tablematerialized_matrixmaterialized_matrix*CREATE TABLE `materialized_matrix` (`consumer_id` integer NOT NULL, `consumer_name` varchar(255) NOT NULL, `consumer_version_id` integer NOT NULL, `consumer_version_number` varchar(255) NOT NULL, `consumer_version_order` integer NOT NULL, `pact_publication_id` integer NOT NULL, `pact_version_id` integer NOT NULL, `pact_version_sha` varchar(255) NOT NULL, `pact_revision_number` integer NOT NULL, `pact_created_at` timestamp NOT NULL, `provider_id` integer NOT NULL, `provider_name` varchar(255) NOT NULL, `provider_version_id` integer, `provider_version_number` varchar(255), `provider_version_order` integer, `verification_id` integer, `success` Boolean, `verification_number` integer, `verification_executed_at` timestamp, `verification_build_url` varchar(255))  - ' I##yviewhead_matrixhead_matrixCREATE VIEW `head_matrix` AS SELECT matrix.*, hpp.tag_name as consumer_version_tag_name FROM latest_matrix_for_consumer_version_and_provider_version matrix INNER JOIN head_pact_publications hpp ON matrix.consumer_id = hpp.consumer_id AND matrix.provider_id = hpp.provider_id AND matrix.consumer_version_order = hpp.consumer_vers3n{{viewlatest_matrix_for_consumer_version_and_provider_versionlatest_matrix_for_consumer_version_and_provider_versionCREATE VIEW `latest_matrix_for_consumer_version_and_provider_version` AS SELECT matrix.* FROM materialized_matrix matrix inner join latest_pact_publication_revision_numbers lr on matrix.consumer_id = lr.consumer_id and matrix.provider_id = lr.provider_id and matrix.consumer_version_order = lr.consumer_version_order and matrix.pact_revision_number = lr.latest_revision_number INNER JOIN latest_verification_id_for_consumer_version_and_provider_version AS lv ON ((matrix.consumer_version_id = lv.consumer_version_id) AND (matrix.provider_version_id = lv.provider_version_id) AND ((matrix.verification_id = lv.latest_verification_id))) UNION ALL select matrix.* from materialized_matrix matrix inner join latest_pact_publication_revision_numbers lr on matrix.consumer_id = lr.consumer_id and matrix.provider_id = lr.provider_id and matrix.consumer_version_order = lr.consumer_version_order and matrix.pact_revision_number = lr.latest_revision_number where verification_id is nullm335indexndx_mm_pact_rev_nummaterialized_matrix8CREATE INDEX `ndx_mm_pact_rev_num` ON `materialized_matrix` (`pact_revision_number`)zl+3#indexndx_mm_verif_idmaterialized_matrix7CREATE INDEX `ndx_mm_verif_id` ON `materialized_matrix` (`verification_id`)`j}=indexmaterialized_head_matrix_consumer_version_tag_name_indexmaterialized_head_matrix3CREATE INDEX `materialized_head_matrix_consumer_version_tag_name_index` ON `materialized_head_matrix` (`consumer_version_tag_name`)h3=-indexndx_mhm_consumer_idmaterialized_head_matrix2CREATE INDEX `ndx_mhm_consumer_id` ON `materialized_head_matrix` (`consumer_id`)g3=-indexndx_mhm_provider_idmaterialized_head_matrix1CREATE INDEX `ndx_mhm_provider_id` ON `materialized_head_matrix` (`provider_id`) f)=9indexndx_mhm_cv_ordmaterialized_head_matrix0CREATE INDEX `ndx_mhm_cv_ord` ON `materialized_head_matrix` (`consumer_version_order`)Pe==3tablematerialized_head_matrixmaterialized_head_matrix/CREATE TABLE `materialized_head_matrix`(`consumer_id` integer DEFAULT (NULL) NOT NULL, `consumer_name` varchar(255) DEFAULT (NULL) NOT NULL, `consumer_version_id` integer DEFAULT (NULL) NOT NULL, `consumer_version_number` varchar(255) DEFAULT (NULL) NOT NULL, `consumer_version_order` integer DEFAULT (NULL) NOT NULL, `pact_publication_id` integer DEFAULT (NULL) NOT NULL, `pact_version_id` integer DEFAULT (NULL) NOT NULL, `pact_version_sha` varchar(255) DEFAULT (NULL) NOT NULL, `pact_revision_number` integer DEFAULT (NULL) NOT NULL, `pact_created_at` timestamp DEFAULT (NULL) NOT NULL, `provider_id` integer DEFAULT (NULL) NOT NULL, `provider_name` varchar(255) DEFAULT (NULL) NOT NULL, `provider_version_id` integer DEFAULT (NULL) NULL, `provider_version_number` varchar(255) DEFAULT (NULL) NULL, `provider_version_order` integer DEFAULT (NULL) NULL, `verification_id` integer DEFAULT (NULL) NULL, `success` Boolean DEFAULT (NULL) NULL, `verification_number` integer DEFAULT (NULL) NULL, `verification_executed_at` timestamp DEFAULT (NULL) NULL, `verification_build_url` varchar(255) DEFAULT (NULL) NULL, `consumer_version_tag_name` varchar(255) DEFAULT (NULL) NULL)}X'3-indexndx_mm_cv_ordmaterialized_matrix.CREATE INDEX `ndx_mm_cv_ord` ON `materialized_matrix` (`consumer_version_order`)|W13!indexndx_mm_provider_idmaterialized_matrix-CREATE INDEX `ndx_mm_provider_id` ON `materialized_matrix` (`provider_id`) \ #  \{{viewlatest_matrix_for_consumer_version_and_provider_vers \##sviewhead_matrixhead_matrixCREATE VIEW `head_matrix` AS select p.consumer_id, p.consumer_name, p.consumer_version_id, p.consumer_version_number, p.consumer_version_order, p.id as pact_publication_id, p.pact_version_id, p.pact_version_sha, p.revision_number as pact_revision_number, p.created_at as pact_created_at, p.provider_id, p.provider_name, lv.provider_version_id, lv.provider_version_number, lv.provider_version_order, lv.id as verification_id, lv.success, lv.number as verification_number, lv.execution_date as verification_executed_at, lv.build_url as verification_build_url, null as consumer_version_tag_name from latest_pact_publications p left outer join latest_verifications lv on p.pact_version_id = lv.pact_version_id union all select p.consumer_id, p.consumer_name, p.consumer_version_id, p.consumer_version_number, p.consumer_version_order, p.id as pact_publication_id, p.pact_version_id, p.pact_version_sha, p.revision_number as pact_revision_number, p.created_at as pact_created_at, p.provider_id, p.provider_name, lv.provider_version_id, lv.provider_version_number, lv.provider_version_order, lv.id as verification_id, lv.success, lv.number as verification_number, lv.execution_date as verification_executed_at, lv.build_url as verification_build_url, lt.tag_name as consumer_version_tag_name from latest_tagged_pact_consumer_version_orders lt inner join latest_pact_publications_by_consumer_versions p on lt.consumer_id = p.consumer_id and lt.provider_id = p.provider_id and lt.latest_consumer_version_order = p.consumer_version_order left outer join latest_verifications lv on p.pact_version_id = lv.pact_version_idQoaaqviewlatest_tagged_pact_consumer_version_orderslatest_tagged_pact_consumer_version_ordersCREATE VIEW `latest_tagged_pact_consumer_version_orders` AS SELECT `pact_publications`.`provider_id`, `cv`.`pacticipant_id` AS 'consumer_id', `t`.`name` AS 'tag_name', max(`order`) AS 'latest_consumer_version_order' FROM `pact_publications` INNER JOIN `versions` AS 'cv' ON (`pact_publications`.`consumer_version_id` = `cv`.`id`) INNER JOIN `tags` AS 't' ON (`t`.`version_id` = `pact_publications`.`consumer_version_id`) GROUP BY `pact_publications`.`provider_id`, `cv`.`pacticipant_id`, `t`.`name`n}=indexmaterialized_head_matrix_consumer_version_tag_name_indexmaterialized_head_matrix3CREATE INDEX FtiiKviewlatest_verifications_for_consumer_version_tagslatest_verifications_for_consumer_version_tagsCREATE VIEW `latest_verifications_for_consumer_version_tags` AS SELECT `lv`.`consumer_id`, `lv`.`provider_id`, `lv`.`consumer_version_tag_name`, `pv`.`sha` AS 'pact_version_sha', `prv`.`number` AS 'provider_version_number', `prv`.`order` AS 'provider_version_order', `verifications`.* FROM `verifications` INNER JOIN `latest_verification_ids_for_consumer_version_tags` AS 'lv' ON (`verifications`.`id` = `lv`.`latest_verification_id`) INNER JOIN `versions` AS 'prv' ON (`verifications`.`provider_version_id` = `prv`.`id`) INNER JOIN `pact_versions` AS 'pv' ON (`verifications`.`pact_version_id` = `pv`.`id`) rEEtableverification_sequence_numberverification_sequence_number9CREATE TABLE `verification_sequence_number` (`value` integer NOT NULL)Yp55Yviewlatest_verificationslatest_verificationsCREATE VIEW `latest_verifications` AS SELECT `verifications`.`id`, `verifications`.`number`, `verifications`.`success`, `s`.`number` AS 'provider_version', `verifications`.`build_url`, `verifications`.`pact_version_id`, `verifications`.`execution_date`, `verifications`.`created_at`, `verifications`.`provider_version_id`, `s`.`number` AS 'provider_version_number', `s`.`order` AS 'provider_version_order' FROM `verifications` INNER JOIN `latest_verification_numbers` AS 'lv' ON ((`verifications`.`pact_version_id` = `lv`.`pact_version_id`) AND (`verifications`.`number` = `lv`.`latest_number`)) INNER JOIN `versions` AS 's' ON (`verifications`.`provider_version_id` = `s`.`id`)   d 6 ! d2a n!z 6oindexsqlite_autoindex_latest_pact_publication_ids_for_consumer_versions_1latest_pact_publication_ids_for_consumer_versionsBIooAtablelatest_pact_publication_ids_for_consumer_versionslatest_pact_publication_ids_for_consumer_versionsACREATE TABLE `latest_pact_publication_ids_for_consumer_versions` (`consumer_id` integer NOT NULL REFERENCES `pacticipants` ON DELETE CASCADE, `consumer_version_id` integer NOT NULL REFERENCES `versions` ON DELETE CASCADE, `provider_id` integer NOT NULL REFERENCES `pacticipants` ON DELETE CASCADE, `pact_publication_id` integer NOT NULL UNIQUE REFERENCES `pact_publications` ON DELETE CASCADE, `pact_version_id` integer NOT NULL REFERENCES `pact_versions` ON DELETE CASCADE)S/?indexpact_publications_consumer_id_indexpact_publications@CREATE INDEX `pact_publications_consumer_id_index` ON `pact_publications` (`consumer_id`)QooUviewlatest_verification_ids_for_consumer_and_providerlatest_verification_ids_for_consumer_and_providerCREATE VIEW `latest_verification_ids_for_consumer_and_provider` AS select provider_id, consumer_id, max(id) as latest_verification_id from verifications v group by provider_id, consumer_id1c'eindexverifications_provider_id_consumer_id_indexverifications?CREATE INDEX `verifications_provider_id_consumer_id_index` ON `verifications` (`provider_id`, `consumer_id`) ~K'/indexverifications_provider_id_indexverifications&{tablewebhookswebhooks=CREATE TABLE `webhooks`(`id` integer DEFAULT (NULL) NOT NULL PRIMARY KEY AUTOINCREMENT, `uuid` varchar(255) DEFAULT (NULL) NOT NULL UNIQUE, `method` varchar(255) DEFAULT (NULL) NOT NULL, `url` varchar(255) DEFAULT (NULL) NOT NULL, `body` varchar(255) DEFAULT (NULL) NULL, `is_json_request_body` Boolean DEFAULT (NULL) NULL, `consumer_id` integer DEFAULT (NULL) NULL, `provider_id` integer DEFAULT (NULL) NULL, `created_at` timestamp DEFAULT (NULL) NULL, `updated_at` timestamp DEFAULT (NULL) NULL, `username` varchar(255) DEFAULT (NULL) NULL, `password` varchar(255) DEFAULT (NULL) 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)$viiviewlatest_verifications_for_consumer_and_providerlatest_verifications_for_consumer_and_providerCREATE VIEW `latest_verifications_for_consumer_and_provider` AS SELECT `lv`.`consumer_id`, `lv`.`provider_id`, `pv`.`sha` AS 'pact_version_sha', `prv`.`number` AS 'provider_version_number', `prv`.`order` AS 'provider_version_order', `verifications`.* FROM `verifications` INNER JOIN `latest_verification_ids_for_consumer_and_provider` AS 'lv' ON (`verifications`.`id` = `lv`.`latest_verification_id`) INNER JOIN `versions` AS 'prv' ON (`verifications`.`provider_version_id` = `prv`.`id`) INNER JOIN `pact_versions` AS 'pv' ON (`verifications`.`pact_version_id` = `pv`.`id`)oiiKviewlatest_verifications_for_consumer_version_tagslatest_verifications_for_consumer_version_tagsCREAeOoindexlpp_provider_id_consumer_id_indexlatest_pact_publication_ids_for_consumer_versionsECREATE INDEX `lpp_provider_id_consumer_id_index` ON `latest_pact_publication_ids_for_consumer_versions` (`provider_id`, `consumer_id`)hCo+indexunq_latest_ppid_prov_converlatest_pact_publication_ids_for_consumer_versionsCCREATE UNIQUE INDEX `unq_latest_ppid_prov_conver` ON `latest_pact_publication_ids_for_consumer_versions` (`provider_id`, `consumer_version_id`)oindexsqlite_autoindex_latest_pact_publication_ids_for_consumer_versions_1latest_pact_publication_ids_for_consumer_versionsB          N oa  xhb1UEindexlatest_v_id_for_pv_and_pv_pv_id_v_idlatest_verification_id_l oo viewlatest_verification_ids_for_consumer_version_tagslatest_verification_ids_for_consumer_version_tagsCREATE VIEW `latest_verification_ids_for_consumer_version_tags` AS select v.provider_id, v.consumer_id, t.name as consumer_version_tag_name, max(v.verification_id) as latest_verification_id from latest_verification_id_for_pact_version_and_provider_version v join latest_pact_publication_ids_for_consumer_versions lpp on v.pact_version_id = lpp.pact_version_id join tags t on lpp.consumer_version_id = t.version_id group by v.provider_id, v.consumer_id, t.name_  1viewlatest_verification_id_for_consumer_version_and_provider_versionlatest_verification_id_for_consumer_version_and_provider_versionCREATE VIEW `latest_verification_id_for_consumer_version_and_provider_version` AS select pp.consumer_version_id, lv.provider_version_id, lv.verification_id as latest_verification_id from latest_pact_publication_ids_for_consumer_versions lpp inner join pact_publications pp on pp.id = lpp.pact_publication_id left outer join latest_verification_id_for_pact_version_and_provider_version lv on lv.pact_version_id = pp.pact_version_id UEindexlatest_v_id_for_pv_and_pv_pv_id_v_idlatest_verification_id_for_pact_version_and_provider_versionHCREATE INDEX `latest_v_id_for_pv_and_pv_pv_id_v_id` ON `latest_verification_id_for_pact_version_and_provider_version` (`pact_version_id`, `verification_id`) _eindexlatest_v_id_for_pv_and_pv_pv_id_pv_id_unqlatest_verification_id_for_pact_version_and_provider_versionGCREATE UNIQUE INDEX `latest_v_id_for_pv_and_pv_pv_id_pv_id_unq` ON `latest_verification_id_for_pact_version_and_provider_version` (`pact_version_id`, `provider_version_id`)z Q)indexlatest_v_id_for_pv_and_pv_v_id_unqlatest_verification_id_for_pact_version_and_provider_versionFCREATE UNIQUE INDEX `latest_v_id_for_pv_and_pv_v_id_unq` ON `latest_verification_id_for_pact_version_and_provider_version` (`verification_id`){ utablelatest_verification_id_for_pact_version_and_provider_versionlatest_verification_id_for_pact_version_and_provider_version)CREATE TABLE `latest_verification_id_for_pact_version_and_provider_version` (`consumer_id` integer NOT NULL CONSTRAINT `latest_v_id_for_pv_and_pv_consumer_id_fk` REFERENCES `pacticipants` ON DELETE CASCADE, `pact_version_id` integer NOT NULL CONSTRAINT `latest_v_id_for_pv_and_pv_pact_version_id_fk` REFERENCES `pact_versions` ON DELETE CASCADE, `provider_id` integer NOT NULL CONSTRAINT `latest_v_id_for_pv_and_pv_provider_id_fk` REFERENCES `pacticipants` ON DELETE CASCADE, `provider_version_id` integer NOT NULL CONSTRAINT `latest_v_id_for_pv_and_pv_provider_version_id_fk` REFERENCES `versions` ON DELETE CASCADE, `verification_id` integer NOT NULL CONSTRAINT `latest_v_id_for_pv_and_pv_verification_id_fk` REFERENCES `verifications` ON DELETE CASCADE);SSaviewlatest_pact_consumer_version_orderslatest_pact_consumer_version_ordersCREATE VIEW `latest_pact_consumer_version_orders` AS SELECT `latest_pact_publication_ids_for_consumer_versions`.`provider_id`, `cv`.`pacticipant_id` AS 'consumer_id', max(`order`) AS 'latest_consumer_version_order' FROM `latest_pact_publication_ids_for_consumer_versions` INNER JOIN `versions` AS 'cv' ON (`latest_pact_publication_ids_for_consumer_versions`.`consumer_version_id` = `cv`.`id`) GROUP BY `latest_pact_publication_ids_for_consumer_versions`.`provider_id`, `cv`.`pacticipant_id`.ggviewlatest_pact_publications_by_consumer_versionslatest_pact_publications_by_consumer_versionsCREATE VIEW `latest_pact_publications_by_consumer_versions` AS select app.* from latest_pact_publication_ids_for_consumer_versions lpp inner join all_pact_publications app on lpp.consumer_version_id = app.consumer_version_id and lpp.pact_publication_id = app.id and lpp.provider_id = app.provider_id     .5uKb> M  | N % X # W 3 S . a5vP*|OlLF~_e0w< 20180722_recreate_views.rbV3k20180721_migrate_latest_pact_publication_ids.rbU2i20180720_create_latest_pact_publication_ids.rbT:y20180616_migrate_consumer_ids_for_pact_publications.rbS4m20180615_add_consumer_id_to_pact_publications.rbRI20180614_update_latest_verification_ids_for_consumer_and_provider.rbQ9w20180613_migrate_pacticipant_ids_for_verifications.rbP4m20180612_add_pacticipant_ids_to_verifications.rbO5o20180611_make_webhook_pacticipant_ids_optional.rbN5o20180608_add_verification_to_triggered_webhook.rbMF20180524_create_latest_verifications_for_consumer_and_provider.rbLF20180523_create_latest_verifications_for_consumer_version_tags.rbKA20180330_refresh_matrix.rbJ,]20180315_create_verification_sequence.rbI$M20180311_optimise_head_matrix.rbH5o20180210_fix_latest_matrix_for_cv_and_pv_again.rbG?20180209_recreate_latest_matrix_for_cv_and_pv_union_all.rbF8u20180208_add_cv_tag_name_index_to_mat_head_matrix.rbE.a20180207_recreate_head_matrix_union_all.rbD=20180206_recreate_head_matrix_rename_consumer_tag_name.rbC/c20180205_drop_materialized_latest_matrix.rbB/c20180204_fix_latest_matrix_for_cv_and_pv.rbAC20180203_fix_head_matrix.rb@/c20180202_create_materialized_head_matrix.rb?"I20180201_create_head_matrix.rb>1g20180131_create_materialized_latest_matrix.rb=*Y20180130_create_materialized_matrix.rb<2i20180129_create_latest_matrix_for_cv_and_pv.rb;,]20180123_create_tags_with_latest_flag.rb:-_20180122_create_head_pact_publications.rb90e20180119_update_latest_triggered_webhooks.rb8$M20180109_migrate_trigger_type.rb7)W20180108_create_certificates_table.rb6%O20171118_create_webhook_events.rb5%O20171117_create_webhook_events.rb4 E20171112_add_test_results.rb3"I000050_create_latest_matrix.rb27s000049_create_latest_verifications_for_cv_and_pv.rb1;000048_create_matrix.rb0&Q000047_create_all_verifications.rb/+[000046_recreate_latest_verifications.rb.7s000045_set_verification_provider_number_nullable.rb-8u000044_populate_verifications_provider_version_id.rb,2i000043_add_provider_version_to_verification.rb+(U000042_delete_orphan_webhook_data.rb*$M000041_migrate_execution_data.rb)3k000040_create_latest_triggered_webhooks_view.rb(4m000039_add_triggered_webhooks_fk_to_execution.rb'-_000038_create_triggered_webhooks_table.rb&!G000037_create_labels_table.rb%&Q000036_create_webhook_execution.rb$#K000035_create_index_on_names.rb#4m000034_create_index_on_consumer_version_order.rb"!G000033_create_config_table.rb!)W000032_create_latest_verifications.rb "I000031_create_verifications.rb'S000030_drop_old_tables_and_views.rb4m000029_create_latest_tagged_pact_publications.rb*Y000028_create_all_pact_publications.rb(U000027_populate_pact_publications.rb&Q000026_create_pact_publications.rb,]000025_make_pv_pacticipants_mandatory.rb$M000024_populate_pact_versions.rb(U000023_create_pact_versions_table.rb-_000022_create_latest_tagged_pacts_view.rb(U000021_recreate_latest_pacts_view.rb<}000020_add_pact_version_content_sha_to_all_pacts_view.rb8u000019_make_pact_version_content_sha_not_nullable.rb1g000018_drop_json_content_column_from_pacts.rbA000017_migrate_json_content_to_pact_version_content_table.rb3k000016_add_pact_content_foreign_key_to_pacts.rb)W000015_create_pact_version_content.rb*Y000014_add_timestamps_to_pact_views.rb%O000013_add_columns_to_webhooks.rb #K000012_create_webhooks_table.rb 'S000011_made_timestamps_mandatory.rb !G000010_populate_timestamps.rb =000009_add_timestamps.rb %O000008_create_latest_pact_view.rb*Y000007_increase_json_content_length.rb0e000006_make_version_foreign_key_mandatory.rb)W000005_add_order_column_to_version.rbC000004_create_tags_table.rb E000003_create_pacts_table.rb#K000002_create_versions_table.rb%Q 000001_create_pacticipant_table.rbMMLLMNIK)IDKNLD<;=::8:87537/.-55,,,& 0hBnA ^ >  q 8 p Q W " i .yI*d!&Q20180828_create_latest_versions.rb_"I20180731_update_head_matrix.rb^B20180730_create_latest_verifications_for_provider_versions.rb]E 20180729_create_latest_verification_ids_for_provider_versions.rb\3k20180728_truncate_materialized_matrix_tables.rb[K20180727_recreate_latest_verification_ids_for_consumer_version_tags.rbZA20180726_recreate_views.rbY/c20180724_migrate_latest_verification_ids.rbX.a20180723_create_latest_verification_ids.rbWA20180722_recreate_views.rbV3k20180721_migrate_latest_pact_publication_ids.rbU2i20180720_create_latest_pact_publication_ids.rbT:y20180616_migrate_consumer_ids_for_pact_publications.rbS4m20180615_add_consumer_id_to_pact_publications.rbRI20180614_update_latest_verification_ids_for_consumer_and_provider.rbQ9w20180613_migrate_pacticipant_ids_for_verifications.rbP4m20180612_add_pacticipant_ids_to_verifications.rbO5o20180611_make_webhook_pacticipant_ids_optional.rbN5o20180608_add_verification_to_triggered_webhook.rbMF20180524_create_latest_verifications_for_consumer_and_provider.rbLF20180523_create_latest_verifications_for_consumer_version_tags.rbKA20180330_refresh_matrix.rbJ,]20180315_create_verification_sequence.rbI$M20180311_optimise_head_matrix.rbH5o20180210_fix_latest_matrix_for_cv_and_pv_again.rbG?20180209_recreate_latest_matrix_for_cv_and_pv_union_all.rbF8u20180208_add_cv_tag_name_index_to_mat_head_matrix.rbE.a20180207_recreate_head_matrix_union_all.rbD=20180206_recreate_head_matrix_rename_consumer_tag_name.rbC/c20180205_drop_materialized_latest_matrix.rbB/c20180204_fix_latest_matrix_for_cv_and_pv.rbAC20180203_fix_head_matrix.rb@/c20180202_create_materialized_head_matrix.rb?"I20180201_create_head_matrix.rb>1g20180131_create_materialized_latest_matrix.rb=*Y20180130_create_materialized_matrix.rb<2i20180129_create_latest_matrix_for_cv_and_pv.rb;,]20180123_create_tags_with_latest_flag.rb:-_20180122_create_head_pact_publications.rb90e20180119_update_latest_triggered_webhooks.rb8$M20180109_migrate_trigger_type.rb7)W20180108_create_certificates_table.rb6%O20171118_create_webhook_events.rb5%O20171117_create_webhook_events.rb4 E20171112_add_test_results.rb3"I000050_create_latest_matrix.rb27s000049_create_latest_verifications_for_cv_and_pv.rb1;000048_create_matrix.rb0 WxOlI$ ] , c ;  s ?  x U /  z V .b<!^5V,\-Kb~E\) ,Wa20180723_create_latest_verification_ids.rbVA20180722_recreate_views.rb1Uk20180721_migrate_latest_pact_publication_ids.rb0Ti20180720_create_latest_pact_publication_ids.rb8Sy20180616_migrate_consumer_ids_for_pact_publications.rb2Rm20180615_add_consumer_id_to_pact_publications.rbGQ20180614_update_latest_verification_ids_for_consumer_and_provider.rb7Pw20180613_migrate_pacticipant_ids_for_verifications.rb2Om20180612_add_pacticipant_ids_to_verifications.rb3No20180611_make_webhook_pacticipant_ids_optional.rb3Mo20180608_add_verification_to_triggered_webhook.rbDL20180524_create_latest_verifications_for_consumer_and_provider.rbDK20180523_create_latest_verifications_for_consumer_version_tags.rbJA20180330_refresh_matrix.rb*I]20180315_create_verification_sequence.rb"HM20180311_optimise_head_matrix.rb3Go20180210_fix_latest_matrix_for_cv_and_pv_again.rb=F20180209_recreate_latest_matrix_for_cv_and_pv_union_all.rb6Eu20180208_add_cv_tag_name_index_to_mat_head_matrix.rb,Da20180207_recreate_head_matrix_union_all.rb;C20180206_recreate_head_matrix_rename_consumer_tag_name.rb-Bc20180205_drop_materialized_latest_matrix.rb-Ac20180204_fix_latest_matrix_for_cv_and_pv.rb@C20180203_fix_head_matrix.rb-?c20180202_create_materialized_head_matrix.rb >I20180201_create_head_matrix.rb/=g20180131_create_materialized_latest_matrix.rb(<Y20180130_create_materialized_matrix.rb0;i20180129_create_latest_matrix_for_cv_and_pv.rb*:]20180123_create_tags_with_latest_flag.rb+9_20180122_create_head_pact_publications.rb.8e20180119_update_latest_triggered_webhooks.rb"7M20180109_migrate_trigger_type.rb'6W20180108_create_certificates_table.rb#5O20171118_create_webhook_events.rb#4O20171117_create_webhook_events.rb3E20171112_add_test_results.rb 2I000050_create_latest_matrix.rb51s000049_create_latest_verifications_for_cv_and_pv.rb0;000048_create_matrix.rb$/Q000047_create_all_verifications.rb).[000046_recreate_latest_verifications.rb5-s000045_set_verification_provider_number_nullable.rb6,u000044_populate_verifications_provider_version_id.rb0+i000043_add_provider_version_to_verification.rb&*U000042_delete_orphan_webhook_data.rb")M000041_migrate_execution_data.rb1(k000040_create_latest_triggered_webhooks_view.rb2'm000039_add_triggered_webhooks_fk_to_execution.rb+&_000038_create_triggered_webhooks_table.rb%G000037_create_labels_table.rb$$Q000036_create_webhook_execution.rb!#K000035_create_index_on_names.rb2"m000034_create_index_on_consumer_version_order.rb!G000033_create_config_table.rb' W000032_create_latest_verifications.rb I000031_create_verifications.rb%S000030_drop_old_tables_and_views.rb2m000029_create_latest_tagged_pact_publications.rb(Y000028_create_all_pact_publications.rb&U000027_populate_pact_publications.rb$Q000026_create_pact_publications.rb*]000025_make_pv_pacticipants_mandatory.rb"M000024_populate_pact_versions.rb&U000023_create_pact_versions_table.rb+_000022_create_latest_tagged_pacts_view.rb&U000021_recreate_latest_pacts_view.rb:}000020_add_pact_version_content_sha_to_all_pacts_view.rb6u000019_make_pact_version_content_sha_not_nullable.rb/g000018_drop_json_content_column_from_pacts.rb?000017_migrate_json_content_to_pact_version_content_table.rb1k000016_add_pact_content_foreign_key_to_pacts.rb'W000015_create_pact_version_content.rb(Y000014_add_timestamps_to_pact_views.rb# O000013_add_columns_to_webhooks.rb! K000012_create_webhooks_table.rb% S000011_made_timestamps_mandatory.rb G000010_populate_timestamps.rb =000009_add_timestamps.rb#O000008_create_latest_pact_view.rb(Y000007_increase_json_content_length.rb.e000006_make_version_foreign_key_mandatory.rb'W000005_add_order_column_to_version.rbC000004_create_tags_table.rbE000003_create_pacts_table.rb!K000002_create_versions_table.rb$Q000001_create_pacticipant_table.rb r Dry++-viewlatest_versionslatest_versionsCREATE VIEW `latest_versions` AS SELECT * FROM `versions` INNER JOIN (SELECT `pacticipant_id`, max(`order`) AS 'latest_version_order' FROM `versions` GROUP BY `pacticipant_id`) AS 't1' ON ((`versions`.`pacticipant_id` = `latest_version_orders`.`pacticipant_id`) AND (`versions`.`order` = `latest_version_orders`.`latest_version_order`))E77-viewlatest_version_orderslatest_version_ordersCREATE VIEW `latest_version_orders` AS SELECT `pacticipant_id`, max(`order`) AS 'latest_version_order' FROM `versions` GROUP BY `pacticipant_id`~YY[viewlatest_verifications_for_pact_versionslatest_verifications_for_pact_versionsCREATE VIEW `latest_verifications_for_pact_versions` AS SELECT `verifications`.`id`, `verifications`.`number`, `verifications`.`success`, `verifications`.`build_url`, `verifications`.`pact_version_id`, `verifications`.`execution_date`, `verifications`.`created_at`, `verifications`.`provider_version_id`, `s`.`number` AS 'provider_version_number', `s`.`order` AS 'provider_version_order' FROM `verifications` INNER JOIN `latest_verification_ids_for_pact_versions` AS 'lv' ON ((`verifications`.`pact_version_id` = `lv`.`pact_version_id`) AND (`verifications`.`id` = `lv`.`latest_verification_id`)) INNER JOIN `versions` AS 's' ON (`verifications`.`provider_version_id` = `s`.`id`)>__Oviewlatest_verification_ids_for_pact_versionslatest_verification_ids_for_pact_versionsCREATE VIEW `latest_verification_ids_for_pact_versions` AS select pact_version_id, MAX(verification_id) latest_verification_id FROM latest_verification_id_for_pact_version_and_provider_version GROUP BY pact_version_idHoo viewlatest_verification_ids_for_consumer_version_tag8##;viewhead_matrixhead_matrixCREATE VIEW `head_matrix` AS select p.consumer_id, p.consumer_name, p.consumer_version_id, p.consumer_version_number, p.consumer_version_order, p.id as pact_publication_id, p.pact_version_id, p.pact_version_sha, p.revision_number as pact_revision_number, p.created_at as pact_created_at, p.provider_id, p.provider_name, lv.provider_version_id, lv.provider_version_number, lv.provider_version_order, lv.id as verification_id, lv.success, lv.number as verification_number, lv.execution_date as verification_executed_at, lv.build_url as verification_build_url, null as consumer_version_tag_name from latest_pact_publications p left outer join latest_verifications_for_pact_versions lv on p.pact_version_id = lv.pact_version_id union all select p.consumer_id, p.consumer_name, p.consumer_version_id, p.consumer_version_number, p.consumer_version_order, p.id as pact_publication_id, p.pact_version_id, p.pact_version_sha, p.revision_number as pact_revision_number, p.created_at as pact_created_at, p.provider_id, p.provider_name, lv.provider_version_id, lv.provider_version_number, lv.provider_version_order, lv.id as verification_id, lv.success, lv.number as verification_number, lv.execution_date as verification_executed_at, lv.build_url as verification_build_url, lt.tag_name as consumer_version_tag_name from latest_tagged_pact_consumer_version_orders lt inner join latest_pact_publications_by_consumer_versions p on lt.consumer_id = p.consumer_id and lt.provider_id = p.provider_id and lt.latest_consumer_version_order = p.consumer_version_order left outer join latest_verifications_for_pact_versions lv on p.pact_version_id = lv.pact_version_id fh5f$_Q20180828_create_latest_versions.rb ^I20180731_update_head_matrix.rb@]20180730_create_latest_verifications_for_provider_versions.rbC\ 20180729_create_latest_verification_ids_for_provider_versions.rb1[k20180728_truncate_materialized_matrix_tables.rbIZ20180727_recreate_latest_verification_ids_for_consumer_version_tags.rbYA20180726_recreate_views.rb-Xc20180724_migrate_latest_verification_ids.rb