Changeset 38052 for branches/eam_branches/ipp-20150112/ippToPsps/config/ippToPspsDbSchema.sql

Timestamp:

Mar 28, 2015, 8:28:32 PM (11 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/eam_branches/ipp-20150112/ippToPsps/config/ippToPspsDbSchema.sql (modified) (2 diffs)

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

@@ -199 +199 @@
   `region` varchar(50) default NULL,
   KEY `batch_id` (`batch_id`),
+  CONSTRAINT `forcedobject_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`
+--
+
+DROP TABLE IF EXISTS `diffobject`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `diffobject` (
+  `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;
@@ -204 +219 @@
 
 --
--- Table structure for table `diffobject`
---
-
-DROP TABLE IF EXISTS `diffobject`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `diffobject` (
-  `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 `pending`
 --
+-- i had to do this to get uniqueness prob sorted out:
+
+--show index from pending;
+--alter table pending drop index `name`;
+--where name was broken becaue it only indedxed stage idg
 
 DROP TABLE IF EXISTS `pending`;