tnd44AQy

1CREATE TABLE IF NOT EXISTS `addresses` ( 
2  `adr_id` int(11) NOT NULL auto_increment, 
3  `per_id` int(11) NOT NULL, 
4  `adr_street` varchar(50) NOT NULL, 
5  `adr_houseno` int(11) default NULL, 
6  `adr_housenoadd` varchar(10) default NULL, 
7  `adr_postalcode` varchar(25) NOT NULL, 
8  `adr_city` varchar(20) NOT NULL, 
9  `adr_type` varchar(45) default NULL, 
10  `cnt_id` int(11) NOT NULL, 
11  `adr_date` date default NULL, 
12  `sys-mut-dt` timestamp NULL default NULL, 
13  `sys-mut-user` varchar(20) default NULL, 
14  `sys-mut-id` int(11) NOT NULL default '0', 
15  PRIMARY KEY  (`adr_id`), 
16  KEY `per_id` (`per_id`), 
17  KEY `cnt_id` (`cnt_id`) 
18) ENGINE=InnoDB DEFAULT CHARSET=utf8 ; 
19-- 
20-- RELATIES VOOR TABEL `addresses`: 
21--   `cnt_id` 
22--       `countries` -> `cnt_id` 
23--   `per_id` 
24--       `persons` -> `per_id` 
25-- 
26
27CREATE TABLE `events` ( 
28  `evt_id` int(11) NOT NULL auto_increment, 
29  `evt_name` varchar(50) NOT NULL, 
30  `evt_description` varchar(100) default NULL, 
31  `evt_startdate` date NOT NULL, 
32  `evt_enddate` date default NULL, 
33  `evt_starttime` time default NULL, 
34  `evt_endtime` time default NULL, 
35  `evt_amtpersons` int(11) default NULL, 
36  `sts_id` int(11) NOT NULL, 
37  `adr_id` int(11) default NULL, 
38  `evt_amtPersonsSubs` tinyint(4) NOT NULL default '0', 
39  `evt_photo` varchar(50) default NULL, 
40  `sys-mut-dt` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 
41  `sys-mut-user` varchar(20) default NULL, 
42  `sys-mut-id` int(11) NOT NULL default '0', 
43  PRIMARY KEY  (`evt_id`), 
44  KEY `sts_id` (`sts_id`), 
45  KEY `adr_id` (`adr_id`) 
46) ENGINE=InnoDB DEFAULT CHARSET=utf8;
47	
48DELETE
49FROM    addresses
50WHERE   per_id = 45
51
521451 - Cannot delete or update a parent row: a foreign key constraint fails (`site/events`, CONSTRAINT `adr_id` FOREIGN KEY (`adr_id`) REFERENCES `addresses` (`adr_id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ;
53	
54/* I think it means "How can I solve this?" */
55	
56SELECT  e.*
57FROM    addresses a
58JOIN    events e
59ON      e.adr_id = a.adr_id
60WHERE   a.per_id = 45