CREATE TABLE GeomaticAddresses
(
    id BIGINT UNSIGNED NOT NULL,
    Zone BIGINT UNSIGNED NOT NULL,
    Longitude DECIMAL(12,9) NOT NULL,
    Latitude DECIMAL(12,9) NOT NULL,
    Color VARCHAR(12) DEFAULT "200 100 0",
    Label VARCHAR(256) NOT NULL,
    the_geom GEOMETRY NOT NULL,
    Feature VARCHAR(32) DEFAULT "circle",
    Size BIGINT UNSIGNED DEFAULT 5,
    Outline VARCHAR(12) DEFAULT "0 0 0",
    PRIMARY KEY ( Zone,id ),
    KEY ( id )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="GeomaticAddresses where address to geolocation information i";
