· 8 years ago · Mar 08, 2018, 12:56 PM
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!40101 SET NAMES utf8 */;
5
6
7--
8-- Table structure for table `#__cddir_jomestate`
9--
10
11CREATE TABLE IF NOT EXISTS `#__cddir_jomestate` (
12`id` int(11) NOT NULL,
13 `categories_id` int(11) NOT NULL,
14 `categories_type_id` int(11) DEFAULT NULL,
15 `categories_address_id` int(11) DEFAULT NULL,
16 `users_id` int(11) DEFAULT NULL,
17 `company_id` int(11) DEFAULT NULL,
18 `agent_id` int(11) DEFAULT NULL,
19 `asset_id` int(10) unsigned DEFAULT NULL,
20 `nr_reference` varchar(255) NOT NULL,
21 `title` varchar(255) NOT NULL,
22 `alias` varchar(255) NOT NULL,
23 `fulladdress` varchar(255) DEFAULT NULL,
24 `introtext` text,
25 `fulltext` text,
26 `energy_class` char(1) DEFAULT NULL,
27 `youtube_link` varchar(255) DEFAULT NULL,
28 `featured` int(3) DEFAULT NULL,
29 `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
30 `date_created` timestamp NULL DEFAULT NULL,
31 `date_publish` timestamp NULL DEFAULT NULL,
32 `date_publish_down` timestamp NULL DEFAULT NULL,
33 `published` tinyint(1) NOT NULL DEFAULT '1',
34 `approved` tinyint(1) NOT NULL DEFAULT '1',
35 `hits` int(11) NOT NULL DEFAULT '0',
36 `meta_title` varchar(160) DEFAULT NULL,
37 `meta_description` varchar(255) DEFAULT NULL,
38 `maps_lat` varchar(255) DEFAULT NULL,
39 `maps_lng` varchar(255) DEFAULT NULL,
40 `maps_zoom` int(11) DEFAULT NULL,
41 `language` char(7) NOT NULL DEFAULT '*',
42 `access` int(10) unsigned NOT NULL DEFAULT '1'
43) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;
44-- cahnged MyISAM in place of InnoDB
45--
46-- Indexes for table `#__cddir_jomestate`
47--
48ALTER TABLE `#__cddir_jomestate`
49 ADD PRIMARY KEY (`id`),
50 ADD KEY `fk_#__cddir_content_#__categories` (`categories_id`),
51 ADD KEY `fk_#__cddir_content_#__users1` (`users_id`),
52 ADD KEY `fk_#__cddir_content_#__assets1` (`asset_id`),
53 ADD KEY `categories_address_id` (`categories_address_id`),
54 ADD KEY `categories_type_id` (`categories_type_id`),
55 ADD KEY `title` (`title`),
56 ADD KEY `company_id` (`company_id`),
57 ADD KEY `access` (`access`),
58 ADD KEY `fulladdress` (`fulladdress`),
59 ADD KEY `published` (`published`),
60 ADD KEY `approved` (`approved`);
61
62--
63-- AUTO_INCREMENT for table `#__cddir_jomestate`
64--
65ALTER TABLE `#__cddir_jomestate`
66 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
67
68
69
70--
71-- Table structure for table `#__cddir_prices`
72--
73
74CREATE TABLE IF NOT EXISTS `#__cddir_prices` (
75`id` int(11) NOT NULL,
76 `content_id` int(11) NOT NULL,
77 `type_id` int(11) NOT NULL,
78 `extension` varchar(255) NOT NULL,
79 `price_netto` decimal(16,2) DEFAULT NULL,
80 `price_brutto` decimal(16,2) DEFAULT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;
82
83--
84-- Indexes for table `#__cddir_prices`
85--
86ALTER TABLE `#__cddir_prices`
87 ADD PRIMARY KEY (`id`),
88 ADD KEY `content_id` (`content_id`,`type_id`),
89 ADD KEY `extension` (`extension`);
90
91--
92-- AUTO_INCREMENT for table `#__cddir_prices`
93--
94ALTER TABLE `#__cddir_prices`
95 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
96
97
98
99--
100-- Table structure for table `#__cddir_agent`
101--
102CREATE TABLE IF NOT EXISTS `#__cddir_agent` (
103 `id` int(10) unsigned NOT NULL,
104 `users_id` int(11) NOT NULL,
105 `company_id` int(11) NOT NULL,
106 `categories_address_id` int(11) DEFAULT NULL,
107 `first_name` varchar(255) NOT NULL,
108 `last_name` varchar(255) NOT NULL,
109 `alias` varchar(255) NOT NULL,
110 `description` text,
111 `email` varchar(255) DEFAULT NULL,
112 `phone` varchar(255) DEFAULT NULL,
113 `mobile` varchar(255) DEFAULT NULL,
114 `fax` varchar(255) DEFAULT NULL,
115 `fulladdress` varchar(255) DEFAULT NULL,
116 `license` varchar(255) DEFAULT NULL,
117 `www` varchar(255) DEFAULT NULL,
118 `gtalk` varchar(255) DEFAULT NULL,
119 `msn` varchar(255) DEFAULT NULL,
120 `linkedin` varchar(255) DEFAULT NULL,
121 `skype` varchar(255) DEFAULT NULL,
122 `twitter` varchar(255) DEFAULT NULL,
123 `published` int(1) DEFAULT NULL
124) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;
125--
126-- Indexes for table `#__cddir_agent`
127--
128ALTER TABLE `#__cddir_agent`
129 ADD PRIMARY KEY (`id`), ADD KEY `company_id` (`company_id`,`categories_address_id`);
130--
131-- AUTO_INCREMENT for table `#__cddir_agent`
132--
133ALTER TABLE `#__cddir_agent`
134MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
135
136
137--
138-- Table structure for table `#__cddir_company`
139--
140CREATE TABLE IF NOT EXISTS `#__cddir_company` (
141 `id` int(10) NOT NULL,
142 `users_id` int(11) NOT NULL,
143 `plans_id` int(10) unsigned NOT NULL COMMENT 'ID planu agencji',
144 `categories_address_id` int(11) DEFAULT NULL,
145 `name` varchar(255) NOT NULL,
146 `alias` varchar(255) NOT NULL,
147 `fulladdress` varchar(255) DEFAULT NULL,
148 `introtext` text,
149 `fulltext` text,
150 `email` varchar(255) DEFAULT NULL,
151 `phone` varchar(255) DEFAULT NULL,
152 `fax` varchar(255) DEFAULT NULL,
153 `license` varchar(255) DEFAULT NULL,
154 `www` varchar(255) DEFAULT NULL,
155 `color` varchar(10) DEFAULT NULL,
156 `published` tinyint(4) NOT NULL DEFAULT '1'
157) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COLLATE = utf8_general_ci;
158
159--
160-- Indexes for table `#__cddir_company`
161--
162ALTER TABLE `#__cddir_company`
163 ADD PRIMARY KEY (`id`),
164 ADD KEY `categories_address_id` (`categories_address_id`),
165 ADD KEY `plans_id` (`plans_id`);
166--
167-- AUTO_INCREMENT for table `#__cddir_company`
168--
169ALTER TABLE `#__cddir_company`
170 MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
171
172
173INSERT 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
174('', 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'),
175('', 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'),
176('', 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');