--insert status types
INSERT INTO STATUS_TYPES (ID, NAME, DESCRIPTION, CODE)
VALUES (202311090630000001,'NRDB Message Type','Status type for nrdb message types','NRDB_MESSAGE_TYPE');

--insert status
INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (0, 202311090630000001, 1, 'UNHANDLED', 'Unhandled', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (1, 202311090630000001, 1, 'HANDLED', 'Handled', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (2, 202311090630000001, 1, 'ERROR', 'Error', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (3, 202311090630000001, 1, 'REMOVED', 'Removed', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (4, 202311090630000001, 1, 'OUTPORT', 'Outport', NULL);

INSERT INTO STATUS (ID, TYPE_ID, ACTIVE, STAT, DESCRIPTION, PARENT_ID)
VALUES (9, 202311090630000001, 1, 'RETRY_ERROR', 'Retry error', NULL);