/*ALIAS>l_data*/

/*SQLStart>561*/
CREATE TABLE NUMKINDDOC_NOM (
    NUMKIND_ID        SMALLINT NOT NULL,
    NUMKIND_PREFIX    VARCHAR(10),
    NUMKIND_USEPREFIX CHAR(1) default "N",
    NUMKIND_ACTIVE    CHAR(1) default "T",
    NUMKIND_VALUE     INTEGER
);
/*SQLStop*/

/*SQLStart>562*/
ALTER TABLE NUMKINDDOC_NOM ADD PRIMARY KEY (NUMKIND_ID);
/*SQLStop*/

/*ManyStart>563*/
GRANT ALL ON NUMKINDDOC_NOM TO PUBLIC;
GRANT ALL ON NUMKINDDOC_NOM TO SYSCREAT WITH GRANT OPTION;
/*ManyStop*/

/*SQLStart>564*/
CREATE GENERATOR NUMKINDDOC_ID_GEN;
/*SQLStop*/

/*SQLStart>565*/
SET GENERATOR NUMKINDDOC_ID_GEN TO 0;
/*SQLStop*/

/*SQLStart>566*/
ALTER TABLE KAT_KL
ADD KAT_NUMKIND SMALLINT;
/*SQLStop*/

/*SQLStart>567*/
ALTER TABLE LCSTYPE_NOM
ADD LT_NUMKIND SMALLINT;
/*SQLStop*/

/*SQLStart>568*/
ALTER TABLE TP_KL
ADD TK_NUMKIND SMALLINT;
/*SQLStop*/
