************************************

Upgrading from Ensight v3.0.1b2

Important: Please skip steps 1 - 4 if you are already on version 3.0.3 or higher

************************************

1. Overwrite all files in the /live directory with those in the patches-3.0.1b2-to-<version>.zip file.

2. In live/modules/connect.php, add the following line:
	define ("EnhanceLongTextAreaFields", true);

3. Run the following SQL commands

CREATE TABLE Profiles_Values_Extra (
	Form_ID int NOT NULL,
	Profile_ID int NOT NULL,
	Reference_ID int NOT NULL,
	FieldValueExtra_BLOB text NULL
);
CREATE INDEX Profiles_Values_ExtraForm_ID ON Profiles_Values_Extra (Form_ID);
CREATE INDEX Profiles_Values_ExtraProfile_ID ON Profiles_Values_Extra (Profile_ID);
CREATE INDEX Profiles_Values_ExtraReference_ID ON Profiles_Values_Extra (Reference_ID);

CREATE TABLE Catalog_Values_Extra (
	Form_ID int NOT NULL,
	Item_ID int NOT NULL,
	Instance_ID int NOT NULL,
	FieldValueExtra_BLOB text NULL
);
CREATE INDEX Catalog_Values_ExtraForm_ID ON Catalog_Values_Extra (Form_ID);
CREATE INDEX Catalog_Values_ExtraItem_ID ON Catalog_Values_Extra (Item_ID);
CREATE INDEX Catalog_Values_ExtraInstance_ID ON Catalog_Values_Extra (Instance_ID);

Ensure that the text fields are set to NULL, rather than NOT NULL

4. Copy DB-mssql.php or DB-mysql.php from /live/modules/DB into /live/modules, backup DB.php and rename the DB-*.php file to DB.php. Don't do this while the site is busy.

************************************
v3.0.3 and above - start here
************************************

5. Open your browser and load the page http://<your_domain>/live/admin/install_patches.php
** If any error messages appear, please contact us immediately!

6. Test!