CREATE TABLE GeographicalKoordinates (
  Id_GeographicalKoordinates int(11) NOT NULL AUTO_INCREMENT,
  Koordinate geometry NOT NULL,
  TypeKoordinates VARCHAR(50) CHECK (TypeKoordinates IN ('POINT', 'LINESTRING','POLYGON','Other', null)),
  SRID_ INT default null,
  RadiusAction double default NULL,
  AllKoordinatesArea text GENERATED ALWAYS AS (Buffer(Koordinate,RadiusAction)),
  HeighSeaLevel DOUBLE default NULL,
  KoordinateTxt text GENERATED ALWAYS AS (AsText(Koordinate)),
  AllKoordinatesAreaTxt text GENERATED ALWAYS AS (KoordsAreaInTxt(Koordinate,RadiusAction)),
  Description TEXT, 
  PRIMARY KEY (`Id_GeographicalKoordinates`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

DELIMITER $$
CREATE DEFINER=`root`@`localhost` FUNCTION `KoordsAreaInTxt`(Koordinate geometry, RadiusAction double) RETURNS text CHARSET utf8
BEGIN
declare area geometry default null;
declare areaTxt TEXT;
set area=Buffer(Koordinate,RadiusAction);
set areaTxt=AsText(area);
RETURN areaTxt;
END$$
DELIMITER ;