-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : mer. 04 déc. 2024 à 13:07
-- Version du serveur : 10.4.28-MariaDB
-- Version de PHP : 8.1.17

START TRANSACTION;



--
-- Base de données : `volontariat`
--

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

--
-- Structure de la table `auth_groups_users`
--

CREATE TABLE `auth_groups_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `group` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `auth_groups_users`
--

INSERT INTO `auth_groups_users` (`id`, `user_id`, `group`, `created_at`) VALUES
(2, 1, 'admin', '2024-06-01 16:30:35'),
(12, 2, 'user', '2024-07-06 10:09:08'),
(13, 3, 'user', '2024-10-12 09:51:13');

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

--
-- Structure de la table `auth_logins`
--

CREATE TABLE `auth_logins` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `date` datetime NOT NULL,
  `success` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `auth_logins`
--

INSERT INTO `auth_logins` (`id`, `ip_address`, `user_agent`, `id_type`, `identifier`, `user_id`, `date`, `success`) VALUES
(1, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-06-01 16:40:55', 0),
(2, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-06-01 16:41:20', 0),
(3, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-06-01 16:41:47', 0),
(4, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-06-01 16:42:04', 1),
(5, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'girukwayo@gmail.com', NULL, '2024-06-03 06:05:18', 0),
(6, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'girukwayo@gmail.com', NULL, '2024-06-03 06:06:47', 0),
(7, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-03 06:08:09', 1),
(8, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-03 13:03:35', 1),
(9, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-04 09:01:41', 1),
(10, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-06-09 15:28:27', 1),
(11, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', NULL, '2024-06-09 15:33:57', 0),
(12, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', NULL, '2024-06-09 15:34:29', 0),
(13, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-09 15:37:19', 1),
(14, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-06-09 15:41:52', 0),
(15, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-06-09 15:42:05', 0),
(16, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-06-09 15:42:38', 0),
(17, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-06-09 15:43:00', 1),
(18, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', NULL, '2024-06-09 15:47:10', 0),
(19, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-09 15:47:27', 1),
(20, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-06-09 15:48:19', 1),
(21, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', NULL, '2024-06-09 15:50:26', 0),
(22, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-09 15:51:07', 1),
(23, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-10 09:20:45', 1),
(24, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-06-10 09:23:07', 1),
(25, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-06-10 11:26:58', 1),
(26, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:127.0) Gecko/20100101 Firefox/127.0', 'email_password', 'leopold@gmail.com', 1, '2024-06-15 12:08:21', 1),
(27, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0', 'email_password', 'thandize@gmail.com', NULL, '2024-06-16 15:21:16', 0),
(28, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0', 'email_password', 'leopord@gmail.com', NULL, '2024-06-16 15:21:29', 0),
(29, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0', 'email_password', 'leopold@gmail.com', 1, '2024-06-16 15:21:48', 1),
(30, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:127.0) Gecko/20100101 Firefox/127.0', 'email_password', 'leopold@gmail.com', 1, '2024-07-06 08:40:19', 1),
(31, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-07-06 09:55:13', 0),
(32, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-07-06 09:55:34', 0),
(33, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-07-06 09:56:21', 0),
(34, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-07-06 10:00:48', 0),
(35, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-07-06 10:01:32', 0),
(36, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', NULL, '2024-07-06 10:02:50', 0),
(37, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'thandize@gmail.com', NULL, '2024-07-06 10:06:29', 0),
(38, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-07-06 10:09:37', 1),
(39, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:127.0) Gecko/20100101 Firefox/127.0', 'email_password', 'leopold@gmail.com', 1, '2024-07-08 07:53:12', 1),
(40, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0', 'email_password', 'bertin@gmail.com', 2, '2024-07-08 07:57:14', 1),
(41, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-07-09 05:17:23', 1),
(42, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'leopord@gmail.com', NULL, '2024-07-09 05:17:43', 0),
(43, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-07-09 05:17:54', 1),
(44, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0', 'email_password', 'bertin@gmail.com', 2, '2024-07-09 05:18:15', 1),
(45, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'thandize@gmail.com', NULL, '2024-07-15 17:45:23', 0),
(46, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-07-15 17:46:10', 1),
(47, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0', 'email_password', 'leopold@gmail.com', 1, '2024-07-15 17:48:08', 1),
(48, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-07-16 18:50:37', 1),
(49, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0', 'email_password', 'bertin@gmail.com', 2, '2024-07-16 18:50:55', 1),
(50, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'thandize@gmail.com', NULL, '2024-07-18 09:21:48', 0),
(51, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-07-18 09:21:58', 1),
(52, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', 'email_password', 'leopold@gmail.com', 1, '2024-08-24 09:47:45', 1),
(53, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-08-24 10:24:05', 1),
(54, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-08-24 11:37:17', 1),
(55, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-08-24 11:38:55', 1),
(56, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-10-12 09:46:16', 1),
(57, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'thandize@gmail.com', 3, '2024-10-12 09:58:16', 1),
(58, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'thandize@gmail.com', 3, '2024-10-12 09:59:26', 1),
(59, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'bertin@gmail.com', 2, '2024-10-12 13:22:17', 1),
(60, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-10-12 13:22:55', 1),
(61, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'thandize@gmail.com', 3, '2024-10-12 13:23:39', 1),
(62, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-10-14 07:11:45', 1),
(63, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-10-15 08:45:38', 1),
(64, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-10-15 09:10:56', 1),
(65, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-10-15 11:09:46', 1),
(66, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-10-19 10:06:15', 1),
(67, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-11-23 09:45:49', 1),
(68, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'email_password', 'leopold@gmail.com', 1, '2024-12-04 12:05:34', 1);

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

--
-- Structure de la table `auth_permissions_users`
--

CREATE TABLE `auth_permissions_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `permission` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Structure de la table `auth_remember_tokens`
--

CREATE TABLE `auth_remember_tokens` (
  `id` int(11) UNSIGNED NOT NULL,
  `selector` varchar(255) NOT NULL,
  `hashedValidator` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `expires` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Structure de la table `auth_token_logins`
--

CREATE TABLE `auth_token_logins` (
  `id` int(11) UNSIGNED NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `id_type` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `date` datetime NOT NULL,
  `success` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Structure de la table `dc_documents`
--

CREATE TABLE `dc_documents` (
  `id` int(11) NOT NULL,
  `type` varchar(100) NOT NULL,
  `document_path` varchar(200) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `dc_documents`
--

INSERT INTO `dc_documents` (`id`, `type`, `document_path`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'CV', '1720258921_a9a46ab9535b96421456.jpg', 1, '2024-07-06 11:42:01', NULL, NULL),
(3, 'ATTESTATION', '1720260628_acddf8f774cf666c5b0c.png', 2, '2024-07-06 12:10:28', NULL, NULL),
(4, 'DIPLOMA', '1720262622_ec73a15942893e869ddf.jpg', 1, '2024-07-06 12:43:42', NULL, NULL),
(6, 'DIPLOMA', '1728731514_6ccb685781a97c647f1f.jpg', 3, '2024-10-12 13:11:54', NULL, NULL);

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

--
-- Structure de la table `migrations`
--

CREATE TABLE `migrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `migrations`
--

INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(20, '2020-12-28-223112', 'CodeIgniter\\Shield\\Database\\Migrations\\CreateAuthTables', 'default', 'CodeIgniter\\Shield', 1717259164, 1),
(21, '2021-07-04-041948', 'CodeIgniter\\Settings\\Database\\Migrations\\CreateSettingsTable', 'default', 'CodeIgniter\\Settings', 1717259165, 1),
(22, '2021-11-14-143905', 'CodeIgniter\\Settings\\Database\\Migrations\\AddContextColumn', 'default', 'CodeIgniter\\Settings', 1717259166, 1),
(23, '2024-05-23-123358', 'Modules\\Administration\\Database\\Migrations\\User', 'default', 'Modules\\Administration', 1717259166, 1),
(24, '2024-05-31-095502', 'Modules\\Volontaire\\Database\\Migrations\\Volontaire', 'default', 'Modules\\Volontaire', 1717259166, 1);

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

--
-- Structure de la table `pays`
--

CREATE TABLE `pays` (
  `id` int(5) UNSIGNED NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `pays`
--

INSERT INTO `pays` (`id`, `description`) VALUES
(1, 'Afghanistan'),
(2, 'Albania'),
(3, 'Algeria'),
(4, 'Andorra'),
(5, 'Angola'),
(6, 'Antigua and Barbuda'),
(7, 'Argentina'),
(8, 'Armenia'),
(9, 'Austria'),
(10, 'Azerbaijan'),
(11, 'Bahrain'),
(12, 'Bangladesh'),
(13, 'Barbados'),
(14, 'Belarus'),
(15, 'Belgium'),
(16, 'Belize'),
(17, 'Benin'),
(18, 'Bhutan'),
(19, 'Bolivia'),
(20, 'Bosnia and Herzegovina'),
(21, 'Botswana'),
(22, 'Brazil'),
(23, 'Brunei'),
(24, 'Bulgaria'),
(25, 'Burkina Faso'),
(26, 'Burundi'),
(27, 'Cabo Verde'),
(28, 'Cambodia'),
(29, 'Cameroon'),
(30, 'Canada'),
(31, 'Central African Republic'),
(32, 'Chad'),
(33, 'Channel Islands'),
(34, 'Chile'),
(35, 'China'),
(36, 'Colombia'),
(37, 'Comoros'),
(38, 'Congo'),
(39, 'Costa Rica'),
(40, 'Côte d\'Ivoire'),
(41, 'Croatia'),
(42, 'Cuba'),
(43, 'Cyprus'),
(44, 'Czech Republic'),
(45, 'Denmark'),
(46, 'Djibouti'),
(47, 'Dominica'),
(48, 'Dominican Republic'),
(49, 'DR Congo'),
(50, 'Ecuador'),
(51, 'Egypt'),
(52, 'El Salvador'),
(53, 'Equatorial Guinea'),
(54, 'Eritrea'),
(55, 'Estonia'),
(56, 'Eswatini'),
(57, 'Ethiopia'),
(58, 'Faeroe Islands'),
(59, 'Finland'),
(60, 'France'),
(61, 'French Guiana'),
(62, 'Gabon'),
(63, 'Gambia'),
(64, 'Georgia'),
(65, 'Germany'),
(66, 'Ghana'),
(67, 'Gibraltar'),
(68, 'Greece'),
(69, 'Grenada'),
(70, 'Guatemala'),
(71, 'Guinea'),
(72, 'Guinea-Bissau'),
(73, 'Guyana'),
(74, 'Haiti'),
(75, 'Holy See'),
(76, 'Honduras'),
(77, 'Hong Kong'),
(78, 'Hungary'),
(79, 'Iceland'),
(80, 'India'),
(81, 'Indonesia'),
(82, 'Iran'),
(83, 'Iraq'),
(84, 'Ireland'),
(85, 'Isle of Man'),
(86, 'Israel'),
(87, 'Italy'),
(88, 'Jamaica'),
(89, 'Japan'),
(90, 'Jordan'),
(91, 'Kazakhstan'),
(92, 'Kenya'),
(93, 'Kuwait'),
(94, 'Kyrgyzstan'),
(95, 'Laos'),
(96, 'Latvia'),
(97, 'Lebanon'),
(98, 'Lesotho'),
(99, 'Liberia'),
(100, 'Libya'),
(101, 'Liechtenstein'),
(102, 'Lithuania'),
(103, 'Luxembourg'),
(104, 'Macao'),
(105, 'Madagascar'),
(106, 'Malawi'),
(107, 'Malaysia'),
(108, 'Maldives'),
(109, 'Mali'),
(110, 'Malta'),
(111, 'Mauritania'),
(112, 'Mauritius'),
(113, 'Mayotte'),
(114, 'Mexico'),
(115, 'Moldova'),
(116, 'Monaco'),
(117, 'Mongolia'),
(118, 'Montenegro'),
(119, 'Morocco'),
(120, 'Mozambique'),
(121, 'Myanmar'),
(122, 'Namibia'),
(123, 'Nepal'),
(124, 'Netherlands'),
(125, 'Nicaragua'),
(126, 'Niger'),
(127, 'Nigeria'),
(128, 'North Korea'),
(129, 'North Macedonia'),
(130, 'Norway'),
(131, 'Oman'),
(132, 'Pakistan'),
(133, 'Panama'),
(134, 'Paraguay'),
(135, 'Peru'),
(136, 'Philippines'),
(137, 'Poland'),
(138, 'Portugal'),
(139, 'Qatar'),
(140, 'Réunion'),
(141, 'Romania'),
(142, 'Russia'),
(143, 'Rwanda'),
(144, 'Saint Helena'),
(145, 'Saint Kitts and Nevis'),
(146, 'Saint Lucia'),
(147, 'Saint Vincent and the Grenadines'),
(148, 'San Marino'),
(149, 'Sao Tome & Principe'),
(150, 'Saudi Arabia'),
(151, 'Senegal'),
(152, 'Serbia'),
(153, 'Seychelles'),
(154, 'Sierra Leone'),
(155, 'Singapore'),
(156, 'Slovakia'),
(157, 'Slovenia'),
(158, 'Somalia'),
(159, 'South Africa'),
(160, 'South Korea'),
(161, 'South Sudan'),
(162, 'Spain'),
(163, 'Sri Lanka'),
(164, 'State of Palestine'),
(165, 'Sudan'),
(166, 'Suriname'),
(167, 'Sweden'),
(168, 'Switzerland'),
(169, 'Syria'),
(170, 'Taiwan'),
(171, 'Tajikistan'),
(172, 'Tanzania'),
(173, 'Thailand'),
(174, 'The Bahamas'),
(175, 'Timor-Leste'),
(176, 'Togo'),
(177, 'Trinidad and Tobago'),
(178, 'Tunisia'),
(179, 'Turkey'),
(180, 'Turkmenistan'),
(181, 'Uganda'),
(182, 'Ukraine'),
(183, 'United Arab Emirates'),
(184, 'United Kingdom'),
(185, 'United States'),
(186, 'Uruguay'),
(187, 'Uzbekistan'),
(188, 'Venezuela'),
(189, 'Vietnam'),
(190, 'Western Sahara'),
(191, 'Yemen'),
(192, 'Zambia'),
(193, 'Zimbabwe');

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

--
-- Structure de la table `pt_candidatures`
--

CREATE TABLE `pt_candidatures` (
  `id` int(11) NOT NULL,
  `volontaire_id` int(11) NOT NULL,
  `poste_id` int(11) NOT NULL,
  `decision` varchar(100) NOT NULL,
  `commentaire` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `pt_candidatures`
--

INSERT INTO `pt_candidatures` (`id`, `volontaire_id`, `poste_id`, `decision`, `commentaire`, `created_at`, `updated_at`, `deleted_at`) VALUES
(3, 2, 3, 'DELETED', NULL, '2024-07-15 20:01:00', NULL, NULL),
(4, 2, 4, 'ACCEPTED', NULL, '2024-07-15 20:01:14', NULL, NULL),
(5, 2, 5, 'REFUSED', NULL, '2024-07-16 20:51:45', NULL, NULL);

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

--
-- Structure de la table `pt_postes`
--

CREATE TABLE `pt_postes` (
  `id` int(11) NOT NULL,
  `nom` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `date_publication` datetime NOT NULL DEFAULT current_timestamp(),
  `date_fin_publication` date NOT NULL,
  `nbPlace` int(11) NOT NULL,
  `pays_id` int(11) NOT NULL,
  `ville` varchar(100) NOT NULL,
  `type_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `pt_postes`
--

INSERT INTO `pt_postes` (`id`, `nom`, `description`, `date_debut`, `date_fin`, `date_publication`, `date_fin_publication`, `nbPlace`, `pays_id`, `ville`, `type_id`, `created_at`, `updated_at`, `deleted_at`, `user_id`) VALUES
(1, 'Poste de test', 'Description du poste', '2024-06-16', '2025-07-05', '2024-06-16 17:48:50', '2024-06-18', 2, 19, 'Bujumbura', 1, '2024-07-06 13:42:04', NULL, NULL, 1),
(2, 'Autre poste', 'dFUUAGEshjkdt;fly,g\'u.h\'', '2022-11-09', '2023-01-10', '2024-06-16 18:22:36', '2022-11-18', 2, 15, 'Ville', 1, '2024-07-06 13:42:07', NULL, NULL, 1),
(3, 'Expert de donnees', 'Description', '2022-11-09', '2023-01-10', '2024-07-01 18:41:12', '2024-07-31', 2, 13, 'Ville', 2, '2024-07-06 13:42:10', NULL, NULL, 1),
(4, 'Expert en Innodation', 'Nous avons besoin d&#039;expert en Inondation ...', '2024-07-01', '2024-07-23', '2024-07-01 11:48:49', '2024-07-31', 1, 5, 'Luanda', 1, '2024-07-06 13:42:13', NULL, NULL, 1),
(5, 'Expert en Innodation', 'Test au niveau du poste', '2024-07-01', '2024-12-31', '2024-07-15 19:49:14', '2024-07-31', 1, 2, 'Agard', 2, '0000-00-00 00:00:00', NULL, NULL, 1),
(6, 'Informaticien specialise en cata', 'Informaticien specialise en catastrophe naturel', '2024-07-01', '2024-12-31', '2024-07-15 20:29:31', '2024-08-14', 2, 6, 'Ville', 1, '0000-00-00 00:00:00', NULL, NULL, 1),
(7, 'Expert en Innondation', 'Expert  en innondation', '2024-07-01', '2024-12-31', '2024-07-18 11:24:01', '2024-08-01', 2, 26, 'Muramvya', 2, '0000-00-00 00:00:00', NULL, NULL, 1);

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `id` int(11) UNSIGNED NOT NULL,
  `username` varchar(30) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `status_message` varchar(255) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `last_active` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `mobile_number` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`id`, `username`, `status`, `status_message`, `active`, `last_active`, `created_at`, `updated_at`, `deleted_at`, `first_name`, `last_name`, `mobile_number`) VALUES
(1, 'leopold', NULL, NULL, 1, NULL, '2024-06-01 16:27:52', '2024-06-01 16:27:53', NULL, 'LEOPOLD ', 'GIRUKWAYO ', '+257 79 570 922'),
(2, 'bertin@gmail.com', NULL, NULL, 1, NULL, '2024-06-01 16:39:54', '2024-06-01 16:39:55', NULL, 'NDUWAYO', 'Bertin', '+2435252410'),
(3, 'user', NULL, NULL, 1, NULL, '2024-10-12 09:51:12', '2024-10-12 09:51:13', NULL, 'NDAYIZEYE', 'THADDEE', '79802611');

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

--
-- Structure de la table `vt_etudes`
--

CREATE TABLE `vt_etudes` (
  `id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `description_qualification` varchar(255) NOT NULL,
  `accent_degre` varchar(255) NOT NULL,
  `institution` varchar(255) NOT NULL,
  `ville_pays` varchar(255) NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date DEFAULT NULL,
  `informations_complementaire` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `vt_etudes`
--

INSERT INTO `vt_etudes` (`id`, `type_id`, `description_qualification`, `accent_degre`, `institution`, `ville_pays`, `date_debut`, `date_fin`, `informations_complementaire`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(4, 1, 'Bachelier en Genie Mécanique ', 'Bsc', 'Université des Sciences de KABONDO', 'Bujumbura- Burundi', '2019-01-01', '2024-06-09', 'Completely ', 1, '2024-06-09 16:15:52', NULL, NULL),
(5, 2, 'Master of Economics Studies', 'Mec', 'Université de Louvain', 'Bruxelles, Belgique ', '2024-04-01', '2026-01-09', 'complementaires', 1, '2024-06-09 16:17:43', NULL, NULL),
(6, 1, 'Droit', 'Droit', 'Université des langues et litératures congolaises ', 'Kinshasa /RDC ', '2022-08-28', '2024-06-09', 'hhh', 2, '2024-06-09 17:46:06', NULL, NULL),
(7, 1, 'Docteur en sciences psychologiques', 'Dr', 'Université de Goma', 'RDC/Goma', '2023-01-01', '0000-00-00', 'Formation en cours', 3, '2024-10-12 12:32:33', NULL, NULL),
(9, 2, 'Gestion des projets', 'Project Manager', 'En ligne sur Coursera', 'USA/Los Angels', '2023-01-01', '2023-10-10', 'Formation est cloture', 3, '2024-10-12 12:40:50', NULL, NULL);

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

--
-- Structure de la table `vt_experiences`
--

CREATE TABLE `vt_experiences` (
  `id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `employeur` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `domaine` varchar(100) DEFAULT NULL,
  `responsabilite` varchar(255) NOT NULL,
  `date_debut` date NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `vt_experiences`
--

INSERT INTO `vt_experiences` (`id`, `type_id`, `employeur`, `position`, `domaine`, `responsabilite`, `date_debut`, `description`, `date_fin`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(5, 1, 'Croix-Rouge du Burundi ', 'senior_officier', 'logistic', 'Management Informatique ', '2009-01-01', 'Test', '2020-12-30', 1, '2024-06-09 16:20:15', NULL, NULL),
(6, 2, 'Croix-Rouge Congo-Kinshasa', 'manager', 'logistic', 'Gestion de projet', '2020-01-01', '', '2024-06-09', 1, '2024-06-09 16:23:50', NULL, NULL),
(7, 1, 'IFRC', 'senior_officier', NULL, 'Temps plein', '2022-06-06', NULL, '2024-06-09', 2, '2024-06-09 17:32:38', NULL, NULL),
(8, 2, 'CRD Burundi', 'senior_officier', 'rh', 'Chargé des ressources humaine', '2024-06-01', 'Description du poste de chef RH', '2024-06-01', 1, '2024-06-15 14:33:30', NULL, NULL),
(9, 1, 'Croix-Rouge du Burundi ', 'coordinator', 'cashier', 'Management Informatique ', '2009-01-01', 'Test de infor', '2020-12-30', 1, '2024-06-15 14:38:33', NULL, NULL),
(10, 1, 'Experiency campany', 'manager', 'finances', 'Test', '2024-06-16', 'Test description', '2024-07-04', 1, '2024-06-16 17:37:01', NULL, NULL),
(11, 1, 'King Conference Center', 'manager', 'security', 'Security manager', '2024-01-01', '', '2024-09-30', 3, '2024-10-12 12:51:26', NULL, NULL),
(12, 4, 'Muha Soft Center', 'senior_officier', 'finances', 'Officer manager', '2023-01-01', '', '2023-10-10', 3, '2024-10-12 12:52:32', NULL, NULL);

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

--
-- Structure de la table `vt_languages`
--

CREATE TABLE `vt_languages` (
  `id` int(11) NOT NULL,
  `langue_id` int(11) NOT NULL,
  `niveau_ecrit` varchar(20) NOT NULL,
  `niveau_lire` varchar(20) NOT NULL,
  `niveau_oral` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `vt_languages`
--

INSERT INTO `vt_languages` (`id`, `langue_id`, `niveau_ecrit`, `niveau_lire`, `niveau_oral`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(5, 1, 'A1', 'A1', 'A1', 1, '2024-06-09 16:24:27', NULL, NULL),
(6, 2, 'B2', 'B2', 'B2', 1, '2024-06-09 16:24:40', NULL, NULL),
(7, 2, 'C1', 'B2', 'B1', 2, '2024-06-09 17:29:13', NULL, NULL),
(8, 3, 'B2', 'A2', 'B1', 3, '2024-10-12 12:59:51', NULL, NULL),
(9, 2, 'B2', 'B1', 'B2', 3, '2024-10-12 13:00:19', NULL, '2024-10-12 11:00:23');

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

--
-- Structure de la table `vt_volontaires`
--

CREATE TABLE `vt_volontaires` (
  `id` int(5) UNSIGNED NOT NULL,
  `nom` varchar(100) DEFAULT NULL,
  `prenom` varchar(100) DEFAULT NULL,
  `surnom` varchar(100) DEFAULT NULL,
  `genre` enum('HOMME','FEMME','AUTRE','NON SPECIFIE') NOT NULL DEFAULT 'NON SPECIFIE',
  `birthDate` date DEFAULT NULL,
  `paysEligibiliteId` varchar(100) DEFAULT NULL,
  `paysRefusId` varchar(100) DEFAULT NULL,
  `nationaliteId` varchar(100) DEFAULT NULL,
  `profession` varchar(255) DEFAULT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `estStaff` enum('OUI','NON','ANCIEN') NOT NULL DEFAULT 'NON',
  `organisationId` int(11) DEFAULT NULL,
  `emplacement` enum('CHAMP','SIEGE SOCIAL') NOT NULL DEFAULT 'SIEGE SOCIAL',
  `numeroRH` varchar(100) DEFAULT NULL,
  `contratId` int(11) DEFAULT NULL,
  `passportImagePath` varchar(100) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `tailleChemiseId` enum('XXS','XS','S','M','L','XL','XXL','XXXL') NOT NULL DEFAULT 'S',
  `pointure` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `telephone` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Déchargement des données de la table `vt_volontaires`
--

INSERT INTO `vt_volontaires` (`id`, `nom`, `prenom`, `surnom`, `genre`, `birthDate`, `paysEligibiliteId`, `paysRefusId`, `nationaliteId`, `profession`, `titre`, `estStaff`, `organisationId`, `emplacement`, `numeroRH`, `contratId`, `passportImagePath`, `userId`, `tailleChemiseId`, `pointure`, `email`, `telephone`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'LEOPOLD ', 'GIRUKWAYO ', 'leopold', 'HOMME', '1984-05-23', '26', NULL, '26', 'Chef de Département Digitalisation', 'Msc', 'OUI', 1, 'CHAMP', '3250000', 1, NULL, 1, 'L', '202', 'leopold@gmail.com', '+257 79 570 922', '2024-06-01 18:27:53', NULL, NULL),
(2, 'Bertin', 'NDUWAYO', 'bertin@gmail.com', 'NON SPECIFIE', NULL, NULL, NULL, NULL, NULL, NULL, 'NON', NULL, 'SIEGE SOCIAL', NULL, NULL, '2_1724500829_87b844462e44eb48aba6.jpg', 2, 'S', NULL, NULL, NULL, '2024-06-01 18:39:55', NULL, NULL),
(3, 'NDAYIZEYE', 'THADDEE', 'Ir Nditade90', 'HOMME', '1993-03-05', '26', NULL, '40', 'Ingenieur', 'Ir', 'OUI', 1, 'SIEGE SOCIAL', '01240', 1, '3_1728728299_986ff0fca567812cef1f.jpg', 3, 'M', '32', 'thandize@gmail.com', '79802611', '2024-10-12 11:51:13', NULL, NULL);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auth_groups_users_user_id_foreign` (`user_id`);

--
-- Index pour la table `auth_logins`
--
ALTER TABLE `auth_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_type_identifier` (`id_type`,`identifier`),
  ADD KEY `user_id` (`user_id`);

--
-- Index pour la table `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `auth_permissions_users_user_id_foreign` (`user_id`);

--
-- Index pour la table `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `selector` (`selector`),
  ADD KEY `auth_remember_tokens_user_id_foreign` (`user_id`);

--
-- Index pour la table `auth_token_logins`
--
ALTER TABLE `auth_token_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_type_identifier` (`id_type`,`identifier`),
  ADD KEY `user_id` (`user_id`);

--
-- Index pour la table `dc_documents`
--
ALTER TABLE `dc_documents`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `pays`
--
ALTER TABLE `pays`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `pt_candidatures`
--
ALTER TABLE `pt_candidatures`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `pt_postes`
--
ALTER TABLE `pt_postes`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Index pour la table `vt_etudes`
--
ALTER TABLE `vt_etudes`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `vt_experiences`
--
ALTER TABLE `vt_experiences`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `vt_languages`
--
ALTER TABLE `vt_languages`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `vt_volontaires`
--
ALTER TABLE `vt_volontaires`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT pour la table `auth_logins`
--
ALTER TABLE `auth_logins`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT pour la table `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `auth_token_logins`
--
ALTER TABLE `auth_token_logins`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `dc_documents`
--
ALTER TABLE `dc_documents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT pour la table `pays`
--
ALTER TABLE `pays`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194;

--
-- AUTO_INCREMENT pour la table `pt_candidatures`
--
ALTER TABLE `pt_candidatures`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `pt_postes`
--
ALTER TABLE `pt_postes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `vt_etudes`
--
ALTER TABLE `vt_etudes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT pour la table `vt_experiences`
--
ALTER TABLE `vt_experiences`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT pour la table `vt_languages`
--
ALTER TABLE `vt_languages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `vt_volontaires`
--
ALTER TABLE `vt_volontaires`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `auth_groups_users`
--
ALTER TABLE `auth_groups_users`
  ADD CONSTRAINT `auth_groups_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `auth_permissions_users`
--
ALTER TABLE `auth_permissions_users`
  ADD CONSTRAINT `auth_permissions_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `auth_remember_tokens`
--
ALTER TABLE `auth_remember_tokens`
  ADD CONSTRAINT `auth_remember_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

