--
-- New data for table `pages`
--

INSERT INTO `pages` (`created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `url`, `settings`, `content`, `seo`, `page_key`, `status`, `custom`) VALUES
(CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'Tools', 'tools', NULL, '{\"header\":{\"upper_title\":\"[lang]lang.tools_header_upper_title[\\/lang]\",\"title\":\"[lang]lang.tools_header_title[\\/lang]\",\"bg_image\":\"widget_X5uDIFwHQ1BFHNZoGYGE3O8XepZM990ND.webp\"}}', '{\"title\":\"Tools\",\"keywords\":\"tools, key\",\"description\":\"Tools description\",\"no_index\":\"1\",\"og_title\":\"Tools og title\",\"og_description\":\"Tools og description\",\"og_image\":null}', 'tools', 1, 0);

--
-- Update data for table `pages`
--

UPDATE `pages` SET `url` = 'convert' WHERE `page_key` = 'tools_convert';
UPDATE `pages` SET `url` = 'compress' WHERE `page_key` = 'tools_compress';
UPDATE `pages` SET `url` = 'resize' WHERE `page_key` = 'tools_resize';
UPDATE `pages` SET `url` = 'rotate-reflect' WHERE `page_key` = 'tools_rotate_reflect';
UPDATE `pages` SET `url` = 'watermark' WHERE `page_key` = 'tools_watermark';
UPDATE `pages` SET `url` = 'preferences' WHERE `page_key` = 'tools_preferences';
UPDATE `pages` SET `url` = 'effects' WHERE `page_key` = 'tools_effects';
UPDATE `pages` SET `url` = 'exif-cleaner' WHERE `page_key` = 'tools_exif_cleaner';
UPDATE `pages` SET `url` = 'autoremove' WHERE `page_key` = 'tools_autoremove';
UPDATE `pages` SET `url` = 'password' WHERE `page_key` = 'tools_password';

--
-- New data for table `settings`
--

INSERT INTO `settings` (`created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`, `additional`) VALUES
(CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'default_color_mode', '1', NULL);

--
-- New table `settings_tools`
--

CREATE TABLE `settings_tools` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings_tools` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`) VALUES
(1, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'convert', '1'),
(2, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'compress', '1'),
(3, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'resize', '1'),
(4, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'rotate_reflect', '1'),
(5, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'watermark', '1'),
(6, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'preferences', '1'),
(7, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'effects', '1'),
(8, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'exif_cleaner', '1'),
(9, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'autoremove', '1'),
(10, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'password', '1');

ALTER TABLE `settings_tools`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `settings_tools`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;
  
--
-- New table `tool_stats`
--

CREATE TABLE `tool_stats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `created_by_ip` varchar(45) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` int(11) NOT NULL,
  `updated_by_ip` varchar(45) NOT NULL,
  `name` varchar(250) NOT NULL,
  `value` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `tool_stats` (`id`, `created_at`, `created_by_id`, `created_by_ip`, `updated_at`, `updated_by_id`, `updated_by_ip`, `name`, `value`) VALUES
(1, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'convert', 0),
(2, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'compress', 0),
(3, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'resize', 0),
(4, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'rotate_reflect', 0),
(5, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'watermark', 0),
(6, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'preferences', 0),
(7, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'effects', 0),
(8, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'exif_cleaner', 0),
(9, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'autoremove', 0),
(10, CURRENT_TIMESTAMP(), 1, '192.168.1.1', CURRENT_TIMESTAMP(), 1, '192.168.1.1', 'password', 0);

ALTER TABLE `tool_stats`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tool_stats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;
