/*ALIAS>l_data*/

/*SQLStart>645*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=50, RDB$CHARACTER_LENGTH=50
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='CATEGORIZE' AND  RDB$FIELD_NAME='CAT_CERT');
/*SQLStop*/

/*SQLStart>646*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=50, RDB$CHARACTER_LENGTH=50
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='CATEGORIZE' AND  RDB$FIELD_NAME='CAT_CERTTERM');
/*SQLStop*/

/*SQLStart>647*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=50, RDB$CHARACTER_LENGTH=50
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='CATEGORIZE' AND  RDB$FIELD_NAME='CAT_CAPACITY');
/*SQLStop*/

/*SQLStart>648*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=50, RDB$CHARACTER_LENGTH=50
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='CATEGORIZE' AND  RDB$FIELD_NAME='CAT_PROTOCOL');
/*SQLStop*/

/*SQLStart>649*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=50, RDB$CHARACTER_LENGTH=50
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='CATEGORIZE' AND  RDB$FIELD_NAME='CAT_ORDER');
/*SQLStop*/

/*SQLStart>650*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=50, RDB$CHARACTER_LENGTH=50,
  RDB$CHARACTER_SET_ID = 52,RDB$FIELD_TYPE = 37,RDB$COLLATION_ID = 0
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='CATEGORIZE' AND  RDB$FIELD_NAME='CAT_CAPACITYINSIDE');
/*SQLStop*/

/*SQLStart>651*/
UPDATE RDB$FIELDS SET RDB$FIELD_LENGTH=50, RDB$CHARACTER_LENGTH=50,
  RDB$CHARACTER_SET_ID = 52,RDB$FIELD_TYPE = 37,RDB$COLLATION_ID = 0
  WHERE RDB$FIELD_NAME=(SELECT RDB$FIELD_SOURCE FROM RDB$RELATION_FIELDS
  WHERE RDB$RELATION_NAME='CATEGORIZE' AND  RDB$FIELD_NAME='CAT_CAPACITYOUTSIDE');
/*SQLStop*/

/*SQLStart>652*/
delete from system_strings where SYS_ID = 0;
/*SQLStop*/

/*SQLStart>653*/
insert into system_strings (SYS_ID,SYS_STR) values (0,'0006');
/*SQLStop*/