SET storage_engine=InnoDB;
UPDATE ezsite_data SET value='4.2.0' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';

-- START: from 4.1.0
-- END: from 4.1.0

-- START: from 4.1.1
ALTER TABLE ezworkflow_event
CHANGE data_text1 data_text1 VARCHAR( 255 ),
CHANGE data_text2 data_text2 VARCHAR( 255 ),
CHANGE data_text3 data_text3 VARCHAR( 255 ),
CHANGE data_text4 data_text4 VARCHAR( 255 );
-- END: from 4.1.1

-- START: from 4.1.2
ALTER TABLE ezsession ALTER COLUMN user_hash SET DEFAULT '';
-- END: from 4.1.2

-- START: from 4.1.4
CREATE INDEX ezkeyword_attr_link_oaid ON ezkeyword_attribute_link( objectattribute_id );
CREATE INDEX ezinfocollection_co_id_created ON ezinfocollection( contentobject_id, created );
-- END: from 4.1.4

ALTER TABLE ezpolicy_limitation ADD INDEX policy_id ( policy_id );
ALTER TABLE ezworkflow_event ADD INDEX wid_version_placement ( workflow_id , version , placement );
ALTER TABLE ezuser_accountkey ADD INDEX hash_key ( hash_key );
