Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
211:e7826710d9c4 212:229f385448fa
3 -- PREREQUISITES: 3 -- PREREQUISITES:
4 -- Cluster has roles as created by roles.sql, 4 -- Cluster has roles as created by roles.sql,
5 -- responsibility areas from responsibility_areas.sql are imported 5 -- responsibility areas from responsibility_areas.sql are imported
6 6
7 -- Fill in Profiles 7 -- Fill in Profiles
8 COPY users.user_profiles (username, country, email_adress) FROM stdin; 8 COPY users.user_profiles (username, country, email_adress, map_extent) FROM stdin;
9 sophie AT sophie@example.com 9 sophie AT sophie@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)
10 lucian RO lucian@example.com 10 lucian RO lucian@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
11 oana RO oana@example.com 11 oana RO oana@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)
12 penka BG penka@example.com 12 penka BG penka@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
13 vanja BG vanja@example.com 13 vanja BG vanja@example.com BOX(22.3450232340001 41.238104147,28.6035262380001 44.228434539)
14 \. 14 \.
15 15
16 COMMIT; 16 COMMIT;