GLE-Layer-Jagdkataster

EJB Verdachtsflächen

 SET @group_id = 1;
 SET @connection = 'user=xxxx password=xxxx dbname=kvwmapsp';
 
 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`) VALUES('EJB Verdachtsflächen','','2',@group_id,'SELECT oid, eigentuemer, flaeche, the_geom FROM lk_ejb_verdachtsflaechen WHERE 1=1','lk_ejb_verdachtsflaechen','the_geom from alkis.lk_ejb_verdachtsflaechen using unique oid using srid=25833','alkis','','','','','','100001','399','',@connection,'','6','oid','oid','3','pixels','25833','','1','70','30091','99','600001','','EPSG:25833','','1.1.0','image/png','60','','','','','1','1','','','untere Jagdbehörde','','0');
 SET @last_layer_id50303096=LAST_INSERT_ID();
 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`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303096,'eigentuemer','eigentuemer','lk_ejb_verdachtsflaechen','lk_ejb_verdachtsflaechen','text','','','1',NULL,NULL,'','Textfeld','','Eigentümer','','','','','','',NULL,NULL,'1','0','1');
 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`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303096,'flaeche','flaeche','lk_ejb_verdachtsflaechen','lk_ejb_verdachtsflaechen','float8','','','1','53',NULL,'','Zahl','','Fläche (ca.) [m²]','','','','','','',NULL,NULL,'2','0','1');
 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`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303096,'oid','oid','','','oid','','',NULL,NULL,NULL,'','Text','','','','','','','','',NULL,NULL,'0',NULL,'0');
 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`,`raster_visibility`,`mandatory`,`order`,`privileg`,`query_tooltip`) VALUES(@last_layer_id50303096,'the_geom','the_geom','lk_ejb_verdachtsflaechen','lk_ejb_verdachtsflaechen','geometry','POLYGON','','1',NULL,NULL,'','Geometrie','','','','','','','','',NULL,NULL,'3','0','0');
 INSERT INTO classes (`Name`,`Layer_ID`,`Expression`,`drawingorder`,`text`) VALUES('',@last_layer_id50303096,'','1','');
 SET @last_class_id=LAST_INSERT_ID();
 INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','5','196 215 241','','-1 -1 -1',NULL,NULL,'','',NULL,NULL,NULL,NULL,'');
  SET @last_style_id=LAST_INSERT_ID();
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 0);
 INSERT INTO styles (`symbol`,`symbolname`,`size`,`color`,`backgroundcolor`,`outlinecolor`,`minsize`,`maxsize`,`angle`,`angleitem`,`antialias`,`width`,`minwidth`,`maxwidth`,`sizeitem`) VALUES(NULL,'','','-1 -1 -1','','255 73 46',NULL,NULL,'','',NULL,'4','1','6','');
  SET @last_style_id=LAST_INSERT_ID();
 INSERT INTO u_styles2classes (style_id, class_id, drawingorder) VALUES (@last_style_id, @last_class_id, 1);
 
 UPDATE layer_attributes SET options = REPLACE(options, '50303058', @last_layer_id50303058) WHERE layer_id IN(@last_layer_id50303058, @last_layer_id50303096) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');
 UPDATE layer_attributes SET options = REPLACE(options, '50303096', @last_layer_id50303096) WHERE layer_id IN(@last_layer_id50303058, @last_layer_id50303096) AND form_element_type IN ('SubFormPK', 'SubFormFK', 'SubFormEmbeddedPK', 'Autovervollständigungsfeld', 'Auswahlfeld');