Table Prefix support
--------------------

1.	Introduction

A requested feature for some time, this functionality has finally been
added for OpenDb 0.50.  It allows Opendb to coexist with other products
in the same database where tables such as 'user' could already be in
use by that other product.

The prefix support allows you to specify a unique prefix for the OpenDb
tables.  For example a prefix of 'opendb050_' would prefix the opendb
tables thus:
	opendb050_user
	opendb050_borrowed_item
	opendb050_review
	opendb050_item
	opendb050_item_instance
	opendb050_item_attribute
	opendb050_s_status_type
	opendb050_s_item_type
	opendb050_s_attribute_type
	opendb050_s_item_attribute_type
	opendb050_s_attribute_type_lookup

2.	Configuration

	The opendb table prefix support is enabled/disabled and configured
	via a single include/config.php variable $CONFIG_VARS['db_server.table_prefix'].

	If this variable is NULL, EMPTY or UNDEFINED table prefix support is 
	disabled.

3.	Apply Prefixes

	This step is very dependent on where you are in the installation
	process.

	3.1	New Install

		If you are installing OpenDb for the first time and have no OpenDb
		tables in the database as yet then before running patch.php ensure
		the $CONFIG_VARS['db_server.table_prefix'] is defined.

		You can then run the Install script as normal.

	3.2	Patch DVDDBp 1.45 - 0.38

		The patches for DVDDBp 1.45, 0.30rc5, 0.33-dev3, 0.34p2, 0.35p2, 0.36,
		0.37 & 0.38 do _not_ provide support for table prefixes, so don't even
	 	try to enable prefix support on an existing installed product from this
		range.

	3.3	Existing Installation
	
		If you have an existing installation of OpenDb and have performed any 
		patches so that you have a OpenDb 0.50 level database you can 
		enable prefix support safely.

		Before loading the patch.php ensure that $CONFIG_VARS['db_server.table_prefix'] is
	 	defined.  Load the patch.php script and choose the 'Prefix tables' 
		option.  If all is well you should have two buttons 'Apply Prefixes' 
		and 'Remove Prefixes'.  You can now click the 'Apply Prefixes' to add
		prefix support.  As long as all of the tables were correctly converted
		your prefixing has been correctly applied.
		
4.	Remove Prefixes

	Ensure that $CONFIG_VARS['db_server.table_prefix'] is set to the current prefix
	of your tables, which it should be if you have not modified this value since 
	apply prefixes.  Load the patch.php script and choose the 'Prefix tables' 
	option; instead of 'Apply Prefixes' choose 'Remove Prefixes'.  If all goes well 
	your prefixes should be removed.  After this step be sure to disable the
	$CONFIG_VARS['db_server.table_prefix'] variable in include/config.php.

5.	Issues
	
	Currently there is no automated way to recover from a failed 
	'Apply Prefixes' or 'Remove Prefixes'. 	You will have to open up phpMyAdmin
	and manually remove/add prefixes yourself.