]> Kevux Git Server - koopa/commit
Cleanup: re-structure the database sql for standard and reservation
authorKevin Day <thekevinday@gmail.com>
Wed, 3 May 2017 02:54:16 +0000 (21:54 -0500)
committerKevin Day <thekevinday@gmail.com>
Wed, 3 May 2017 03:25:03 +0000 (22:25 -0500)
commit561fb6af6fff37b7b30f8ba30e72282cd820176f
treed41cb9d003e30c099dd4bcbbf42dafe5d46b0d88
parenta2c082b135509b0b0dfe1b24b4d2abf2f9cf2f60
Cleanup: re-structure the database sql for standard and reservation

To avoid having duplicate queries, I moved all the permission related information for standard into a separate sql file.
- This allows for referencing the standard sql files as part of the install, without having to modify them for name changes.

The only files that should need to be replaced from standard are standard-first.sql, standard-permissions.sql, and standard-last.sql.

I changed all references of u_standard and r_standard to u_reservation and r_reservation to generate the reservation specific versions of standard-first.sql, standard-permissions.sql, and standard-last.
- These changes were saved in their respective reservation equivalent files: reservation-first.sql, reservation-permissions.sql, and reservation-last.

While making these changes, I noticed that there is a way to disable all triggers for a table so that I can alter content without a trigger being 'triggered'.
- This made it easy for me to move some special cases to the standard-permissions.sql file.
33 files changed:
database/sql/reservation/order.install
database/sql/reservation/reservation-associations.sql
database/sql/reservation/reservation-dates.sql
database/sql/reservation/reservation-fields.sql
database/sql/reservation/reservation-files.sql [deleted file]
database/sql/reservation/reservation-groups.sql [deleted file]
database/sql/reservation/reservation-last.sql
database/sql/reservation/reservation-legal.sql
database/sql/reservation/reservation-log_groups.sql [deleted file]
database/sql/reservation/reservation-log_problems.sql [deleted file]
database/sql/reservation/reservation-log_types.sql [deleted file]
database/sql/reservation/reservation-log_users.sql [deleted file]
database/sql/reservation/reservation-main.sql [deleted file]
database/sql/reservation/reservation-paths.sql [deleted file]
database/sql/reservation/reservation-permissions.sql [moved from database/sql/reservation/reservation-users.sql with 51% similarity]
database/sql/reservation/reservation-requests.sql
database/sql/reservation/reservation-statistics.sql
database/sql/reservation/reservation-types.sql [deleted file]
database/sql/reservation/reservation-workflow.sql
database/sql/standard/order.install
database/sql/standard/standard-files.sql
database/sql/standard/standard-groups.sql
database/sql/standard/standard-last.sql
database/sql/standard/standard-log_groups.sql
database/sql/standard/standard-log_problems.sql
database/sql/standard/standard-log_types.sql
database/sql/standard/standard-log_users.sql
database/sql/standard/standard-main.sql
database/sql/standard/standard-paths.sql
database/sql/standard/standard-permissions.sql [new file with mode: 0644]
database/sql/standard/standard-statistics.sql
database/sql/standard/standard-types.sql
database/sql/standard/standard-users.sql