Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/005.workers.sql
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) | ||||
); | ); |