ntB3CUzC

1CREATE TABLE IF NOT EXISTS `country` (
2  `id` int(6) unsigned NOT NULL,
3  `name` varchar(100) NOT NULL,
4  PRIMARY KEY (`id`)
5) DEFAULT CHARSET=utf8;
6CREATE TABLE IF NOT EXISTS `region` (
7  `id` int(6) unsigned NOT NULL,
8  `country_id` int(6) unsigned NOT NULL,
9  `name` varchar(100) NOT NULL,
10  PRIMARY KEY (`id`),
11  FOREIGN KEY (`country_id`) REFERENCES country(`id`)
12) DEFAULT CHARSET=utf8;
13CREATE TABLE IF NOT EXISTS `city` (
14  `id` int(6) unsigned NOT NULL,
15  `region_id` int(6) unsigned NOT NULL,
16  `name` varchar(100) NOT NULL,
17  PRIMARY KEY (`id`),
18  FOREIGN KEY (`region_id`) REFERENCES region(`id`)
19) DEFAULT CHARSET=utf8;
20CREATE TABLE IF NOT EXISTS `hostel` (
21  `id` int(6) unsigned NOT NULL,
22  `city_id` int(6) unsigned NOT NULL,
23  `name` varchar(100) NOT NULL,
24  PRIMARY KEY (`id`),
25  FOREIGN KEY (`city_id`) REFERENCES city(`id`)
26) DEFAULT CHARSET=utf8;
27INSERT INTO `country` (`id`, `name`) VALUES
28  ('1', 'Россия'),
29  ('2', 'Америка');
30INSERT INTO `region` (`id`, `country_id`, `name`) VALUES
31  ('1', '1', 'Волгоградская область'),
32  ('2', '1', 'Ростовская область');
33INSERT INTO `city` (`id`, `region_id`, `name`) VALUES
34  ('1', '1', 'Волгоград'),
35  ('2', '2', 'Ростов'),
36  ('3', '1', 'Урюпинск'),
37  ('4', '2', 'Таганрог');
38INSERT INTO `hostel` (`id`, `city_id`, `name`) VALUES
39  ('1', '1', 'Огонек'),
40  ('2', '1', 'ннн'),
41  ('3', '2', 'ррр'),
42  ('4', '1', 'ккк'),
43  ('5', '3', 'hghgh'),
44  ('6', '4', 'lf'),
45  ('7', '3', '[w[w[');