<commit_before>--
-- $Id: POSTGRESQL.sql,v 1.1.2.45 2004-09-13 12:16:16 dan Exp $
--
-- Copyright (c) 1998-2003 DVL Software Limited
--

--
-- users, groups, permissions for postgresql
--

--
-- for the http server
--


-- DO THIS BEFORE YOU LOAD THE DATA

create group www;
create user www with password 'password';

alter group www add user www;




-- DO THIS AFTER YOU LOAD THE DATA
--
-- select access only
--
grant select on commit_log                     to group www;
grant select on commit_log_elements            to group www;
grant select on commit_log_port_elements       to group www;
grant select on commit_log_ports_elements      to group www;
grant select on commit_log_ports               to group www;
grant select on commit_log_ports_ignore        to group www;
grant select on latest_commits_ports           to group www;
grant select on element                        to group www;
grant select on element_revision               to group www;
grant select on ports                          to group www;
grant select on ports_categories               to group www;
grant select on ports_active                   to group www;
grant select on ports_all                      to group www;
grant select on ports_moved                    to group www;
grant select on ports_updating                 to group www;
grant select on ports_updating_ports_xref      to group www;
grant select on system                         to group www;
grant select on system_branch                  to group www;
grant select on system_branch_element_revision to group www;
grant select on tasks                          to group www;
grant select on user_tasks                     to group www;

grant select on commit_log_ports_vuxml         to group www;
grant select on vuxml                          to group www;
<commit_msg>Give select permission on vuxml_affected and vuxml_names to group www so www/vuxml.php can work.<commit_after>--
-- $Id: POSTGRESQL.sql,v 1.1.2.46 2004-09-28 03:25:45 dan Exp $
--
-- Copyright (c) 1998-2003 DVL Software Limited
--

--
-- users, groups, permissions for postgresql
--

--
-- for the http server
--


-- DO THIS BEFORE YOU LOAD THE DATA

create group www;
create user www with password 'password';

alter group www add user www;




-- DO THIS AFTER YOU LOAD THE DATA
--
-- select access only
--
grant select on commit_log                     to group www;
grant select on commit_log_elements            to group www;
grant select on commit_log_port_elements       to group www;
grant select on commit_log_ports_elements      to group www;
grant select on commit_log_ports               to group www;
grant select on commit_log_ports_ignore        to group www;
grant select on latest_commits_ports           to group www;
grant select on element                        to group www;
grant select on element_revision               to group www;
grant select on ports                          to group www;
grant select on ports_categories               to group www;
grant select on ports_active                   to group www;
grant select on ports_all                      to group www;
grant select on ports_moved                    to group www;
grant select on ports_updating                 to group www;
grant select on ports_updating_ports_xref      to group www;
grant select on system                         to group www;
grant select on system_branch                  to group www;
grant select on system_branch_element_revision to group www;
grant select on tasks                          to group www;
grant select on user_tasks                     to group www;

grant select on commit_log_ports_vuxml         to group www;
grant select on vuxml                          to group www;
grant select on vuxml_affected                 to group www;
grant select on vuxml_names                    to group www;

{'fraction_non_alphanumeric': 0.04266873545384019, 'fraction_numerical': 0.013964313421256789, 'mean_word_length': 1.9214501510574018, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 58, 'xml': 9}, 'pii_count': 2, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2006248', 'n_tokens_mistral': 1082, 'n_tokens_neox': 961, 'n_words': 459}