summaryrefslogtreecommitdiff
path: root/beta_old1/install/jeu_essai.sql
diff options
context:
space:
mode:
authorLudovic Pouzenc <ludovic@pouzenc.fr>2018-06-30 11:37:30 +0200
committerLudovic Pouzenc <ludovic@pouzenc.fr>2018-06-30 11:37:30 +0200
commit5dac82f52f45ad27f16ec2ff63ee75e2f39ef942 (patch)
tree62cf671332976c83024139fc4c22009b382d45ff /beta_old1/install/jeu_essai.sql
parent34795da1b6bd714df0d5dce93558e04b2bb8a287 (diff)
download2007-AWOR-5dac82f52f45ad27f16ec2ff63ee75e2f39ef942.tar.gz
2007-AWOR-5dac82f52f45ad27f16ec2ff63ee75e2f39ef942.tar.bz2
2007-AWOR-5dac82f52f45ad27f16ec2ff63ee75e2f39ef942.zip
Renommage pour diff de beta_old1 vers beta_accents
Diffstat (limited to 'beta_old1/install/jeu_essai.sql')
-rw-r--r--beta_old1/install/jeu_essai.sql114
1 files changed, 0 insertions, 114 deletions
diff --git a/beta_old1/install/jeu_essai.sql b/beta_old1/install/jeu_essai.sql
deleted file mode 100644
index 7723733..0000000
--- a/beta_old1/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', '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);