· 6 years ago · Jun 20, 2019, 11:22 PM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8███╗ ██╗███████╗██╗ ██╗███████╗███████╗ ██████╗
9████╗ ██║██╔════╝██║ ██║██╔════╝██╔════╝██╔════╝
10██╔██╗ ██║█████╗ ██║ █╗ ██║███████╗█████╗ ██║
11██║╚██╗██║██╔══╝ ██║███╗██║╚════██║██╔══╝ ██║
12██║ ╚████║███████╗╚███╔███╔╝███████║███████╗╚██████╗
13╚═╝ ╚═══╝╚══════╝ ╚══╝╚══╝ ╚══════╝╚══════╝ ╚═════╝
14
15--------------------------------------------------------------------------------------
16
17Target : http://www.defesacivil.sc.gov.br/ ( Defesa Civil De Santa Catarina )
18
19Salve Pros Manos: Cyr0x, NedLock, Kami, S1x3r, S1Lv3R
20
21"Dumped By : DemonSad"
22--------------------------------------------------------------------------------------
23 `nome` varchar(180) NOT NULL,
24 `estado_civil` varchar(20) NOT NULL,
25 `profissao` varchar(180) NOT NULL,
26 `grau_de_instrucao` varchar(180) NOT NULL,
27 `cpf` varchar(20) NOT NULL,
28 `rg` varchar(20) NOT NULL,
29 `emissor_rg` varchar(20) NOT NULL,
30 `estado_rg` varchar(20) NOT NULL,
31 `ctps_num` varchar(20) NOT NULL,
32 `ctps_serie` varchar(20) NOT NULL,
33 `ctps_data_de_emissao` date NOT NULL,
34 `nome_da_mae` varchar(180) NOT NULL,
35 `nome_do_pai` varchar(180) NOT NULL,
36 `email` varchar(180) NOT NULL,
37 `celular_1` varchar(20) NOT NULL,
38 `operadora_celular_1` varchar(20) NOT NULL,
39 `celular_2` varchar(20) NOT NULL,
40 `operadora_celular_2` varchar(20) NOT NULL,
41 `celular_3` varchar(20) NOT NULL,
42 `operadora_celular_3` varchar(20) NOT NULL,
43 `login` varchar(20) NOT NULL,
44 `senha` varchar(64) NOT NULL,
45 `logadouro` varchar(180) NOT NULL,
46 `complemento_logadouro` varchar(180) NOT NULL,
47 `bairro` varchar(180) NOT NULL,
48 `cidade` varchar(180) NOT NULL,
49 `cep` varchar(20) NOT NULL,
50 `estado` varchar(180) NOT NULL,
51 `id_cadastrador` int(12) unsigned zerofill NOT NULL,
52 `data_cadastro` date NOT NULL,
53 `id_origem` int(12) unsigned zerofill NOT NULL,
54 PRIMARY KEY (`id_cliente`),
55 UNIQUE KEY `cpf` (`cpf`),
56 UNIQUE KEY `login` (`login`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
58
59-- --------------------------------------------------------
60
61--
62-- Estrutura da tabela `gato`
63--
64
65CREATE TABLE IF NOT EXISTS `gato` (
66 `id_gato` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT,
67 `nome` varchar(180) NOT NULL,
68 `cpf` varchar(20) NOT NULL,
69 `rg` varchar(20) NOT NULL,
70 `emissor_rg` varchar(20) NOT NULL,
71 `estado_rg` varchar(20) NOT NULL,
72 `nome_da_mae` varchar(180) NOT NULL,
73 `email` varchar(180) NOT NULL,
74 `celular_1` varchar(20) NOT NULL,
75 `operadora_celular_1` varchar(20) NOT NULL,
76 `celular_2` varchar(20) NOT NULL,
77 `operadora_celular_2` varchar(20) NOT NULL,
78 `celular_3` varchar(20) NOT NULL,
79 `operadora_celular_3` varchar(20) NOT NULL,
80 `login` varchar(20) NOT NULL,
81 `senha` varchar(64) NOT NULL,
82 `logadouro` varchar(180) NOT NULL,
83 `complemento_logadouro` varchar(180) NOT NULL,
84 `bairro` varchar(180) NOT NULL,
85 `cidade` varchar(180) NOT NULL,
86 `cep` varchar(20) NOT NULL,
87 `estado` varchar(180) NOT NULL,
88 `id_cadastrador` int(12) unsigned zerofill NOT NULL,
89 `data_cadastro` date NOT NULL,
90 `id_origem` int(12) unsigned zerofill NOT NULL,
91 PRIMARY KEY (`id_gato`),
92 UNIQUE KEY `cpf` (`cpf`),
93 UNIQUE KEY `login` (`login`)
94) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
95
96-- --------------------------------------------------------
97
98--
99-- Estrutura da tabela `oponente`
100--
101
102CREATE TABLE IF NOT EXISTS `oponente` (
103 `id_oponente` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT,
104 `nome` varchar(180) NOT NULL,
105 `estado_civil` varchar(20) NOT NULL,
106 `profissao` varchar(180) NOT NULL,
107 `grau_de_instrucao` varchar(180) NOT NULL,
108 `cpf` varchar(20) NOT NULL,
109 `rg` varchar(20) NOT NULL,
110 `emissor_rg` varchar(20) NOT NULL,
111 `estado_rg` varchar(20) NOT NULL,
112 `ctps_num` varchar(20) NOT NULL,
113 `ctps_serie` varchar(20) NOT NULL,
114 `ctps_data_de_emissao` date NOT NULL,
115 `nome_da_mae` varchar(180) NOT NULL,
116 `nome_do_pai` varchar(180) NOT NULL,
117 `email` varchar(180) NOT NULL,
118 `celular_1` varchar(20) NOT NULL,
119 `operadora_celular_1` varchar(20) NOT NULL,
120 `celular_2` varchar(20) NOT NULL,
121 `operadora_celular_2` varchar(20) NOT NULL,
122 `celular_3` varchar(20) NOT NULL,
123 `operadora_celular_3` varchar(20) NOT NULL,
124 `logadouro` varchar(180) NOT NULL,
125 `complemento_logadouro` varchar(180) NOT NULL,
126 `bairro` varchar(180) NOT NULL,
127 `cidade` varchar(180) NOT NULL,
128 `cep` varchar(20) NOT NULL,
129 `estado` varchar(180) NOT NULL,
130 `id_cadastrador` int(12) unsigned zerofill NOT NULL,
131 `data_cadastro` date NOT NULL,
132 `id_origem` int(12) unsigned zerofill NOT NULL,
133 PRIMARY KEY (`id_oponente`),
134 UNIQUE KEY `cpf` (`cpf`)
135) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
136
137-- --------------------------------------------------------
138
139--
140-- Estrutura da tabela `defesa_sc`
141--
142
143CREATE TABLE IF NOT EXISTS `testemunha` (
144 `id_testemunha` int(12) unsigned zerofill NOT NULL AUTO_INCREMENT,
145 `nome` varchar(180) NOT NULL,
146 `estado_civil` varchar(20) NOT NULL,
147 `profissao` varchar(180) NOT NULL,
148 `grau_de_instrucao` varchar(180) NOT NULL,
149 `cpf` varchar(20) NOT NULL,
150 `rg` varchar(20) NOT NULL,
151 `emissor_rg` varchar(20) NOT NULL,
152 `estado_rg` varchar(20) NOT NULL,
153 `ctps_num` varchar(20) NOT NULL,
154 `ctps_serie` varchar(20) NOT NULL,
155 `ctps_data_de_emissao` date NOT NULL,
156 `nome_da_mae` varchar(180) NOT NULL,
157 `nome_do_pai` varchar(180) NOT NULL,
158 `email` varchar(180) NOT NULL,
159 `celular_1` varchar(20) NOT NULL,
160 `operadora_celular_1` varchar(20) NOT NULL,
161 `celular_2` varchar(20) NOT NULL,
162 `operadora_celular_2` varchar(20) NOT NULL,
163 `celular_3` varchar(20) NOT NULL,
164 `operadora_celular_3` varchar(20) NOT NULL,
165 `logadouro` varchar(180) NOT NULL,
166 `complemento_logadouro` varchar(180) NOT NULL,
167 `bairro` varchar(180) NOT NULL,
168 `cidade` varchar(180) NOT NULL,
169 `cep` varchar(20) NOT NULL,
170 `estado` varchar(180) NOT NULL,
171 `id_cadastrador` int(12) unsigned zerofill NOT NULL,
172 `data_cadastro` date NOT NULL,
173 `id_origem` int(12) unsigned zerofill NOT NULL,
174 PRIMARY KEY (`id_testemunha`),
175 UNIQUE KEY `cpf` (`cpf`)
176) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
177
178-- --------------------------------------------------------
179
180--
181-- Estrutura da tabela `usuarios`
182--
183
184CREATE TABLE IF NOT EXISTS `usuarios` (
185 `id_usuario` int(12) NOT NULL AUTO_INCREMENT,
186 `nome` varchar(180) NOT NULL,
187 `cpf` varchar(20) NOT NULL,
188 `rg` varchar(20) NOT NULL,
189 `data_de_nascimento` date NOT NULL,
190 `nivel` int(1) NOT NULL,
191 `bloqueado` int(1) NOT NULL,
192 `email` varchar(180) NOT NULL,
193 `celular_1` int(20) NOT NULL,
194 `operadora_celular_1` varchar(20) NOT NULL,
195 `celular_2` varchar(20) NOT NULL,
196 `operadora_celular_2` varchar(20) NOT NULL,
197 `celular_3` varchar(20) NOT NULL,
198 `operadora_celular_3` varchar(20) NOT NULL,
199 `login` varchar(12) NOT NULL,
200 `senha` varchar(64) NOT NULL,
201 `logadouro` varchar(180) NOT NULL,
202 `complemento_logadouro` varchar(180) NOT NULL,
203 `bairro` varchar(180) NOT NULL,
204 `cidade` varchar(180) NOT NULL,
205 `cep` varchar(180) NOT NULL,
206 `estado` varchar(180) NOT NULL,
207 `data_de_cadastro` date NOT NULL,
208 PRIMARY KEY (`id_usuario`)
209) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
210--
211-- Banco de Dados: `jm`
212--
213CREATE DATABASE `jm` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
214USE `jm`;
215
216-- --------------------------------------------------------
217
218--
219-- Estrutura da tabela `jaqmr_assets`
220--
221
222CREATE TABLE IF NOT EXISTS `jaqmr_assets` (
223 `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
224 `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
225 `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
226 `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
227 `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
228 `name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.\n',
229 `title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.',
230 `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
231 PRIMARY KEY (`id`),
232 UNIQUE KEY `idx_asset_name` (`name`),
233 KEY `idx_lft_rgt` (`lft`,`rgt`),
234 KEY `idx_parent_id` (`parent_id`)
235) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=174 ;
236
237--
238-- Extraindo dados da tabela `jaqmr_assets`
239--
240
241INSERT INTO `jaqmr_assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES
242(1, 0, 1, 424, 0, 'root.1', 'Root Asset', '{"core.login.site":{"6":1,"2":1},"core.login.admin":{"6":1},"core.admin":{"8":1},"core.manage":{"7":1},"core.create":{"6":1,"3":1},"core.delete":{"6":1},"core.edit":{"6":1,"4":1},"core.edit.state":{"6":1,"5":1},"core.edit.own":{"6":1,"3":1}}'),
243(2, 1, 2, 3, 1, 'com_admin', 'com_admin', '{}'),
244(3, 1, 4, 11, 1, 'com_banners', 'com_banners', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
245(4, 1, 12, 13, 1, 'com_cache', 'com_cache', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
246(5, 1, 14, 15, 1, 'com_checkin', 'com_checkin', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
247(6, 1, 16, 17, 1, 'com_config', 'com_config', '{}'),
248(7, 1, 18, 87, 1, 'com_contact', 'com_contact', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
249(8, 1, 88, 299, 1, 'com_content', 'com_content', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"core.edit.own":[]}'),
250(9, 1, 300, 301, 1, 'com_cpanel', 'com_cpanel', '{}'),
251(10, 1, 302, 303, 1, 'com_installer', 'com_installer', '{"core.admin":[],"core.manage":{"7":0},"core.delete":{"7":0},"core.edit.state":{"7":0}}'),
252(11, 1, 304, 305, 1, 'com_languages', 'com_languages', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
253(12, 1, 306, 307, 1, 'com_login', 'com_login', '{}'),
254(13, 1, 308, 309, 1, 'com_mailto', 'com_mailto', '{}'),
255(14, 1, 310, 311, 1, 'com_massmail', 'com_massmail', '{}'),
256(15, 1, 312, 313, 1, 'com_media', 'com_media', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":{"5":1},"core.edit":[],"core.edit.state":[]}'),
257(16, 1, 314, 315, 1, 'com_menus', 'com_menus', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
258(17, 1, 37, 38, 1, 'com_messages', 'com_messages', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
259(18, 1, 318, 319, 1, 'com_modules', 'com_modules', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
260(19, 1, 320, 327, 1, 'com_newsfeeds', 'com_newsfeeds', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
261(20, 1, 328, 329, 1, 'com_plugins', 'com_plugins', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
262(21, 1, 330, 331, 1, 'com_redirect', 'com_redirect', '{"core.admin":{"7":1},"core.manage":[]}'),
263(22, 1, 332, 333, 1, 'com_search', 'com_search', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
264(23, 1, 334, 335, 1, 'com_templates', 'com_templates', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
265(24, 1, 336, 339, 1, 'com_users', 'com_users', '{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
266(25, 1, 340, 357, 1, 'com_weblinks', 'com_weblinks', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1,"10":0,"12":0},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1}}'),
267(26, 1, 358, 359, 1, 'com_wrapper', 'com_wrapper', '{}'),
268(33, 1, 420, 421, 1, 'com_finder', 'com_finder', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
269(34, 8, 105, 108, 2, 'com_content.category.9', 'Uncategorised', '{"core.create":{"10":0,"12":0},"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
270(35, 3, 7, 8, 2, 'com_banners.category.10', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
271(36, 7, 23, 24, 2, 'com_contact.category.11', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
272(37, 19, 323, 324, 2, 'com_newsfeeds.category.12', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
273(38, 25, 347, 348, 2, 'com_weblinks.category.13', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
274(39, 8, 109, 298, 2, 'com_content.category.14', 'Sample Data-Articles', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
275(40, 3, 9, 10, 2, 'com_banners.category.15', 'Sample Data-Banners', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
276(41, 7, 25, 86, 2, 'com_contact.category.16', 'Sample Data-Contact', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
277(42, 19, 325, 326, 2, 'com_newsfeeds.category.17', 'Sample Data-Newsfeeds', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
278(43, 25, 349, 356, 2, 'com_weblinks.category.18', 'Sample Data-Weblinks', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
279(44, 39, 110, 247, 3, 'com_content.category.19', 'Joomla!', '{"core.create":{"10":0,"12":0},"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
280(45, 44, 111, 224, 4, 'com_content.category.20', 'Extensions', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
281(46, 45, 112, 127, 5, 'com_content.category.21', 'Components', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
282(47, 45, 128, 189, 5, 'com_content.category.22', 'Modules', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
283(48, 45, 190, 201, 5, 'com_content.category.23', 'Templates', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
284(49, 45, 202, 203, 5, 'com_content.category.24', 'Languages', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
285(50, 45, 204, 223, 5, 'com_content.category.25', 'Plugins', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
286(51, 39, 248, 279, 3, 'com_content.category.26', 'Park Site', '{"core.create":{"10":0,"12":0},"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
287(52, 51, 249, 254, 4, 'com_content.category.27', 'Park Blog', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
288(53, 51, 255, 276, 4, 'com_content.category.28', 'Photo Gallery', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
289(54, 39, 280, 293, 3, 'com_content.category.29', 'Fruit Shop Site', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
290(55, 54, 281, 286, 4, 'com_content.category.30', 'Growers', '{"core.create":{"12":0},"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":{"10":1}}'),
291(56, 43, 350, 351, 3, 'com_weblinks.category.31', 'Park Links', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
292(57, 43, 352, 355, 3, 'com_weblinks.category.32', 'Joomla! Specific Links', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
293(58, 57, 353, 354, 4, 'com_weblinks.category.33', 'Other Resources', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
294(59, 41, 26, 27, 3, 'com_contact.category.34', 'Park Site', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
295(60, 41, 28, 85, 3, 'com_contact.category.35', 'Shop Site', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
296(61, 60, 29, 30, 4, 'com_contact.category.36', 'Staff', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
297(62, 60, 31, 84, 4, 'com_contact.category.37', 'Fruit Encyclopedia', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":
298
299-- Estrutura da tabela `jaqmr_finder_links`
300--
301
302CREATE TABLE IF NOT EXISTS `jaqmr_finder_links` (
303 `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
304 `url` varchar(255) NOT NULL,
305 `route` varchar(255) NOT NULL,
306 `title` varchar(255) DEFAULT NULL,
307 `description` varchar(255) DEFAULT NULL,
308 `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
309 `md5sum` varchar(32) DEFAULT NULL,
310 `published` tinyint(1) NOT NULL DEFAULT '1',
311 `state` int(5) DEFAULT '1',
312 `access` int(5) DEFAULT '0',
313 `language` varchar(8) NOT NULL,
314 `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
315 `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
316 `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
317 `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
318 `list_price` double unsigned NOT NULL DEFAULT '0',
319 `sale_price` double unsigned NOT NULL DEFAULT '0',
320 `type_id` int(11) NOT NULL,
321 `object` mediumblob NOT NULL,
322 PRIMARY KEY (`link_id`),
323 KEY `idx_type` (`type_id`),
324 KEY `idx_title` (`title`),
325 KEY `idx_md5` (`md5sum`),
326 KEY `idx_url` (`url`(75)),
327 KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
328 KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
329) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
330
331-- --------------------------------------------------------
332
333--
334-- Estrutura da tabela `jaqmr_finder_links_terms0`
335--
336
337CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms0` (
338 `link_id` int(10) unsigned NOT NULL,
339 `term_id` int(10) unsigned NOT NULL,
340 `weight` float unsigned NOT NULL,
341 PRIMARY KEY (`link_id`,`term_id`),
342 KEY `idx_term_weight` (`term_id`,`weight`),
343 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
344) ENGINE=InnoDB DEFAULT CHARSET=utf8;
345
346-- --------------------------------------------------------
347
348--
349-- Estrutura da tabela `jaqmr_finder_links_terms1`
350--
351
352CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms1` (
353 `link_id` int(10) unsigned NOT NULL,
354 `term_id` int(10) unsigned NOT NULL,
355 `weight` float unsigned NOT NULL,
356 PRIMARY KEY (`link_id`,`term_id`),
357 KEY `idx_term_weight` (`term_id`,`weight`),
358 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
359) ENGINE=InnoDB DEFAULT CHARSET=utf8;
360
361-- --------------------------------------------------------
362
363--
364-- Estrutura da tabela `jaqmr_finder_links_terms2`
365--
366
367CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms2` (
368 `link_id` int(10) unsigned NOT NULL,
369 `term_id` int(10) unsigned NOT NULL,
370 `weight` float unsigned NOT NULL,
371 PRIMARY KEY (`link_id`,`term_id`),
372 KEY `idx_term_weight` (`term_id`,`weight`),
373 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
374) ENGINE=InnoDB DEFAULT CHARSET=utf8;
375
376-- --------------------------------------------------------
377
378--
379-- Estrutura da tabela `jaqmr_finder_links_terms3`
380--
381
382CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms3` (
383 `link_id` int(10) unsigned NOT NULL,
384 `term_id` int(10) unsigned NOT NULL,
385 `weight` float unsigned NOT NULL,
386 PRIMARY KEY (`link_id`,`term_id`),
387 KEY `idx_term_weight` (`term_id`,`weight`),
388 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
389) ENGINE=InnoDB DEFAULT CHARSET=utf8;
390
391-- --------------------------------------------------------
392
393--
394-- Estrutura da tabela `jaqmr_finder_links_terms4`
395--
396
397CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms4` (
398 `link_id` int(10) unsigned NOT NULL,
399 `term_id` int(10) unsigned NOT NULL,
400 `weight` float unsigned NOT NULL,
401 PRIMARY KEY (`link_id`,`term_id`),
402 KEY `idx_term_weight` (`term_id`,`weight`),
403 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
404) ENGINE=InnoDB DEFAULT CHARSET=utf8;
405
406-- --------------------------------------------------------
407
408--
409-- Estrutura da tabela `jaqmr_finder_links_terms5`
410--
411
412CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms5` (
413 `link_id` int(10) unsigned NOT NULL,
414 `term_id` int(10) unsigned NOT NULL,
415 `weight` float unsigned NOT NULL,
416 PRIMARY KEY (`link_id`,`term_id`),
417 KEY `idx_term_weight` (`term_id`,`weight`),
418 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
419) ENGINE=InnoDB DEFAULT CHARSET=utf8;
420
421-- --------------------------------------------------------
422
423--
424-- Estrutura da tabela `jaqmr_finder_links_terms6`
425--
426
427CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms6` (
428 `link_id` int(10) unsigned NOT NULL,
429 `term_id` int(10) unsigned NOT NULL,
430 `weight` float unsigned NOT NULL,
431 PRIMARY KEY (`link_id`,`term_id`),
432 KEY `idx_term_weight` (`term_id`,`weight`),
433 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
434) ENGINE=InnoDB DEFAULT CHARSET=utf8;
435
436-- --------------------------------------------------------
437
438--
439-- Estrutura da tabela `jaqmr_finder_links_terms7`
440--
441
442CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms7` (
443 `link_id` int(10) unsigned NOT NULL,
444 `term_id` int(10) unsigned NOT NULL,
445 `weight` float unsigned NOT NULL,
446 PRIMARY KEY (`link_id`,`term_id`),
447 KEY `idx_term_weight` (`term_id`,`weight`),
448 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
449) ENGINE=InnoDB DEFAULT CHARSET=utf8;
450
451-- --------------------------------------------------------
452
453--
454-- Estrutura da tabela `jaqmr_finder_links_terms8`
455--
456
457CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms8` (
458 `link_id` int(10) unsigned NOT NULL,
459 `term_id` int(10) unsigned NOT NULL,
460 `weight` float unsigned NOT NULL,
461 PRIMARY KEY (`link_id`,`term_id`),
462 KEY `idx_term_weight` (`term_id`,`weight`),
463 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
464) ENGINE=InnoDB DEFAULT CHARSET=utf8;
465
466-- --------------------------------------------------------
467
468--
469-- Estrutura da tabela `jaqmr_finder_links_terms9`
470--
471
472CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_terms9` (
473 `link_id` int(10) unsigned NOT NULL,
474 `term_id` int(10) unsigned NOT NULL,
475 `weight` float unsigned NOT NULL,
476 PRIMARY KEY (`link_id`,`term_id`),
477 KEY `idx_term_weight` (`term_id`,`weight`),
478 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
479) ENGINE=InnoDB DEFAULT CHARSET=utf8;
480
481-- --------------------------------------------------------
482
483--
484-- Estrutura da tabela `jaqmr_finder_links_termsa`
485--
486
487CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_termsa` (
488 `link_id` int(10) unsigned NOT NULL,
489 `term_id` int(10) unsigned NOT NULL,
490 `weight` float unsigned NOT NULL,
491 PRIMARY KEY (`link_id`,`term_id`),
492 KEY `idx_term_weight` (`term_id`,`weight`),
493 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
494) ENGINE=InnoDB DEFAULT CHARSET=utf8;
495
496-- --------------------------------------------------------
497
498--
499-- Estrutura da tabela `jaqmr_finder_links_termsb`
500--
501
502CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_termsb` (
503 `link_id` int(10) unsigned NOT NULL,
504 `term_id` int(10) unsigned NOT NULL,
505 `weight` float unsigned NOT NULL,
506 PRIMARY KEY (`link_id`,`term_id`),
507 KEY `idx_term_weight` (`term_id`,`weight`),
508 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
509) ENGINE=InnoDB DEFAULT CHARSET=utf8;
510
511-- --------------------------------------------------------
512
513--
514-- Estrutura da tabela `jaqmr_finder_links_termsc`
515--
516
517CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_termsc` (
518 `link_id` int(10) unsigned NOT NULL,
519 `term_id` int(10) unsigned NOT NULL,
520 `weight` float unsigned NOT NULL,
521 PRIMARY KEY (`link_id`,`term_id`),
522 KEY `idx_term_weight` (`term_id`,`weight`),
523 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
524) ENGINE=InnoDB DEFAULT CHARSET=utf8;
525
526-- --------------------------------------------------------
527
528--
529-- Estrutura da tabela `jaqmr_finder_links_termsd`
530--
531
532CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_termsd` (
533 `link_id` int(10) unsigned NOT NULL,
534 `term_id` int(10) unsigned NOT NULL,
535 `weight` float unsigned NOT NULL,
536 PRIMARY KEY (`link_id`,`term_id`),
537 KEY `idx_term_weight` (`term_id`,`weight`),
538 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
539) ENGINE=InnoDB DEFAULT CHARSET=utf8;
540
541-- --------------------------------------------------------
542
543--
544-- Estrutura da tabela `jaqmr_finder_links_termse`
545--
546
547CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_termse` (
548 `link_id` int(10) unsigned NOT NULL,
549 `term_id` int(10) unsigned NOT NULL,
550 `weight` float unsigned NOT NULL,
551 PRIMARY KEY (`link_id`,`term_id`),
552 KEY `idx_term_weight` (`term_id`,`weight`),
553 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
554) ENGINE=InnoDB DEFAULT CHARSET=utf8;
555
556-- --------------------------------------------------------
557
558--
559-- Estrutura da tabela `jaqmr_finder_links_termsf`
560--
561
562CREATE TABLE IF NOT EXISTS `jaqmr_finder_links_termsf` (
563 `link_id` int(10) unsigned NOT NULL,
564 `term_id` int(10) unsigned NOT NULL,
565 `weight` float unsigned NOT NULL,
566 PRIMARY KEY (`link_id`,`term_id`),
567 KEY `idx_term_weight` (`term_id`,`weight`),
568 KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
569) ENGINE=InnoDB DEFAULT CHARSET=utf8;
570
571-- --------------------------------------------------------
572
573--
574-- Estrutura da tabela `jaqmr_finder_taxonomy`
575--
576
577CREATE TABLE IF NOT EXISTS `jaqmr_finder_taxonomy` (
578 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
579 `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
580 `title` varchar(255) NOT NULL,
581 `state` tinyint(1) unsigned NOT NULL DEFAULT '1',
582 `access` tinyint(1) unsigned NOT NULL DEFAULT '0',
583 `ordering` tinyint(1) unsigned NOT NULL DEFAULT '0',
584 PRIMARY KEY (`id`),
585 KEY `parent_id` (`parent_id`),
586 KEY `state` (`state`),
587 KEY `ordering` (`ordering`),
588 KEY `access` (`access`),
589 KEY `idx_parent_published` (`parent_id`,`state`,`access`)
590) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
591
592--
593-- Extraindo dados da tabela `jaqmr_finder_taxonomy`
594--
595
596INSERT INTO `jaqmr_finder_taxonomy` (`id`, `parent_id`, `title`, `state`, `access`, `ordering`) VALUES
597(1, 0, 'ROOT', 0, 0, 0);
598
599-- --------------------------------------------------------
600
601--
602-- Estrutura da tabela `jaqmr_finder_taxonomy_map`
603--
604
605CREATE TABLE IF NOT EXISTS `jaqmr_finder_taxonomy_map` (
606 `link_id` int(10) unsigned NOT NULL,
607 `node_id` int(10) unsigned NOT NULL,
608 PRIMARY KEY (`link_id`,`node_id`),
609 KEY `link_id` (`link_id`),
610 KEY `node_id` (`node_id`)
611) ENGINE=InnoDB DEFAULT CHARSET=utf8;
612
613-- --------------------------------------------------------
614
615--
616-- Estrutura da tabela `jaqmr_finder_terms`
617--
618
619CREATE TABLE IF NOT EXISTS `jaqmr_finder_terms` (
620 `term_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
621 `term` varchar(75) NOT NULL,
622 `stem` varchar(75) NOT NULL,
623 `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
624 `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
625 `weight` float unsigned NOT NULL DEFAULT '0',
626 `soundex` varchar(75) NOT NULL,
627 `links` int(10) NOT NULL DEFAULT '0',
628 PRIMARY KEY (`term_id`),
629 UNIQUE KEY `idx_term` (`term`),
630 KEY `idx_term_phrase` (`term`,`phrase`),
631 KEY `idx_stem_phrase` (`stem`,`phrase`),
632 KEY `idx_soundex_phrase` (`soundex`,`phrase`)
633) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
634
635-- --------------------------------------------------------
636
637--
638-- Estrutura da tabela `jaqmr_finder_terms_common`
639--
640
641CREATE TABLE IF NOT EXISTS `jaqmr_finder_terms_common` (
642 `term` varchar(75) NOT NULL,
643 `language` varchar(3) NOT NULL,
644 KEY `idx_word_lang` (`term`,`language`),
645 KEY `idx_lang` (`language`)
646) ENGINE=InnoDB DEFAULT CHARSET=utf8;
647
648--
649-- Extraindo dados da tabela `jaqmr_finder_terms_common`
650--
651
652INSERT INTO `jaqmr_finder_terms_common` (`term`, `language`) VALUES
653('a', 'en'),
654('about', 'en'),
655('after', 'en'),
656('ago', 'en'),
657('all', 'en'),
658('am', 'en'),
659('an', 'en'),
660('and', 'en'),
661('ani', 'en'),
662('any', 'en'),
663('are', 'en'),
664('aren''t', 'en'),
665('as', 'en'),
666('at', 'en'),
667('be', 'en'),
668('but', 'en'),
669('by', 'en'),
670('for', 'en'),
671('from', 'en'),
672('get', 'en'),
673('go', 'en'),
674('how', 'en'),
675('if', 'en'),
676('in', 'en'),
677('into', 'en'),
678('is', 'en'),
679('isn''t', 'en'),
680('it', 'en'),
681('its', 'en'),
682('me', 'en'),
683('more', 'en'),
684('most', 'en'),
685('must', 'en'),
686('my', 'en'),
687('new', 'en'),
688('no', 'en'),
689('none', 'en'),
690('not', 'en'),
691('noth', 'en'),
692('nothing', 'en'),
693('of', 'en'),
694('off', 'en'),
695('often', 'en'),
696('old', 'en'),
697('on', 'en'),
698('onc', 'en'),
699('once', 'en'),
700('onli', 'en'),
701('only', 'en'),
702('or', 'en'),
703('other', 'en'),
704('our', 'en'),
705('ours', 'en'),
706('out', 'en'),
707('over', 'en'),
708('page', 'en'),
709('she', 'en'),
710('should', 'en'),
711('small', 'en'),
712('so', 'en'),
713('some', 'en'),
714('than', 'en'),
715('thank', 'en'),
716('that', 'en'),
717('the', 'en'),
718('their', 'en'),
719('theirs', 'en'),
720('them', 'en'),
721('then', 'en'),
722('there', 'en'),
723('these', 'en'),
724('they', 'en'),
725('this', 'en'),
726('those', 'en'),
727('thus', 'en'),
728('time', 'en'),
729('times', 'en'),
730('to', 'en'),
731('too', 'en'),
732('true', 'en'),
733('under', 'en'),
734('until', 'en'),
735('up', 'en'),
736('upon', 'en'),
737('use', 'en'),
738('user', 'en'),
739('users', 'en'),
740('veri', 'en'),
741('version', 'en'),
742('very', 'en'),
743('via', 'en'),
744('want', 'en'),
745('was', 'en'),
746('way', 'en'),
747('were', 'en'),
748('what', 'en'),
749('when', 'en'),
750('where', 'en'),
751('whi', 'en'),
752('which', 'en'),
753('who', 'en'),
754('whom', 'en'),
755('whose', 'en'),
756('why', 'en'),
757('wide', 'en'),
758('will', 'en'),
759('with', 'en'),
760('within', 'en'),
761('without', 'en'),
762('would', 'en'),
763('yes', 'en'),
764('yet', 'en'),
765('you', 'en'),
766('your', 'en'),
767('yours', 'en');
768
769-- --------------------------------------------------------
770
771--
772-- Estrutura da tabela `jaqmr_finder_tokens`
773--
774
775CREATE TABLE IF NOT EXISTS `jaqmr_finder_tokens` (
776 `term` varchar(75) NOT NULL,
777 `stem` varchar(75) NOT NULL,
778 `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
779 `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
780 `weight` float unsigned NOT NULL DEFAULT '1',
781 `context` tinyint(1) unsigned NOT NULL DEFAULT '2',
782 KEY `idx_word` (`term`),
783 KEY `idx_context` (`context`)
784) ENGINE=MEMORY DEFAULT CHARSET=utf8;
785
786-- --------------------------------------------------------
787
788--
789-- Estrutura da tabela `jaqmr_finder_tokens_aggregate`
790--
791
792CREATE TABLE IF NOT EXISTS `jaqmr_finder_tokens_aggregate` (
793 `term_id` int(10) unsigned NOT NULL,
794 `map_suffix` char(1) NOT NULL,
795 `term` varchar(75) NOT NULL,
796 `stem` varchar(75) NOT NULL,
797 `common` tinyint(1) unsigned NOT NULL DEFAULT '0',
798 `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0',
799 `term_weight` float unsigned NOT NULL,
800 `context` tinyint(1) unsigned NOT NULL DEFAULT '2',
801 `context_weight` float unsigned NOT NULL,
802 `total_weight` float unsigned NOT NULL,
803 KEY `token` (`term`),
804 KEY `keyword_id` (`term_id`)
805) ENGINE=MEMORY DEFAULT CHARSET=utf8;
806
807-- --------------------------------------------------------
808
809--
810-- Estrutura da tabela `jaqmr_finder_types`
811--
812
813CREATE TABLE IF NOT EXISTS `jaqmr_finder_types` (
814 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
815 `title` varchar(100) NOT NULL,
816 `mime` varchar(100) NOT NULL,
817 PRIMARY KEY (`id`),
818 UNIQUE KEY `title` (`title`)
819) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
820
821-- --------------------------------------------------------
822
823--
824-- Estrutura da tabela `jaqmr_languages`
825--
826
827CREATE TABLE IF NOT EXISTS `jaqmr_languages` (
828 `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
829 `lang_code` char(7) NOT NULL,
830 `title` varchar(50) NOT NULL,
831 `title_native` varchar(50) NOT NULL,
832 `sef` varchar(50) NOT NULL,
833 `image` varchar(50) NOT NULL,
834 `description` varchar(512) NOT NULL,
835 `metakey` text NOT NULL,
836 `metadesc` text NOT NULL,
837 `sitename` varchar(1024) NOT NULL DEFAULT '',
838 `published` int(11) NOT NULL DEFAULT '0',
839 `access` int(10) unsigned NOT NULL DEFAULT '0',
840 `ordering` int(11) NOT NULL DEFAULT '0',
841 PRIMARY KEY (`lang_id`),
842 UNIQUE KEY `idx_sef` (`sef`),
843 UNIQUE KEY `idx_image` (`image`),
844 UNIQUE KEY `idx_langcode` (`lang_code`),
845 KEY `idx_access` (`access`),
846 KEY `idx_ordering` (`ordering`)
847) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
848
849--
850-- Extraindo dados da tabela `jaqmr_languages`
851--
852
853INSERT INTO `jaqmr_languages` (`lang_id`, `lang_code`, `title`, `title_native`, `sef`, `image`, `description`, `metakey`, `metadesc`, `sitename`, `published`, `access`, `ordering`) VALUES
854(1, 'en-GB', 'English (UK)', 'English (UK)', 'en', 'en', '', '', '', '', 1, 1, 1);
855
856-- --------------------------------------------------------
857
858--
859-- Estrutura da tabela `jaqmr_menu`
860--
861
862CREATE TABLE IF NOT EXISTS `jaqmr_menu` (
863 `id` int(11) NOT NULL AUTO_INCREMENT,
864 `menutype` varchar(24) NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype',
865 `title` varchar(255) NOT NULL COMMENT 'The display title of the menu item.',
866 `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The SEF alias of the menu item.',
867 `note` varchar(255) NOT NULL DEFAULT '',
868 `path` varchar(1024) NOT NULL COMMENT 'The computed path of the menu item based on the alias field.',
869 `link` varchar(1024) NOT NULL COMMENT 'The actually link the menu item refers to.',
870 `type` varchar(16) NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator',
871 `published` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The published state of the menu link.',
872 `parent_id` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'The parent menu item in the menu tree.',
873 `level` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The relative level in the tree.',
874 `component_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__extensions.id',
875 `ordering` int(11) NOT NULL DEFAULT '0' COMMENT 'The relative ordering of the menu item in the tree.',
876 `checked_out` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__users.id',
877 `checked_out_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.',
878 `browserNav` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The click behaviour of the link.',
879 `access` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The access level required to view the menu item.',
880 `img` varchar(255) NOT NULL COMMENT 'The image of the menu item.',
881 `template_style_id` int(10) unsigned NOT NULL DEFAULT '0',
882 `params` text NOT NULL COMMENT 'JSON encoded data for the menu item.',
883 `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
884 `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
885 `home` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Indicates if this menu item is the home or default page.',
886 `language` char(7) NOT NULL DEFAULT '',
887 `client_id` tinyint(4) NOT NULL DEFAULT '0',
888 PRIMARY KEY (`id`),
889 UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`,`language`),
890 KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`),
891 KEY `idx_menutype` (`menutype`),
892 KEY `idx_left_right` (`lft`,`rgt`),
893 KEY `idx_alias` (`alias`),
894 KEY `idx_path` (`path`(255)),
895 KEY `idx_language` (`language`)
896) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=468 ;
897
898--
899-- Extraindo dados da tabela `jaqmr_menu`
900--