CREATE TABLE IF NOT EXISTS areas id int 11 NOT NULL AUTO_INCREMENT use

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
CREATE TABLE IF NOT EXISTS `areas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`area` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Дамп данных таблицы `areas`
--
INSERT INTO `areas` (`id`, `user`, `x`, `y`, `area`) VALUES
(1, 1, 0, 0, 1),
(2, 1, 1, 0, 2),
(3, 1, 1, 1, 2),
(4, 1, 2, 2, 2),
(5, 1, 0, 2, 1),
(10, 1, 0, 1, 1);