SQLDict_createMessageTable.zsql 1.13 KB
Newer Older
1 2
<dtml-comment>
title:
3
connection_id:cmf_activity_sql_connection
4
max_rows:1000
5
max_cache:0
6 7 8 9 10 11
cache_time:0
class_name:
class_file:
</dtml-comment>
<params></params>
CREATE TABLE `message` (
12
  `uid` INT UNSIGNED NOT NULL,
13 14
  `date` DATETIME NOT NULL,
  `path` VARCHAR(255) NOT NULL,
15
  `active_process_uid` INT UNSIGNED NULL,
16 17 18 19 20 21 22
  `method_id` VARCHAR(255) NOT NULL,
  `processing_node` SMALLINT NOT NULL DEFAULT -1,
  `processing` TINYINT NOT NULL DEFAULT 0,
  `processing_date` DATETIME,
  `priority` TINYINT NOT NULL DEFAULT 0,
  `group_method_id` VARCHAR(255) NOT NULL DEFAULT '',
  `tag` VARCHAR(255) NOT NULL,
23
  `serialization_tag` VARCHAR(255) NOT NULL,
24
  `retry` TINYINT UNSIGNED NOT NULL DEFAULT 0,
25
  `order_validation_text` VARCHAR(255) NOT NULL,
26
  `message` LONGBLOB NOT NULL,
27 28
  PRIMARY KEY (`uid`),
  KEY (`path`),
29
  KEY (`active_process_uid`),
30
  KEY (`method_id`),
31
  KEY `processing_node_processing` (`processing_node`, `processing`),
32
  KEY `processing_node_date` (`processing_node`, `date`),
33
  KEY `serialization_tag_processing_node` (`serialization_tag`, `processing_node`),
34 35 36
  KEY (`priority`),
  KEY (`tag`),
  KEY (`order_validation_text`)
37
) TYPE = InnoDB