Sample Constraints for mysql

mysql-constraints.sql

-- phpMyAdmin SQL Dump
-- version 3.5.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 16, 2013 at 08:30 AM
-- Server version: 5.5.25a
-- PHP Version: 5.3.20

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `masterTbl`
--

CREATE TABLE IF NOT EXISTS `masterTbl` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `someProperty` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=110 ;

--
-- Dumping data for table `masterTbl`
--

INSERT INTO `masterTbl` (`id`, `someProperty`) VALUES
(10, 'Braxton Delacruz'),
(11, 'Vladislav Lam'),
(12, 'Vladislav Morrison'),
(13, 'Catherine Pollard'),
(14, 'Melinda McGee'),
(15, 'Vagelis Robinson'),
(16, 'Gabriel Weiss'),
(17, 'Rebecca Thomas'),
(18, 'Maureen Buchanan'),
(19, 'Jacob Cabrera'),
(20, 'Kieran Hensley'),
(21, 'Vanessa Fuentes'),
(22, 'Sameera Greene'),
(23, 'Bess Harrington'),
(24, 'Jessica Reyes'),
(25, 'Teresa Gentry'),
(26, 'George Hopkins'),
(27, 'Chris McFarland'),
(28, 'Maureen Drake'),
(29, 'Steven Mack'),
(30, 'Jennifer Barnes'),
(31, 'Dominic Villarreal'),
(32, 'Ahmad Haas'),
(33, 'Hannah Orr'),
(34, 'Mat Klein'),
(35, 'Daryl Cobb'),
(36, 'Dragan Harper'),
(37, 'Lars Wilcox'),
(38, 'Sharon Spears'),
(39, 'Penny Mata'),
(40, 'Bjorn Goff'),
(41, 'Ross Brown'),
(42, 'Elif Leonard'),
(43, 'Emily Bowen'),
(44, 'Roderic Duncan'),
(45, 'Benny Harrington'),
(46, 'Rosalyn Mitchell'),
(47, 'Summer Lowe'),
(48, 'Gedeon Walker'),
(49, 'Virginia Herring'),
(50, 'Bonnie Moss'),
(51, 'Yvette Morgan'),
(52, 'Bartlomiej Miles'),
(53, 'Erin Walls'),
(54, 'Jase Trujillo'),
(55, 'Erin Horton'),
(56, 'Cliff Wells'),
(57, 'Olga Zhang'),
(58, 'Shawn Key'),
(59, 'Christy Wolf'),
(60, 'Andy Huang'),
(61, 'Dean Nolan'),
(62, 'Leigh Aguilar'),
(63, 'Rachana Vazquez'),
(64, 'Nicholas Calderon'),
(65, 'Bryce Patton'),
(66, 'Stewart Yates'),
(67, 'Rosalyn O''Donnell'),
(68, 'Keith Tucker'),
(69, 'Florian Rush'),
(70, 'Conor Gallagher'),
(71, 'Dana Andrews'),
(72, 'Julio Mosley'),
(73, 'Bill Malone'),
(74, 'Jesper Snow'),
(75, 'Johan Lowery'),
(76, 'Kirk Walker'),
(77, 'Seth Fry'),
(78, 'Neil Mata'),
(79, 'Jean Paul Olson'),
(80, 'Abigail Gross'),
(81, 'Sîan Moon'),
(82, 'Jasper McClain'),
(83, 'Fred Patel'),
(84, 'Reginald Long'),
(85, 'Luis Cook'),
(86, 'Clemens Evans'),
(87, 'Conor Abbott'),
(88, 'Magnus Simon'),
(89, 'Joel Norton'),
(90, 'Rosie Rich'),
(91, 'Simon Bonilla'),
(92, 'Joe Ritter'),
(93, 'Cameron Meyer'),
(94, 'Eoin Sanders'),
(95, 'Alexis Short'),
(96, 'Anne-Marie Pearson'),
(97, 'Emma Norris'),
(98, 'Hector Vance'),
(99, 'Maureen Vega'),
(100, 'Penny Jacobson'),
(101, 'Ted Hatfield'),
(102, 'Geoff Pearson'),
(103, 'Devin Barker'),
(104, 'Reginald Zamora'),
(105, 'Brandon Atkins'),
(106, 'Zac Benjamin'),
(107, 'Florian Dougherty'),
(108, 'Zachary Mitchell'),
(109, 'Laurence Phillips');

-- --------------------------------------------------------

--
-- Table structure for table `slaveTbl`
--

CREATE TABLE IF NOT EXISTS `slaveTbl` (
  `masterTbl_id` int(11) unsigned NOT NULL,
  `extraData` varchar(200) DEFAULT NULL,
  KEY `masterTbl_id` (`masterTbl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `slaveTbl`
--

INSERT INTO `slaveTbl` (`masterTbl_id`, `extraData`) VALUES
(14, 'jake@latewerk.eg'),
(83, 'benton@fuelunit.kg'),
(30, 'florian@lowwerk.bh'),
(61, 'giles@lowwerk.bn'),
(38, 'charles.gamble@rolllive.sl'),
(30, 'sonia.singh@madefeed.zw'),
(31, 'maynard@fussbase.lu'),
(65, 'victoria@fuelfeed.ad'),
(18, 'eveline@shutbase.lb'),
(55, 'henry@gigabot.sl'),
(38, 'charles@gigabot.ca'),
(91, 'petty@busything.li'),
(62, 'chen@tidybase.gf'),
(14, 'landry@latething.fi'),
(54, 'laura@gigaware.eu'),
(19, 'sebastian.cain@chatserv.gr'),
(74, 'anne-marie@lowbase.ie'),
(44, 'claire.barrera@lowbot.ci'),
(85, 'swanson@selfwerk.aq'),
(71, 'fulton@jetware.tm'),
(77, 'garcia@earlything.ru'),
(51, 'agatha.oneill@shutware.mil'),
(58, 'kirsty@tagclicks.us'),
(38, 'avery@getware.at'),
(17, 'lucas@mybot.pro'),
(69, 'cantrell@tidysource.tr'),
(82, 'garrett.lee@putbeat.sv'),
(14, 'brooks@chatdesk.pe'),
(78, 'haley@busydesk.ag'),
(22, 'nikolay@rollbase.bt'),
(40, 'fred@chatclicks.pr'),
(31, 'mcmahon@chatserv.rw'),
(71, 'dragan@selfsimple.ee'),
(80, 'dennis.stephens@rollwords.co'),
(89, 'ava@rolldesk.tt'),
(86, 'matthias.henson@tidyspace.ba'),
(59, 'amy.pitts@quitbeat.mx'),
(96, 'bertha@quitlive.mh'),
(46, 'andrade@quitsphere.tel'),
(79, 'lily@quitsimple.fk'),
(33, 'belinda@shutblog.gt'),
(23, 'joshua.levy@earlysource.cf'),
(81, 'colin.porter@lowware.int'),
(89, 'jermaine.frazier@madebase.tj'),
(63, 'levy@fuellive.mo'),
(52, 'gordon@rollwerk.it'),
(35, 'page@shutdesk.gov'),
(21, 'jensen@youserv.tc'),
(50, 'ignacio.munoz@presswords.aw'),
(57, 'jocelyn.romero@latebase.ba'),
(74, 'ruby.newton@youfeed.lu'),
(61, 'padma@gigaserv.vu'),
(70, 'cornelius.contreras@tidysource.so'),
(31, 'stella.sharp@fuelclicks.edu'),
(40, 'drew.salazar@tagserv.sv'),
(16, 'ulrika.nolan@selfserv.se'),
(44, 'vicky@pressspace.mobi'),
(67, 'rory@latesphere.edu'),
(13, 'mccormick@selfwords.lb'),
(47, 'hugh.hicks@quitsphere.mu'),
(43, 'curry@shutbeat.dm'),
(77, 'gunther@fuellive.pro'),
(29, 'dougal.branch@earlybit.eg'),
(57, 'jackson@chatspace.info'),
(60, 'blair@busywerk.jm'),
(23, 'evan.ryan@putbase.aw'),
(74, 'mary.silva@putlive.jobs'),
(89, 'villarreal@fuelfeed.au'),
(24, 'hal.wiley@shutware.int'),
(39, 'vasile.gay@pressunit.pm'),
(86, 'potts@lowthing.to'),
(77, 'larissa.mitchell@lateblog.nc'),
(46, 'conor@fussblog.lk'),
(76, 'colleen@getbit.gm'),
(88, 'thompson@earlywords.be'),
(14, 'larson@fussbeat.hm'),
(36, 'dean@jetspace.md'),
(54, 'vanessa.lawson@gigafeed.kr'),
(14, 'graeme.bishop@tidyspace.vi'),
(65, 'davis@tagunit.vg'),
(17, 'daisy.faulkner@yousphere.vg'),
(79, 'warren.kirby@tidywords.is'),
(65, 'mark@madelive.tf'),
(94, 'julio.douglas@chatfeed.biz'),
(96, 'hector.green@quitsource.fm'),
(34, 'nina@putwerk.cl'),
(87, 'juarez@getsource.gm'),
(78, 'james@fussspace.ck'),
(90, 'arne.robinson@madefeed.tv'),
(96, 'arellano@myware.gov'),
(70, 'adam.everett@fusswerk.fi'),
(12, 'shane@selfpower.vg'),
(76, 'bertha.tran@lowbot.to'),
(10, 'flynn@gigapower.lb'),
(17, 'vasile@chatfeed.az'),
(29, 'sarah@busyblog.no'),
(67, 'alasdair.gaines@lowunit.pk'),
(65, 'estrada@putserv.to'),
(28, 'ingrid@madebeat.la'),
(47, 'dominique.burgess@latewords.tp'),
(95, 'tabitha@latefeed.ae'),
(25, 'william.powell@getlive.gh'),
(26, 'brandon.prince@presssphere.ba'),
(19, 'una.dean@putserv.tel'),
(80, 'eugene@tidyware.ad'),
(46, 'bowen@gigabase.bo'),
(14, 'johannes@tagwerk.ie'),
(90, 'vagelis@earlybase.tj'),
(56, 'o''brien@latebit.im'),
(64, 'davina.boone@jetlive.il'),
(66, 'mccormick@gigabeat.tv'),
(83, 'conor.rocha@chatbase.xxx'),
(99, 'jens.yates@chatbit.lv'),
(20, 'holmes@getdesk.mx'),
(22, 'arnaud.lowe@mysphere.ck'),
(49, 'hanna@putwerk.ar'),
(61, 'mejia@quitsimple.mobi'),
(13, 'zoe@rollbeat.kh'),
(66, 'green@chatpower.nc'),
(87, 'debra.perkins@putthing.lk'),
(31, 'henry@rollwerk.org'),
(77, 'chung@rollthing.cf'),
(52, 'aguilar@busywords.km'),
(64, 'istvan.gordon@earlylive.ba'),
(81, 'shane@getware.gi'),
(70, 'susan.mccall@selfunit.tt'),
(59, 'clarke@selfspace.tn'),
(31, 'terry@earlywords.az'),
(70, 'downs@earlylive.kg'),
(23, 'heath@fuelunit.co'),
(43, 'sullivan@gigaserv.vn'),
(36, 'braxton.hull@chatunit.nl'),
(46, 'case@gigaserv.ls'),
(27, 'laszlo.salinas@latepower.kn'),
(18, 'lars.yoder@tidyware.am'),
(52, 'o''connor@chatlive.at'),
(53, 'tessa@rollpower.jp'),
(99, 'hawkins@presssphere.tc'),
(81, 'summer@latebit.cf'),
(81, 'laurence@rollsource.na'),
(56, 'allen.sanders@pressbase.mq'),
(88, 'craig@yousphere.sk'),
(26, 'blanchard@selfbeat.et'),
(40, 'bradley@jetlive.yt'),
(27, 'jorge.hurst@busydesk.ps'),
(81, 'morton@madedesk.sl'),
(69, 'calderon@tagbot.mp'),
(50, 'nguyen@selfwerk.sa'),
(35, 'george@busyserv.sb'),
(36, 'dejesus@quitclicks.ru'),
(21, 'berg@quitpower.tw'),
(14, 'avila@selflive.ni'),
(39, 'luis@rollsource.kr'),
(31, 'kieran@lowbase.es'),
(81, 'parker@lateunit.ac'),
(86, 'bishop@tagsource.ac'),
(92, 'sian.yoder@shutbot.uy'),
(72, 'thomas.daugherty@youbot.fj'),
(67, 'karen.houston@selfpower.fr'),
(56, 'tania.werner@youdesk.jo'),
(80, 'becky@jetpower.at'),
(15, 'les.best@earlyunit.tm'),
(11, 'zach@madepower.vg'),
(40, 'petersen@chatpower.sr'),
(85, 'violet@jetsource.pl'),
(62, 'august.duarte@chatwords.bg'),
(73, 'soto@selfwerk.ad'),
(90, 'jane.conrad@quitunit.cg'),
(45, 'rose@madedesk.rs'),
(39, 'daisy@fussblog.kg'),
(48, 'jeanpaul@fussblog.mv'),
(59, 'mary@jetbit.sk'),
(34, 'barbara@fusswords.lb'),
(81, 'gunther@chatsource.ie'),
(77, 'eveline.ferrell@rollbit.ps'),
(44, 'walls@chatbeat.uk'),
(49, 'logan@quitsphere.om'),
(97, 'galvan@lowbase.by'),
(84, 'larson@quitware.ac'),
(26, 'andrew.bartlett@putsource.td'),
(85, 'torsten.singh@chatbase.mx'),
(36, 'weeks@quitdesk.md'),
(23, 'annabel@quitbeat.vu'),
(32, 'gunter@earlyspace.fo'),
(52, 'oleg@quitsource.asia'),
(30, 'louise@jetbot.de'),
(83, 'hays@selfbot.gi'),
(57, 'andreas@chatdesk.me'),
(22, 'bryce.gallegos@jetware.coop'),
(46, 'gwen.molina@busywords.py'),
(29, 'warren.barr@tidyfeed.tel'),
(40, 'avery@pressbot.so'),
(53, 'costa@chatfeed.mt'),
(20, 'eugene@selfware.ml'),
(53, 'valeriy.cox@selffeed.coop'),
(34, 'colleen@lowwords.sn'),
(78, 'stephan@busyserv.ad'),
(10, 'xanthe.cohen@youlive.tf'),
(17, 'dragan@youthing.mx'),
(59, 'gabrielle.moyer@youdesk.nr'),
(80, 'lydia.winters@tidybit.mw'),
(12, 'denise.stanley@quitware.cat'),
(63, 'murray@selfwerk.nl'),
(12, 'braun@shutbase.hm'),
(35, 'owen@fuelbit.gs'),
(74, 'johann@latefeed.ls'),
(26, 'jerremy@jetlive.tf'),
(27, 'andersen@getdesk.pf'),
(66, 'ryan@youpower.dk'),
(28, 'debbie.parks@busyware.ao'),
(97, 'galloway@lowspace.st'),
(63, 'tobias.monroe@myunit.sr'),
(48, 'debbie.levine@mylive.sy'),
(43, 'karen@presssource.tn'),
(46, 'arnold.carter@quitbot.sm'),
(61, 'edna@shutwerk.tz'),
(51, 'castaneda@latespace.nu'),
(86, 'nigella.dickerson@rollthing.gr'),
(27, 'ash@tidylive.su'),
(66, 'silvio@lowware.al'),
(87, 'blanchard@chatblog.it'),
(29, 'michael@selfbit.wf'),
(59, 'mia@putsimple.in'),
(42, 'chandler@earlybot.dm'),
(10, 'todd@shutspace.ma'),
(54, 'cliff.mack@putbot.mr'),
(11, 'clemens.herman@rollclicks.pa'),
(50, 'roland@selfbit.ml'),
(45, 'geoff@busything.gq'),
(13, 'allen.golden@putsphere.fk'),
(80, 'jeremy.rubio@quitlive.cm'),
(86, 'gordon.norton@busypower.cu'),
(57, 'claudio.thompson@selflive.gg'),
(90, 'espinoza@fussfeed.aero'),
(22, 'callahan@getunit.pm'),
(22, 'bronwyn@earlywerk.il'),
(94, 'jessica.ramsey@rollsphere.pw'),
(85, 'claudio.tran@lowbot.ao'),
(93, 'gareth.erickson@jetthing.ag'),
(100, 'jeremy@jetspace.zw'),
(30, 'grant@gigawerk.bd'),
(56, 'mabel.miles@tidyware.tl'),
(65, 'bill.george@latewerk.edu'),
(65, 'dmitri.brady@gigaspace.sm'),
(72, 'debbie@fussbeat.gb'),
(45, 'bowen@getfeed.cm'),
(11, 'josie@madeblog.mu'),
(41, 'hensley@getfeed.sv'),
(34, 'stefan.mckee@gigadesk.et'),
(49, 'haas@rollbase.tk'),
(36, 'nielsen@chatunit.dj'),
(58, 'claude@putsphere.bg'),
(34, 'dillon@tagclicks.tf'),
(62, 'kirk@yousphere.mobi'),
(82, 'alvarado@lowsphere.np'),
(84, 'rosales@putbit.coop'),
(95, 'houston@tidysource.sb'),
(80, 'jerry@getlive.al'),
(81, 'wendy.chandler@rollspace.qa'),
(100, 'danny.valdez@quitwerk.dm'),
(10, 'max.house@latespace.na'),
(80, 'casey@shutbot.ae'),
(47, 'guy@fuelbot.ec'),
(39, 'villarreal@fuelsphere.mt'),
(90, 'gilbert@getsphere.kn'),
(58, 'leah@selfsphere.gg'),
(72, 'lopez@lowbeat.vg'),
(13, 'seth@gigaware.vc'),
(46, 'georgina@jetsphere.nl'),
(58, 'brit.crawford@latefeed.com'),
(28, 'kemp@latedesk.fj'),
(36, 'miguel.owens@gigawords.edu'),
(40, 'moreno@chatspace.vu'),
(99, 'matthew.randolph@tidyserv.mr'),
(72, 'slater@chatsimple.pg'),
(78, 'andrews@putbeat.io'),
(66, 'kate@rollbeat.tr'),
(60, 'mccormick@lowbot.sr'),
(49, 'young@fussunit.tl'),
(44, 'shane.sutton@latesimple.ba'),
(68, 'frank@tagbot.pn'),
(74, 'jason.mccarthy@lowdesk.au'),
(52, 'esparza@mydesk.tn'),
(94, 'shaw@lowclicks.es'),
(68, 'lukas@lowunit.hk'),
(100, 'chung@selfblog.jobs'),
(32, 'shirley@jetsource.hu'),
(34, 'harrison@selfthing.kn'),
(65, 'jude@pressblog.bb'),
(29, 'padraig@mywerk.tz'),
(37, 'charlotte@rolldesk.pro'),
(27, 'megan@earlybit.tk'),
(70, 'paulo.norton@mysphere.im'),
(55, 'brett@chatbit.nc'),
(94, 'hunter.cherry@rollsphere.org'),
(44, 'maureen.ramos@selfbeat.aw'),
(91, 'vladimir.calderon@taglive.bn'),
(70, 'jane@fussclicks.no'),
(94, 'roman@quitthing.ec'),
(34, 'riddle@selfwerk.aq');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `slaveTbl`
--
ALTER TABLE `slaveTbl`
  ADD CONSTRAINT `slaveTbl_ibfk_1` FOREIGN KEY (`masterTbl_id`) REFERENCES `masterTbl` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!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 */;