gkarlsson.spring-boot-example.15.1.1.source-code.schema.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of spring-boot-example Show documentation

Examples on how to use db-scheduler with Spring Boot

There is a newer version: 15.1.2

-- Table definition for HSQLDB.
-- Will get executed automatically by Spring Boot if the database is of type embedded.
create table if not exists scheduled_tasks (
	task_name varchar(100),
	task_instance varchar(100),
	task_data blob,
	execution_time TIMESTAMP WITH TIME ZONE,
	picked BIT,
	picked_by varchar(50),
	last_success TIMESTAMP WITH TIME ZONE,
	last_failure TIMESTAMP WITH TIME ZONE,
	consecutive_failures INT,
	last_heartbeat TIMESTAMP WITH TIME ZONE,
	version BIGINT,
	priority INT,
	PRIMARY KEY (task_name, task_instance)
);