]> Kevux Git Server - koopa/commit
Update: rework access control to be automatic based on is_* roles in the t_users...
authorKevin Day <thekevinday@gmail.com>
Sat, 1 Apr 2017 06:05:11 +0000 (01:05 -0500)
committerKevin Day <thekevinday@gmail.com>
Sat, 1 Apr 2017 06:05:11 +0000 (01:05 -0500)
commita9a0e43de5eb84b32124371157a96634d5c8857e
tree5128eefb9f8581ce6f124002bdf33b27b243c641
parent56510c02a93997ef87a90639c9ef8c8ffe3e9e23
Update: rework access control to be automatic based on is_* roles in the t_users table

Instead of trying to use select queries on every statement based on a users role, have the database automatical grant/revoke roles based on column settings in the s_tables.t_users table.
u_public and r_public have been renamed to be u_reservation_public and r_reservation_public to keep all roles self-contained.
name_machine fields should now only allow word characters.
21 files changed:
database/sql/reservation/reservation-associations.sql
database/sql/reservation/reservation-dates.sql
database/sql/reservation/reservation-fields.sql
database/sql/reservation/reservation-files.sql
database/sql/reservation/reservation-first.sql
database/sql/reservation/reservation-groups.sql
database/sql/reservation/reservation-last.sql
database/sql/reservation/reservation-legal.sql
database/sql/reservation/reservation-log_problems.sql
database/sql/reservation/reservation-log_types.sql
database/sql/reservation/reservation-log_users.sql
database/sql/reservation/reservation-main.sql
database/sql/reservation/reservation-paths.sql
database/sql/reservation/reservation-requests.sql
database/sql/reservation/reservation-statistics.sql
database/sql/reservation/reservation-types.sql
database/sql/reservation/reservation-users.sql
documentation/access_roles.txt
examples/test.php
program/reservation/index.php
program/reservation/reservation_paths.php