tp_bdd2

rbonnet/tp_bdd2

Fork 0

Commit graph

31569dd426 delete names ins master Olougouna Axel 2023-01-09 17:33:19 +0100
a13fd0c635 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Ronan 2023-01-09 17:15:09 +0100
b69647ffbe Update README.md Ronan 2023-01-09 17:14:42 +0100
965ebc1073 ajout publie_scien Olougouna Axel 2023-01-09 17:01:19 +0100
f79fceb56b Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Olougouna Axel 2023-01-09 16:55:02 +0100
316db70eee correction Q12 Olougouna Axel 2023-01-09 16:54:25 +0100
4bfecbdee1 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2023-01-09 16:33:17 +0100
0d63d02fd1 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Bonnet Ronan 2023-01-05 10:34:17 +0100
24f11b32f6 Q19 25 au lieu de 50 Bonnet Ronan 2023-01-05 10:34:14 +0100
fcd63f3b6d meilleurs encadrement nbillard 2023-01-05 10:29:48 +0100
9d553a1867 enlever publie doctorant nbillard 2023-01-05 10:24:47 +0100
6fe86ca434 publie_doctorant correction nbillard 2023-01-05 10:23:46 +0100
b30aa535b7 changement d'ordre nbillard 2023-01-05 10:19:53 +0100
d700e9bfe7 correction partenaires nbillard 2023-01-05 10:17:19 +0100
6392ad33cd fix insert problems zith participe_externe Bonnet Ronan 2023-01-05 10:13:07 +0100
cf4f9aefe7 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 nbillard 2023-01-05 10:09:26 +0100
09d6c4ac0e Mettre à jour 'insert.sql' Yasmine Grane-Belghmaidi 2023-01-05 10:09:53 +0100
8b38182704 plus de Scientifiques nbillard 2023-01-05 10:09:23 +0100
bf79b7e2c0 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Olougouna Axel 2023-01-05 10:06:22 +0100
bfc1592cd4 modification partenaire insert Olougouna Axel 2023-01-05 10:06:17 +0100
162a26aea6 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Bonnet Ronan 2023-01-05 10:04:10 +0100
68c2ded08a fix insert problems zith participe_externe Bonnet Ronan 2023-01-05 10:04:07 +0100
78f50e73bf Mettre à jour 'insert.sql' Yasmine Grane-Belghmaidi 2023-01-05 10:03:39 +0100
638d27f33b enlever right join Olougouna Axel 2023-01-05 09:56:07 +0100
59175ccede enlever right join Olougouna Axel 2023-01-05 09:55:00 +0100
7874e08ce3 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2023-01-05 09:54:43 +0100
acf1f26930 cleanup nbillard 2023-01-05 09:48:11 +0100
b10454ead7 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Bonnet Ronan 2023-01-05 09:47:02 +0100
b8b20ae87e Q18 updated Bonnet Ronan 2023-01-05 09:46:56 +0100
a397fd1016 q20 Olougouna Axel 2023-01-05 09:42:48 +0100
5c16d82893 q20 Olougouna Axel 2023-01-05 09:40:05 +0100
2d6364068e rien nbillard 2023-01-05 09:37:40 +0100
770b74f34f Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 nbillard 2023-01-05 09:09:58 +0100
048edb8f23 question 18 done and dusted nbillard 2023-01-05 09:09:53 +0100
e17841d284 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2023-01-05 08:42:50 +0100
571aff5e4b Mettre à jour 'insert.sql' Yasmine Grane-Belghmaidi 2023-01-05 08:36:38 +0100
a116a06de6 Mettre à jour 'insert.sql' Yasmine Grane-Belghmaidi 2022-12-16 10:06:32 +0100
40de1c4744 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 nbillard 2022-12-16 09:48:46 +0100
46f3d489cc Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 09:49:35 +0100
705f541df7 fixed id errors nbillard 2022-12-16 09:48:43 +0100
c7a7cde2e1 fixing merging errors nbillard 2022-12-16 09:45:20 +0100
31f90b2742 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Olougouna Axel 2022-12-16 09:45:31 +0100
4b10960648 verif Olougouna Axel 2022-12-16 09:45:24 +0100
c7492f86c7 git error fixed nbillard 2022-12-16 09:44:51 +0100
0393829d7f merging nbillard 2022-12-16 09:41:34 +0100
38d778edb5 grosse periode de recrutement d'enseigant chercheurs nbillard 2022-12-16 09:40:41 +0100
b119cf9702 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 09:38:24 +0100
401e6ce57e Mettre à jour 'insert.sql' Yasmine Grane-Belghmaidi 2022-12-16 09:36:25 +0100
a5f8e10aa2 question 13 tested Olougouna Axel 2022-12-16 09:20:57 +0100
448879958c question 13 tested Olougouna Axel 2022-12-16 09:17:00 +0100
1a38bf8865 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 nbillard 2022-12-16 09:12:23 +0100
b922fce465 Je ne sais plus ce que j'ai changé nbillard 2022-12-16 09:12:21 +0100
aff391728d Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 09:05:59 +0100
254bd4bca2 idScientifique -> idEnseignant in Q12 nbillard 2022-12-16 09:03:57 +0100
fe46cd661b annee -> nbAnnee in Q14 nbillard 2022-12-16 09:01:34 +0100
5c9d2331b5 Q14 group by annee nbillard 2022-12-16 09:00:45 +0100
46faf9f056 Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 nbillard 2022-12-16 08:57:09 +0100
f6031039c9 changed table at the top nbillard 2022-12-16 08:57:07 +0100
b41fd4dfbb Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 08:57:03 +0100
1f55276c20 question 12 modif Olougouna Axel 2022-12-16 08:55:55 +0100
49dfa0a5cc Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 Olougouna Axel 2022-12-16 08:54:28 +0100
703cc448d2 question 12 modif Olougouna Axel 2022-12-16 08:54:23 +0100
d381f41656 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 08:52:55 +0100
a8de11367b Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 correction sur la q 13 Olougouna Axel 2022-12-16 08:51:01 +0100
21871f627d Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 modif 13 Olougouna Axel 2022-12-16 08:49:43 +0100
b4690a1298 question 13 modif Olougouna Axel 2022-12-16 08:49:35 +0100
77e26c8927 added data to test Q8 nbillard 2022-12-16 08:48:24 +0100
91911825ef trying to merge nbillard 2022-12-16 08:44:01 +0100
af3e89bb6e Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 question 13 Olougouna Axel 2022-12-16 08:43:21 +0100
50da8ceda6 removing unasked field from Q10 nbillard 2022-12-16 08:43:19 +0100
03f4e38087 question 13 Olougouna Axel 2022-12-16 08:43:16 +0100
6481e3fb89 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 08:41:54 +0100
5dd1aaffc7 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 08:41:28 +0100
1b8af74789 Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 08:40:33 +0100
f53e529e07 merging nbillard 2022-12-16 08:35:03 +0100
fe19f14dfe Q6 soutenance not null was false. Corrected nbillard 2022-12-16 08:34:33 +0100
116fbe0c6f Mettre à jour 'request.sql' Yasmine Grane-Belghmaidi 2022-12-16 08:34:12 +0100
b12c9da93c Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 coucou Olougouna Axel 2022-12-16 08:30:02 +0100
bcc5fcadf1 question 13 Olougouna Axel 2022-12-16 08:29:54 +0100
bb91580bbb added missing semicolon nbillard 2022-12-16 08:28:03 +0100
e396acf0c8 changer le nom de la variable pour qu'il corresponde à celui de la table nbillard 2022-12-16 08:24:31 +0100
b29353ac0f changer la requete (id = 1 -> id = 2) pour marcher avec les valeurs des données nbillard 2022-12-16 08:21:04 +0100
6c706ee47e Merge branch 'master' of https://git.etud.insa-toulouse.fr/rbonnet/tp_bdd2 nbillard 2022-12-16 08:20:10 +0100
950c3cdc0b data to test Q3 nbillard 2022-12-16 08:20:08 +0100
0809696b8b modification du 3 Olougouna Axel 2022-12-16 08:19:08 +0100
eb1ecc0448 ajout du tableau pour référencer le travail nbillard 2022-12-11 07:59:49 +0100
e99020f731 adding data to test Q2 nbillard 2022-12-10 15:48:07 +0100
d761ed9534 fixing Q2 nbillard 2022-12-10 15:40:35 +0100
b621514c66 still fixing Q2 nbillard 2022-12-10 15:39:18 +0100
83ac1569fa fixing Q2 syntax nbillard 2022-12-10 15:37:37 +0100
307d5ea27c trying to test Q2 nbillard 2022-12-10 15:36:14 +0100
30982efc3b Q19 done and tested nbillard 2022-12-10 15:26:36 +0100
8271e66ce4 Q11 done and tested nbillard 2022-12-10 15:04:57 +0100
a07068a21d fixed non-existing foreign ids nbillard 2022-12-10 13:15:11 +0100
76877a4726 fixed typos nbillard 2022-12-10 13:12:28 +0100
ce2e4fa123 removed ids in insert.sql when SERIAL is used nbillard 2022-12-10 13:03:25 +0100
70ef1db8e4 fixing remaining insert.sql errors nbillard 2022-12-10 12:55:00 +0100
e5e00a775d fixing insert.sql errors nbillard 2022-12-10 12:53:32 +0100
0c71b50ab5 fixed errors created during standardisation nbillard 2022-12-10 12:43:56 +0100
8bfc3ae46d standardisé la création de tables nbillard 2022-12-10 12:42:29 +0100