-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.17-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema test
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ test;
USE test;

--
-- Table structure for table `test`.`c`
--

DROP TABLE IF EXISTS `c`;
CREATE TABLE `c` (
  `name` varchar(64) default NULL,
  `type` varchar(64) default NULL,
  `number` int(11) default NULL,
  KEY `name` (`name`,`type`),
  CONSTRAINT `c_ibfk_1` FOREIGN KEY (`name`, `type`) REFERENCES `p` (`name`, `type`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test`.`c`
--

/*!40000 ALTER TABLE `c` DISABLE KEYS */;
/*!40000 ALTER TABLE `c` ENABLE KEYS */;


--
-- Table structure for table `test`.`p`
--

DROP TABLE IF EXISTS `p`;
CREATE TABLE `p` (
  `name` varchar(64) NOT NULL default '',
  `type` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`name`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test`.`p`
--

/*!40000 ALTER TABLE `p` DISABLE KEYS */;
/*!40000 ALTER TABLE `p` ENABLE KEYS */;


--
-- Procedure `test`.`bogus`
--

DROP PROCEDURE IF EXISTS `bogus`;
DELIMITER $$

CREATE PROCEDURE `bogus`(
    p_schema varchar(64)
,   p_table  varchar(64)
)
select   concat(
             table_schema
         ,   '.'
         ,   table_name
         ,   ' ('
         ,   constraint_name
         ,   ' )'
         ,   group_concat(
                 column_name
             ,   ' -> '
             ,   referenced_column_name
             order by ordinal_position
             )
         )
from   information_schema.key_column_usage kcu
where kcu.referenced_table_schema = p_schema
and kcu.referenced_table_name = p_table
group by constraint_schema
,        constraint_name
,        table_schema
,        table_name $$

DELIMITER ;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;