fpugP3qA

1CREATE TABLE IF NOT EXISTS `complex` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `city_name` varchar(256) NOT NULL,
4  `region_name` varchar(256) NOT NULL,
5  `address_name` varchar(256) NOT NULL,
6  `complex_name` varchar(256) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10INSERT INTO `complex` 
11(`id`, `city_name`, `region_name`, `address_name`, `complex_name`) 
12VALUES
13(1, 'Москва', 'Арбат', 'Арбат, 1', 'Дмитровский парк'),
14(2, 'Москва', 'Арбат', 'Арбат, 2', 'Оранж парк'),
15(3, 'Москва', 'Арбат', 'Арбат, 3', 'Люблинский парк'),
16(4, 'Москва', 'Басманный', 'Басманный, 1', 'Люберцы парк'),
17(5, 'Москва', 'Басманный', 'Басманный, 2', 'Митино парк'),
18(6, 'Москва', 'Басманный', 'Басманный, 3', 'Западный порт');
19
20
21CREATE TABLE IF NOT EXISTS `building` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `complex_id` int(11) NOT NULL,
24  `corpus_number` tinyint(3) unsigned NOT NULL,
25  `floor_count` tinyint(3) NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28
29INSERT INTO `building` 
30(`id`, `complex_id`, `corpus_number`, `floor_count`) 
31VALUES
32(1, 1, 0, 15),
33(2, 2, 1, 15),
34(3, 2, 2, 15),
35(4, 3, 0, 15),
36(5, 4, 0, 15),
37(6, 5, 1, 15),
38(7, 5, 2, 15),
39(8, 5, 3, 15),
40(9, 6, 0, 15);
41
42
43CREATE TABLE IF NOT EXISTS `flat` (
44  `id` int(11) NOT NULL AUTO_INCREMENT,
45  `building_id` int(11) NOT NULL,
46  `rent_sum` DECIMAL(9,2) NOT NULL,
47  `area` DECIMAL(6,2) NOT NULL,
48  `rooms` tinyint(3) unsigned NOT NULL,
49  `floor` tinyint(3) NOT NULL,
50  PRIMARY KEY (`id`)
51) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52
53INSERT INTO `flat` 
54(`id`, `building_id`, `rent_sum`, `area`, `rooms`, `floor`) 
55VALUES
56(1, 1, 30000, 25, 2, 1),
57(2, 1, 35000, 25, 2, 1),
58(3, 1, 40000, 25, 2, 1),
59(4, 1, 45000, 25, 2, 1),
60(5, 1, 50000, 25, 2, 1),
61(6, 2, 55000, 25, 2, 1),
62(7, 2, 60000, 25, 2, 2),
63(8, 2, 65000, 25, 2, 2),
64(9, 2, 70000, 25, 2, 2),
65(10, 2, 75000, 25, 2, 2),
66(11, 3, 80000, 25, 2, 2),
67(12, 3, 85000, 25, 2, 2),
68(13, 3, 90000, 25, 2, 10),
69(14, 3, 95000, 25, 2, 10),
70(15, 3, 100000, 25, 2, 10),
71(16, 4, 105000, 25, 2, 10),
72(17, 4, 110000, 25, 2, 10),
73(18, 4, 115000, 25, 2, 10),
74(19, 4, 120000, 25, 2, 10),
75(20, 4, 125000, 25, 2, 10),
76(21, 5, 30000, 25, 2, 3),
77(22, 5, 35000, 25, 2, 3),
78(23, 5, 40000, 25, 2, 3),
79(24, 5, 45000, 25, 2, 3),
80(25, 5, 50000, 25, 2, 3),
81(26, 6, 55000, 25, 2, 10),
82(27, 6, 60000, 25, 2, 10),
83(28, 6, 65000, 25, 2, 10),
84(29, 6, 70000, 25, 2, 10),
85(30, 6, 75000, 25, 2, 10);