NTXT2nSd

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4--
5-- Database: `joomla`
6--
7
8-- --------------------------------------------------------
9
10--
11-- Table structure for table `#__assets`
12--
13
14CREATE TABLE IF NOT EXISTS `#__assets` (
15  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
16  `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set parent.',
17  `lft` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
18  `rgt` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
19  `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
20  `name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.\n',
21  `title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.',
22  `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
23  PRIMARY KEY (`id`),
24  UNIQUE KEY `idx_asset_name` (`name`),
25  KEY `idx_lft_rgt` (`lft`,`rgt`),
26  KEY `idx_parent_id` (`parent_id`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
28
29--
30-- Dumping data for table `#__assets`
31--
32
33INSERT INTO `#__assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES
34(1, 0, 0, 113, 0, 'root.1', 'Root Asset', '{"core.login.site":{"6":1,"2":1},"core.login.admin":{"6":1},"core.login.offline":{"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}}'),
35(2, 1, 1, 2, 1, 'com_admin', 'com_admin', '{}'),
36(3, 1, 3, 6, 1, 'com_banners', 'com_banners', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
37(4, 1, 7, 8, 1, 'com_cache', 'com_cache', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
38(5, 1, 9, 10, 1, 'com_checkin', 'com_checkin', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
39(6, 1, 11, 12, 1, 'com_config', 'com_config', '{}'),
40(7, 1, 13, 16, 1, 'com_contact', 'com_contact', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
41(8, 1, 17, 20, 1, 'com_content', 'com_content', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.edit":{"4":1},"core.edit.state":{"5":1}}'),
42(9, 1, 21, 22, 1, 'com_cpanel', 'com_cpanel', '{}'),
43(10, 1, 23, 24, 1, 'com_installer', 'com_installer', '{"core.manage":{"7":0},"core.delete":{"7":0},"core.edit.state":{"7":0}}'),
44(11, 1, 25, 26, 1, 'com_languages', 'com_languages', '{"core.admin":{"7":1}}'),
45(12, 1, 27, 28, 1, 'com_login', 'com_login', '{}'),
46(13, 1, 29, 30, 1, 'com_mailto', 'com_mailto', '{}'),
47(14, 1, 31, 32, 1, 'com_massmail', 'com_massmail', '{}'),
48(15, 1, 33, 34, 1, 'com_media', 'com_media', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":{"5":1}}'),
49(16, 1, 35, 38, 1, 'com_menus', 'com_menus', '{"core.admin":{"7":1}}'),
50(17, 1, 39, 40, 1, 'com_messages', 'com_messages', '{"core.admin":{"7":1},"core.manage":{"7":1}}'),
51(18, 1, 41, 78, 1, 'com_modules', 'com_modules', '{"core.admin":{"7":1}}'),
52(19, 1, 79, 82, 1, 'com_newsfeeds', 'com_newsfeeds', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
53(20, 1, 83, 84, 1, 'com_plugins', 'com_plugins', '{"core.admin":{"7":1}}'),
54(21, 1, 85, 86, 1, 'com_redirect', 'com_redirect', '{"core.admin":{"7":1}}'),
55(22, 1, 87, 88, 1, 'com_search', 'com_search', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
56(23, 1, 89, 90, 1, 'com_templates', 'com_templates', '{"core.admin":{"7":1}}'),
57(24, 1, 91, 94, 1, 'com_users', 'com_users', '{"core.admin":{"7":1}}'),
58(26, 1, 95, 96, 1, 'com_wrapper', 'com_wrapper', '{}'),
59(27, 8, 18, 19, 2, 'com_content.category.2', 'Uncategorised', '{}'),
60(28, 3, 4, 5, 2, 'com_banners.category.3', 'Uncategorised', '{}'),
61(29, 7, 14, 15, 2, 'com_contact.category.4', 'Uncategorised', '{}'),
62(30, 19, 80, 81, 2, 'com_newsfeeds.category.5', 'Uncategorised', '{}'),
63(32, 24, 92, 93, 2, 'com_users.category.7', 'Uncategorised', '{}'),
64(33, 1, 97, 98, 1, 'com_finder', 'com_finder', '{"core.admin":{"7":1},"core.manage":{"6":1}}'),
65(34, 1, 99, 100, 1, 'com_joomlaupdate', 'com_joomlaupdate', '{}'),
66(35, 1, 101, 102, 1, 'com_tags', 'com_tags', '{}'),
67(36, 1, 103, 104, 1, 'com_contenthistory', 'com_contenthistory', '{}'),
68(37, 1, 105, 106, 1, 'com_ajax', 'com_ajax', '{}'),
69(38, 1, 107, 108, 1, 'com_postinstall', 'com_postinstall', '{}'),
70(39, 18, 42, 43, 2, 'com_modules.module.1', 'Main Menu', '{}'),
71(40, 18, 44, 45, 2, 'com_modules.module.2', 'Login', '{}'),
72(41, 18, 46, 47, 2, 'com_modules.module.3', 'Popular Articles', '{}'),
73(42, 18, 48, 49, 2, 'com_modules.module.4', 'Recently Added Articles', '{}'),
74(43, 18, 50, 51, 2, 'com_modules.module.8', 'Toolbar', '{}'),
75(44, 18, 52, 53, 2, 'com_modules.module.9', 'Quick Icons', '{}'),
76(45, 18, 54, 55, 2, 'com_modules.module.10', 'Logged-in Users', '{}'),
77(46, 18, 56, 57, 2, 'com_modules.module.12', 'Admin Menu', '{}'),
78(47, 18, 58, 59, 2, 'com_modules.module.13', 'Admin Submenu', '{}'),
79(48, 18, 60, 61, 2, 'com_modules.module.14', 'User Status', '{}'),
80(49, 18, 62, 63, 2, 'com_modules.module.15', 'Title', '{}'),
81(50, 18, 64, 65, 2, 'com_modules.module.16', 'Login Form', '{}'),
82(51, 18, 66, 67, 2, 'com_modules.module.17', 'Breadcrumbs', '{}'),
83(52, 18, 68, 69, 2, 'com_modules.module.79', 'Multilanguage status', '{}'),
84(53, 18, 70, 71, 2, 'com_modules.module.86', 'Joomla Version', '{}'),
85(54, 16, 36, 37, 2, 'com_menus.menu.1', 'Main Menu', '{}'),
86(55, 18, 72, 73, 2, 'com_modules.module.87', 'Sample Data', '{}'),
87(56, 1, 109, 110, 1, 'com_privacy', 'com_privacy', '{}'),
88(57, 1, 111, 112, 1, 'com_actionlogs', 'com_actionlogs', '{}'),
89(58, 18, 74, 75, 2, 'com_modules.module.88', 'Latest Actions', '{}'),
90(59, 18, 76, 77, 2, 'com_modules.module.89', 'Privacy Dashboard', '{}');
91
92
93-- --------------------------------------------------------
94
95--
96-- Table structure for table `#__associations`
97--
98
99CREATE TABLE IF NOT EXISTS `#__associations` (
100  `id` int(11) NOT NULL COMMENT 'A reference to the associated item.',
101  `context` varchar(50) NOT NULL COMMENT 'The context of the associated item.',
102  `key` char(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
103  PRIMARY KEY (`context`,`id`),
104  KEY `idx_key` (`key`)
105) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
106
107-- --------------------------------------------------------
108
109--
110-- Table structure for table `#__banners`
111--
112
113CREATE TABLE IF NOT EXISTS `#__banners` (
114  `id` int(11) NOT NULL AUTO_INCREMENT,
115  `cid` int(11) NOT NULL DEFAULT 0,
116  `type` int(11) NOT NULL DEFAULT 0,
117  `name` varchar(255) NOT NULL DEFAULT '',
118  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
119  `imptotal` int(11) NOT NULL DEFAULT 0,
120  `impmade` int(11) NOT NULL DEFAULT 0,
121  `clicks` int(11) NOT NULL DEFAULT 0,
122  `clickurl` varchar(200) NOT NULL DEFAULT '',
123  `state` tinyint(3) NOT NULL DEFAULT 0,
124  `catid` int(10) unsigned NOT NULL DEFAULT 0,
125  `description` text NOT NULL,
126  `custombannercode` varchar(2048) NOT NULL,
127  `sticky` tinyint(1) unsigned NOT NULL DEFAULT 0,
128  `ordering` int(11) NOT NULL DEFAULT 0,
129  `metakey` text NOT NULL,
130  `params` text NOT NULL,
131  `own_prefix` tinyint(1) NOT NULL DEFAULT 0,
132  `metakey_prefix` varchar(400) NOT NULL DEFAULT '',
133  `purchase_type` tinyint(4) NOT NULL DEFAULT -1,
134  `track_clicks` tinyint(4) NOT NULL DEFAULT -1,
135  `track_impressions` tinyint(4) NOT NULL DEFAULT -1,
136  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
137  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
138  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
139  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
140  `reset` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
141  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
142  `language` char(7) NOT NULL DEFAULT '',
143  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
144  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
145  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
146  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
147  `version` int(10) unsigned NOT NULL DEFAULT 1,
148  PRIMARY KEY (`id`),
149  KEY `idx_state` (`state`),
150  KEY `idx_own_prefix` (`own_prefix`),
151  KEY `idx_metakey_prefix` (`metakey_prefix`(100)),
152  KEY `idx_banner_catid` (`catid`),
153  KEY `idx_language` (`language`)
154) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
155
156-- --------------------------------------------------------
157
158--
159-- Table structure for table `#__banner_clients`
160--
161
162CREATE TABLE IF NOT EXISTS `#__banner_clients` (
163  `id` int(11) NOT NULL AUTO_INCREMENT,
164  `name` varchar(255) NOT NULL DEFAULT '',
165  `contact` varchar(255) NOT NULL DEFAULT '',
166  `email` varchar(255) NOT NULL DEFAULT '',
167  `extrainfo` text NOT NULL,
168  `state` tinyint(3) NOT NULL DEFAULT 0,
169  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
170  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
171  `metakey` text NOT NULL,
172  `own_prefix` tinyint(4) NOT NULL DEFAULT 0,
173  `metakey_prefix` varchar(400) NOT NULL DEFAULT '',
174  `purchase_type` tinyint(4) NOT NULL DEFAULT -1,
175  `track_clicks` tinyint(4) NOT NULL DEFAULT -1,
176  `track_impressions` tinyint(4) NOT NULL DEFAULT -1,
177  PRIMARY KEY (`id`),
178  KEY `idx_own_prefix` (`own_prefix`),
179  KEY `idx_metakey_prefix` (`metakey_prefix`(100))
180) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
181
182-- --------------------------------------------------------
183
184--
185-- Table structure for table `#__banner_tracks`
186--
187
188CREATE TABLE IF NOT EXISTS `#__banner_tracks` (
189  `track_date` datetime NOT NULL,
190  `track_type` int(10) unsigned NOT NULL,
191  `banner_id` int(10) unsigned NOT NULL,
192  `count` int(10) unsigned NOT NULL DEFAULT 0,
193  PRIMARY KEY (`track_date`,`track_type`,`banner_id`),
194  KEY `idx_track_date` (`track_date`),
195  KEY `idx_track_type` (`track_type`),
196  KEY `idx_banner_id` (`banner_id`)
197) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
198
199-- --------------------------------------------------------
200
201--
202-- Table structure for table `#__categories`
203--
204
205CREATE TABLE IF NOT EXISTS `#__categories` (
206  `id` int(11) NOT NULL AUTO_INCREMENT,
207  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
208  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
209  `lft` int(11) NOT NULL DEFAULT 0,
210  `rgt` int(11) NOT NULL DEFAULT 0,
211  `level` int(10) unsigned NOT NULL DEFAULT 0,
212  `path` varchar(400) NOT NULL DEFAULT '',
213  `extension` varchar(50) NOT NULL DEFAULT '',
214  `title` varchar(255) NOT NULL DEFAULT '',
215  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
216  `note` varchar(255) NOT NULL DEFAULT '',
217  `description` mediumtext NOT NULL DEFAULT '',
218  `published` tinyint(1) NOT NULL DEFAULT 0,
219  `checked_out` int(11) unsigned NOT NULL DEFAULT 0,
220  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
221  `access` int(10) unsigned NOT NULL DEFAULT 0,
222  `params` text NOT NULL DEFAULT '',
223  `metadesc` varchar(1024) NOT NULL DEFAULT '' COMMENT 'The meta description for the page.',
224  `metakey` varchar(1024) NOT NULL DEFAULT '' COMMENT 'The meta keywords for the page.',
225  `metadata` varchar(2048) NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.',
226  `created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
227  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
228  `modified_user_id` int(10) unsigned NOT NULL DEFAULT 0,
229  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
230  `hits` int(10) unsigned NOT NULL DEFAULT 0,
231  `language` char(7) NOT NULL DEFAULT '',
232  `version` int(10) unsigned NOT NULL DEFAULT 1,
233  PRIMARY KEY (`id`),
234  KEY `cat_idx` (`extension`,`published`,`access`),
235  KEY `idx_access` (`access`),
236  KEY `idx_checkout` (`checked_out`),
237  KEY `idx_path` (`path`(100)),
238  KEY `idx_left_right` (`lft`,`rgt`),
239  KEY `idx_alias` (`alias`(100)),
240  KEY `idx_language` (`language`)
241) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
242
243--
244-- Dumping data for table `#__categories`
245--
246
247INSERT INTO `#__categories` (`id`, `asset_id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `modified_user_id`, `modified_time`, `hits`, `language`, `version`) VALUES
248(1, 0, 0, 0, 11, 0, '', 'system', 'ROOT', 'root', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{}', '', '', '{}', 42, '2011-01-01 00:00:01', 0, '0000-00-00 00:00:00', 0, '*', 1),
249(2, 27, 1, 1, 2, 1, 'uncategorised', 'com_content', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, '2011-01-01 00:00:01', 0, '0000-00-00 00:00:00', 0, '*', 1),
250(3, 28, 1, 3, 4, 1, 'uncategorised', 'com_banners', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, '2011-01-01 00:00:01', 0, '0000-00-00 00:00:00', 0, '*', 1),
251(4, 29, 1, 5, 6, 1, 'uncategorised', 'com_contact', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, '2011-01-01 00:00:01', 0, '0000-00-00 00:00:00', 0, '*', 1),
252(5, 30, 1, 7, 8, 1, 'uncategorised', 'com_newsfeeds', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, '2011-01-01 00:00:01', 0, '0000-00-00 00:00:00', 0, '*', 1),
253(7, 32, 1, 9, 10, 1, 'uncategorised', 'com_users', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 42, '2011-01-01 00:00:01', 0, '0000-00-00 00:00:00', 0, '*', 1);
254
255-- --------------------------------------------------------
256
257--
258-- Table structure for table `#__contact_details`
259--
260
261CREATE TABLE IF NOT EXISTS `#__contact_details` (
262  `id` int(11) NOT NULL AUTO_INCREMENT,
263  `name` varchar(255) NOT NULL,
264  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
265  `con_position` varchar(255),
266  `address` text,
267  `suburb` varchar(100),
268  `state` varchar(100),
269  `country` varchar(100),
270  `postcode` varchar(100),
271  `telephone` varchar(255),
272  `fax` varchar(255),
273  `misc` mediumtext,
274  `image` varchar(255),
275  `email_to` varchar(255),
276  `default_con` tinyint(1) unsigned NOT NULL DEFAULT 0,
277  `published` tinyint(1) NOT NULL DEFAULT 0,
278  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
279  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
280  `ordering` int(11) NOT NULL DEFAULT 0,
281  `params` text NOT NULL,
282  `user_id` int(11) NOT NULL DEFAULT 0,
283  `catid` int(11) NOT NULL DEFAULT 0,
284  `access` int(10) unsigned NOT NULL DEFAULT 0,
285  `mobile` varchar(255) NOT NULL DEFAULT '',
286  `webpage` varchar(255) NOT NULL DEFAULT '',
287  `sortname1` varchar(255) NOT NULL DEFAULT '',
288  `sortname2` varchar(255) NOT NULL DEFAULT '',
289  `sortname3` varchar(255) NOT NULL DEFAULT '',
290  `language` varchar(7) NOT NULL,
291  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
292  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
293  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
294  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
295  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
296  `metakey` text NOT NULL,
297  `metadesc` text NOT NULL,
298  `metadata` text NOT NULL,
299  `featured` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if contact is featured.',
300  `xreference` varchar(50) NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
301  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
302  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
303  `version` int(10) unsigned NOT NULL DEFAULT 1,
304  `hits` int(10) unsigned NOT NULL DEFAULT 0,
305  PRIMARY KEY (`id`),
306  KEY `idx_access` (`access`),
307  KEY `idx_checkout` (`checked_out`),
308  KEY `idx_state` (`published`),
309  KEY `idx_catid` (`catid`),
310  KEY `idx_createdby` (`created_by`),
311  KEY `idx_featured_catid` (`featured`,`catid`),
312  KEY `idx_language` (`language`),
313  KEY `idx_xreference` (`xreference`)
314) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
315
316-- --------------------------------------------------------
317
318--
319-- Table structure for table `#__content`
320--
321
322CREATE TABLE IF NOT EXISTS `#__content` (
323  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
324  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
325  `title` varchar(255) NOT NULL DEFAULT '',
326  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
327  `introtext` mediumtext NOT NULL,
328  `fulltext` mediumtext NOT NULL,
329  `state` tinyint(3) NOT NULL DEFAULT 0,
330  `catid` int(10) unsigned NOT NULL DEFAULT 0,
331  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
332  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
333  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
334  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
335  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
336  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
337  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
338  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
339  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
340  `images` text NOT NULL,
341  `urls` text NOT NULL,
342  `attribs` varchar(5120) NOT NULL,
343  `version` int(10) unsigned NOT NULL DEFAULT 1,
344  `ordering` int(11) NOT NULL DEFAULT 0,
345  `metakey` text NOT NULL,
346  `metadesc` text NOT NULL,
347  `access` int(10) unsigned NOT NULL DEFAULT 0,
348  `hits` int(10) unsigned NOT NULL DEFAULT 0,
349  `metadata` text NOT NULL,
350  `featured` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
351  `language` char(7) NOT NULL COMMENT 'The language code for the article.',
352  `xreference` varchar(50) NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
353  `note` varchar(255) NOT NULL DEFAULT '',
354  PRIMARY KEY (`id`),
355  KEY `idx_access` (`access`),
356  KEY `idx_checkout` (`checked_out`),
357  KEY `idx_state` (`state`),
358  KEY `idx_catid` (`catid`),
359  KEY `idx_createdby` (`created_by`),
360  KEY `idx_featured_catid` (`featured`,`catid`),
361  KEY `idx_language` (`language`),
362  KEY `idx_xreference` (`xreference`),
363  KEY `idx_alias` (`alias`(191))
364) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
365
366-- --------------------------------------------------------
367
368--
369-- Table structure for table `#__content_frontpage`
370--
371
372CREATE TABLE IF NOT EXISTS `#__content_frontpage` (
373  `content_id` int(11) NOT NULL DEFAULT 0,
374  `ordering` int(11) NOT NULL DEFAULT 0,
375  PRIMARY KEY (`content_id`)
376) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
377
378-- --------------------------------------------------------
379
380--
381-- Table structure for table `#__content_rating`
382--
383
384CREATE TABLE IF NOT EXISTS `#__content_rating` (
385  `content_id` int(11) NOT NULL DEFAULT 0,
386  `rating_sum` int(10) unsigned NOT NULL DEFAULT 0,
387  `rating_count` int(10) unsigned NOT NULL DEFAULT 0,
388  `lastip` varchar(50) NOT NULL DEFAULT '',
389  PRIMARY KEY (`content_id`)
390) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
391
392-- --------------------------------------------------------
393
394--
395-- Table structure for table `#__content_types`
396--
397
398CREATE TABLE IF NOT EXISTS `#__content_types` (
399  `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
400  `type_title` varchar(255) NOT NULL DEFAULT '',
401  `type_alias` varchar(400) NOT NULL DEFAULT '',
402  `table` varchar(255) NOT NULL DEFAULT '',
403  `rules` text NOT NULL,
404  `field_mappings` text NOT NULL,
405  `router` varchar(255) NOT NULL DEFAULT '',
406  `content_history_options` varchar(5120) COMMENT 'JSON string for com_contenthistory options',
407  PRIMARY KEY (`type_id`),
408  KEY `idx_alias` (`type_alias`(100))
409) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10000;
410
411--
412-- Dumping data for table `#__content_types`
413--
414
415INSERT INTO `#__content_types` (`type_id`, `type_title`, `type_alias`, `table`, `rules`, `field_mappings`, `router`, `content_history_options`) VALUES
416(1, 'Article', 'com_content.article', '{"special":{"dbtable":"#__content","key":"id","type":"Content","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"state","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"introtext", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"attribs", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"asset_id", "note":"note"}, "special":{"fulltext":"fulltext"}}', 'ContentHelperRoute::getArticleRoute', '{"formFile":"administrator\\/components\\/com_content\\/models\\/forms\\/article.xml", "hideFields":["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}'),
417(2, 'Contact', 'com_contact.contact', '{"special":{"dbtable":"#__contact_details","key":"id","type":"Contact","prefix":"ContactTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"address", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"image", "core_urls":"webpage", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}, "special":{"con_position":"con_position","suburb":"suburb","state":"state","country":"country","postcode":"postcode","telephone":"telephone","fax":"fax","misc":"misc","email_to":"email_to","default_con":"default_con","user_id":"user_id","mobile":"mobile","sortname1":"sortname1","sortname2":"sortname2","sortname3":"sortname3"}}', 'ContactHelperRoute::getContactRoute', '{"formFile":"administrator\\/components\\/com_contact\\/models\\/forms\\/contact.xml","hideFields":["default_con","checked_out","checked_out_time","version","xreference"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"], "displayLookup":[ {"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ] }'),
418(3, 'Newsfeed', 'com_newsfeeds.newsfeed', '{"special":{"dbtable":"#__newsfeeds","key":"id","type":"Newsfeed","prefix":"NewsfeedsTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"hits","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"xreference", "asset_id":"null"}, "special":{"numarticles":"numarticles","cache_time":"cache_time","rtl":"rtl"}}', 'NewsfeedsHelperRoute::getNewsfeedRoute', '{"formFile":"administrator\\/components\\/com_newsfeeds\\/models\\/forms\\/newsfeed.xml","hideFields":["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "hits"],"convertToInt":["publish_up", "publish_down", "featured", "ordering"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}'),
419(4, 'User', 'com_users.user', '{"special":{"dbtable":"#__users","key":"id","type":"User","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"null","core_alias":"username","core_created_time":"registerdate","core_modified_time":"lastvisitDate","core_body":"null", "core_hits":"null","core_publish_up":"null","core_publish_down":"null","access":"null", "core_params":"params", "core_featured":"null", "core_metadata":"null", "core_language":"null", "core_images":"null", "core_urls":"null", "core_version":"null", "core_ordering":"null", "core_metakey":"null", "core_metadesc":"null", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}, "special":{}}', 'UsersHelperRoute::getUserRoute', ''),
420(5, 'Article Category', 'com_content.category', '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', 'ContentHelperRoute::getCategoryRoute', '{"formFile":"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'),
421(6, 'Contact Category', 'com_contact.category', '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', 'ContactHelperRoute::getCategoryRoute', '{"formFile":"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'),
422(7, 'Newsfeeds Category', 'com_newsfeeds.category', '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', 'NewsfeedsHelperRoute::getCategoryRoute', '{"formFile":"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'),
423(8, 'Tag', 'com_tags.tag', '{"special":{"dbtable":"#__tags","key":"tag_id","type":"Tag","prefix":"TagsTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"featured", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"urls", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"null", "core_xreference":"null", "asset_id":"null"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path"}}', 'TagsHelperRoute::getTagRoute', '{"formFile":"administrator\\/components\\/com_tags\\/models\\/forms\\/tag.xml", "hideFields":["checked_out","checked_out_time","version", "lft", "rgt", "level", "path", "urls", "publish_up", "publish_down"],"ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"],"convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}'),
424(9, 'Banner', 'com_banners.banner', '{"special":{"dbtable":"#__banners","key":"id","type":"Banner","prefix":"BannersTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"null","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"null", "asset_id":"null"}, "special":{"imptotal":"imptotal", "impmade":"impmade", "clicks":"clicks", "clickurl":"clickurl", "custombannercode":"custombannercode", "cid":"cid", "purchase_type":"purchase_type", "track_impressions":"track_impressions", "track_clicks":"track_clicks"}}', '','{"formFile":"administrator\\/components\\/com_banners\\/models\\/forms\\/banner.xml", "hideFields":["checked_out","checked_out_time","version", "reset"],"ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time", "version", "imptotal", "impmade", "reset"], "convertToInt":["publish_up", "publish_down", "ordering"], "displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"cid","targetTable":"#__banner_clients","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"} ]}'),
425(10, 'Banners Category', 'com_banners.category', '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special": {"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}','','{"formFile":"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml", "hideFields":["asset_id","checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"], "convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}'),
426(11, 'Banner Client', 'com_banners.client', '{"special":{"dbtable":"#__banner_clients","key":"id","type":"Client","prefix":"BannersTable"}}', '', '', '', '{"formFile":"administrator\\/components\\/com_banners\\/models\\/forms\\/client.xml", "hideFields":["checked_out","checked_out_time"], "ignoreChanges":["checked_out", "checked_out_time"], "convertToInt":[], "displayLookup":[]}'),
427(12, 'User Notes', 'com_users.note', '{"special":{"dbtable":"#__user_notes","key":"id","type":"Note","prefix":"UsersTable"}}', '', '', '', '{"formFile":"administrator\\/components\\/com_users\\/models\\/forms\\/note.xml", "hideFields":["checked_out","checked_out_time", "publish_up", "publish_down"],"ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time"], "convertToInt":["publish_up", "publish_down"],"displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}, {"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}'),
428(13, 'User Notes Category', 'com_users.category', '{"special":{"dbtable":"#__categories","key":"id","type":"Category","prefix":"JTable","config":"array()"},"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"title","core_state":"published","core_alias":"alias","core_created_time":"created_time","core_modified_time":"modified_time","core_body":"description", "core_hits":"hits","core_publish_up":"null","core_publish_down":"null","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"null", "core_urls":"null", "core_version":"version", "core_ordering":"null", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"parent_id", "core_xreference":"null", "asset_id":"asset_id"}, "special":{"parent_id":"parent_id","lft":"lft","rgt":"rgt","level":"level","path":"path","extension":"extension","note":"note"}}', '', '{"formFile":"administrator\\/components\\/com_categories\\/models\\/forms\\/category.xml", "hideFields":["checked_out","checked_out_time","version","lft","rgt","level","path","extension"], "ignoreChanges":["modified_user_id", "modified_time", "checked_out", "checked_out_time", "version", "hits", "path"], "convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"created_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}, {"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_user_id","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"parent_id","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"}]}');
429
430-- --------------------------------------------------------
431
432--
433-- Table structure for table `#__contentitem_tag_map`
434--
435
436CREATE TABLE IF NOT EXISTS `#__contentitem_tag_map` (
437  `type_alias` varchar(255) NOT NULL DEFAULT '',
438  `core_content_id` int(10) unsigned NOT NULL COMMENT 'PK from the core content table',
439  `content_item_id` int(11) NOT NULL COMMENT 'PK from the content type table',
440  `tag_id` int(10) unsigned NOT NULL COMMENT 'PK from the tag table',
441  `tag_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of most recent save for this tag-item',
442  `type_id` mediumint(8) NOT NULL COMMENT 'PK from the content_type table',
443  UNIQUE KEY `uc_ItemnameTagid` (`type_id`,`content_item_id`,`tag_id`),
444  KEY `idx_tag_type` (`tag_id`,`type_id`),
445  KEY `idx_date_id` (`tag_date`,`tag_id`),
446  KEY `idx_core_content_id` (`core_content_id`)
447) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Maps items from content tables to tags';
448
449-- --------------------------------------------------------
450
451--
452-- Table structure for table `#__core_log_searches`
453--
454
455CREATE TABLE IF NOT EXISTS `#__core_log_searches` (
456  `search_term` varchar(128) NOT NULL DEFAULT '',
457  `hits` int(10) unsigned NOT NULL DEFAULT 0
458) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
459
460-- --------------------------------------------------------
461
462--
463-- Table structure for table `#__extensions`
464--
465
466CREATE TABLE IF NOT EXISTS `#__extensions` (
467  `extension_id` int(11) NOT NULL AUTO_INCREMENT,
468  `package_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Parent package ID for extensions installed as a package.',
469  `name` varchar(100) NOT NULL,
470  `type` varchar(20) NOT NULL,
471  `element` varchar(100) NOT NULL,
472  `folder` varchar(100) NOT NULL,
473  `client_id` tinyint(3) NOT NULL,
474  `enabled` tinyint(3) NOT NULL DEFAULT 0,
475  `access` int(10) unsigned NOT NULL DEFAULT 1,
476  `protected` tinyint(3) NOT NULL DEFAULT 0,
477  `manifest_cache` text NOT NULL,
478  `params` text NOT NULL,
479  `custom_data` text NOT NULL,
480  `system_data` text NOT NULL,
481  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
482  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
483  `ordering` int(11) DEFAULT 0,
484  `state` int(11) DEFAULT 0,
485  PRIMARY KEY (`extension_id`),
486  KEY `element_clientid` (`element`,`client_id`),
487  KEY `element_folder_clientid` (`element`,`folder`,`client_id`),
488  KEY `extension` (`type`,`element`,`folder`,`client_id`)
489) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10000;
490
491--
492-- Dumping data for table `#__extensions`
493--
494
495INSERT INTO `#__extensions` (`extension_id`, `package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES
496(1, 0, 'com_mailto', 'component', 'com_mailto', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
497(2, 0, 'com_wrapper', 'component', 'com_wrapper', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
498(3, 0, 'com_admin', 'component', 'com_admin', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
499(4, 0, 'com_banners', 'component', 'com_banners', '', 1, 1, 1, 0, '', '{"purchase_type":"3","track_impressions":"0","track_clicks":"0","metakey_prefix":"","save_history":"1","history_limit":10}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
500(5, 0, 'com_cache', 'component', 'com_cache', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
501(6, 0, 'com_categories', 'component', 'com_categories', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
502(7, 0, 'com_checkin', 'component', 'com_checkin', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
503(8, 0, 'com_contact', 'component', 'com_contact', '', 1, 1, 1, 0, '', '{"contact_layout":"_:default","show_contact_category":"hide","save_history":"1","history_limit":10,"show_contact_list":"0","presentation_style":"sliders","show_tags":"1","show_info":"1","show_name":"1","show_position":"1","show_email":"0","show_street_address":"1","show_suburb":"1","show_state":"1","show_postcode":"1","show_country":"1","show_telephone":"1","show_mobile":"1","show_fax":"1","show_webpage":"1","show_image":"1","show_misc":"1","image":"","allow_vcard":"0","show_articles":"0","articles_display_num":"10","show_profile":"0","show_user_custom_fields":["-1"],"show_links":"0","linka_name":"","linkb_name":"","linkc_name":"","linkd_name":"","linke_name":"","contact_icons":"0","icon_address":"","icon_email":"","icon_telephone":"","icon_mobile":"","icon_fax":"","icon_misc":"","category_layout":"_:default","show_category_title":"1","show_description":"1","show_description_image":"0","maxLevel":"-1","show_subcat_desc":"1","show_empty_categories":"0","show_cat_items":"1","show_cat_tags":"1","show_base_description":"1","maxLevelcat":"-1","show_subcat_desc_cat":"1","show_empty_categories_cat":"0","show_cat_items_cat":"1","filter_field":"0","show_pagination_limit":"0","show_headings":"1","show_image_heading":"0","show_position_headings":"1","show_email_headings":"0","show_telephone_headings":"1","show_mobile_headings":"0","show_fax_headings":"0","show_suburb_headings":"1","show_state_headings":"1","show_country_headings":"1","show_pagination":"2","show_pagination_results":"1","initial_sort":"ordering","captcha":"","show_email_form":"1","show_email_copy":"0","banned_email":"","banned_subject":"","banned_text":"","validate_session":"1","custom_reply":"0","redirect":"","show_feed_link":"1","sef_advanced":0,"sef_ids":0,"custom_fields_enable":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
504(9, 0, 'com_cpanel', 'component', 'com_cpanel', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
505(10, 0, 'com_installer', 'component', 'com_installer', '', 1, 1, 1, 1, '', '{"show_jed_info":"1","cachetimeout":"6","minimum_stability":"4"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
506(11, 0, 'com_languages', 'component', 'com_languages', '', 1, 1, 1, 1, '', '{"administrator":"en-GB","site":"en-GB"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
507(12, 0, 'com_login', 'component', 'com_login', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
508(13, 0, 'com_media', 'component', 'com_media', '', 1, 1, 0, 1, '', '{"upload_extensions":"bmp,csv,doc,gif,ico,jpg,jpeg,odg,odp,ods,odt,pdf,png,ppt,txt,xcf,xls,BMP,CSV,DOC,GIF,ICO,JPG,JPEG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,TXT,XCF,XLS","upload_maxsize":"10","file_path":"images","image_path":"images","restrict_uploads":"1","allowed_media_usergroup":"3","check_mime":"1","image_extensions":"bmp,gif,jpg,png","ignore_extensions":"","upload_mime":"image\\/jpeg,image\\/gif,image\\/png,image\\/bmp,application\\/msword,application\\/excel,application\\/pdf,application\\/powerpoint,text\\/plain,application\\/x-zip","upload_mime_illegal":"text\\/html"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
509(14, 0, 'com_menus', 'component', 'com_menus', '', 1, 1, 1, 1, '', '{"page_title":"","show_page_heading":0,"page_heading":"","pageclass_sfx":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
510(15, 0, 'com_messages', 'component', 'com_messages', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
511(16, 0, 'com_modules', 'component', 'com_modules', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
512(17, 0, 'com_newsfeeds', 'component', 'com_newsfeeds', '', 1, 1, 1, 0, '', '{"newsfeed_layout":"_:default","save_history":"1","history_limit":5,"show_feed_image":"1","show_feed_description":"1","show_item_description":"1","feed_character_count":"0","feed_display_order":"des","float_first":"right","float_second":"right","show_tags":"1","category_layout":"_:default","show_category_title":"1","show_description":"1","show_description_image":"1","maxLevel":"-1","show_empty_categories":"0","show_subcat_desc":"1","show_cat_items":"1","show_cat_tags":"1","show_base_description":"1","maxLevelcat":"-1","show_empty_categories_cat":"0","show_subcat_desc_cat":"1","show_cat_items_cat":"1","filter_field":"1","show_pagination_limit":"1","show_headings":"1","show_articles":"0","show_link":"1","show_pagination":"1","show_pagination_results":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
513(18, 0, 'com_plugins', 'component', 'com_plugins', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
514(19, 0, 'com_search', 'component', 'com_search', '', 1, 1, 1, 0, '', '{"enabled":"0","search_phrases":"1","search_areas":"1","show_date":"1","opensearch_name":"","opensearch_description":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
515(20, 0, 'com_templates', 'component', 'com_templates', '', 1, 1, 1, 1, '', '{"template_positions_display":"0","upload_limit":"10","image_formats":"gif,bmp,jpg,jpeg,png","source_formats":"txt,less,ini,xml,js,php,css,scss,sass","font_formats":"woff,ttf,otf","compressed_formats":"zip"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
516(22, 0, 'com_content', 'component', 'com_content', '', 1, 1, 0, 1, '', '{"article_layout":"_:default","show_title":"1","link_titles":"1","show_intro":"1","show_category":"1","link_category":"1","show_parent_category":"0","link_parent_category":"0","show_author":"1","link_author":"0","show_create_date":"0","show_modify_date":"0","show_publish_date":"1","show_item_navigation":"1","show_vote":"0","show_readmore":"1","show_readmore_title":"1","readmore_limit":"100","show_icons":"1","show_print_icon":"1","show_email_icon":"0","show_hits":"1","show_noauth":"0","show_publishing_options":"1","show_article_options":"1","save_history":"1","history_limit":10,"show_urls_images_frontend":"0","show_urls_images_backend":"1","targeta":0,"targetb":0,"targetc":0,"float_intro":"left","float_fulltext":"left","category_layout":"_:blog","show_category_title":"0","show_description":"0","show_description_image":"0","maxLevel":"1","show_empty_categories":"0","show_no_articles":"1","show_subcat_desc":"1","show_cat_num_articles":"0","show_base_description":"1","maxLevelcat":"-1","show_empty_categories_cat":"0","show_subcat_desc_cat":"1","show_cat_num_articles_cat":"1","num_leading_articles":"1","num_intro_articles":"4","num_columns":"2","num_links":"4","multi_column_order":"0","show_subcategory_content":"0","show_pagination_limit":"1","filter_field":"hide","show_headings":"1","list_show_date":"0","date_format":"","list_show_hits":"1","list_show_author":"1","orderby_pri":"order","orderby_sec":"rdate","order_date":"published","show_pagination":"2","show_pagination_results":"1","show_feed_link":"1","feed_summary":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
517(23, 0, 'com_config', 'component', 'com_config', '', 1, 1, 0, 1, '', '{"filters":{"1":{"filter_type":"NH","filter_tags":"","filter_attributes":""},"6":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"7":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"2":{"filter_type":"NH","filter_tags":"","filter_attributes":""},"3":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"4":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"5":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"10":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"12":{"filter_type":"BL","filter_tags":"","filter_attributes":""},"8":{"filter_type":"NONE","filter_tags":"","filter_attributes":""}}}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
518(24, 0, 'com_redirect', 'component', 'com_redirect', '', 1, 1, 0, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
519(25, 0, 'com_users', 'component', 'com_users', '', 1, 1, 0, 1, '', '{"allowUserRegistration":"0","new_usertype":"2","guest_usergroup":"9","sendpassword":"0","useractivation":"2","mail_to_admin":"1","captcha":"","frontend_userparams":"1","site_language":"0","change_login_name":"0","reset_count":"10","reset_time":"1","minimum_length":"4","minimum_integers":"0","minimum_symbols":"0","minimum_uppercase":"0","save_history":"1","history_limit":5,"mailSubjectPrefix":"","mailBodySuffix":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
520(27, 0, 'com_finder', 'component', 'com_finder', '', 1, 1, 0, 0, '', '{"enabled":"0","show_description":"1","description_length":255,"allow_empty_query":"0","show_url":"1","show_autosuggest":"1","show_suggested_query":"1","show_explained_query":"1","show_advanced":"1","show_advanced_tips":"1","expand_advanced":"0","show_date_filters":"0","sort_order":"relevance","sort_direction":"desc","highlight_terms":"1","opensearch_name":"","opensearch_description":"","batch_size":"50","memory_table_limit":30000,"title_multiplier":"1.7","text_multiplier":"0.7","meta_multiplier":"1.2","path_multiplier":"2.0","misc_multiplier":"0.3","stem":"1","stemmer":"snowball","enable_logging":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
521(28, 0, 'com_joomlaupdate', 'component', 'com_joomlaupdate', '', 1, 1, 0, 1, '', '{"updatesource":"default","customurl":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
522(29, 0, 'com_tags', 'component', 'com_tags', '', 1, 1, 1, 1, '', '{"tag_layout":"_:default","save_history":"1","history_limit":5,"show_tag_title":"0","tag_list_show_tag_image":"0","tag_list_show_tag_description":"0","tag_list_image":"","tag_list_orderby":"title","tag_list_orderby_direction":"ASC","show_headings":"0","tag_list_show_date":"0","tag_list_show_item_image":"0","tag_list_show_item_description":"0","tag_list_item_maximum_characters":0,"return_any_or_all":"1","include_children":"0","maximum":200,"tag_list_language_filter":"all","tags_layout":"_:default","all_tags_orderby":"title","all_tags_orderby_direction":"ASC","all_tags_show_tag_image":"0","all_tags_show_tag_descripion":"0","all_tags_tag_maximum_characters":20,"all_tags_show_tag_hits":"0","filter_field":"1","show_pagination_limit":"1","show_pagination":"2","show_pagination_results":"1","tag_field_ajax_mode":"1","show_feed_link":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
523(30, 0, 'com_contenthistory', 'component', 'com_contenthistory', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
524(31, 0, 'com_ajax', 'component', 'com_ajax', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
525(32, 0, 'com_postinstall', 'component', 'com_postinstall', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
526(33, 0, 'com_fields', 'component', 'com_fields', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
527(34, 0, 'com_associations', 'component', 'com_associations', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
528(35, 0, 'com_privacy', 'component', 'com_privacy', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
529(36, 0, 'com_actionlogs', 'component', 'com_actionlogs', '', 1, 1, 1, 1, '', '{"ip_logging":0,"csv_delimiter":",","loggable_extensions":["com_banners","com_cache","com_categories","com_config","com_contact","com_content","com_installer","com_media","com_menus","com_messages","com_modules","com_newsfeeds","com_plugins","com_redirect","com_tags","com_templates","com_users"]}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
530(102, 0, 'phputf8', 'library', 'phputf8', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
531(103, 0, 'Joomla! Platform', 'library', 'joomla', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
532(104, 0, 'IDNA Convert', 'library', 'idna_convert', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
533(105, 0, 'FOF', 'library', 'fof', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
534(106, 0, 'PHPass', 'library', 'phpass', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
535(200, 0, 'mod_articles_archive', 'module', 'mod_articles_archive', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
536(201, 0, 'mod_articles_latest', 'module', 'mod_articles_latest', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
537(202, 0, 'mod_articles_popular', 'module', 'mod_articles_popular', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
538(203, 0, 'mod_banners', 'module', 'mod_banners', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
539(204, 0, 'mod_breadcrumbs', 'module', 'mod_breadcrumbs', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
540(205, 0, 'mod_custom', 'module', 'mod_custom', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
541(206, 0, 'mod_feed', 'module', 'mod_feed', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
542(207, 0, 'mod_footer', 'module', 'mod_footer', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
543(208, 0, 'mod_login', 'module', 'mod_login', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
544(209, 0, 'mod_menu', 'module', 'mod_menu', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
545(210, 0, 'mod_articles_news', 'module', 'mod_articles_news', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
546(211, 0, 'mod_random_image', 'module', 'mod_random_image', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
547(212, 0, 'mod_related_items', 'module', 'mod_related_items', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
548(213, 0, 'mod_search', 'module', 'mod_search', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
549(214, 0, 'mod_stats', 'module', 'mod_stats', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
550(215, 0, 'mod_syndicate', 'module', 'mod_syndicate', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
551(216, 0, 'mod_users_latest', 'module', 'mod_users_latest', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
552(218, 0, 'mod_whosonline', 'module', 'mod_whosonline', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
553(219, 0, 'mod_wrapper', 'module', 'mod_wrapper', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
554(220, 0, 'mod_articles_category', 'module', 'mod_articles_category', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
555(221, 0, 'mod_articles_categories', 'module', 'mod_articles_categories', '', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
556(222, 0, 'mod_languages', 'module', 'mod_languages', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
557(223, 0, 'mod_finder', 'module', 'mod_finder', '', 0, 1, 0, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
558(300, 0, 'mod_custom', 'module', 'mod_custom', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
559(301, 0, 'mod_feed', 'module', 'mod_feed', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
560(302, 0, 'mod_latest', 'module', 'mod_latest', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
561(303, 0, 'mod_logged', 'module', 'mod_logged', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
562(304, 0, 'mod_login', 'module', 'mod_login', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
563(305, 0, 'mod_menu', 'module', 'mod_menu', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
564(307, 0, 'mod_popular', 'module', 'mod_popular', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
565(308, 0, 'mod_quickicon', 'module', 'mod_quickicon', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
566(309, 0, 'mod_status', 'module', 'mod_status', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
567(310, 0, 'mod_submenu', 'module', 'mod_submenu', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
568(311, 0, 'mod_title', 'module', 'mod_title', '', 1, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
569(312, 0, 'mod_toolbar', 'module', 'mod_toolbar', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
570(313, 0, 'mod_multilangstatus', 'module', 'mod_multilangstatus', '', 1, 1, 1, 0, '', '{"cache":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
571(314, 0, 'mod_version', 'module', 'mod_version', '', 1, 1, 1, 0, '', '{"format":"short","product":"1","cache":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
572(315, 0, 'mod_stats_admin', 'module', 'mod_stats_admin', '', 1, 1, 1, 0, '', '{"serverinfo":"0","siteinfo":"0","counter":"0","increase":"0","cache":"1","cache_time":"900","cachemode":"static"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
573(316, 0, 'mod_tags_popular', 'module', 'mod_tags_popular', '', 0, 1, 1, 0, '', '{"maximum":"5","timeframe":"alltime","owncache":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
574(317, 0, 'mod_tags_similar', 'module', 'mod_tags_similar', '', 0, 1, 1, 0, '', '{"maximum":"5","matchtype":"any","owncache":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
575(318, 0, 'mod_sampledata', 'module', 'mod_sampledata', '', 1, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
576(319, 0, 'mod_latestactions', 'module', 'mod_latestactions', '', 1, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
577(320, 0, 'mod_privacy_dashboard', 'module', 'mod_privacy_dashboard', '', 1, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
578(400, 0, 'plg_authentication_gmail', 'plugin', 'gmail', 'authentication', 0, 0, 1, 0, '', '{"applysuffix":"0","suffix":"","verifypeer":"1","user_blacklist":""}', '', '', 0, '0000-00-00 00:00:00', 1, 0),
579(401, 0, 'plg_authentication_joomla', 'plugin', 'joomla', 'authentication', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
580(402, 0, 'plg_authentication_ldap', 'plugin', 'ldap', 'authentication', 0, 0, 1, 0, '', '{"host":"","port":"389","use_ldapV3":"0","negotiate_tls":"0","no_referrals":"0","auth_method":"bind","base_dn":"","search_string":"","users_dn":"","username":"admin","password":"bobby7","ldap_fullname":"fullName","ldap_email":"mail","ldap_uid":"uid"}', '', '', 0, '0000-00-00 00:00:00', 3, 0),
581(403, 0, 'plg_content_contact', 'plugin', 'contact', 'content', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 1, 0),
582(404, 0, 'plg_content_emailcloak', 'plugin', 'emailcloak', 'content', 0, 1, 1, 0, '', '{"mode":"1"}', '', '', 0, '0000-00-00 00:00:00', 1, 0),
583(406, 0, 'plg_content_loadmodule', 'plugin', 'loadmodule', 'content', 0, 1, 1, 0, '', '{"style":"xhtml"}', '', '', 0, '2011-09-18 15:22:50', 0, 0),
584(407, 0, 'plg_content_pagebreak', 'plugin', 'pagebreak', 'content', 0, 1, 1, 0, '', '{"title":"1","multipage_toc":"1","showall":"1"}', '', '', 0, '0000-00-00 00:00:00', 4, 0),
585(408, 0, 'plg_content_pagenavigation', 'plugin', 'pagenavigation', 'content', 0, 1, 1, 0, '', '{"position":"1"}', '', '', 0, '0000-00-00 00:00:00', 5, 0),
586(409, 0, 'plg_content_vote', 'plugin', 'vote', 'content', 0, 0, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 6, 0),
587(410, 0, 'plg_editors_codemirror', 'plugin', 'codemirror', 'editors', 0, 1, 1, 1, '', '{"lineNumbers":"1","lineWrapping":"1","matchTags":"1","matchBrackets":"1","marker-gutter":"1","autoCloseTags":"1","autoCloseBrackets":"1","autoFocus":"1","theme":"default","tabmode":"indent"}', '', '', 0, '0000-00-00 00:00:00', 1, 0),
588(411, 0, 'plg_editors_none', 'plugin', 'none', 'editors', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 2, 0),
589(412, 0, 'plg_editors_tinymce', 'plugin', 'tinymce', 'editors', 0, 1, 1, 0, '', '{"configuration":{"toolbars":{"2":{"toolbar1":["bold","underline","strikethrough","|","undo","redo","|","bullist","numlist","|","pastetext"]},"1":{"menu":["edit","insert","view","format","table","tools"],"toolbar1":["bold","italic","underline","strikethrough","|","alignleft","aligncenter","alignright","alignjustify","|","formatselect","|","bullist","numlist","|","outdent","indent","|","undo","redo","|","link","unlink","anchor","code","|","hr","table","|","subscript","superscript","|","charmap","pastetext","preview"]},"0":{"menu":["edit","insert","view","format","table","tools"],"toolbar1":["bold","italic","underline","strikethrough","|","alignleft","aligncenter","alignright","alignjustify","|","styleselect","|","formatselect","fontselect","fontsizeselect","|","searchreplace","|","bullist","numlist","|","outdent","indent","|","undo","redo","|","link","unlink","anchor","image","|","code","|","forecolor","backcolor","|","fullscreen","|","table","|","subscript","superscript","|","charmap","emoticons","media","hr","ltr","rtl","|","cut","copy","paste","pastetext","|","visualchars","visualblocks","nonbreaking","blockquote","template","|","print","preview","codesample","insertdatetime","removeformat"]}},"setoptions":{"2":{"access":["1"],"skin":"0","skin_admin":"0","mobile":"0","drag_drop":"1","path":"","entity_encoding":"raw","lang_mode":"1","text_direction":"ltr","content_css":"1","content_css_custom":"","relative_urls":"1","newlines":"0","use_config_textfilters":"0","invalid_elements":"script,applet,iframe","valid_elements":"","extended_elements":"","resizing":"1","resize_horizontal":"1","element_path":"1","wordcount":"1","image_advtab":"0","advlist":"1","autosave":"1","contextmenu":"1","custom_plugin":"","custom_button":""},"1":{"access":["6","2"],"skin":"0","skin_admin":"0","mobile":"0","drag_drop":"1","path":"","entity_encoding":"raw","lang_mode":"1","text_direction":"ltr","content_css":"1","content_css_custom":"","relative_urls":"1","newlines":"0","use_config_textfilters":"0","invalid_elements":"script,applet,iframe","valid_elements":"","extended_elements":"","resizing":"1","resize_horizontal":"1","element_path":"1","wordcount":"1","image_advtab":"0","advlist":"1","autosave":"1","contextmenu":"1","custom_plugin":"","custom_button":""},"0":{"access":["7","4","8"],"skin":"0","skin_admin":"0","mobile":"0","drag_drop":"1","path":"","entity_encoding":"raw","lang_mode":"1","text_direction":"ltr","content_css":"1","content_css_custom":"","relative_urls":"1","newlines":"0","use_config_textfilters":"0","invalid_elements":"script,applet,iframe","valid_elements":"","extended_elements":"","resizing":"1","resize_horizontal":"1","element_path":"1","wordcount":"1","image_advtab":"1","advlist":"1","autosave":"1","contextmenu":"1","custom_plugin":"","custom_button":""}}},"sets_amount":3,"html_height":"550","html_width":"750"}', '', '', 0, '0000-00-00 00:00:00', 3, 0),
590(413, 0, 'plg_editors-xtd_article', 'plugin', 'article', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 1, 0),
591(414, 0, 'plg_editors-xtd_image', 'plugin', 'image', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 2, 0),
592(415, 0, 'plg_editors-xtd_pagebreak', 'plugin', 'pagebreak', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 3, 0),
593(416, 0, 'plg_editors-xtd_readmore', 'plugin', 'readmore', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 4, 0),
594(417, 0, 'plg_search_categories', 'plugin', 'categories', 'search', 0, 1, 1, 0, '', '{"search_limit":"50","search_content":"1","search_archived":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
595(418, 0, 'plg_search_contacts', 'plugin', 'contacts', 'search', 0, 1, 1, 0, '', '{"search_limit":"50","search_content":"1","search_archived":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
596(419, 0, 'plg_search_content', 'plugin', 'content', 'search', 0, 1, 1, 0, '', '{"search_limit":"50","search_content":"1","search_archived":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
597(420, 0, 'plg_search_newsfeeds', 'plugin', 'newsfeeds', 'search', 0, 1, 1, 0, '', '{"search_limit":"50","search_content":"1","search_archived":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
598(422, 0, 'plg_system_languagefilter', 'plugin', 'languagefilter', 'system', 0, 0, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 1, 0),
599(423, 0, 'plg_system_p3p', 'plugin', 'p3p', 'system', 0, 0, 1, 0, '', '{"headers":"NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"}', '', '', 0, '0000-00-00 00:00:00', 2, 0),
600(424, 0, 'plg_system_cache', 'plugin', 'cache', 'system', 0, 0, 1, 1, '', '{"browsercache":"0","cachetime":"15"}', '', '', 0, '0000-00-00 00:00:00', 9, 0),
601(425, 0, 'plg_system_debug', 'plugin', 'debug', 'system', 0, 1, 1, 0, '', '{"profile":"1","queries":"1","memory":"1","language_files":"1","language_strings":"1","strip-first":"1","strip-prefix":"","strip-suffix":""}', '', '', 0, '0000-00-00 00:00:00', 4, 0),
602(426, 0, 'plg_system_log', 'plugin', 'log', 'system', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 5, 0),
603(427, 0, 'plg_system_redirect', 'plugin', 'redirect', 'system', 0, 0, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 3, 0),
604(428, 0, 'plg_system_remember', 'plugin', 'remember', 'system', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 7, 0),
605(429, 0, 'plg_system_sef', 'plugin', 'sef', 'system', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 8, 0),
606(430, 0, 'plg_system_logout', 'plugin', 'logout', 'system', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 6, 0),
607(431, 0, 'plg_user_contactcreator', 'plugin', 'contactcreator', 'user', 0, 0, 1, 0, '', '{"autowebpage":"","category":"34","autopublish":"0"}', '', '', 0, '0000-00-00 00:00:00', 1, 0),
608(432, 0, 'plg_user_joomla', 'plugin', 'joomla', 'user', 0, 1, 1, 0, '', '{"autoregister":"1","mail_to_user":"1","forceLogout":"1"}', '', '', 0, '0000-00-00 00:00:00', 2, 0),
609(433, 0, 'plg_user_profile', 'plugin', 'profile', 'user', 0, 0, 1, 0, '', '{"register-require_address1":"1","register-require_address2":"1","register-require_city":"1","register-require_region":"1","register-require_country":"1","register-require_postal_code":"1","register-require_phone":"1","register-require_website":"1","register-require_favoritebook":"1","register-require_aboutme":"1","register-require_tos":"1","register-require_dob":"1","profile-require_address1":"1","profile-require_address2":"1","profile-require_city":"1","profile-require_region":"1","profile-require_country":"1","profile-require_postal_code":"1","profile-require_phone":"1","profile-require_website":"1","profile-require_favoritebook":"1","profile-require_aboutme":"1","profile-require_tos":"1","profile-require_dob":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
610(434, 0, 'plg_extension_joomla', 'plugin', 'joomla', 'extension', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 1, 0),
611(435, 0, 'plg_content_joomla', 'plugin', 'joomla', 'content', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
612(436, 0, 'plg_system_languagecode', 'plugin', 'languagecode', 'system', 0, 0, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 10, 0),
613(437, 0, 'plg_quickicon_joomlaupdate', 'plugin', 'joomlaupdate', 'quickicon', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
614(438, 0, 'plg_quickicon_extensionupdate', 'plugin', 'extensionupdate', 'quickicon', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
615(439, 0, 'plg_captcha_recaptcha', 'plugin', 'recaptcha', 'captcha', 0, 0, 1, 0, '', '{"public_key":"","private_key":"","theme":"clean"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
616(440, 0, 'plg_system_highlight', 'plugin', 'highlight', 'system', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 7, 0),
617(441, 0, 'plg_content_finder', 'plugin', 'finder', 'content', 0, 0, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
618(442, 0, 'plg_finder_categories', 'plugin', 'categories', 'finder', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 1, 0),
619(443, 0, 'plg_finder_contacts', 'plugin', 'contacts', 'finder', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 2, 0),
620(444, 0, 'plg_finder_content', 'plugin', 'content', 'finder', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 3, 0),
621(445, 0, 'plg_finder_newsfeeds', 'plugin', 'newsfeeds', 'finder', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 4, 0),
622(447, 0, 'plg_finder_tags', 'plugin', 'tags', 'finder', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
623(448, 0, 'plg_twofactorauth_totp', 'plugin', 'totp', 'twofactorauth', 0, 0, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
624(449, 0, 'plg_authentication_cookie', 'plugin', 'cookie', 'authentication', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
625(450, 0, 'plg_twofactorauth_yubikey', 'plugin', 'yubikey', 'twofactorauth', 0, 0, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
626(451, 0, 'plg_search_tags', 'plugin', 'tags', 'search', 0, 1, 1, 0, '', '{"search_limit":"50","show_tagged_items":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
627(452, 0, 'plg_system_updatenotification', 'plugin', 'updatenotification', 'system', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
628(453, 0, 'plg_editors-xtd_module', 'plugin', 'module', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
629(454, 0, 'plg_system_stats', 'plugin', 'stats', 'system', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
630(455, 0, 'plg_installer_packageinstaller', 'plugin', 'packageinstaller', 'installer', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 1, 0),
631(456, 0, 'plg_installer_folderinstaller', 'plugin', 'folderinstaller', 'installer', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 2, 0),
632(457, 0, 'plg_installer_urlinstaller', 'plugin', 'urlinstaller', 'installer', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 3, 0),
633(458, 0, 'plg_quickicon_phpversioncheck', 'plugin', 'phpversioncheck', 'quickicon', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
634(459, 0, 'plg_editors-xtd_menu', 'plugin', 'menu', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
635(460, 0, 'plg_editors-xtd_contact', 'plugin', 'contact', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
636(461, 0, 'plg_system_fields', 'plugin', 'fields', 'system', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
637(462, 0, 'plg_fields_calendar', 'plugin', 'calendar', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
638(463, 0, 'plg_fields_checkboxes', 'plugin', 'checkboxes', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
639(464, 0, 'plg_fields_color', 'plugin', 'color', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
640(465, 0, 'plg_fields_editor', 'plugin', 'editor', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
641(466, 0, 'plg_fields_imagelist', 'plugin', 'imagelist', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
642(467, 0, 'plg_fields_integer', 'plugin', 'integer', 'fields', 0, 1, 1, 0, '', '{"multiple":"0","first":"1","last":"100","step":"1"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
643(468, 0, 'plg_fields_list', 'plugin', 'list', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
644(469, 0, 'plg_fields_media', 'plugin', 'media', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
645(470, 0, 'plg_fields_radio', 'plugin', 'radio', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
646(471, 0, 'plg_fields_sql', 'plugin', 'sql', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
647(472, 0, 'plg_fields_text', 'plugin', 'text', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
648(473, 0, 'plg_fields_textarea', 'plugin', 'textarea', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
649(474, 0, 'plg_fields_url', 'plugin', 'url', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
650(475, 0, 'plg_fields_user', 'plugin', 'user', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
651(476, 0, 'plg_fields_usergrouplist', 'plugin', 'usergrouplist', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
652(477, 0, 'plg_content_fields', 'plugin', 'fields', 'content', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
653(478, 0, 'plg_editors-xtd_fields', 'plugin', 'fields', 'editors-xtd', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
654(479, 0, 'plg_sampledata_blog', 'plugin', 'blog', 'sampledata', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
655(480, 0, 'plg_system_sessiongc', 'plugin', 'sessiongc', 'system', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
656(481, 0, 'plg_fields_repeatable', 'plugin', 'repeatable', 'fields', 0, 1, 1, 0, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
657(482, 0, 'plg_content_confirmconsent', 'plugin', 'confirmconsent', 'content', 0, 0, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
658(483, 0, 'plg_system_actionlogs', 'plugin', 'actionlogs', 'system', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
659(484, 0, 'plg_actionlog_joomla', 'plugin', 'joomla', 'actionlog', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
660(485, 0, 'plg_system_privacyconsent', 'plugin', 'privacyconsent', 'system', 0, 0, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
661(486, 0, 'plg_system_logrotation', 'plugin', 'logrotation', 'system', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
662(487, 0, 'plg_privacy_user', 'plugin', 'user', 'privacy', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
663(488, 0, 'plg_quickicon_privacycheck', 'plugin', 'privacycheck', 'quickicon', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
664(489, 0, 'plg_user_terms', 'plugin', 'terms', 'user', 0, 0, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
665(490, 0, 'plg_privacy_contact', 'plugin', 'contact', 'privacy', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
666(491, 0, 'plg_privacy_content', 'plugin', 'content', 'privacy', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
667(492, 0, 'plg_privacy_message', 'plugin', 'message', 'privacy', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
668(493, 0, 'plg_privacy_actionlogs', 'plugin', 'actionlogs', 'privacy', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
669(494, 0, 'plg_captcha_recaptcha_invisible', 'plugin', 'recaptcha_invisible', 'captcha', 0, 0, 1, 0, '', '{"public_key":"","private_key":"","theme":"clean"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
670(495, 0, 'plg_privacy_consents', 'plugin', 'consents', 'privacy', 0, 1, 1, 0, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
671(503, 0, 'beez3', 'template', 'beez3', '', 0, 1, 1, 0, '', '{"wrapperSmall":"53","wrapperLarge":"72","sitetitle":"","sitedescription":"","navposition":"center","templatecolor":"nature"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
672(504, 0, 'hathor', 'template', 'hathor', '', 1, 1, 1, 0, '', '{"showSiteName":"0","colourChoice":"0","boldText":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
673(506, 0, 'protostar', 'template', 'protostar', '', 0, 1, 1, 0, '', '{"templateColor":"","logoFile":"","googleFont":"1","googleFontName":"Open+Sans","fluidContainer":"0"}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
674(507, 0, 'isis', 'template', 'isis', '', 1, 1, 1, 0, '', '{"templateColor":"","logoFile":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0),
675(600, 802, 'English (en-GB)', 'language', 'en-GB', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
676(601, 802, 'English (en-GB)', 'language', 'en-GB', '', 1, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
677(700, 0, 'files_joomla', 'file', 'joomla', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0),
678(802, 0, 'English (en-GB) Language Pack', 'package', 'pkg_en-GB', '', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);
679
680-- --------------------------------------------------------
681
682--
683-- Table structure for table `#__fields`
684--
685
686CREATE TABLE IF NOT EXISTS `#__fields` (
687  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
688  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
689  `context` varchar(255) NOT NULL DEFAULT '',
690  `group_id` int(10) unsigned NOT NULL DEFAULT 0,
691  `title` varchar(255) NOT NULL DEFAULT '',
692  `name` varchar(255) NOT NULL DEFAULT '',
693  `label` varchar(255) NOT NULL DEFAULT '',
694  `default_value` text NOT NULL DEFAULT '',
695  `type` varchar(255) NOT NULL DEFAULT 'text',
696  `note` varchar(255) NOT NULL DEFAULT '',
697  `description` text NOT NULL,
698  `state` tinyint(1) NOT NULL DEFAULT '0',
699  `required` tinyint(1) NOT NULL DEFAULT '0',
700  `checked_out` int(11) NOT NULL DEFAULT '0',
701  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
702  `ordering` int(11) NOT NULL DEFAULT '0',
703  `params` text NOT NULL,
704  `fieldparams` text NOT NULL,
705  `language` char(7) NOT NULL DEFAULT '',
706  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
707  `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
708  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
709  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
710  `access` int(11) NOT NULL DEFAULT '1',
711  PRIMARY KEY (`id`),
712  KEY `idx_checkout` (`checked_out`),
713  KEY `idx_state` (`state`),
714  KEY `idx_created_user_id` (`created_user_id`),
715  KEY `idx_access` (`access`),
716  KEY `idx_context` (`context`(191)),
717  KEY `idx_language` (`language`)
718) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
719
720-- --------------------------------------------------------
721
722--
723-- Table structure for table `#__fields_categories`
724--
725
726CREATE TABLE IF NOT EXISTS `#__fields_categories` (
727  `field_id` int(11) NOT NULL DEFAULT 0,
728  `category_id` int(11) NOT NULL DEFAULT 0,
729  PRIMARY KEY (`field_id`,`category_id`)
730) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
731
732-- --------------------------------------------------------
733
734--
735-- Table structure for table `#__fields_groups`
736--
737
738CREATE TABLE IF NOT EXISTS `#__fields_groups` (
739  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
740  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
741  `context` varchar(255) NOT NULL DEFAULT '',
742  `title` varchar(255) NOT NULL DEFAULT '',
743  `note` varchar(255) NOT NULL DEFAULT '',
744  `description` text NOT NULL,
745  `state` tinyint(1) NOT NULL DEFAULT '0',
746  `checked_out` int(11) NOT NULL DEFAULT '0',
747  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
748  `ordering` int(11) NOT NULL DEFAULT '0',
749  `params` text NOT NULL,
750  `language` char(7) NOT NULL DEFAULT '',
751  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
752  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
753  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
754  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
755  `access` int(11) NOT NULL DEFAULT '1',
756  PRIMARY KEY (`id`),
757  KEY `idx_checkout` (`checked_out`),
758  KEY `idx_state` (`state`),
759  KEY `idx_created_by` (`created_by`),
760  KEY `idx_access` (`access`),
761  KEY `idx_context` (`context`(191)),
762  KEY `idx_language` (`language`)
763) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
764
765-- --------------------------------------------------------
766
767--
768-- Table structure for table `#__fields_values`
769--
770
771CREATE TABLE IF NOT EXISTS `#__fields_values` (
772  `field_id` int(10) unsigned NOT NULL,
773  `item_id` varchar(255) NOT NULL COMMENT 'Allow references to items which have strings as ids, eg. none db systems.',
774  `value` text NOT NULL DEFAULT '',
775  KEY `idx_field_id` (`field_id`),
776  KEY `idx_item_id` (`item_id`(191))
777) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
778
779-- --------------------------------------------------------
780
781--
782-- Table structure for table `#__finder_filters`
783--
784
785CREATE TABLE IF NOT EXISTS `#__finder_filters` (
786  `filter_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
787  `title` varchar(255) NOT NULL,
788  `alias` varchar(255) NOT NULL,
789  `state` tinyint(1) NOT NULL DEFAULT 1,
790  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
791  `created_by` int(10) unsigned NOT NULL,
792  `created_by_alias` varchar(255) NOT NULL,
793  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
794  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
795  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
796  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
797  `map_count` int(10) unsigned NOT NULL DEFAULT 0,
798  `data` text NOT NULL,
799  `params` mediumtext,
800  PRIMARY KEY (`filter_id`)
801) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
802
803-- --------------------------------------------------------
804
805--
806-- Table structure for table `#__finder_links`
807--
808
809CREATE TABLE IF NOT EXISTS `#__finder_links` (
810  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
811  `url` varchar(255) NOT NULL,
812  `route` varchar(255) NOT NULL,
813  `title` varchar(400) DEFAULT NULL,
814  `description` text DEFAULT NULL,
815  `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
816  `md5sum` varchar(32) DEFAULT NULL,
817  `published` tinyint(1) NOT NULL DEFAULT 1,
818  `state` int(5) DEFAULT 1,
819  `access` int(5) DEFAULT 0,
820  `language` varchar(8) NOT NULL,
821  `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
822  `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
823  `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
824  `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
825  `list_price` double unsigned NOT NULL DEFAULT 0,
826  `sale_price` double unsigned NOT NULL DEFAULT 0,
827  `type_id` int(11) NOT NULL,
828  `object` mediumblob NOT NULL,
829  PRIMARY KEY (`link_id`),
830  KEY `idx_type` (`type_id`),
831  KEY `idx_title` (`title`(100)),
832  KEY `idx_md5` (`md5sum`),
833  KEY `idx_url` (`url`(75)),
834  KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
835  KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
836) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
837
838-- --------------------------------------------------------
839
840--
841-- Table structure for table `#__finder_links_terms0`
842--
843
844CREATE TABLE IF NOT EXISTS `#__finder_links_terms0` (
845  `link_id` int(10) unsigned NOT NULL,
846  `term_id` int(10) unsigned NOT NULL,
847  `weight` float unsigned NOT NULL,
848  PRIMARY KEY (`link_id`,`term_id`),
849  KEY `idx_term_weight` (`term_id`,`weight`),
850  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
851) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
852
853-- --------------------------------------------------------
854
855--
856-- Table structure for table `#__finder_links_terms1`
857--
858
859CREATE TABLE IF NOT EXISTS `#__finder_links_terms1` (
860  `link_id` int(10) unsigned NOT NULL,
861  `term_id` int(10) unsigned NOT NULL,
862  `weight` float unsigned NOT NULL,
863  PRIMARY KEY (`link_id`,`term_id`),
864  KEY `idx_term_weight` (`term_id`,`weight`),
865  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
866) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
867
868-- --------------------------------------------------------
869
870--
871-- Table structure for table `#__finder_links_terms2`
872--
873
874CREATE TABLE IF NOT EXISTS `#__finder_links_terms2` (
875  `link_id` int(10) unsigned NOT NULL,
876  `term_id` int(10) unsigned NOT NULL,
877  `weight` float unsigned NOT NULL,
878  PRIMARY KEY (`link_id`,`term_id`),
879  KEY `idx_term_weight` (`term_id`,`weight`),
880  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
881) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
882
883-- --------------------------------------------------------
884
885--
886-- Table structure for table `#__finder_links_terms3`
887--
888
889CREATE TABLE IF NOT EXISTS `#__finder_links_terms3` (
890  `link_id` int(10) unsigned NOT NULL,
891  `term_id` int(10) unsigned NOT NULL,
892  `weight` float unsigned NOT NULL,
893  PRIMARY KEY (`link_id`,`term_id`),
894  KEY `idx_term_weight` (`term_id`,`weight`),
895  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
896) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
897
898-- --------------------------------------------------------
899
900--
901-- Table structure for table `#__finder_links_terms4`
902--
903
904CREATE TABLE IF NOT EXISTS `#__finder_links_terms4` (
905  `link_id` int(10) unsigned NOT NULL,
906  `term_id` int(10) unsigned NOT NULL,
907  `weight` float unsigned NOT NULL,
908  PRIMARY KEY (`link_id`,`term_id`),
909  KEY `idx_term_weight` (`term_id`,`weight`),
910  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
911) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
912
913-- --------------------------------------------------------
914
915--
916-- Table structure for table `#__finder_links_terms5`
917--
918
919CREATE TABLE IF NOT EXISTS `#__finder_links_terms5` (
920  `link_id` int(10) unsigned NOT NULL,
921  `term_id` int(10) unsigned NOT NULL,
922  `weight` float unsigned NOT NULL,
923  PRIMARY KEY (`link_id`,`term_id`),
924  KEY `idx_term_weight` (`term_id`,`weight`),
925  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
926) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
927
928-- --------------------------------------------------------
929
930--
931-- Table structure for table `#__finder_links_terms6`
932--
933
934CREATE TABLE IF NOT EXISTS `#__finder_links_terms6` (
935  `link_id` int(10) unsigned NOT NULL,
936  `term_id` int(10) unsigned NOT NULL,
937  `weight` float unsigned NOT NULL,
938  PRIMARY KEY (`link_id`,`term_id`),
939  KEY `idx_term_weight` (`term_id`,`weight`),
940  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
941) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
942
943-- --------------------------------------------------------
944
945--
946-- Table structure for table `#__finder_links_terms7`
947--
948
949CREATE TABLE IF NOT EXISTS `#__finder_links_terms7` (
950  `link_id` int(10) unsigned NOT NULL,
951  `term_id` int(10) unsigned NOT NULL,
952  `weight` float unsigned NOT NULL,
953  PRIMARY KEY (`link_id`,`term_id`),
954  KEY `idx_term_weight` (`term_id`,`weight`),
955  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
956) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
957
958-- --------------------------------------------------------
959
960--
961-- Table structure for table `#__finder_links_terms8`
962--
963
964CREATE TABLE IF NOT EXISTS `#__finder_links_terms8` (
965  `link_id` int(10) unsigned NOT NULL,
966  `term_id` int(10) unsigned NOT NULL,
967  `weight` float unsigned NOT NULL,
968  PRIMARY KEY (`link_id`,`term_id`),
969  KEY `idx_term_weight` (`term_id`,`weight`),
970  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
971) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
972
973-- --------------------------------------------------------
974
975--
976-- Table structure for table `#__finder_links_terms9`
977--
978
979CREATE TABLE IF NOT EXISTS `#__finder_links_terms9` (
980  `link_id` int(10) unsigned NOT NULL,
981  `term_id` int(10) unsigned NOT NULL,
982  `weight` float unsigned NOT NULL,
983  PRIMARY KEY (`link_id`,`term_id`),
984  KEY `idx_term_weight` (`term_id`,`weight`),
985  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
986) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
987
988-- --------------------------------------------------------
989
990--
991-- Table structure for table `#__finder_links_termsa`
992--
993
994CREATE TABLE IF NOT EXISTS `#__finder_links_termsa` (
995  `link_id` int(10) unsigned NOT NULL,
996  `term_id` int(10) unsigned NOT NULL,
997  `weight` float unsigned NOT NULL,
998  PRIMARY KEY (`link_id`,`term_id`),
999  KEY `idx_term_weight` (`term_id`,`weight`),
1000  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
1001) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1002
1003-- --------------------------------------------------------
1004
1005--
1006-- Table structure for table `#__finder_links_termsb`
1007--
1008
1009CREATE TABLE IF NOT EXISTS `#__finder_links_termsb` (
1010  `link_id` int(10) unsigned NOT NULL,
1011  `term_id` int(10) unsigned NOT NULL,
1012  `weight` float unsigned NOT NULL,
1013  PRIMARY KEY (`link_id`,`term_id`),
1014  KEY `idx_term_weight` (`term_id`,`weight`),
1015  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
1016) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1017
1018-- --------------------------------------------------------
1019
1020--
1021-- Table structure for table `#__finder_links_termsc`
1022--
1023
1024CREATE TABLE IF NOT EXISTS `#__finder_links_termsc` (
1025  `link_id` int(10) unsigned NOT NULL,
1026  `term_id` int(10) unsigned NOT NULL,
1027  `weight` float unsigned NOT NULL,
1028  PRIMARY KEY (`link_id`,`term_id`),
1029  KEY `idx_term_weight` (`term_id`,`weight`),
1030  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
1031) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1032
1033-- --------------------------------------------------------
1034
1035--
1036-- Table structure for table `#__finder_links_termsd`
1037--
1038
1039CREATE TABLE IF NOT EXISTS `#__finder_links_termsd` (
1040  `link_id` int(10) unsigned NOT NULL,
1041  `term_id` int(10) unsigned NOT NULL,
1042  `weight` float unsigned NOT NULL,
1043  PRIMARY KEY (`link_id`,`term_id`),
1044  KEY `idx_term_weight` (`term_id`,`weight`),
1045  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
1046) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1047
1048-- --------------------------------------------------------
1049
1050--
1051-- Table structure for table `#__finder_links_termse`
1052--
1053
1054CREATE TABLE IF NOT EXISTS `#__finder_links_termse` (
1055  `link_id` int(10) unsigned NOT NULL,
1056  `term_id` int(10) unsigned NOT NULL,
1057  `weight` float unsigned NOT NULL,
1058  PRIMARY KEY (`link_id`,`term_id`),
1059  KEY `idx_term_weight` (`term_id`,`weight`),
1060  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
1061) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1062
1063-- --------------------------------------------------------
1064
1065--
1066-- Table structure for table `#__finder_links_termsf`
1067--
1068
1069CREATE TABLE IF NOT EXISTS `#__finder_links_termsf` (
1070  `link_id` int(10) unsigned NOT NULL,
1071  `term_id` int(10) unsigned NOT NULL,
1072  `weight` float unsigned NOT NULL,
1073  PRIMARY KEY (`link_id`,`term_id`),
1074  KEY `idx_term_weight` (`term_id`,`weight`),
1075  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
1076) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1077
1078-- --------------------------------------------------------
1079
1080--
1081-- Table structure for table `#__finder_taxonomy`
1082--
1083
1084CREATE TABLE IF NOT EXISTS `#__finder_taxonomy` (
1085  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1086  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
1087  `title` varchar(255) NOT NULL,
1088  `state` tinyint(1) unsigned NOT NULL DEFAULT 1,
1089  `access` tinyint(1) unsigned NOT NULL DEFAULT 0,
1090  `ordering` tinyint(1) unsigned NOT NULL DEFAULT 0,
1091  PRIMARY KEY (`id`),
1092  KEY `parent_id` (`parent_id`),
1093  KEY `state` (`state`),
1094  KEY `ordering` (`ordering`),
1095  KEY `access` (`access`),
1096  KEY `idx_parent_published` (`parent_id`,`state`,`access`)
1097) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1098
1099--
1100-- Dumping data for table `#__finder_taxonomy`
1101--
1102
1103INSERT INTO `#__finder_taxonomy` (`id`, `parent_id`, `title`, `state`, `access`, `ordering`) VALUES
1104(1, 0, 'ROOT', 0, 0, 0);
1105
1106-- --------------------------------------------------------
1107
1108--
1109-- Table structure for table `#__finder_taxonomy_map`
1110--
1111
1112CREATE TABLE IF NOT EXISTS `#__finder_taxonomy_map` (
1113  `link_id` int(10) unsigned NOT NULL,
1114  `node_id` int(10) unsigned NOT NULL,
1115  PRIMARY KEY (`link_id`,`node_id`),
1116  KEY `link_id` (`link_id`),
1117  KEY `node_id` (`node_id`)
1118) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1119
1120-- --------------------------------------------------------
1121
1122--
1123-- Table structure for table `#__finder_terms`
1124--
1125
1126CREATE TABLE IF NOT EXISTS `#__finder_terms` (
1127  `term_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1128  `term` varchar(75) NOT NULL,
1129  `stem` varchar(75) NOT NULL,
1130  `common` tinyint(1) unsigned NOT NULL DEFAULT 0,
1131  `phrase` tinyint(1) unsigned NOT NULL DEFAULT 0,
1132  `weight` float unsigned NOT NULL DEFAULT 0,
1133  `soundex` varchar(75) NOT NULL,
1134  `links` int(10) NOT NULL DEFAULT 0,
1135  `language` char(3) NOT NULL DEFAULT '',
1136  PRIMARY KEY (`term_id`),
1137  UNIQUE KEY `idx_term` (`term`),
1138  KEY `idx_term_phrase` (`term`,`phrase`),
1139  KEY `idx_stem_phrase` (`stem`,`phrase`),
1140  KEY `idx_soundex_phrase` (`soundex`,`phrase`)
1141) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1142
1143-- --------------------------------------------------------
1144
1145--
1146-- Table structure for table `#__finder_terms_common`
1147--
1148
1149CREATE TABLE IF NOT EXISTS `#__finder_terms_common` (
1150  `term` varchar(75) NOT NULL,
1151  `language` varchar(3) NOT NULL,
1152  KEY `idx_word_lang` (`term`,`language`),
1153  KEY `idx_lang` (`language`)
1154) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1155
1156--
1157-- Dumping data for table `#__finder_terms_common`
1158--
1159
1160INSERT INTO `#__finder_terms_common` (`term`, `language`) VALUES
1161('a', 'en'),
1162('about', 'en'),
1163('after', 'en'),
1164('ago', 'en'),
1165('all', 'en'),
1166('am', 'en'),
1167('an', 'en'),
1168('and', 'en'),
1169('any', 'en'),
1170('are', 'en'),
1171('aren''t', 'en'),
1172('as', 'en'),
1173('at', 'en'),
1174('be', 'en'),
1175('but', 'en'),
1176('by', 'en'),
1177('for', 'en'),
1178('from', 'en'),
1179('get', 'en'),
1180('go', 'en'),
1181('how', 'en'),
1182('if', 'en'),
1183('in', 'en'),
1184('into', 'en'),
1185('is', 'en'),
1186('isn''t', 'en'),
1187('it', 'en'),
1188('its', 'en'),
1189('me', 'en'),
1190('more', 'en'),
1191('most', 'en'),
1192('must', 'en'),
1193('my', 'en'),
1194('new', 'en'),
1195('no', 'en'),
1196('none', 'en'),
1197('not', 'en'),
1198('nothing', 'en'),
1199('of', 'en'),
1200('off', 'en'),
1201('often', 'en'),
1202('old', 'en'),
1203('on', 'en'),
1204('onc', 'en'),
1205('once', 'en'),
1206('only', 'en'),
1207('or', 'en'),
1208('other', 'en'),
1209('our', 'en'),
1210('ours', 'en'),
1211('out', 'en'),
1212('over', 'en'),
1213('page', 'en'),
1214('she', 'en'),
1215('should', 'en'),
1216('small', 'en'),
1217('so', 'en'),
1218('some', 'en'),
1219('than', 'en'),
1220('thank', 'en'),
1221('that', 'en'),
1222('the', 'en'),
1223('their', 'en'),
1224('theirs', 'en'),
1225('them', 'en'),
1226('then', 'en'),
1227('there', 'en'),
1228('these', 'en'),
1229('they', 'en'),
1230('this', 'en'),
1231('those', 'en'),
1232('thus', 'en'),
1233('time', 'en'),
1234('times', 'en'),
1235('to', 'en'),
1236('too', 'en'),
1237('true', 'en'),
1238('under', 'en'),
1239('until', 'en'),
1240('up', 'en'),
1241('upon', 'en'),
1242('use', 'en'),
1243('user', 'en'),
1244('users', 'en'),
1245('version', 'en'),
1246('very', 'en'),
1247('via', 'en'),
1248('want', 'en'),
1249('was', 'en'),
1250('way', 'en'),
1251('were', 'en'),
1252('what', 'en'),
1253('when', 'en'),
1254('where', 'en'),
1255('which', 'en'),
1256('who', 'en'),
1257('whom', 'en'),
1258('whose', 'en'),
1259('why', 'en'),
1260('wide', 'en'),
1261('will', 'en'),
1262('with', 'en'),
1263('within', 'en'),
1264('without', 'en'),
1265('would', 'en'),
1266('yes', 'en'),
1267('yet', 'en'),
1268('you', 'en'),
1269('your', 'en'),
1270('yours', 'en');
1271
1272-- --------------------------------------------------------
1273
1274--
1275-- Table structure for table `#__finder_tokens`
1276--
1277
1278CREATE TABLE IF NOT EXISTS `#__finder_tokens` (
1279  `term` varchar(75) NOT NULL,
1280  `stem` varchar(75) NOT NULL,
1281  `common` tinyint(1) unsigned NOT NULL DEFAULT 0,
1282  `phrase` tinyint(1) unsigned NOT NULL DEFAULT 0,
1283  `weight` float unsigned NOT NULL DEFAULT 1,
1284  `context` tinyint(1) unsigned NOT NULL DEFAULT 2,
1285  `language` char(3) NOT NULL DEFAULT '',
1286  KEY `idx_word` (`term`),
1287  KEY `idx_context` (`context`)
1288) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1289
1290-- --------------------------------------------------------
1291
1292--
1293-- Table structure for table `#__finder_tokens_aggregate`
1294--
1295
1296CREATE TABLE IF NOT EXISTS `#__finder_tokens_aggregate` (
1297  `term_id` int(10) unsigned NOT NULL,
1298  `map_suffix` char(1) NOT NULL,
1299  `term` varchar(75) NOT NULL,
1300  `stem` varchar(75) NOT NULL,
1301  `common` tinyint(1) unsigned NOT NULL DEFAULT 0,
1302  `phrase` tinyint(1) unsigned NOT NULL DEFAULT 0,
1303  `term_weight` float unsigned NOT NULL,
1304  `context` tinyint(1) unsigned NOT NULL DEFAULT 2,
1305  `context_weight` float unsigned NOT NULL,
1306  `total_weight` float unsigned NOT NULL,
1307  `language` char(3) NOT NULL DEFAULT '',
1308  KEY `token` (`term`),
1309  KEY `keyword_id` (`term_id`)
1310) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1311
1312-- --------------------------------------------------------
1313
1314--
1315-- Table structure for table `#__finder_types`
1316--
1317
1318CREATE TABLE IF NOT EXISTS `#__finder_types` (
1319  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1320  `title` varchar(100) NOT NULL,
1321  `mime` varchar(100) NOT NULL,
1322  PRIMARY KEY (`id`),
1323  UNIQUE KEY `title` (`title`)
1324) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
1325
1326-- --------------------------------------------------------
1327
1328--
1329-- Table structure for table `#__languages`
1330--
1331
1332CREATE TABLE IF NOT EXISTS `#__languages` (
1333  `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1334  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
1335  `lang_code` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
1336  `title` varchar(50) NOT NULL,
1337  `title_native` varchar(50) NOT NULL,
1338  `sef` varchar(50) NOT NULL,
1339  `image` varchar(50) NOT NULL,
1340  `description` varchar(512) NOT NULL,
1341  `metakey` text NOT NULL,
1342  `metadesc` text NOT NULL,
1343  `sitename` varchar(1024) NOT NULL DEFAULT '',
1344  `published` int(11) NOT NULL DEFAULT 0,
1345  `access` int(10) unsigned NOT NULL DEFAULT 0,
1346  `ordering` int(11) NOT NULL DEFAULT 0,
1347  PRIMARY KEY (`lang_id`),
1348  UNIQUE KEY `idx_sef` (`sef`),
1349  UNIQUE KEY `idx_langcode` (`lang_code`),
1350  KEY `idx_access` (`access`),
1351  KEY `idx_ordering` (`ordering`)
1352) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1353
1354--
1355-- Dumping data for table `#__languages`
1356--
1357
1358INSERT INTO `#__languages` (`lang_id`, `lang_code`, `title`, `title_native`, `sef`, `image`, `description`, `metakey`, `metadesc`, `sitename`, `published`, `access`, `ordering`) VALUES
1359(1, 'en-GB', 'English (en-GB)', 'English (United Kingdom)', 'en', 'en_gb', '', '', '', '', 1, 1, 1);
1360
1361-- --------------------------------------------------------
1362
1363--
1364-- Table structure for table `#__menu`
1365--
1366
1367CREATE TABLE IF NOT EXISTS `#__menu` (
1368  `id` int(11) NOT NULL AUTO_INCREMENT,
1369  `menutype` varchar(24) NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype',
1370  `title` varchar(255) NOT NULL COMMENT 'The display title of the menu item.',
1371  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'The SEF alias of the menu item.',
1372  `note` varchar(255) NOT NULL DEFAULT '',
1373  `path` varchar(1024) NOT NULL COMMENT 'The computed path of the menu item based on the alias field.',
1374  `link` varchar(1024) NOT NULL COMMENT 'The actually link the menu item refers to.',
1375  `type` varchar(16) NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator',
1376  `published` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'The published state of the menu link.',
1377  `parent_id` int(10) unsigned NOT NULL DEFAULT 1 COMMENT 'The parent menu item in the menu tree.',
1378  `level` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The relative level in the tree.',
1379  `component_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to #__extensions.id',
1380  `checked_out` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to #__users.id',
1381  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.',
1382  `browserNav` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'The click behaviour of the link.',
1383  `access` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The access level required to view the menu item.',
1384  `img` varchar(255) NOT NULL COMMENT 'The image of the menu item.',
1385  `template_style_id` int(10) unsigned NOT NULL DEFAULT 0,
1386  `params` text NOT NULL COMMENT 'JSON encoded data for the menu item.',
1387  `lft` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
1388  `rgt` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
1389  `home` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Indicates if this menu item is the home or default page.',
1390  `language` char(7) NOT NULL DEFAULT '',
1391  `client_id` tinyint(4) NOT NULL DEFAULT 0,
1392  PRIMARY KEY (`id`),
1393  UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`(100),`language`),
1394  KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`),
1395  KEY `idx_menutype` (`menutype`),
1396  KEY `idx_left_right` (`lft`,`rgt`),
1397  KEY `idx_alias` (`alias`(100)),
1398  KEY `idx_path` (`path`(100)),
1399  KEY `idx_language` (`language`)
1400) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=102;
1401
1402--
1403-- Dumping data for table `#__menu`
1404--
1405
1406INSERT INTO `#__menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES
1407(1, '', 'Menu_Item_Root', 'root', '', '', '', '', 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, '', 0, '', 0, 43, 0, '*', 0),
1408(2, 'main', 'com_banners', 'Banners', '', 'Banners', 'index.php?option=com_banners', 'component', 1, 1, 1, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 1, 10, 0, '*', 1),
1409(3, 'main', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners', 'component', 1, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 2, 3, 0, '*', 1),
1410(4, 'main', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&extension=com_banners', 'component', 1, 2, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-cat', 0, '', 4, 5, 0, '*', 1),
1411(5, 'main', 'com_banners_clients', 'Clients', '', 'Banners/Clients', 'index.php?option=com_banners&view=clients', 'component', 1, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-clients', 0, '', 6, 7, 0, '*', 1),
1412(6, 'main', 'com_banners_tracks', 'Tracks', '', 'Banners/Tracks', 'index.php?option=com_banners&view=tracks', 'component', 1, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-tracks', 0, '', 8, 9, 0, '*', 1),
1413(7, 'main', 'com_contact', 'Contacts', '', 'Contacts', 'index.php?option=com_contact', 'component', 1, 1, 1, 8, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 11, 16, 0, '*', 1),
1414(8, 'main', 'com_contact_contacts', 'Contacts', '', 'Contacts/Contacts', 'index.php?option=com_contact', 'component', 1, 7, 2, 8, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 12, 13, 0, '*', 1),
1415(9, 'main', 'com_contact_categories', 'Categories', '', 'Contacts/Categories', 'index.php?option=com_categories&extension=com_contact', 'component', 1, 7, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact-cat', 0, '', 14, 15, 0, '*', 1),
1416(10, 'main', 'com_messages', 'Messaging', '', 'Messaging', 'index.php?option=com_messages', 'component', 1, 1, 1, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages', 0, '', 17, 20, 0, '*', 1),
1417(11, 'main', 'com_messages_add', 'New Private Message', '', 'Messaging/New Private Message', 'index.php?option=com_messages&task=message.add', 'component', 1, 10, 2, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-add', 0, '', 18, 19, 0, '*', 1),
1418(13, 'main', 'com_newsfeeds', 'News Feeds', '', 'News Feeds', 'index.php?option=com_newsfeeds', 'component', 1, 1, 1, 17, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 21, 26, 0, '*', 1),
1419(14, 'main', 'com_newsfeeds_feeds', 'Feeds', '', 'News Feeds/Feeds', 'index.php?option=com_newsfeeds', 'component', 1, 13, 2, 17, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 22, 23, 0, '*', 1),
1420(15, 'main', 'com_newsfeeds_categories', 'Categories', '', 'News Feeds/Categories', 'index.php?option=com_categories&extension=com_newsfeeds', 'component', 1, 13, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds-cat', 0, '', 24, 25, 0, '*', 1),
1421(16, 'main', 'com_redirect', 'Redirect', '', 'Redirect', 'index.php?option=com_redirect', 'component', 1, 1, 1, 24, 0, '0000-00-00 00:00:00', 0, 0, 'class:redirect', 0, '', 27, 28, 0, '*', 1),
1422(17, 'main', 'com_search', 'Basic Search', '', 'Basic Search', 'index.php?option=com_search', 'component', 1, 1, 1, 19, 0, '0000-00-00 00:00:00', 0, 0, 'class:search', 0, '', 29, 30, 0, '*', 1),
1423(18, 'main', 'com_finder', 'Smart Search', '', 'Smart Search', 'index.php?option=com_finder', 'component', 1, 1, 1, 27, 0, '0000-00-00 00:00:00', 0, 0, 'class:finder', 0, '', 31, 32, 0, '*', 1),
1424(19, 'main', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update', 'index.php?option=com_joomlaupdate', 'component', 1, 1, 1, 28, 0, '0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 33, 34, 0, '*', 1),
1425(20, 'main', 'com_tags', 'Tags', '', 'Tags', 'index.php?option=com_tags', 'component', 1, 1, 1, 29, 0, '0000-00-00 00:00:00', 0, 1, 'class:tags', 0, '', 35, 36, 0, '', 1),
1426(21, 'main', 'com_postinstall', 'Post-installation messages', '', 'Post-installation messages', 'index.php?option=com_postinstall', 'component', 1, 1, 1, 32, 0, '0000-00-00 00:00:00', 0, 1, 'class:postinstall', 0, '', 37, 38, 0, '*', 1),
1427(22, 'main', 'com_associations', 'Multilingual Associations', '', 'Multilingual Associations', 'index.php?option=com_associations', 'component', 1, 1, 1, 34, 0, '0000-00-00 00:00:00', 0, 0, 'class:associations', 0, '', 39, 40, 0, '*', 1),
1428(101, 'mainmenu', 'Home', 'home', '', 'home', 'index.php?option=com_content&view=featured', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, '', 0, '{"featured_categories":[""],"layout_type":"blog","num_leading_articles":"1","num_intro_articles":"3","num_columns":"3","num_links":"0","multi_column_order":"1","orderby_pri":"","orderby_sec":"front","order_date":"","show_pagination":"2","show_pagination_results":"1","show_title":"","link_titles":"","show_intro":"","info_block_position":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_vote":"","show_readmore":"","show_readmore_title":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_hits":"","show_noauth":"","show_feed_link":"1","feed_summary":"","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_text":1,"page_title":"","show_page_heading":1,"page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}', 41, 42, 1, '*', 0);
1429
1430-- --------------------------------------------------------
1431
1432--
1433-- Table structure for table `#__menu_types`
1434--
1435
1436CREATE TABLE IF NOT EXISTS `#__menu_types` (
1437  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1438  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
1439  `menutype` varchar(24) NOT NULL,
1440  `title` varchar(48) NOT NULL,
1441  `description` varchar(255) NOT NULL DEFAULT '',
1442  `client_id` int(11) NOT NULL DEFAULT '0',
1443  PRIMARY KEY (`id`),
1444  UNIQUE KEY `idx_menutype` (`menutype`)
1445) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1446
1447--
1448-- Dumping data for table `#__menu_types`
1449--
1450
1451INSERT IGNORE INTO `#__menu_types` (`id`, `asset_id`, `menutype`, `title`, `description`, `client_id`) VALUES
1452(1, 0, 'mainmenu', 'Main Menu', 'The main menu for the site', 0);
1453
1454-- --------------------------------------------------------
1455
1456--
1457-- Table structure for table `#__messages`
1458--
1459
1460CREATE TABLE IF NOT EXISTS `#__messages` (
1461  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1462  `user_id_from` int(10) unsigned NOT NULL DEFAULT 0,
1463  `user_id_to` int(10) unsigned NOT NULL DEFAULT 0,
1464  `folder_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
1465  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1466  `state` tinyint(1) NOT NULL DEFAULT 0,
1467  `priority` tinyint(1) unsigned NOT NULL DEFAULT 0,
1468  `subject` varchar(255) NOT NULL DEFAULT '',
1469  `message` text NOT NULL,
1470  PRIMARY KEY (`message_id`),
1471  KEY `useridto_state` (`user_id_to`,`state`)
1472) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1473
1474-- --------------------------------------------------------
1475
1476--
1477-- Table structure for table `#__messages_cfg`
1478--
1479
1480CREATE TABLE IF NOT EXISTS `#__messages_cfg` (
1481  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
1482  `cfg_name` varchar(100) NOT NULL DEFAULT '',
1483  `cfg_value` varchar(255) NOT NULL DEFAULT '',
1484  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
1485) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1486
1487-- --------------------------------------------------------
1488
1489--
1490-- Table structure for table `#__modules`
1491--
1492
1493CREATE TABLE IF NOT EXISTS `#__modules` (
1494  `id` int(11) NOT NULL AUTO_INCREMENT,
1495  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
1496  `title` varchar(100) NOT NULL DEFAULT '',
1497  `note` varchar(255) NOT NULL DEFAULT '',
1498  `content` text NOT NULL DEFAULT '',
1499  `ordering` int(11) NOT NULL DEFAULT 0,
1500  `position` varchar(50) NOT NULL DEFAULT '',
1501  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
1502  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1503  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1504  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1505  `published` tinyint(1) NOT NULL DEFAULT 0,
1506  `module` varchar(50) DEFAULT NULL,
1507  `access` int(10) unsigned NOT NULL DEFAULT 0,
1508  `showtitle` tinyint(3) unsigned NOT NULL DEFAULT 1,
1509  `params` text NOT NULL,
1510  `client_id` tinyint(4) NOT NULL DEFAULT 0,
1511  `language` char(7) NOT NULL,
1512  PRIMARY KEY (`id`),
1513  KEY `published` (`published`,`access`),
1514  KEY `newsfeeds` (`module`,`published`),
1515  KEY `idx_language` (`language`)
1516) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=87;
1517
1518--
1519-- Dumping data for table `#__modules`
1520--
1521
1522INSERT INTO `#__modules` (`id`, `asset_id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES
1523(1, 39, 'Main Menu', '', '', 1, 'position-7', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_menu', 1, 1, '{"menutype":"mainmenu","startLevel":"0","endLevel":"0","showAllChildren":"1","tag_id":"","class_sfx":"","window_open":"","layout":"","moduleclass_sfx":"_menu","cache":"1","cache_time":"900","cachemode":"itemid"}', 0, '*'),
1524(2, 40, 'Login', '', '', 1, 'login', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_login', 1, 1, '', 1, '*'),
1525(3, 41, 'Popular Articles', '', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_popular', 3, 1, '{"count":"5","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'),
1526(4, 42, 'Recently Added Articles', '', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_latest', 3, 1, '{"count":"5","ordering":"c_dsc","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'),
1527(8, 43, 'Toolbar', '', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_toolbar', 3, 1, '', 1, '*'),
1528(9, 44, 'Quick Icons', '', '', 1, 'icon', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_quickicon', 3, 1, '', 1, '*'),
1529(10, 45, 'Logged-in Users', '', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_logged', 3, 1, '{"count":"5","name":"1","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'),
1530(12, 46, 'Admin Menu', '', '', 1, 'menu', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_menu', 3, 1, '{"layout":"","moduleclass_sfx":"","shownew":"1","showhelp":"1","cache":"0"}', 1, '*'),
1531(13, 47, 'Admin Submenu', '', '', 1, 'submenu', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_submenu', 3, 1, '', 1, '*'),
1532(14, 48, 'User Status', '', '', 2, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_status', 3, 1, '', 1, '*'),
1533(15, 49, 'Title', '', '', 1, 'title', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_title', 3, 1, '', 1, '*'),
1534(16, 50, 'Login Form', '', '', 7, 'position-7', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_login', 1, 1, '{"greeting":"1","name":"0"}', 0, '*'),
1535(17, 51, 'Breadcrumbs', '', '', 1, 'position-2', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_breadcrumbs', 1, 1, '{"moduleclass_sfx":"","showHome":"1","homeText":"","showComponent":"1","separator":"","cache":"0","cache_time":"0","cachemode":"itemid"}', 0, '*'),
1536(79, 52, 'Multilanguage status', '', '', 1, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'mod_multilangstatus', 3, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'),
1537(86, 53, 'Joomla Version', '', '', 1, 'footer', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_version', 3, 1, '{"format":"short","product":"1","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'),
1538(87, 55, 'Sample Data', '', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_sampledata', 6, 1, '{}', 1, '*'),
1539(88, 58, 'Latest Actions', '', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_latestactions', 6, 1, '{}', 1, '*'),
1540(89, 59, 'Privacy Dashboard', '', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_privacy_dashboard', 6, 1, '{}', 1, '*');
1541
1542-- --------------------------------------------------------
1543
1544--
1545-- Table structure for table `#__modules_menu`
1546--
1547
1548CREATE TABLE IF NOT EXISTS `#__modules_menu` (
1549  `moduleid` int(11) NOT NULL DEFAULT 0,
1550  `menuid` int(11) NOT NULL DEFAULT 0,
1551  PRIMARY KEY (`moduleid`,`menuid`)
1552) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1553
1554--
1555-- Dumping data for table `#__modules_menu`
1556--
1557
1558INSERT INTO `#__modules_menu` (`moduleid`, `menuid`) VALUES
1559(1, 0),
1560(2, 0),
1561(3, 0),
1562(4, 0),
1563(6, 0),
1564(7, 0),
1565(8, 0),
1566(9, 0),
1567(10, 0),
1568(12, 0),
1569(13, 0),
1570(14, 0),
1571(15, 0),
1572(16, 0),
1573(17, 0),
1574(79, 0),
1575(86, 0),
1576(87, 0),
1577(88, 0),
1578(89, 0);
1579
1580-- --------------------------------------------------------
1581
1582--
1583-- Table structure for table `#__newsfeeds`
1584--
1585
1586CREATE TABLE IF NOT EXISTS `#__newsfeeds` (
1587  `catid` int(11) NOT NULL DEFAULT 0,
1588  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1589  `name` varchar(100) NOT NULL DEFAULT '',
1590  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
1591  `link` varchar(2048) NOT NULL DEFAULT '',
1592  `published` tinyint(1) NOT NULL DEFAULT 0,
1593  `numarticles` int(10) unsigned NOT NULL DEFAULT 1,
1594  `cache_time` int(10) unsigned NOT NULL DEFAULT 3600,
1595  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
1596  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1597  `ordering` int(11) NOT NULL DEFAULT 0,
1598  `rtl` tinyint(4) NOT NULL DEFAULT 0,
1599  `access` int(10) unsigned NOT NULL DEFAULT 0,
1600  `language` char(7) NOT NULL DEFAULT '',
1601  `params` text NOT NULL,
1602  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1603  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
1604  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
1605  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1606  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
1607  `metakey` text NOT NULL,
1608  `metadesc` text NOT NULL,
1609  `metadata` text NOT NULL,
1610  `xreference` varchar(50) NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
1611  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1612  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1613  `description` text NOT NULL,
1614  `version` int(10) unsigned NOT NULL DEFAULT 1,
1615  `hits` int(10) unsigned NOT NULL DEFAULT 0,
1616  `images` text NOT NULL,
1617  PRIMARY KEY (`id`),
1618  KEY `idx_access` (`access`),
1619  KEY `idx_checkout` (`checked_out`),
1620  KEY `idx_state` (`published`),
1621  KEY `idx_catid` (`catid`),
1622  KEY `idx_createdby` (`created_by`),
1623  KEY `idx_language` (`language`),
1624  KEY `idx_xreference` (`xreference`)
1625) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1626
1627-- --------------------------------------------------------
1628
1629--
1630-- Table structure for table `#__overrider`
1631--
1632
1633CREATE TABLE IF NOT EXISTS `#__overrider` (
1634  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
1635  `constant` varchar(255) NOT NULL,
1636  `string` text NOT NULL,
1637  `file` varchar(255) NOT NULL,
1638  PRIMARY KEY (`id`)
1639) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1640
1641-- --------------------------------------------------------
1642
1643--
1644-- Table structure for table `#__postinstall_messages`
1645--
1646
1647CREATE TABLE IF NOT EXISTS `#__postinstall_messages` (
1648  `postinstall_message_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1649  `extension_id` bigint(20) NOT NULL DEFAULT 700 COMMENT 'FK to #__extensions',
1650  `title_key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Lang key for the title',
1651  `description_key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Lang key for description',
1652  `action_key` varchar(255) NOT NULL DEFAULT '',
1653  `language_extension` varchar(255) NOT NULL DEFAULT 'com_postinstall' COMMENT 'Extension holding lang keys',
1654  `language_client_id` tinyint(3) NOT NULL DEFAULT '1',
1655  `type` varchar(10) NOT NULL DEFAULT 'link' COMMENT 'Message type - message, link, action',
1656  `action_file` varchar(255) DEFAULT '' COMMENT 'RAD URI to the PHP file containing action method',
1657  `action` varchar(255) DEFAULT '' COMMENT 'Action method name or URL',
1658  `condition_file` varchar(255) DEFAULT NULL COMMENT 'RAD URI to file holding display condition method',
1659  `condition_method` varchar(255) DEFAULT NULL COMMENT 'Display condition method, must return boolean',
1660  `version_introduced` varchar(50) NOT NULL DEFAULT '3.2.0' COMMENT 'Version when this message was introduced',
1661  `enabled` tinyint(3) NOT NULL DEFAULT 1,
1662  PRIMARY KEY (`postinstall_message_id`)
1663) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1664
1665--
1666-- Dumping data for table `#__postinstall_messages`
1667--
1668
1669INSERT INTO `#__postinstall_messages` (`extension_id`, `title_key`, `description_key`, `action_key`, `language_extension`, `language_client_id`, `type`, `action_file`, `action`, `condition_file`, `condition_method`, `version_introduced`, `enabled`) VALUES
1670(700, 'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_TITLE', 'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_BODY', 'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_ACTION', 'plg_twofactorauth_totp', 1, 'action', 'site://plugins/twofactorauth/totp/postinstall/actions.php', 'twofactorauth_postinstall_action', 'site://plugins/twofactorauth/totp/postinstall/actions.php', 'twofactorauth_postinstall_condition', '3.2.0', 1),
1671(700, 'COM_CPANEL_WELCOME_BEGINNERS_TITLE', 'COM_CPANEL_WELCOME_BEGINNERS_MESSAGE', '', 'com_cpanel', 1, 'message', '', '', '', '', '3.2.0', 1),
1672(700, 'COM_CPANEL_MSG_STATS_COLLECTION_TITLE', 'COM_CPANEL_MSG_STATS_COLLECTION_BODY', '', 'com_cpanel', 1, 'message', '', '', 'admin://components/com_admin/postinstall/statscollection.php', 'admin_postinstall_statscollection_condition', '3.5.0', 1),
1673(700, 'PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME', 'PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME_BODY', 'PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME_ACTION', 'plg_system_updatenotification', 1, 'action', 'site://plugins/system/updatenotification/postinstall/updatecachetime.php', 'updatecachetime_postinstall_action', 'site://plugins/system/updatenotification/postinstall/updatecachetime.php', 'updatecachetime_postinstall_condition', '3.6.3', 1),
1674(700, 'COM_CPANEL_MSG_JOOMLA40_PRE_CHECKS_TITLE', 'COM_CPANEL_MSG_JOOMLA40_PRE_CHECKS_BODY', '', 'com_cpanel', 1, 'message', '', '', 'admin://components/com_admin/postinstall/joomla40checks.php', 'admin_postinstall_joomla40checks_condition', '3.7.0', 1),
1675(700, 'TPL_HATHOR_MESSAGE_POSTINSTALL_TITLE', 'TPL_HATHOR_MESSAGE_POSTINSTALL_BODY', 'TPL_HATHOR_MESSAGE_POSTINSTALL_ACTION', 'tpl_hathor', 1, 'action', 'admin://templates/hathor/postinstall/hathormessage.php', 'hathormessage_postinstall_action', 'admin://templates/hathor/postinstall/hathormessage.php', 'hathormessage_postinstall_condition', '3.7.0', 1),
1676(700, 'PLG_PLG_RECAPTCHA_VERSION_1_POSTINSTALL_TITLE', 'PLG_PLG_RECAPTCHA_VERSION_1_POSTINSTALL_BODY', 'PLG_PLG_RECAPTCHA_VERSION_1_POSTINSTALL_ACTION', 'plg_captcha_recaptcha', 1, 'action', 'site://plugins/captcha/recaptcha/postinstall/actions.php', 'recaptcha_postinstall_action', 'site://plugins/captcha/recaptcha/postinstall/actions.php', 'recaptcha_postinstall_condition', '3.8.6', 1),
1677(700, 'COM_ACTIONLOGS_POSTINSTALL_TITLE', 'COM_ACTIONLOGS_POSTINSTALL_BODY', '', 'com_actionlogs', 1, 'message', '', '', '', '', '3.9.0', 1),
1678(700, 'COM_PRIVACY_POSTINSTALL_TITLE', 'COM_PRIVACY_POSTINSTALL_BODY', '', 'com_privacy', 1, 'message', '', '', '', '', '3.9.0', 1);
1679
1680-- --------------------------------------------------------
1681
1682--
1683-- Table structure for table `#__privacy_requests`
1684--
1685
1686CREATE TABLE IF NOT EXISTS `#__privacy_requests` (
1687  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1688  `email` varchar(100) NOT NULL DEFAULT '',
1689  `requested_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1690  `status` tinyint(4) NOT NULL DEFAULT '0',
1691  `request_type` varchar(25) NOT NULL DEFAULT '',
1692  `confirm_token` varchar(100) NOT NULL DEFAULT '',
1693  `confirm_token_created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1694  PRIMARY KEY (`id`)
1695) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1696
1697-- --------------------------------------------------------
1698
1699--
1700-- Table structure for table `#__privacy_consents`
1701--
1702
1703CREATE TABLE IF NOT EXISTS `#__privacy_consents` (
1704  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1705  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
1706  `state` INT(10) NOT NULL DEFAULT '1',
1707  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1708  `subject` varchar(255) NOT NULL DEFAULT '',
1709  `body` text NOT NULL,
1710  `remind` tinyint(4) NOT NULL DEFAULT '0',
1711  `token` varchar(100) NOT NULL DEFAULT '',
1712  PRIMARY KEY (`id`),
1713  KEY `idx_user_id` (`user_id`)
1714) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1715
1716-- --------------------------------------------------------
1717
1718--
1719-- Table structure for table `#__redirect_links`
1720--
1721
1722CREATE TABLE IF NOT EXISTS `#__redirect_links` (
1723  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1724  `old_url` varchar(2048) NOT NULL,
1725  `new_url` varchar(2048),
1726  `referer` varchar(2048) NOT NULL,
1727  `comment` varchar(255) NOT NULL DEFAULT '',
1728  `hits` int(10) unsigned NOT NULL DEFAULT 0,
1729  `published` tinyint(4) NOT NULL,
1730  `created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1731  `modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1732  `header` smallint(3) NOT NULL DEFAULT 301,
1733  PRIMARY KEY (`id`),
1734  KEY `idx_old_url` (`old_url`(100)),
1735  KEY `idx_link_modifed` (`modified_date`)
1736) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1737
1738-- --------------------------------------------------------
1739
1740--
1741-- Table structure for table `#__schemas`
1742--
1743
1744CREATE TABLE IF NOT EXISTS `#__schemas` (
1745  `extension_id` int(11) NOT NULL,
1746  `version_id` varchar(20) NOT NULL,
1747  PRIMARY KEY (`extension_id`,`version_id`)
1748) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1749
1750-- --------------------------------------------------------
1751
1752--
1753-- Table structure for table `#__session`
1754--
1755
1756CREATE TABLE IF NOT EXISTS `#__session` (
1757  `session_id` varbinary(192) NOT NULL,
1758  `client_id` tinyint(3) unsigned DEFAULT NULL,
1759  `guest` tinyint(3) unsigned DEFAULT 1,
1760  `time` int(11) NOT NULL DEFAULT 0,
1761  `data` mediumtext,
1762  `userid` int(11) DEFAULT 0,
1763  `username` varchar(150) DEFAULT '',
1764  PRIMARY KEY (`session_id`),
1765  KEY `userid` (`userid`),
1766  KEY `time` (`time`)
1767) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1768
1769-- --------------------------------------------------------
1770
1771--
1772-- Table structure for table `#__tags`
1773--
1774
1775CREATE TABLE IF NOT EXISTS `#__tags` (
1776  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1777  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
1778  `lft` int(11) NOT NULL DEFAULT 0,
1779  `rgt` int(11) NOT NULL DEFAULT 0,
1780  `level` int(10) unsigned NOT NULL DEFAULT 0,
1781  `path` varchar(400) NOT NULL DEFAULT '',
1782  `title` varchar(255) NOT NULL,
1783  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
1784  `note` varchar(255) NOT NULL DEFAULT '',
1785  `description` mediumtext NOT NULL,
1786  `published` tinyint(1) NOT NULL DEFAULT 0,
1787  `checked_out` int(11) unsigned NOT NULL DEFAULT 0,
1788  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1789  `access` int(10) unsigned NOT NULL DEFAULT 0,
1790  `params` text NOT NULL,
1791  `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.',
1792  `metakey` varchar(1024) NOT NULL COMMENT 'The meta keywords for the page.',
1793  `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.',
1794  `created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
1795  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1796  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
1797  `modified_user_id` int(10) unsigned NOT NULL DEFAULT 0,
1798  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1799  `images` text NOT NULL,
1800  `urls` text NOT NULL,
1801  `hits` int(10) unsigned NOT NULL DEFAULT 0,
1802  `language` char(7) NOT NULL,
1803  `version` int(10) unsigned NOT NULL DEFAULT 1,
1804  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1805  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1806  PRIMARY KEY (`id`),
1807  KEY `tag_idx` (`published`,`access`),
1808  KEY `idx_access` (`access`),
1809  KEY `idx_checkout` (`checked_out`),
1810  KEY `idx_path` (`path`(100)),
1811  KEY `idx_left_right` (`lft`,`rgt`),
1812  KEY `idx_alias` (`alias`(100)),
1813  KEY `idx_language` (`language`)
1814) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1815
1816--
1817-- Dumping data for table `#__tags`
1818--
1819
1820INSERT INTO `#__tags` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `created_by_alias`, `modified_user_id`, `modified_time`, `images`, `urls`, `hits`, `language`, `version`) VALUES
1821(1, 0, 0, 1, 0, '', 'ROOT', 'root', '', '', 1, 0, '0000-00-00 00:00:00', 1, '', '', '', '', 42, '2011-01-01 00:00:01', '', 0, '0000-00-00 00:00:00', '', '', 0, '*', 1);
1822
1823-- --------------------------------------------------------
1824
1825--
1826-- Table structure for table `#__template_styles`
1827--
1828
1829CREATE TABLE IF NOT EXISTS `#__template_styles` (
1830  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1831  `template` varchar(50) NOT NULL DEFAULT '',
1832  `client_id` tinyint(1) unsigned NOT NULL DEFAULT 0,
1833  `home` char(7) NOT NULL DEFAULT 0,
1834  `title` varchar(255) NOT NULL DEFAULT '',
1835  `params` text NOT NULL,
1836  PRIMARY KEY (`id`),
1837  KEY `idx_template` (`template`),
1838  KEY `idx_home` (`home`)
1839) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9;
1840
1841--
1842-- Dumping data for table `#__template_styles`
1843--
1844
1845INSERT INTO `#__template_styles` (`id`, `template`, `client_id`, `home`, `title`, `params`) VALUES
1846(4, 'beez3', 0, '0', 'Beez3 - Default', '{"wrapperSmall":"53","wrapperLarge":"72","logo":"images\\/joomla_black.png","sitetitle":"Joomla!","sitedescription":"Open Source Content Management","navposition":"left","templatecolor":"personal","html5":"0"}'),
1847(5, 'hathor', 1, '0', 'Hathor - Default', '{"showSiteName":"0","colourChoice":"","boldText":"0"}'),
1848(7, 'protostar', 0, '1', 'protostar - Default', '{"templateColor":"","logoFile":"","googleFont":"1","googleFontName":"Open+Sans","fluidContainer":"0"}'),
1849(8, 'isis', 1, '1', 'isis - Default', '{"templateColor":"","logoFile":""}');
1850
1851-- --------------------------------------------------------
1852
1853--
1854-- Table structure for table `#__ucm_base`
1855--
1856
1857CREATE TABLE IF NOT EXISTS `#__ucm_base` (
1858  `ucm_id` int(10) unsigned NOT NULL,
1859  `ucm_item_id` int(10) NOT NULL,
1860  `ucm_type_id` int(11) NOT NULL,
1861  `ucm_language_id` int(11) NOT NULL,
1862  PRIMARY KEY (`ucm_id`),
1863  KEY `idx_ucm_item_id` (`ucm_item_id`),
1864  KEY `idx_ucm_type_id` (`ucm_type_id`),
1865  KEY `idx_ucm_language_id` (`ucm_language_id`)
1866) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1867
1868-- --------------------------------------------------------
1869
1870--
1871-- Table structure for table `#__ucm_content`
1872--
1873
1874CREATE TABLE IF NOT EXISTS `#__ucm_content` (
1875  `core_content_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1876  `core_type_alias` varchar(400) NOT NULL DEFAULT '' COMMENT 'FK to the content types table',
1877  `core_title` varchar(400) NOT NULL DEFAULT '',
1878  `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
1879  `core_body` mediumtext NOT NULL DEFAULT '',
1880  `core_state` tinyint(1) NOT NULL DEFAULT 0,
1881  `core_checked_out_time` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
1882  `core_checked_out_user_id` int(10) unsigned NOT NULL DEFAULT 0,
1883  `core_access` int(10) unsigned NOT NULL DEFAULT 0,
1884  `core_params` text NOT NULL DEFAULT '',
1885  `core_featured` tinyint(4) unsigned NOT NULL DEFAULT 0,
1886  `core_metadata` varchar(2048) NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.',
1887  `core_created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
1888  `core_created_by_alias` varchar(255) NOT NULL DEFAULT '',
1889  `core_created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1890  `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Most recent user that modified',
1891  `core_modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1892  `core_language` char(7) NOT NULL DEFAULT '',
1893  `core_publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1894  `core_publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1895  `core_content_item_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'ID from the individual type table',
1896  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
1897  `core_images` text NOT NULL DEFAULT '',
1898  `core_urls` text NOT NULL DEFAULT '',
1899  `core_hits` int(10) unsigned NOT NULL DEFAULT 0,
1900  `core_version` int(10) unsigned NOT NULL DEFAULT 1,
1901  `core_ordering` int(11) NOT NULL DEFAULT 0,
1902  `core_metakey` text NOT NULL DEFAULT '',
1903  `core_metadesc` text NOT NULL DEFAULT '',
1904  `core_catid` int(10) unsigned NOT NULL DEFAULT 0,
1905  `core_xreference` varchar(50) NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
1906  `core_type_id` int(10) unsigned NOT NULL DEFAULT 0,
1907  PRIMARY KEY (`core_content_id`),
1908  KEY `tag_idx` (`core_state`,`core_access`),
1909  KEY `idx_access` (`core_access`),
1910  KEY `idx_alias` (`core_alias`(100)),
1911  KEY `idx_language` (`core_language`),
1912  KEY `idx_title` (`core_title`(100)),
1913  KEY `idx_modified_time` (`core_modified_time`),
1914  KEY `idx_created_time` (`core_created_time`),
1915  KEY `idx_content_type` (`core_type_alias`(100)),
1916  KEY `idx_core_modified_user_id` (`core_modified_user_id`),
1917  KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`),
1918  KEY `idx_core_created_user_id` (`core_created_user_id`),
1919  KEY `idx_core_type_id` (`core_type_id`)
1920 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Contains core content data in name spaced fields';
1921
1922-- --------------------------------------------------------
1923
1924--
1925-- Table structure for table `#__ucm_history`
1926--
1927
1928CREATE TABLE IF NOT EXISTS `#__ucm_history` (
1929  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1930  `ucm_item_id` int(10) unsigned NOT NULL,
1931  `ucm_type_id` int(10) unsigned NOT NULL,
1932  `version_note` varchar(255) NOT NULL DEFAULT '' COMMENT 'Optional version name',
1933  `save_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1934  `editor_user_id` int(10) unsigned NOT NULL DEFAULT 0,
1935  `character_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Number of characters in this version.',
1936  `sha1_hash` varchar(50) NOT NULL DEFAULT '' COMMENT 'SHA1 hash of the version_data column.',
1937  `version_data` mediumtext NOT NULL COMMENT 'json-encoded string of version data',
1938  `keep_forever` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=auto delete; 1=keep',
1939  PRIMARY KEY (`version_id`),
1940  KEY `idx_ucm_item_id` (`ucm_type_id`,`ucm_item_id`),
1941  KEY `idx_save_date` (`save_date`)
1942) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
1943
1944-- --------------------------------------------------------
1945
1946--
1947-- Table structure for table `#__updates`
1948--
1949
1950CREATE TABLE IF NOT EXISTS `#__updates` (
1951  `update_id` int(11) NOT NULL AUTO_INCREMENT,
1952  `update_site_id` int(11) DEFAULT 0,
1953  `extension_id` int(11) DEFAULT 0,
1954  `name` varchar(100) DEFAULT '',
1955  `description` text NOT NULL,
1956  `element` varchar(100) DEFAULT '',
1957  `type` varchar(20) DEFAULT '',
1958  `folder` varchar(20) DEFAULT '',
1959  `client_id` tinyint(3) DEFAULT 0,
1960  `version` varchar(32) DEFAULT '',
1961  `data` text NOT NULL,
1962  `detailsurl` text NOT NULL,
1963  `infourl` text NOT NULL,
1964  `extra_query` varchar(1000) DEFAULT '',
1965  PRIMARY KEY (`update_id`)
1966) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';
1967
1968-- --------------------------------------------------------
1969
1970--
1971-- Table structure for table `#__update_sites`
1972--
1973
1974CREATE TABLE IF NOT EXISTS `#__update_sites` (
1975  `update_site_id` int(11) NOT NULL AUTO_INCREMENT,
1976  `name` varchar(100) DEFAULT '',
1977  `type` varchar(20) DEFAULT '',
1978  `location` text NOT NULL,
1979  `enabled` int(11) DEFAULT 0,
1980  `last_check_timestamp` bigint(20) DEFAULT 0,
1981  `extra_query` varchar(1000) DEFAULT '',
1982  PRIMARY KEY (`update_site_id`)
1983) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites';
1984
1985--
1986-- Dumping data for table `#__update_sites`
1987--
1988
1989INSERT INTO `#__update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`) VALUES
1990(1, 'Joomla! Core', 'collection', 'https://update.joomla.org/core/list.xml', 1, 0),
1991(2, 'Accredited Joomla! Translations', 'collection', 'https://update.joomla.org/language/translationlist_3.xml', 1, 0),
1992(3, 'Joomla! Update Component Update Site', 'extension', 'https://update.joomla.org/core/extensions/com_joomlaupdate.xml', 1, 0);
1993
1994-- --------------------------------------------------------
1995
1996--
1997-- Table structure for table `#__update_sites_extensions`
1998--
1999
2000CREATE TABLE IF NOT EXISTS `#__update_sites_extensions` (
2001  `update_site_id` int(11) NOT NULL DEFAULT 0,
2002  `extension_id` int(11) NOT NULL DEFAULT 0,
2003  PRIMARY KEY (`update_site_id`,`extension_id`)
2004) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites';
2005
2006--
2007-- Dumping data for table `#__update_sites_extensions`
2008--
2009
2010INSERT INTO `#__update_sites_extensions` (`update_site_id`, `extension_id`) VALUES
2011(1, 700),
2012(2, 802),
2013(3, 28);
2014
2015-- --------------------------------------------------------
2016
2017--
2018-- Table structure for table `#__usergroups`
2019--
2020
2021CREATE TABLE IF NOT EXISTS `#__usergroups` (
2022  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
2023  `parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Adjacency List Reference Id',
2024  `lft` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
2025  `rgt` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
2026  `title` varchar(100) NOT NULL DEFAULT '',
2027  PRIMARY KEY (`id`),
2028  UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
2029  KEY `idx_usergroup_title_lookup` (`title`),
2030  KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
2031  KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE
2032) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2033
2034--
2035-- Dumping data for table `#__usergroups`
2036--
2037
2038INSERT INTO `#__usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES
2039(1, 0, 1, 18, 'Public'),
2040(2, 1, 8, 15, 'Registered'),
2041(3, 2, 9, 14, 'Author'),
2042(4, 3, 10, 13, 'Editor'),
2043(5, 4, 11, 12, 'Publisher'),
2044(6, 1, 4, 7, 'Manager'),
2045(7, 6, 5, 6, 'Administrator'),
2046(8, 1, 16, 17, 'Super Users'),
2047(9, 1, 2, 3, 'Guest');
2048
2049-- --------------------------------------------------------
2050
2051--
2052-- Table structure for table `#__users`
2053--
2054
2055CREATE TABLE IF NOT EXISTS `#__users` (
2056  `id` int(11) NOT NULL AUTO_INCREMENT,
2057  `name` varchar(400) NOT NULL DEFAULT '',
2058  `username` varchar(150) NOT NULL DEFAULT '',
2059  `email` varchar(100) NOT NULL DEFAULT '',
2060  `password` varchar(100) NOT NULL DEFAULT '',
2061  `block` tinyint(4) NOT NULL DEFAULT 0,
2062  `sendEmail` tinyint(4) DEFAULT 0,
2063  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2064  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2065  `activation` varchar(100) NOT NULL DEFAULT '',
2066  `params` text NOT NULL,
2067  `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
2068  `resetCount` int(11) NOT NULL DEFAULT 0 COMMENT 'Count of password resets since lastResetTime',
2069  `otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
2070  `otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
2071  `requireReset` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Require user to reset password on next login',
2072  PRIMARY KEY (`id`),
2073  KEY `idx_name` (`name`(100)),
2074  KEY `idx_block` (`block`),
2075  KEY `username` (`username`),
2076  KEY `email` (`email`)
2077) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2078
2079-- --------------------------------------------------------
2080
2081--
2082-- Table structure for table `#__user_keys`
2083--
2084
2085CREATE TABLE IF NOT EXISTS `#__user_keys` (
2086  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2087  `user_id` varchar(150) NOT NULL,
2088  `token` varchar(255) NOT NULL,
2089  `series` varchar(191) NOT NULL,
2090  `invalid` tinyint(4) NOT NULL,
2091  `time` varchar(200) NOT NULL,
2092  `uastring` varchar(255) NOT NULL,
2093  PRIMARY KEY (`id`),
2094  UNIQUE KEY `series` (`series`),
2095  KEY `user_id` (`user_id`)
2096) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2097
2098-- --------------------------------------------------------
2099
2100--
2101-- Table structure for table `#__user_notes`
2102--
2103
2104CREATE TABLE IF NOT EXISTS `#__user_notes` (
2105  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2106  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
2107  `catid` int(10) unsigned NOT NULL DEFAULT 0,
2108  `subject` varchar(100) NOT NULL DEFAULT '',
2109  `body` text NOT NULL,
2110  `state` tinyint(3) NOT NULL DEFAULT 0,
2111  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
2112  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2113  `created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
2114  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2115  `modified_user_id` int(10) unsigned NOT NULL,
2116  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2117  `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2118  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2119  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2120  PRIMARY KEY (`id`),
2121  KEY `idx_user_id` (`user_id`),
2122  KEY `idx_category_id` (`catid`)
2123) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2124
2125-- --------------------------------------------------------
2126
2127--
2128-- Table structure for table `#__user_profiles`
2129--
2130
2131CREATE TABLE IF NOT EXISTS `#__user_profiles` (
2132  `user_id` int(11) NOT NULL,
2133  `profile_key` varchar(100) NOT NULL,
2134  `profile_value` text NOT NULL,
2135  `ordering` int(11) NOT NULL DEFAULT 0,
2136  UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`)
2137) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';
2138
2139-- --------------------------------------------------------
2140
2141--
2142-- Table structure for table `#__user_usergroup_map`
2143--
2144
2145CREATE TABLE IF NOT EXISTS `#__user_usergroup_map` (
2146  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Foreign Key to #__users.id',
2147  `group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Foreign Key to #__usergroups.id',
2148  PRIMARY KEY (`user_id`,`group_id`)
2149) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2150
2151--
2152-- Table structure for table `#__action_logs`
2153--
2154
2155CREATE TABLE IF NOT EXISTS `#__action_logs` (
2156  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2157  `message_language_key` varchar(255) NOT NULL DEFAULT '',
2158  `message` text NOT NULL,
2159  `log_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2160  `extension` varchar(50) NOT NULL DEFAULT '',
2161  `user_id` int(11) NOT NULL DEFAULT 0,
2162  `item_id` int(11) NOT NULL DEFAULT 0,
2163  `ip_address` VARCHAR(40) NOT NULL DEFAULT '0.0.0.0',
2164  PRIMARY KEY (`id`),
2165  KEY `idx_user_id` (`user_id`),
2166  KEY `idx_user_id_logdate` (`user_id`, `log_date`),
2167  KEY `idx_user_id_extension` (`user_id`, `extension`),
2168  KEY `idx_extension_item_id` (`extension`, `item_id`)
2169) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2170
2171--
2172-- Table structure for table `#__action_logs_extensions`
2173--
2174
2175CREATE TABLE IF NOT EXISTS `#__action_logs_extensions` (
2176  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2177  `extension` varchar(255) NOT NULL DEFAULT '',
2178  PRIMARY KEY (`id`)
2179) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2180
2181INSERT INTO `#__action_logs_extensions` (`id`, `extension`) VALUES
2182(1, 'com_banners'),
2183(2, 'com_cache'),
2184(3, 'com_categories'),
2185(4, 'com_config'),
2186(5, 'com_contact'),
2187(6, 'com_content'),
2188(7, 'com_installer'),
2189(8, 'com_media'),
2190(9, 'com_menus'),
2191(10, 'com_messages'),
2192(11, 'com_modules'),
2193(12, 'com_newsfeeds'),
2194(13, 'com_plugins'),
2195(14, 'com_redirect'),
2196(15, 'com_tags'),
2197(16, 'com_templates'),
2198(17, 'com_users');
2199
2200--
2201-- Table structure for table `#__action_log_config`
2202--
2203
2204CREATE TABLE IF NOT EXISTS `#__action_log_config` (
2205  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2206  `type_title` varchar(255) NOT NULL DEFAULT '',
2207  `type_alias` varchar(255) NOT NULL DEFAULT '',
2208  `id_holder` varchar(255),
2209  `title_holder` varchar(255),
2210  `table_name` varchar(255),
2211  `text_prefix` varchar(255),
2212  PRIMARY KEY (`id`)
2213) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2214
2215INSERT INTO `#__action_log_config` (`id`, `type_title`, `type_alias`, `id_holder`, `title_holder`, `table_name`, `text_prefix`) VALUES
2216(1, 'article', 'com_content.article', 'id' ,'title' , '#__content', 'PLG_ACTIONLOG_JOOMLA'),
2217(2, 'article', 'com_content.form', 'id', 'title' , '#__content', 'PLG_ACTIONLOG_JOOMLA'),
2218(3, 'banner', 'com_banners.banner', 'id' ,'name' , '#__banners', 'PLG_ACTIONLOG_JOOMLA'),
2219(4, 'user_note', 'com_users.note', 'id', 'subject' ,'#__user_notes', 'PLG_ACTIONLOG_JOOMLA'),
2220(5, 'media', 'com_media.file', '' , 'name' , '',  'PLG_ACTIONLOG_JOOMLA'),
2221(6, 'category', 'com_categories.category', 'id' , 'title' , '#__categories', 'PLG_ACTIONLOG_JOOMLA'),
2222(7, 'menu', 'com_menus.menu', 'id' ,'title' , '#__menu_types', 'PLG_ACTIONLOG_JOOMLA'),
2223(8, 'menu_item', 'com_menus.item', 'id' , 'title' , '#__menu', 'PLG_ACTIONLOG_JOOMLA'),
2224(9, 'newsfeed', 'com_newsfeeds.newsfeed', 'id' ,'name' , '#__newsfeeds', 'PLG_ACTIONLOG_JOOMLA'),
2225(10, 'link', 'com_redirect.link', 'id', 'old_url' , '#__redirect_links', 'PLG_ACTIONLOG_JOOMLA'),
2226(11, 'tag', 'com_tags.tag', 'id', 'title' , '#__tags', 'PLG_ACTIONLOG_JOOMLA'),
2227(12, 'style', 'com_templates.style', 'id' , 'title' , '#__template_styles', 'PLG_ACTIONLOG_JOOMLA'),
2228(13, 'plugin', 'com_plugins.plugin', 'extension_id' , 'name' , '#__extensions', 'PLG_ACTIONLOG_JOOMLA'),
2229(14, 'component_config', 'com_config.component', 'extension_id' , 'name', '', 'PLG_ACTIONLOG_JOOMLA'),
2230(15, 'contact', 'com_contact.contact', 'id', 'name', '#__contact_details', 'PLG_ACTIONLOG_JOOMLA'),
2231(16, 'module', 'com_modules.module', 'id' ,'title', '#__modules', 'PLG_ACTIONLOG_JOOMLA'),
2232(17, 'access_level', 'com_users.level', 'id' , 'title', '#__viewlevels', 'PLG_ACTIONLOG_JOOMLA'),
2233(18, 'banner_client', 'com_banners.client', 'id', 'name', '#__banner_clients', 'PLG_ACTIONLOG_JOOMLA'),
2234(19, 'application_config', 'com_config.application', '', 'name', '', 'PLG_ACTIONLOG_JOOMLA');
2235
2236--
2237-- Table structure for table `#__action_logs_users`
2238--
2239
2240CREATE TABLE IF NOT EXISTS `#__action_logs_users` (
2241  `user_id` int(11) UNSIGNED NOT NULL,
2242  `notify` tinyint(1) UNSIGNED NOT NULL,
2243  `extensions` text NOT NULL,
2244  PRIMARY KEY (`user_id`),
2245  KEY `idx_notify` (`notify`)
2246) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2247
2248--
2249-- Table structure for table `#__utf8_conversion`
2250--
2251
2252CREATE TABLE IF NOT EXISTS `#__utf8_conversion` (
2253  `converted` tinyint(4) NOT NULL DEFAULT 0
2254) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
2255
2256--
2257-- Dumping data for table `#__utf8_conversion`
2258--
2259
2260INSERT INTO `#__utf8_conversion` (`converted`) VALUES (0);
2261
2262--
2263-- Table structure for table `#__viewlevels`
2264--
2265
2266CREATE TABLE IF NOT EXISTS `#__viewlevels` (
2267  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
2268  `title` varchar(100) NOT NULL DEFAULT '',
2269  `ordering` int(11) NOT NULL DEFAULT 0,
2270  `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
2271  PRIMARY KEY (`id`),
2272  UNIQUE KEY `idx_assetgroup_title_lookup` (`title`)
2273) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7;
2274
2275--
2276-- Dumping data for table `#__viewlevels`
2277--
2278
2279INSERT INTO `#__viewlevels` (`id`, `title`, `ordering`, `rules`) VALUES
2280(1, 'Public', 0, '[1]'),
2281(2, 'Registered', 2, '[6,2,8]'),
2282(3, 'Special', 3, '[6,3,8]'),
2283(5, 'Guest', 1, '[9]'),
2284(6, 'Super Users', 4, '[8]');