-- Add properties
ALTER TABLE `#__wpl_properties`  ADD `vir_tour` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';
-- Add columns for agent and agency
ALTER TABLE `#__wpl_users` ADD `r_facebook` varchar(255) NULL;
ALTER TABLE `#__wpl_users` ADD `r_twitter` varchar(255) NULL;
ALTER TABLE `#__wpl_users` ADD `r_pinterest` varchar (255) NULL;
ALTER TABLE `#__wpl_users` ADD `r_skype` varchar(255) NULL;
ALTER TABLE `#__wpl_users` ADD `agent_cover` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `#__wpl_users` ADD `fancify_agent_list` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `#__wpl_users` ADD `fancify_agency_establish` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

-- add agent field
INSERT INTO `#__wpl_dbst` (`id`,`kind`, `mandatory`, `name`, `type`, `options`, `enabled`, `pshow`, `plisting`, `searchmod`, `editable`, `deletable`, `index`, `css`, `style`, `specificable`, `listing_specific`, `property_type_specific`, `table_name`, `table_column`, `category`, `rankable`, `rank_point`, `comments`, `pwizard`, `text_search`, `params`) VALUES
(10101, 2, 0, 'Facebook', 'text', '', 1, '1', 1, 0, 0, 0, 5.00, '', '', 1, '', '', 'wpl_users', 'r_facebook', 10, 1, 0, NULL, '1', 1, ''),
(10102, 2, 0, 'Twitter', 'text', '', 1, '1', 1, 0, 0, 0, 5.10, '', '', 1, '', '', 'wpl_users', 'r_twitter', 10, 1, 0, NULL, '1', 1, ''),
(10103, 2, 0, 'pinterest', 'text', '', 1, '1', 1, 0, 0, 0, 5.20, '', '', 1, '', '', 'wpl_users', 'r_pinterest', 10, 1, 0, NULL, '1', 1, ''),
(10104, 2, 0, 'Skype', 'text', '', 1, '1', 1, 0, 0, 0, 5.20, '', '', 1, '', '', 'wpl_users', 'r_skype', 10, 1, 0, NULL, '1', 1, ''),
(4104, 2, 0, 'Cover Image', 'upload', '{"params":{"request_str":"?wpl_format=b:users:ajax&wpl_function=upload_file&file_name=[html_element_id]&item_id=[item_id]"},"preview":1,"remove_str":"wpl_format=b:users:ajax&wpl_function=delete_file&item_id=[item_id]"}', 1, '0', 0, 0, 0, 0, 5.30, '', '', 0, '', '', 'wpl_users', 'agent_cover', 10, 0, 0, '', '1', 0, '');
