INSERT INTO GeographicalKoordinates (Koordinate,TypeKoordinates,SRID,RadiusAction,HeighSeaLevel,Description) VALUES (ST_Pointfromtext('POINT(55.118132 51.75641)',4326),'POINT',4326,10,15,'Unknown');

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