GLE-Layer-FMK-Verwaltungsgrenzen

SQL-Dump der in kvwmap für die Fachschale FMK benötigten Layer, Klassen, Attribute, Labels, Styles und Drucklayouts für die Verwaltungsgrenzen

Folgenden Anpassungen müssen bei der Einrichtung der Fachschale vorgenommen werden.

Anpassung der Gruppen und Connection-ID.
Nicht alle Layer sind erforderlich wenn das FMK sich nicht über alle Verwaltungseinheiten erstreckt. Ein Landkreis braucht z.B. nicht den Layer Land und Landkreise, weil diese für einen Landkreis immer gleich sind und nicht pro Potentialfläche berechnet werden müssen.
Es können auch vorhandene Tabellen mit Verwaltungsgrenzen in der Fachschale FMK verwendet werden, jedoch muss dann sicher gestellt werden dass die Trigger, die die Zuordnung zu den Potentialflächen berechnen auch an die vorhandenen Tabellen angepasst werden.

 -- Layerdump aus kvwmap vom 07.09.2023 11:21:56
 -- Achtung: Die Datenbank in die der Dump eingespielt wird, sollte die gleiche Migrationsversion haben,
 -- wie die Datenbank aus der exportiert wurde! Anderenfalls kann es zu Fehlern bei der Ausführung des SQL kommen.
 SET @group_id = 1;
 SET @connection = ;
 SET @connection_id = '1';

 -- Layer 51
 INSERT INTO layer (`Name`, `alias`, `Datentyp`, `Gruppe`, `pfad`, `maintable`, `oid`, `Data`, `schema`, `document_path`, `tileindex`, `tileitem`, `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `connection_id`, `printconnection`, `connectiontype`, `classitem`, `tolerance`, `toleranceunits`, `sizeunits`, `epsg_code`, `template`, `queryable`, `transparency`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `ows_srs`, `wms_name`, `wms_server_version`, `wms_format`, `wms_connectiontimeout`, `wms_auth_username`, `wms_auth_password`, `wfs_geom`, `write_mapserver_templates`, `selectiontype`, `querymap`, `logconsume`, `processing`, `kurzbeschreibung`, `datasource`, `dataowner_name`, `dataowner_email`, `dataowner_tel`, `uptodateness`, `updatecycle`, `metalink`, `privileg`, `trigger_function`) VALUES ('Amtsverwaltungen', , '2', @group_id, 'SELECT\r\n  a.schllan,\r\n  a.land,\r\n  a.schlkrs,\r\n  a.kreis,\r\n  a.schlamt,\r\n  a.schlamt::integer AS stelleid,\r\n  a.amt,\r\n  a.amtsfrei,\r\n  round(ST_XMin(st_envelope(a.the_geom))) - 1000 as xmin,\r\n  round(ST_XMax(st_envelope(a.the_geom))) + 1000 as xmax,\r\n  round(ST_YMin(st_envelope(a.the_geom))) - 1000 as ymin,\r\n  round(ST_YMax(st_envelope(a.the_geom))) + 1000 as ymax,\r\n  s.id AS stelle_vorhanden,  \r\n  \'\' AS stelle_anlegen,\r\n  a.the_geom\r\nFROM\r\n  amtsverwaltungen AS a LEFT JOIN\r\n  fmk.stellen AS s ON a.schlamt::integer = s.id\r\nWHERE\r\n  true', 'amtsverwaltungen', 'schlamt', 'the_geom from (SELECT schlamt, amt, CASE WHEN amtsfrei THEN 1 ELSE 0 END AS amtsfrei, the_geom FROM verwaltungsgrenzen.amtsverwaltungen) as foo using unique schlamt using srid=25832', 'verwaltungsgrenzen', , , , , 'amt', '450000', NULL, , @connection, @connection_id, , '6', 'amtsfrei', '3', 'pixels', NULL, '25832', , '1', '60', '210', NULL, NULL, , 'EPSG:25832 EPSG:4326', , '1.0.0', 'image/png', '60', , , , , , '1', '0', , , '5', 'Landesamt für Vermessung und Geoinformation Schleswig-Holstein (LVermGeo SH)', , , , , , '0', );
 SET @last_layer_id51=LAST_INSERT_ID();

 -- Attribut amt des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'amt', 'amt', 'amtsverwaltungen', 'a', 'varchar', , , '1', '1', NULL, NULL, , 'Text', , 'Amt', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '24', '0', '1');

 -- Attribut amtsfrei des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'amtsfrei', 'amtsfrei', 'amtsverwaltungen', 'a', 'bool', , , '1', '0', NULL, NULL, 'false', 'Text', , , , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '13', '0', '0');

 -- Attribut kreis des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'kreis', 'kreis', 'amtsverwaltungen', 'a', 'varchar', , , '1', '1', NULL, NULL, , 'Text', , 'Kreis', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '20', '0', '1');

 -- Attribut land des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'land', 'land', 'amtsverwaltungen', 'a', 'varchar', , , '1', '1', NULL, NULL, , 'Text', , 'Land', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '11', '0', '0');

 -- Attribut schlamt des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'schlamt', 'schlamt', 'amtsverwaltungen', 'a', 'varchar', , 'PRIMARY KEY', '1', '0', '8', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '23', '0', '1');

 -- Attribut schlkrs des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'schlkrs', 'schlkrs', 'amtsverwaltungen', 'a', 'varchar', , , '1', '1', '5', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '21', '0', '0');

 -- Attribut schllan des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'schllan', 'schllan', 'amtsverwaltungen', 'a', 'varchar', , , '1', '1', NULL, NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '3', '0', '0');

 -- Attribut stelleid des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'stelleid', , , , 'int4', , , '0', NULL, NULL, NULL, , 'Text', , , , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '5', NULL, '0');

 -- Attribut stelle_anlegen des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'stelle_anlegen', , , , 'text', , , '0', NULL, NULL, NULL, , 'dynamicLink', 'index.php?go=Stelleneditor_Als neue Stelle eintragen&id=$stelleid&bezeichnung=$amt&Referenzkarte_ID=2&minxmax=$xmin&minymax=$ymin&maxxmax=$xmax&maxymax=$ymax&epsg_code=25832&default_user_id=6&selusers=1, 2, 4, 5&selparents=3&create_referencemap=1;Stelle anlegen;root', 'Stelle anlegen', , , , , , , '0', '0', NULL, '0', '0', NULL, '2', 'stelle_vorhanden', '=', , '30', NULL, '0');

 -- Attribut stelle_vorhanden des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'stelle_vorhanden', 'id', 'stellen', 's', 'int4', , , '1', '1', '32', '0', , 'dynamicLink', 'index.php?go=Stelleneditor&selected_stelle_id=$stelleid;Stelle vorhanden;root', 'Stelle vorhanden', , , , , , , '0', '0', NULL, '0', '0', NULL, '2', 'stelle_vorhanden', '!=', , '31', NULL, '0');

 -- Attribut the_geom des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'the_geom', 'the_geom', 'amtsverwaltungen', 'a', 'geometry', 'MULTIPOLYGON', , '1', '1', NULL, NULL, , 'Geometrie', , , , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '34', '0', '0');

 -- Attribut xmax des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'xmax', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'Ost', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '27', '0', '0');

 -- Attribut xmin des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'xmin', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'West', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '25', '0', '0');

 -- Attribut ymax des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'ymax', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'Nord', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '28', '0', '0');

 -- Attribut ymin des Layers 51
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id51, 'ymin', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'Süd', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '26', '0', '0');

 -- Class 204 des Layers 51
 INSERT INTO classes (`Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES ('Amtsangehörig', @last_layer_id51, '0', NULL, );
 SET @last_class_id=LAST_INSERT_ID();

 -- Style 129 der Class 204
 INSERT INTO styles (`symbol`, `symbolname`, `size`, `color`, `backgroundcolor`, `outlinecolor`, `colorrange`, `datarange`, `rangeitem`, `opacity`, `minsize`, `maxsize`, `minscale`, `maxscale`, `angle`, `angleitem`, `width`, `minwidth`, `maxwidth`, `offsetx`, `offsety`, `polaroffset`, `pattern`, `geomtransform`, `gap`, `initialgap`, `linecap`, `linejoin`, `linejoinmaxsize`) VALUES (NULL, , '1', '255 215 156', , '31 26 0', , , , NULL, , , NULL, NULL, , , '2', '2', '2', NULL, NULL, , , , NULL, NULL, , , NULL);
 SET @last_style_id=LAST_INSERT_ID();
 -- Zuordnung Style 129 zu Class 204
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

 -- Label 17 der Class 204
 INSERT INTO labels (`font`, `type`, `color`, `outlinecolor`, `shadowcolor`, `shadowsizex`, `shadowsizey`, `backgroundcolor`, `backgroundshadowcolor`, `backgroundshadowsizex`, `backgroundshadowsizey`, `size`, `minsize`, `maxsize`, `position`, `offsetx`, `offsety`, `angle`, `anglemode`, `buffer`, `minfeaturesize`, `maxfeaturesize`, `partials`, `wrap`, `the_force`) VALUES ('arial', NULL, , , , NULL, NULL, , , NULL, NULL, '10', '6', '12', '6', NULL, NULL, , NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 SET @last_label_id=LAST_INSERT_ID();
 -- Zuordnung Label 17 zu Class 204
 INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

 -- Class 217 des Layers 51
 INSERT INTO classes (`Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES ('Amtsfrei', @last_layer_id51, '1', '1', );
 SET @last_class_id=LAST_INSERT_ID();

 -- Style 144 der Class 217
 INSERT INTO styles (`symbol`, `symbolname`, `size`, `color`, `backgroundcolor`, `outlinecolor`, `colorrange`, `datarange`, `rangeitem`, `opacity`, `minsize`, `maxsize`, `minscale`, `maxscale`, `angle`, `angleitem`, `width`, `minwidth`, `maxwidth`, `offsetx`, `offsety`, `polaroffset`, `pattern`, `geomtransform`, `gap`, `initialgap`, `linecap`, `linejoin`, `linejoinmaxsize`) VALUES (NULL, , '6', '255 184 45', , '31 26 0', , , , NULL, , '8', NULL, NULL, '360', , '1.5', '1', '1', NULL, NULL, , , , NULL, NULL, , , NULL);
 SET @last_style_id=LAST_INSERT_ID();
 -- Zuordnung Style 144 zu Class 217
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

 -- Label 186 der Class 217
 INSERT INTO labels (`font`, `type`, `color`, `outlinecolor`, `shadowcolor`, `shadowsizex`, `shadowsizey`, `backgroundcolor`, `backgroundshadowcolor`, `backgroundshadowsizex`, `backgroundshadowsizey`, `size`, `minsize`, `maxsize`, `position`, `offsetx`, `offsety`, `angle`, `anglemode`, `buffer`, `minfeaturesize`, `maxfeaturesize`, `partials`, `wrap`, `the_force`) VALUES ('arial', NULL, , , , NULL, NULL, , , NULL, NULL, '10', '8', '12', '8', NULL, NULL, , NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 SET @last_label_id=LAST_INSERT_ID();
 -- Zuordnung Label 186 zu Class 217
 INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

 -- Layer 54
 INSERT INTO layer (`Name`, `alias`, `Datentyp`, `Gruppe`, `pfad`, `maintable`, `oid`, `Data`, `schema`, `document_path`, `tileindex`, `tileitem`, `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `connection_id`, `printconnection`, `connectiontype`, `classitem`, `tolerance`, `toleranceunits`, `sizeunits`, `epsg_code`, `template`, `queryable`, `transparency`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `ows_srs`, `wms_name`, `wms_server_version`, `wms_format`, `wms_connectiontimeout`, `wms_auth_username`, `wms_auth_password`, `wfs_geom`, `write_mapserver_templates`, `selectiontype`, `querymap`, `logconsume`, `processing`, `kurzbeschreibung`, `datasource`, `dataowner_name`, `dataowner_email`, `dataowner_tel`, `uptodateness`, `updatecycle`, `metalink`, `privileg`, `trigger_function`) VALUES ('Gemarkungen', , '2', @group_id, 'SELECT\r\n  land,\r\n  schllan,\r\n  kreis,\r\n  schlkrs,\r\n  amt,\r\n  schlamt,\r\n  gemeinde,\r\n  schlgmd,\r\n  gemarkung,\r\n  schlgmk,\r\n  the_geom\r\nFROM\r\n  gemarkungen\r\nWHERE\r\n  true', 'gemarkungen', 'schlgmk', 'the_geom from (SELECT schlgmk, \'Gemarkung: \' || gemarkung AS lable, gemarkung, the_geom FROM verwaltungsgrenzen.gemarkungen) as foo using unique schlgmk using srid=25832', 'verwaltungsgrenzen', , , , , 'lable', '50000', '5000', , @connection, @connection_id, , '6', 'schlgmk', '3', 'pixels', NULL, '25832', , '1', '100', '230', NULL, NULL, , 'EPSG:25832 EPSG:4326', , '1.0.0', 'image/png', '60', , , , , , '1', '0', , , '5', 'Landesamt für Vermessung und Geoinformation Schleswig-Holstein (LVermGeo SH)', , , , , , '0', );
 SET @last_layer_id54=LAST_INSERT_ID();

 -- Attribut amt des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'amt', 'amt', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '60', NULL, , 'Text', , 'Amt', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '18', '0', '1');

 -- Attribut gemarkung des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'gemarkung', 'gemarkung', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '35', NULL, , 'Text', , 'Gemarkung', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '22', '0', '1');

 -- Attribut gemeinde des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'gemeinde', 'gemeinde', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '35', NULL, , 'Text', , 'Gemeinde', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '20', '0', '1');

 -- Attribut kreis des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'kreis', 'kreis', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '35', NULL, , 'Text', , 'Kreis', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '16', '0', '1');

 -- Attribut land des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'land', 'land', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '20', NULL, , 'Text', , 'Land', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '1', '0', '0');

 -- Attribut schlamt des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'schlamt', 'schlamt', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '7', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '19', '0', '0');

 -- Attribut schlgmd des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'schlgmd', 'schlgmd', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '8', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '21', '0', '0');

 -- Attribut schlgmk des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'schlgmk', 'schlgmk', 'gemarkungen', 'gemarkungen', 'varchar', , 'PRIMARY KEY', '1', '0', '6', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '23', '0', '1');

 -- Attribut schlkrs des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'schlkrs', 'schlkrs', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '5', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '17', '0', '0');

 -- Attribut schllan des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'schllan', 'schllan', 'gemarkungen', 'gemarkungen', 'varchar', , , '1', '1', '2', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '15', '0', '0');

 -- Attribut the_geom des Layers 54
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id54, 'the_geom', 'the_geom', 'gemarkungen', 'gemarkungen', 'geometry', 'MULTIPOLYGON', , '1', '1', NULL, NULL, , 'Geometrie', , , , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '24', '0', '0');

 -- Class 207 des Layers 54
 INSERT INTO classes (`Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES (' ', @last_layer_id54, , NULL, );
 SET @last_class_id=LAST_INSERT_ID();

 -- Style 134 der Class 207
 INSERT INTO styles (`symbol`, `symbolname`, `size`, `color`, `backgroundcolor`, `outlinecolor`, `colorrange`, `datarange`, `rangeitem`, `opacity`, `minsize`, `maxsize`, `minscale`, `maxscale`, `angle`, `angleitem`, `width`, `minwidth`, `maxwidth`, `offsetx`, `offsety`, `polaroffset`, `pattern`, `geomtransform`, `gap`, `initialgap`, `linecap`, `linejoin`, `linejoinmaxsize`) VALUES (NULL, , '1', '-1 -1 -1', , '127 92 131', , , , NULL, , , NULL, NULL, , , '2', '2', '2', NULL, NULL, , , , NULL, NULL, , , NULL);
 SET @last_style_id=LAST_INSERT_ID();
 -- Zuordnung Style 134 zu Class 207
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

 -- Label 21 der Class 207
 INSERT INTO labels (`font`, `type`, `color`, `outlinecolor`, `shadowcolor`, `shadowsizex`, `shadowsizey`, `backgroundcolor`, `backgroundshadowcolor`, `backgroundshadowsizex`, `backgroundshadowsizey`, `size`, `minsize`, `maxsize`, `position`, `offsetx`, `offsety`, `angle`, `anglemode`, `buffer`, `minfeaturesize`, `maxfeaturesize`, `partials`, `wrap`, `the_force`) VALUES ('arial', NULL, , , , NULL, NULL, , , NULL, NULL, '8', '6', '10', '6', NULL, NULL, , NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 SET @last_label_id=LAST_INSERT_ID();
 -- Zuordnung Label 21 zu Class 207
 INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

 -- Layer 53
 INSERT INTO layer (`Name`, `alias`, `Datentyp`, `Gruppe`, `pfad`, `maintable`, `oid`, `Data`, `schema`, `document_path`, `tileindex`, `tileitem`, `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `connection_id`, `printconnection`, `connectiontype`, `classitem`, `tolerance`, `toleranceunits`, `sizeunits`, `epsg_code`, `template`, `queryable`, `transparency`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `ows_srs`, `wms_name`, `wms_server_version`, `wms_format`, `wms_connectiontimeout`, `wms_auth_username`, `wms_auth_password`, `wfs_geom`, `write_mapserver_templates`, `selectiontype`, `querymap`, `logconsume`, `processing`, `kurzbeschreibung`, `datasource`, `dataowner_name`, `dataowner_email`, `dataowner_tel`, `uptodateness`, `updatecycle`, `metalink`, `privileg`, `trigger_function`) VALUES ('Gemeinden', , '2', @group_id, 'SELECT\r\n  g.land,\r\n  g.schllan,\r\n  g.kreis,\r\n  g.schlkrs,\r\n  g.amt,\r\n  g.schlamt,\r\n  g.gemeinde,\r\n  g.schlgmd,\r\n  g.schlgmd::integer AS stelleid,\r\n  round(ST_XMin(st_envelope(g.the_geom))) - 1000 as xmin,\r\n  round(ST_XMax(st_envelope(g.the_geom))) + 1000 as xmax,\r\n  round(ST_YMin(st_envelope(g.the_geom))) - 1000 as ymin,\r\n  round(ST_YMax(st_envelope(g.the_geom))) + 1000 as ymax,\r\n  s.id AS stelle_vorhanden,\r\n  \'\' as stelle_anlegen,\r\n  g.the_geom\r\nFROM\r\n  gemeinden g LEFT JOIN\r\n  fmk.stellen s ON g.schlgmd::integer = s.id\r\nWHERE\r\n  true', 'gemeinden', 'schlgmd', 'the_geom from (SELECT schlgmd, gemeinde AS lable, gemeinde, the_geom FROM verwaltungsgrenzen.gemeinden) as foo using unique schlgmd using srid=25832', 'verwaltungsgrenzen', , , , , 'lable', '150000', '15000', , @connection, @connection_id, , '6', 'schlgmd', '3', 'pixels', NULL, '25832', , '1', '100', '240', NULL, NULL, , 'EPSG:25832 EPSG:4326', , '1.0.0', 'image/png', '60', , , , , , '1', '0', , 'ALKIS-Verwaltungsgrenzen bereitgestellt von Olaf Imkemeyer, Innenministerium Schleswig-Holstein für die Nutzung im FMK-Server', '5', 'Herr Olaf Imkemeyer', 'olaf.imkemeyer@im.landsh.de', ' +49 431/988 - 1834', 'Anfang Oktober 2022', , , '0', );
 SET @last_layer_id53=LAST_INSERT_ID();

 -- Attribut amt des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'amt', 'amt', 'gemeinden', 'g', 'varchar', , , '1', '1', '60', NULL, , 'Text', , 'Amt', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '28', '0', '1');

 -- Attribut gemeinde des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'gemeinde', 'gemeinde', 'gemeinden', 'g', 'varchar', , , '1', '1', '35', NULL, , 'Text', , 'Gemeinde', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '33', '0', '1');

 -- Attribut kreis des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'kreis', 'kreis', 'gemeinden', 'g', 'varchar', , , '1', '1', '35', NULL, , 'Text', , 'Kreis', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '24', '0', '1');

 -- Attribut land des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'land', 'land', 'gemeinden', 'g', 'varchar', , , '1', '1', '20', NULL, , 'Text', , 'Land', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '1', '0', '0');

 -- Attribut schlamt des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'schlamt', 'schlamt', 'gemeinden', 'g', 'varchar', , , '1', '1', '8', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '29', '0', '0');

 -- Attribut schlgmd des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'schlgmd', 'schlgmd', 'gemeinden', 'g', 'varchar', , 'PRIMARY KEY', '1', '0', '8', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '34', '0', '1');

 -- Attribut schlkrs des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'schlkrs', 'schlkrs', 'gemeinden', 'g', 'varchar', , , '1', '1', '5', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '25', '0', '0');

 -- Attribut schllan des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'schllan', 'schllan', 'gemeinden', 'g', 'varchar', , , '1', '1', '2', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '20', '0', '0');

 -- Attribut stelleid des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'stelleid', , , , 'int4', , , '0', NULL, NULL, NULL, , 'Text', , 'Stelle-ID', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '45', '0', '0');

 -- Attribut stelle_anlegen des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'stelle_anlegen', , , , 'text', , , '0', NULL, NULL, NULL, , 'dynamicLink', 'index.php?go=Stelleneditor_Als neue Stelle eintragen&id=$stelleid&bezeichnung=$gemeinde&Referenzkarte_ID=2&minxmax=$xmin&minymax=$ymin&maxxmax=$xmax&maxymax=$ymax&epsg_code=25832&default_user_id=5&selusers=1, 2, 4, 5&selparents=3&create_referencemap=1;Stelle anlegen;root', 'Stelle anlegen', , , , , , , '0', '0', NULL, '0', '0', NULL, '2', 'stelle_vorhanden', '=', , '53', '0', '0');

 -- Attribut stelle_vorhanden des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'stelle_vorhanden', 'id', 'stellen', 's', 'int4', , , '1', '1', '32', '0', , 'dynamicLink', 'index.php?go=Stelleneditor&selected_stelle_id=$stelleid;Stelle vorhanden;root', 'Stelle vorhanden', , , , , , , '0', '0', NULL, '0', '0', NULL, '2', 'stelle_vorhanden', '!=', , '54', '0', '0');

 -- Attribut the_geom des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'the_geom', 'the_geom', 'gemeinden', 'g', 'geometry', 'MULTIPOLYGON', , '1', '1', NULL, NULL, , 'Geometrie', , , , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '61', '0', '0');

 -- Attribut xmax des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'xmax', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'Süd', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '41', '0', '0');

 -- Attribut xmin des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'xmin', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'West', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '40', '0', '0');

 -- Attribut ymax des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'ymax', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'Nord', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '43', '0', '0');

 -- Attribut ymin des Layers 53
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id53, 'ymin', , , , 'float8', , , '0', NULL, NULL, NULL, , 'Text', , 'Ost', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '42', '0', '0');

 -- Class 206 des Layers 53
 INSERT INTO classes (`Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES (' ', @last_layer_id53, , NULL, );
 SET @last_class_id=LAST_INSERT_ID();

 -- Style 133 der Class 206
 INSERT INTO styles (`symbol`, `symbolname`, `size`, `color`, `backgroundcolor`, `outlinecolor`, `colorrange`, `datarange`, `rangeitem`, `opacity`, `minsize`, `maxsize`, `minscale`, `maxscale`, `angle`, `angleitem`, `width`, `minwidth`, `maxwidth`, `offsetx`, `offsety`, `polaroffset`, `pattern`, `geomtransform`, `gap`, `initialgap`, `linecap`, `linejoin`, `linejoinmaxsize`) VALUES (NULL, , '1', '-1 -1 -1', , '4 0 16', , , , NULL, , , NULL, NULL, , , '1', '1', '1', NULL, NULL, , , , NULL, NULL, 'square', , NULL);
 SET @last_style_id=LAST_INSERT_ID();
 -- Zuordnung Style 133 zu Class 206
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

 -- Label 20 der Class 206
 INSERT INTO labels (`font`, `type`, `color`, `outlinecolor`, `shadowcolor`, `shadowsizex`, `shadowsizey`, `backgroundcolor`, `backgroundshadowcolor`, `backgroundshadowsizex`, `backgroundshadowsizey`, `size`, `minsize`, `maxsize`, `position`, `offsetx`, `offsety`, `angle`, `anglemode`, `buffer`, `minfeaturesize`, `maxfeaturesize`, `partials`, `wrap`, `the_force`) VALUES ('arial', NULL, '125 125 125', , , NULL, NULL, , , NULL, NULL, '10', '6', '8', '8', NULL, NULL, , NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 SET @last_label_id=LAST_INSERT_ID();
 -- Zuordnung Label 20 zu Class 206
 INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

 -- Layer 52
 INSERT INTO layer (`Name`, `alias`, `Datentyp`, `Gruppe`, `pfad`, `maintable`, `oid`, `Data`, `schema`, `document_path`, `tileindex`, `tileitem`, `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `connection_id`, `printconnection`, `connectiontype`, `classitem`, `tolerance`, `toleranceunits`, `sizeunits`, `epsg_code`, `template`, `queryable`, `transparency`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `ows_srs`, `wms_name`, `wms_server_version`, `wms_format`, `wms_connectiontimeout`, `wms_auth_username`, `wms_auth_password`, `wfs_geom`, `write_mapserver_templates`, `selectiontype`, `querymap`, `logconsume`, `processing`, `kurzbeschreibung`, `datasource`, `dataowner_name`, `dataowner_email`, `dataowner_tel`, `uptodateness`, `updatecycle`, `metalink`, `privileg`, `trigger_function`) VALUES ('Landkreise', , '2', @group_id, 'SELECT\r\n  schllan,\r\n  land,\r\n  schlkrs,\r\n  kreis,\r\n  the_geom\r\nFROM\r\n  landkreise\r\nWHERE\r\n  true', 'landkreise', 'schlkrs', 'the_geom from (SELECT schlkrs, \'Landkreis: \' || kreis AS lable, kreis, the_geom FROM verwaltungsgrenzen.landkreise) as foo using unique schlkrs using srid=25832', 'verwaltungsgrenzen', , , , , 'kreis', '700000', '70000', , @connection, @connection_id, , '6', 'schlkrs', '3', 'pixels', NULL, '25832', , '1', '100', '250', NULL, NULL, , 'EPSG:25832 EPSG:4326', , '1.0.0', 'image/png', '60', , , , , , '1', '0', , , '5', 'Landesamt für Vermessung und Geoinformation Schleswig-Holstein (LVermGeo SH)', , , , , , '0', );
 SET @last_layer_id52=LAST_INSERT_ID();

 -- Attribut kreis des Layers 52
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id52, 'kreis', 'kreis', 'landkreise', 'landkreise', 'varchar', , , '1', '1', '35', NULL, , 'Text', , 'Kreis', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '19', '0', '1');

 -- Attribut land des Layers 52
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id52, 'land', 'land', 'landkreise', 'landkreise', 'varchar', , , '1', '1', '20', NULL, , 'Text', , 'Land', , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '11', '0', '0');

 -- Attribut schlkrs des Layers 52
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id52, 'schlkrs', 'schlkrs', 'landkreise', 'landkreise', 'varchar', , 'PRIMARY KEY', '1', '0', '5', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '21', '0', '1');

 -- Attribut schllan des Layers 52
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id52, 'schllan', 'schllan', 'landkreise', 'landkreise', 'varchar', , , '1', '1', '2', NULL, , 'Text', , 'Schlüssel', , , , , , , '1', '0', NULL, '0', '0', NULL, '1', , , , '2', '0', '0');

 -- Attribut the_geom des Layers 52
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id52, 'the_geom', 'the_geom', 'landkreise', 'landkreise', 'geometry', 'MULTIPOLYGON', , '1', '1', NULL, NULL, , 'Geometrie', , , , , , , , , '0', '0', NULL, '0', '0', NULL, '1', , , , '22', '0', '0');

 -- Class 205 des Layers 52
 INSERT INTO classes (`Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES (' ', @last_layer_id52, , NULL, );
 SET @last_class_id=LAST_INSERT_ID();

 -- Style 132 der Class 205
 INSERT INTO styles (`symbol`, `symbolname`, `size`, `color`, `backgroundcolor`, `outlinecolor`, `colorrange`, `datarange`, `rangeitem`, `opacity`, `minsize`, `maxsize`, `minscale`, `maxscale`, `angle`, `angleitem`, `width`, `minwidth`, `maxwidth`, `offsetx`, `offsety`, `polaroffset`, `pattern`, `geomtransform`, `gap`, `initialgap`, `linecap`, `linejoin`, `linejoinmaxsize`) VALUES (NULL, , '1', '-1 -1 -1', , '4 0 16', , , , NULL, , , NULL, NULL, , , '1.5', '2', '2', NULL, NULL, , , , NULL, NULL, , , NULL);
 SET @last_style_id=LAST_INSERT_ID();
 -- Zuordnung Style 132 zu Class 205
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);

 -- Label 19 der Class 205
 INSERT INTO labels (`font`, `type`, `color`, `outlinecolor`, `shadowcolor`, `shadowsizex`, `shadowsizey`, `backgroundcolor`, `backgroundshadowcolor`, `backgroundshadowsizex`, `backgroundshadowsizey`, `size`, `minsize`, `maxsize`, `position`, `offsetx`, `offsety`, `angle`, `anglemode`, `buffer`, `minfeaturesize`, `maxfeaturesize`, `partials`, `wrap`, `the_force`) VALUES ('arial', NULL, , , , NULL, NULL, , , NULL, NULL, '12', '10', '14', '8', NULL, NULL, , NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 SET @last_label_id=LAST_INSERT_ID();
 -- Zuordnung Label 19 zu Class 205
 INSERT INTO u_labels2classes (label_id, class_id) VALUES (@last_label_id, @last_class_id);

 -- Layer 92
 INSERT INTO layer (`Name`, `alias`, `Datentyp`, `Gruppe`, `pfad`, `maintable`, `oid`, `Data`, `schema`, `document_path`, `tileindex`, `tileitem`, `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `connection_id`, `printconnection`, `connectiontype`, `classitem`, `tolerance`, `toleranceunits`, `sizeunits`, `epsg_code`, `template`, `queryable`, `transparency`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `ows_srs`, `wms_name`, `wms_server_version`, `wms_format`, `wms_connectiontimeout`, `wms_auth_username`, `wms_auth_password`, `wfs_geom`, `write_mapserver_templates`, `selectiontype`, `querymap`, `logconsume`, `processing`, `kurzbeschreibung`, `datasource`, `dataowner_name`, `dataowner_email`, `dataowner_tel`, `uptodateness`, `updatecycle`, `metalink`, `privileg`, `trigger_function`) VALUES ('Ortsteile', , '5', @group_id, 'SELECT\r\n   ortsteil_id, bezeichnung, stelle_id\r\nFROM\r\n  ortsteile   \r\nWHERE\r\n  stelle_id = $stelle_id', 'ortsteile', 'ortsteil_id', , 'verwaltungsgrenzen', , , , , , NULL, NULL, , @connection, @connection_id, , '6', , '3', 'pixels', NULL, '25832', , '1', NULL, '0', NULL, NULL, , 'EPSG:25832 EPSG:4326', , '1.0.0', 'image/png', '60', , , , , , '1', '0', , , '5', 'Landesamt für Vermessung und Geoinformation Schleswig-Holstein (LVermGeo SH)', , , , , , '2', );
 SET @last_layer_id92=LAST_INSERT_ID();

 -- Attribut bezeichnung des Layers 92
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id92, 'bezeichnung', 'bezeichnung', 'ortsteile', 'ortsteile', 'varchar', , , '1', '0', NULL, NULL, , 'Text', , 'Stadt-/Ortsteil', , , , , , , '0', '0', NULL, '1', '0', NULL, '1', , , , '2', '1', '0');

 -- Attribut ortsteil_id des Layers 92
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id92, 'ortsteil_id', 'ortsteil_id', 'ortsteile', 'ortsteile', 'int4', , 'PRIMARY KEY', '1', '1', '32', '0', , 'Text', , 'ID', , , , , , , '0', '0', NULL, '0', '0', NULL, '0', , , , '1', '0', '0');

 -- Attribut stelle_id des Layers 92
 INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `saveable`, `nullable`, `length`, `decimal_length`, `default`, `form_element_type`, `options`, `alias`, `alias_low-german`, `alias_english`, `alias_polish`, `alias_vietnamese`, `tooltip`, `group`, `arrangement`, `labeling`, `raster_visibility`, `dont_use_for_new`, `mandatory`, `quicksearch`, `visible`, `vcheck_attribute`, `vcheck_operator`, `vcheck_value`, `order`, `privileg`, `query_tooltip`) VALUES (@last_layer_id92, 'stelle_id', 'stelle_id', 'ortsteile', 'ortsteile', 'int4', , , '1', '0', '32', '0', , 'StelleID', , 'Stelle_ID', , , , , , , '0', '0', NULL, '0', '0', NULL, '0', , , , '3', '0', '0');

 -- Replace attribute options for Layer 51
 UPDATE layer_attributes SET options = REPLACE(options, 'layer_id=51', CONCAT('layer_id=', @last_layer_id51)) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('Autovervollständigungsfeld', 'Auswahlfeld', 'Link','dynamicLink');
 UPDATE layer_attributes SET options = REPLACE(options, '51,', CONCAT(@last_layer_id51, ',')) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

 -- Replace attribute options for Layer 54
 UPDATE layer_attributes SET options = REPLACE(options, 'layer_id=54', CONCAT('layer_id=', @last_layer_id54)) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('Autovervollständigungsfeld', 'Auswahlfeld', 'Link','dynamicLink');
 UPDATE layer_attributes SET options = REPLACE(options, '54,', CONCAT(@last_layer_id54, ',')) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

 -- Replace attribute options for Layer 53
 UPDATE layer_attributes SET options = REPLACE(options, 'layer_id=53', CONCAT('layer_id=', @last_layer_id53)) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('Autovervollständigungsfeld', 'Auswahlfeld', 'Link','dynamicLink');
 UPDATE layer_attributes SET options = REPLACE(options, '53,', CONCAT(@last_layer_id53, ',')) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

 -- Replace attribute options for Layer 52
 UPDATE layer_attributes SET options = REPLACE(options, 'layer_id=52', CONCAT('layer_id=', @last_layer_id52)) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('Autovervollständigungsfeld', 'Auswahlfeld', 'Link','dynamicLink');
 UPDATE layer_attributes SET options = REPLACE(options, '52,', CONCAT(@last_layer_id52, ',')) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

 -- Replace attribute options for Layer 92
 UPDATE layer_attributes SET options = REPLACE(options, 'layer_id=92', CONCAT('layer_id=', @last_layer_id92)) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('Autovervollständigungsfeld', 'Auswahlfeld', 'Link','dynamicLink');
 UPDATE layer_attributes SET options = REPLACE(options, '92,', CONCAT(@last_layer_id92, ',')) WHERE layer_id IN (@last_layer_id51, @last_layer_id54, @last_layer_id53, @last_layer_id52, @last_layer_id92) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK');

GLE-Layer-FMK-Verwaltungsgrenzen

SQL-Dump der in kvwmap für die Fachschale FMK benötigten Layer, Klassen, Attribute, Labels, Styles und Drucklayouts für die Verwaltungsgrenzen

Navigationsmenü

Meine Werkzeuge

Namensräume

Varianten

Ansichten

Aktionen

Suche

Dokumentation

Foren

Community

Extras

Werkzeuge