Feature #11555: Integrated extension "gabriel" into TYPO3 Core as sysext "scheduler"
[Packages/TYPO3.CMS.git] / 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 DEFAULT '0' NOT NULL auto_increment,
6 crdate int(11) unsigned DEFAULT '0' NOT NULL,
7 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
8 classname varchar(255) DEFAULT '' NOT NULL,
9 nextexecution int(11) unsigned DEFAULT '0' NOT NULL,
10 lastexecution_time int(11) unsigned DEFAULT '0' NOT NULL,
11 lastexecution_failure text NOT NULL,
12 lastexecution_context char(3) DEFAULT '' NOT NULL,
13 serialized_task_object text NOT NULL,
14 serialized_executions text NOT NULL,
15 PRIMARY KEY (uid),
16 KEY index_nextexecution (nextexecution)
17 );