Mercurial > gemma

view schema/demo-data/users.sql @ 212:229f385448fa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make map extent mandatory The extent of the countries responsibility area seems a reasonable default.
author Tom Gottfried <tom@intevation.de>
date Mon, 23 Jul 2018 17:41:31 +0200
parents e7826710d9c4
children 531d1f8a2b4b
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 users.user_profiles (username, country, email_adress, map_extent) FROM stdin;
sophie	AT	sophie@example.com	BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
lucian	RO	lucian@example.com	BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
oana	RO	oana@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)
vanja	BG	vanja@example.com	BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
\.

COMMIT;