--
-- Database: `test`
--

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

--
-- Table structure for table `ex_tbl_trgr`
--

CREATE TABLE IF NOT EXISTS `ex_tbl_trgr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`company` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

CREATE TABLE IF NOT EXISTS `ex_tbl_trgr_bkp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`company` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_trigger_ex`
--

INSERT INTO `ex_tbl_trgr` (`id`, `name`, `company`) VALUES
(1, 'john', 'abc inc'),
(2, 'lois', 'daily planet'),
(3, 'clark kent', 'north pole ltd'),
(4, 'abbott', 'costello inc');

--
-- Trigger `ExMovDeletedRecs`
--
DROP TRIGGER IF EXISTS `test`.`ExMovDeletedRecs`;
DELIMITER //
CREATE TRIGGER `test`.`ExMovDeletedRecs` BEFORE DELETE ON `test`.`ex_tbl_trgr`
FOR EACH ROW BEGIN
INSERT INTO ex_tbl_trgr_bkp (`id`,`name`,`company`)
VALUES(OLD.id,OLD.name,OLD.company) ;
END //
DELIMITER ;