YADE Background Service should store the information on file transfers with files exceeding 2GB

Current Situation

• The YADE Background Service stores the file size of the transferred file in the field "FILE_SIZE" of the database table SOSFTP_FILES.
• This field has the datatype INT, Number(10) or NUMERIC(10) resp. depending on the DBMS in use.
• If the the file size exceeds 2GB then an INT field is too small.

Workaround

• Change the data type of the FILE_SIZE field in table SOSFTP_FILES to BIGINT, NUMBER(19) or NUMERIC(19) resp. to support file transfers with files exceding 2GB.
• Example for MySQL:

   ALTER TABLE SOSFTP_FILES MODIFY "FILE_SIZE"  BIGINT  DEFAULT 0 NOT NULL;
  

• Example for Oracle:

   ALTER TABLE SOSFTP_FILES MODIFY "FILE_SIZE"  NUMBER(19) DEFAULT 0 NOT NULL;
  

• Example for PostgreSQL:

   ALTER TABLE SOSFTP_FILES MODIFY ALTER COLUMN "FILE_SIZE"  NUMERIC(19) DEFAULT 0 NOT NULL;
  

Desired Behavior

• The above mentioned workarounds are applied by the YADE setup respectively for all supported DBMS.