diff options
Diffstat (limited to 'Database/dbmain.php')
| -rw-r--r-- | Database/dbmain.php | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/Database/dbmain.php b/Database/dbmain.php index 532bb7c..262c55a 100644 --- a/Database/dbmain.php +++ b/Database/dbmain.php @@ -12,6 +12,8 @@ // final: ne peut etre ré-écris (overload) class DbMain { + // Pour gérer si "en production" + private $debug = True; // Salt pour chiffrement private $salt = "cTKXHBoN3oxymlhNem2h"; // Configuration du serveur MYSQL / MARIADB @@ -19,10 +21,9 @@ class DbMain { private $host = "127.0.0.1"; private $user = "root"; private $pass = ""; - private $debug = True; - // Déclaration des tables private $database = "alphajob"; + // Déclaration des tables // Timestamp auto si non renseigné // UserAccount, infos du compte nécessaire à la connection private $createTableUserAccount = "CREATE TABLE IF NOT EXISTS `alphajob`.`userAccount` ( @@ -65,8 +66,9 @@ class DbMain { // Liste des categories d'emploie possible private $createTableJobCategory = "CREATE TABLE IF NOT EXISTS `alphajob`.`jobCategory` ( - `jobCategoryId` INT UNSIGNED NOT NULL, - `categoryName` VARCHAR(128) NOT NULL, + `jobCategoryId` INT UNSIGNED NOT NULL AUTO_INCREMENT, + `jobCategoryNameEn` VARCHAR(128) NOT NULL, + `jobCategoryNameFr` VARCHAR(128) NOT NULL, PRIMARY KEY (`jobCategoryId`) ) ENGINE = InnoDB |