· 6 years ago · Oct 31, 2019, 10:00 PM
1Auditor: CyberVX
2
3- OS:
4# KALI LINUX
5
6- TOOLS:
7# FIREFOX
8# NMAP
9# KATANA
10# OPTIVA
11
12- VULNERABILITY:
13# FILE INCLUSION - JOOMLA !
14
15- TARGET:
16# http://www.aloncoimoveis.com.br/
17
18========================
19 REPORT 1
20========================
21
22aloncoimoveis.com.br (191.6.194.94)
23
24PORT STATE SERVICE VERSION
2521/tcp open ftp ProFTPD
26|_clamav-exec: ERROR: Script execution failed (use -d to debug)
27|_sslv2-drown:
2825/tcp open tcpwrapped
29|_clamav-exec: ERROR: Script execution failed (use -d to debug)
30|_sslv2-drown:
3180/tcp open ssl/http Apache
32|_clamav-exec: ERROR: Script execution failed (use -d to debug)
33|_http-aspnet-debug: ERROR: Script execution failed (use -d to debug)
34|_http-csrf: Couldn't find any CSRF vulnerabilities.
35|_http-dombased-xss: Couldn't find any DOM based XSS.
36|_http-server-header: Apache
37|_http-stored-xss: Couldn't find any stored XSS vulnerabilities.
38|_http-vuln-cve2014-3704: ERROR: Script execution failed (use -d to debug)
39|_ssl-ccs-injection: No reply from server (TIMEOUT)
40|_sslv2-drown:
41110/tcp open tcpwrapped
42|_clamav-exec: ERROR: Script execution failed (use -d to debug)
43|_sslv2-drown:
44113/tcp closed ident
45443/tcp open ssl/ssl Apache httpd (SSL-only mode)
46|_clamav-exec: ERROR: Script execution failed (use -d to debug)
47|_http-csrf: Couldn't find any CSRF vulnerabilities.
48| http-dombased-xss:
49| Spidering limited to: maxdepth=3; maxpagecount=20; withinhost=aloncoimoveis.com.br
50| Found the following indications of potential DOM based XSS:
51|
52| Source: document.write(window.location.host)
53|_ Pages: https://aloncoimoveis.com.br:443/
54|_http-server-header: Apache
55| http-slowloris-check:
56| VULNERABLE:
57| Slowloris DOS attack
58| State: LIKELY VULNERABLE
59| IDs: CVE:CVE-2007-6750
60| Slowloris tries to keep many connections to the target web server open and hold
61| them open as long as possible. It accomplishes this by opening connections to
62| the target web server and sending a partial request. By doing so, it starves
63| the http server's resources causing Denial Of Service.
64|
65| Disclosure date: 2009-09-17
66| References:
67| https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-6750
68|_ http://ha.ckers.org/slowloris/
69|_http-stored-xss: Couldn't find any stored XSS vulnerabilities.
70|_http-vuln-cve2017-1001000: ERROR: Script execution failed (use -d to debug)
71|_sslv2-drown:
728008/tcp open http
73|_clamav-exec: ERROR: Script execution failed (use -d to debug)
74| fingerprint-strings:
75| FourOhFourRequest:
76| HTTP/1.1 302 Found
77| Location: https://:8010/nice%20ports%2C/Tri%6Eity.txt%2ebak
78| Connection: close
79| X-Frame-Options: SAMEORIGIN
80| X-XSS-Protection: 1; mode=block
81| X-Content-Type-Options: nosniff
82| Content-Security-Policy: frame-ancestors
83| GenericLines, HTTPOptions, RTSPRequest, SIPOptions:
84| HTTP/1.1 302 Found
85| Location: https://:8010
86| Connection: close
87| X-Frame-Options: SAMEORIGIN
88| X-XSS-Protection: 1; mode=block
89| X-Content-Type-Options: nosniff
90| Content-Security-Policy: frame-ancestors
91| GetRequest:
92| HTTP/1.1 302 Found
93| Location: https://:8010/
94| Connection: close
95| X-Frame-Options: SAMEORIGIN
96| X-XSS-Protection: 1; mode=block
97| X-Content-Type-Options: nosniff
98|_ Content-Security-Policy: frame-ancestors
99|_http-aspnet-debug: ERROR: Script execution failed (use -d to debug)
100|_http-csrf: Couldn't find any CSRF vulnerabilities.
101|_http-dombased-xss: Couldn't find any DOM based XSS.
102|_http-stored-xss: Couldn't find any stored XSS vulnerabilities.
103|_http-vuln-cve2014-3704: ERROR: Script execution failed (use -d to debug)
104|_https-redirect: ERROR: Script execution failed (use -d to debug)
1058010/tcp open ssl/http-proxy FortiGate Web Filtering Service
106|_clamav-exec: ERROR: Script execution failed (use -d to debug)
107|_http-majordomo2-dir-traversal: ERROR: Script execution failed (use -d to debug)
108| http-phpmyadmin-dir-traversal:
109| VULNERABLE:
110| phpMyAdmin grab_globals.lib.php subform Parameter Traversal Local File Inclusion
111| State: UNKNOWN (unable to test)
112| IDs: CVE:CVE-2005-3299
113| PHP file inclusion vulnerability in grab_globals.lib.php in phpMyAdmin 2.6.4 and 2.6.4-pl1 allows remote attackers to include local files via the $__redirect parameter, possibly involving the subform array.
114|
115| Disclosure date: 2005-10-nil
116| Extra information:
117| ../../../../../etc/passwd :
118| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
119| <html>
120| <head>
121| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
122| <meta name="referrer" content="no-referrer">
123| <title>Web Filter Block Override</title>
124| <style type="text/css">
125| html, body { margin: 0; padding: 0; font-family: Verdana, Arial, sans-serif; font-size: 10pt; }
126| h1, h2 { height: 82px; text-indent: -999em; margin: 0; padding: 0; margin: 0; }
127| div { margin: 0; padding: 0; }
128| div.header { background: url(https://aloncoimoveis.com.br:8010/XX/YY/ZZ/CI/MGPGHGPGPFGHCDPFGGOGFGEH) 0 0 repeat-x; height: 82px; }
129| div.header h1 { background: url(https://aloncoimoveis.com.br:8010/XX/YY/ZZ/CI/MGPGHGPGPFGHCDPFGGHGFHBGCHEGPFHHGG) 0 0 no-repeat; }
130| div.header h2 { background: url(https://aloncoimoveis.com.br:8010/XX/YY/ZZ/CI/MGPGHGPGPFGHCDPFGGOGFGEH) 0 -82px no-repeat; width: 160px; float: right; }
131| div.sidebar { width: 195px; height: 200px; float: left; }
132| div.main { padding: 5px; margin-left: 195px; }
133| div.buttons { margin-top: 30px; text-align: right; }
134| h3 { margin: 36px 0; font-size: 16pt; }
135| .blocked h3 { color: #c00; }
136| .authenticate h3 { color: #36c; }
137| h2.fgd_icon { background: url(https://aloncoimoveis.com.br:8010/XX/YY/ZZ/CI/MGPGHGPGPFGHCDPFGGOGFGEH) 0 -166px repeat-x; width: 90px; height: 92px; margin: 48px auto; }
138| .blocked h2.fgd_icon { background-position: 0 -166px; }
139| .authenticate h2.fgd_icon { background-position: -89px -166px; }
140| form { width: 300px; margin: 30px 0; }
141| label { display: block; width: 300px; margin: 5px 0; line-height: 25px; }
142| label input { width: 200px; border: 1px solid #7f9db9; height: 20px; float: right; }
143| </style>
144| </head>
145| <body class="authenticate">
146| <div class="header">
147| <h2>Powered By Fortinet</h2>
148| <h1>FortiGuard Web Filtering</h1>
149| </div>
150| <div class="sidebar">
151| <h2 class="fgd_icon">authenticate</h2>
152| </div>
153| <div class="main">
154| <h3>Web Filter Block Override</h3><div class="notice">If you have been granted override creation privileges by your administrator, you can enter your username and password here to gain immediate access to the blocked web-page. If you do not have these privileges, please contact your administrator to gain access to the web-page.</div> <div><font color="#FF0000">Invalid FortiGuard Web Filtering override request.</font></div> </div>
155| </body>
156|
157|
158| References:
159| https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2005-3299
160|_ http://www.exploit-db.com/exploits/1244/
161| http-vuln-cve2010-0738:
162|_ /jmx-console/: Authentication was not required
163| http-vuln-cve2011-3368:
164| VULNERABLE:
165| Apache mod_proxy Reverse Proxy Security Bypass
166| State: VULNERABLE
167| IDs: CVE:CVE-2011-3368 BID:49957
168| An exposure was reported affecting the use of Apache HTTP Server in
169| reverse proxy mode. The exposure could inadvertently expose internal
170| servers to remote users who send carefully crafted requests.
171| Disclosure date: 2011-10-05
172| References:
173| https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2011-3368
174|_ https://www.securityfocus.com/bid/49957
175|_http-vuln-cve2017-1001000: ERROR: Script execution failed (use -d to debug)
176|_sslv2-drown:
177
178Device type: general purpose|VoIP phone
179Running (JUST GUESSING): Linux 3.X|2.6.X (95%), Grandstream embedded (88%)
180OS CPE: cpe:/o:linux:linux_kernel:3 cpe:/h:grandstream:gxv3275 cpe:/o:linux:linux_kernel:2.6
181Aggressive OS guesses: Linux 3.2 - 3.8 (95%), Grandstream GXV3275 video phone (88%), Linux 2.6.32 - 2.6.33 (87%), Linux 3.3 (87%), Linux 2.6.32 - 2.6.39 (86%), Linux 3.6 (86%), Linux 2.6.38 (85%), Linux 3.18 (85%)
182No exact OS matches for host (test conditions non-ideal).
183
184========================
185 REPORT 2
186========================
187<?php
188class JConfig {
189 public $MetaAuthor = '1';
190 public $MetaDesc = 'Alonço Imóveis, Imobiliária especializada em bons negócios e atendimento personalizado, faça contato conosco agora mesmo!';
191 public $MetaKeys = 'Alonço Imóveis, Alonco imoveis, aloncoimoveis, imobiliária alonço, alonço jacareí, alonço imóveis, casas a venda, casas venda jacareí, apartamentos, locação de apartamento, terrenos em jacareí, empreendimento imobiliário em jacareí, alonço vale do paraíba, alonco, alonco caragua, caraguatatuba, santa';
192 public $MetaRights = '';
193 public $MetaTitle = '1';
194 public $MetaVersion = '0';
195 public $access = '1';
196 public $cache_handler = 'file';
197 public $cachetime = '15';
198 public $caching = '0';
199 public $captcha = '0';
200 public $cookie_domain = '';
201 public $cookie_path = '';
202 public $db = 'aloncoimoveis04';
203 public $dbprefix = 'jx1pt_';
204 public $dbtype = 'mysql';
205 public $debug = '0';
206 public $debug_lang = '0';
207 public $display_offline_message = '1';
208 public $editor = 'tinymce';
209 public $error_reporting = 'none';
210 public $feed_email = 'none';
211 public $feed_limit = '10';
212 public $force_ssl = '0';
213 public $fromname = 'Alonço Imoveis';
214 public $ftp_enable = '0';
215 public $ftp_host = '';
216 public $ftp_pass = '';
217 public $ftp_port = '21';
218 public $ftp_root = '';
219 public $ftp_user = '';
220 public $gzip = '0';
221 public $helpurl = '';
222 public $host = 'mysql.aloncoimoveis.com.br';
223 public $lifetime = '15';
224 public $list_limit = '20';
225 public $live_site = '';
226 public $log_path = '/home/aloncoimoveis/www/logs';
227 public $mailer = 'mail';
228 public $mailfrom = 'contato@aloncoimoveis.com.br';
229 public $memcache_compress = '0';
230 public $memcache_persist = '1';
231 public $memcache_server_host = 'localhost';
232 public $memcache_server_port = '11211';
233 public $offline = '0';
234 public $offline_image = '';
235 public $offline_message = 'Este site está fora do ar para manutenção.<br />Tente novamente mais tarde.';
236 public $offset = 'America/Sao_Paulo';
237 public $offset_user = 'UTC';
238 public $password = 'imoveisal3138';
239 public $robots = '';
240 public $secret = '6hwiswBfQepVT1WuncUNZVOIdYgs2HZ2';
241 public $sef = '1';
242 public $sef_rewrite = '1';
243 public $sef_suffix = '1';
244 public $sendmail = '/usr/sbin/sendmail';
245 public $session_handler = 'none';
246 public $sitename = 'Alonço Imoveis';
247 public $sitename_pagetitles = '2';
248 public $smtpauth = '0';
249 public $smtphost = 'localhost';
250 public $smtppass = '';
251 public $smtpport = '25';
252 public $smtpsecure = 'none';
253 public $smtpuser = '';
254 public $tmp_path = '/home/aloncoimoveis/www/tmp';
255 public $unicodeslugs = '0';
256 public $user = 'aloncoimoveis04';
257 public $mailonline = '1';
258 public $cache_platformprefix = '0';
259 public $memcached_persist = '1';
260 public $memcached_compress = '0';
261 public $memcached_server_host = 'localhost';
262 public $memcached_server_port = '11211';
263 public $redis_persist = '1';
264 public $redis_server_host = 'localhost';
265 public $redis_server_port = '6379';
266 public $redis_server_db = '0';
267 public $proxy_enable = '0';
268 public $massmailoff = '0';
269 public $session_memcache_server_host = 'localhost';
270 public $session_memcache_server_port = '11211';
271 public $session_memcached_server_host = 'localhost';
272 public $session_memcached_server_port = '11211';
273 public $frontediting = '1';
274 public $asset_id = '1';
275}
276
277========================
278 REPORT 3
279========================
280
281
282
283
284
285
286-- phpMyAdmin SQL Dump
287-- version 4.3.7
288-- http://www.phpmyadmin.net
289--
290-- Host: mysql03-farm58.kinghost.net
291-- Tempo de geração: 31/10/2019 às 17:53
292-- Versão do servidor: 5.5.43-log
293-- Versão do PHP: 5.3.28
294
295SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
296SET time_zone = "+00:00";
297
298
299/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
300/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
301/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
302/*!40101 SET NAMES utf8 */;
303
304--
305-- Banco de dados: `aloncoimoveis04`
306--
307
308-- --------------------------------------------------------
309
310--
311-- Estrutura para tabela `jx1pt_akeeba_common`
312--
313
314CREATE TABLE IF NOT EXISTS `jx1pt_akeeba_common` (
315 `key` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
316 `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL
317) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
318
319-- --------------------------------------------------------
320
321--
322-- Estrutura para tabela `jx1pt_ak_profiles`
323--
324
325CREATE TABLE IF NOT EXISTS `jx1pt_ak_profiles` (
326 `id` int(10) unsigned NOT NULL,
327 `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
328 `configuration` longtext COLLATE utf8mb4_unicode_ci,
329 `filters` longtext COLLATE utf8mb4_unicode_ci,
330 `quickicon` tinyint(3) NOT NULL DEFAULT '1'
331) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
332
333-- --------------------------------------------------------
334
335--
336-- Estrutura para tabela `jx1pt_ak_stats`
337--
338
339CREATE TABLE IF NOT EXISTS `jx1pt_ak_stats` (
340 `id` bigint(20) unsigned NOT NULL,
341 `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
342 `comment` longtext COLLATE utf8mb4_unicode_ci,
343 `backupstart` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
344 `backupend` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
345 `status` enum('run','fail','complete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'run',
346 `origin` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'backend',
347 `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'full',
348 `profile_id` bigint(20) NOT NULL DEFAULT '1',
349 `archivename` longtext COLLATE utf8mb4_unicode_ci,
350 `absolute_path` longtext COLLATE utf8mb4_unicode_ci,
351 `multipart` int(11) NOT NULL DEFAULT '0',
352 `tag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
353 `backupid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
354 `filesexist` tinyint(3) NOT NULL DEFAULT '1',
355 `remote_filename` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
356 `total_size` bigint(20) NOT NULL DEFAULT '0'
357) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
358
359-- --------------------------------------------------------
360
361--
362-- Estrutura para tabela `jx1pt_ak_storage`
363--
364
365CREATE TABLE IF NOT EXISTS `jx1pt_ak_storage` (
366 `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
367 `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
368 `data` longtext COLLATE utf8mb4_unicode_ci
369) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
370
371-- --------------------------------------------------------
372
373--
374-- Estrutura para tabela `jx1pt_assets`
375--
376
377CREATE TABLE IF NOT EXISTS `jx1pt_assets` (
378 `id` int(10) unsigned NOT NULL COMMENT 'Primary Key',
379 `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
380 `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
381 `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
382 `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
383 `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The unique name for the asset.\n',
384 `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.',
385 `rules` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.'
386) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
387
388-- --------------------------------------------------------
389
390--
391-- Estrutura para tabela `jx1pt_associations`
392--
393
394CREATE TABLE IF NOT EXISTS `jx1pt_associations` (
395 `id` int(11) NOT NULL COMMENT 'A reference to the associated item.',
396 `context` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The context of the associated item.',
397 `key` char(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.'
398) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
399
400-- --------------------------------------------------------
401
402--
403-- Estrutura para tabela `jx1pt_banners`
404--
405
406CREATE TABLE IF NOT EXISTS `jx1pt_banners` (
407 `id` int(11) NOT NULL,
408 `cid` int(11) NOT NULL DEFAULT '0',
409 `type` int(11) NOT NULL DEFAULT '0',
410 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
411 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
412 `imptotal` int(11) NOT NULL DEFAULT '0',
413 `impmade` int(11) NOT NULL DEFAULT '0',
414 `clicks` int(11) NOT NULL DEFAULT '0',
415 `clickurl` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
416 `state` tinyint(3) NOT NULL DEFAULT '0',
417 `catid` int(10) unsigned NOT NULL DEFAULT '0',
418 `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
419 `custombannercode` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
420 `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
421 `ordering` int(11) NOT NULL DEFAULT '0',
422 `metakey` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
423 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
424 `own_prefix` tinyint(1) NOT NULL DEFAULT '0',
425 `metakey_prefix` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
426 `purchase_type` tinyint(4) NOT NULL DEFAULT '-1',
427 `track_clicks` tinyint(4) NOT NULL DEFAULT '-1',
428 `track_impressions` tinyint(4) NOT NULL DEFAULT '-1',
429 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
430 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
431 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
432 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
433 `reset` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
434 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
435 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
436 `created_by` int(10) unsigned NOT NULL DEFAULT '0',
437 `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
438 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
439 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
440 `version` int(10) unsigned NOT NULL DEFAULT '1'
441) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
442
443-- --------------------------------------------------------
444
445--
446-- Estrutura para tabela `jx1pt_banner_clients`
447--
448
449CREATE TABLE IF NOT EXISTS `jx1pt_banner_clients` (
450 `id` int(11) NOT NULL,
451 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
452 `contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
453 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
454 `extrainfo` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
455 `state` tinyint(3) NOT NULL DEFAULT '0',
456 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
457 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
458 `metakey` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
459 `own_prefix` tinyint(4) NOT NULL DEFAULT '0',
460 `metakey_prefix` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
461 `purchase_type` tinyint(4) NOT NULL DEFAULT '-1',
462 `track_clicks` tinyint(4) NOT NULL DEFAULT '-1',
463 `track_impressions` tinyint(4) NOT NULL DEFAULT '-1'
464) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
465
466-- --------------------------------------------------------
467
468--
469-- Estrutura para tabela `jx1pt_banner_tracks`
470--
471
472CREATE TABLE IF NOT EXISTS `jx1pt_banner_tracks` (
473 `track_date` datetime NOT NULL,
474 `track_type` int(10) unsigned NOT NULL,
475 `banner_id` int(10) unsigned NOT NULL,
476 `count` int(10) unsigned NOT NULL DEFAULT '0'
477) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
478
479-- --------------------------------------------------------
480
481--
482-- Estrutura para tabela `jx1pt_categories`
483--
484
485CREATE TABLE IF NOT EXISTS `jx1pt_categories` (
486 `id` int(11) NOT NULL,
487 `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
488 `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
489 `lft` int(11) NOT NULL DEFAULT '0',
490 `rgt` int(11) NOT NULL DEFAULT '0',
491 `level` int(10) unsigned NOT NULL DEFAULT '0',
492 `path` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
493 `extension` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
494 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
495 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
496 `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
497 `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
498 `published` tinyint(1) NOT NULL DEFAULT '0',
499 `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
500 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
501 `access` int(10) unsigned NOT NULL DEFAULT '0',
502 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
503 `metadesc` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'The meta description for the page.',
504 `metakey` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'The meta keywords for the page.',
505 `metadata` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.',
506 `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
507 `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
508 `modified_user_id` int(10) unsigned NOT NULL DEFAULT '0',
509 `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
510 `hits` int(10) unsigned NOT NULL DEFAULT '0',
511 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
512 `version` int(10) unsigned NOT NULL DEFAULT '1'
513) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
514
515-- --------------------------------------------------------
516
517--
518-- Estrutura para tabela `jx1pt_contact_details`
519--
520
521CREATE TABLE IF NOT EXISTS `jx1pt_contact_details` (
522 `id` int(11) NOT NULL,
523 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
524 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
525 `con_position` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
526 `address` mediumtext COLLATE utf8mb4_unicode_ci,
527 `suburb` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
528 `state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
529 `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
530 `postcode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
531 `telephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
532 `fax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
533 `misc` longtext COLLATE utf8mb4_unicode_ci,
534 `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
535 `email_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
536 `default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
537 `published` tinyint(1) NOT NULL DEFAULT '0',
538 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
539 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
540 `ordering` int(11) NOT NULL DEFAULT '0',
541 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
542 `user_id` int(11) NOT NULL DEFAULT '0',
543 `catid` int(11) NOT NULL DEFAULT '0',
544 `access` int(10) unsigned NOT NULL DEFAULT '0',
545 `mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
546 `webpage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
547 `sortname1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
548 `sortname2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
549 `sortname3` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
550 `language` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL,
551 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
552 `created_by` int(10) unsigned NOT NULL DEFAULT '0',
553 `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
554 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
555 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
556 `metakey` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
557 `metadesc` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
558 `metadata` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
559 `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if article is featured.',
560 `xreference` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
561 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
562 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
563 `version` int(10) unsigned NOT NULL DEFAULT '1',
564 `hits` int(10) unsigned NOT NULL DEFAULT '0'
565) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
566
567-- --------------------------------------------------------
568
569--
570-- Estrutura para tabela `jx1pt_content`
571--
572
573CREATE TABLE IF NOT EXISTS `jx1pt_content` (
574 `id` int(10) unsigned NOT NULL,
575 `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
576 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
577 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
578 `introtext` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
579 `fulltext` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
580 `state` tinyint(3) NOT NULL DEFAULT '0',
581 `catid` int(10) unsigned NOT NULL DEFAULT '0',
582 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
583 `created_by` int(10) unsigned NOT NULL DEFAULT '0',
584 `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
585 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
586 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
587 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
588 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
589 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
590 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
591 `images` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
592 `urls` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
593 `attribs` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL,
594 `version` int(10) unsigned NOT NULL DEFAULT '1',
595 `ordering` int(11) NOT NULL DEFAULT '0',
596 `metakey` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
597 `metadesc` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
598 `access` int(10) unsigned NOT NULL DEFAULT '0',
599 `hits` int(10) unsigned NOT NULL DEFAULT '0',
600 `metadata` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
601 `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if article is featured.',
602 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The language code for the article.',
603 `xreference` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
604) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
605
606-- --------------------------------------------------------
607
608--
609-- Estrutura para tabela `jx1pt_contentitem_tag_map`
610--
611
612CREATE TABLE IF NOT EXISTS `jx1pt_contentitem_tag_map` (
613 `type_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
614 `core_content_id` int(10) unsigned NOT NULL COMMENT 'PK from the core content table',
615 `content_item_id` int(11) NOT NULL COMMENT 'PK from the content type table',
616 `tag_id` int(10) unsigned NOT NULL COMMENT 'PK from the tag table',
617 `tag_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of most recent save for this tag-item',
618 `type_id` mediumint(8) NOT NULL COMMENT 'PK from the content_type table'
619) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Maps items from content tables to tags';
620
621-- --------------------------------------------------------
622
623--
624-- Estrutura para tabela `jx1pt_content_frontpage`
625--
626
627CREATE TABLE IF NOT EXISTS `jx1pt_content_frontpage` (
628 `content_id` int(11) NOT NULL DEFAULT '0',
629 `ordering` int(11) NOT NULL DEFAULT '0'
630) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
631
632-- --------------------------------------------------------
633
634--
635-- Estrutura para tabela `jx1pt_content_rating`
636--
637
638CREATE TABLE IF NOT EXISTS `jx1pt_content_rating` (
639 `content_id` int(11) NOT NULL DEFAULT '0',
640 `rating_sum` int(10) unsigned NOT NULL DEFAULT '0',
641 `rating_count` int(10) unsigned NOT NULL DEFAULT '0',
642 `lastip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
643) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
644
645-- --------------------------------------------------------
646
647--
648-- Estrutura para tabela `jx1pt_content_types`
649--
650
651CREATE TABLE IF NOT EXISTS `jx1pt_content_types` (
652 `type_id` int(10) unsigned NOT NULL,
653 `type_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
654 `type_alias` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
655 `table` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
656 `rules` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
657 `field_mappings` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
658 `router` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
659 `content_history_options` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON string for com_contenthistory options'
660) ENGINE=InnoDB AUTO_INCREMENT=10005 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
661
662-- --------------------------------------------------------
663
664--
665-- Estrutura para tabela `jx1pt_core_log_searches`
666--
667
668CREATE TABLE IF NOT EXISTS `jx1pt_core_log_searches` (
669 `search_term` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
670 `hits` int(10) unsigned NOT NULL DEFAULT '0'
671) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
672
673-- --------------------------------------------------------
674
675--
676-- Estrutura para tabela `jx1pt_extensions`
677--
678
679CREATE TABLE IF NOT EXISTS `jx1pt_extensions` (
680 `extension_id` int(11) NOT NULL,
681 `package_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Parent package ID for extensions installed as a package.',
682 `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
683 `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
684 `element` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
685 `folder` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
686 `client_id` tinyint(3) NOT NULL,
687 `enabled` tinyint(3) NOT NULL DEFAULT '0',
688 `access` int(10) unsigned NOT NULL DEFAULT '1',
689 `protected` tinyint(3) NOT NULL DEFAULT '0',
690 `manifest_cache` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
691 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
692 `custom_data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
693 `system_data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
694 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
695 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
696 `ordering` int(11) DEFAULT '0',
697 `state` int(11) DEFAULT '0'
698) ENGINE=InnoDB AUTO_INCREMENT=10127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
699
700-- --------------------------------------------------------
701
702--
703-- Estrutura para tabela `jx1pt_fields`
704--
705
706CREATE TABLE IF NOT EXISTS `jx1pt_fields` (
707 `id` int(10) unsigned NOT NULL,
708 `asset_id` int(10) unsigned NOT NULL DEFAULT '0',
709 `context` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
710 `group_id` int(10) unsigned NOT NULL DEFAULT '0',
711 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
712 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
713 `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
714 `default_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
715 `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
716 `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
717 `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
718 `state` tinyint(1) NOT NULL DEFAULT '0',
719 `required` tinyint(1) NOT NULL DEFAULT '0',
720 `checked_out` int(11) NOT NULL DEFAULT '0',
721 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
722 `ordering` int(11) NOT NULL DEFAULT '0',
723 `params` text COLLATE utf8mb4_unicode_ci NOT NULL,
724 `fieldparams` text COLLATE utf8mb4_unicode_ci NOT NULL,
725 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
726 `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
727 `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
728 `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
729 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
730 `access` int(11) NOT NULL DEFAULT '1'
731) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
732
733-- --------------------------------------------------------
734
735--
736-- Estrutura para tabela `jx1pt_fields_categories`
737--
738
739CREATE TABLE IF NOT EXISTS `jx1pt_fields_categories` (
740 `field_id` int(11) NOT NULL DEFAULT '0',
741 `category_id` int(11) NOT NULL DEFAULT '0'
742) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
743
744-- --------------------------------------------------------
745
746--
747-- Estrutura para tabela `jx1pt_fields_groups`
748--
749
750CREATE TABLE IF NOT EXISTS `jx1pt_fields_groups` (
751 `id` int(10) unsigned NOT NULL,
752 `asset_id` int(10) unsigned NOT NULL DEFAULT '0',
753 `context` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
754 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
755 `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
756 `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
757 `state` tinyint(1) NOT NULL DEFAULT '0',
758 `checked_out` int(11) NOT NULL DEFAULT '0',
759 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
760 `ordering` int(11) NOT NULL DEFAULT '0',
761 `params` text COLLATE utf8mb4_unicode_ci NOT NULL,
762 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
763 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
764 `created_by` int(10) unsigned NOT NULL DEFAULT '0',
765 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
766 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
767 `access` int(11) NOT NULL DEFAULT '1'
768) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
769
770-- --------------------------------------------------------
771
772--
773-- Estrutura para tabela `jx1pt_fields_values`
774--
775
776CREATE TABLE IF NOT EXISTS `jx1pt_fields_values` (
777 `field_id` int(10) unsigned NOT NULL,
778 `item_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Allow references to items which have strings as ids, eg. none db systems.',
779 `value` text COLLATE utf8mb4_unicode_ci NOT NULL
780) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
781
782-- --------------------------------------------------------
783
784--
785-- Estrutura para tabela `jx1pt_finder_filters`
786--
787
788CREATE TABLE IF NOT EXISTS `jx1pt_finder_filters` (
789 `filter_id` int(10) unsigned NOT NULL,
790 `title` varchar(255) NOT NULL,
791 `alias` varchar(255) NOT NULL,
792 `state` tinyint(1) NOT NULL DEFAULT '1',
793 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
794 `created_by` int(10) unsigned NOT NULL,
795 `created_by_alias` varchar(255) NOT NULL,
796 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
797 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
798 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
799 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
800 `map_count` int(10) unsigned NOT NULL DEFAULT '0',
801 `data` mediumtext NOT NULL,
802 `params` longtext
803) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
804
805-- --------------------------------------------------------
806
807--
808-- Estrutura para tabela `jx1pt_finder_links`
809--
810
811CREATE TABLE IF NOT EXISTS `jx1pt_finder_links` (
812 `link_id` int(10) unsigned NOT NULL,
813 `url` varchar(255) NOT NULL,
814 `route` varchar(255) NOT NULL,
815 `title` varchar(400) DEFAULT NULL,
816 `description` mediumtext,
817 `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
818 `md5sum` varchar(32) DEFAULT NULL,
819 `published` tinyint(1) NOT NULL DEFAULT '1',
820 `state` int(5) DEFAULT '1',
821 `access` int(5) DEFAULT '0',
822 `language` varchar(8) NOT NULL,
823 `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
824 `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
825 `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
826 `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
827 `list_price` double unsigned NOT NULL DEFAULT '0',
828 `sale_price` double unsigned NOT NULL DEFAULT '0',
829 `type_id` int(11) NOT NULL,
830 `object` mediumblob NOT NULL
831) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
832
833-- --------------------------------------------------------
834
835--
836-- Estrutura para tabela `jx1pt_finder_links_terms0`
837--
838
839CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms0` (
840 `link_id` int(10) unsigned NOT NULL,
841 `term_id` int(10) unsigned NOT NULL,
842 `weight` float unsigned NOT NULL
843) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
844
845-- --------------------------------------------------------
846
847--
848-- Estrutura para tabela `jx1pt_finder_links_terms1`
849--
850
851CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms1` (
852 `link_id` int(10) unsigned NOT NULL,
853 `term_id` int(10) unsigned NOT NULL,
854 `weight` float unsigned NOT NULL
855) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
856
857-- --------------------------------------------------------
858
859--
860-- Estrutura para tabela `jx1pt_finder_links_terms2`
861--
862
863CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms2` (
864 `link_id` int(10) unsigned NOT NULL,
865 `term_id` int(10) unsigned NOT NULL,
866 `weight` float unsigned NOT NULL
867) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
868
869-- --------------------------------------------------------
870
871--
872-- Estrutura para tabela `jx1pt_finder_links_terms3`
873--
874
875CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms3` (
876 `link_id` int(10) unsigned NOT NULL,
877 `term_id` int(10) unsigned NOT NULL,
878 `weight` float unsigned NOT NULL
879) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
880
881-- --------------------------------------------------------
882
883--
884-- Estrutura para tabela `jx1pt_finder_links_terms4`
885--
886
887CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms4` (
888 `link_id` int(10) unsigned NOT NULL,
889 `term_id` int(10) unsigned NOT NULL,
890 `weight` float unsigned NOT NULL
891) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
892
893-- --------------------------------------------------------
894
895--
896-- Estrutura para tabela `jx1pt_finder_links_terms5`
897--
898
899CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms5` (
900 `link_id` int(10) unsigned NOT NULL,
901 `term_id` int(10) unsigned NOT NULL,
902 `weight` float unsigned NOT NULL
903) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
904
905-- --------------------------------------------------------
906
907--
908-- Estrutura para tabela `jx1pt_finder_links_terms6`
909--
910
911CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms6` (
912 `link_id` int(10) unsigned NOT NULL,
913 `term_id` int(10) unsigned NOT NULL,
914 `weight` float unsigned NOT NULL
915) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
916
917-- --------------------------------------------------------
918
919--
920-- Estrutura para tabela `jx1pt_finder_links_terms7`
921--
922
923CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms7` (
924 `link_id` int(10) unsigned NOT NULL,
925 `term_id` int(10) unsigned NOT NULL,
926 `weight` float unsigned NOT NULL
927) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
928
929-- --------------------------------------------------------
930
931--
932-- Estrutura para tabela `jx1pt_finder_links_terms8`
933--
934
935CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms8` (
936 `link_id` int(10) unsigned NOT NULL,
937 `term_id` int(10) unsigned NOT NULL,
938 `weight` float unsigned NOT NULL
939) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
940
941-- --------------------------------------------------------
942
943--
944-- Estrutura para tabela `jx1pt_finder_links_terms9`
945--
946
947CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_terms9` (
948 `link_id` int(10) unsigned NOT NULL,
949 `term_id` int(10) unsigned NOT NULL,
950 `weight` float unsigned NOT NULL
951) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
952
953-- --------------------------------------------------------
954
955--
956-- Estrutura para tabela `jx1pt_finder_links_termsa`
957--
958
959CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_termsa` (
960 `link_id` int(10) unsigned NOT NULL,
961 `term_id` int(10) unsigned NOT NULL,
962 `weight` float unsigned NOT NULL
963) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
964
965-- --------------------------------------------------------
966
967--
968-- Estrutura para tabela `jx1pt_finder_links_termsb`
969--
970
971CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_termsb` (
972 `link_id` int(10) unsigned NOT NULL,
973 `term_id` int(10) unsigned NOT NULL,
974 `weight` float unsigned NOT NULL
975) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
976
977-- --------------------------------------------------------
978
979--
980-- Estrutura para tabela `jx1pt_finder_links_termsc`
981--
982
983CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_termsc` (
984 `link_id` int(10) unsigned NOT NULL,
985 `term_id` int(10) unsigned NOT NULL,
986 `weight` float unsigned NOT NULL
987) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
988
989-- --------------------------------------------------------
990
991--
992-- Estrutura para tabela `jx1pt_finder_links_termsd`
993--
994
995CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_termsd` (
996 `link_id` int(10) unsigned NOT NULL,
997 `term_id` int(10) unsigned NOT NULL,
998 `weight` float unsigned NOT NULL
999) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1000
1001-- --------------------------------------------------------
1002
1003--
1004-- Estrutura para tabela `jx1pt_finder_links_termse`
1005--
1006
1007CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_termse` (
1008 `link_id` int(10) unsigned NOT NULL,
1009 `term_id` int(10) unsigned NOT NULL,
1010 `weight` float unsigned NOT NULL
1011) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1012
1013-- --------------------------------------------------------
1014
1015--
1016-- Estrutura para tabela `jx1pt_finder_links_termsf`
1017--
1018
1019CREATE TABLE IF NOT EXISTS `jx1pt_finder_links_termsf` (
1020 `link_id` int(10) unsigned NOT NULL,
1021 `term_id` int(10) unsigned NOT NULL,
1022 `weight` float unsigned NOT NULL
1023) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1024
1025-- --------------------------------------------------------
1026
1027--
1028-- Estrutura para tabela `jx1pt_finder_taxonomy`
1029--
1030
1031CREATE TABLE IF NOT EXISTS `jx1pt_finder_taxonomy` (
1032 `id` int(10) unsigned NOT NULL,
1033 `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
1034 `title` varchar(255) NOT NULL,
1035 `state` tinyint(1) unsigned NOT NULL DEFAULT '1',
1036 `access` tinyint(1) unsigned NOT NULL DEFAULT '0',
1037 `ordering` tinyint(1) unsigned NOT NULL DEFAULT '0'
1038) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1039
1040-- --------------------------------------------------------
1041
1042--
1043-- Estrutura para tabela `jx1pt_finder_taxonomy_map`
1044--
1045
1046CREATE TABLE IF NOT EXISTS `jx1pt_finder_taxonomy_map` (
1047 `link_id` int(10) unsigned NOT NULL,
1048 `node_id` int(10) unsigned NOT NULL
1049) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1050
1051-- --------------------------------------------------------
1052
1053--
1054-- Estrutura para tabela `jx1pt_finder_terms`
1055--
1056
1057CREATE TABLE IF NOT EXISTS `jx1pt_finder_terms` (
1058 `term_id` int(10) unsigned NOT NULL,
1059 `term` varchar(75) NOT NULL,
1060 `stem` varchar(75) NOT NULL,
1061 `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
1062 `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
1063 `weight` float unsigned NOT NULL DEFAULT '0',
1064 `soundex` varchar(75) NOT NULL,
1065 `links` int(10) NOT NULL DEFAULT '0',
1066 `language` char(3) NOT NULL DEFAULT ''
1067) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1068
1069-- --------------------------------------------------------
1070
1071--
1072-- Estrutura para tabela `jx1pt_finder_terms_common`
1073--
1074
1075CREATE TABLE IF NOT EXISTS `jx1pt_finder_terms_common` (
1076 `term` varchar(75) NOT NULL,
1077 `language` varchar(3) NOT NULL
1078) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1079
1080-- --------------------------------------------------------
1081
1082--
1083-- Estrutura para tabela `jx1pt_finder_tokens`
1084--
1085
1086CREATE TABLE IF NOT EXISTS `jx1pt_finder_tokens` (
1087 `term` varchar(75) NOT NULL,
1088 `stem` varchar(75) NOT NULL,
1089 `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
1090 `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
1091 `weight` float unsigned NOT NULL DEFAULT '1',
1092 `context` tinyint(1) unsigned NOT NULL DEFAULT '2',
1093 `language` char(3) NOT NULL DEFAULT ''
1094) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4;
1095
1096-- --------------------------------------------------------
1097
1098--
1099-- Estrutura para tabela `jx1pt_finder_tokens_aggregate`
1100--
1101
1102CREATE TABLE IF NOT EXISTS `jx1pt_finder_tokens_aggregate` (
1103 `term_id` int(10) unsigned NOT NULL,
1104 `map_suffix` char(1) NOT NULL,
1105 `term` varchar(75) NOT NULL,
1106 `stem` varchar(75) NOT NULL,
1107 `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
1108 `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
1109 `term_weight` float unsigned NOT NULL,
1110 `context` tinyint(1) unsigned NOT NULL DEFAULT '2',
1111 `context_weight` float unsigned NOT NULL,
1112 `total_weight` float unsigned NOT NULL,
1113 `language` char(3) NOT NULL DEFAULT ''
1114) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4;
1115
1116-- --------------------------------------------------------
1117
1118--
1119-- Estrutura para tabela `jx1pt_finder_types`
1120--
1121
1122CREATE TABLE IF NOT EXISTS `jx1pt_finder_types` (
1123 `id` int(10) unsigned NOT NULL,
1124 `title` varchar(100) NOT NULL,
1125 `mime` varchar(100) NOT NULL
1126) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
1127
1128-- --------------------------------------------------------
1129
1130--
1131-- Estrutura para tabela `jx1pt_fsj_main_attachment`
1132--
1133
1134CREATE TABLE IF NOT EXISTS `jx1pt_fsj_main_attachment` (
1135 `id` int(10) unsigned NOT NULL,
1136 `params` text NOT NULL,
1137 `source` varchar(50) NOT NULL DEFAULT '',
1138 `source_id` int(11) NOT NULL DEFAULT '0',
1139 `dest` varchar(50) NOT NULL DEFAULT '',
1140 `dest_id` int(11) NOT NULL DEFAULT '0',
1141 `ordering` int(11) NOT NULL DEFAULT '0'
1142) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1143
1144-- --------------------------------------------------------
1145
1146--
1147-- Estrutura para tabela `jx1pt_fsj_main_related`
1148--
1149
1150CREATE TABLE IF NOT EXISTS `jx1pt_fsj_main_related` (
1151 `id` int(10) unsigned NOT NULL,
1152 `params` text NOT NULL,
1153 `source` varchar(50) NOT NULL DEFAULT '',
1154 `source_id` int(11) NOT NULL DEFAULT '0',
1155 `dest` varchar(50) NOT NULL DEFAULT '',
1156 `dest_id` int(11) NOT NULL DEFAULT '0',
1157 `ordering` int(11) NOT NULL DEFAULT '0'
1158) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1159
1160-- --------------------------------------------------------
1161
1162--
1163-- Estrutura para tabela `jx1pt_fsj_main_settings`
1164--
1165
1166CREATE TABLE IF NOT EXISTS `jx1pt_fsj_main_settings` (
1167 `id` int(10) unsigned NOT NULL,
1168 `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
1169 `lft` int(10) NOT NULL DEFAULT '0',
1170 `rgt` int(10) NOT NULL DEFAULT '0',
1171 `level` int(10) unsigned NOT NULL DEFAULT '0',
1172 `path` varchar(255) NOT NULL DEFAULT '',
1173 `alias` varchar(255) NOT NULL DEFAULT '',
1174 `j_asset` int(11) NOT NULL DEFAULT '0',
1175 `name` varchar(50) NOT NULL DEFAULT '',
1176 `title` varchar(100) NOT NULL DEFAULT '',
1177 `value` text NOT NULL
1178) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
1179
1180-- --------------------------------------------------------
1181
1182--
1183-- Estrutura para tabela `jx1pt_fsj_plg_plugin`
1184--
1185
1186CREATE TABLE IF NOT EXISTS `jx1pt_fsj_plg_plugin` (
1187 `id` int(10) unsigned NOT NULL,
1188 `state` tinyint(3) NOT NULL DEFAULT '0',
1189 `params` text NOT NULL,
1190 `type` varchar(50) NOT NULL DEFAULT '',
1191 `name` varchar(50) NOT NULL DEFAULT '',
1192 `path` varchar(250) NOT NULL DEFAULT '',
1193 `title` varchar(50) NOT NULL DEFAULT '',
1194 `description` varchar(250) NOT NULL DEFAULT '',
1195 `author` varchar(50) NOT NULL DEFAULT '',
1196 `settings` text NOT NULL
1197) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
1198
1199-- --------------------------------------------------------
1200
1201--
1202-- Estrutura para tabela `jx1pt_fsj_plg_type`
1203--
1204
1205CREATE TABLE IF NOT EXISTS `jx1pt_fsj_plg_type` (
1206 `id` int(10) unsigned NOT NULL,
1207 `params` text NOT NULL,
1208 `name` varchar(50) NOT NULL DEFAULT '',
1209 `path` varchar(250) NOT NULL DEFAULT '',
1210 `component` varchar(250) NOT NULL DEFAULT '',
1211 `title` varchar(50) NOT NULL DEFAULT '',
1212 `description` varchar(250) NOT NULL DEFAULT '',
1213 `author` varchar(50) NOT NULL DEFAULT '',
1214 `settings` text NOT NULL
1215) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1216
1217-- --------------------------------------------------------
1218
1219--
1220-- Estrutura para tabela `jx1pt_fsj_tpl_template`
1221--
1222
1223CREATE TABLE IF NOT EXISTS `jx1pt_fsj_tpl_template` (
1224 `id` int(10) unsigned NOT NULL,
1225 `component` varchar(50) NOT NULL DEFAULT '',
1226 `type` varchar(50) NOT NULL DEFAULT '',
1227 `name` varchar(50) NOT NULL DEFAULT '',
1228 `title` varchar(250) NOT NULL DEFAULT '',
1229 `description` text NOT NULL,
1230 `parsed` text NOT NULL,
1231 `params` text NOT NULL,
1232 `updated` int(11) NOT NULL DEFAULT '0',
1233 `noedit` int(11) NOT NULL DEFAULT '0',
1234 `base` varchar(50) NOT NULL DEFAULT ''
1235) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1236
1237-- --------------------------------------------------------
1238
1239--
1240-- Estrutura para tabela `jx1pt_fsj_tpl_type`
1241--
1242
1243CREATE TABLE IF NOT EXISTS `jx1pt_fsj_tpl_type` (
1244 `id` int(10) unsigned NOT NULL,
1245 `component` varchar(50) NOT NULL DEFAULT '',
1246 `type` varchar(50) NOT NULL DEFAULT '',
1247 `xmlfile` varchar(250) NOT NULL DEFAULT '',
1248 `instpath` varchar(250) NOT NULL DEFAULT '',
1249 `title` varchar(250) NOT NULL DEFAULT '',
1250 `description` text NOT NULL
1251) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1252
1253-- --------------------------------------------------------
1254
1255--
1256-- Estrutura para tabela `jx1pt_joomanager_ads`
1257--
1258
1259CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_ads` (
1260 `id` int(11) NOT NULL,
1261 `ads_title` varchar(256) NOT NULL,
1262 `price` decimal(11,2) NOT NULL,
1263 `ads_limit` int(11) NOT NULL,
1264 `pending_limit` int(11) NOT NULL,
1265 `auto_approve` int(1) NOT NULL,
1266 `auto_featured` int(1) NOT NULL,
1267 `auto_publish_review` int(1) NOT NULL,
1268 `show_editor` int(1) NOT NULL,
1269 `payment_methode` varchar(256) NOT NULL,
1270 `allow_category` varchar(256) NOT NULL,
1271 `published` int(1) NOT NULL,
1272 `description` longtext NOT NULL,
1273 `ads_type` varchar(256) NOT NULL,
1274 `renew_price` decimal(11,2) NOT NULL,
1275 `active_day` int(11) NOT NULL
1276) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1277
1278-- --------------------------------------------------------
1279
1280--
1281-- Estrutura para tabela `jx1pt_joomanager_alerts`
1282--
1283
1284CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_alerts` (
1285 `id` int(11) NOT NULL,
1286 `userid` int(11) NOT NULL,
1287 `alert_fields` text NOT NULL,
1288 `sendalerts` int(10) NOT NULL DEFAULT '0'
1289) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1290
1291-- --------------------------------------------------------
1292
1293--
1294-- Estrutura para tabela `jx1pt_joomanager_category`
1295--
1296
1297CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_category` (
1298 `id` int(11) NOT NULL,
1299 `category_name` varchar(200) NOT NULL,
1300 `category_image` mediumtext NOT NULL,
1301 `category_published` int(11) NOT NULL,
1302 `category_level` varchar(200) NOT NULL,
1303 `category_description` mediumtext NOT NULL,
1304 `rets` int(10) NOT NULL DEFAULT '0',
1305 `update_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1306 `ordering` int(11) NOT NULL
1307) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;
1308
1309-- --------------------------------------------------------
1310
1311--
1312-- Estrutura para tabela `jx1pt_joomanager_config`
1313--
1314
1315CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_config` (
1316 `name` varchar(200) NOT NULL,
1317 `value` mediumtext NOT NULL
1318) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1319
1320-- --------------------------------------------------------
1321
1322--
1323-- Estrutura para tabela `jx1pt_joomanager_fields`
1324--
1325
1326CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_fields` (
1327 `id` int(11) NOT NULL,
1328 `fieldname` varchar(200) NOT NULL DEFAULT '',
1329 `fieldtype` varchar(200) NOT NULL DEFAULT '',
1330 `searchable` tinyint(4) NOT NULL DEFAULT '0',
1331 `published` tinyint(4) NOT NULL DEFAULT '0',
1332 `required` tinyint(4) NOT NULL DEFAULT '0',
1333 `showon_list` int(11) NOT NULL DEFAULT '0',
1334 `showon_details` int(11) NOT NULL DEFAULT '0',
1335 `ordering` int(11) NOT NULL DEFAULT '0',
1336 `fieldsize` int(11) NOT NULL DEFAULT '0',
1337 `default_value` varchar(200) NOT NULL DEFAULT '',
1338 `rows` int(11) NOT NULL DEFAULT '0',
1339 `cols` int(11) NOT NULL DEFAULT '0',
1340 `height` int(11) NOT NULL DEFAULT '0',
1341 `width` int(11) NOT NULL DEFAULT '0',
1342 `date_format` varchar(200) NOT NULL DEFAULT '',
1343 `multiple` tinyint(11) NOT NULL DEFAULT '0',
1344 `readonly` tinyint(4) NOT NULL DEFAULT '0',
1345 `rets` int(10) NOT NULL DEFAULT '0',
1346 `options` mediumtext NOT NULL,
1347 `catids` text NOT NULL,
1348 `fieldtarget` varchar(256) NOT NULL,
1349 `fieldfilesize` varchar(256) NOT NULL
1350) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;
1351
1352-- --------------------------------------------------------
1353
1354--
1355-- Estrutura para tabela `jx1pt_joomanager_fields_values`
1356--
1357
1358CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_fields_values` (
1359 `id` int(11) NOT NULL,
1360 `rets` int(10) NOT NULL DEFAULT '0',
1361 `itemid` int(11) NOT NULL DEFAULT '0',
1362 `fieldid` int(11) NOT NULL DEFAULT '0',
1363 `value` mediumtext NOT NULL
1364) ENGINE=MyISAM AUTO_INCREMENT=9801 DEFAULT CHARSET=utf8;
1365
1366-- --------------------------------------------------------
1367
1368--
1369-- Estrutura para tabela `jx1pt_joomanager_items`
1370--
1371
1372CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_items` (
1373 `id` int(11) NOT NULL,
1374 `userid` int(11) NOT NULL DEFAULT '0',
1375 `category_id` varchar(256) NOT NULL DEFAULT '0',
1376 `agentid` text NOT NULL,
1377 `ListingID` text NOT NULL,
1378 `title` varchar(200) NOT NULL DEFAULT '',
1379 `published` tinyint(11) NOT NULL DEFAULT '0',
1380 `featured` tinyint(4) NOT NULL DEFAULT '0',
1381 `hits` int(11) NOT NULL DEFAULT '0',
1382 `show_contactform` int(11) NOT NULL DEFAULT '0',
1383 `show_tellafriend` int(11) NOT NULL DEFAULT '0',
1384 `show_googlemap` int(11) NOT NULL DEFAULT '1',
1385 `map_address` varchar(200) NOT NULL DEFAULT '',
1386 `allow_rating` int(11) NOT NULL DEFAULT '0',
1387 `allow_comments` int(11) NOT NULL DEFAULT '0',
1388 `rets` int(10) NOT NULL DEFAULT '0',
1389 `added_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1390 `modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1391 `ordering` int(11) NOT NULL,
1392 `author` int(11) NOT NULL,
1393 `author_alias` varchar(255) NOT NULL,
1394 `access_level` int(11) NOT NULL,
1395 `publish_date` datetime NOT NULL,
1396 `last_date` datetime NOT NULL,
1397 `meta_desc` varchar(255) NOT NULL,
1398 `meta_key` varchar(255) NOT NULL,
1399 `meta_robot` varchar(255) NOT NULL,
1400 `meta_author` varchar(255) NOT NULL,
1401 `ads_id` int(11) NOT NULL,
1402 `display` int(1) NOT NULL DEFAULT '1'
1403) ENGINE=MyISAM AUTO_INCREMENT=438 DEFAULT CHARSET=utf8;
1404
1405-- --------------------------------------------------------
1406
1407--
1408-- Estrutura para tabela `jx1pt_joomanager_items_xref`
1409--
1410
1411CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_items_xref` (
1412 `id` int(11) NOT NULL,
1413 `itemid` int(11) NOT NULL DEFAULT '0',
1414 `category_id` int(11) NOT NULL DEFAULT '0',
1415 `rets` int(10) NOT NULL DEFAULT '0'
1416) ENGINE=MyISAM AUTO_INCREMENT=689 DEFAULT CHARSET=utf8;
1417
1418-- --------------------------------------------------------
1419
1420--
1421-- Estrutura para tabela `jx1pt_joomanager_payment`
1422--
1423
1424CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_payment` (
1425 `id` int(11) NOT NULL,
1426 `name` varchar(256) NOT NULL,
1427 `className` varchar(256) NOT NULL,
1428 `published` int(1) NOT NULL,
1429 `params` longtext NOT NULL,
1430 `description` longtext NOT NULL
1431) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1432
1433-- --------------------------------------------------------
1434
1435--
1436-- Estrutura para tabela `jx1pt_joomanager_ratings`
1437--
1438
1439CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_ratings` (
1440 `id` varchar(11) NOT NULL DEFAULT '',
1441 `total_votes` int(11) NOT NULL DEFAULT '0',
1442 `total_value` int(11) NOT NULL DEFAULT '0',
1443 `used_uid` longtext,
1444 `comments` longtext
1445) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1446
1447-- --------------------------------------------------------
1448
1449--
1450-- Estrutura para tabela `jx1pt_joomanager_rets_fields`
1451--
1452
1453CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_rets_fields` (
1454 `id` int(12) NOT NULL,
1455 `value` longtext NOT NULL
1456) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1457
1458-- --------------------------------------------------------
1459
1460--
1461-- Estrutura para tabela `jx1pt_joomanager_subscription`
1462--
1463
1464CREATE TABLE IF NOT EXISTS `jx1pt_joomanager_subscription` (
1465 `id` int(11) NOT NULL,
1466 `user_id` int(11) NOT NULL,
1467 `ads_id` int(11) NOT NULL,
1468 `published` int(1) NOT NULL,
1469 `status` int(1) NOT NULL,
1470 `payment_id` int(11) NOT NULL,
1471 `createdData` date NOT NULL,
1472 `ads_title` varchar(256) NOT NULL,
1473 `price` decimal(11,2) NOT NULL,
1474 `ads_limit` int(11) NOT NULL,
1475 `pending_limit` int(11) NOT NULL,
1476 `auto_approve` int(1) NOT NULL,
1477 `auto_featured` int(1) NOT NULL,
1478 `auto_publish_review` int(1) NOT NULL,
1479 `show_editor` int(1) NOT NULL,
1480 `payment_status` int(1) NOT NULL,
1481 `allow_category` varchar(256) NOT NULL,
1482 `renew_price` decimal(11,2) NOT NULL,
1483 `active_day` int(11) NOT NULL,
1484 `payment_date` date NOT NULL
1485) ENGINE=MyISAM AUTO_INCREMENT=898 DEFAULT CHARSET=utf8;
1486
1487-- --------------------------------------------------------
1488
1489--
1490-- Estrutura para tabela `jx1pt_languages`
1491--
1492
1493CREATE TABLE IF NOT EXISTS `jx1pt_languages` (
1494 `lang_id` int(11) unsigned NOT NULL,
1495 `asset_id` int(10) unsigned NOT NULL DEFAULT '0',
1496 `lang_code` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
1497 `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1498 `title_native` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1499 `sef` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1500 `image` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
1501 `description` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
1502 `metakey` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1503 `metadesc` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1504 `sitename` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1505 `published` int(11) NOT NULL DEFAULT '0',
1506 `access` int(10) unsigned NOT NULL DEFAULT '0',
1507 `ordering` int(11) NOT NULL DEFAULT '0'
1508) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1509
1510-- --------------------------------------------------------
1511
1512--
1513-- Estrutura para tabela `jx1pt_menu`
1514--
1515
1516CREATE TABLE IF NOT EXISTS `jx1pt_menu` (
1517 `id` int(11) NOT NULL,
1518 `menutype` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype',
1519 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The display title of the menu item.',
1520 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'The SEF alias of the menu item.',
1521 `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1522 `path` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The computed path of the menu item based on the alias field.',
1523 `link` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The actually link the menu item refers to.',
1524 `type` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator',
1525 `published` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The published state of the menu link.',
1526 `parent_id` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'The parent menu item in the menu tree.',
1527 `level` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The relative level in the tree.',
1528 `component_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__extensions.id',
1529 `checked_out` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__users.id',
1530 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.',
1531 `browserNav` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The click behaviour of the link.',
1532 `access` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The access level required to view the menu item.',
1533 `img` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The image of the menu item.',
1534 `template_style_id` int(10) unsigned NOT NULL DEFAULT '0',
1535 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded data for the menu item.',
1536 `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
1537 `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
1538 `home` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Indicates if this menu item is the home or default page.',
1539 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1540 `client_id` tinyint(4) NOT NULL DEFAULT '0'
1541) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1542
1543-- --------------------------------------------------------
1544
1545--
1546-- Estrutura para tabela `jx1pt_menu_types`
1547--
1548
1549CREATE TABLE IF NOT EXISTS `jx1pt_menu_types` (
1550 `id` int(10) unsigned NOT NULL,
1551 `asset_id` int(10) unsigned NOT NULL DEFAULT '0',
1552 `menutype` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
1553 `title` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL,
1554 `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1555 `client_id` int(11) NOT NULL DEFAULT '0'
1556) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1557
1558-- --------------------------------------------------------
1559
1560--
1561-- Estrutura para tabela `jx1pt_messages`
1562--
1563
1564CREATE TABLE IF NOT EXISTS `jx1pt_messages` (
1565 `message_id` int(10) unsigned NOT NULL,
1566 `user_id_from` int(10) unsigned NOT NULL DEFAULT '0',
1567 `user_id_to` int(10) unsigned NOT NULL DEFAULT '0',
1568 `folder_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
1569 `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1570 `state` tinyint(1) NOT NULL DEFAULT '0',
1571 `priority` tinyint(1) unsigned NOT NULL DEFAULT '0',
1572 `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1573 `message` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
1574) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1575
1576-- --------------------------------------------------------
1577
1578--
1579-- Estrutura para tabela `jx1pt_messages_cfg`
1580--
1581
1582CREATE TABLE IF NOT EXISTS `jx1pt_messages_cfg` (
1583 `user_id` int(10) unsigned NOT NULL DEFAULT '0',
1584 `cfg_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1585 `cfg_value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
1586) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1587
1588-- --------------------------------------------------------
1589
1590--
1591-- Estrutura para tabela `jx1pt_mi_iptable`
1592--
1593
1594CREATE TABLE IF NOT EXISTS `jx1pt_mi_iptable` (
1595 `ip` varchar(40) NOT NULL COMMENT 'ip to char',
1596 `firsthacktime` datetime NOT NULL,
1597 `lasthacktime` datetime NOT NULL,
1598 `hackcount` int(11) NOT NULL DEFAULT '1',
1599 `autodelete` tinyint(4) NOT NULL DEFAULT '1'
1600) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1601
1602-- --------------------------------------------------------
1603
1604--
1605-- Estrutura para tabela `jx1pt_modules`
1606--
1607
1608CREATE TABLE IF NOT EXISTS `jx1pt_modules` (
1609 `id` int(11) NOT NULL,
1610 `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
1611 `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1612 `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1613 `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1614 `ordering` int(11) NOT NULL DEFAULT '0',
1615 `position` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1616 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
1617 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1618 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1619 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1620 `published` tinyint(1) NOT NULL DEFAULT '0',
1621 `module` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1622 `access` int(10) unsigned NOT NULL DEFAULT '0',
1623 `showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
1624 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1625 `client_id` tinyint(4) NOT NULL DEFAULT '0',
1626 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL
1627) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1628
1629-- --------------------------------------------------------
1630
1631--
1632-- Estrutura para tabela `jx1pt_modules_menu`
1633--
1634
1635CREATE TABLE IF NOT EXISTS `jx1pt_modules_menu` (
1636 `moduleid` int(11) NOT NULL DEFAULT '0',
1637 `menuid` int(11) NOT NULL DEFAULT '0'
1638) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1639
1640-- --------------------------------------------------------
1641
1642--
1643-- Estrutura para tabela `jx1pt_newsfeeds`
1644--
1645
1646CREATE TABLE IF NOT EXISTS `jx1pt_newsfeeds` (
1647 `catid` int(11) NOT NULL DEFAULT '0',
1648 `id` int(10) unsigned NOT NULL,
1649 `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1650 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
1651 `link` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
1652 `published` tinyint(1) NOT NULL DEFAULT '0',
1653 `numarticles` int(10) unsigned NOT NULL DEFAULT '1',
1654 `cache_time` int(10) unsigned NOT NULL DEFAULT '3600',
1655 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
1656 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1657 `ordering` int(11) NOT NULL DEFAULT '0',
1658 `rtl` tinyint(4) NOT NULL DEFAULT '0',
1659 `access` int(10) unsigned NOT NULL DEFAULT '0',
1660 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1661 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1662 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1663 `created_by` int(10) unsigned NOT NULL DEFAULT '0',
1664 `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1665 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1666 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
1667 `metakey` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1668 `metadesc` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1669 `metadata` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1670 `xreference` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1671 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1672 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1673 `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1674 `version` int(10) unsigned NOT NULL DEFAULT '1',
1675 `hits` int(10) unsigned NOT NULL DEFAULT '0',
1676 `images` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
1677) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1678
1679-- --------------------------------------------------------
1680
1681--
1682-- Estrutura para tabela `jx1pt_overrider`
1683--
1684
1685CREATE TABLE IF NOT EXISTS `jx1pt_overrider` (
1686 `id` int(10) NOT NULL COMMENT 'Primary Key',
1687 `constant` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
1688 `string` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
1689 `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
1690) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1691
1692-- --------------------------------------------------------
1693
1694--
1695-- Estrutura para tabela `jx1pt_phocamaps_icon`
1696--
1697
1698CREATE TABLE IF NOT EXISTS `jx1pt_phocamaps_icon` (
1699 `id` int(11) unsigned NOT NULL,
1700 `title` varchar(250) NOT NULL DEFAULT '',
1701 `alias` varchar(255) NOT NULL DEFAULT '',
1702 `url` text NOT NULL,
1703 `urls` text NOT NULL,
1704 `object` varchar(255) NOT NULL DEFAULT '',
1705 `objects` varchar(255) NOT NULL DEFAULT '',
1706 `objectshape` varchar(255) NOT NULL DEFAULT '',
1707 `published` tinyint(1) NOT NULL DEFAULT '0',
1708 `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
1709 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1710 `ordering` int(11) NOT NULL DEFAULT '0',
1711 `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
1712 `hits` int(11) NOT NULL DEFAULT '0',
1713 `params` text NOT NULL,
1714 `language` char(7) NOT NULL DEFAULT ''
1715) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
1716
1717-- --------------------------------------------------------
1718
1719--
1720-- Estrutura para tabela `jx1pt_phocamaps_map`
1721--
1722
1723CREATE TABLE IF NOT EXISTS `jx1pt_phocamaps_map` (
1724 `id` int(11) NOT NULL,
1725 `title` varchar(255) NOT NULL DEFAULT '',
1726 `alias` varchar(255) NOT NULL DEFAULT '',
1727 `width` int(5) NOT NULL DEFAULT '0',
1728 `height` int(5) NOT NULL DEFAULT '0',
1729 `latitude` varchar(20) NOT NULL DEFAULT '',
1730 `longitude` varchar(20) NOT NULL DEFAULT '',
1731 `zoom` int(3) NOT NULL DEFAULT '0',
1732 `lang` varchar(6) NOT NULL DEFAULT '',
1733 `border` tinyint(1) NOT NULL DEFAULT '0',
1734 `continuouszoom` tinyint(1) NOT NULL DEFAULT '0',
1735 `doubleclickzoom` tinyint(1) NOT NULL DEFAULT '0',
1736 `scrollwheelzoom` tinyint(1) NOT NULL DEFAULT '0',
1737 `zoomcontrol` tinyint(1) NOT NULL DEFAULT '0',
1738 `scalecontrol` tinyint(1) NOT NULL DEFAULT '0',
1739 `typeid` tinyint(1) NOT NULL DEFAULT '0',
1740 `typecontrol` tinyint(1) NOT NULL DEFAULT '0',
1741 `typecontrolposition` tinyint(1) NOT NULL DEFAULT '0',
1742 `collapsibleoverview` tinyint(1) NOT NULL DEFAULT '0',
1743 `dynamiclabel` tinyint(1) NOT NULL DEFAULT '0',
1744 `googlebar` tinyint(1) NOT NULL DEFAULT '0',
1745 `displayroute` tinyint(1) NOT NULL DEFAULT '0',
1746 `kmlfile` varchar(255) NOT NULL DEFAULT '',
1747 `description` text NOT NULL,
1748 `published` tinyint(1) NOT NULL DEFAULT '0',
1749 `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
1750 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1751 `ordering` int(11) NOT NULL DEFAULT '0',
1752 `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
1753 `hits` int(11) NOT NULL DEFAULT '0',
1754 `params` text NOT NULL,
1755 `language` char(7) NOT NULL DEFAULT ''
1756) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1757
1758-- --------------------------------------------------------
1759
1760--
1761-- Estrutura para tabela `jx1pt_phocamaps_marker`
1762--
1763
1764CREATE TABLE IF NOT EXISTS `jx1pt_phocamaps_marker` (
1765 `id` int(11) unsigned NOT NULL,
1766 `catid` int(11) NOT NULL DEFAULT '0',
1767 `title` varchar(250) NOT NULL DEFAULT '',
1768 `alias` varchar(255) NOT NULL DEFAULT '',
1769 `latitude` varchar(20) NOT NULL DEFAULT '',
1770 `longitude` varchar(20) NOT NULL DEFAULT '',
1771 `gpslatitude` varchar(50) NOT NULL DEFAULT '',
1772 `gpslongitude` varchar(50) NOT NULL DEFAULT '',
1773 `displaygps` tinyint(1) NOT NULL DEFAULT '0',
1774 `icon` tinyint(1) NOT NULL DEFAULT '0',
1775 `iconext` int(11) NOT NULL DEFAULT '0',
1776 `description` text NOT NULL,
1777 `contentwidth` varchar(8) NOT NULL DEFAULT '',
1778 `contentheight` varchar(8) NOT NULL DEFAULT '',
1779 `markerwindow` tinyint(1) NOT NULL DEFAULT '0',
1780 `published` tinyint(1) NOT NULL DEFAULT '0',
1781 `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
1782 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1783 `ordering` int(11) NOT NULL DEFAULT '0',
1784 `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
1785 `hits` int(11) NOT NULL DEFAULT '0',
1786 `params` text NOT NULL,
1787 `language` char(7) NOT NULL DEFAULT ''
1788) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1789
1790-- --------------------------------------------------------
1791
1792--
1793-- Estrutura para tabela `jx1pt_postinstall_messages`
1794--
1795
1796CREATE TABLE IF NOT EXISTS `jx1pt_postinstall_messages` (
1797 `postinstall_message_id` bigint(20) unsigned NOT NULL,
1798 `extension_id` bigint(20) NOT NULL DEFAULT '700' COMMENT 'FK to #__extensions',
1799 `title_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Lang key for the title',
1800 `description_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Lang key for description',
1801 `action_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1802 `language_extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'com_postinstall' COMMENT 'Extension holding lang keys',
1803 `language_client_id` tinyint(3) NOT NULL DEFAULT '1',
1804 `type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'link' COMMENT 'Message type - message, link, action',
1805 `action_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'RAD URI to the PHP file containing action method',
1806 `action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Action method name or URL',
1807 `condition_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'RAD URI to file holding display condition method',
1808 `condition_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Display condition method, must return boolean',
1809 `version_introduced` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '3.2.0' COMMENT 'Version when this message was introduced',
1810 `enabled` tinyint(3) NOT NULL DEFAULT '1'
1811) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1812
1813-- --------------------------------------------------------
1814
1815--
1816-- Estrutura para tabela `jx1pt_redirect_links`
1817--
1818
1819CREATE TABLE IF NOT EXISTS `jx1pt_redirect_links` (
1820 `id` int(10) unsigned NOT NULL,
1821 `old_url` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
1822 `new_url` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1823 `referer` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
1824 `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
1825 `hits` int(10) unsigned NOT NULL DEFAULT '0',
1826 `published` tinyint(4) NOT NULL,
1827 `created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1828 `modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1829 `header` smallint(3) NOT NULL DEFAULT '301'
1830) ENGINE=InnoDB AUTO_INCREMENT=884 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1831
1832-- --------------------------------------------------------
1833
1834--
1835-- Estrutura para tabela `jx1pt_rereplacer`
1836--
1837
1838CREATE TABLE IF NOT EXISTS `jx1pt_rereplacer` (
1839 `id` int(11) unsigned NOT NULL,
1840 `name` text NOT NULL,
1841 `description` text NOT NULL,
1842 `search` text NOT NULL,
1843 `replace` text NOT NULL,
1844 `area` text NOT NULL,
1845 `params` text NOT NULL,
1846 `published` tinyint(1) NOT NULL DEFAULT '0',
1847 `ordering` int(11) NOT NULL DEFAULT '0',
1848 `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
1849 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
1850) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1851
1852-- --------------------------------------------------------
1853
1854--
1855-- Estrutura para tabela `jx1pt_rokcandy`
1856--
1857
1858CREATE TABLE IF NOT EXISTS `jx1pt_rokcandy` (
1859 `id` int(11) unsigned NOT NULL,
1860 `catid` int(11) NOT NULL,
1861 `macro` text NOT NULL,
1862 `html` text NOT NULL,
1863 `published` tinyint(1) NOT NULL,
1864 `checked_out` int(11) NOT NULL,
1865 `checked_out_time` datetime NOT NULL,
1866 `ordering` int(11) NOT NULL,
1867 `params` text NOT NULL
1868) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
1869
1870-- --------------------------------------------------------
1871
1872--
1873-- Estrutura para tabela `jx1pt_rokcommon_configs`
1874--
1875
1876CREATE TABLE IF NOT EXISTS `jx1pt_rokcommon_configs` (
1877 `id` int(11) NOT NULL,
1878 `extension` varchar(45) NOT NULL DEFAULT '',
1879 `type` varchar(45) NOT NULL,
1880 `file` varchar(256) NOT NULL,
1881 `priority` int(10) NOT NULL DEFAULT '10'
1882) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
1883
1884-- --------------------------------------------------------
1885
1886--
1887-- Estrutura para tabela `jx1pt_roksprocket_items`
1888--
1889
1890CREATE TABLE IF NOT EXISTS `jx1pt_roksprocket_items` (
1891 `id` int(11) NOT NULL,
1892 `module_id` varchar(45) NOT NULL,
1893 `provider` varchar(45) NOT NULL,
1894 `provider_id` varchar(45) NOT NULL,
1895 `order` int(10) unsigned NOT NULL,
1896 `params` text
1897) ENGINE=InnoDB AUTO_INCREMENT=2741 DEFAULT CHARSET=utf8;
1898
1899-- --------------------------------------------------------
1900
1901--
1902-- Estrutura para tabela `jx1pt_rsfirewall_configuration`
1903--
1904
1905CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_configuration` (
1906 `name` varchar(255) NOT NULL,
1907 `value` text NOT NULL,
1908 `type` varchar(16) NOT NULL
1909) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1910
1911-- --------------------------------------------------------
1912
1913--
1914-- Estrutura para tabela `jx1pt_rsfirewall_exceptions`
1915--
1916
1917CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_exceptions` (
1918 `id` int(11) NOT NULL,
1919 `type` varchar(4) NOT NULL,
1920 `regex` tinyint(1) NOT NULL,
1921 `match` text NOT NULL,
1922 `php` tinyint(1) NOT NULL,
1923 `sql` tinyint(1) NOT NULL,
1924 `js` tinyint(1) NOT NULL,
1925 `uploads` tinyint(1) NOT NULL,
1926 `reason` text NOT NULL,
1927 `date` datetime NOT NULL,
1928 `published` tinyint(1) NOT NULL
1929) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1930
1931-- --------------------------------------------------------
1932
1933--
1934-- Estrutura para tabela `jx1pt_rsfirewall_feeds`
1935--
1936
1937CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_feeds` (
1938 `id` int(11) NOT NULL,
1939 `url` text NOT NULL,
1940 `limit` tinyint(4) NOT NULL,
1941 `ordering` int(11) NOT NULL,
1942 `published` tinyint(1) NOT NULL
1943) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1944
1945-- --------------------------------------------------------
1946
1947--
1948-- Estrutura para tabela `jx1pt_rsfirewall_hashes`
1949--
1950
1951CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_hashes` (
1952 `id` int(11) NOT NULL,
1953 `file` text NOT NULL,
1954 `hash` varchar(32) NOT NULL,
1955 `type` varchar(64) NOT NULL,
1956 `flag` varchar(1) NOT NULL,
1957 `date` varchar(255) NOT NULL
1958) ENGINE=InnoDB AUTO_INCREMENT=289 DEFAULT CHARSET=utf8;
1959
1960-- --------------------------------------------------------
1961
1962--
1963-- Estrutura para tabela `jx1pt_rsfirewall_ignored`
1964--
1965
1966CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_ignored` (
1967 `path` text NOT NULL,
1968 `type` varchar(255) NOT NULL
1969) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1970
1971-- --------------------------------------------------------
1972
1973--
1974-- Estrutura para tabela `jx1pt_rsfirewall_lists`
1975--
1976
1977CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_lists` (
1978 `id` int(11) NOT NULL,
1979 `ip` varchar(255) NOT NULL,
1980 `type` tinyint(1) NOT NULL,
1981 `reason` varchar(255) NOT NULL,
1982 `date` datetime NOT NULL,
1983 `published` tinyint(1) NOT NULL
1984) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1985
1986-- --------------------------------------------------------
1987
1988--
1989-- Estrutura para tabela `jx1pt_rsfirewall_logs`
1990--
1991
1992CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_logs` (
1993 `id` int(11) NOT NULL,
1994 `level` enum('low','medium','high','critical') NOT NULL,
1995 `date` datetime NOT NULL,
1996 `ip` varchar(255) NOT NULL,
1997 `user_id` int(11) NOT NULL,
1998 `username` varchar(255) NOT NULL,
1999 `page` text NOT NULL,
2000 `referer` text NOT NULL,
2001 `code` varchar(255) NOT NULL,
2002 `debug_variables` text NOT NULL
2003) ENGINE=InnoDB AUTO_INCREMENT=1939 DEFAULT CHARSET=utf8;
2004
2005-- --------------------------------------------------------
2006
2007--
2008-- Estrutura para tabela `jx1pt_rsfirewall_offenders`
2009--
2010
2011CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_offenders` (
2012 `id` int(11) NOT NULL,
2013 `ip` varchar(255) NOT NULL,
2014 `date` datetime NOT NULL
2015) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2016
2017-- --------------------------------------------------------
2018
2019--
2020-- Estrutura para tabela `jx1pt_rsfirewall_signatures`
2021--
2022
2023CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_signatures` (
2024 `signature` varchar(255) NOT NULL,
2025 `type` varchar(16) NOT NULL,
2026 `reason` varchar(255) NOT NULL
2027) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2028
2029-- --------------------------------------------------------
2030
2031--
2032-- Estrutura para tabela `jx1pt_rsfirewall_snapshots`
2033--
2034
2035CREATE TABLE IF NOT EXISTS `jx1pt_rsfirewall_snapshots` (
2036 `id` int(11) NOT NULL,
2037 `user_id` int(11) NOT NULL,
2038 `snapshot` text NOT NULL,
2039 `type` varchar(16) NOT NULL
2040) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
2041
2042-- --------------------------------------------------------
2043
2044--
2045-- Estrutura para tabela `jx1pt_schemas`
2046--
2047
2048CREATE TABLE IF NOT EXISTS `jx1pt_schemas` (
2049 `extension_id` int(11) NOT NULL,
2050 `version_id` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL
2051) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2052
2053-- --------------------------------------------------------
2054
2055--
2056-- Estrutura para tabela `jx1pt_session`
2057--
2058
2059CREATE TABLE IF NOT EXISTS `jx1pt_session` (
2060 `session_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2061 `client_id` tinyint(3) unsigned DEFAULT NULL,
2062 `guest` tinyint(4) unsigned DEFAULT '1',
2063 `time` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT '',
2064 `data` longtext COLLATE utf8mb4_unicode_ci,
2065 `userid` int(11) DEFAULT '0',
2066 `username` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT ''
2067) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2068
2069-- --------------------------------------------------------
2070
2071--
2072-- Estrutura para tabela `jx1pt_tags`
2073--
2074
2075CREATE TABLE IF NOT EXISTS `jx1pt_tags` (
2076 `id` int(10) unsigned NOT NULL,
2077 `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
2078 `lft` int(11) NOT NULL DEFAULT '0',
2079 `rgt` int(11) NOT NULL DEFAULT '0',
2080 `level` int(10) unsigned NOT NULL DEFAULT '0',
2081 `path` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2082 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2083 `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
2084 `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2085 `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
2086 `published` tinyint(1) NOT NULL DEFAULT '0',
2087 `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
2088 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2089 `access` int(10) unsigned NOT NULL DEFAULT '0',
2090 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2091 `metadesc` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The meta description for the page.',
2092 `metakey` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The meta keywords for the page.',
2093 `metadata` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded metadata properties.',
2094 `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
2095 `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2096 `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2097 `modified_user_id` int(10) unsigned NOT NULL DEFAULT '0',
2098 `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2099 `images` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2100 `urls` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2101 `hits` int(10) unsigned NOT NULL DEFAULT '0',
2102 `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
2103 `version` int(10) unsigned NOT NULL DEFAULT '1',
2104 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2105 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
2106) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2107
2108-- --------------------------------------------------------
2109
2110--
2111-- Estrutura para tabela `jx1pt_template_styles`
2112--
2113
2114CREATE TABLE IF NOT EXISTS `jx1pt_template_styles` (
2115 `id` int(10) unsigned NOT NULL,
2116 `template` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2117 `client_id` tinyint(1) unsigned NOT NULL DEFAULT '0',
2118 `home` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
2119 `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2120 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
2121) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2122
2123-- --------------------------------------------------------
2124
2125--
2126-- Estrutura para tabela `jx1pt_ucm_base`
2127--
2128
2129CREATE TABLE IF NOT EXISTS `jx1pt_ucm_base` (
2130 `ucm_id` int(10) unsigned NOT NULL,
2131 `ucm_item_id` int(10) NOT NULL,
2132 `ucm_type_id` int(11) NOT NULL,
2133 `ucm_language_id` int(11) NOT NULL
2134) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2135
2136-- --------------------------------------------------------
2137
2138--
2139-- Estrutura para tabela `jx1pt_ucm_content`
2140--
2141
2142CREATE TABLE IF NOT EXISTS `jx1pt_ucm_content` (
2143 `core_content_id` int(10) unsigned NOT NULL,
2144 `core_type_alias` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'FK to the content types table',
2145 `core_title` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2146 `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
2147 `core_body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
2148 `core_state` tinyint(1) NOT NULL DEFAULT '0',
2149 `core_checked_out_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0000-00-00 00:00:00',
2150 `core_checked_out_user_id` int(10) unsigned NOT NULL DEFAULT '0',
2151 `core_access` int(10) unsigned NOT NULL DEFAULT '0',
2152 `core_params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2153 `core_featured` tinyint(4) unsigned NOT NULL DEFAULT '0',
2154 `core_metadata` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.',
2155 `core_created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
2156 `core_created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2157 `core_created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2158 `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent user that modified',
2159 `core_modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2160 `core_language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2161 `core_publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2162 `core_publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2163 `core_content_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'ID from the individual type table',
2164 `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
2165 `core_images` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2166 `core_urls` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2167 `core_hits` int(10) unsigned NOT NULL DEFAULT '0',
2168 `core_version` int(10) unsigned NOT NULL DEFAULT '1',
2169 `core_ordering` int(11) NOT NULL DEFAULT '0',
2170 `core_metakey` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2171 `core_metadesc` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2172 `core_catid` int(10) unsigned NOT NULL DEFAULT '0',
2173 `core_xreference` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
2174 `core_type_id` int(10) unsigned NOT NULL DEFAULT '0'
2175) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Contains core content data in name spaced fields';
2176
2177-- --------------------------------------------------------
2178
2179--
2180-- Estrutura para tabela `jx1pt_ucm_history`
2181--
2182
2183CREATE TABLE IF NOT EXISTS `jx1pt_ucm_history` (
2184 `version_id` int(10) unsigned NOT NULL,
2185 `ucm_item_id` int(10) unsigned NOT NULL,
2186 `ucm_type_id` int(10) unsigned NOT NULL,
2187 `version_note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Optional version name',
2188 `save_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2189 `editor_user_id` int(10) unsigned NOT NULL DEFAULT '0',
2190 `character_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of characters in this version.',
2191 `sha1_hash` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'SHA1 hash of the version_data column.',
2192 `version_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'json-encoded string of version data',
2193 `keep_forever` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=auto delete; 1=keep'
2194) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2195
2196-- --------------------------------------------------------
2197
2198--
2199-- Estrutura para tabela `jx1pt_updates`
2200--
2201
2202CREATE TABLE IF NOT EXISTS `jx1pt_updates` (
2203 `update_id` int(11) NOT NULL,
2204 `update_site_id` int(11) DEFAULT '0',
2205 `extension_id` int(11) DEFAULT '0',
2206 `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
2207 `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2208 `element` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
2209 `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
2210 `folder` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
2211 `client_id` tinyint(3) DEFAULT '0',
2212 `version` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '',
2213 `data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2214 `detailsurl` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2215 `infourl` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2216 `extra_query` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT ''
2217) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';
2218
2219-- --------------------------------------------------------
2220
2221--
2222-- Estrutura para tabela `jx1pt_update_sites`
2223--
2224
2225CREATE TABLE IF NOT EXISTS `jx1pt_update_sites` (
2226 `update_site_id` int(11) NOT NULL,
2227 `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
2228 `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
2229 `location` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2230 `enabled` int(11) DEFAULT '0',
2231 `last_check_timestamp` bigint(20) DEFAULT '0',
2232 `extra_query` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT ''
2233) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites';
2234
2235-- --------------------------------------------------------
2236
2237--
2238-- Estrutura para tabela `jx1pt_update_sites_extensions`
2239--
2240
2241CREATE TABLE IF NOT EXISTS `jx1pt_update_sites_extensions` (
2242 `update_site_id` int(11) NOT NULL DEFAULT '0',
2243 `extension_id` int(11) NOT NULL DEFAULT '0'
2244) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites';
2245
2246-- --------------------------------------------------------
2247
2248--
2249-- Estrutura para tabela `jx1pt_usergroups`
2250--
2251
2252CREATE TABLE IF NOT EXISTS `jx1pt_usergroups` (
2253 `id` int(10) unsigned NOT NULL COMMENT 'Primary Key',
2254 `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
2255 `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
2256 `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
2257 `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
2258) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2259
2260-- --------------------------------------------------------
2261
2262--
2263-- Estrutura para tabela `jx1pt_users`
2264--
2265
2266CREATE TABLE IF NOT EXISTS `jx1pt_users` (
2267 `id` int(11) NOT NULL,
2268 `name` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2269 `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2270 `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2271 `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2272 `block` tinyint(4) NOT NULL DEFAULT '0',
2273 `sendEmail` tinyint(4) DEFAULT '0',
2274 `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2275 `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2276 `activation` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2277 `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2278 `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
2279 `resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime',
2280 `otpKey` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
2281 `otep` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
2282 `requireReset` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login'
2283) ENGINE=InnoDB AUTO_INCREMENT=983 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2284
2285-- --------------------------------------------------------
2286
2287--
2288-- Estrutura para tabela `jx1pt_user_keys`
2289--
2290
2291CREATE TABLE IF NOT EXISTS `jx1pt_user_keys` (
2292 `id` int(10) unsigned NOT NULL,
2293 `user_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
2294 `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
2295 `series` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
2296 `invalid` tinyint(4) NOT NULL,
2297 `time` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
2298 `uastring` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
2299) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2300
2301-- --------------------------------------------------------
2302
2303--
2304-- Estrutura para tabela `jx1pt_user_notes`
2305--
2306
2307CREATE TABLE IF NOT EXISTS `jx1pt_user_notes` (
2308 `id` int(10) unsigned NOT NULL,
2309 `user_id` int(10) unsigned NOT NULL DEFAULT '0',
2310 `catid` int(10) unsigned NOT NULL DEFAULT '0',
2311 `subject` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2312 `body` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2313 `state` tinyint(3) NOT NULL DEFAULT '0',
2314 `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
2315 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2316 `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
2317 `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2318 `modified_user_id` int(10) unsigned NOT NULL,
2319 `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2320 `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2321 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2322 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
2323) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2324
2325-- --------------------------------------------------------
2326
2327--
2328-- Estrutura para tabela `jx1pt_user_profiles`
2329--
2330
2331CREATE TABLE IF NOT EXISTS `jx1pt_user_profiles` (
2332 `user_id` int(11) NOT NULL,
2333 `profile_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
2334 `profile_value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
2335 `ordering` int(11) NOT NULL DEFAULT '0'
2336) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';
2337
2338-- --------------------------------------------------------
2339
2340--
2341-- Estrutura para tabela `jx1pt_user_usergroup_map`
2342--
2343
2344CREATE TABLE IF NOT EXISTS `jx1pt_user_usergroup_map` (
2345 `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id',
2346 `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id'
2347) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2348
2349-- --------------------------------------------------------
2350
2351--
2352-- Estrutura para tabela `jx1pt_utf8_conversion`
2353--
2354
2355CREATE TABLE IF NOT EXISTS `jx1pt_utf8_conversion` (
2356 `converted` tinyint(4) NOT NULL DEFAULT '0'
2357) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2358
2359-- --------------------------------------------------------
2360
2361--
2362-- Estrutura para tabela `jx1pt_viewlevels`
2363--
2364
2365CREATE TABLE IF NOT EXISTS `jx1pt_viewlevels` (
2366 `id` int(10) unsigned NOT NULL COMMENT 'Primary Key',
2367 `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
2368 `ordering` int(11) NOT NULL DEFAULT '0',
2369 `rules` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.'
2370) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2371
2372-- --------------------------------------------------------
2373
2374--
2375-- Estrutura para tabela `jx1pt_weblinks`
2376--
2377
2378CREATE TABLE IF NOT EXISTS `jx1pt_weblinks` (
2379 `id` int(10) unsigned NOT NULL,
2380 `catid` int(11) NOT NULL DEFAULT '0',
2381 `title` varchar(250) NOT NULL DEFAULT '',
2382 `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2383 `url` varchar(250) NOT NULL DEFAULT '',
2384 `description` text NOT NULL,
2385 `hits` int(11) NOT NULL DEFAULT '0',
2386 `state` tinyint(1) NOT NULL DEFAULT '0',
2387 `checked_out` int(11) NOT NULL DEFAULT '0',
2388 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2389 `ordering` int(11) NOT NULL DEFAULT '0',
2390 `access` int(11) NOT NULL DEFAULT '1',
2391 `params` text NOT NULL,
2392 `language` char(7) NOT NULL DEFAULT '',
2393 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2394 `created_by` int(10) unsigned NOT NULL DEFAULT '0',
2395 `created_by_alias` varchar(255) NOT NULL DEFAULT '',
2396 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2397 `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
2398 `metakey` text NOT NULL,
2399 `metadesc` text NOT NULL,
2400 `metadata` text NOT NULL,
2401 `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.',
2402 `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
2403 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2404 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2405 `version` int(10) unsigned NOT NULL DEFAULT '1',
2406 `images` text NOT NULL
2407) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2408
2409--
2410-- Índices de tabelas apagadas
2411--
2412
2413--
2414-- Índices de tabela `jx1pt_akeeba_common`
2415--
2416ALTER TABLE `jx1pt_akeeba_common`
2417 ADD PRIMARY KEY (`key`);
2418
2419--
2420-- Índices de tabela `jx1pt_ak_profiles`
2421--
2422ALTER TABLE `jx1pt_ak_profiles`
2423 ADD PRIMARY KEY (`id`);
2424
2425--
2426-- Índices de tabela `jx1pt_ak_stats`
2427--
2428ALTER TABLE `jx1pt_ak_stats`
2429 ADD PRIMARY KEY (`id`), ADD KEY `idx_fullstatus` (`filesexist`,`status`), ADD KEY `idx_stale` (`status`,`origin`);
2430
2431--
2432-- Índices de tabela `jx1pt_ak_storage`
2433--
2434ALTER TABLE `jx1pt_ak_storage`
2435 ADD PRIMARY KEY (`tag`(100));
2436
2437--
2438-- Índices de tabela `jx1pt_assets`
2439--
2440ALTER TABLE `jx1pt_assets`
2441 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_asset_name` (`name`), ADD KEY `idx_lft_rgt` (`lft`,`rgt`), ADD KEY `idx_parent_id` (`parent_id`);
2442
2443--
2444-- Índices de tabela `jx1pt_associations`
2445--
2446ALTER TABLE `jx1pt_associations`
2447 ADD PRIMARY KEY (`context`,`id`), ADD KEY `idx_key` (`key`);
2448
2449--
2450-- Índices de tabela `jx1pt_banners`
2451--
2452ALTER TABLE `jx1pt_banners`
2453 ADD PRIMARY KEY (`id`), ADD KEY `idx_state` (`state`), ADD KEY `idx_own_prefix` (`own_prefix`), ADD KEY `idx_banner_catid` (`catid`), ADD KEY `idx_language` (`language`), ADD KEY `idx_metakey_prefix` (`metakey_prefix`(100));
2454
2455--
2456-- Índices de tabela `jx1pt_banner_clients`
2457--
2458ALTER TABLE `jx1pt_banner_clients`
2459 ADD PRIMARY KEY (`id`), ADD KEY `idx_own_prefix` (`own_prefix`), ADD KEY `idx_metakey_prefix` (`metakey_prefix`(100));
2460
2461--
2462-- Índices de tabela `jx1pt_banner_tracks`
2463--
2464ALTER TABLE `jx1pt_banner_tracks`
2465 ADD PRIMARY KEY (`track_date`,`track_type`,`banner_id`), ADD KEY `idx_track_date` (`track_date`), ADD KEY `idx_track_type` (`track_type`), ADD KEY `idx_banner_id` (`banner_id`);
2466
2467--
2468-- Índices de tabela `jx1pt_categories`
2469--
2470ALTER TABLE `jx1pt_categories`
2471 ADD PRIMARY KEY (`id`), ADD KEY `cat_idx` (`extension`,`published`,`access`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_left_right` (`lft`,`rgt`), ADD KEY `idx_language` (`language`), ADD KEY `idx_path` (`path`(100)), ADD KEY `idx_alias` (`alias`(100));
2472
2473--
2474-- Índices de tabela `jx1pt_contact_details`
2475--
2476ALTER TABLE `jx1pt_contact_details`
2477 ADD PRIMARY KEY (`id`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_state` (`published`), ADD KEY `idx_catid` (`catid`), ADD KEY `idx_createdby` (`created_by`), ADD KEY `idx_featured_catid` (`featured`,`catid`), ADD KEY `idx_language` (`language`), ADD KEY `idx_xreference` (`xreference`);
2478
2479--
2480-- Índices de tabela `jx1pt_content`
2481--
2482ALTER TABLE `jx1pt_content`
2483 ADD PRIMARY KEY (`id`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_state` (`state`), ADD KEY `idx_catid` (`catid`), ADD KEY `idx_createdby` (`created_by`), ADD KEY `idx_featured_catid` (`featured`,`catid`), ADD KEY `idx_language` (`language`), ADD KEY `idx_xreference` (`xreference`), ADD KEY `idx_alias` (`alias`(191));
2484
2485--
2486-- Índices de tabela `jx1pt_contentitem_tag_map`
2487--
2488ALTER TABLE `jx1pt_contentitem_tag_map`
2489 ADD UNIQUE KEY `uc_ItemnameTagid` (`type_id`,`content_item_id`,`tag_id`), ADD KEY `idx_tag_type` (`tag_id`,`type_id`), ADD KEY `idx_date_id` (`tag_date`,`tag_id`), ADD KEY `idx_core_content_id` (`core_content_id`);
2490
2491--
2492-- Índices de tabela `jx1pt_content_frontpage`
2493--
2494ALTER TABLE `jx1pt_content_frontpage`
2495 ADD PRIMARY KEY (`content_id`);
2496
2497--
2498-- Índices de tabela `jx1pt_content_rating`
2499--
2500ALTER TABLE `jx1pt_content_rating`
2501 ADD PRIMARY KEY (`content_id`);
2502
2503--
2504-- Índices de tabela `jx1pt_content_types`
2505--
2506ALTER TABLE `jx1pt_content_types`
2507 ADD PRIMARY KEY (`type_id`), ADD KEY `idx_alias` (`type_alias`(100));
2508
2509--
2510-- Índices de tabela `jx1pt_extensions`
2511--
2512ALTER TABLE `jx1pt_extensions`
2513 ADD PRIMARY KEY (`extension_id`), ADD KEY `element_clientid` (`element`,`client_id`), ADD KEY `element_folder_clientid` (`element`,`folder`,`client_id`), ADD KEY `extension` (`type`,`element`,`folder`,`client_id`), ADD KEY `idx_1` (`element`,`enabled`);
2514
2515--
2516-- Índices de tabela `jx1pt_fields`
2517--
2518ALTER TABLE `jx1pt_fields`
2519 ADD PRIMARY KEY (`id`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_state` (`state`), ADD KEY `idx_created_user_id` (`created_user_id`), ADD KEY `idx_access` (`access`), ADD KEY `idx_language` (`language`), ADD KEY `idx_context` (`context`(191));
2520
2521--
2522-- Índices de tabela `jx1pt_fields_categories`
2523--
2524ALTER TABLE `jx1pt_fields_categories`
2525 ADD PRIMARY KEY (`field_id`,`category_id`);
2526
2527--
2528-- Índices de tabela `jx1pt_fields_groups`
2529--
2530ALTER TABLE `jx1pt_fields_groups`
2531 ADD PRIMARY KEY (`id`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_state` (`state`), ADD KEY `idx_created_by` (`created_by`), ADD KEY `idx_access` (`access`), ADD KEY `idx_language` (`language`), ADD KEY `idx_context` (`context`(191));
2532
2533--
2534-- Índices de tabela `jx1pt_fields_values`
2535--
2536ALTER TABLE `jx1pt_fields_values`
2537 ADD KEY `idx_field_id` (`field_id`), ADD KEY `idx_item_id` (`item_id`(191));
2538
2539--
2540-- Índices de tabela `jx1pt_finder_filters`
2541--
2542ALTER TABLE `jx1pt_finder_filters`
2543 ADD PRIMARY KEY (`filter_id`);
2544
2545--
2546-- Índices de tabela `jx1pt_finder_links`
2547--
2548ALTER TABLE `jx1pt_finder_links`
2549 ADD PRIMARY KEY (`link_id`), ADD KEY `idx_type` (`type_id`), ADD KEY `idx_md5` (`md5sum`), ADD KEY `idx_url` (`url`(75)), ADD KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`), ADD KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`), ADD KEY `idx_title` (`title`(100));
2550
2551--
2552-- Índices de tabela `jx1pt_finder_links_terms0`
2553--
2554ALTER TABLE `jx1pt_finder_links_terms0`
2555 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2556
2557--
2558-- Índices de tabela `jx1pt_finder_links_terms1`
2559--
2560ALTER TABLE `jx1pt_finder_links_terms1`
2561 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2562
2563--
2564-- Índices de tabela `jx1pt_finder_links_terms2`
2565--
2566ALTER TABLE `jx1pt_finder_links_terms2`
2567 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2568
2569--
2570-- Índices de tabela `jx1pt_finder_links_terms3`
2571--
2572ALTER TABLE `jx1pt_finder_links_terms3`
2573 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2574
2575--
2576-- Índices de tabela `jx1pt_finder_links_terms4`
2577--
2578ALTER TABLE `jx1pt_finder_links_terms4`
2579 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2580
2581--
2582-- Índices de tabela `jx1pt_finder_links_terms5`
2583--
2584ALTER TABLE `jx1pt_finder_links_terms5`
2585 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2586
2587--
2588-- Índices de tabela `jx1pt_finder_links_terms6`
2589--
2590ALTER TABLE `jx1pt_finder_links_terms6`
2591 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2592
2593--
2594-- Índices de tabela `jx1pt_finder_links_terms7`
2595--
2596ALTER TABLE `jx1pt_finder_links_terms7`
2597 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2598
2599--
2600-- Índices de tabela `jx1pt_finder_links_terms8`
2601--
2602ALTER TABLE `jx1pt_finder_links_terms8`
2603 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2604
2605--
2606-- Índices de tabela `jx1pt_finder_links_terms9`
2607--
2608ALTER TABLE `jx1pt_finder_links_terms9`
2609 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2610
2611--
2612-- Índices de tabela `jx1pt_finder_links_termsa`
2613--
2614ALTER TABLE `jx1pt_finder_links_termsa`
2615 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2616
2617--
2618-- Índices de tabela `jx1pt_finder_links_termsb`
2619--
2620ALTER TABLE `jx1pt_finder_links_termsb`
2621 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2622
2623--
2624-- Índices de tabela `jx1pt_finder_links_termsc`
2625--
2626ALTER TABLE `jx1pt_finder_links_termsc`
2627 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2628
2629--
2630-- Índices de tabela `jx1pt_finder_links_termsd`
2631--
2632ALTER TABLE `jx1pt_finder_links_termsd`
2633 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2634
2635--
2636-- Índices de tabela `jx1pt_finder_links_termse`
2637--
2638ALTER TABLE `jx1pt_finder_links_termse`
2639 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2640
2641--
2642-- Índices de tabela `jx1pt_finder_links_termsf`
2643--
2644ALTER TABLE `jx1pt_finder_links_termsf`
2645 ADD PRIMARY KEY (`link_id`,`term_id`), ADD KEY `idx_term_weight` (`term_id`,`weight`), ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);
2646
2647--
2648-- Índices de tabela `jx1pt_finder_taxonomy`
2649--
2650ALTER TABLE `jx1pt_finder_taxonomy`
2651 ADD PRIMARY KEY (`id`), ADD KEY `parent_id` (`parent_id`), ADD KEY `state` (`state`), ADD KEY `ordering` (`ordering`), ADD KEY `access` (`access`), ADD KEY `idx_parent_published` (`parent_id`,`state`,`access`);
2652
2653--
2654-- Índices de tabela `jx1pt_finder_taxonomy_map`
2655--
2656ALTER TABLE `jx1pt_finder_taxonomy_map`
2657 ADD PRIMARY KEY (`link_id`,`node_id`), ADD KEY `link_id` (`link_id`), ADD KEY `node_id` (`node_id`);
2658
2659--
2660-- Índices de tabela `jx1pt_finder_terms`
2661--
2662ALTER TABLE `jx1pt_finder_terms`
2663 ADD PRIMARY KEY (`term_id`), ADD UNIQUE KEY `idx_term` (`term`), ADD KEY `idx_term_phrase` (`term`,`phrase`), ADD KEY `idx_stem_phrase` (`stem`,`phrase`), ADD KEY `idx_soundex_phrase` (`soundex`,`phrase`);
2664
2665--
2666-- Índices de tabela `jx1pt_finder_terms_common`
2667--
2668ALTER TABLE `jx1pt_finder_terms_common`
2669 ADD KEY `idx_word_lang` (`term`,`language`), ADD KEY `idx_lang` (`language`);
2670
2671--
2672-- Índices de tabela `jx1pt_finder_tokens`
2673--
2674ALTER TABLE `jx1pt_finder_tokens`
2675 ADD KEY `idx_word` (`term`), ADD KEY `idx_context` (`context`);
2676
2677--
2678-- Índices de tabela `jx1pt_finder_tokens_aggregate`
2679--
2680ALTER TABLE `jx1pt_finder_tokens_aggregate`
2681 ADD KEY `token` (`term`), ADD KEY `keyword_id` (`term_id`);
2682
2683--
2684-- Índices de tabela `jx1pt_finder_types`
2685--
2686ALTER TABLE `jx1pt_finder_types`
2687 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `title` (`title`);
2688
2689--
2690-- Índices de tabela `jx1pt_fsj_main_attachment`
2691--
2692ALTER TABLE `jx1pt_fsj_main_attachment`
2693 ADD PRIMARY KEY (`id`), ADD KEY `Lookup` (`source`,`source_id`,`dest`,`dest_id`);
2694
2695--
2696-- Índices de tabela `jx1pt_fsj_main_related`
2697--
2698ALTER TABLE `jx1pt_fsj_main_related`
2699 ADD PRIMARY KEY (`id`), ADD KEY `Lookup` (`source`,`source_id`,`dest`,`dest_id`);
2700
2701--
2702-- Índices de tabela `jx1pt_fsj_main_settings`
2703--
2704ALTER TABLE `jx1pt_fsj_main_settings`
2705 ADD PRIMARY KEY (`id`), ADD KEY `idx_asset_id` (`j_asset`), ADD KEY `idx_name` (`name`), ADD KEY `idx_lft_rgt` (`lft`,`rgt`), ADD KEY `parent_id` (`parent_id`), ADD KEY `idx_id_lft_rgt` (`id`,`lft`,`rgt`);
2706
2707--
2708-- Índices de tabela `jx1pt_fsj_plg_plugin`
2709--
2710ALTER TABLE `jx1pt_fsj_plg_plugin`
2711 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_name` (`type`,`name`), ADD KEY `idx_state` (`state`), ADD KEY `Main` (`type`,`name`);
2712
2713--
2714-- Índices de tabela `jx1pt_fsj_plg_type`
2715--
2716ALTER TABLE `jx1pt_fsj_plg_type`
2717 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_name` (`name`);
2718
2719--
2720-- Índices de tabela `jx1pt_fsj_tpl_template`
2721--
2722ALTER TABLE `jx1pt_fsj_tpl_template`
2723 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `Main` (`component`,`type`,`name`);
2724
2725--
2726-- Índices de tabela `jx1pt_fsj_tpl_type`
2727--
2728ALTER TABLE `jx1pt_fsj_tpl_type`
2729 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `Main` (`component`,`type`);
2730
2731--
2732-- Índices de tabela `jx1pt_joomanager_ads`
2733--
2734ALTER TABLE `jx1pt_joomanager_ads`
2735 ADD PRIMARY KEY (`id`);
2736
2737--
2738-- Índices de tabela `jx1pt_joomanager_alerts`
2739--
2740ALTER TABLE `jx1pt_joomanager_alerts`
2741 ADD PRIMARY KEY (`id`);
2742
2743--
2744-- Índices de tabela `jx1pt_joomanager_category`
2745--
2746ALTER TABLE `jx1pt_joomanager_category`
2747 ADD PRIMARY KEY (`id`);
2748
2749--
2750-- Índices de tabela `jx1pt_joomanager_fields`
2751--
2752ALTER TABLE `jx1pt_joomanager_fields`
2753 ADD PRIMARY KEY (`id`);
2754
2755--
2756-- Índices de tabela `jx1pt_joomanager_fields_values`
2757--
2758ALTER TABLE `jx1pt_joomanager_fields_values`
2759 ADD PRIMARY KEY (`id`);
2760
2761--
2762-- Índices de tabela `jx1pt_joomanager_items`
2763--
2764ALTER TABLE `jx1pt_joomanager_items`
2765 ADD PRIMARY KEY (`id`);
2766
2767--
2768-- Índices de tabela `jx1pt_joomanager_items_xref`
2769--
2770ALTER TABLE `jx1pt_joomanager_items_xref`
2771 ADD PRIMARY KEY (`id`);
2772
2773--
2774-- Índices de tabela `jx1pt_joomanager_payment`
2775--
2776ALTER TABLE `jx1pt_joomanager_payment`
2777 ADD PRIMARY KEY (`id`);
2778
2779--
2780-- Índices de tabela `jx1pt_joomanager_ratings`
2781--
2782ALTER TABLE `jx1pt_joomanager_ratings`
2783 ADD PRIMARY KEY (`id`);
2784
2785--
2786-- Índices de tabela `jx1pt_joomanager_rets_fields`
2787--
2788ALTER TABLE `jx1pt_joomanager_rets_fields`
2789 ADD PRIMARY KEY (`id`);
2790
2791--
2792-- Índices de tabela `jx1pt_joomanager_subscription`
2793--
2794ALTER TABLE `jx1pt_joomanager_subscription`
2795 ADD PRIMARY KEY (`id`);
2796
2797--
2798-- Índices de tabela `jx1pt_languages`
2799--
2800ALTER TABLE `jx1pt_languages`
2801 ADD PRIMARY KEY (`lang_id`), ADD UNIQUE KEY `idx_sef` (`sef`), ADD UNIQUE KEY `idx_langcode` (`lang_code`), ADD KEY `idx_access` (`access`), ADD KEY `idx_ordering` (`ordering`);
2802
2803--
2804-- Índices de tabela `jx1pt_menu`
2805--
2806ALTER TABLE `jx1pt_menu`
2807 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`(100),`language`), ADD KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`), ADD KEY `idx_menutype` (`menutype`), ADD KEY `idx_left_right` (`lft`,`rgt`), ADD KEY `idx_language` (`language`), ADD KEY `idx_alias` (`alias`(100)), ADD KEY `idx_path` (`path`(100));
2808
2809--
2810-- Índices de tabela `jx1pt_menu_types`
2811--
2812ALTER TABLE `jx1pt_menu_types`
2813 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_menutype` (`menutype`);
2814
2815--
2816-- Índices de tabela `jx1pt_messages`
2817--
2818ALTER TABLE `jx1pt_messages`
2819 ADD PRIMARY KEY (`message_id`), ADD KEY `useridto_state` (`user_id_to`,`state`);
2820
2821--
2822-- Índices de tabela `jx1pt_messages_cfg`
2823--
2824ALTER TABLE `jx1pt_messages_cfg`
2825 ADD UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`);
2826
2827--
2828-- Índices de tabela `jx1pt_mi_iptable`
2829--
2830ALTER TABLE `jx1pt_mi_iptable`
2831 ADD PRIMARY KEY (`ip`);
2832
2833--
2834-- Índices de tabela `jx1pt_modules`
2835--
2836ALTER TABLE `jx1pt_modules`
2837 ADD PRIMARY KEY (`id`), ADD KEY `published` (`published`,`access`), ADD KEY `newsfeeds` (`module`,`published`), ADD KEY `idx_language` (`language`), ADD KEY `idx_1` (`access`,`client_id`,`id`,`module`,`publish_down`,`publish_up`,`published`);
2838
2839--
2840-- Índices de tabela `jx1pt_modules_menu`
2841--
2842ALTER TABLE `jx1pt_modules_menu`
2843 ADD PRIMARY KEY (`moduleid`,`menuid`);
2844
2845--
2846-- Índices de tabela `jx1pt_newsfeeds`
2847--
2848ALTER TABLE `jx1pt_newsfeeds`
2849 ADD PRIMARY KEY (`id`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_state` (`published`), ADD KEY `idx_catid` (`catid`), ADD KEY `idx_createdby` (`created_by`), ADD KEY `idx_language` (`language`), ADD KEY `idx_xreference` (`xreference`);
2850
2851--
2852-- Índices de tabela `jx1pt_overrider`
2853--
2854ALTER TABLE `jx1pt_overrider`
2855 ADD PRIMARY KEY (`id`);
2856
2857--
2858-- Índices de tabela `jx1pt_phocamaps_icon`
2859--
2860ALTER TABLE `jx1pt_phocamaps_icon`
2861 ADD PRIMARY KEY (`id`);
2862
2863--
2864-- Índices de tabela `jx1pt_phocamaps_map`
2865--
2866ALTER TABLE `jx1pt_phocamaps_map`
2867 ADD PRIMARY KEY (`id`), ADD KEY `cat_idx` (`published`,`access`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`);
2868
2869--
2870-- Índices de tabela `jx1pt_phocamaps_marker`
2871--
2872ALTER TABLE `jx1pt_phocamaps_marker`
2873 ADD PRIMARY KEY (`id`), ADD KEY `catid` (`catid`,`published`);
2874
2875--
2876-- Índices de tabela `jx1pt_postinstall_messages`
2877--
2878ALTER TABLE `jx1pt_postinstall_messages`
2879 ADD PRIMARY KEY (`postinstall_message_id`);
2880
2881--
2882-- Índices de tabela `jx1pt_redirect_links`
2883--
2884ALTER TABLE `jx1pt_redirect_links`
2885 ADD PRIMARY KEY (`id`), ADD KEY `idx_link_modifed` (`modified_date`), ADD KEY `idx_old_url` (`old_url`(100));
2886
2887--
2888-- Índices de tabela `jx1pt_rereplacer`
2889--
2890ALTER TABLE `jx1pt_rereplacer`
2891 ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`,`published`);
2892
2893--
2894-- Índices de tabela `jx1pt_rokcandy`
2895--
2896ALTER TABLE `jx1pt_rokcandy`
2897 ADD PRIMARY KEY (`id`);
2898
2899--
2900-- Índices de tabela `jx1pt_rokcommon_configs`
2901--
2902ALTER TABLE `jx1pt_rokcommon_configs`
2903 ADD PRIMARY KEY (`id`);
2904
2905--
2906-- Índices de tabela `jx1pt_roksprocket_items`
2907--
2908ALTER TABLE `jx1pt_roksprocket_items`
2909 ADD PRIMARY KEY (`id`), ADD KEY `idx_module` (`module_id`), ADD KEY `idx_module_order` (`module_id`,`order`);
2910
2911--
2912-- Índices de tabela `jx1pt_rsfirewall_configuration`
2913--
2914ALTER TABLE `jx1pt_rsfirewall_configuration`
2915 ADD PRIMARY KEY (`name`);
2916
2917--
2918-- Índices de tabela `jx1pt_rsfirewall_exceptions`
2919--
2920ALTER TABLE `jx1pt_rsfirewall_exceptions`
2921 ADD PRIMARY KEY (`id`);
2922
2923--
2924-- Índices de tabela `jx1pt_rsfirewall_feeds`
2925--
2926ALTER TABLE `jx1pt_rsfirewall_feeds`
2927 ADD PRIMARY KEY (`id`);
2928
2929--
2930-- Índices de tabela `jx1pt_rsfirewall_hashes`
2931--
2932ALTER TABLE `jx1pt_rsfirewall_hashes`
2933 ADD PRIMARY KEY (`id`);
2934
2935--
2936-- Índices de tabela `jx1pt_rsfirewall_lists`
2937--
2938ALTER TABLE `jx1pt_rsfirewall_lists`
2939 ADD PRIMARY KEY (`id`), ADD KEY `published` (`published`), ADD KEY `type` (`type`), ADD KEY `ip` (`ip`);
2940
2941--
2942-- Índices de tabela `jx1pt_rsfirewall_logs`
2943--
2944ALTER TABLE `jx1pt_rsfirewall_logs`
2945 ADD PRIMARY KEY (`id`), ADD KEY `ip` (`ip`);
2946
2947--
2948-- Índices de tabela `jx1pt_rsfirewall_offenders`
2949--
2950ALTER TABLE `jx1pt_rsfirewall_offenders`
2951 ADD PRIMARY KEY (`id`);
2952
2953--
2954-- Índices de tabela `jx1pt_rsfirewall_signatures`
2955--
2956ALTER TABLE `jx1pt_rsfirewall_signatures`
2957 ADD PRIMARY KEY (`signature`,`type`);
2958
2959--
2960-- Índices de tabela `jx1pt_rsfirewall_snapshots`
2961--
2962ALTER TABLE `jx1pt_rsfirewall_snapshots`
2963 ADD PRIMARY KEY (`id`);
2964
2965--
2966-- Índices de tabela `jx1pt_schemas`
2967--
2968ALTER TABLE `jx1pt_schemas`
2969 ADD PRIMARY KEY (`extension_id`,`version_id`);
2970
2971--
2972-- Índices de tabela `jx1pt_session`
2973--
2974ALTER TABLE `jx1pt_session`
2975 ADD PRIMARY KEY (`session_id`), ADD KEY `userid` (`userid`), ADD KEY `time` (`time`);
2976
2977--
2978-- Índices de tabela `jx1pt_tags`
2979--
2980ALTER TABLE `jx1pt_tags`
2981 ADD PRIMARY KEY (`id`), ADD KEY `tag_idx` (`published`,`access`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_left_right` (`lft`,`rgt`), ADD KEY `idx_language` (`language`), ADD KEY `idx_path` (`path`(100)), ADD KEY `idx_alias` (`alias`(100));
2982
2983--
2984-- Índices de tabela `jx1pt_template_styles`
2985--
2986ALTER TABLE `jx1pt_template_styles`
2987 ADD PRIMARY KEY (`id`), ADD KEY `idx_template` (`template`), ADD KEY `idx_home` (`home`);
2988
2989--
2990-- Índices de tabela `jx1pt_ucm_base`
2991--
2992ALTER TABLE `jx1pt_ucm_base`
2993 ADD PRIMARY KEY (`ucm_id`), ADD KEY `idx_ucm_item_id` (`ucm_item_id`), ADD KEY `idx_ucm_type_id` (`ucm_type_id`), ADD KEY `idx_ucm_language_id` (`ucm_language_id`);
2994
2995--
2996-- Índices de tabela `jx1pt_ucm_content`
2997--
2998ALTER TABLE `jx1pt_ucm_content`
2999 ADD PRIMARY KEY (`core_content_id`), ADD KEY `tag_idx` (`core_state`,`core_access`), ADD KEY `idx_access` (`core_access`), ADD KEY `idx_language` (`core_language`), ADD KEY `idx_modified_time` (`core_modified_time`), ADD KEY `idx_created_time` (`core_created_time`), ADD KEY `idx_core_modified_user_id` (`core_modified_user_id`), ADD KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`), ADD KEY `idx_core_created_user_id` (`core_created_user_id`), ADD KEY `idx_core_type_id` (`core_type_id`), ADD KEY `idx_alias` (`core_alias`(100)), ADD KEY `idx_title` (`core_title`(100)), ADD KEY `idx_content_type` (`core_type_alias`(100));
3000
3001--
3002-- Índices de tabela `jx1pt_ucm_history`
3003--
3004ALTER TABLE `jx1pt_ucm_history`
3005 ADD PRIMARY KEY (`version_id`), ADD KEY `idx_ucm_item_id` (`ucm_type_id`,`ucm_item_id`), ADD KEY `idx_save_date` (`save_date`);
3006
3007--
3008-- Índices de tabela `jx1pt_updates`
3009--
3010ALTER TABLE `jx1pt_updates`
3011 ADD PRIMARY KEY (`update_id`);
3012
3013--
3014-- Índices de tabela `jx1pt_update_sites`
3015--
3016ALTER TABLE `jx1pt_update_sites`
3017 ADD PRIMARY KEY (`update_site_id`);
3018
3019--
3020-- Índices de tabela `jx1pt_update_sites_extensions`
3021--
3022ALTER TABLE `jx1pt_update_sites_extensions`
3023 ADD PRIMARY KEY (`update_site_id`,`extension_id`);
3024
3025--
3026-- Índices de tabela `jx1pt_usergroups`
3027--
3028ALTER TABLE `jx1pt_usergroups`
3029 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`), ADD KEY `idx_usergroup_title_lookup` (`title`), ADD KEY `idx_usergroup_adjacency_lookup` (`parent_id`), ADD KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`);
3030
3031--
3032-- Índices de tabela `jx1pt_users`
3033--
3034ALTER TABLE `jx1pt_users`
3035 ADD PRIMARY KEY (`id`), ADD KEY `idx_block` (`block`), ADD KEY `username` (`username`), ADD KEY `email` (`email`), ADD KEY `idx_name` (`name`(100));
3036
3037--
3038-- Índices de tabela `jx1pt_user_keys`
3039--
3040ALTER TABLE `jx1pt_user_keys`
3041 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `series` (`series`), ADD KEY `user_id` (`user_id`);
3042
3043--
3044-- Índices de tabela `jx1pt_user_notes`
3045--
3046ALTER TABLE `jx1pt_user_notes`
3047 ADD PRIMARY KEY (`id`), ADD KEY `idx_user_id` (`user_id`), ADD KEY `idx_category_id` (`catid`);
3048
3049--
3050-- Índices de tabela `jx1pt_user_profiles`
3051--
3052ALTER TABLE `jx1pt_user_profiles`
3053 ADD UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`);
3054
3055--
3056-- Índices de tabela `jx1pt_user_usergroup_map`
3057--
3058ALTER TABLE `jx1pt_user_usergroup_map`
3059 ADD PRIMARY KEY (`user_id`,`group_id`);
3060
3061--
3062-- Índices de tabela `jx1pt_viewlevels`
3063--
3064ALTER TABLE `jx1pt_viewlevels`
3065 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_assetgroup_title_lookup` (`title`);
3066
3067--
3068-- Índices de tabela `jx1pt_weblinks`
3069--
3070ALTER TABLE `jx1pt_weblinks`
3071 ADD PRIMARY KEY (`id`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_state` (`state`), ADD KEY `idx_catid` (`catid`), ADD KEY `idx_createdby` (`created_by`), ADD KEY `idx_featured_catid` (`featured`,`catid`), ADD KEY `idx_language` (`language`), ADD KEY `idx_xreference` (`xreference`);
3072
3073--
3074-- AUTO_INCREMENT de tabelas apagadas
3075--
3076
3077--
3078-- AUTO_INCREMENT de tabela `jx1pt_ak_profiles`
3079--
3080ALTER TABLE `jx1pt_ak_profiles`
3081 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3082--
3083-- AUTO_INCREMENT de tabela `jx1pt_ak_stats`
3084--
3085ALTER TABLE `jx1pt_ak_stats`
3086 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
3087--
3088-- AUTO_INCREMENT de tabela `jx1pt_assets`
3089--
3090ALTER TABLE `jx1pt_assets`
3091 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',AUTO_INCREMENT=129;
3092--
3093-- AUTO_INCREMENT de tabela `jx1pt_banners`
3094--
3095ALTER TABLE `jx1pt_banners`
3096 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
3097--
3098-- AUTO_INCREMENT de tabela `jx1pt_banner_clients`
3099--
3100ALTER TABLE `jx1pt_banner_clients`
3101 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3102--
3103-- AUTO_INCREMENT de tabela `jx1pt_categories`
3104--
3105ALTER TABLE `jx1pt_categories`
3106 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
3107--
3108-- AUTO_INCREMENT de tabela `jx1pt_contact_details`
3109--
3110ALTER TABLE `jx1pt_contact_details`
3111 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3112--
3113-- AUTO_INCREMENT de tabela `jx1pt_content`
3114--
3115ALTER TABLE `jx1pt_content`
3116 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
3117--
3118-- AUTO_INCREMENT de tabela `jx1pt_content_types`
3119--
3120ALTER TABLE `jx1pt_content_types`
3121 MODIFY `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10005;
3122--
3123-- AUTO_INCREMENT de tabela `jx1pt_extensions`
3124--
3125ALTER TABLE `jx1pt_extensions`
3126 MODIFY `extension_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10127;
3127--
3128-- AUTO_INCREMENT de tabela `jx1pt_fields`
3129--
3130ALTER TABLE `jx1pt_fields`
3131 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3132--
3133-- AUTO_INCREMENT de tabela `jx1pt_fields_groups`
3134--
3135ALTER TABLE `jx1pt_fields_groups`
3136 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3137--
3138-- AUTO_INCREMENT de tabela `jx1pt_finder_filters`
3139--
3140ALTER TABLE `jx1pt_finder_filters`
3141 MODIFY `filter_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3142--
3143-- AUTO_INCREMENT de tabela `jx1pt_finder_links`
3144--
3145ALTER TABLE `jx1pt_finder_links`
3146 MODIFY `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3147--
3148-- AUTO_INCREMENT de tabela `jx1pt_finder_taxonomy`
3149--
3150ALTER TABLE `jx1pt_finder_taxonomy`
3151 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3152--
3153-- AUTO_INCREMENT de tabela `jx1pt_finder_terms`
3154--
3155ALTER TABLE `jx1pt_finder_terms`
3156 MODIFY `term_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3157--
3158-- AUTO_INCREMENT de tabela `jx1pt_finder_types`
3159--
3160ALTER TABLE `jx1pt_finder_types`
3161 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3162--
3163-- AUTO_INCREMENT de tabela `jx1pt_fsj_main_attachment`
3164--
3165ALTER TABLE `jx1pt_fsj_main_attachment`
3166 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3167--
3168-- AUTO_INCREMENT de tabela `jx1pt_fsj_main_related`
3169--
3170ALTER TABLE `jx1pt_fsj_main_related`
3171 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3172--
3173-- AUTO_INCREMENT de tabela `jx1pt_fsj_main_settings`
3174--
3175ALTER TABLE `jx1pt_fsj_main_settings`
3176 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
3177--
3178-- AUTO_INCREMENT de tabela `jx1pt_fsj_plg_plugin`
3179--
3180ALTER TABLE `jx1pt_fsj_plg_plugin`
3181 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
3182--
3183-- AUTO_INCREMENT de tabela `jx1pt_fsj_plg_type`
3184--
3185ALTER TABLE `jx1pt_fsj_plg_type`
3186 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
3187--
3188-- AUTO_INCREMENT de tabela `jx1pt_fsj_tpl_template`
3189--
3190ALTER TABLE `jx1pt_fsj_tpl_template`
3191 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
3192--
3193-- AUTO_INCREMENT de tabela `jx1pt_fsj_tpl_type`
3194--
3195ALTER TABLE `jx1pt_fsj_tpl_type`
3196 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
3197--
3198-- AUTO_INCREMENT de tabela `jx1pt_joomanager_ads`
3199--
3200ALTER TABLE `jx1pt_joomanager_ads`
3201 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3202--
3203-- AUTO_INCREMENT de tabela `jx1pt_joomanager_alerts`
3204--
3205ALTER TABLE `jx1pt_joomanager_alerts`
3206 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3207--
3208-- AUTO_INCREMENT de tabela `jx1pt_joomanager_category`
3209--
3210ALTER TABLE `jx1pt_joomanager_category`
3211 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=53;
3212--
3213-- AUTO_INCREMENT de tabela `jx1pt_joomanager_fields`
3214--
3215ALTER TABLE `jx1pt_joomanager_fields`
3216 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=62;
3217--
3218-- AUTO_INCREMENT de tabela `jx1pt_joomanager_fields_values`
3219--
3220ALTER TABLE `jx1pt_joomanager_fields_values`
3221 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9801;
3222--
3223-- AUTO_INCREMENT de tabela `jx1pt_joomanager_items`
3224--
3225ALTER TABLE `jx1pt_joomanager_items`
3226 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=438;
3227--
3228-- AUTO_INCREMENT de tabela `jx1pt_joomanager_items_xref`
3229--
3230ALTER TABLE `jx1pt_joomanager_items_xref`
3231 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=689;
3232--
3233-- AUTO_INCREMENT de tabela `jx1pt_joomanager_payment`
3234--
3235ALTER TABLE `jx1pt_joomanager_payment`
3236 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
3237--
3238-- AUTO_INCREMENT de tabela `jx1pt_joomanager_rets_fields`
3239--
3240ALTER TABLE `jx1pt_joomanager_rets_fields`
3241 MODIFY `id` int(12) NOT NULL AUTO_INCREMENT;
3242--
3243-- AUTO_INCREMENT de tabela `jx1pt_joomanager_subscription`
3244--
3245ALTER TABLE `jx1pt_joomanager_subscription`
3246 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=898;
3247--
3248-- AUTO_INCREMENT de tabela `jx1pt_languages`
3249--
3250ALTER TABLE `jx1pt_languages`
3251 MODIFY `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3252--
3253-- AUTO_INCREMENT de tabela `jx1pt_menu`
3254--
3255ALTER TABLE `jx1pt_menu`
3256 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=199;
3257--
3258-- AUTO_INCREMENT de tabela `jx1pt_menu_types`
3259--
3260ALTER TABLE `jx1pt_menu_types`
3261 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3262--
3263-- AUTO_INCREMENT de tabela `jx1pt_messages`
3264--
3265ALTER TABLE `jx1pt_messages`
3266 MODIFY `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3267--
3268-- AUTO_INCREMENT de tabela `jx1pt_modules`
3269--
3270ALTER TABLE `jx1pt_modules`
3271 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=278;
3272--
3273-- AUTO_INCREMENT de tabela `jx1pt_newsfeeds`
3274--
3275ALTER TABLE `jx1pt_newsfeeds`
3276 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3277--
3278-- AUTO_INCREMENT de tabela `jx1pt_overrider`
3279--
3280ALTER TABLE `jx1pt_overrider`
3281 MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key';
3282--
3283-- AUTO_INCREMENT de tabela `jx1pt_phocamaps_icon`
3284--
3285ALTER TABLE `jx1pt_phocamaps_icon`
3286 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
3287--
3288-- AUTO_INCREMENT de tabela `jx1pt_phocamaps_map`
3289--
3290ALTER TABLE `jx1pt_phocamaps_map`
3291 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3292--
3293-- AUTO_INCREMENT de tabela `jx1pt_phocamaps_marker`
3294--
3295ALTER TABLE `jx1pt_phocamaps_marker`
3296 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3297--
3298-- AUTO_INCREMENT de tabela `jx1pt_postinstall_messages`
3299--
3300ALTER TABLE `jx1pt_postinstall_messages`
3301 MODIFY `postinstall_message_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
3302--
3303-- AUTO_INCREMENT de tabela `jx1pt_redirect_links`
3304--
3305ALTER TABLE `jx1pt_redirect_links`
3306 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=884;
3307--
3308-- AUTO_INCREMENT de tabela `jx1pt_rereplacer`
3309--
3310ALTER TABLE `jx1pt_rereplacer`
3311 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3312--
3313-- AUTO_INCREMENT de tabela `jx1pt_rokcandy`
3314--
3315ALTER TABLE `jx1pt_rokcandy`
3316 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
3317--
3318-- AUTO_INCREMENT de tabela `jx1pt_rokcommon_configs`
3319--
3320ALTER TABLE `jx1pt_rokcommon_configs`
3321 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
3322--
3323-- AUTO_INCREMENT de tabela `jx1pt_roksprocket_items`
3324--
3325ALTER TABLE `jx1pt_roksprocket_items`
3326 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2741;
3327--
3328-- AUTO_INCREMENT de tabela `jx1pt_rsfirewall_exceptions`
3329--
3330ALTER TABLE `jx1pt_rsfirewall_exceptions`
3331 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3332--
3333-- AUTO_INCREMENT de tabela `jx1pt_rsfirewall_feeds`
3334--
3335ALTER TABLE `jx1pt_rsfirewall_feeds`
3336 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3337--
3338-- AUTO_INCREMENT de tabela `jx1pt_rsfirewall_hashes`
3339--
3340ALTER TABLE `jx1pt_rsfirewall_hashes`
3341 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=289;
3342--
3343-- AUTO_INCREMENT de tabela `jx1pt_rsfirewall_lists`
3344--
3345ALTER TABLE `jx1pt_rsfirewall_lists`
3346 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3347--
3348-- AUTO_INCREMENT de tabela `jx1pt_rsfirewall_logs`
3349--
3350ALTER TABLE `jx1pt_rsfirewall_logs`
3351 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1939;
3352--
3353-- AUTO_INCREMENT de tabela `jx1pt_rsfirewall_offenders`
3354--
3355ALTER TABLE `jx1pt_rsfirewall_offenders`
3356 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
3357--
3358-- AUTO_INCREMENT de tabela `jx1pt_rsfirewall_snapshots`
3359--
3360ALTER TABLE `jx1pt_rsfirewall_snapshots`
3361 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3362--
3363-- AUTO_INCREMENT de tabela `jx1pt_tags`
3364--
3365ALTER TABLE `jx1pt_tags`
3366 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
3367--
3368-- AUTO_INCREMENT de tabela `jx1pt_template_styles`
3369--
3370ALTER TABLE `jx1pt_template_styles`
3371 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
3372--
3373-- AUTO_INCREMENT de tabela `jx1pt_ucm_content`
3374--
3375ALTER TABLE `jx1pt_ucm_content`
3376 MODIFY `core_content_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3377--
3378-- AUTO_INCREMENT de tabela `jx1pt_ucm_history`
3379--
3380ALTER TABLE `jx1pt_ucm_history`
3381 MODIFY `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3382--
3383-- AUTO_INCREMENT de tabela `jx1pt_updates`
3384--
3385ALTER TABLE `jx1pt_updates`
3386 MODIFY `update_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=89;
3387--
3388-- AUTO_INCREMENT de tabela `jx1pt_update_sites`
3389--
3390ALTER TABLE `jx1pt_update_sites`
3391 MODIFY `update_site_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
3392--
3393-- AUTO_INCREMENT de tabela `jx1pt_usergroups`
3394--
3395ALTER TABLE `jx1pt_usergroups`
3396 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',AUTO_INCREMENT=10;
3397--
3398-- AUTO_INCREMENT de tabela `jx1pt_users`
3399--
3400ALTER TABLE `jx1pt_users`
3401 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=983;
3402--
3403-- AUTO_INCREMENT de tabela `jx1pt_user_keys`
3404--
3405ALTER TABLE `jx1pt_user_keys`
3406 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3407--
3408-- AUTO_INCREMENT de tabela `jx1pt_user_notes`
3409--
3410ALTER TABLE `jx1pt_user_notes`
3411 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3412--
3413-- AUTO_INCREMENT de tabela `jx1pt_viewlevels`
3414--
3415ALTER TABLE `jx1pt_viewlevels`
3416 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',AUTO_INCREMENT=4;
3417--
3418-- AUTO_INCREMENT de tabela `jx1pt_weblinks`
3419--
3420ALTER TABLE `jx1pt_weblinks`
3421 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
3422/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3423/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3424/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3425
3426========================
3427 REPORT 3
3428========================
3429
3430+ www.aloncoimoveis.com.br IP[191.6.194.94]
3431+ mail.aloncoimoveis.com.br IP[177.185.201.253]
3432+ webmail.aloncoimoveis.com.br IP[177.185.200.65]
3433+ smtp.aloncoimoveis.com.br IP[177.185.201.253]
3434+ ftp.aloncoimoveis.com.br IP[191.6.194.94]
3435+ autodiscover.aloncoimoveis.com.br IP[177.185.193.222]
3436+ imap.aloncoimoveis.com.br IP[177.185.200.133]
3437+ pop.aloncoimoveis.com.br IP[177.185.200.133]
3438+ mysql.aloncoimoveis.com.br IP[191.6.194.22]
3439+ mail.aloncoimoveis.com.br IP[177.185.201.253]
3440+ webmail.aloncoimoveis.com.br IP[177.185.200.65]
3441
3442========================
3443 REPORT 4
3444========================
3445
3446Link: http://mysql.aloncoimoveis.com.br
3447Login: aloncoimoveis04
3448Password: imoveisal3138
3449Md5: 7b5100e378a8eee682bdeb222db7f1cd
3450PHP: $P$BTYktkIMsUWGFMoyD7/xyAuX9E8Vhs1