This directory includes the documentation and install file for the MySQL Halfhourly Database. This is v1.1N, prepared in October 2013. Changes since the April 2013 version (v1.1M) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of September 2013) have been added. This is v1.1M, prepared in April 2013. Changes since the October 2012 version (v1.1L) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of March 2013) have been added. Changes since the April 2012 version (v1.1K) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Sep 2012) have been added. Changes since the October 2011 version (v1.1j) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of March 2012) have been added. Changes since the April 2011 version (v1.1i) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Sep 2011) have been added. - Extra mappings were added in the genload_series_to_gxp table. Changes since the October 2010 version (v1.1h) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Mar 2011) have been added. - Treatment of Huntly generation in the genload_series_to_generator_id table has changed. Changes since the April 2010 version (v1.1g) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Sep 2010) have been added. - Treatment of Huntly generation in the genload_series_to_generator_id table has changed. Changes since the October 2009 version (v1.1f) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Feb/Mar 2010) have been added. - Some missing offer data have been added. - 7zip archive format is now used (.7z rather than .zip). Changes since the April 2009 version (v1.1e) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Sep/Oct 2009) have been added. Changes since the October 2008 version (v1.1d) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Mar 2009) have been added. Changes since the April 2008 version (v1.1c) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Sep 2008) have been added. - A new table containing HVDC transfer data has been created. - A new table summarising offer data has been created. - A new data containing instantaneous reserve price data has been created. Significant changes since the October 2007 version (v1.1b) are listed in the documentation; in brief, they are: - Approximately six months of data (to end of Mar 2008) have been added. - New tables have been added to map generator metering data to generator name and information. Changes since the April 2007 version (v1.1) are listed in the documentation; in brief, they are: - Approximately six months of data (to early 2007) have been added. - Some data series have been added, deleted, modified or renamed, following changes to the Gnash version of the database. Changes since the 2006 version (v1.0) are listed in the documentation; in brief, they are: - Approximately six months of data (to early 2007) have been added. - Various minor corrections have been made to tables and documentation. - The install file can now be opened by UltimateZip (the previous installer was built with WinZip and could not be accessed via UltimateZip). - Tables have been added to map the nodal identifiers in the price and metering data tables to standard GXP labels (e.g. mapping 'GEN_Hydro_ Waipapa_Price' to 'WPA2201'). - A table has been added to map the standard GXP identifiers to transmission region (e.g. GXPs beginning with ANI are located in the Bay of Plenty region).