view schema/demo-data/users.sql @ 3678:8f58851927c0

client: make layer factory only return new layer config for individual maps instead of each time it is invoked. The purpose of the factory was to support multiple maps with individual layers. But returning a new config each time it is invoked leads to bugs that rely on the layer's state. Now this factory reuses the same objects it created before, per map.
author Markus Kottlaender <markus@intevation.de>
date Mon, 17 Jun 2019 17:31:35 +0200
parents 1c8de1c695cd
children
line wrap: on
line source

-- This is Free Software under GNU Affero General Public License v >= 3.0
-- without warranty, see README.md and license for details.

-- SPDX-License-Identifier: AGPL-3.0-or-later
-- License-Filename: LICENSES/AGPL-3.0.txt

-- Copyright (C) 2018 by via donau
--   – Österreichische Wasserstraßen-Gesellschaft mbH
-- Software engineering by Intevation GmbH

-- Author(s):
--  * Sascha Wilde <sascha.wilde@intevation.de>
--  * Christine Tschuprine <christine.tschuprine@intevation.de>
--  * Thomas Junk <thomas.junk@intevation.de>
--  * Tom Gottfried <tom@intevation.de>

BEGIN;

-- PREREQUISITES:
-- Cluster has roles as created by roles.sql,
-- responsibility areas from responsibility_areas.sql are imported

-- Fill in Profiles
COPY internal.user_profiles (username, country, email_address, map_extent) FROM stdin;
sophie	AT	sophie@example.com	BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158)
David Wagner	AT	wagner@example.com	BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158)
Dipl.-Inform. Stefan-Albert Zimmermann	AT	zimmermann@example.com	BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158)
JohannaPichler	AT	pichler@example.com	BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158)
Katharina Gruber	AT	gruber@example.com	BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158)
Maximilian Wimmer	AT	wimmer@example.com	BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158)
oana	HR	oana@example.com	BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413)
Christina Kovačević	HR	kovacevic@example.com	BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413)
Ivo Marković	HR	markovic@example.com	BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413)
Leonard Vuković	HR	vukovic@example.com	BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413)
Neven Novak	HR	novak@example.com	BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413)
lucian	RO	lucian@example.com	BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414)
Elena Popescu	RO	popescu@example.com	BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414)
Eugen Munteanu	RO	munteanu@example.com	BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414)
Gabriela Gheorghe	RO	gheorghe@example.com	BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414)
Marina Stoica	RO	stoica@example.com	BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414)
penka	BG	penka@example.com	BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666)
БорисДаманиов	BG	daimanov@example.com	BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666)
Фидан Дубарова	BG	dubarova@example.com	BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666)
Дипл. Инж. Константин Ясенов	BG	ясенов@example.com	BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666)
Люба Ходкивич	BG	hodkiewicz@example.com	BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666)
Andrej Kovačič	SK	kovacic@example.com	BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655)
Milana Božič	SK	bozic@example.com	BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655)
Vladislav Zupančič	SK	zupancic@example.com	BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655)
Zuzanna Korošec	SK	korosec@example.com	BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655)
Željko Popović	RS	popovic@example.com	BOX(18.7894254872172 44.1967324599651,22.8013676181007 46.1777657959295)
Boglárka Halász	HU	halasz@example.com	BOX(18.3430934844849 45.8985837545336,19.1439011951023 47.828792632158)
wwadm-at	AT	wwadm-at@example.com	BOX(13.4292771034607 48.0932697732137,17.0665467715356 48.6000136289158)
wwadm-sk	SK	wwadm-sk@example.com	BOX(17.0513974744621 47.7210081090549,18.3573141684446 48.1564918736655)
wwadm-hu	HU	wwadm-hu@example.com	BOX(18.3430934844849 45.8985837545336,19.1439011951023 47.828792632158)
wwadm-hr	HR	wwadm-hr@example.com	BOX(18.7894254872172 45.2151833810119,19.4148859308035 45.9187395678413)
wwadm-rs	RS	wwadm-rs@example.com	BOX(18.7894254872172 44.1967324599651,22.8013676181007 46.1777657959295)
wwadm-ro	RO	wwadm-ro@example.com	BOX(22.6449178570838 43.6582065599625,24.7374359404622 44.2424516801414)
wwadm-bg	BG	wwadm-bg@example.com	BOX(24.7333785334023 43.5838590157115,29.8261453141563 45.4968764910666)
\.

COMMIT;