1 files changed, 7 insertions, 10 deletions
diff --git a/Database/dbmain.php b/Database/dbmain.php
index 262c55a..1f1ac24 100644
--- a/Database/dbmain.php
+++ b/Database/dbmain.php
@@ -32,9 +32,7 @@ class DbMain {
         `password`        VARCHAR(128) NOT NULL,
         `tokenAutoLogin`  VARCHAR(128) NULL DEFAULT NULL,
         `inscriptionDate` TIMESTAMP NOT NULL,
-        `isClient`        TINYINT(1) NOT NULL,
-        `isPro`           TINYINT(1) NOT NULL,
-        `isAdmin`         TINYINT(1) NOT NULL,
+        `userStatus`      TINYINT(1) UNSIGNED NOT NULL,
         PRIMARY KEY (`userId`)
         )
         ENGINE = InnoDB
@@ -48,7 +46,6 @@ class DbMain {
         `adress`      VARCHAR(128) NOT NULL,
         `zipCode`     VARCHAR(6) NOT NULL,
         `city`        VARCHAR(128) NOT NULL,
-        `job`         VARCHAR(128) NULL DEFAULT NULL,
         `degree`      VARCHAR(128) NULL DEFAULT NULL,
         `capability`  TEXT NULL DEFAULT NULL,
         `description` TEXT NULL DEFAULT NULL,
@@ -83,12 +80,12 @@ class DbMain {
         CONSTRAINT `fk_userJob_userId`
             FOREIGN KEY (`userId`)
             REFERENCES  `alphajob`.`userAccount` (`userId`)
-            ON DELETE NO ACTION
+            ON DELETE CASCADE
             ON UPDATE CASCADE,
         CONSTRAINT `fk_userJob_jobCategoryId`
             FOREIGN KEY (`jobCategoryId`)
             REFERENCES  `alphajob`.`jobCategory` (`jobCategoryId`)
-            ON DELETE NO ACTION
+            ON DELETE CASCADE
             ON UPDATE CASCADE
         )
         ENGINE = InnoDB
@@ -99,7 +96,7 @@ class DbMain {
         `missionId`         INT UNSIGNED NOT NULL AUTO_INCREMENT,
         `date`              TIMESTAMP NOT NULL,
         `subject`           VARCHAR(128) NULL DEFAULT NULL,
-        `note`              INT UNSIGNED NULL DEFAULT NULL,
+        `note`              TINYINT(1) UNSIGNED NULL DEFAULT NULL,
         `review`            TEXT NULL DEFAULT NULL,
         `acceptedByPro`     TIMESTAMP NULL DEFAULT NULL,
         `validatedByClient` TIMESTAMP NULL DEFAULT NULL,
@@ -114,17 +111,17 @@ class DbMain {
         CONSTRAINT `fk_mission_clientId`
             FOREIGN KEY (`clientId`)
             REFERENCES  `alphajob`.`userAccount` (`userId`)
-            ON DELETE NO ACTION
+            ON DELETE CASCADE
             ON UPDATE CASCADE,
         CONSTRAINT `fk_mission_proId`
             FOREIGN KEY (`proId`)
             REFERENCES  `alphajob`.`userAccount` (`userId`)
-            ON DELETE NO ACTION
+            ON DELETE CASCADE
             ON UPDATE CASCADE,
         CONSTRAINT `fk_mission_jobCategoryId`
             FOREIGN KEY (`jobCategoryId`)
             REFERENCES  `alphajob`.`jobCategory` (`jobCategoryId`)
-            ON DELETE NO ACTION
+            ON DELETE CASCADE
             ON UPDATE CASCADE
         )
         ENGINE = InnoDB