SQLite format 3@ +.) 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 `schema_migrations` (`filename` varchar(255) N'a[I ; 7xOlI$ ] , c ;  s ?  x U /  z V .b<!Z5"7M20180109_migrate_trigger_type.rb#6O20171118_create_webhook_events.rb#5O20171117_create_webhook_events.rb4E20171112_add_test_results.rb'3W20180108_create_certificates_table.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 7uKb> M  | N % X # W 3 S . a5L&m$M20180109_migrate_trigger_type.rb7%O20171118_create_webhook_events.rb6%O20171117_create_webhook_events.rb5 E20171112_add_test_results.rb4)W20180108_create_certificates_table.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.rb   ss1webhook_executions webhook_'verifications /pact_publications versions%pacticipants pacts 'pact_versions      y3=  #o G3/$Cindexsqlite_autoindex_webhooks_1webhooksR#wtablewebhookswebhooks CREATE TABLE `webhooks` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `uuid` varchar(255) NOT NULL CONSTRA/QOindexpacts_version_id_provider_id_indexpacts CREATE UNIQUE IN};//)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):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)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))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)%%Aviewlatest_pa=&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`))/$Cindexsqlite_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)     P c WGRK#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_order?CaaMviewlatest_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.nameB==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,ASSCviewlatest_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_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`)         [[: W  x  _H\''Otableverificationsverifications&CREATE 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, FOREIGN KEY (`providRK#sindexndx_ver_numversionsCREATE INDEX `ndx_ver_num` ON `versions` (`number`)\J+indexunq_config_nameconfig CREATE UNIQUE INDEX `unq_config_name` ON `config` (`name`)[??1viewlatest_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.created_at = ltwi.latest_triggered_webhook_created_at*ZEE[viewlatest_triggered_webhook_idslatest_triggered_webhook_idsCREATE VIEW `latest_triggered_webhook_ids` 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_idmY11tablewebhook_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)9UC1 indexuq_triggered_webhook_ppi_witriggered_webhooks%CREATE UNIQUE INDEX `uq_triggered_webhook_ppi_wi` ON `triggered_webhooks` (`pact_publication_id`, `webhook_id`, `trigger_uuid`)T;1Uindexuq_triggered_webhook_witriggered_webhooks$CREATE UNIQUE INDEX `uq_triggered_webhook_wi` ON `triggered_webhooks` (`webhook_id`, `trigger_uuid`)?S11)tabletriggered_webhookstriggered_webhooks#CREATE TABLE `triggered_webhooks` (`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `trigger_uuid` varchar(255) NOT NULL, `trigger_type` varchar(255) NOT NULL, `pact_publication_id` integer NOT NULL REFERENCES `pact_publications`, `webhook_id` integer REFERENCES `webhooks`, `webhook_uuid` varchar(255) NOT NULL, `consumer_id` integer NOT NULL REFERENCES `pacticipants`, `provider_id` integer NOT NULL REFERENCES `pacticipants`, `status` varchar(255) NOT NULL, `created_at` timestamp NOT NULL, `updated_at` timestamp NOT NULL)+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`)qM))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`)             AAH Q '91dkc''c\''tableverificationsverifications&CREATE 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, FOREIGN KEY (`provider_version_id`) REFERENCES `versions` ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY (`pact_version_id`) REFERENCES `pact_versions` ON DELETE NO ACTION ON UPDATE NO ACTION)\aviewmatrixmatrixCREATE 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`)_^CCIviewlatest_verification_numberslatest_verification_numbersCREATE VIEW `latest_verification_numbers` AS SELECT pact_version_id, MAX(number) latest_number FROM verifications GROUP BY pact_version_id 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_id3`//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`)t_55viewlatest_verificationslatest_verificationsCREATE VIEW `latest_verifications` AS SELECT v.id, v.number, v.success, s.number as provider_version, v.build_url, v.pact_version_id, v.execution_date, v.created_at, v.provider_version_id, s.number as provider_version_number FROM verifications v INNER JOIN latest_verification_numbers lv ON v.pact_version_id = lv.pact_version_id AND v.number = lv.latest_number INNER JOIN versions s on v.provider_version_id = s.id5]a'oindexverifications_pact_version_id_number_indexverifications CREATE UNIQUE INDEX `verifications_pact_version_id_number_index` ON `verifications` (`pact_version_id`, `number`)  WW M _ Wxg1)#indexuq_webhook_id_namewebhook_events+CREATE UNIQUE INDEX `uq_webhook_id_name` ON `webhook_events` (`id`, `name`) f))Utablewebhook_eventswebhook_events*CREATE 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):d%%7tablecertificatescertificatesCREATE 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)7eK%indexsqlite_autoindex_certificates_1certificates(kc''viewlatest_matrixlatest_matrixCREATE VIEW `latest_matrix` AS SELECT matrix.* FROM matrix 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 select matrix.* 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 where verification_id is null0b  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