[Summary view] [Print] [Text view]

   1  create table {$NAMESPACE}_worker.worker_task (
   2    id int unsigned not null auto_increment primary key,
   3    taskClass varchar(255) not null,
   4    leaseOwner varchar(255),
   5    leaseExpires int unsigned,
   6    priority bigint unsigned not null,
   7    failureCount int unsigned not null,
   8    key(taskClass),
   9    key(leaseOwner),
  10    key(leaseExpires)
  11  );
  12  
  13  create table {$NAMESPACE}_worker.worker_taskdata (
  14    id int unsigned not null auto_increment primary key,
  15    taskID int unsigned not null,
  16    data longblob not null,
  17    unique key (taskID)
  18  );