db.migration.V3.3__Create_table_node.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jabit-repositories Show documentation

A Java implementation of the Bitmessage protocol. This contains JDBC implementations of the repositories.

There is a newer version: 2.0.4

CREATE TABLE Node (
  stream   BIGINT     NOT NULL,
  address  BINARY(32) NOT NULL,
  port     INT        NOT NULL,
  services BIGINT     NOT NULL,
  time     BIGINT     NOT NULL,
  PRIMARY KEY (stream, address, port)
);
CREATE INDEX idx_time on Node(time);