Version Log for MB_MySQL 1.1 * The gid column field on all the tables is now a primary key. * Many INDEX's added. * Init.pl now shows how long it takes for each table to be loaded. * '--local-infile' added to Init.pl. Without this flag it caused some problems on some versions of MySQL. 1.2 * In table album, attributes field fixed. PostgreSQL uses an array which MySQL does not support, so the array is converted into a single integer, see documentation for more details. * code_bits.pl - Gives code samples and algorithms for various tasks. NOTE: This was later replaced by MB_MySQL.pm in version 1.3 * Small problem where a divide-by-zero was causing Update.pl to exit sometimes, this has now been fixed. 1.3 * Added index for puidjoin table. * Addition of MB_MySQL.pm - A perl module for interfacing the MusicBrainz database. 1.4 * Added support for new tables; label, labelalias, gid_redirect, l_album_label, l_artist_label, l_label_label, l_label_track, l_label_url, lt_album_label, lt_artist_label, lt_label_label, lt_label_track, lt_label_url, moderator_subscribe_label. * New indexes for l_album_label, l_artist_label, l_label_label, l_label_track, l_label_url, label, labelalias. * Some tables modified to support data quality; album, artist. 1.4.1 * New index: album.name. * New tables: tag, artist_tag, track_tag, release_tag, label_tag. * New indicies for new tables. * Pending and PendingData are now indexed InnoDB tables, making replication updates much faster. * New column added: cdtoc.degraded. * Fix to MB_Funcs.pl so that 'release' can be the name of a field. 2.0 - OFFICIAL RELEASE * Table renamed. 'release_' to its orginal name 'release'. A VIEW has been created so SQL code containing 'release_' should remain uneffected. * Update.pl has help (-h --help) option. * Update.pl is able to modify the replication number with the -g=x option. * Better error checking so 'Duplicate ID' can be ignored. See $g_die_on_dupid in Globals.pl. * Force TRUNCATE with the '-t' option. Use this is you wish to wipe the Pending and PendingData tables.