/*ALIAS>l_data*/

/*SQLStart>0*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=240, RDB$CHARACTER_LENGTH=240
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='FIRMS' AND  RDB$FIELD_NAME='F_NAME');
/*SQLStop*/

/*SQLStart>0*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=240, RDB$CHARACTER_LENGTH=240
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='FIRMS' AND  RDB$FIELD_NAME='F_CLEARNAME');
/*SQLStop*/

/*SQLStart>532*/
alter table objects
  add o_deputyid integer;
/*SQLStop>*/

/*DLLStart>533*/
DLLName=upd009.dll
DLLProc=fixdeputy
/*DLLStop>*/

/*SQLStart>0*/
alter table objectregister
  drop or_deputy,
  drop or_deputyphone;
/*SQLStop*/