[TASK] Allow multiple extractor services with the same priority
[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 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 );