Details
-
Feature
-
Status: Resolved (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
The installer contains the new file ./db/[dbms]/sosftphistory_alter.sql and executes them.
FOR FIREBIRD USER:
Please open a firebird sql client (e.g. isql) and call:
SELECT RDB$CONSTRAINT_NAME FROM RDB$RELATION_CONSTRAINTS WHERE RDB$CONSTRAINT_TYPE='PRIMARY KEY' AND RDB$RELATION_NAME='SOSFTP_FILES_HISTORY';
Delete the primary key constraint. For this use the constraint name from above sql statement.
ALTER TABLE SOSFTP_FILES_HISTORY DROP CONSTRAINT [constraint name];
Alter the type of the column "GUID":
ALTER TABLE SOSFTP_FILES_HISTORY ALTER COLUMN "GUID" TYPE VARCHAR(40);
Add the primary key
ALTER TABLE SOSFTP_FILES_HISTORY ADD PRIMARY KEY ("GUID");