Задавайте вопросы, мы ответим
Вы не зашли.
Поле name выдаёт ошибку. В чём проблема?
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `tra`.`control_zone` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`user_id` INT( 10 ) UNSIGNED NOT NULL ,
`source` GEOMETRY NOT NULL ,
`distance` DOUBLE NOT NULL ,
`name` VARCHAR( 45 ) NOT NULL ,
`buffer` GEOMETRY NOT NULL ,
`color` INT( 11 ) NOT NULL ,
`borderColor` INT( 11 ) NOT NULL ,
`lineWidth` FLOAT NOT NULL ,
PRIMARY KEY ( `id` ) ,
SPATIAL INDEX `Index_2` ( `source` ( 32 ) ASC )
) ENGINE = MYISAM DEFAULT CHARACTER SET = cp1251;
Ответ MySQL: Документация
#1089 - Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
Неактивен
SPATIAL INDEX `Index_2` ( `source` ( 32 ) ASC )
http://dev.mysql.com/doc/refman/5.5/en/ … index.html
For spatial columns, prefix values cannot be given, as described later in this section.
Неактивен