/*ALIAS>l_data*/

/*SQLStart>523*/
ALTER TABLE FIRMS
ADD F_MANAGERADDRESS VARCHAR(240),
DROP F_RSDDATA;
/*SQLStop*/

/*SQLStart>524*/
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_ADDR_PLACE');
/*SQLStop*/

/*SQLStart>525*/
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_COMMENT');
/*SQLStop*/

/*SQLStart>526*/
ALTER TABLE FIRMS
ADD F_RSDDATA date;
/*SQLStop*/

/*SQLStart>527*/
ALTER TABLE LICENSES
ADD L_DTBREAKREASON VARCHAR(240);
/*SQLStop*/

/*SQLStart>528*/
alter table termperm
add TP_REJECTED char(1) default "F",
add TP_REJECTEDREASON VARCHAR(240);
/*SQLStop*/

/*SQLStart>529*/
update termperm set tp_rejected="F";
/*SQLStop*/
