Sync table schema on Firebird 2.5 do nothing

[zhartoma]

Firebird 2.5 has no BOOLEAN data type.
To fix sync schema I replaced
"CASE WHEN rf.RDB$NULL_FLAG = 1 THEN FALSE ELSE TRUE END AS nullable, "
with
"CASE WHEN rf.RDB$NULL_FLAG = 1 THEN 0 ELSE 1 END AS nullable, "
and
"EXISTS (SELECT 1 FROM RDB$RELATION_CONSTRAINTS rc " "JOIN RDB$INDEX_SEGMENTS idx ON rc.RDB$INDEX_NAME = idx.RDB$INDEX_NAME " "WHERE rc.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY' " "AND rc.RDB$RELATION_NAME = rf.RDB$RELATION_NAME " "AND idx.RDB$FIELD_NAME = rf.RDB$FIELD_NAME) AS pk "
with
"IIF(EXISTS (SELECT 1 FROM RDB$RELATION_CONSTRAINTS rc " "JOIN RDB$INDEX_SEGMENTS idx ON rc.RDB$INDEX_NAME = idx.RDB$INDEX_NAME " "WHERE rc.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY' " "AND rc.RDB$RELATION_NAME = rf.RDB$RELATION_NAME " "AND idx.RDB$FIELD_NAME = rf.RDB$FIELD_NAME), 1, 0) AS pk "

[andrevanzuydam]

Thank you for your code example consider doing a pull request for this. I will also check and apply the fix.