-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Hôte : 127.0.0.1 -- Généré le : dim. 07 août 2022 à 22:48 -- Version du serveur : 10.4.21-MariaDB -- Version de PHP : 8.0.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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 */; -- -- Base de données : `religious` -- -- -------------------------------------------------------- -- -- Structure de la table `activite_religieuses` -- CREATE TABLE `activite_religieuses` ( `id` bigint(20) UNSIGNED NOT NULL, `type_activite_religieuse_id` bigint(20) UNSIGNED NOT NULL, `rubrique` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `contenu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `bibles` -- CREATE TABLE `bibles` ( `id` bigint(20) UNSIGNED NOT NULL, `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `libelle_bible` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_parution` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contenu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Déchargement des données de la table `bibles` -- INSERT INTO `bibles` (`id`, `version`, `libelle_bible`, `date_parution`, `contenu`, `notes`, `created_at`, `updated_at`) VALUES (1, 'version 1', 'catastroph', '12/02/2022', 'bla bla bla bla ', 'bla bla bla bla', '2022-08-07 20:37:55', '2022-08-07 20:37:55'), (2, 'version 2', 'lib', '2022-08-13', 'bla', 'bla bla', '2022-08-07 19:41:13', '2022-08-07 19:41:13'); -- -------------------------------------------------------- -- -- Structure de la table `calendrier_liturgiques` -- CREATE TABLE `calendrier_liturgiques` ( `id` bigint(20) UNSIGNED NOT NULL, `liturgie_jour_id` bigint(20) UNSIGNED NOT NULL, `evenement_id` bigint(20) UNSIGNED NOT NULL, `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `libelle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Déchargement des données de la table `categories` -- INSERT INTO `categories` (`id`, `libelle`, `created_at`, `updated_at`) VALUES (2, 'ancien testament 1', '2022-08-07 19:21:21', '2022-08-07 18:35:34'), (3, 'Nouveau testament', '2022-08-07 18:26:00', '2022-08-07 18:26:00'); -- -------------------------------------------------------- -- -- Structure de la table `chapitres` -- CREATE TABLE `chapitres` ( `id` bigint(20) UNSIGNED NOT NULL, `livre_biblique_id` bigint(20) UNSIGNED NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `deuxieme_lectures` -- CREATE TABLE `deuxieme_lectures` ( `id` bigint(20) UNSIGNED NOT NULL, `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `evangiles` -- CREATE TABLE `evangiles` ( `id` bigint(20) UNSIGNED NOT NULL, `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `evenements` -- CREATE TABLE `evenements` ( `id` bigint(20) UNSIGNED NOT NULL, `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `foire_aux_questions` -- CREATE TABLE `foire_aux_questions` ( `id` bigint(20) UNSIGNED NOT NULL, `question_reponse_id` bigint(20) UNSIGNED NOT NULL, `bible_id` bigint(20) UNSIGNED NOT NULL, `liturgie_id` bigint(20) UNSIGNED NOT NULL, `contenu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `liturgie_jours` -- CREATE TABLE `liturgie_jours` ( `id` bigint(20) UNSIGNED NOT NULL, `premiere_lecture_id` bigint(20) UNSIGNED NOT NULL, `deuxieme_lecture_id` bigint(20) UNSIGNED NOT NULL, `psaume_id` bigint(20) UNSIGNED NOT NULL, `evangile_id` bigint(20) UNSIGNED NOT NULL, `programme_messe_id` bigint(20) UNSIGNED NOT NULL, `libelle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `contenu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `commentaire` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `livres_bibliques` -- CREATE TABLE `livres_bibliques` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `bible_id` bigint(20) UNSIGNED NOT NULL, `libelle_livre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ancien_t` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nouveau_t` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description_livre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Déchargement des données de la table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2021_11_23_121245_create_verify_users_table', 1), (6, '2021_12_10_063410_create_bible_table', 1), (7, '2021_12_10_063438_create_categories_table', 1), (8, '2021_12_10_063509_create_livres_bibliques_table', 1), (9, '2021_12_10_070309_create_chapitres_table', 1), (10, '2021_12_10_070409_create_verses_table', 1), (11, '2021_12_10_073437_create_type_activite_religieuses_table', 1), (12, '2021_12_10_073438_create_activite_religieuses_table', 1), (13, '2021_12_10_073438_create_paroisses_table', 1), (14, '2021_12_10_073438_create_programme_messes_table', 1), (15, '2021_12_10_073526_create_premiere_lectures_table', 1), (16, '2021_12_10_073527_create_deuxieme_lectures_table', 1), (17, '2021_12_10_073527_create_evangiles_table', 1), (18, '2021_12_10_073527_create_evenements_table', 1), (19, '2021_12_10_073528_create_psaumes_table', 1), (20, '2021_12_10_073529_create_liturgie_jours_table', 1), (21, '2021_12_10_073530_create_calendrier_liturgiques_table', 1), (22, '2021_12_10_073740_create_question_reponses_table', 1), (23, '2021_12_10_073746_create_foire_aux_questions_table', 1); -- -------------------------------------------------------- -- -- Structure de la table `paroisses` -- CREATE TABLE `paroisses` ( `id` bigint(20) UNSIGNED NOT NULL, `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `annonce` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `adresse` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `premiere_lectures` -- CREATE TABLE `premiere_lectures` ( `id` bigint(20) UNSIGNED NOT NULL, `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `programme_messes` -- CREATE TABLE `programme_messes` ( `id` bigint(20) UNSIGNED NOT NULL, `activite_religieuse_id` bigint(20) UNSIGNED NOT NULL, `paroisse_id` bigint(20) UNSIGNED NOT NULL, `libelle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `deroulement` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `duree` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `psaumes` -- CREATE TABLE `psaumes` ( `id` bigint(20) UNSIGNED NOT NULL, `text_ps` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description_ps` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `question_reponses` -- CREATE TABLE `question_reponses` ( `id` bigint(20) UNSIGNED NOT NULL, `num` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `reponse` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `type_activite_religieuses` -- CREATE TABLE `type_activite_religieuses` ( `id` bigint(20) UNSIGNED NOT NULL, `libelle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `verified` tinyint(1) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 0, `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Déchargement des données de la table `users` -- INSERT INTO `users` (`id`, `name`, `phone`, `email`, `dob`, `email_verified_at`, `verified`, `active`, `token`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Aristide Wilfried MVELE MVELE', '+237656551855', 'mvelemvele@gmail.com', NULL, NULL, 0, 0, '11df854d16abc2d6825ac16c7f4a5e1ecb85ce9b', '$2y$10$VpIoC9z3VlLNQDA2gggI7ubvV/MnRU1KyGQQZqkti6r1dJB62vHZy', NULL, '2022-08-07 18:48:42', '2022-08-07 18:48:42'); -- -------------------------------------------------------- -- -- Structure de la table `verify_users` -- CREATE TABLE `verify_users` ( `id` bigint(20) UNSIGNED NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `verses` -- CREATE TABLE `verses` ( `id` bigint(20) UNSIGNED NOT NULL, `chapitre_id` bigint(20) UNSIGNED NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Index pour les tables déchargées -- -- -- Index pour la table `activite_religieuses` -- ALTER TABLE `activite_religieuses` ADD PRIMARY KEY (`id`), ADD KEY `activite_religieuses_type_activite_religieuse_id_foreign` (`type_activite_religieuse_id`); -- -- Index pour la table `bibles` -- ALTER TABLE `bibles` ADD PRIMARY KEY (`id`); -- -- Index pour la table `calendrier_liturgiques` -- ALTER TABLE `calendrier_liturgiques` ADD PRIMARY KEY (`id`), ADD KEY `calendrier_liturgiques_liturgie_jour_id_foreign` (`liturgie_jour_id`), ADD KEY `calendrier_liturgiques_evenement_id_foreign` (`evenement_id`); -- -- Index pour la table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Index pour la table `chapitres` -- ALTER TABLE `chapitres` ADD PRIMARY KEY (`id`), ADD KEY `chapitres_livre_biblique_id_foreign` (`livre_biblique_id`); -- -- Index pour la table `deuxieme_lectures` -- ALTER TABLE `deuxieme_lectures` ADD PRIMARY KEY (`id`); -- -- Index pour la table `evangiles` -- ALTER TABLE `evangiles` ADD PRIMARY KEY (`id`); -- -- Index pour la table `evenements` -- ALTER TABLE `evenements` ADD PRIMARY KEY (`id`); -- -- Index pour la table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Index pour la table `foire_aux_questions` -- ALTER TABLE `foire_aux_questions` ADD PRIMARY KEY (`id`), ADD KEY `foire_aux_questions_question_reponse_id_foreign` (`question_reponse_id`), ADD KEY `foire_aux_questions_bible_id_foreign` (`bible_id`), ADD KEY `foire_aux_questions_liturgie_id_foreign` (`liturgie_id`); -- -- Index pour la table `liturgie_jours` -- ALTER TABLE `liturgie_jours` ADD PRIMARY KEY (`id`), ADD KEY `liturgie_jours_premiere_lecture_id_foreign` (`premiere_lecture_id`), ADD KEY `liturgie_jours_deuxieme_lecture_id_foreign` (`deuxieme_lecture_id`), ADD KEY `liturgie_jours_psaume_id_foreign` (`psaume_id`), ADD KEY `liturgie_jours_evangile_id_foreign` (`evangile_id`), ADD KEY `liturgie_jours_programme_messe_id_foreign` (`programme_messe_id`); -- -- Index pour la table `livres_bibliques` -- ALTER TABLE `livres_bibliques` ADD PRIMARY KEY (`id`), ADD KEY `livres_bibliques_category_id_foreign` (`category_id`), ADD KEY `livres_bibliques_bible_id_foreign` (`bible_id`); -- -- Index pour la table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Index pour la table `paroisses` -- ALTER TABLE `paroisses` ADD PRIMARY KEY (`id`); -- -- Index pour la table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Index pour la table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Index pour la table `premiere_lectures` -- ALTER TABLE `premiere_lectures` ADD PRIMARY KEY (`id`); -- -- Index pour la table `programme_messes` -- ALTER TABLE `programme_messes` ADD PRIMARY KEY (`id`), ADD KEY `programme_messes_activite_religieuse_id_foreign` (`activite_religieuse_id`), ADD KEY `programme_messes_paroisse_id_foreign` (`paroisse_id`); -- -- Index pour la table `psaumes` -- ALTER TABLE `psaumes` ADD PRIMARY KEY (`id`); -- -- Index pour la table `question_reponses` -- ALTER TABLE `question_reponses` ADD PRIMARY KEY (`id`); -- -- Index pour la table `type_activite_religieuses` -- ALTER TABLE `type_activite_religieuses` ADD PRIMARY KEY (`id`); -- -- Index pour la table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Index pour la table `verify_users` -- ALTER TABLE `verify_users` ADD PRIMARY KEY (`id`), ADD KEY `verify_users_user_id_foreign` (`user_id`); -- -- Index pour la table `verses` -- ALTER TABLE `verses` ADD PRIMARY KEY (`id`), ADD KEY `verses_chapitre_id_foreign` (`chapitre_id`); -- -- AUTO_INCREMENT pour les tables déchargées -- -- -- AUTO_INCREMENT pour la table `activite_religieuses` -- ALTER TABLE `activite_religieuses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `bibles` -- ALTER TABLE `bibles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT pour la table `calendrier_liturgiques` -- ALTER TABLE `calendrier_liturgiques` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT pour la table `chapitres` -- ALTER TABLE `chapitres` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `deuxieme_lectures` -- ALTER TABLE `deuxieme_lectures` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `evangiles` -- ALTER TABLE `evangiles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `evenements` -- ALTER TABLE `evenements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `foire_aux_questions` -- ALTER TABLE `foire_aux_questions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `liturgie_jours` -- ALTER TABLE `liturgie_jours` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `livres_bibliques` -- ALTER TABLE `livres_bibliques` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT pour la table `paroisses` -- ALTER TABLE `paroisses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `premiere_lectures` -- ALTER TABLE `premiere_lectures` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `programme_messes` -- ALTER TABLE `programme_messes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `psaumes` -- ALTER TABLE `psaumes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `question_reponses` -- ALTER TABLE `question_reponses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `type_activite_religieuses` -- ALTER TABLE `type_activite_religieuses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT pour la table `verify_users` -- ALTER TABLE `verify_users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT pour la table `verses` -- ALTER TABLE `verses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Contraintes pour les tables déchargées -- -- -- Contraintes pour la table `activite_religieuses` -- ALTER TABLE `activite_religieuses` ADD CONSTRAINT `activite_religieuses_type_activite_religieuse_id_foreign` FOREIGN KEY (`type_activite_religieuse_id`) REFERENCES `type_activite_religieuses` (`id`); -- -- Contraintes pour la table `calendrier_liturgiques` -- ALTER TABLE `calendrier_liturgiques` ADD CONSTRAINT `calendrier_liturgiques_evenement_id_foreign` FOREIGN KEY (`evenement_id`) REFERENCES `evenements` (`id`), ADD CONSTRAINT `calendrier_liturgiques_liturgie_jour_id_foreign` FOREIGN KEY (`liturgie_jour_id`) REFERENCES `liturgie_jours` (`id`); -- -- Contraintes pour la table `chapitres` -- ALTER TABLE `chapitres` ADD CONSTRAINT `chapitres_livre_biblique_id_foreign` FOREIGN KEY (`livre_biblique_id`) REFERENCES `livres_bibliques` (`id`); -- -- Contraintes pour la table `foire_aux_questions` -- ALTER TABLE `foire_aux_questions` ADD CONSTRAINT `foire_aux_questions_bible_id_foreign` FOREIGN KEY (`bible_id`) REFERENCES `bibles` (`id`), ADD CONSTRAINT `foire_aux_questions_liturgie_id_foreign` FOREIGN KEY (`liturgie_id`) REFERENCES `liturgie_jours` (`id`), ADD CONSTRAINT `foire_aux_questions_question_reponse_id_foreign` FOREIGN KEY (`question_reponse_id`) REFERENCES `question_reponses` (`id`); -- -- Contraintes pour la table `liturgie_jours` -- ALTER TABLE `liturgie_jours` ADD CONSTRAINT `liturgie_jours_deuxieme_lecture_id_foreign` FOREIGN KEY (`deuxieme_lecture_id`) REFERENCES `deuxieme_lectures` (`id`), ADD CONSTRAINT `liturgie_jours_evangile_id_foreign` FOREIGN KEY (`evangile_id`) REFERENCES `evangiles` (`id`), ADD CONSTRAINT `liturgie_jours_premiere_lecture_id_foreign` FOREIGN KEY (`premiere_lecture_id`) REFERENCES `premiere_lectures` (`id`), ADD CONSTRAINT `liturgie_jours_programme_messe_id_foreign` FOREIGN KEY (`programme_messe_id`) REFERENCES `programme_messes` (`id`), ADD CONSTRAINT `liturgie_jours_psaume_id_foreign` FOREIGN KEY (`psaume_id`) REFERENCES `psaumes` (`id`); -- -- Contraintes pour la table `livres_bibliques` -- ALTER TABLE `livres_bibliques` ADD CONSTRAINT `livres_bibliques_bible_id_foreign` FOREIGN KEY (`bible_id`) REFERENCES `bibles` (`id`), ADD CONSTRAINT `livres_bibliques_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`); -- -- Contraintes pour la table `programme_messes` -- ALTER TABLE `programme_messes` ADD CONSTRAINT `programme_messes_activite_religieuse_id_foreign` FOREIGN KEY (`activite_religieuse_id`) REFERENCES `activite_religieuses` (`id`), ADD CONSTRAINT `programme_messes_paroisse_id_foreign` FOREIGN KEY (`paroisse_id`) REFERENCES `paroisses` (`id`); -- -- Contraintes pour la table `verify_users` -- ALTER TABLE `verify_users` ADD CONSTRAINT `verify_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Contraintes pour la table `verses` -- ALTER TABLE `verses` ADD CONSTRAINT `verses_chapitre_id_foreign` FOREIGN KEY (`chapitre_id`) REFERENCES `chapitres` (`id`); 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 */;