-- MariaDB dump 10.19 Distrib 10.11.7-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: 127.0.0.1 Database: gestion_stage -- ------------------------------------------------------ -- Server version 10.11.7-MariaDB-1:10.11.7+maria~ubu2204 /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Temporary table structure for view `Activite` -- DROP TABLE IF EXISTS `Activite`; /*!50001 DROP VIEW IF EXISTS `Activite`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE VIEW `Activite` AS SELECT 1 AS `IdActivite`, 1 AS `IdEtudiant`, 1 AS `IdEntreprise`, 1 AS `Date`, 1 AS `Heure`, 1 AS `Type`, 1 AS `Etudiant`, 1 AS `Entreprise`, 1 AS `Ville`, 1 AS `Commentaire` */; SET character_set_client = @saved_cs_client; -- -- Table structure for table `Activite_Etu` -- DROP TABLE IF EXISTS `Activite_Etu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Activite_Etu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ID_Entreprise` int(11) DEFAULT NULL, `IdEtudiant` int(11) DEFAULT NULL, `date` datetime DEFAULT NULL, `type` varchar(25) DEFAULT NULL, `Commentaire` varchar(255) DEFAULT NULL, `contact_mail` varchar(100) DEFAULT NULL, `contact_tel` varchar(100) DEFAULT NULL, `contact_nom` varchar(100) DEFAULT NULL, `contact_fonction` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IdEtudiant` (`IdEtudiant`), KEY `ID_Entreprise` (`ID_Entreprise`), CONSTRAINT `Activite_Etu_ibfk_1` FOREIGN KEY (`IdEtudiant`) REFERENCES `User` (`id`), CONSTRAINT `Activite_Etu_ibfk_2` FOREIGN KEY (`ID_Entreprise`) REFERENCES `Entreprise` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Activite_Etu` -- LOCK TABLES `Activite_Etu` WRITE; /*!40000 ALTER TABLE `Activite_Etu` DISABLE KEYS */; INSERT INTO `Activite_Etu` VALUES (1,1,1,'2024-02-01 10:00:00','tel','no coment',NULL,NULL,NULL,NULL), (2,2,1,'2024-03-21 10:00:00','mail','un commentaire',NULL,NULL,NULL,NULL), (10,1,1,'2024-04-10 19:49:19','1','',NULL,NULL,NULL,NULL), (11,49,2,'2024-04-10 20:42:17','mal','',NULL,NULL,NULL,NULL), (12,100,2,'2024-04-11 09:20:44','1','5555555555555',NULL,NULL,NULL,NULL), (13,14,1,'2024-04-11 09:24:15','651656546546465','651651651651651',NULL,NULL,NULL,NULL), (14,85,2,'2024-04-11 09:24:38','56156516','5165165165156',NULL,NULL,NULL,NULL), (19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (25,2,NULL,'2024-04-20 19:57:35','mail',NULL,NULL,NULL,NULL,NULL), (26,45,1,'2024-04-20 22:24:53','tel','coucou',NULL,NULL,NULL,NULL), (27,1,1,'2024-04-20 22:25:10','email','zzzzzzz',NULL,NULL,NULL,NULL), (28,54,1,'2024-04-20 22:30:55','email','Ceci est mon commentaire',NULL,NULL,NULL,NULL), (29,53,1,'2024-04-20 22:38:30','tel','cccccccccccccc',NULL,NULL,NULL,NULL), (30,127,1,'2024-04-20 22:52:08','email','fzefz',NULL,NULL,NULL,NULL), (31,101,1,'2024-04-20 23:24:27','tel','ytesy',NULL,NULL,NULL,NULL), (32,54,1,'2024-04-21 15:49:40','email','fEFEF',NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `Activite_Etu` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'IGNORE_SPACE,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER ajout_activite BEFORE INSERT ON Activite_Etu FOR EACH ROW BEGIN SET NEW.date = NOW(); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `Employe` -- DROP TABLE IF EXISTS `Employe`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Employe` ( `id` int(11) NOT NULL, `idEntreprise` int(11) DEFAULT NULL, `nom` varchar(255) DEFAULT NULL, `prenom` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `telephone` varchar(255) DEFAULT NULL, `fonction` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idEntreprise` (`idEntreprise`), CONSTRAINT `Employe_ibfk_1` FOREIGN KEY (`idEntreprise`) REFERENCES `Entreprise` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Employe` -- LOCK TABLES `Employe` WRITE; /*!40000 ALTER TABLE `Employe` DISABLE KEYS */; /*!40000 ALTER TABLE `Employe` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Entreprise` -- DROP TABLE IF EXISTS `Entreprise`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Entreprise` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nomEntreprise` varchar(255) DEFAULT NULL, `adresse` varchar(255) DEFAULT NULL, `ville` varchar(255) DEFAULT NULL, `tel` varchar(255) DEFAULT NULL, `codePostal` varchar(255) DEFAULT NULL, `indice_fiabilite` int(11) DEFAULT NULL, `Notes` varchar(255) DEFAULT NULL, `dep_geo` varchar(100) DEFAULT NULL, `code_ape` varchar(100) DEFAULT NULL, `adresse2` varchar(255) DEFAULT NULL, `Created_UserID` int(11) DEFAULT NULL, `Created_Date` datetime DEFAULT NULL, `effectif` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf16 COLLATE=utf16_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Entreprise` -- LOCK TABLES `Entreprise` WRITE; /*!40000 ALTER TABLE `Entreprise` DISABLE KEYS */; INSERT INTO `Entreprise` VALUES (1,'Auto-école du Littoral','17, Rue Pujos','ROCHEFORT','0000000000000000000','17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (2,'Base aérienne 721',' Base Aérienne','Rochefort','05 46 88 80 00','17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (3,'IDK Stratégie Multimédia','Hotel d\'entreprise, local n°3, 1 Rue de la Trinquette','La Rochelle (Minnimes)',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (4,'Léa Nature','23Avenue Paul Langevin','Perigny Cedex',NULL,'17183',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (5,'Novatique','16 B RUE DU DANEMARK ','AURAY','','56400',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (6,'Novatique',NULL,'AURAY',NULL,'56400',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (7,'Pays Rochefortais','3 avenue Maurice Chupin Parc des Fouriers','Rochefort',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (8,'Sacrée Com','15 rue Renouleau','Tonnay-Charente',NULL,'17430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (9,'TESSI TECHNOLOGIES','1-3 Avenue des Satellites','Le Haillan',NULL,'33185',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (10,'4DConcept','41-43 Avenue du centre MONTIGNY LE BRETONNEUX','MONTIGNY LE BRETONNEUX',NULL,'78180',NULL,'Mr BALCERAK Mathieu',NULL,NULL,NULL,NULL,NULL,NULL), (11,'6 TEM\' INFORMATIQUE','2 RD 734','Dolus',NULL,'17550',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (12,'A2I Informatique ','Rue Augustin Fresnel –','PERIGNY',NULL,'17183',NULL,'Vincent PACOMME Directeur serv',NULL,NULL,NULL,NULL,NULL,NULL), (13,'A2I INFORMATIQUE','ZAC Les Montagnes BP5','CHAMPNIERS',NULL,'16430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (14,'ACT Service','18 rue de la Bonnette Les minimes','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (15,'Adequat Systeme','14 avenue Jean de Vivonne','Pisany',NULL,'17600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (16,'Alstom','Avenue Commdt Lysiack','Aytré',NULL,'17440',NULL,'Stephane Petit',NULL,NULL,NULL,NULL,NULL,NULL), (17,'Archipel',NULL,'ROCHEFORT',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (18,'Astron Associate SA','Ch du grand Puits 38 CP 339 CH – 1217 Meyrin - 1','Meyrin- Suisse',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (19,'CARA','107 avenue de ROCHEFORT','Royan',NULL,'17200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (20,'Caserne Renaudin','av Porte Dauphine','LA ROCHELLE',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (21,'CC17','37 rue du Dr Peltier','ROCHEFORT',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (22,'CCI Rochefort et Saintonges','Corderie Royale Rue Audebert','ROCHEFORT',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (23,'Centre hospitalier de Rochefort','16, Rue du Docteur Peltier','ROCHEFORT',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (24,'Centre hospitalier de Royan',NULL,'Royan',NULL,'17205',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (25,'Centre Hospitalier De Saintong','11 Bd Ambroise Paré BP326','SAINTES',NULL,'17108',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (26,'Cetios','Allée de la Baucette','Surgères',NULL,'17700',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (27,'CH Jonzac','Av, Winston churchild, BP 109','Jonzac',NULL,'17503',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (28,'cipecma',NULL,'Chatelaillon',NULL,'17340',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (29,'Clinique Pasteur',NULL,'Royan',NULL,'17200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (30,'CMAF ',NULL,'LA ROCHELLE',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (31,'Communauté d\'agglomération de ',NULL,'PERIGNY',NULL,'17180',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (32,'Mairie de Château-Larcher','4, Rue de la Mairie ','CHATEAU LARCHER',NULL,'86370',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (33,'CC17 INFORMATIQUE',' 37, rue du Docteur Peltier ','ROCHEFORT',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (34,'CYBERTEK','Avenue Fourneaux ','ANGOULINS SUR MER',NULL,'17690',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (35,'DATACLIC ','47, Rue Pierre de Campet','SAUJON',NULL,'17600',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (36,'DDSV ',NULL,'LA ROCHELLE',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (37,'DELAMET SAS ','16, Rue Gambetta ','Saint Aigulin',NULL,'17360',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (38,'DIGITAL','751 rue de la Génoise,Parc d\'activité Les Montagnes ','CHAMPNIERS',NULL,'16430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (39,'EIGSI - ',NULL,'La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (40,'ENILIA – ENSMIC','Avenue François Mitterand BP 49 ','SURGERES',NULL,'17700',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (41,'Foyer départemental Lannelongue','30 Bld du Débarquement','Saint Trojan Les Bains',NULL,'17370',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (42,'GARANDEAU FRERES Chamblanc ',' 2 route des étangs','Cherves-Richemont',NULL,'16370',NULL,' Champblanc',NULL,NULL,NULL,NULL,NULL,NULL), (43,'Groupe Coop Atlantique','3 rue du docteur jean ','SAINTES',NULL,'17100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (44,'Groupe Gibaud','15 rue de l\'ormeau du Pied Saintes ','SAINTES',NULL,'17100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (45,'Groupe Léa Nature','Avenue Paul Langevin','Périgny',NULL,'17180',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (46,'Excelia','102, Rue de Coureilles / 1 rue Jean Perrin','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (47,'Hano-communication ',' place Charles De Gaulle ','Aulnay',NULL,'17450',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (48,'IN TECH',' 2bis rue Ferdinand Gateau','Tonnay Charente ',NULL,'17430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (49,'IUT La Rochelle ',NULL,'La Rochelle ',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (50,'IUT La Rochelle ','15 rue François De Vaux Foletier ',' LA ROCHELE cedex 01 ',NULL,'17026',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (51,'Groupe Michel',' 163 Avenue Jean-Paul SARTRE ','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (52,'Jean-Noël Informatique','37 avenue d\'aunis ','tonnay-charente ',NULL,'17430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (53,'KUEHNE+NAGEL DSIA','16 rue de la petite sensive ','Nantes ',NULL,'44323',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (54,'Leroy Somer','Boulevard Marcelin Leroy','Angoulème',NULL,'16000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (55,'LP Jean Rostand louise lériget','12 Rue Louise Lériget','Angouleme ',NULL,'16000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (56,'Lycée ?','66 Boulevard de châtenay ','Cognac ',NULL,'16100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (57,'Lycée agricole','Site de l\'oisellerie ','Angouleme ',NULL,'16000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (58,'Lycée Agricole Bordeaux ',NULL,'Blanquefort ',NULL,'33290',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (59,'Lycee bellevue ',NULL,'SAINTES ',NULL,'17100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (60,'Lycée Bernard Palissy','1, Rue de Gascogne','SAINTES ',NULL,'17100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (61,'lycée Georges Desclaude','rue Georges Desclaude','Saintes',NULL,'17100',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (62,'Lycée georges Leygues ',NULL,'Villeneuve\\lot ',NULL,'47300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (63,'Lycée Jamain','2A Boulevard Pouzet ','ROCHEFORT ',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (64,'Lycée Jean DAUTET ',NULL,'La Rochelle ',NULL,'17000',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (65,'Lycée Léonce Vieljeux ','Rue des Gonthières ','La Rochelle ',NULL,'17000',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (66,'Lycée Marcel Dassault - ',' NULL','ROCHEFORT ',NULL,'17300',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (67,'lycée Professionnel Régional I',' NULL','COGNAC ',NULL,'16100',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (68,'Lycée Professionnel Rompsay',' Rue de Périgny ','La Rochelle',NULL,'17025',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (69,'Lycée Victor hugo ',NULL,'Poitiers ',NULL,'86000',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (70,'MAAF Assurances','SA Chauray ','Niort ',NULL,'79036',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (71,'Maiano Informatique',' 17 rue de l\'électricité 17200 Royan ','Royan ',NULL,'17200',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (72,'Mairie de Saintes','Square Andre Maudet ','SAINTES ',NULL,'17100',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (73,'Mairie de Chatelaillon ',NULL,'Chatelaillon ',NULL,'17340',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (74,'Mairie de Meschers','8 rue Paul Massy ','MESCHERS SUR GIRONDE',NULL,'17132',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (75,'Mairie de Poitiers Informatiqu','Rue du Dolmen','Poitiers',NULL,'86000',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (76,'Mairie de Pont l\'Abbé d\'Arnoul','Place du général de Gaulle','Pont l\'Abbé d\'Arnoult ',NULL,'17250',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (77,'MAIRIE DE ROYAN',' 80, avenue de Pontaillac ','Royan ',NULL,'17200',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (78,'MAIRIE DE SAUJON',' Hotel de ville BP 108 ','SAUJON ',NULL,'17600',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (79,'Malichaud atlantique','13 rue Hubert Pennevert','ROCHEFORT ',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (80,'MAPA Mutuelle d\'Assurance','Rue Anatole Contré ','Saint Jean d\'Angély ',NULL,'17400',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (81,'Metal Néo','ZI des Soeurs, 21 Boulevard du vercors','Rochefort',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (82,'MSA ','46, boulevard du Dr C.Duroselle','Angouleme ',NULL,'16000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (83,'NEOPC','ZI OUEST voie C ','SURGERES ',NULL,'17700',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (84,'NEVA technologies','40 Rue de Marignan','Cognac',NULL,'16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (85,'ORECO S.A. ','44 bd Oscar Planat ','COGNAC ',NULL,'16100',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (86,'Orix Informatique','6 rue pape','SAINTES ',NULL,'17100',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (87,'Boutique?','Parc d\'activité Les Montagnes ','ROCHEFORT ',NULL,'17300',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (88,'PRODWARE','9 rue jacques cartier ','AYTRE ',NULL,'17440',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (89,'Romain Informatique','20 rue de saint-vivien',' Bords',NULL,'17430',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (90,'Saint jean d\'Y / Val de Sainto',' rue texier ','Saint Jean d\'Angély ',NULL,'17400',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (91,'SAINTRONIC',' parc atlantique, l\'ormeau de pied ','SAINTES ',NULL,'17101',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (92,'SARL A.I.P.C. ','18, route de Frontenay RUFFIGNY','LA CRECHE ',NULL,'79260',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (93,'SARL Concept Joueur Cité Joueu','15, rue Jean Fougerat ','Angouleme ',NULL,'16000',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (94,'SARL DIF Informatique','ZA de chez Bernard 25 route de Cognac','Archiac',NULL,'17520',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (95,'SARL LE MONDE DU PC ','16,rue G. Claude ','Vaux Sur Mer ',NULL,'17640',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (96,'Satti informatique ','rue Augustin Fresnel ZI ','PERIGNY ',NULL,'17183',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (97,'Services-emedia','12 rue de la boulangerie ','Bernay Saint-Martin ',NULL,'17330',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (98,'Simair','17 avenue André Dublin','ROCHEFORT',NULL,'17300',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (99,'SOGEMAP','40, Rue de Marignan','COGNAC ',NULL,'16100',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (100,'SS2i-services','1 rue Alexandre Fleming','LA ROCHELLE ',NULL,'17000',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (101,'STEF INFORMATIX ','61, av. Lafayette ','ROCHEFORT ',NULL,'17300',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (102,'Soluris',NULL,'SAINTES ',NULL,'17100',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (103,'SYSTEL SA','17 Rue Leverrien','AYTRE',NULL,'17440',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (104,'URANIE ','Zone d\'activité des docks maritimes Bat A Quai Carriet ','Lormont ',NULL,'33310',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (105,'Zolux','141 cours Paul Doumer','Saintes',NULL,'17100',NULL,' NULL',NULL,NULL,NULL,NULL,NULL,NULL), (106,'Mairie Ecurat','route de ','Ecurat',NULL,'17560',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (107,'SASU Esprit numérique','rue Henri Giraudeau','Surgères',NULL,'17700',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (108,'Agence Wouep!','Pépinière d\'entreprises Indigo Allée de la Barratte','Surgères',NULL,'17700',NULL,'Z.I. de la métairie',NULL,NULL,NULL,NULL,NULL,NULL), (109,'LR Marketing','1 rue Fleming','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (110,'Cerealog ','1 place Bernard Moitessier','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (111,'Inter Mutuelles Assistance','118 avenue de Paris','Niort ',NULL,'79033',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (112,'Conservatoire du littoral','Corderie Royale CS 10137','Rochefort',NULL,'17306',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (113,'Communauté de Communes de l\'île de Ré','3, rue du Père Ignace','Saint Martin de Ré',NULL,'17410',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (114,'Pluscom','45 rue de la gare','Aytré',NULL,'17440',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (115,'Centre hospitalier Jonzac','4 avenue Winston Churchill ','Jonzac',NULL,'17503',NULL,'BP 80109',NULL,NULL,NULL,NULL,NULL,NULL), (116,'Mairie de La Rochelle','Place de l\'hôtel de ville','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (117,'SICA Atlantique','69 rue Montcalm','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (118,'A2MI','10 rue Jean Perrin','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (119,'Agence des territoires de la Vienne','Avenue René Cassin','Chasseneuil-du-Poitou',NULL,'86963',NULL,'Téléport 2 BP 90238',NULL,NULL,NULL,NULL,NULL,NULL), (120,'Terra Lacta',' 2 rue de la Glacière 05 46 30 30 30','Surgères ',NULL,'17700',NULL,' - CS 29 -',NULL,NULL,NULL,NULL,NULL,NULL), (121,'AP-HP Corentin Celton','4, parvis Corentin Celton','Issy-les-Moulineaux',NULL,'92130',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (122,'Essentia','23a rue Antoine Lavoisier','Aytre',NULL,'17440',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (123,'Université de La Rochelle','15 rue Flemming','La Rochelle',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (124,'MAIF','200 avenue Salvadore Allende','Niort',NULL,'79000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (125,'Studio VA','5 quai Auriol','Tonnay-Charente',NULL,'17430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (126,'NASKIGO','21 Chemin du Prieuré ',' LA ROCHELLE ',NULL,'17000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (127,'Eixa6 Informatique','5 Rue Louise Michel','Marennes',NULL,'17320',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (130,'','k','k','k','5',NULL,NULL,NULL,NULL,NULL,3,'2024-04-22 14:08:54',NULL), (131,'TEST','vvvvvvvvvvvvvvvv','dsv','vvvvvvvvvvvv','dvd',NULL,NULL,'71','dvd',NULL,3,'2024-04-22 14:22:57',555); /*!40000 ALTER TABLE `Entreprise` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Suivi_stage` -- DROP TABLE IF EXISTS `Suivi_stage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Suivi_stage` ( `idStage` int(11) NOT NULL, `idEntreprise` int(11) DEFAULT NULL, `idMaitreDeStage` int(11) DEFAULT NULL, `idEtudiant` int(11) DEFAULT NULL, `titreStage` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `stamp` datetime DEFAULT NULL, `dateFin` date DEFAULT NULL, PRIMARY KEY (`idStage`), KEY `idEntreprise` (`idEntreprise`), KEY `idMaitreDeStage` (`idMaitreDeStage`), KEY `idEtudiant` (`idEtudiant`), CONSTRAINT `Suivi_stage_ibfk_1` FOREIGN KEY (`idEntreprise`) REFERENCES `Entreprise` (`id`), CONSTRAINT `Suivi_stage_ibfk_2` FOREIGN KEY (`idMaitreDeStage`) REFERENCES `Employe` (`id`), CONSTRAINT `Suivi_stage_ibfk_3` FOREIGN KEY (`idEtudiant`) REFERENCES `User` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Suivi_stage` -- LOCK TABLES `Suivi_stage` WRITE; /*!40000 ALTER TABLE `Suivi_stage` DISABLE KEYS */; /*!40000 ALTER TABLE `Suivi_stage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `User` -- DROP TABLE IF EXISTS `User`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `User` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nom` varchar(255) NOT NULL, `prenom` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `telephone` varchar(255) DEFAULT NULL, `promo` varchar(4) DEFAULT NULL, `login` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `password_reset` tinyint(1) DEFAULT NULL, `statut` varchar(100) DEFAULT NULL, `inactif` tinyint(1) DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf16 COLLATE=utf16_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `User` -- LOCK TABLES `User` WRITE; /*!40000 ALTER TABLE `User` DISABLE KEYS */; INSERT INTO `User` VALUES (1,'Dupond','André','',NULL,'2023','test','$2y$10$XzVV.OVw3QxgcuEW9ZXGEubrF0jYfVrJV73FDMLVd1zP2lOFeOtUW',0,'Etudiant',1), (2,'prof','prof',NULL,NULL,NULL,'prof','$2y$10$Ib3pC565U/q.lb4lxsa5W.oNfVjlHpdgvHUU0HA7TgwAkffgXFQrW',0,'Professeur',0), (3,'Ornech','Jean-François','jean-francois.ornech@ac-poitiers.fr','',NULL,'jfornech','$2y$10$GVLSmMO4r25S2Uu.lpa6COtmNRdMr6.q.KgoDdVec.IIPtEi.GN.q',0,'Professeur',0), (17,'','','','','2024','','$2y$10$..BYjqV4WTrvhUvhKZwNVOBWuKl6UXsxz7IlLS4EkYKgh5e1BAepq',0,'Etudiant',0), (18,'Patrice','DENIS ARONIS','mail@mail.local','','2024','patrice','$2y$10$hR2DosUGTpgg/z4yy3X.vupNh9Rg7ri9rw3JIa8uJLzInmxLhBnLW',1,'Professeur',0), (19,'test2','test2','test2@test2','','2024','test2','$2y$10$5hyrfSoGsZq8jHWCLhUTSuUmYrQH/diwSFcPIRnCmqeGUFlqlHmz.',0,'Etudiant',1), (20,'Etudiant','etudiant de test','','','2024','sio','$2y$10$KeXbUulOY1uxBUdr.5zkDeTCDqLJHGYU8DF11Ji5PmUcBe79RI0Tq',0,'Etudiant',1), (21,'login','login',NULL,NULL,'2023','login','$2y$10$NNi/pR4j1Ne4N8MD.QFJOedZjQtNhcfPttfxHRXPLYyPGrGzBDnXu',0,'Etudiant',0), (22,'BARBIER','Loann',NULL,NULL,'2023','Loann','$2y$10$Qh16qj4e89ufgLRgzgKNpePmHAnINk0OR/SCWuQGS2nfuOd.IRjey',1,'Etudiant',0), (23,'BEAUFILS','Killian',NULL,NULL,'2023','Killian','$2y$10$W4VJ.dnjG6Mb.ZpzQwJv/.rrjJnB0OHG0sY2ff.4p/lgnSROcE43O',1,'Etudiant',0), (24,'DEGRAUW-VERRY','Axel',NULL,NULL,'2023','Axel','$2y$10$qTtT5t/gjyfaLh8I7mmXceyLZ5HS14pSdoJK1xws23GqePVzDdq/a',1,'Etudiant',0), (25,'ERNOULT','Gabin',NULL,NULL,'2023','Gabin','$2y$10$cStxPKScBkpFnm4Na/z4iOOkmtEZ/l.6AlRnapOlNEatLbNcrjpA6',1,'Etudiant',0), (26,'GAILLARD','Logan',NULL,NULL,'2023','Logan','$2y$10$qZuoB0Q0ft3VE6zNSSwy6OPx6zHuMOY8xXEHIBZm6wi6.qi5DbGCO',1,'Etudiant',0), (27,'KOSIOREK','Alexandre',NULL,NULL,'2023','Alexandre','$2y$10$Dcu9gJnHECAyaUWy.64qYugrNMxhgQgRtvJ4GRo/QvrpmDwNgnE0i',1,'Etudiant',0), (28,'LE ROCHELEUIL-CHAILLE','Alexis',NULL,NULL,'2023','Alexis','$2y$10$k2WGwT.t/rvnn.etNz3YjuZIQu4qnnwmZqPHxPcTHvdVBc/Pup44.',1,'Etudiant',0), (29,'LEFEVRE','Manon',NULL,NULL,'2023','Manon','$2y$10$TtirF7AzMSeweLV8eetfLe/Zc5jOge0/0Xyp4np/xaqHt2kHj8Gmu',1,'Etudiant',0), (30,'LESCOUZERE','Mathéo',NULL,NULL,'2023','Mathéo','$2y$10$lx1CgzdTtV8AswcBY6h.qOQjIwG1xySoc2SU615kH1iGYUZCs138K',1,'Etudiant',0), (31,'MANUKYAN','Astghik',NULL,NULL,'2023','Astghik','$2y$10$eGwWRqIlkK67L/pgHXmxS.Q2CJHt6MFLxo9FaWaNDca5ch.DqcNoa',1,'Etudiant',0), (32,'MINGOUOLO','Noah',NULL,NULL,'2023','Noah','$2y$10$zMb2ORIMzWXITcrfVyaA5.TYhzysABRianWGseZR896nLVejWNB3m',1,'Etudiant',0), (33,'MORNAC','Erwan',NULL,NULL,'2023','Erwan','$2y$10$j9FcCNc3G.L4pTAP.GpvE.krXC.idehMjvyAEbLfHUy.VBMDtv4rW',1,'Etudiant',0), (34,'RAMOS','Clement',NULL,NULL,'2023','Clement','$2y$10$lukUC3GTqkAly6V.Kr9ZReevNwkgMXhgMNsacm14VmnID6QBs1HfG',1,'Etudiant',0), (35,'ROBIN','Kyllian',NULL,NULL,'2023','Kyllian','$2y$10$mKLkFJe44UiNM6YajR0ygOkCXKYhU0GQU8qW6qJmDFqcsXKxVw.Dq',1,'Etudiant',0), (36,'ROUX','Kevin',NULL,NULL,'2023','Kevin','$2y$10$WgGW3r6Dp8liNbdq5Zur8u2nEp9jhMrJS9q8JAO5mZD46fwRYTJye',1,'Etudiant',0), (37,'SAWANÉ','Sallé',NULL,NULL,'2023','Salle','$2y$10$g1jUmHWNEM0j/nzRfT981eFsTp3PYMm5xhyUfMrfAwgfkxaD3CNKq',1,'Etudiant',0), (38,'SOUAKRI','Lounès',NULL,NULL,'2023','Lounes','$2y$10$nRBXrL96Ze4zk6hRtFfamOi6HumaPGEaes6FRShfsKEXHDG9..KE2',1,'Etudiant',0), (39,'TEXIER','Enola',NULL,NULL,'2023','Enola','$2y$10$8vqZrqVQzxHdbUgs/TpGZeoWeajzf4N39RRie.c4FPztnlqHKuOp6',1,'Etudiant',0), (40,'CASTILLO','Jean-Christophe','','','','castillojc','$2y$10$H5W2E9n/oN0m4C9ugRdbdeRUEYM.zM.DUGWMlPrIR1ID7XqI785vC',1,'Professeur',0), (41,'BOUCHEREAU','Bertrand','','','2024','bouchereaub','$2y$10$HO4yuuq58SJBqqxnGzksCuvm4FWDBR6nWc3n6ZJHyNHdDEk2tBAK6',1,'Professeur',0); /*!40000 ALTER TABLE `User` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'gestion_stage' -- -- -- Final view structure for view `Activite` -- /*!50001 DROP VIEW IF EXISTS `Activite`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_unicode_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 SQL SECURITY DEFINER */ /*!50001 VIEW `Activite` AS select `Activite_Etu`.`id` AS `IdActivite`,`User`.`id` AS `IdEtudiant`,`Entreprise`.`id` AS `IdEntreprise`,cast(`Activite_Etu`.`date` as date) AS `Date`,cast(`Activite_Etu`.`date` as time) AS `Heure`,`Activite_Etu`.`type` AS `Type`,concat(`User`.`nom`,' ',`User`.`prenom`) AS `Etudiant`,`Entreprise`.`nomEntreprise` AS `Entreprise`,`Entreprise`.`ville` AS `Ville`,`Activite_Etu`.`Commentaire` AS `Commentaire` from ((`Activite_Etu` join `User` on(`Activite_Etu`.`IdEtudiant` = `User`.`id`)) join `Entreprise` on(`Activite_Etu`.`ID_Entreprise` = `Entreprise`.`id`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-04-29 7:46:16