Mercurial > gemma

view schema/demo-data/users.sql @ 1158:da75faa8043f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added central moveMap method to pan and zoom the map on certain events it was requested to prevent zooming out if the zoomlevel is already higher then the desired default zoom (for certain zoom/pan targets) so there's a parameter preventZoomOut which, if set to true, lets this method only zoom in but not out.
author Markus Kottlaender <markus@intevation.de>
date Tue, 13 Nov 2018 14:22:35 +0100
parents be38eec5cc25
children 50dd4ff7907e
line wrap: on
line source

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(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
David Wagner	AT	wagner@example.com	BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
Dipl.-Inform. Stefan-Albert Zimmermann	AT	zimmermann@example.com	BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
Johanna Pichler	AT	pichler@example.com	BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
Katharina Gruber	AT	gruber@example.com	BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
Maximilian Wimmer	AT	wimmer@example.com	BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
oana	HR	oana@example.com	BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001)
Christina Kovačević	HR	kovacevic@example.com	BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001)
Ivo Marković	HR	markovic@example.com	BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001)
Leonard Vuković	HR	vukovic@example.com	BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001)
Neven Novak	HR	novak@example.com	BOX(13.5014754570001 42.4163272160001,19.4078381750001 46.5469790650001)
lucian	RO	lucian@example.com	BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
Elena Popescu	RO	popescu@example.com	BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
Eugen Munteanu	RO	munteanu@example.com	BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
Gabriela Gheorghe	RO	gheorghe@example.com	BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
Marina Stoica	RO	stoica@example.com	BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
penka	BG	penka@example.com	BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
Борис Даманиов	BG	daimanov@example.com	BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
Фидан Дубарова	BG	dubarova@example.com	BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
Дипл. Инж. Константин yasenov	BG	ясенов@example.com	BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
Люба Ходкивич	BG	hodkiewicz@example.com	BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
Andrej Kovačič	SK	kovacic@example.com	BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684)
Milana Božič	SK	bozic@example.com	BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684)
Vladislav Zupančič	SK	zupancic@example.com	BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684)
Zuzanna Korošec	SK	korosec@example.com	BOX(16.8444804280001 47.7500064090001,22.5396366780001 49.601779684)
\.

COMMIT;