/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


--
-- Table structure for table `#__cddir_jomestate`
--

CREATE TABLE IF NOT EXISTS `#__cddir_jomestate` (
`id` INT(11) NOT NULL,
  `categories_id` INT(11) NOT NULL,
  `categories_type_id` INT(11) DEFAULT NULL,
  `categories_address_id` INT(11) DEFAULT NULL,
  `users_id` INT(11) DEFAULT NULL,
  `company_id` INT(11) DEFAULT NULL,
  `agent_id` INT(11) DEFAULT NULL,
  `asset_id` INT(10) UNSIGNED DEFAULT NULL,
  `nr_reference` VARCHAR(255) NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NOT NULL,
  `fulladdress` VARCHAR(255) DEFAULT NULL,
  `introtext` text,
  `fulltext` text,
  `energy_class` CHAR(1) DEFAULT NULL,
  `youtube_link` VARCHAR(255) DEFAULT NULL,
  `featured` INT(3) DEFAULT NULL,
  `date_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_created` TIMESTAMP NULL DEFAULT NULL,
  `date_publish` TIMESTAMP NULL DEFAULT NULL,
  `date_publish_down` TIMESTAMP NULL DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `approved` tinyint(1) NOT NULL DEFAULT '1',
  `hits` INT(11) NOT NULL DEFAULT '0',
  `meta_title` VARCHAR(160) DEFAULT NULL,
  `meta_description` VARCHAR(255) DEFAULT NULL,
  `maps_lat` VARCHAR(255) DEFAULT NULL,
  `maps_lng` VARCHAR(255) DEFAULT NULL,
  `maps_zoom` INT(11) DEFAULT NULL,
  `language` CHAR(7) NOT NULL DEFAULT '*',
  `access` INT(10) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;
-- cahnged MyISAM in place of InnoDB
--
-- Indexes for table `#__cddir_jomestate`
--
ALTER TABLE `#__cddir_jomestate`
    ADD PRIMARY KEY (`id`),
    ADD KEY `fk_#__cddir_content_#__categories` (`categories_id`),
    ADD KEY `fk_#__cddir_content_#__users1` (`users_id`),
    ADD KEY `fk_#__cddir_content_#__assets1` (`asset_id`),
    ADD KEY `categories_address_id` (`categories_address_id`),
    ADD KEY `categories_type_id` (`categories_type_id`),
    ADD KEY `title` (`title`),
    ADD KEY `company_id` (`company_id`),
    ADD KEY `access` (`access`),
    ADD KEY `fulladdress` (`fulladdress`),
    ADD KEY `published` (`published`),
    ADD KEY `approved` (`approved`);

--
-- AUTO_INCREMENT for table `#__cddir_jomestate`
--
ALTER TABLE `#__cddir_jomestate`
    MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;



--
-- Table structure for table `#__cddir_prices`
--

CREATE TABLE IF NOT EXISTS `#__cddir_prices` (
`id` INT(11) NOT NULL,
  `content_id` INT(11) NOT NULL,
  `type_id` INT(11) NOT NULL,
  `extension` VARCHAR(255) NOT NULL,
  `price_netto` DECIMAL(16,2) DEFAULT NULL,
  `price_brutto` DECIMAL(16,2) DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;

--
-- Indexes for table `#__cddir_prices`
--
ALTER TABLE `#__cddir_prices`
    ADD PRIMARY KEY (`id`),
    ADD KEY `content_id` (`content_id`,`type_id`),
    ADD KEY `extension` (`extension`);

--
-- AUTO_INCREMENT for table `#__cddir_prices`
--
ALTER TABLE `#__cddir_prices`
    MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;



--
-- Table structure for table `#__cddir_agent`
--
CREATE TABLE IF NOT EXISTS `#__cddir_agent` (
  `id` INT(10) UNSIGNED NOT NULL,
  `users_id` INT(11) NOT NULL,
  `company_id` INT(11) NOT NULL,
  `categories_address_id` INT(11) DEFAULT NULL,
  `first_name` VARCHAR(255) NOT NULL,
  `last_name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NOT NULL,
  `description` text,
  `email` VARCHAR(255) DEFAULT NULL,
  `phone` VARCHAR(255) DEFAULT NULL,
  `mobile` VARCHAR(255) DEFAULT NULL,
  `fax` VARCHAR(255) DEFAULT NULL,
  `fulladdress` VARCHAR(255) DEFAULT NULL,
  `license` VARCHAR(255) DEFAULT NULL,
  `www` VARCHAR(255) DEFAULT NULL,
  `gtalk` VARCHAR(255) DEFAULT NULL,
  `msn` VARCHAR(255) DEFAULT NULL,
  `linkedin` VARCHAR(255) DEFAULT NULL,
  `skype` VARCHAR(255) DEFAULT NULL,
  `twitter` VARCHAR(255) DEFAULT NULL,
  `published` INT(1) DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;
--
-- Indexes for table `#__cddir_agent`
--
ALTER TABLE `#__cddir_agent`
 ADD PRIMARY KEY (`id`), ADD KEY `company_id` (`company_id`,`categories_address_id`);
--
-- AUTO_INCREMENT for table `#__cddir_agent`
--
ALTER TABLE `#__cddir_agent`
MODIFY `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;


--
-- Table structure for table `#__cddir_company`
--
CREATE TABLE IF NOT EXISTS `#__cddir_company` (
  `id` INT(10) NOT NULL,
  `users_id` INT(11) NOT NULL,
  `plans_id` INT(10) UNSIGNED NOT NULL COMMENT 'ID planu agencji',
  `categories_address_id` INT(11) DEFAULT NULL,
  `name` VARCHAR(255) NOT NULL,
  `alias` VARCHAR(255) NOT NULL,
  `fulladdress` VARCHAR(255) DEFAULT NULL,
  `introtext` text,
  `fulltext` text,
  `email` VARCHAR(255) DEFAULT NULL,
  `phone` VARCHAR(255) DEFAULT NULL,
  `fax` VARCHAR(255) DEFAULT NULL,
  `license` VARCHAR(255) DEFAULT NULL,
  `www` VARCHAR(255) DEFAULT NULL,
  `color` VARCHAR(10) DEFAULT NULL,
  `published` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;

--
-- Indexes for table `#__cddir_company`
--
ALTER TABLE `#__cddir_company`
    ADD PRIMARY KEY (`id`),
    ADD KEY `categories_address_id` (`categories_address_id`),
    ADD KEY `plans_id` (`plans_id`);
--
-- AUTO_INCREMENT for table `#__cddir_company`
--
ALTER TABLE `#__cddir_company`
    MODIFY `id` INT(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;


INSERT INTO `#__cddir_fields` (`id`, `categories_type_id`, `categories_value_id`, `categories_group_id`, `categories_id`, `name`, `alias`, `published`, `date_modified`, `date_created`, `date_publish`, `date_publish_down`, `select`, `ordering`, `language`, `template`, `protected`, `extension`) VALUES
('', 9, 19, 24, NULL, 'Beds', 'beds', 1, '2016-03-26 17:36:49', '2016-03-26 17:41:28', '2016-03-26 17:41:28', NULL, 'null', 0, '*', 'horizontal_float_icon', 0, 'com_jomestate'),
('', 9, 19, 24, NULL, 'Baths', 'baths', 1, '2016-03-26 17:37:31', '2016-03-26 17:41:28', '2016-03-26 17:41:28', NULL, 'null', 0, '*', 'horizontal_float_icon', 0, 'com_jomestate'),
('', 9, 20, 24, NULL, 'Garage', 'garage', 1, '2016-03-26 17:37:58', '2016-03-26 17:41:28', '2016-03-26 17:41:28', NULL, 'null', 0, '*', 'horizontal_float_icon', 0, 'com_jomestate');