%PDF-1.4 %âãÏÓ 191 0 obj <> endobj 403 Forbidden
⚝ One Hat Cyber Team ⚝
  • Dir : ~/proc/self/root/var/softaculous/eengine/
    • Edit File: eengine.sql
    \n \n \n
    \n \n
    \n {/exp:email:contact_form}\n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (11, 1, 6, 'rss', 'feed', NULL, '{!-- page vars (prefix p_) --}\n{preload_replace:p_title=''My Blog''}\n{preload_replace:p_url=''blog''}\n{preload_replace:p_url_entry=''entry''}\n{!-- channel vars (prefix ch_) --}\n{preload_replace:ch=''blog''}\n{preload_replace:ch_disable=''member_data|pagination''}\n\n{exp:rss:feed channel=''{ch}''}\n \n \n\n \n\n <![CDATA[{p_title} / {site_name}]]>\n {site_url}{p_url}/\n {channel_description}\n {channel_language}\n {email} ({author})\n Copyright {gmt_date format=''%Y''}\n {gmt_date format=''%Y-%m-%dT%H:%i:%s%Q''}\n \n\n {exp:channel:entries channel=''{ch}'' disable=''{ch_disable}'' limit=''10'' rdf=''off'' dynamic_start=''yes''}\n \n <![CDATA[{title}]]>\n {title_permalink=''{p_url}/{p_url_entry}''}\n {title_permalink=''{p_url}/{p_url_entry}''}\n {email} ({author})\n Read more

    ]]>    \n \n {gmt_entry_date format=''{DATE_RSS}''}\n     \n {/exp:channel:entries}\n\n     \n     \n{/exp:rss:feed}', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (12, 1, 6, 'index', 'webpage', NULL, '{layout=''layouts/_blog-layout''}\n\n{!--\n 404 Redirect\n ============\n This is a listing page, it needs categories and pagination to work, but also needs to redirect if segment_2 is invalid . i.e. http://example.com/blog/nothing\n--}\n{if segment_2}\n {if segment_2 != ''category'' AND segment_2 ~ ''/^(?!P\\d+).*/''}\n {redirect=''404''}\n {/if}\n{/if}\n\n{!-- prevents 3rd ++ segments on non category listings --}\n{if segment_3}\n {if segment_2 != ''category''}\n {redirect=''{segment_1}/{segment_2}''}\n {/if}\n{/if}\n\n{!-- prevents 4th ++ segments on category listings --}\n{if segment_4}\n {if segment_4 ~ ''/^(?!P\\d+).*/''}\n {redirect=''{segment_1}/{segment_2}/{segment_3}''}\n {/if}\n{/if}\n\n{!-- prevents 5th ++ segments on paginated category listings --}\n{if segment_5}\n {redirect=''{segment_1}/{segment_2}/{segment_3}/{segment_4}''}\n{/if}\n\n{!-- We use preload replace variables for in-template replacements for things\n like tag parameters that we might repeat here. That way if we change things\n down the road, we can just change it here instead of looking all over the\n template for them. --}\n\n{!-- page vars (prefix p_) --}\n{preload_replace:p_title=''My Blog''}\n{preload_replace:p_description=''A blog about things, things I like and things I do.''}\n{preload_replace:p_url=''blog''}\n{preload_replace:p_url_entry=''entry''}\n{!-- channel vars (prefix ch_) --}\n{preload_replace:ch=''blog''}\n{preload_replace:ch_disable=''category_fields|member_data''}\n\n{!-- every template using the blog layout will set these which lets us use\n shared markup with customizable details. --}\n\n{!-- layout vars, channel/page related --}\n{layout:set name=''ch'' value=''{ch}''}\n{layout:set name=''p_url'' value=''{p_url}''}\n{layout:set name=''p_title'' value=''{p_title}''}\n{!-- layout vars, static --}\n{layout:set name=''title'' value=''{p_title}{gv_sep}''}\n{layout:set name=''description'' value=''{p_description}''}\n{!-- OpenGraph meta output --}\n{layout:set name=''og_title'' value=''{p_title}''}\n{layout:set name=''og_url''}{path=''{p_url}''}{/layout:set}\n{layout:set name=''og_description'' value=''{p_description}''}\n\n{!-- Everything below is the "meat" of the template. We''ll use tags to output content,\n which will populate the layout:contents of the layouts/_blog-layout layout --}\n\n {!-- Heading output is different in the case of category listings. --}\n {if segment_2 == ''category''}\n {layout:set name=''cat_ch'' value=''{ch}''}\n {exp:channel:category_heading channel=''{ch}''}\n

    {category_name}

    \n {if category_description}\n

    {category_description}

    \n {/if}\n {/exp:channel:category_heading}\n {if:else}\n

    {p_title}

    \n

    {p_description}

    \n {/if}\n
    \n {exp:channel:entries channel=''{ch}'' disable=''{ch_disable}'' limit=''5''}\n {!-- listing as a snippet, as it''s used through more than one template --}\n {snp_blog_list}\n {!-- no results output --}\n {if no_results}\n
    \n

    {gv_entries_none}

    \n
    \n {/if}\n {!-- pagination --}\n {snp_blog_list_paginate}\n {/exp:channel:entries}\n
    ', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (13, 1, 6, 'search', 'webpage', NULL, '{layout=''layouts/_blog-layout''}\n\n{!-- prevents 4th ++ segments on search results --}\n{if segment_4}\n {if segment_4 ~ ''/^(?!P\\d+).*/''}\n {redirect=''{segment_1}/{segment_2}/{segment_3}''}\n {/if}\n{/if}\n\n{!-- prevents 5th ++ segments on paginated search results --}\n{if segment_5}\n {redirect=''{segment_1}/{segment_2}/{segment_3}/{segment_4}''}\n{/if}\n\n{!-- page vars --}\n{preload_replace:p_title=''My Blog''}\n{preload_replace:p_description=''Search Results''}\n{preload_replace:p_url=''blog''}\n{preload_replace:p_url_entry=''entry''}\n{!-- channel vars (prefix ch_) --}\n{preload_replace:ch=''blog''}\n{!-- layout vars, channel/page related --}\n{layout:set name=''ch'' value=''{ch}''}\n{layout:set name=''p_url'' value=''{p_url}''}\n{layout:set name=''p_title'' value=''{p_title}''}\n{layout:set name=''search'' value=''y''}\n{!-- layout vars --}\n{layout:set name=''title'' value=''search results{gv_sep}{p_title}{gv_sep}''}\n{layout:set name=''description'' value=''{p_description}''}\n\n

    Search Results, {p_title}

    \n
    \n {exp:search:search_results}\n {!-- listing as a snippet, as it''s used through more than one template --}\n {snp_blog_list}\n {!-- pagination --}\n {snp_blog_list_paginate}\n {/exp:search:search_results}\n
    \n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (14, 1, 6, 'entry', 'webpage', NULL, '{layout=''layouts/_blog-layout''}\n\n{!--\n Redirect\n ============\n This is a blog single entry page, it''ll never need a fourth segment, so we use the following code to make sure the page redirects if someone types in an incorrect URL in the browser address bar, by adding new segments. i.e. http://example.com/blog/entry/title/nothing\n--}\n{if segment_4}\n {redirect=''{segment_1}/{segment_2}/{segment_3}''}\n{/if}\n\n{!-- page vars (prefix p_) --}\n{preload_replace:p_title=''My Blog''}\n{preload_replace:p_description=''A blog about things, things I like and things I do.''}\n{preload_replace:p_url=''blog''}\n{preload_replace:p_url_entry=''entry''}\n{!-- channel vars (prefix ch_) --}\n{preload_replace:ch=''blog''}\n{preload_replace:ch_disable=''category_fields|member_data|pagination''}\n{!-- layout vars, channel/page related --}\n{layout:set name=''ch'' value=''{ch}''}\n{layout:set name=''p_url'' value=''{p_url}''}\n{layout:set name=''p_title'' value=''{p_title}''}\n\n\n {!-- single-entry pagination --}\n
    \n {exp:channel:prev_entry channel=''{ch}''}\n Previous\n {/exp:channel:prev_entry}\n {exp:channel:next_entry channel=''{ch}''}\n Next\n {/exp:channel:next_entry}\n
    \n {!-- require_entry makes it so if someone types the wrong URL, they will get a 404 page --}\n {exp:channel:entries channel=''{ch}'' disable=''{ch_disable}'' limit=''1'' require_entry=''yes''}\n {!-- layout vars, dynamic, not output --}\n {layout:set name=''title'' value=''{seo_title}{gv_sep}{p_title}{gv_sep}''}\n {layout:set name=''description'' value=''{seo_desc}''}\n {layout:set name=''entry_ch'' value=''{ch}''}\n {!-- OpenGraph meta output --}\n {layout:set name=''og_title'' value=''{seo_title}''}\n {layout:set name=''og_url''}{path=''{p_url}''}{/layout:set}\n {layout:set name=''og_description'' value=''{seo_desc}''}\n {!-- /layout vars, dynamic, not output --}\n\n {!-- content output --}\n

    {title}

    \n {!-- video, youtube or vimeo? (GRID) --}\n {if blog_video}\n {blog_video}\n {if blog_video:type == ''youtube''}\n
    \n
    \n \n
    \n
    \n {/if}\n {if blog_video:type == ''vimeo''}\n
    \n
    \n \n
    \n
    \n {/if}\n {/blog_video}\n {/if}\n {!-- audio, soundcloud or bandcamp? (GRID) --}\n {if blog_audio}\n {blog_audio}\n {if blog_audio:type == ''soundcloud''}\n
    \n \n
    \n {/if}\n {if blog_audio:type == ''bandcamp''}\n
    \n \n
    \n {/if}\n {/blog_audio}\n {/if}\n {!-- image (GRID) --}\n {if blog_image}\n {blog_image}\n
    \n {blog_image:caption:attr_safe}\n
    {blog_image:caption}
    \n
    \n {/blog_image}\n {/if}\n {!-- blog_content is a textarea with HTML output we don''t need to wrap this tag with HTML as that is already included in it''s output. --}\n {blog_content}\n {!-- /content output --}\n\n {!--\n no results redirect\n ===================\n If the entry doesn''t exist, we redirect to 404. This works in tandem with the require_entry=''yes'' parameter on the channel entries tag.\n --}\n {if no_results}\n {redirect=''404''}\n {/if}\n {!--\n comments\n comment:entries and comment:form are independent of channel:entries\n we''ve put them into a embed here to demonstrate how to get a specific\n display on the front end of the site using allow_comments.\n This would not work without the embed, as these tags would not parse\n inside the channel:entries tag.\n --}\n {if allow_comments}\n {embed=''{p_url}/_comments'' ch=''{ch}''}\n {if:else}\n {if comment_total >= 1}\n {embed=''{p_url}/_comments'' ch=''{ch}''}\n {/if}\n
    \n {if comment_expiration_date < current_time AND comment_expiration_date != 0}\n

    {gv_comment_expired}

    \n {if:else}\n

    {gv_comment_disabled}

    \n {/if}\n
    \n {/if}\n {/exp:channel:entries}\n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (15, 1, 6, '_comments', 'webpage', NULL, '{!-- comments --}\n
    \n

    Commentary

    \n {!-- comment entries --}\n {exp:comment:entries channel=''{embed:ch}''}\n
    \n
    \n
    \n {!-- change the comment text output if the commenter is being ignored by the logged in user. --}\n {if is_ignored}\n
    \n

    {gv_comment_ignore} {name}.

    \n
    \n {if:else}\n {comment}\n {/if}\n
    \n
    \n {!-- mark the author of the post, and ignored differently than other commenters --}\n \n {if url}\n {name}\n {if:else}\n {url_as_author}\n {/if}\n \n

    on {comment_date format="%n/%j/%Y"}{if location}
    from {location}{/if}

    \n
    \n
    \n
    \n {!--\n no results output\n ===================\n If there are no comments, show this message.\n --}\n {if no_results}\n
    \n

    {gv_comment_none}

    \n
    \n {/if}\n {/exp:comment:entries}\n\n {!-- comment form --}\n
    \n {exp:comment:form channel=''{embed:ch}'' form_class=''comment-form'' return=''{segment_1}/{segment_2}/{segment_3}#last-comment''}\n {!-- if the user is logged out show more fields for commenting --}\n {if logged_out}\n

    Comment as a guest Required Fields ✱

    \n
    \n
    \n \n What do you want to be called?\n
    \n
    \n \n
    \n
    \n
    \n
    \n \n How do we contact you?\n
    \n
    \n \n
    \n
    \n
    \n
    \n \n Where are you commenting from?\n
    \n
    \n \n
    \n
    \n
    \n
    \n \n Do you have a website to share?\n
    \n
    \n \n
    \n
    \n {if:else}\n

    Comment as {screen_name} ✱ Required Fields

    \n {/if}\n
    \n
    \n \n Please keep it kind, brief and courteous.\n
    \n
    \n \n
    \n
    \n
    \n
    \n \n Extra stuff we can do!\n
    \n
    \n \n \n
    \n
    \n
    \n \n
    \n {!-- required to prevent EE from outputting text --}\n {if comments_disabled}{/if}\n {if comments_expired}{/if}\n {/exp:comment:form}\n
    \n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (16, 1, 6, 'no-results', 'webpage', NULL, '{layout=''layouts/_blog-layout''}\n\n{!-- prevents 4th ++ segments on no results searches --}\n{if segment_4}\n {redirect=''{segment_1}/{segment_2}/{segment_3}''}\n{/if}\n\n{!-- page vars --}\n{preload_replace:p_title=''My Blog''}\n{preload_replace:p_description=''Search Results''}\n{preload_replace:p_url=''blog''}\n{!-- channel vars (prefix ch_) --}\n{preload_replace:ch=''blog''}\n{!-- layout vars, channel/page related --}\n{layout:set name=''ch'' value=''{ch}''}\n{layout:set name=''p_url'' value=''{p_url}''}\n{layout:set name=''p_title'' value=''{p_title}''}\n{layout:set name=''search'' value=''y''}\n{!-- layout vars --}\n{layout:set name=''title'' value=''search results{gv_sep}{p_title}{gv_sep}''}\n{layout:set name=''description'' value=''{p_description}''}\n\n

    Search Results, {p_title}

    \n
    \n

    Sorry, zero entries found matching "{exp:search:keywords}".

    \n
    \n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (17, 1, 7, '_about-layout', 'webpage', NULL, '{layout=''layouts/_html-wrapper''}\n\n{!-- embed for breadcrumb, needed to pass arguments (embeds aren''t evil) --}\n{layout:set name=''breadcrumbs''}\n {embed=''common/_breadcrumb''\n p_url=''{layout:p_url}''\n p_title=''{layout:p_title}''\n {if layout:entry_ch}entry_ch=''{layout:entry_ch}''{/if}\n }\n{/layout:set}\n\n
    \n
    \n {layout:contents}\n
    \n
    \n
    \n
      \n {!--\n sub navigation\n ==============\n This is a dynamic way to create sub navigation for this section. I use the parameter dynamic=''no'' to prevent the URL from changing the output of a channel entries tag. I also use a status of ''Default Page'' to determine the, well default page.\n NOTE: A channel should only have one Default Page.\n --}\n {exp:channel:entries channel=''{layout:ch}'' disable=''{layout:ch_disable}'' dynamic=''no'' orderby=''status'' sort=''asc'' status=''{layout:ch_status}''}\n {!-- we need to treat the default page link a little differently so we check for the ''Default Page'' status and output it, then all other page links output below that. We use the orderby=''status'' and sort=''asc'' parameters to accomplish this. --}\n {if status == ''Default Page''}\n
    • {title}
      • \n {if:else}\n
    • {title}
      • \n {/if}\n {/exp:channel:entries}\n
    \n
    \n
    \n
    ', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (18, 1, 7, '_contact-layout', 'webpage', NULL, '{layout=''layouts/_html-wrapper''}\n\n{!-- embed for breadcrumb, needed to pass arguments (embeds aren''t evil) --}\n{layout:set name=''breadcrumbs''}\n {embed=''common/_breadcrumb''\n p_url=''{layout:p_url}''\n p_title=''{layout:p_title}''\n }\n{/layout:set}\n\n{layout:set name=''scripts''}\n \n {layout:scripts}\n{/layout:set}\n\n
    \n
    \n {layout:contents}\n
    \n
    \n {!-- output contact info --}\n {exp:channel:entries channel=''{layout:ch}'' disable=''{layout:ch_disable}'' limit=''1'' dynamic=''no''}\n
    \n {site_name}\n {if contact_address}\n {contact_address}\n \n {contact_address:street}, {contact_address:street_2}
    \n {contact_address:city}, {contact_address:state} {contact_address:zip}\n     \n {/contact_address}\n {/if}\n {if contact_phone OR contact_email}\n \n {if contact_phone}{contact_phone}{/if}\n {if contact_phone AND contact_email}
    {/if}\n {if contact_email}{contact_email}{/if}\n     \n {/if}\n
    \n {/exp:channel:entries}\n
    \n
    \n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (19, 1, 7, '_html-wrapper', 'webpage', NULL, '\n\n \n \n {layout:title}{site_name}\n \n\n \n {if layout:meta_author}{/if}\n {if layout:meta_description}{/if}\n\n \n \n \n {!-- square, 50*50 min --}\n\n {if layout:og_title != ''''}\n \n \n \n \n {/if}\n\n \n \n \n \n
    \n
    \n
    \n

    {site_name} Website

    \n
    \n
    \n {!-- creates a small menu link on smaller devices --}\n \n {!-- appears in both header and footer, so a snippet is used to keep it DRY --}\n {snp_main_nav}\n
    \n
    \n
    \n\n {layout:breadcrumbs}\n\n
    \n {layout:contents}\n
    \n\n
    \n
    \n {!-- appears in both header and footer, so a snippet is used to keep it DRY --}\n {snp_main_nav}\n

    ©{current_time format=''%Y''}, all rights reserved. Built with ExpressionEngine®

    \n
    \n
    \n \n \n \n \n {layout:scripts}\n \n\n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'), (20, 1, 7, '_blog-layout', 'webpage', NULL, '{layout=''layouts/_html-wrapper''}\n\n{!-- page vars (prefix p_) --}\n{preload_replace:p_url_cat=''category''}\n\n{!-- embed for breadcrumb, needed to pass arguments (embeds aren''t evil) --}\n{layout:set name=''breadcrumbs''}\n {embed=''common/_breadcrumb''\n p_url=''{layout:p_url}''\n p_title=''{layout:p_title}''\n {if layout:entry_ch}entry_ch=''{layout:entry_ch}''{/if}\n {if layout:search}search=''{layout:search}''{/if}\n {if layout:cat_ch}cat_ch=''{layout:cat_ch}''{/if}\n }\n{/layout:set}\n\n{layout:set name=''scripts''}\n \n {layout:scripts}\n{/layout:set}\n\n
    \n
    \n {layout:contents}\n
    \n
    \n
    \n {exp:search:simple_form\n form_class=''search''\n channel=''{layout:ch}''\n search_in=''everywhere''\n where=''all''\n result_page=''{layout:p_url}/search''\n no_result_page=''{layout:p_url}/no-results''\n results=''5''\n }\n \n {/exp:search:simple_form}\n

    Categories

    \n
      \n {exp:channel:categories channel=''{layout:ch}'' style=''linear''}\n
    • {category_name}
      • \n {/exp:channel:categories}\n
    \n

    RSS Feed

    \n \n
    \n\n
    \n
    \n', NULL, [[timestamp]], 0, 'n', 0, '', 'n', 'n', 'o', 0, 'n', 'y'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]templates_roles` -- CREATE TABLE `[[dbprefix]]templates_roles` ( `role_id` int(10) unsigned NOT NULL, `template_id` int(10) unsigned NOT NULL, PRIMARY KEY (`template_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `[[dbprefix]]templates_roles` -- INSERT INTO `[[dbprefix]]templates_roles` VALUES (1, 1), (2, 1), (3, 1), (4, 1), (5, 1), (1, 2), (2, 2), (3, 2), (4, 2), (5, 2), (1, 3), (2, 3), (3, 3), (4, 3), (5, 3), (1, 4), (2, 4), (3, 4), (4, 4), (5, 4), (1, 5), (2, 5), (3, 5), (4, 5), (5, 5), (1, 6), (2, 6), (3, 6), (4, 6), (5, 6), (1, 7), (2, 7), (3, 7), (4, 7), (5, 7), (1, 8), (2, 8), (3, 8), (4, 8), (5, 8), (1, 9), (2, 9), (3, 9), (4, 9), (5, 9), (1, 10), (2, 10), (3, 10), (4, 10), (5, 10), (1, 11), (2, 11), (3, 11), (4, 11), (5, 11), (1, 12), (2, 12), (3, 12), (4, 12), (5, 12), (1, 13), (2, 13), (3, 13), (4, 13), (5, 13), (1, 14), (2, 14), (3, 14), (4, 14), (5, 14), (1, 15), (2, 15), (3, 15), (4, 15), (5, 15), (1, 16), (2, 16), (3, 16), (4, 16), (5, 16), (1, 17), (2, 17), (3, 17), (4, 17), (5, 17), (1, 18), (2, 18), (3, 18), (4, 18), (5, 18), (1, 19), (2, 19), (3, 19), (4, 19), (5, 19), (1, 20), (2, 20), (3, 20), (4, 20), (5, 20); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]template_groups` -- CREATE TABLE `[[dbprefix]]template_groups` ( `group_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `group_order` int(3) unsigned NOT NULL, `is_site_default` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n', PRIMARY KEY (`group_id`), KEY `site_id` (`site_id`), KEY `group_name_idx` (`group_name`), KEY `group_order_idx` (`group_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ; -- -- Dumping data for table `[[dbprefix]]template_groups` -- INSERT INTO `[[dbprefix]]template_groups` VALUES (1, 1, 'pro-dashboard-widgets', 1, 'n'), (2, 1, 'about', 2, 'n'), (3, 1, 'home', 3, 'y'), (4, 1, 'common', 4, 'n'), (5, 1, 'contact', 5, 'n'), (6, 1, 'blog', 6, 'n'), (7, 1, 'layouts', 7, 'n'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]template_groups_roles` -- CREATE TABLE `[[dbprefix]]template_groups_roles` ( `role_id` int(10) unsigned NOT NULL, `template_group_id` mediumint(5) unsigned NOT NULL, PRIMARY KEY (`role_id`,`template_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]template_routes` -- CREATE TABLE `[[dbprefix]]template_routes` ( `route_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `template_id` int(10) unsigned NOT NULL, `order` int(10) unsigned DEFAULT NULL, `route` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `route_parsed` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `route_required` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n', PRIMARY KEY (`route_id`), KEY `template_id` (`template_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]throttle` -- CREATE TABLE `[[dbprefix]]throttle` ( `throttle_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `last_activity` bigint(10) unsigned NOT NULL DEFAULT '0', `hits` int(10) unsigned NOT NULL, `locked_out` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n', PRIMARY KEY (`throttle_id`), KEY `ip_address` (`ip_address`), KEY `last_activity` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]update_log` -- CREATE TABLE `[[dbprefix]]update_log` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `timestamp` int(10) unsigned DEFAULT NULL, `message` text COLLATE utf8mb4_unicode_ci, `method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `line` int(10) unsigned DEFAULT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`log_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `[[dbprefix]]update_log` -- INSERT INTO `[[dbprefix]]update_log` VALUES (1, [[timestamp]], 'Smartforge::add_key failed. Table ''[[dbprefix]]comments'' does not exist.', 'Smartforge::add_key', 106, '[[softpath]]/system/ee/ExpressionEngine/Addons/comment/upd.comment.php'), (2, [[timestamp]], 'Smartforge::add_key failed. Table ''[[dbprefix]]dock_prolets'' does not exist.', 'Smartforge::add_key', 210, '[[softpath]]/system/ee/ExpressionEngine/Addons/pro/upd.pro.php'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]upload_prefs` -- CREATE TABLE `[[dbprefix]]upload_prefs` ( `id` int(4) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `adapter` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local', `adapter_settings` text COLLATE utf8mb4_unicode_ci, `server_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `allowed_types` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'img', `allow_subfolders` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n', `subfolders_on_top` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'y', `default_modal_view` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'list', `max_size` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `max_height` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `max_width` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `properties` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pre_format` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `post_format` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file_properties` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file_pre_format` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file_post_format` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cat_group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `batch_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `module_id` int(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `site_id` (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ; -- -- Dumping data for table `[[dbprefix]]upload_prefs` -- INSERT INTO `[[dbprefix]]upload_prefs` VALUES (1, 1, 'Avatars', 'local', NULL, '{base_path}images/avatars/', '{base_url}images/avatars/', 'img', 'n', 'y', 'list', '50', '100', '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1), (2, 1, 'Signature Attachments', 'local', NULL, '{base_path}images/signature_attachments/', '{base_url}images/signature_attachments/', 'img', 'n', 'y', 'list', '30', '80', '480', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1), (3, 1, 'PM Attachments', 'local', NULL, '{base_path}images/pm_attachments/', '{base_url}images/pm_attachments/', 'img', 'n', 'y', 'list', '250', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1), (4, 1, 'Blog', 'local', NULL, '{base_path}themes/user/site/default/asset/img/blog/', '{base_url}themes/user/site/default/asset/img/blog/', 'img', 'n', 'y', 'list', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0), (5, 1, 'Common', 'local', NULL, '{base_path}themes/user/site/default/asset/img/common/', '{base_url}themes/user/site/default/asset/img/common/', 'img', 'n', 'y', 'list', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0), (6, 1, 'Home', 'local', NULL, '{base_path}themes/user/site/default/asset/img/home/', '{base_url}themes/user/site/default/asset/img/home/', 'img', 'n', 'y', 'list', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]upload_prefs_category_groups` -- CREATE TABLE `[[dbprefix]]upload_prefs_category_groups` ( `upload_location_id` int(4) unsigned NOT NULL, `group_id` int(6) unsigned NOT NULL, PRIMARY KEY (`upload_location_id`,`group_id`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]upload_prefs_roles` -- CREATE TABLE `[[dbprefix]]upload_prefs_roles` ( `role_id` int(10) unsigned NOT NULL, `upload_id` int(4) unsigned NOT NULL, PRIMARY KEY (`upload_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;