TDDQG6vs

1
2CREATE TABLE IF NOT EXISTS `delivery_raions` (
3  `id` int(5) NOT NULL AUTO_INCREMENT,
4  `name` varchar(255) NOT NULL,
5  `city_id` int(5) NOT NULL,
6  PRIMARY KEY (`id`),
7  KEY `city_id` (`city_id`)
8) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
9
10CREATE TABLE IF NOT EXISTS `delivery_cities` (
11  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
12  `zone_id` int(5) unsigned NOT NULL,
13  `city_id` int(5) unsigned NOT NULL,
14  `amount_of_km` int(2) unsigned NOT NULL,
15  PRIMARY KEY (`id`),
16  KEY `zone_id` (`zone_id`)
17) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
18
19# THAT NOT WORKING
20ALTER TABLE `delivery_raions` ADD
21FOREIGN KEY (city_id) REFERENCES delivery_cities(id)
22ON DELETE CASCADE