Mercurial > gemma
view schema/demo-data/users.sql @ 345:b97b3172c61a
Add staging feature to more tables
Added tables currently only have limited visibility for waterway_user
but not yet policies for write access.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 06 Aug 2018 15:19:05 +0200 |
parents | 72062ca52746 |
children | 46a80016293c |
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) 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;