Résolution bug regex vérification email en JsHEADmaster

Résolution bug si char non présent dans cookie autologin
Optimisation de quelques éléments
Réorganisation légère des documents tiers
Ajout .htaccess pour interdire le listage des dossiers

4 files changed, 0 insertions, 143 deletions

diff --git a/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb b/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb
deleted file mode 100644
index 3a7249d..0000000
--- a/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb
+++ /dev/null
diff --git a/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb.bak b/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb.bak
deleted file mode 100644
index 570f173..0000000
--- a/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb.bak
+++ /dev/null
diff --git a/Documents_et_infos/Bdd_mysql/mysql_alphajob.png b/Documents_et_infos/Bdd_mysql/mysql_alphajob.png
deleted file mode 100644
index a9b8e1c..0000000
--- a/Documents_et_infos/Bdd_mysql/mysql_alphajob.png
+++ /dev/null
diff --git a/Documents_et_infos/Bdd_mysql/mysql_alphajob.sql b/Documents_et_infos/Bdd_mysql/mysql_alphajob.sql
deleted file mode 100644
index 1189648..0000000
--- a/Documents_et_infos/Bdd_mysql/mysql_alphajob.sql
+++ /dev/null
@@ -1,143 +0,0 @@
--- MySQL Script generated by MySQL Workbench
--- Sun Mar 13 12:15:01 2022
--- Model: New Model    Version: 1.0
--- MySQL Workbench Forward Engineering
-
-SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
-SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
-SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
-
--- -----------------------------------------------------
--- Schema exophp
--- -----------------------------------------------------
-
--- -----------------------------------------------------
--- Schema exophp
--- -----------------------------------------------------
-CREATE SCHEMA IF NOT EXISTS `exophp` DEFAULT CHARACTER SET utf8 ;
-USE `exophp` ;
-
--- -----------------------------------------------------
--- Table `exophp`.`userAccount`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `exophp`.`userAccount` (
-  `userId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
-  `email` VARCHAR(128) NOT NULL,
-  `password` VARCHAR(128) NOT NULL,
-  `tokenAutoLogin` VARCHAR(128) NULL DEFAULT NULL,
-  `inscriptionDate` TIMESTAMP NOT NULL,
-  `isClient` TINYINT(1) UNSIGNED NOT NULL,
-  `isPro` TINYINT(1) UNSIGNED NOT NULL,
-  `isAdmin` TINYINT(1) UNSIGNED NOT NULL,
-  PRIMARY KEY (`userId`))
-ENGINE = InnoDB
-DEFAULT CHARACTER SET = utf8;
-
-
--- -----------------------------------------------------
--- Table `exophp`.`jobCategrory`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `exophp`.`jobCategrory` (
-  `jobCategoryId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
-  `jobCategoryNameEn` VARCHAR(128) NOT NULL,
-  `jobCategoryNameFr` VARCHAR(128) NOT NULL,
-  PRIMARY KEY (`jobCategoryId`))
-ENGINE = InnoDB;
-
-
--- -----------------------------------------------------
--- Table `exophp`.`mission`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `exophp`.`mission` (
-  `missionId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
-  `date` TIMESTAMP NOT NULL,
-  `subject` VARCHAR(128) NOT NULL,
-  `note` TINYINT(1) UNSIGNED NULL DEFAULT NULL,
-  `review` TEXT NULL DEFAULT NULL,
-  `acceptedByPro` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
-  `validatedByClient` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
-  `validatedByPro` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
-  `clientId` INT UNSIGNED NOT NULL,
-  `proId` INT UNSIGNED NOT NULL,
-  `jobCategroryId` INT UNSIGNED NOT NULL,
-  PRIMARY KEY (`missionId`),
-  INDEX `fk_mission_clientId_idx` (`clientId` ASC) VISIBLE,
-  INDEX `fk_mission_proId_idx` (`proId` ASC) VISIBLE,
-  INDEX `fk_mission_jobCategroryId_idx` (`jobCategroryId` ASC) VISIBLE,
-  CONSTRAINT `fk_mission_userId`
-    FOREIGN KEY (`clientId`)
-    REFERENCES `exophp`.`userAccount` (`userId`)
-    ON DELETE NO ACTION
-    ON UPDATE NO ACTION,
-  CONSTRAINT `fk_mission_consultantId`
-    FOREIGN KEY (`proId`)
-    REFERENCES `exophp`.`userAccount` (`userId`)
-    ON DELETE NO ACTION
-    ON UPDATE NO ACTION,
-  CONSTRAINT `fk_mission_jobcategrory1`
-    FOREIGN KEY (`jobCategroryId`)
-    REFERENCES `exophp`.`jobCategrory` (`jobCategoryId`)
-    ON DELETE NO ACTION
-    ON UPDATE NO ACTION)
-ENGINE = InnoDB
-DEFAULT CHARACTER SET = utf8;
-
-
--- -----------------------------------------------------
--- Table `exophp`.`userInfo`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `exophp`.`userInfo` (
-  `lastName` VARCHAR(128) NOT NULL,
-  `firstName` VARCHAR(128) NOT NULL,
-  `phoneNumber` VARCHAR(10) NOT NULL,
-  `adress` VARCHAR(128) NOT NULL,
-  `zipCode` VARCHAR(6) NOT NULL,
-  `city` VARCHAR(128) NOT NULL,
-  `degree` VARCHAR(128) NULL DEFAULT NULL,
-  `capability` TEXT NULL DEFAULT NULL,
-  `description` TEXT NULL DEFAULT NULL,
-  `userId` INT UNSIGNED NOT NULL,
-  PRIMARY KEY (`userId`),
-  INDEX `fk_userinfo_userId_idx` (`userId` ASC) VISIBLE,
-  CONSTRAINT `fk_userinfo_userId`
-    FOREIGN KEY (`userId`)
-    REFERENCES `exophp`.`userAccount` (`userId`)
-    ON DELETE CASCADE
-    ON UPDATE CASCADE)
-ENGINE = InnoDB
-DEFAULT CHARACTER SET = utf8;
-
-
--- -----------------------------------------------------
--- Table `exophp`.`category`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `exophp`.`category` (
-  `category_id` INT NOT NULL,
-  `name` VARCHAR(255) NOT NULL,
-  PRIMARY KEY (`category_id`));
-
-
--- -----------------------------------------------------
--- Table `exophp`.`userJob`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `exophp`.`userJob` (
-  `jobCategroryId` INT UNSIGNED NOT NULL,
-  `userId` INT UNSIGNED NOT NULL,
-  INDEX `fk_userJob_jobcategrory1_idx` (`jobCategroryId` ASC) VISIBLE,
-  INDEX `fk_userJob_userinfo1_idx` (`userId` ASC) VISIBLE,
-  CONSTRAINT `fk_userJob_jobCategroryId`
-    FOREIGN KEY (`jobCategroryId`)
-    REFERENCES `exophp`.`jobCategrory` (`jobCategoryId`)
-    ON DELETE NO ACTION
-    ON UPDATE NO ACTION,
-  CONSTRAINT `fk_userJob_userId`
-    FOREIGN KEY (`userId`)
-    REFERENCES `exophp`.`userInfo` (`userId`)
-    ON DELETE NO ACTION
-    ON UPDATE NO ACTION)
-ENGINE = InnoDB;
-
-
-SET SQL_MODE=@OLD_SQL_MODE;
-SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
-SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;