[Erp5-report] r18422 - /erp5/trunk/products/CMFActivity/skins/activity/

[nobody at svn.erp5.org]

Author: vincent
Date: Wed Dec 19 16:30:39 2007
New Revision: 18422

URL: http://svn.erp5.org?rev=18422&view=rev
Log:
Remove unneeded differences sompared to SQLDict_createMessageTable:
 - uppercase type definition
 - explicit [NOT] NULL column type definition
 - shorten INT types when possible
 - remove index names
 - remove extra space
 - removed unused indexes on date and processing_date

Modified:
    erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql

Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql?rev=18422&r1=18421&r2=18422&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql Wed Dec 19 16:30:39 2007
@@ -9,22 +9,20 @@
 </dtml-comment>
 <params></params>
 CREATE TABLE `message_queue` (
-  `uid` int(11) NOT NULL,
-  `date` datetime,
-  `path` VARCHAR(255),
-  `method_id` VARCHAR(255),
-  `processing_node` INT DEFAULT -1,
-  `processing` INT DEFAULT 0,
-  `processing_date` datetime,
-  `priority` INT DEFAULT 0,
-  `tag` VARCHAR(255),
-  `message` LONGBLOB,
-  PRIMARY KEY  (`uid`),
-  KEY `date` (`date`),
-  KEY `path` (`path`),
-  KEY `method_id` (`method_id`),
+  `uid` INT UNSIGNED NOT NULL,
+  `date` DATETIME NOT NULL,
+  `path` VARCHAR(255) NOT NULL,
+  `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,
+  `tag` VARCHAR(255) NOT NULL,
+  `message` LONGBLOB NOT NULL,
+  PRIMARY KEY (`uid`),
+  KEY (`path`),
+  KEY (`method_id`),
   KEY `processing_node_processing` (`processing_node`, `processing`),
-  KEY `processing_date` (`processing_date`),
-  KEY `priority` (`priority`),
-  KEY `tag` (`tag`)
+  KEY (`priority`),
+  KEY (`tag`)
 ) TYPE = InnoDB;