Mercurial > gemma

comparison schema/tap_tests_data.sql @ 5515:751a0f5da294

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixup rev. 8797274e2739: Adapt test data
author Tom Gottfried <tom@intevation.de>
date Tue, 19 Oct 2021 14:53:25 +0200
parents 147a2585e136
children
comparison
equal deleted inserted replaced
5514:147a2585e136 5515:751a0f5da294
50 true 50 true
51 ) RETURNING id, objnam) 51 ) RETURNING id, objnam)
52 INSERT INTO users.stretch_countries SELECT id, objnam FROM insert_st; 52 INSERT INTO users.stretch_countries SELECT id, objnam FROM insert_st;
53 53
54 INSERT INTO users.list_users VALUES ( 54 INSERT INTO users.list_users VALUES (
55 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx', false); 55 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx', false, true);
56 INSERT INTO users.list_users VALUES ( 56 INSERT INTO users.list_users VALUES (
57 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy', false); 57 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy', false, true);
58 INSERT INTO users.list_users VALUES ( 58 INSERT INTO users.list_users VALUES (
59 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy', false); 59 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy', false, true);
60 INSERT INTO users.list_users VALUES ( 60 INSERT INTO users.list_users VALUES (
61 'waterway_admin', 'test_admin_at2', 'admin_at2$', 'AT', NULL, 'yyy', false); 61 'waterway_admin', 'test_admin_at2', 'admin_at2$', 'AT', NULL, 'yyy', false, true);
62 INSERT INTO users.list_users VALUES ( 62 INSERT INTO users.list_users VALUES (
63 'waterway_admin', 'test_admin_ro', 'admin_ro1$', 'RO', NULL, 'yyx', false); 63 'waterway_admin', 'test_admin_ro', 'admin_ro1$', 'RO', NULL, 'yyx', false, true);
64 INSERT INTO users.list_users VALUES ( 64 INSERT INTO users.list_users VALUES (
65 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz', false); 65 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz', false, true);
66 66
67 INSERT INTO limiting_factors VALUES ('depth'), ('width'); 67 INSERT INTO limiting_factors VALUES ('depth'), ('width');
68 68
69 WITH 69 WITH
70 gs AS ( 70 gs AS (