Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `flat` (
- `number` int(6) unsigned NOT NULL,
- `count_room` int(5) NOT NULL,
- `floor` int(3) unsigned NOT NULL,
- `square` int(10) NOT NULL,
- PRIMARY KEY (`number`)
- ) DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS `persons` (
- `id` int(6) unsigned NOT NULL,
- `fio` varchar(40) NOT NULL,
- `flat` int(6) NOT NULL,
- PRIMARY KEY (`id`)
- ) DEFAULT CHARSET=utf8;
- INSERT INTO flat (number, count_room, floor, square) VALUES (1, 2, 1, 60)
- INSERT INTO flat (number, count_room, floor, square) VALUES (2, 3, 2, 80)
- INSERT INTO persons (id, fio, flat) VALUES (1, "PVA", 1)
- INSERT INTO persons (id, fio, flat) VALUES (2, "MAI", 2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement