• Home
• no.ssb.rawdata
• rawdata-state-provider-h2
• 0.1
• source code
• init-db.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

h2.init-db.sql Maven / Gradle / Ivy

DROP TABLE IF EXISTS completed_positions;
DROP TABLE IF EXISTS expected_positions;

CREATE TABLE expected_positions (
  id            bigint auto_increment,
  namespace     varchar                      NOT NULL,
  opaque_id     varchar                      NOT NULL,
  synthetic_id  int4                         NOT NULL,
  batch_ts      timestamp with time zone     NOT NULL,
  PRIMARY KEY (id, namespace, opaque_id, batch_ts)
);

CREATE TABLE completed_positions (
  namespace     varchar                      NOT NULL,
  opaque_id     varchar                      NOT NULL,
  PRIMARY KEY (namespace, opaque_id),
  FOREIGN KEY (namespace, opaque_id) REFERENCES expected_positions(namespace, opaque_id)
);