Changeset 37820 for branches/eam_branches/ipp-pv3-20140717-merge/ippToPsps/config/ippToPspsDbSchema.sql

Timestamp:

Jan 12, 2015, 12:24:24 PM (12 years ago)

Author:

eugene

Message:

various updates merged from trunk

File:

• branches/eam_branches/ipp-pv3-20140717-merge/ippToPsps/config/ippToPspsDbSchema.sql (modified) (3 diffs)

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

@@ -1 +1 @@
 -- MySQL dump 10.11
 --
--- Host: ippdb01    Database: ipptopsps
+-- Host: ipp06    Database: ipptopsps
 -- ------------------------------------------------------
 -- Server version       5.0.77-log
@@ -189 +189 @@
 SET character_set_client = @saved_cs_client;
 --
+-- Table structure for table `forcedobject`
+--
+
+DROP TABLE IF EXISTS `forcedobject`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `forcedobject` (
+  `batch_id` bigint(20) unsigned NOT NULL,
+  `region` varchar(50) default NULL,
+  KEY `batch_id` (`batch_id`),
+  CONSTRAINT `diffobject_fk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
 -- Table structure for table `diffobject`
 --
@@ -215 +230 @@
   `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;