Revize 54cb07ac

Re #7526 Change data type of sick days count

server/init.sql

@@ -37 +37 @@
   first_name VARCHAR(45) NOT NULL,
   last_name VARCHAR(45) NOT NULL,
   no_vacations FLOAT,
-  no_sick_days SMALLINT,
+  no_sick_days INT,
   alert DATETIME,
   token TEXT NOT NULL,
   email VARCHAR(45) NOT NULL,
@@ -55 +55 @@
     REFERENCES approval_status (id)
     ON DELETE NO ACTION ON UPDATE CASCADE,
   CONSTRAINT check_no_vacation CHECK (no_vacations >= 0),
-  CONSTRAINT check_no_sick_days CHECK (no_sick_days >= 0),
-  CONSTRAINT check_email CHECK (email = '%_@__%.__%')
+  CONSTRAINT check_no_sick_days CHECK (no_sick_days >= 0)
 );
 
 -- -----------------------------------------------------
@@ -75 +74 @@
   PRIMARY KEY (id),
   INDEX fk_vacation_day_approval_status (status_id ASC),
   INDEX fk_vacation_day_end_user (user_id ASC),
+  INDEX fk_vacation_day_vacation_type (type_id ASC),
   CONSTRAINT fk_vacation_day_approval_status FOREIGN KEY (status_id)
     REFERENCES approval_status (id)
     ON DELETE NO ACTION ON UPDATE CASCADE,
   CONSTRAINT fk_vacation_day_end_user FOREIGN KEY (user_id)
     REFERENCES end_user (id)
     ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT fk_vacation_day_vacation_type FOREIGN KEY (type_id)
+    REFERENCES vacation_type (id)
+    ON DELETE CASCADE ON UPDATE CASCADE,
   CONSTRAINT check_time CHECK (time_from < time_to)
 );
 
@@ -90 +93 @@
 DROP TABLE IF EXISTS default_settings;
 CREATE TABLE default_settings (
   id BIGINT NOT NULL AUTO_INCREMENT,
-  no_sick_days SMALLINT NOT NULL,
+  no_sick_days INT NOT NULL,
   alert DATETIME NOT NULL,
   creation_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (id),