/*ALIAS>l_data*/

/*SQLStart>681*/
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='LICENSES' AND  RDB$FIELD_NAME='L_PROT');
/*SQLStop*/

/*SQLStart>682*/
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='LICENSES' AND  RDB$FIELD_NAME='L_FACTNO');
/*SQLStop*/


/*SQLStart>683*/
CREATE INDEX F_BULSTATIDX ON FIRMS (F_BULSTAT);
/*SQLStop*/

/*SQLStart>684*/
CREATE INDEX L_NOIDX ON LICENSES (L_NO);
/*SQLStop*/

/*SQLStart>685*/
CREATE INDEX CAR_REGNUMIDX ON CARS (CAR_REGNUM);
/*SQLStop*/

/*SQLStart>686*/
CREATE INDEX CAT_CERTIDX ON CATEGORIZE (CAT_CERT);
/*SQLStop*/

/*SQLStart>687*/
CREATE INDEX CAT_CERTTERMIDX ON CATEGORIZE (CAT_CERTTERM);
/*SQLStop*/

/*SQLStart>688*/
CREATE INDEX TAXI_REGNUMIDX ON TAXI (TAXI_REGNUM);
/*SQLStop*/

/*SQLStart>689*/
CREATE INDEX TP_NOMTXTIDX ON TERMPERM (TP_NOMTXT);
/*SQLStop*/

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

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