-- 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;