Drink-Bar spatial problem

-- ---
-- Globals
-- ---

-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET FOREIGN_KEY_CHECKS=0;

-- ---
-- Table 'drinks'
--
-- ---

DROP TABLE IF EXISTS `drinks`;

CREATE TABLE `drinks` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR NULL DEFAULT NULL,
  `glass_id` INTEGER NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

-- ---
-- Table 'bars'
--
-- ---

DROP TABLE IF EXISTS `bars`;

CREATE TABLE `bars` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR NULL DEFAULT NULL,
  `lat` DOUBLE NULL DEFAULT NULL,
  `lng` DOUBLE NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

-- ---
-- Table 'glasses'
--
-- ---

DROP TABLE IF EXISTS `glasses`;

CREATE TABLE `glasses` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` VARCHAR NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

-- ---
-- Table 'drink__bars'
--
-- ---

DROP TABLE IF EXISTS `drink__bars`;

CREATE TABLE `drink__bars` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `bar_id` INTEGER NULL DEFAULT NULL,
  `drink_id` INTEGER NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

-- ---
-- Foreign Keys
-- ---

ALTER TABLE `drinks` ADD FOREIGN KEY (glass_id) REFERENCES `glasses` (`id`);
ALTER TABLE `drink__bars` ADD FOREIGN KEY (bar_id) REFERENCES `bars` (`id`);
ALTER TABLE `drink__bars` ADD FOREIGN KEY (drink_id) REFERENCES `drinks` (`id`);

-- ---
-- Table Properties
-- ---

-- ALTER TABLE `drinks` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `bars` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `glasses` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `drink__bars` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ---
-- Test Data
-- ---

-- INSERT INTO `drinks` (`id`,`name`,`glass_id`) VALUES
-- ('','','');
-- INSERT INTO `bars` (`id`,`name`,`lat`,`lng`) VALUES
-- ('','','','');
-- INSERT INTO `glasses` (`id`,`name`) VALUES
-- ('','');
-- INSERT INTO `drink__bars` (`id`,`bar_id`,`drink_id`) VALUES
-- ('','','');