4v23qP52

1
2CREATE TABLE IF NOT EXISTS `flat` (
3  `number` int(6) unsigned NOT NULL,
4  `count_room` int(5) NOT NULL,
5  `floor` int(3) unsigned NOT NULL,
6  `square` int(10) NOT NULL,
7  PRIMARY KEY (`number`)
8) DEFAULT CHARSET=utf8;
9
10CREATE TABLE IF NOT EXISTS `persons` (
11  `id` int(6) unsigned NOT NULL,
12  `fio` varchar(40) NOT NULL,
13  `flat` int(6) NOT NULL,
14  PRIMARY KEY (`id`)
15) DEFAULT CHARSET=utf8;