-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 03, 2022 at 12:35 AM
-- Server version: 10.4.11-MariaDB-log
-- PHP Version: 8.0.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mydccinterop`
--

-- --------------------------------------------------------

--
-- Table structure for table `validity_rules`
--

DROP TABLE IF EXISTS `validity_rules`;
CREATE TABLE IF NOT EXISTS `validity_rules` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `string_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `validity_rules`
--

INSERT INTO `validity_rules` (`id`, `string_id`, `group`, `label`, `value`, `comment`, `created_at`, `updated_at`) VALUES
(2, 'ln9XDKPKDeJh9BpyEacgVj83NXtMjblU0K9uNkYP2M2vASqi', '263', 'AppName', 'BjCovid', NULL, '2022-02-01 17:08:01', '2022-02-01 20:15:33'),
(3, 'OWh8o6IFnoLkLEsPwRHDL2eKCRO5DUenmIjkXqNYq1W9w3s2', '263', 'AppUrl', 'https//dccinterop.local', NULL, '2022-02-01 17:45:47', '2022-02-01 20:16:03'),
(4, 'VT8SIFjWRH9L8erHTKPSo9w9RdNCYEVlqmrlbVzMhY9HG6OA', '267', 'TestNegativePcrPeriode', '24', 'Durée de validité d\'un Test PCR de base', '2022-02-01 17:46:18', '2022-02-02 09:21:33'),
(5, 'EomusCUhLSHkXO6bEaIT8D8GXF6Diet1logWQWOs4LAEOCmy', '267', 'TestNegativeAntigenicPeriode', '24', 'Durée de validité d\'un Test Antigénique de base', '2022-02-01 17:46:45', '2022-02-02 09:23:42'),
(6, 'Tlcb1M2IeoAMK1JGuIEsP1hHJHTMjHNGPKnAP7LTfSb4q7S3', '267', 'PassVaccinalActif', '7', 'Pass Vaccinal actif 7 jours après la 2eme dose selon le vaccin administré', '2022-02-02 09:01:20', '2022-02-02 09:42:54'),
(7, 'CmUYQE4bcFk56JUDbip54Ch8nO5eZQBONuyzacaJ6bkKKLa9', '267', 'TestPositivePcrPeriode', '15', 'Durée d\'isolement de base d\'un cas  testé positif', '2022-02-02 09:07:16', '2022-02-02 09:26:31'),
(8, 'kvFF1tvcbEmODmqBG3WgLMW6JfijQTu0OQIZOw9lg3Ye3eaK', '267', 'RecoveryPeriode', '15', 'Guérison d\'un cas testé positif après  15 jours d\'incubation', '2022-02-02 09:11:55', '2022-02-02 09:30:42'),
(9, 'WxjH81YwK2i5O4oF2jXAb4nwjX4FaRKEghb6vjrfOkCssXYi', '267', 'RecoveryProtection', '180', 'Protection naturelle durant 180 jours après la guérison', '2022-02-02 09:35:51', '2022-02-02 09:35:51'),
(10, 'RWisIe110zS9Lsx2QmflhDqC8XEDkZlYRIfdU5lDoLQIaYwL', '267', 'VaccinalProtection', '180', 'Protection Vaccinale durant 180 jours après la 2eme dose', '2022-02-02 09:38:37', '2022-02-02 09:38:37'),
(11, '1isFedS9ZlxK60TiKodzAdFSi5A8g3jyvBOgYsySqpfDYQWt', '265', 'PassVaccinalBJ', '7', 'Benin: Pass Vaccinal actif 7 jours après la 2eme dose selon vaccin', '2022-02-02 09:39:59', '2022-02-02 09:45:48'),
(12, '0wRH0McDSiljJcxuu5zjlxrcgMLU9pkngL5LuL9zlmtiFtF6', '265', 'VaccinalProtectionBJ', '180', 'Benin: Pass Vaccinal délai maximum de protection avant et après  dose de rappel', '2022-02-02 09:47:03', '2022-02-02 09:58:39'),
(13, '0jgxHP0YEFQSLADNmFdjHyH5jkbeDzjg3XzFyGK1PDttCef7', '264', 'TestNegativePcrPeriodeBJ', '48', 'Benin: Durée de validité d\'un Test PCR à partir de la date d\'échantillonnage', '2022-02-02 09:50:41', '2022-02-02 09:50:41'),
(14, 'zqKTQE43idLigSL0tru8SMYXzx8Z6biN4cP0YoNIldRbieyU', '264', 'TestNegativeAntigeniquePeriodeBJ', '48', 'Benin: Durée de validité d\'un Test Antigénique', '2022-02-02 09:54:16', '2022-02-02 09:54:16'),
(15, '4jitVuhDwTedqK9h4xDdkE4MssDcXuqtrzNiYmRNf9rKlvaf', '266', 'RecoveryProtectionBJ', '0', 'Benin: N\'est pas accepter', '2022-02-02 09:56:12', '2022-02-02 09:56:12');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
