• Home
• com.qmetric
• hal-feed-consumer-mysql
• 1.7
• source code
• V1__create_initial_table.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.

hal-feed-consumer-mysql-db-migration.V1__create_initial_table.sql Maven / Gradle / Ivy

CREATE TABLE ${feed.tracker.table}
(
  id VARCHAR(128) NOT NULL,
  status VARCHAR(128) NOT NULL,
  seen_at DATETIME NOT NULL,
  consuming DATETIME,
  consumed DATETIME,
  failures_count INTEGER DEFAULT 0,
  aborted DATETIME,
  PRIMARY KEY (id)
);

CREATE INDEX ${feed.tracker.table}_status_idx ON ${feed.tracker.table} (status);
CREATE INDEX ${feed.tracker.table}_seen_idx ON ${feed.tracker.table} (seen_at);
CREATE INDEX ${feed.tracker.table}_consuming_idx ON ${feed.tracker.table} (consuming);
CREATE INDEX ${feed.tracker.table}_consumed_idx ON ${feed.tracker.table} (consumed);
CREATE INDEX ${feed.tracker.table}_aborted_idx ON ${feed.tracker.table} (aborted);