Changeset 33593

Timestamp:

Mar 22, 2012, 2:26:03 PM (14 years ago)

Author:

rhenders

Message:

added CASCADE DELETE to box table FK constraint

File:

• trunk/ippToPsps/config/ippToPspsDbSchema.sql (modified) (4 diffs)

trunk/ippToPsps/config/ippToPspsDbSchema.sql

@@ -45 +45 @@
   `purged` tinyint(4) NOT NULL default '0',
   PRIMARY KEY  (`batch_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=317094 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=326479 DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
 
@@ -63 +63 @@
   `box_side` float default NULL,
   PRIMARY KEY  (`id`),
-  KEY `config` (`config`),
-  CONSTRAINT `box_ibfk_1` FOREIGN KEY (`config`) REFERENCES `config` (`name`)
-) ENGINE=InnoDB AUTO_INCREMENT=3359 DEFAULT CHARSET=latin1;
+  KEY `fk_config` (`config`),
+  CONSTRAINT `fk_config` FOREIGN KEY (`config`) REFERENCES `config` (`name`) ON DELETE CASCADE
+) ENGINE=InnoDB AUTO_INCREMENT=25457 DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
 
@@ -87 +87 @@
   PRIMARY KEY  (`id`),
   UNIQUE KEY `unique_key` (`host`,`pid`)
-) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=961 DEFAULT CHARSET=latin1;
 SET character_set_client = @saved_cs_client;
 
@@ -199 +199 @@
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2012-03-06  6:00:32
+-- Dump completed on 2012-03-22  7:59:34