Locations table/data

/**
 * Locations table
 */
CREATE TABLE `locations` (
    `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name` VARCHAR(15) NOT NULL,
    `latitude` DECIMAL NOT NULL,
    `longitude` DECIMAL NOT NULL,
    `user_id` INT NOT NULL,
    `created` DATETIME DEFAULT NULL,
    `modified` DATETIME DEFAULT NULL
);

/**
 * Locations data
 */
INSERT INTO `locations` (`id`, `name`, `latitude`, `longitude`, `user_id`, `created`, `modified`) VALUES
    (0, 'Boston, MA', 42.3581, 71.0636, 3, NOW(), NOW()),
    (0, 'London, England', 51.5072, 0.1275, 3, NOW(), NOW()),
    (0, 'Great Barrier Reef', 18.2861, 147.7000, 3, NOW(), NOW());