Mercurial > gemma

comparison schema/tap_tests_data.sql @ 5514:147a2585e136

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixup rev. eec88a166251: Adapt test data
author Tom Gottfried <tom@intevation.de>
date Tue, 19 Oct 2021 14:47:48 +0200
parents 4c658a8f34da
children 751a0f5da294
comparison
equal deleted inserted replaced
5513:68358e4603c8 5514:147a2585e136
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'); 55 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx', false);
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'); 57 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy', false);
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'); 59 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy', false);
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'); 61 'waterway_admin', 'test_admin_at2', 'admin_at2$', 'AT', NULL, 'yyy', false);
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'); 63 'waterway_admin', 'test_admin_ro', 'admin_ro1$', 'RO', NULL, 'yyx', false);
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'); 65 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz', false);
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 (