• Home
• org.sakaiproject.scheduler
• scheduler-component-shared
• 11.2
• source code
• delayed.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.

mysql.delayed.sql Maven / Gradle / Ivy

-- SQL for delayed invokation.
-- This has been moved out of the main quartz file so it's easier to upgrade the quartz file and
-- see what has changed between releases.

CREATE TABLE SCHEDULER_DELAYED_INVOCATION (
INVOCATION_ID VARCHAR(36) NOT NULL,
INVOCATION_TIME DATETIME NOT NULL,
COMPONENT VARCHAR(2000) NOT NULL,
CONTEXT VARCHAR(2000) NULL,
PRIMARY KEY (INVOCATION_ID)
);

CREATE INDEX SCHEDULER_DI_TIME_INDEX ON SCHEDULER_DELAYED_INVOCATION (INVOCATION_TIME);