[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_worker.worker_archivetask (
   2    id INT UNSIGNED PRIMARY KEY,
   3    taskClass VARCHAR(255) NOT NULL COLLATE utf8_bin,
   4    leaseOwner VARCHAR(255) COLLATE utf8_bin,
   5    leaseExpires INT UNSIGNED,
   6    failureCount INT UNSIGNED NOT NULL,
   7    dataID INT UNSIGNED NOT NULL,
   8    result INT UNSIGNED NOT NULL,
   9    duration BIGINT UNSIGNED NOT NULL,
  10    dateCreated INT UNSIGNED NOT NULL,
  11    dateModified INT UNSIGNED NOT NULL,
  12    key(dateCreated)
  13  ) ENGINE=InnoDB, COLLATE utf8_general_ci;