--
-- 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 ;