/*ALIAS>l_data*/

/*SQLStart>593*/
alter table objectregister
    add OR_KIND integer;
/*SQLStop*/

/*SQLStart>594*/
CREATE TABLE NOTICETYPE (
    NOTICETYPE_ID INTEGER NOT NULL PRIMARY KEY,
    NOTICETYPE_TEXT VARCHAR(240),
    NOTICETYPE_NUMKIND INTEGER);
/*SQLStop*/

/*SQLStart>595*/
GRANT ALL ON NOTICETYPE TO PUBLIC;
/*SQLStop*/

/*SQLStart>596*/
delete from SYSTEM_STRINGS where sys_id=0;
/*SQLStop*/

/*SQLStart>597*/
insert into SYSTEM_STRINGS (sys_id,sys_str) values (0,'0001');
/*SQLStop*/
