typo3/sysext/scheduler/ext_tables.sql

   1 #
   2 # Table structure for table 'tx_scheduler_task'
   3 #
   4 CREATE TABLE tx_scheduler_task (
   5         uid int(11) unsigned NOT NULL auto_increment,
   6         crdate int(11) unsigned DEFAULT '0' NOT NULL,
   7         disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
   8         deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
   9         description text,
  10         nextexecution int(11) unsigned DEFAULT '0' NOT NULL,
  11         lastexecution_time int(11) unsigned DEFAULT '0' NOT NULL,
  12         lastexecution_failure text,
  13         lastexecution_context char(3) DEFAULT '' NOT NULL,
  14         serialized_task_object mediumblob,
  15         serialized_executions mediumblob,
  16         task_group int(11) unsigned DEFAULT '0' NOT NULL,
  17         PRIMARY KEY (uid),
  18         KEY index_nextexecution (nextexecution)
  19 );
  20
  21 #
  22 # Table structure for table 'tx_scheduler_task_group'
  23 #
  24 CREATE TABLE tx_scheduler_task_group (
  25         groupName varchar(80) DEFAULT '' NOT NULL,
  26         description text
  27 );