projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c45cc09) | patch
LP#1599634: change ID column in view to BIGINT
authorGalen Charlton <gmc@esilibrary.com>
Thu, 11 Aug 2016 14:41:29 +0000 (10:41 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Thu, 11 Aug 2016 14:41:29 +0000 (10:41 -0400)
commitbc4da93590220fb8d5729c6bc8c2a5f9ef467248
tree7636f504b0166377bbe0997a09eca0d827e57a06tree
parentc45cc094d769c1c4621072febf1c8a088ae63068commit | diff
LP#1599634: change ID column in view to BIGINT

This patches changes the ID column to just pass through
the ID from the source tables, promoted to BIGINT in
some cases.  This has the effect of:

- removing a redundancy, as circ_type already specifies the source table
- making it easier to join this view against the circulation tables when
  writing SQL queries

This patch also renames the schema upgrade script to better
match conventions.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/examples/fm_IDL.xml diff | blob | history
Open-ILS/src/sql/Pg/090.schema.action.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.LP1599634_Circulation_report_source_to_include_in-house_and_non_cat_circ.sql [deleted file] blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.all_circulation_combined_types_view.sql [new file with mode: 0644] blob
Evergreen ILS