[Lxr-dev] [ lxr-Patches-1693932 ] Rename "release" to "stream" in SQL interface

[SourceForge.net <no...@so...>]

Patches item #1693932, was opened at 2007-04-03 18:30
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=390119&aid=1693932&group_id=27350

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Paul D. Smith (psmith)
Assigned to: Nobody/Anonymous (nobody)
Summary: Rename "release" to "stream" in SQL interface

Initial Comment:
In a discussion on the LXR mailing list the proposal was made to avoid the whole "quoting `release` keyword" problem in MySQL 5 by simply renaming the column to something that's not a keyword (rather than going through and remembering to quote it everywhere).

This patch is a comprehensive attempt to do that, renaming the lxr_releases table to lxr_streams and the release column in that table to "stream".  It also renames the "release" references in the DB backends to "stream" so that they're consistent.  It does NOT attempt to rename the upper-level uses of the term "release", although that's something that might be worth doing for consistency's sake.

Finally, it provides some scripts to update existing databases and perform those renames on them, so you don't have to dump/reload your data, and gives instructions in the INSTALL file on how to use them.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=390119&aid=1693932&group_id=27350