Mercurial > gemma

view schema/demo-data/users.sql @ 234:55dce2f649bc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Allow using the same email-address for multiple users This can be useful at least in testing scenarios, where one person wants to have multiple accounts with different roles and there is no other reason to enforce uniqueness.
author Tom Gottfried <tom@intevation.de>
date Thu, 26 Jul 2018 15:10:22 +0200
parents 531d1f8a2b4b
children 72062ca52746
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_address, 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;