Change log for MySQL Cookbook recipes distribution

This file lists changes to the recipes distribution that accompanies MySQL Cookbook. Changes are listed in reverse chronological order.

Version 1.12 (2003-05-27)

Discovered that the system on which I generate distributions has a flakey jar program that generates a bad mcb.war file. This prevented the mcb application context from working properly for the JSP stuff. Modified tomcat/makewar.sh to create the WAR file using zip instead.
Modified the web.xml file in tomcat/mcb/WEB-INF to comment out all the JSTL-related <taglib> entries. Otherwise, Tomcat unpacks mcb.war but doesn't enable the mcb context because it doesn't find the necessary JSTL files. Now it'll unpack and enable the context. (You should then install the JSTL files and uncomment the <taglib> entries and restart Tomcat.) Noted this change in tomcat/README.

Version 1.11 (2003-05-06)

Added day-of-year selection form to apache/searches/bbbirth.rb so that you can display birthdays for any day of the year.
Fixed help message display bug in transfer/cvt_file.pl.
Converted Changes.txt to Changes.xml so that HTML and text versions can be generated from the same source. Changes.xml and related files are located in the Support directory.

Version 1.10 (2003-05-01)

In transfer/load_diag.pl, enable the mysql_local_infile option if DBD::mysql is recent enough to support it.
Made some modification to tables/tomcat.sql:
- Widened data column from BLOB to MEDIUMBLOB
- Added app column (this is needed for Tomcat 4.1, and should be harmless for 4.0)
Added tomcat/README.JDBC.Session file with some information about setting up Tomcat to use MySQL for session storage.
As of Tomcat 4.1.12, the default invoker servlet is disabled for security reasons, so I added an mcb-context-specific mapping to enable it in mcb/WEB-INF/web.xml. Added note about this in tomcat/README as well.
Added link to tomcat/mcb/index.html for one of the session-tracking scripts.
Moved bbbirth.php from dates directory to apache/searches directory because it's intended for web server use.
New Ruby script apache/searches/bbbirth.rb, similar to bbbirth.php.

Version 1.09 (2003-04-25)

Add notes to metadata/get_server_version.* scripts about alternate way to get version string.
More Ruby:
- apache/mysql_server/mysql_server.rb
- apache/hits/hits.rb
misc/query_len.pl now prints max_allowed_packet value.
Fix bug in is_ampm_time() function in lib/Cookbook_Utils.pm.
Clean up dates/bbbirth.php a bit.
Modify tomcat/mcb/bbbirth.jsp to be more like bbbirth.php (add a form allowing the user to select any day of the year).

Version 1.08 (2003-01-15)

One primary change for this version is to include an initial line in most script files now that indicates the name of the file. (This helps as a reminder of what file you're looking at, for people with editors that don't show the filename.)
The other primary change is the inclusion of a number of Ruby scripts. Some are based on the Ruby MySQL module, others on the Ruby DBI module. Ruby-related changes include:
- Begin using -w on #! line in Ruby scripts, and using dbh as the database handle object name consistently. Other minor mods to Ruby scripts.
- Add api/02_error/error.rb, demonstrating Ruby MySQL module error handling.
- Add lib/Cookbook.rb Ruby module containing cookbook database connection method, api/03_lib/harness.rb test harness script illustrating how to use the module file. Also add CookbookDBI.rb and harness2.rb scripts that do the same using Ruby DBI.
- Add api/04_query/query.rb, illustrating query processing using Ruby MySQL module.
- Add metadata/get_rs_meta.rb, illustrating how to get result set metadata in Ruby.
- Add metadata/get_server_version.rb, illustrating how to get server version in Ruby.
Removed a few unnecessary files from transfer, misc directories.

Version 1.07 (2003-01-02)

Clean up README.txt a bit.
Add note to baseball1/README that version 4.5 of the baseball database should be used. (baseball1.com has released version 5.0, but its table structures are not the same as those for version 4.5.)
Add api/01_connect/connect2.rb that is like connect.rb, but uses the Ruby DBI rather than using the MySQL driver directly.
Modify Ruby script metadata/get_database_names.rb to show how to get databases using either list_dbs method or SHOW DATABASES query.

Version 1.06 (2002-12-09)

Slight title change to tomcat/mcb/sess_track2.jsp.
Fix comment typo in apache/images/{banner.pl,banner.py}.
Fix comment typo in apache/images/store_image.pl.
Fix error in api/01_connect/connect2.py: unix_sock parameter should be unix_socket.

Version 1.05 (2002-11-20)

Modify dates/bbbirth.php to display today's birthdays by default (as before), but to include a couple of popups allowing the user to select a month/day for which to display birthdays.
Correct small display error in apache/hits/hits.py.

Version 1.04 (2002-11-01)

Added the baseball1 directory that contains the scripts for loading the baseball1.com baseball database into MySQL.
Added select/clone_table.php.
Added --help option to transfer/cvt_file.pl.

Version 1.03 (2002-10-03)

All Java programs use MySQL Connector/J rather than MM.MySQL. See README.txt if you already have MM.MySQL installed and want to use that. (This change was actually made for the 1.02 distribution, but I forgot to mention it.)

Version 1.02 (2002-10-01)

Added --help, --port, --socket options to transfer/iso_to_us.pl.
Added --port, --socket options to transfer/load_diag.pl.
Added --help, --port, --socket options to transfer/mysql_to_excel.pl.
Added --help, --port, --socket options to transfer/mysql_to_filemaker.pl.
Fix "use of uninitialized value" warning in transfer/mysql_to_filemaker.pl.
Added --help, --port, --socket options to transfer/mysql_to_text.pl.
Added --help, --port, --socket options to transfer/mysql_to_xml.pl.
Added --help, --port, --socket options to transfer/xml_to_mysql.pl.
Modified sequences/{seqdemo,seqdiag}.pl to take standard options and make fewer assumptions.
Several minor corrections to match changes in book text made by copy editor.

Version 1.01 (2002-09-10)

Version 1.00 (2002-09-10)