MSSQL

CREATE TABLE CNSSEQ (
  TOPIC VARCHAR(50) NOT NULL,
  PREFIX VARCHAR(50) NOT NULL,
  COUNTER INTEGER NOT NULL,
PRIMARY KEY(TOPIC,PREFIX,COUNTER)
);
grant all on dbo.CNSSEQ to public;

MySQL

CREATE TABLE CNSSEQ (
  TOPIC VARCHAR(50) NOT NULL,
  PREFIX VARCHAR(50) NOT NULL,
  COUNTER INTEGER NOT NULL,
PRIMARY KEY(TOPIC,PREFIX,COUNTER)
);
grant all on dbo.CNSSEQ to public;

Oracle

CREATE TABLE CNSSEQ (
  TOPIC VARCHAR(50) NOT NULL,
  PREFIX VARCHAR(50) NOT NULL,
  COUNTER INTEGER NOT NULL,
  PRIMARY KEY(TOPIC,PREFIX,COUNTER)
);
CREATE PUBLIC SYNONYM CNSSEQ FOR SYSTEM.CNSSEQ;
GRANT ALL ON CNSSEQ