ALTER TABLE `#__sr_experiences` ADD COLUMN `created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__sr_experiences` ADD COLUMN `created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `#__sr_experiences` ADD COLUMN `modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `#__sr_experiences` ADD COLUMN `modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `#__sr_experiences` ADD COLUMN `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `#__sr_experiences` ADD COLUMN `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
INSERT INTO `#__content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`, `router`, `content_history_options`) VALUES (0, 'Solidres Experience', 'com_solidres.experience', '{"special":{"dbtable":"#__sr_experiences","key":"id","type":"Experience","prefix":"SolidresTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"state","core_alias":"alias","core_created_time":"created_date","core_modified_time":"modified_date","core_body":"long_description", "core_hits":"null","core_publish_up":"null","core_publish_down":"null","core_access":"null", "core_params":"params", "core_featured":"null", "core_metadata":"null", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"ordering", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}, "special":{}}', 'SRExperienceHelper::getItemRoute', '');
ALTER TABLE `#__sr_experiences` ADD COLUMN `meta_title` VARCHAR(255) NOT NULL DEFAULT '' AFTER `checked_out_time`;
ALTER TABLE `#__sr_experiences` ADD COLUMN `meta_key` VARCHAR(255) NOT NULL DEFAULT '' AFTER `meta_title`;
ALTER TABLE `#__sr_experiences` ADD COLUMN `meta_desc` VARCHAR(255) NOT NULL DEFAULT '' AFTER `meta_key`;
ALTER TABLE `#__sr_experiences` ADD COLUMN `tab_content` LONGTEXT AFTER `meta_desc`;
ALTER TABLE `#__sr_experiences` ADD COLUMN `hits` INT(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `tab_content`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `supplement_amount` DECIMAL(12,2) NOT NULL DEFAULT 0.00 AFTER `time_slot_to`;
ALTER TABLE `#__sr_experience_reservations`
    ADD COLUMN `origin_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `supplement_amount`,
    ADD INDEX `fk_exp_res_origins1_idx` (`origin_id` ASC),
    ADD CONSTRAINT `fk_exp_res_origins1` FOREIGN KEY (`origin_id`) REFERENCES `#__sr_origins`(`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `time_slot_w_day` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `time_slot_to`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_ua` VARCHAR(255) NOT NULL DEFAULT '' AFTER `origin_id`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_ismobile` TINYINT(1) UNSIGNED NULL DEFAULT NULL AFTER `customer_ua`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_ip` VARCHAR(50) NOT NULL DEFAULT '' AFTER `customer_ismobile`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_coordinates` TEXT AFTER `customer_ip`;
ALTER TABLE `#__sr_experience_reservations` ADD COLUMN `customer_language` VARCHAR(7) NULL DEFAULT NULL AFTER `customer_coordinates`;
ALTER TABLE `#__sr_experience_timeslots` ADD COLUMN `w_day` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `to`;
ALTER TABLE `#__sr_experience_categories` ADD COLUMN `image` VARCHAR(500) NOT NULL DEFAULT '' AFTER `state`;
ALTER TABLE `#__sr_experience_categories` ADD COLUMN `description` VARCHAR(1000) NOT NULL DEFAULT '' AFTER `image`;