script to update DB object comments
authorgmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 18 Apr 2011 15:43:34 +0000 (15:43 +0000)
committergmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 18 Apr 2011 15:43:34 +0000 (15:43 +0000)
commita1ce9204c0de1fe88f8a849bcf3fa93d5dc2304d
tree605012573c9841f858224e85d9100ea47d506aad
parent55767049e82ce13c2d184b3af1a1dbd700fb8683
script to update DB object comments

New script, update-db-comments.sh, to be run as part of upgrades
to refresh comments on database schema objects.  Usage is:

  update-db-comments.sh db-host db-port db-name db-user db-pass

The helper script grab-db-comment.pl is what actually parses out
the comment statements.

To avoid repetition, the list of default SQL scripts to use when
initializing an Evergreen database has been moved to a new file
called sql_file_manifest.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_1@20163 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/build-db.sh
Open-ILS/src/sql/Pg/grab-db-comments.pl [new file with mode: 0755]
Open-ILS/src/sql/Pg/sql_file_manifest [new file with mode: 0644]
Open-ILS/src/sql/Pg/update-db-comments.sh [new file with mode: 0755]