GLE-Layer-Nutzerhinweise

SET @group_id = 1;
SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';

-- Layer 1003
INSERT INTO layer (`Name`, `alias`, `Datentyp`, `Gruppe`, `pfad`, `maintable`, `Data`, `schema`, `document_path`, `tileindex`, `tileitem`, `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `printconnection`, `connectiontype`, `classitem`, `filteritem`, `tolerance`, `toleranceunits`, `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`, `selectiontype`, `querymap`, `logconsume`, `processing`, `kurzbeschreibung`, `datenherr`, `metalink`, `privileg`, `trigger_function`, `sync`) VALUES ('Nutzer-Hinweise', '', '5', @group_id, 'SELECT hinweis, startdatum, dauer,  (startdatum + (dauer::text||\' day\')::INTERVAL - \'1 day\'::interval)::date AS angezeigt_bis, created_at, nutzer, stelle_id FROM hinweise WHERE 1=1', 'hinweise', '', '', '', '', '', '', '', NULL, NULL, '', @connection, '', '6', '', '', '3', 'pixels', '2398', '', '1', NULL, NULL, NULL, NULL, '', 'EPSG:2398', '', '1.1.0', 'image/png', '60', '', '', '', '', '0', '0', '', '', '', '', '0', '', '0');
SET @last_layer_id1003=LAST_INSERT_ID();

-- Attribut angezeigt_bis des Layers 1003
INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `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_id1003, 'angezeigt_bis', '', '', '', 'not_saveable', '', '', NULL, NULL, NULL, '', 'Text', '', 'Enddatum', '', '', '', '', 'Tag an dem der Hinweis zum letzten Mal angezeigt werden soll.', '', '0', '0', NULL, '0', '0', NULL, '1', '', '', '', '3', '0', '0');

-- Attribut created_at des Layers 1003
INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `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_id1003, 'created_at', 'created_at', 'hinweise', 'hinweise', 'timestamp', '', '', '0', NULL, NULL, 'SELECT now()', 'Text', '', 'angelegt am', '', '', '', '', '', '', '0', '0', NULL, '0', '0', NULL, '1', '', '', '', '4', '0', '0');

-- Attribut dauer des Layers 1003
INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `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_id1003, 'dauer', 'dauer', 'hinweise', 'hinweise', 'int4', '', '', '0', '32', '0', 'SELECT 2', 'Text', '', 'Dauer', '', '', '', '', 'Die Anzahl der Tage für die der Hinweis angezeigt werden soll, einschließlich des ersten Tages.', '', '0', '0', NULL, '0', '0', NULL, '1', '', '', '', '2', '0', '0');

-- Attribut hinweis des Layers 1003
INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `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_id1003, 'hinweis', 'hinweis', 'hinweise', 'hinweise', 'text', '', '', '1', NULL, NULL, '', 'Textfeld', '', 'Hinweistext', '', '', '', '', '', '', '0', '0', NULL, '0', '0', NULL, '1', '', '', '', '0', '0', '0');

-- Attribut nutzer des Layers 1003
INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `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_id1003, 'nutzer', 'nutzer', 'hinweise', 'hinweise', 'varchar', '', '', '1', '50', NULL, '', 'User', '', 'von', '', '', '', '', '', '', '1', '0', NULL, '0', '0', NULL, '1', '', '', '', '5', '0', '0');

-- Attribut startdatum des Layers 1003
INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `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_id1003, 'startdatum', 'startdatum', 'hinweise', 'hinweise', 'date', '', '', '0', NULL, NULL, 'SELECT (\'now\'::text)::date', 'Text', '', 'Startdatum', '', '', '', '', 'Das Datum an dem der Hinweis zum ersten Mal angezeigt werden soll.
Ein Doppelklick auf das Kalendersymbol übernimmt das aktuelle Datum.', '', '0', '0', NULL, '0', '0', NULL, '1', '', '', '', '1', '0', '0');

-- Attribut stelle_id des Layers 1003
INSERT INTO layer_attributes (`layer_id`, `name`, `real_name`, `tablename`, `table_alias_name`, `type`, `geometrytype`, `constraints`, `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_id1003, 'stelle_id', 'stelle_id', 'hinweise', 'hinweise', 'int4', '', '', '1', '32', '0', '', 'StelleID', '', 'in Stelle', '', '', '', '', '', '', '1', '0', NULL, '0', '0', NULL, '1', '', '', '', '6', '0', '0');