Index: trunk/ippToPsps/config/ippToPspsDbSchema.sql
===================================================================
--- trunk/ippToPsps/config/ippToPspsDbSchema.sql	(revision 36699)
+++ trunk/ippToPsps/config/ippToPspsDbSchema.sql	(revision 36706)
@@ -53,24 +53,4 @@
 SET character_set_client = @saved_cs_client;
 
---
--- Table structure for table `box`
---
-
-DROP TABLE IF EXISTS `box`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `box` (
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
-  `id` bigint(20) unsigned NOT NULL auto_increment,
-  `skychunk` varchar(30) default NULL,
-  `ra_center` float default NULL,
-  `dec_center` float default NULL,
-  `box_side` float default NULL,
-  `ingested` varchar(64) default 'none',
-  PRIMARY KEY  (`id`),
-  KEY `fk_skychunk` (`skychunk`),
-  CONSTRAINT `fk_skychunk` FOREIGN KEY (`skychunk`) REFERENCES `skychunk` (`name`) ON DELETE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-SET character_set_client = @saved_cs_client;
 
 --
@@ -142,4 +122,25 @@
 
 --
+-- Table structure for table `box` needs to be after skychunk or get err:150
+--
+
+DROP TABLE IF EXISTS `box`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `box` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `id` bigint(20) unsigned NOT NULL auto_increment,
+  `skychunk` varchar(30) default NULL,
+  `ra_center` float default NULL,
+  `dec_center` float default NULL,
+  `box_side` float default NULL,
+  `ingested` varchar(64) default 'none',
+  PRIMARY KEY  (`id`),
+  KEY `fk_skychunk` (`skychunk`),
+  CONSTRAINT `fk_skychunk` FOREIGN KEY (`skychunk`) REFERENCES `skychunk` (`name`) ON DELETE CASCADE
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
 -- Table structure for table `detection`
 --
@@ -169,5 +170,5 @@
   `filter` varchar(1) default NULL,
   KEY `batch_id` (`batch_id`),
-  CONSTRAINT `detection_ibfk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
+  CONSTRAINT `forcedwarpd_ibfk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
@@ -198,5 +199,5 @@
   `region` varchar(50) default NULL,
   KEY `batch_id` (`batch_id`),
-  CONSTRAINT `object_fk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`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;
@@ -247,5 +248,5 @@
   `diff_type` varchar(20) default NULL,
   KEY `batch_id` (`batch_id`),
-  CONSTRAINT `stack_ibfk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
+  CONSTRAINT `diff_ibfk_1` FOREIGN KEY (`batch_id`) REFERENCES `batch` (`batch_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;