• Home
• com.expediagroup
• beekeeper-scheduler-apiary
• 3.5.6
• source code
• V1_1__Create_path_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.

db.migration.V1_1__Create_path_table.sql Maven / Gradle / Ivy

USE beekeeper;

CREATE TABLE IF NOT EXISTS path (
  id BIGINT(20) AUTO_INCREMENT,
  path VARCHAR(10000) NOT NULL,
  database_name VARCHAR(512),
  table_name VARCHAR(512),
  path_status VARCHAR(50) NOT NULL,
  cleanup_delay VARCHAR(50) NOT NULL,
  creation_timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  modified_timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  cleanup_timestamp TIMESTAMP NOT NULL,
  cleanup_attempts INT NOT NULL DEFAULT 0,
  client_id VARCHAR(512),
  PRIMARY KEY (id)
);