From 9738017972a6d4fea655926525b3c67dd85740cf Mon Sep 17 00:00:00 2001 From: Ludovic Pouzenc Date: Sat, 30 Jun 2018 11:39:33 +0200 Subject: Version beta_accents 2007-03-12+17:26:00 - 2007-03-14+17:35:14 --- beta_accents/install/jeu_essai.sql | 116 +----------------------------------- beta_accents/install/jeu_essai.sql~ | 114 ----------------------------------- 2 files changed, 2 insertions(+), 228 deletions(-) delete mode 100644 beta_accents/install/jeu_essai.sql~ (limited to 'beta_accents/install') diff --git a/beta_accents/install/jeu_essai.sql b/beta_accents/install/jeu_essai.sql index 7723733..889d4f6 100644 --- a/beta_accents/install/jeu_essai.sql +++ b/beta_accents/install/jeu_essai.sql @@ -1,114 +1,2 @@ --- --- Base de données: `awor` --- - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Appartenir` --- -DELETE FROM `AWOR_Appartenir`; -INSERT INTO `AWOR_Appartenir` (`idL`, `idP`) VALUES (1, 2), -(1, 3), -(1, 4), -(1, 5), -(2, 1), -(2, 2), -(2, 4), -(2, 5), -(3, 1), -(3, 2), -(3, 3), -(4, 1), -(4, 4), -(4, 5), -(5, 1), -(5, 4), -(5, 5), -(6, 1), -(6, 2), -(6, 3), -(8, 1), -(8, 2), -(8, 3), -(8, 4); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Choisir` --- -DELETE FROM `AWOR_Choisir`; -INSERT INTO `AWOR_Choisir` (`idC`, `idP`, `estDispo`) VALUES (1, 3, 'oui'), -(6, 1, 'oui'), -(7, 1, 'non'), -(1, 2, 'oui'), -(2, 2, 'non'), -(3, 2, 'oui'), -(4, 2, 'non'), -(5, 2, 'oui'); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Creneau` --- -DELETE FROM `AWOR_Creneau`; -INSERT INTO `AWOR_Creneau` (`idC`, `dateHeure`, `duree`, `idR`) VALUES (1, '2007-04-01 07:45:00', 645, 1), -(2, '2007-04-03 09:15:00', 75, 1), -(3, '2007-04-10 09:15:00', 75, 1), -(4, '2007-04-17 09:15:00', 75, 1), -(5, '2007-04-24 09:15:00', 75, 1), -(6, '2007-06-20 10:10:00', 80, 2), -(7, '2007-06-25 12:00:00', 30, 2), -(8, '2007-04-25 00:00:00', 0, 4); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Fichier` --- -DELETE FROM `AWOR_Fichier`; -INSERT INTO `AWOR_Fichier` (`idFic`, `nomFic`, `idR`) VALUES (1, 'r1_READ_ME.pdf', 1), -(2, 'r2_IUP MER.txt', 2); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Liste` --- -DELETE FROM `AWOR_Liste`; -INSERT INTO `AWOR_Liste` (`idL`, `libelleL`, `estPrivee`, `idP_Createur`) VALUES (1, 'interne_idR_1', 'oui', NULL), -(2, 'interne_idR_2', 'oui', NULL), -(3, 'Amis', 'oui', 3), -(4, 'interne_idR_3', 'oui', NULL), -(5, 'interne_idR_4', 'oui', NULL), -(6, 'Créateurs d''AWOR', 'oui', 1), -(7, 'interne_idR_5', 'oui', NULL), -(8, 'MaListePerso', 'oui', 2); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Personne` --- -DELETE FROM `AWOR_Personne`; -INSERT INTO `AWOR_Personne` (`idP`, `courrielP`, `loginP`, `nomP`, `prenomP`, `estAdmin`, `methodeAuth`) VALUES (1, 'lpouzenc@wanadoo.fr', 'lpouzenc', 'Pouzenc', 'Ludovic', 'oui', 'pop'), -(2, 'jeremie.denoyer@etu.iut-blagnac.fr', 'jeremie.denoyer', 'jeremie', 'denoyer', 'non', 'pop'), -(3, 'julien.sere@free.fr', 'julien.sere', 'Julien', 'Sere', 'non', 'pop'), -(4, 'soule@iut-blagnac.fr', 'soule@iut-blagnac.fr', 'Soulé', 'Geneviève', 'non', 'pop'), -(5, 'inglebert@iut-blagnac.fr', 'inglebert@iut-blagnac.fr', 'Inglebert', 'Jean-Michel', 'non', 'bypass'); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Repondre` --- -DELETE FROM `AWOR_Repondre`; -INSERT INTO `AWOR_Repondre` (`idR`, `idP`, `commentaireReponse`) VALUES (1, 1, 'Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...'), -(1, 3, 'Un commentaire à [ | ) @ {[| @#~{[#`|['), -(3, 1, 'Réunion juste pour le test...'); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Reunion` --- -DELETE FROM `AWOR_Reunion`; -INSERT INTO `AWOR_Reunion` (`idR`, `objetR`, `ordreJourR`, `lieuR`, `remarquesR`, `montrerDispoR`, `estAnnulee`, `idP_Orga`, `idC_Fixe`, `idL`) VALUES (1, 'Recette du projet tuteuré', 'Recette de cette magnifique application :-)', 'Salle 219', 'Aucune', 'non', 'non', 1, NULL, 1), -(2, 'Renseignez', NULL, NULL, NULL, 'non', 'non', 3, NULL, 2), -(3, 'Réunion annulée - essais', '', 'Nullepart', '', 'oui', 'oui', 1, NULL, 4), -(4, 'Réunion fixée pour tester', '', '', '', 'non', 'non', 1, 8, 5), -(5, 'Renseignez', NULL, NULL, NULL, 'non', 'non', 2, NULL, 7); +-- phpMyAdmin SQL Dump +-- TODO !! diff --git a/beta_accents/install/jeu_essai.sql~ b/beta_accents/install/jeu_essai.sql~ deleted file mode 100644 index f2d25b3..0000000 --- a/beta_accents/install/jeu_essai.sql~ +++ /dev/null @@ -1,114 +0,0 @@ --- --- Base de données: `awor` --- - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Appartenir` --- -DELETE FROM `AWOR_Appartenir`; -INSERT INTO `AWOR_Appartenir` (`idL`, `idP`) VALUES (1, 2), -(1, 3), -(1, 4), -(1, 5), -(2, 1), -(2, 2), -(2, 4), -(2, 5), -(3, 1), -(3, 2), -(3, 3), -(4, 1), -(4, 4), -(4, 5), -(5, 1), -(5, 4), -(5, 5), -(6, 1), -(6, 2), -(6, 3), -(8, 1), -(8, 2), -(8, 3), -(8, 4); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Choisir` --- -DELETE FROM `AWOR_Choisir`; -INSERT INTO `AWOR_Choisir` (`idC`, `idP`, `estDispo`) VALUES (1, 3, 'oui'), -(6, 1, 'oui'), -(7, 1, 'non'), -(1, 2, 'oui'), -(2, 2, 'non'), -(3, 2, 'oui'), -(4, 2, 'non'), -(5, 2, 'oui'); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Creneau` --- -DELETE FROM `AWOR_Creneau`; -INSERT INTO `AWOR_Creneau` (`idC`, `dateHeure`, `duree`, `idR`) VALUES (1, '2007-04-01 07:45:00', 645, 1), -(2, '2007-04-03 09:15:00', 75, 1), -(3, '2007-04-10 09:15:00', 75, 1), -(4, '2007-04-17 09:15:00', 75, 1), -(5, '2007-04-24 09:15:00', 75, 1), -(6, '2007-06-20 10:10:00', 80, 2), -(7, '2007-06-25 12:00:00', 30, 2), -(8, '2007-04-25 00:00:00', 0, 4); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Fichier` --- -DELETE FROM `AWOR_Fichier`; -INSERT INTO `AWOR_Fichier` (`idFic`, `nomFic`, `idR`) VALUES (1, 'r1_READ_ME.pdf', 1), -(2, 'r2_IUP MER.txt', 2); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Liste` --- -DELETE FROM `AWOR_Liste`; -INSERT INTO `AWOR_Liste` (`idL`, `libelleL`, `estPrivee`, `idP_Createur`) VALUES (1, 'interne_idR_1', 'oui', NULL), -(2, 'interne_idR_2', 'oui', NULL), -(3, 'Amis', 'oui', 3), -(4, 'interne_idR_3', 'oui', NULL), -(5, 'interne_idR_4', 'oui', NULL), -(6, 'Créateurs d''AWOR', 'oui', 1), -(7, 'interne_idR_5', 'oui', NULL), -(8, 'MaListePerso', 'oui', 2); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Personne` --- -DELETE FROM `AWOR_Personne`; -INSERT INTO `AWOR_Personne` (`idP`, `courrielP`, `loginP`, `nomP`, `prenomP`, `estAdmin`, `methodeAuth`) VALUES (1, 'lpouzenc@wanadoo.fr', 'lpouzenc', 'Pouzenc', 'Ludovic', 'oui', 'bypass'), -(2, 'jeremie.denoyer@etu.iut-blagnac.fr', 'jeremie.denoyer', 'jeremie', 'denoyer', 'non', 'bypass'), -(3, 'julien.sere@free.fr', 'julien.sere', 'Julien', 'Sere', 'non', 'bypass'), -(4, 'soule@iut-blagnac.fr', 'soule@iut-blagnac.fr', 'Soulé', 'Geneviève', 'non', 'bypass'), -(5, 'inglebert@iut-blagnac.fr', 'inglebert@iut-blagnac.fr', 'Inglebert', 'Jean-Michel', 'non', 'bypass'); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Repondre` --- -DELETE FROM `AWOR_Repondre`; -INSERT INTO `AWOR_Repondre` (`idR`, `idP`, `commentaireReponse`) VALUES (1, 1, 'Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...Test de commentaire un peu long...'), -(1, 3, 'Un commentaire à [ | ) @ {[| @#~{[#`|['), -(3, 1, 'Réunion juste pour le test...'); - --- -------------------------------------------------------- --- --- Contenu de la table `AWOR_Reunion` --- -DELETE FROM `AWOR_Reunion`; -INSERT INTO `AWOR_Reunion` (`idR`, `objetR`, `ordreJourR`, `lieuR`, `remarquesR`, `montrerDispoR`, `estAnnulee`, `idP_Orga`, `idC_Fixe`, `idL`) VALUES (1, 'Recette du projet tuteuré', 'Recette de cette magnifique application :-)', 'Salle 219', 'Aucune', 'non', 'non', 1, NULL, 1), -(2, 'Renseignez', NULL, NULL, NULL, 'non', 'non', 3, NULL, 2), -(3, 'Réunion annulée - essais', '', 'Nullepart', '', 'oui', 'oui', 1, NULL, 4), -(4, 'Réunion fixée pour tester', '', '', '', 'non', 'non', 1, 8, 5), -(5, 'Renseignez', NULL, NULL, NULL, 'non', 'non', 2, NULL, 7); -- cgit v1.2.3