VBE 5.x: How to create NS tables manually with SQL?

Problem:

• Product Name: VisiBroker
• Product Version: 5.x and above
• Product Component: Naming Service
• Platform/OS Version: All
• JDK/Compiler Version: N/A

How to create Naming Service database tables manually with SQL?

Resolution:

Below is the details of the database schema used in a VisiNaming with name "NAMEMASTER" for Oracle Database:

CREATE VBINS_NAMEMASTER_CTX_TBL
(
  CTX_INDEX INTEGER,
  CTX_TYPE INTEGER
);


CREATE VBINS_NAMEMASTER_GRAPH_TBL
(
  PARENT_CTX_INDEX INTEGER,
  NAME_ID VARCHAR(255),
  NAME_KIND VARCHAR(255),
  C_TYPE INTEGER,
  REFERENCE LONG
);

CREATE VBINS_NAMEMASTER_META_TBL
(
  C_TYPE VARCHAR(255),
  INDEX_VALUE INTEGER
);


CREATE VBINS_NAMEMASTER_CLUSTER_TBL
(
  CLUSTER_INDEX INTEGER,
  CRITERION_TYPE INTEGER
);


insert into VBINS_NAMEMASTER_META_TBL values ("CTX_INDEX", 0);

insert into VBINS_NAMEMASTER_META_TBL values ("SCHEMA_VERSION",2);

insert into VBINS_NAMEMASTER_CTX_TBL values (2, 2);

Support Case: 579424