Differential D11454 Diff 27536 resources/sql/patches/005.workers.sql

Changeset View

Standalone View

	create table {$NAMESPACE}_worker.worker_task (			create table {$NAMESPACE}_worker.worker_task (
	id int unsigned not null auto_increment primary key,			id int unsigned not null auto_increment primary key,
	taskClass varchar(255) not null,			taskClass varchar(255) not null,
	leaseOwner varchar(255),			leaseOwner varchar(255),
	leaseExpires int unsigned,			leaseExpires int unsigned,
	priority bigint unsigned not null,			priority bigint unsigned not null,
	failureCount int unsigned not null,			failureCount int unsigned not null,
	key(taskClass),			key(taskClass(128)),
	key(leaseOwner),			key(leaseOwner(128)),
	key(leaseExpires)			key(leaseExpires)
	);			);

	create table {$NAMESPACE}_worker.worker_taskdata (			create table {$NAMESPACE}_worker.worker_taskdata (
	id int unsigned not null auto_increment primary key,			id int unsigned not null auto_increment primary key,
	taskID int unsigned not null,			taskID int unsigned not null,
	data longblob not null,			data longblob not null,
	unique key (taskID)			unique key (taskID)
	);			);