sql file should work fine on import now (exported via phpmyadmin, which puts constraints at the end)

git-svn-id: http://anope.svn.sourceforge.net/svnroot/anope/trunk@2937 5417fbe8-f217-4b02-8779-1006273d7864

1 files changed, 136 insertions, 100 deletions

diff --git a/data/tables.sql b/data/tables.sql
index 92e44a8a1..b4bee54c4 100644
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -1,31 +1,29 @@
---
--- mysqldump --skip-opt --compact --comments --add-drop-table --create-options --disable-keys --no-data  --routines -u anope -panope anope > tables.sql
---
+-- $Id$
 
+-- If you need to create your db, uncomment the following lines.
+-- 
+-- CREATE DATABASE anope;
+-- USE anope;
 
 --
 -- Table structure for table `anope_bs_badwords`
 --
 
 DROP TABLE IF EXISTS `anope_bs_badwords`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_bs_badwords` (
   `channel` varchar(255) NOT NULL DEFAULT '',
   `word` varchar(255) NOT NULL,
   `type` varchar(50) NOT NULL,
-  UNIQUE KEY `channel` (`channel`,`word`),
-  CONSTRAINT `anope_bs_badwords_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `channel` (`channel`,`word`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_bs_core`
 --
 
 DROP TABLE IF EXISTS `anope_bs_core`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_bs_core` (
   `nick` varchar(255) NOT NULL DEFAULT '',
   `user` varchar(255) NOT NULL DEFAULT '',
@@ -36,63 +34,57 @@ CREATE TABLE `anope_bs_core` (
   `chancount` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`nick`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_bs_info_metadata`
 --
 
 DROP TABLE IF EXISTS `anope_bs_info_metadata`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_bs_info_metadata` (
   `botname` varchar(255) NOT NULL DEFAULT '',
   `name` varchar(255) NOT NULL DEFAULT '',
   `value` text NOT NULL,
-  UNIQUE KEY `botname` (`botname`,`name`),
-  CONSTRAINT `anope_bs_info_metadata_ibfk_1` FOREIGN KEY (`botname`) REFERENCES `anope_bs_core` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `botname` (`botname`,`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_commands`
 --
 
 DROP TABLE IF EXISTS `anope_commands`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_commands` (
   `nick` varchar(255) NOT NULL DEFAULT '',
   `service` varchar(255) NOT NULL DEFAULT '',
   `command` text NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_cs_access`
 --
 
 DROP TABLE IF EXISTS `anope_cs_access`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_cs_access` (
   `level` int(11) NOT NULL DEFAULT '0',
   `display` varchar(255) NOT NULL DEFAULT '',
   `channel` varchar(255) NOT NULL DEFAULT '',
   `last_seen` int(11) NOT NULL DEFAULT '0',
   `creator` varchar(255) NOT NULL DEFAULT '',
-  UNIQUE KEY `channel` (`channel`,`display`),
-  CONSTRAINT `anope_cs_access_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `channel` (`channel`,`display`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_cs_akick`
 --
 
 DROP TABLE IF EXISTS `anope_cs_akick`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_cs_akick` (
   `channel` varchar(255) NOT NULL DEFAULT '',
   `flags` varchar(255) NOT NULL DEFAULT '',
@@ -101,18 +93,16 @@ CREATE TABLE `anope_cs_akick` (
   `creator` varchar(255) NOT NULL DEFAULT '',
   `created` int(11) NOT NULL DEFAULT '0',
   `last_used` int(11) NOT NULL DEFAULT '0',
-  UNIQUE KEY `channel` (`channel`,`mask`),
-  CONSTRAINT `anope_cs_akick_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `channel` (`channel`,`mask`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_cs_info`
 --
 
 DROP TABLE IF EXISTS `anope_cs_info`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_cs_info` (
   `name` varchar(255) NOT NULL DEFAULT '',
   `founder` text NOT NULL,
@@ -143,102 +133,92 @@ CREATE TABLE `anope_cs_info` (
   `repeattimes` smallint(6) NOT NULL DEFAULT '0',
   PRIMARY KEY (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_cs_info_metadata`
 --
 
 DROP TABLE IF EXISTS `anope_cs_info_metadata`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_cs_info_metadata` (
   `channel` varchar(255) NOT NULL DEFAULT '',
   `name` varchar(255) NOT NULL DEFAULT '',
   `value` text NOT NULL,
-  UNIQUE KEY `channel` (`channel`,`name`),
-  CONSTRAINT `anope_cs_info_metadata_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `channel` (`channel`,`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_cs_levels`
 --
 
 DROP TABLE IF EXISTS `anope_cs_levels`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_cs_levels` (
   `channel` varchar(255) NOT NULL DEFAULT '',
   `position` int(11) NOT NULL DEFAULT '0',
   `level` int(11) NOT NULL DEFAULT '0',
-  UNIQUE KEY `channel` (`channel`,`position`),
-  CONSTRAINT `anope_cs_levels_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `channel` (`channel`,`position`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_cs_ttb`
 --
 
 DROP TABLE IF EXISTS `anope_cs_ttb`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_cs_ttb` (
   `channel` varchar(255) NOT NULL DEFAULT '',
   `ttb_id` int(11) NOT NULL DEFAULT '0',
   `value` int(11) NOT NULL DEFAULT '0',
-  UNIQUE KEY `channel` (`channel`,`ttb_id`),
-  CONSTRAINT `anope_cs_ttb_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `channel` (`channel`,`ttb_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_extra`
 --
 
 DROP TABLE IF EXISTS `anope_extra`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_extra` (
   `data` text NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_info`
 --
 
 DROP TABLE IF EXISTS `anope_info`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_info` (
   `version` int(11) DEFAULT NULL,
   `date` datetime DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_metadata`
 --
 
 DROP TABLE IF EXISTS `anope_metadata`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_metadata` (
   `name` varchar(255) NOT NULL DEFAULT '',
   `value` text NOT NULL,
   PRIMARY KEY (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_ms_info`
 --
 
 DROP TABLE IF EXISTS `anope_ms_info`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_ms_info` (
   `receiver` varchar(255) NOT NULL,
   `number` int(11) NOT NULL DEFAULT '0',
@@ -247,33 +227,29 @@ CREATE TABLE `anope_ms_info` (
   `sender` text NOT NULL,
   `text` blob NOT NULL,
   `serv` enum('NICK','CHAN') NOT NULL DEFAULT 'NICK',
-  UNIQUE KEY `receiver` (`receiver`,`number`),
-  CONSTRAINT `anope_ms_info_ibfk_1` FOREIGN KEY (`receiver`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `receiver` (`receiver`,`number`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_ns_access`
 --
 
 DROP TABLE IF EXISTS `anope_ns_access`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_ns_access` (
   `display` varchar(255) NOT NULL DEFAULT '',
   `access` varchar(160) NOT NULL,
-  UNIQUE KEY `display` (`display`,`access`),
-  CONSTRAINT `anope_ns_access_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE
+  UNIQUE KEY `display` (`display`,`access`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_ns_alias`
 --
 
 DROP TABLE IF EXISTS `anope_ns_alias`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_ns_alias` (
   `nick` varchar(255) NOT NULL DEFAULT '',
   `last_quit` text NOT NULL,
@@ -284,35 +260,31 @@ CREATE TABLE `anope_ns_alias` (
   `flags` text NOT NULL,
   `display` varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`nick`),
-  KEY `display` (`display`),
-  CONSTRAINT `anope_ns_alias_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE
+  KEY `display` (`display`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_ns_alias_metadata`
 --
 
 DROP TABLE IF EXISTS `anope_ns_alias_metadata`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_ns_alias_metadata` (
   `nick` varchar(255) NOT NULL DEFAULT '',
   `name` varchar(255) NOT NULL DEFAULT '',
   `value` text NOT NULL,
   PRIMARY KEY (`name`),
-  KEY `nick` (`nick`),
-  CONSTRAINT `anope_ns_alias_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_alias` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE
+  KEY `nick` (`nick`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_ns_core`
 --
 
 DROP TABLE IF EXISTS `anope_ns_core`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_ns_core` (
   `display` varchar(255) NOT NULL DEFAULT '',
   `pass` text NOT NULL,
@@ -326,32 +298,29 @@ CREATE TABLE `anope_ns_core` (
   `memomax` smallint(5) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`display`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_ns_core_metadata`
 --
 
 DROP TABLE IF EXISTS `anope_ns_core_metadata`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_ns_core_metadata` (
   `nick` varchar(255) NOT NULL DEFAULT '',
   `name` varchar(255) NOT NULL DEFAULT '',
   `value` text NOT NULL,
   PRIMARY KEY (`name`),
-  KEY `nick` (`nick`),
-  CONSTRAINT `anope_ns_core_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE
+  KEY `nick` (`nick`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_ns_request`
 --
 
 DROP TABLE IF EXISTS `anope_ns_request`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_ns_request` (
   `nick` varchar(255) NOT NULL DEFAULT '',
   `passcode` text NOT NULL,
@@ -360,15 +329,14 @@ CREATE TABLE `anope_ns_request` (
   `requested` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`nick`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_os_akills`
 --
 
 DROP TABLE IF EXISTS `anope_os_akills`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_os_akills` (
   `user` varchar(255) NOT NULL,
   `host` varchar(255) NOT NULL,
@@ -378,15 +346,14 @@ CREATE TABLE `anope_os_akills` (
   `expire` int(11) NOT NULL DEFAULT '0',
   UNIQUE KEY `user` (`user`,`host`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_os_core`
 --
 
 DROP TABLE IF EXISTS `anope_os_core`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_os_core` (
   `maxusercnt` int(11) NOT NULL DEFAULT '0',
   `maxusertime` int(11) NOT NULL DEFAULT '0',
@@ -395,15 +362,14 @@ CREATE TABLE `anope_os_core` (
   `sqlines_count` int(11) NOT NULL DEFAULT '0',
   `szlines_count` int(11) NOT NULL DEFAULT '0'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_os_exceptions`
 --
 
 DROP TABLE IF EXISTS `anope_os_exceptions`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_os_exceptions` (
   `mask` varchar(255) NOT NULL,
   `limit` int(11) NOT NULL DEFAULT '0',
@@ -412,15 +378,14 @@ CREATE TABLE `anope_os_exceptions` (
   `time` int(11) NOT NULL DEFAULT '0',
   `expires` int(11) NOT NULL DEFAULT '0'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
+
+-- --------------------------------------------------------
 
 --
 -- Table structure for table `anope_os_sxlines`
 --
 
 DROP TABLE IF EXISTS `anope_os_sxlines`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `anope_os_sxlines` (
   `type` varchar(20) NOT NULL,
   `mask` varchar(255) NOT NULL,
@@ -429,8 +394,79 @@ CREATE TABLE `anope_os_sxlines` (
   `seton` int(11) NOT NULL DEFAULT '0',
   `expire` int(11) NOT NULL DEFAULT '0'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Dumping routines for database 'anope'
+-- Constraints for dumped tables
+--
+
+--
+-- Constraints for table `anope_bs_badwords`
+--
+ALTER TABLE `anope_bs_badwords`
+  ADD CONSTRAINT `anope_bs_badwords_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_bs_info_metadata`
+--
+ALTER TABLE `anope_bs_info_metadata`
+  ADD CONSTRAINT `anope_bs_info_metadata_ibfk_1` FOREIGN KEY (`botname`) REFERENCES `anope_bs_core` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_cs_access`
+--
+ALTER TABLE `anope_cs_access`
+  ADD CONSTRAINT `anope_cs_access_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_cs_akick`
+--
+ALTER TABLE `anope_cs_akick`
+  ADD CONSTRAINT `anope_cs_akick_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_cs_info_metadata`
+--
+ALTER TABLE `anope_cs_info_metadata`
+  ADD CONSTRAINT `anope_cs_info_metadata_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_cs_levels`
+--
+ALTER TABLE `anope_cs_levels`
+  ADD CONSTRAINT `anope_cs_levels_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_cs_ttb`
+--
+ALTER TABLE `anope_cs_ttb`
+  ADD CONSTRAINT `anope_cs_ttb_ibfk_1` FOREIGN KEY (`channel`) REFERENCES `anope_cs_info` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_ms_info`
+--
+ALTER TABLE `anope_ms_info`
+  ADD CONSTRAINT `anope_ms_info_ibfk_1` FOREIGN KEY (`receiver`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_ns_access`
+--
+ALTER TABLE `anope_ns_access`
+  ADD CONSTRAINT `anope_ns_access_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_ns_alias`
+--
+ALTER TABLE `anope_ns_alias`
+  ADD CONSTRAINT `anope_ns_alias_ibfk_1` FOREIGN KEY (`display`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_ns_alias_metadata`
+--
+ALTER TABLE `anope_ns_alias_metadata`
+  ADD CONSTRAINT `anope_ns_alias_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_alias` (`nick`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `anope_ns_core_metadata`
 --
+ALTER TABLE `anope_ns_core_metadata`
+  ADD CONSTRAINT `anope_ns_core_metadata_ibfk_1` FOREIGN KEY (`nick`) REFERENCES `anope_ns_core` (`display`) ON DELETE CASCADE ON UPDATE CASCADE;