• Home
• org.tuxdevelop
• spring-batch-lightmin-core
• 0.2.0
• source code
• schema_sybase.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.

org.tuxdevelop.spring.batch.lightmin.schema_sybase.sql Maven / Gradle / Ivy

CREATE TABLE BATCH_JOB_CONFIGURATION (
  job_configuration_id NUMERIC IDENTITY PRIMARY KEY NOT NULL,
  job_name             UNIVARCHAR(255),
  job_incrementer      UNIVARCHAR(255)
)
go

CREATE TABLE BATCH_JOB_SCHEDULER_CONFIGURATION (
  id                   NUMERIC IDENTITY PRIMARY KEY NOT NULL,
  job_configuration_id NUMERIC                      NOT NULL,
  scheduler_type       INT                          NOT NULL,
  cron_expression      UNIVARCHAR(255)              NULL,
  initial_delay        NUMERIC                      NULL,
  fixed_delay          NUMERIC                      NULL,
  task_executor_type   INT                          NOT NULL,
  bean_name            UNIVARCHAR(255)              NOT NULL,
  status               UNIVARCHAR(255)              NOT NULL,
  FOREIGN KEY (job_configuration_id) REFERENCES BATCH_JOB_CONFIGURATION(job_configuration_id)
)
go

CREATE TABLE BATCH_JOB_CONFIGURATION_PARAMETERS (
  id                   NUMERIC IDENTITY PRIMARY KEY NOT NULL,
  job_configuration_id NUMERIC                      NOT NULL,
  parameter_name       UNIVARCHAR(255)              NOT NULL,
  parameter_value      UNIVARCHAR(255)              NOT NULL,
  parameter_type       INT                          NOT NULL,
  FOREIGN KEY (job_configuration_id) REFERENCES BATCH_JOB_CONFIGURATION(job_configuration_id)
)
go