src/sql/db2-id-table-schema.sql

                                        
-----------------------------------------------------------------------------
-- ID_TABLE
-----------------------------------------------------------------------------
drop table ID_TABLE;


CREATE TABLE ID_TABLE
(
    ID_TABLE_ID INT GENERATED ALWAYS AS IDENTITY,
    TABLE_NAME VARCHAR (255) NOT NULL,
    NEXT_ID INT NOT NULL,
    QUANTITY INT NOT NULL,
    UNIQUE (TABLE_NAME)
);

ALTER TABLE ID_TABLE
    ADD CONSTRAINT ID_TABLE_PK 
PRIMARY KEY (ID_TABLE_ID);