github.com/kaleido-io/firefly@v0.0.0-20210622132723-8b4b6aacb971/db/migrations/postgres/000009_create_namespaces_table.up.sql (about)

     1  BEGIN;
     2  CREATE TABLE namespaces (
     3    seq         SERIAL          PRIMARY KEY,
     4    id          UUID            NOT NULL,
     5    message_id  UUID,
     6    name        VARCHAR(64)     NOT NULL,
     7    ntype       VARCHAR(64)     NOT NULL,
     8    description VARCHAR(4096),
     9    created     BIGINT          NOT NULL
    10  );
    11  
    12  CREATE UNIQUE INDEX namespaces_id ON operations(id);
    13  CREATE UNIQUE INDEX namespaces_name ON namespaces(name);
    14  
    15  COMMIT;