
update infobox_configuration set infobox_define='BOX_HEADING_EVENTS_CATEGORIES' where infobox_define='BOX_HEADING_EVENTS';

update configuration set configuration_title='Address 2' where configuration_key='ACCOUNT_SUBURB';

update configuration set configuration_description='Display Address 2 in the customers account' where configuration_key='ACCOUNT_SUBURB';



Alter Table products add is_subscription char(1) default 'N';

ALTER TABLE `services_locations` MODIFY COLUMN `service_location_equipment` TEXT COLLATE latin1_swedish_ci;

ALTER TABLE `events_locations` MODIFY COLUMN `location_equipment` TEXT COLLATE latin1_swedish_ci;

#
# Structure for the `products_to_subscriptions` table : 
#
DROP TABLE IF EXISTS `products_to_subscriptions`;
CREATE TABLE `products_to_subscriptions` (
  `products_id` int(11) NOT NULL default '0',
  `subscription_id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT into sql_queries values('freeway_v1_1_4.sql',now()); 

