From be364bb579f60ce87f43bb8421f81dc6312be23e Mon Sep 17 00:00:00 2001 From: Debulois Date: Wed, 13 Jul 2022 13:13:45 +0200 Subject: Résolution bug regex vérification email en Js 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 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb | Bin 13477 -> 0 bytes .../Bdd_mysql/mysql_alphajob.mwb.bak | Bin 13489 -> 0 bytes Documents_et_infos/Bdd_mysql/mysql_alphajob.png | Bin 47039 -> 0 bytes Documents_et_infos/Bdd_mysql/mysql_alphajob.sql | 143 --------------------- 4 files changed, 143 deletions(-) delete mode 100644 Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb delete mode 100644 Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb.bak delete mode 100644 Documents_et_infos/Bdd_mysql/mysql_alphajob.png delete mode 100644 Documents_et_infos/Bdd_mysql/mysql_alphajob.sql (limited to 'Documents_et_infos/Bdd_mysql') 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 Binary files a/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb and /dev/null differ 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 Binary files a/Documents_et_infos/Bdd_mysql/mysql_alphajob.mwb.bak and /dev/null differ 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 Binary files a/Documents_et_infos/Bdd_mysql/mysql_alphajob.png and /dev/null differ 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; -- cgit v1.2.3