• Home
• ru.taskurotta
• recipes
• 0.8.0
• source code

×

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.

.recipes.0.8.0.source-code.create_queues.sql Maven / Gradle / Ivy

DROP TABLE qb$multiplier;
CREATE TABLE qb$multiplier (
  TASK_ID VARCHAR(36) NOT NULL ENABLE,
  STATUS_ID NUMBER NOT NULL ENABLE,
  TASK_LIST VARCHAR(54) NOT NULL ENABLE,
  DATE_START TIMESTAMP,
  INSERT_DATE TIMESTAMP,
  PRIMARY KEY (TASK_ID)
);
CREATE INDEX qb$multiplier_IND ON qb$multiplier (STATUS_ID, DATE_START);

DROP TABLE qb$number_generator;
CREATE TABLE qb$number_generator (
  TASK_ID VARCHAR(36) NOT NULL ENABLE,
  STATUS_ID NUMBER NOT NULL ENABLE,
  TASK_LIST VARCHAR(54) NOT NULL ENABLE,
  DATE_START TIMESTAMP,
  INSERT_DATE TIMESTAMP,
  PRIMARY KEY (TASK_ID)
);
CREATE INDEX qb$number_generator_IND ON qb$number_generator (STATUS_ID, DATE_START);

DROP TABLE qb$summarizer;
CREATE TABLE qb$summarizer (
  TASK_ID VARCHAR(36) NOT NULL ENABLE,
  STATUS_ID NUMBER NOT NULL ENABLE,
  TASK_LIST VARCHAR(54) NOT NULL ENABLE,
  DATE_START TIMESTAMP,
  INSERT_DATE TIMESTAMP,
  PRIMARY KEY (TASK_ID)
);
CREATE INDEX qb$summarizer_IND ON qb$summarizer (STATUS_ID, DATE_START);

DROP TABLE qb$math_action_decider;
CREATE TABLE qb$math_action_decider (
  TASK_ID VARCHAR(36) NOT NULL ENABLE,
  STATUS_ID NUMBER NOT NULL ENABLE,
  TASK_LIST VARCHAR(54) NOT NULL ENABLE,
  DATE_START TIMESTAMP,
  INSERT_DATE TIMESTAMP,
  PRIMARY KEY (TASK_ID)
);
CREATE INDEX qb$math_action_decider_IND ON qb$math_action_decider (STATUS_ID, DATE_START);