Changeset 37233

Timestamp:

Aug 12, 2014, 2:05:06 PM (12 years ago)

Author:

eugene

Message:

pending should not have uniq on just stage_id, but stack_id+batch_type

File:

• branches/eam_branches/ipp-20140717/ippToPsps/config/ippToPspsDbSchema.sql (modified) (1 diff)

branches/eam_branches/ipp-20140717/ippToPsps/config/ippToPspsDbSchema.sql

@@ -215 +215 @@
   `stage_id` bigint(20) default NULL,
   UNIQUE KEY `a_key` (`box_id`,`stage_id`,`batch_type`),
-  UNIQUE KEY `stage_id_key` (`stage_id`),
+  UNIQUE KEY `stage_id_key` (`stage_id`,`batch_type`),
   CONSTRAINT `box_key` FOREIGN KEY (`box_id`) REFERENCES `box` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;