/*ALIAS>l_data*/

/*SQLStart>780*/
CREATE TABLE OBL_KL (OBL_ID INTEGER NOT NULL, OBL_TEXT VARCHAR(100));
/*SQLStop*/

/*SQLStart>781*/
ALTER TABLE OBL_KL ADD CONSTRAINT PK_OBL_KL PRIMARY KEY (OBL_ID);
/*SQLStop*/

/*SQLStart>782*/
ALTER TABLE FIRMS ADD F_FAX VARCHAR(100);
/*SQLStop*/

/*SQLStart>783*/
ALTER TABLE FIRMS ALTER F_EMAIL TYPE VARCHAR(200);
/*SQLStop*/

/*SQLStart>784*/
ALTER TABLE FIRMS ADD F_OBL_ID INTEGER;
/*SQLStop*/

/*SQLStart>785*/
ALTER TABLE OBJECTS ADD O_OBL_ID INTEGER;
/*SQLStop*/

/*SQLStart>786*/
CREATE GENERATOR OBL_ID_GEN
/*SQLStop*/

/*SQLStart>787*/
CREATE trigger obl_kl_bi0 for obl_kl
active before insert position 0
AS
begin
  if (new.obl_id is null) then
    new.obl_id = gen_id(obl_id_gen,1);
end
/*SQLStop*/

/*SQLStart>788*/
grant all on obl_kl to public;
/*SQLStop*/

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

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