Mercurial > gemma
view schema/demo-data/users.sql @ 1548:ccf4fc8a6402
Import queue: Give milliseconds in JSON output, too.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 10 Dec 2018 16:49:34 +0100 |
parents | 50dd4ff7907e |
children | 26c806f1684d |
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(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;