66ana_fixed_sql

CREATE TABLE `users` (
`user_id` INT NOT NULL AUTO_INCREMENT,
`email` VARCHAR(320) NOT NULL,
`password` VARCHAR(128) DEFAULT NULL,
`name` VARCHAR(64) NOT NULL,
`avatar` VARCHAR(40) DEFAULT NULL,
`billing` text,
`api_key` VARCHAR(32) DEFAULT NULL,
`token_code` VARCHAR(32) DEFAULT NULL,
`twofa_secret` VARCHAR(32) DEFAULT NULL,
`anti_phishing_code` VARCHAR(8) DEFAULT NULL,
`one_time_login_code` VARCHAR(32) DEFAULT NULL,
`pending_email` VARCHAR(128) DEFAULT NULL,
`email_activation_code` VARCHAR(32) DEFAULT NULL,
`lost_password_code` VARCHAR(32) DEFAULT NULL,
`type` tinyint NOT NULL DEFAULT 0,
`status` tinyint NOT NULL DEFAULT 0,
`is_newsletter_subscribed` tinyint NOT NULL DEFAULT 0,
`has_pending_internal_notifications` tinyint NOT NULL DEFAULT 0,
`plan_id` VARCHAR(16) NOT NULL DEFAULT 0,
`plan_expiration_date` datetime DEFAULT NULL,
`plan_settings` text,
`plan_trial_done` tinyint DEFAULT '0',
`plan_expiry_reminder` tinyint DEFAULT '0',
`payment_subscription_id` VARCHAR(64) DEFAULT NULL,
`payment_processor` VARCHAR(16) DEFAULT NULL,
`payment_total_amount` FLOAT DEFAULT NULL,
`payment_currency` VARCHAR(4) DEFAULT NULL,
`referral_key` VARCHAR(32) DEFAULT NULL,
`referred_by` VARCHAR(32) DEFAULT NULL,
`referred_by_has_converted` tinyint DEFAULT '0',
`language` VARCHAR(32) DEFAULT 'english',
`currency` VARCHAR(4) DEFAULT NULL,
`timezone` VARCHAR(32) DEFAULT 'UTC',
`preferences` text,
`extra` text,
`datetime` datetime DEFAULT NULL,
`next_cleanup_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
`ip` VARCHAR(64) DEFAULT NULL,
`continent_code` ENUM('AF', 'AN', 'AS', 'EU', 'NA', 'OC', 'SA') DEFAULT NULL,
`country` VARCHAR(8) DEFAULT NULL,
`city_name` VARCHAR(32) DEFAULT NULL,
`device_type` enum('mobile', 'tablet', 'desktop') DEFAULT NULL,
`browser_language` VARCHAR(32) DEFAULT NULL,
`browser_name` VARCHAR(32) DEFAULT NULL,
`os_name` VARCHAR(16) DEFAULT NULL,
`last_activity` datetime DEFAULT NULL,
`total_logins` INT DEFAULT '0',
`user_deletion_reminder` tinyint(4) DEFAULT '0',
`source` VARCHAR(32) DEFAULT 'direct',
PRIMARY KEY (`user_id`),
KEY `plan_id` (`plan_id`),
KEY `api_key` (`api_key`),
KEY `idx_users_next_cleanup_datetime` (`next_cleanup_datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


INSERT INTO `users` (`user_id`, `email`, `password`, `api_key`, `referral_key`, `name`, `type`, `status`, `plan_id`, `plan_expiration_date`, `plan_settings`, `datetime`, `ip`, `last_activity`)
VALUES (1,'admin','$2y$10$uFNO0pQKEHSFcus1zSFlveiPCB3EvG9ZlES7XKgJFTAl5JbRGFCWy', md5(rand()), md5(rand()), 'AltumCode',1,1,'custom','2030-01-01 12:00:00', '{"no_ads":true,"email_reports_is_enabled":true,"teams_is_enabled":true,"websites_limit":-1,"sessions_events_limit":-1,"events_children_limit":-1,"events_children_retention":365,"sessions_replays_limit":-1,"sessions_replays_retention":30,"sessions_replays_time_limit":60,"websites_heatmaps_limit":-1,"websites_goals_limit":-1,"api_is_enabled":true,"affiliate_is_enabled":true}', NOW(),'',NOW());

-- SEPARATOR --


CREATE TABLE `users_logs` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT DEFAULT NULL,
`type` VARCHAR(64) DEFAULT NULL,
`ip` VARCHAR(64) DEFAULT NULL,
`device_type` enum('mobile', 'tablet', 'desktop') DEFAULT NULL,
`os_name` VARCHAR(16) DEFAULT NULL,
`continent_code` ENUM('AF', 'AN', 'AS', 'EU', 'NA', 'OC', 'SA') DEFAULT NULL,
`country_code` VARCHAR(8) DEFAULT NULL,
`city_name` VARCHAR(32) DEFAULT NULL,
`browser_language` VARCHAR(32) DEFAULT NULL,
`browser_name` VARCHAR(32) DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `users_logs_user_id` (`user_id`),
KEY `users_logs_ip_type_datetime_index` (`ip`,`type`,`datetime`),
CONSTRAINT `users_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `plans` (
`plan_id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(64) NOT NULL DEFAULT 0,
`description` VARCHAR(256) NOT NULL DEFAULT 0,
`translations` text NOT NULL,
`prices` text NOT NULL,
`trial_days` INT UNSIGNED NOT NULL DEFAULT '0',
`settings` longtext NOT NULL,
`taxes_ids` text,
`color` VARCHAR(16) DEFAULT NULL,
`status` tinyint(4) NOT NULL,
`order` INT(10) UNSIGNED DEFAULT '0',
`datetime` datetime NOT NULL,
PRIMARY KEY (`plan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- SEPARATOR --


CREATE TABLE `pages_categories` (
`pages_category_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`url` VARCHAR(256) NOT NULL,
`title` VARCHAR(256) NOT NULL DEFAULT 0,
`description` VARCHAR(256) DEFAULT NULL,
`icon` VARCHAR(32) DEFAULT NULL,
`order` INT NOT NULL DEFAULT '0',
`language` VARCHAR(32) DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
`last_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`pages_category_id`),
KEY `url` (`url`),
KEY `pages_categories_url_language_index` (`url`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;


CREATE TABLE `pages` (
`page_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`pages_category_id` BIGINT UNSIGNED DEFAULT NULL,
`url` VARCHAR(256) NOT NULL,
`title` VARCHAR(256) NOT NULL DEFAULT 0,
`description` VARCHAR(256) DEFAULT NULL,
`icon` VARCHAR(32) DEFAULT NULL,
`keywords` VARCHAR(256) CHARACTER SET utf8mb4 DEFAULT NULL,
`editor` VARCHAR(16) DEFAULT NULL,
`content` longtext,
`type` enum('internal', 'external') DEFAULT 'internal',
`position` VARCHAR(16) NOT NULL DEFAULT 0,
`language` VARCHAR(32) DEFAULT NULL,
`open_in_new_tab` tinyint DEFAULT '1',
`order` INT DEFAULT '0',
`total_views` BIGINT UNSIGNED DEFAULT '0',
`is_published` tinyint DEFAULT '1',
`datetime` datetime DEFAULT NULL,
`last_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`page_id`),
KEY `pages_pages_category_id_index` (`pages_category_id`),
KEY `pages_url_index` (`url`),
KEY `pages_is_published_index` (`is_published`),
KEY `pages_language_index` (`language`),
CONSTRAINT `pages_ibfk_1` FOREIGN KEY (`pages_category_id`) REFERENCES `pages_categories` (`pages_category_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


INSERT INTO `pages` (`pages_category_id`, `url`, `title`, `description`, `content`, `type`, `position`, `order`, `total_views`, `datetime`, `last_datetime`) VALUES
(NULL, 'https://altumcode.com/', 'Software by AltumCode', '', '', 'external', 'bottom', 1, 0, NOW(), NOW()),
(NULL, 'https://altumco.de/66analytics', 'Built with 66Analytics', '', '', 'external', 'bottom', 0, 0, NOW(), NOW());

-- SEPARATOR --


CREATE TABLE `blog_posts_categories` (
`blog_posts_category_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`url` VARCHAR(256) NOT NULL,
`title` VARCHAR(256) NOT NULL DEFAULT 0,
`description` VARCHAR(256) DEFAULT NULL,
`order` INT NOT NULL DEFAULT '0',
`language` VARCHAR(32) DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
`last_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`blog_posts_category_id`),
KEY `url` (`url`),
KEY `blog_posts_categories_url_language_index` (`url`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- SEPARATOR --


CREATE TABLE `blog_posts` (
`blog_post_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`blog_posts_category_id` BIGINT UNSIGNED DEFAULT 0,
`url` VARCHAR(256) NOT NULL,
`title` VARCHAR(256) NOT NULL DEFAULT 0,
`description` VARCHAR(256) DEFAULT NULL,
`image_description` VARCHAR(256) DEFAULT NULL,
`keywords` VARCHAR(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`image` VARCHAR(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`editor` VARCHAR(16) DEFAULT NULL,
`content` longtext,
`language` VARCHAR(32) DEFAULT NULL,
`total_views` BIGINT UNSIGNED DEFAULT '0',
`average_rating` FLOAT UNSIGNED NOT NULL DEFAULT 0,
`total_ratings` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`is_published` tinyint DEFAULT '1',
`datetime` datetime DEFAULT NULL,
`last_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`blog_post_id`),
KEY `blog_post_id_index` (`blog_post_id`),
KEY `blog_post_url_index` (`url`),
KEY `blog_posts_category_id` (`blog_posts_category_id`),
KEY `blog_posts_is_published_index` (`is_published`),
KEY `blog_posts_language_index` (`language`),
CONSTRAINT `blog_posts_ibfk_1` FOREIGN KEY (`blog_posts_category_id`) REFERENCES `blog_posts_categories` (`blog_posts_category_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `blog_posts_ratings` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`blog_post_id` BIGINT UNSIGNED DEFAULT 0,
`user_id` INT DEFAULT NULL,
`ip_binary` varbinary(16) DEFAULT NULL,
`rating` tinyint(1) DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `blog_posts_ratings_blog_post_id_ip_binary_idx` (`blog_post_id`,`ip_binary`) USING BTREE,
KEY `user_id` (`user_id`),
CONSTRAINT `blog_posts_ratings_ibfk_1` FOREIGN KEY (`blog_post_id`) REFERENCES `blog_posts` (`blog_post_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `blog_posts_ratings_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `websites` (
`website_id` INT NOT NULL AUTO_INCREMENT,
`pixel_key` VARCHAR(16) NOT NULL DEFAULT 0,
`user_id` INT NOT NULL,
`domain_id` INT DEFAULT NULL,
`name` VARCHAR(256) NOT NULL DEFAULT 0,
`scheme` VARCHAR(8) NOT NULL DEFAULT 0,
`host` VARCHAR(128) NOT NULL DEFAULT 0,
`path` VARCHAR(256) DEFAULT NULL,
`tracking_type` enum('normal', 'lightweight') DEFAULT 'normal',
`ip_storage_is_enabled` tinyint UNSIGNED NOT NULL DEFAULT '0',
`excluded_ips` text,
`query_parameters_tracking_is_enabled` tinyint DEFAULT '0',
`bot_exclusion_is_enabled` tinyint DEFAULT '1',
`current_month_sessions_events` BIGINT UNSIGNED NOT NULL DEFAULT '0',
`current_month_events_children` BIGINT UNSIGNED NOT NULL DEFAULT '0',
`current_month_sessions_replays` BIGINT UNSIGNED NOT NULL DEFAULT '0',
`plan_sessions_events_limit_notice` tinyint DEFAULT '0',
`plan_events_children_limit_notice` tinyint DEFAULT '0',
`plan_sessions_replays_limit_notice` tinyint DEFAULT '0',
`events_children_is_enabled` tinyint(4) NOT NULL DEFAULT '1',
`sessions_replays_is_enabled` tinyint(4) NOT NULL DEFAULT '0',
`email_reports_is_enabled` tinyint(4) NOT NULL DEFAULT '0',
`email_reports_last_date` datetime DEFAULT NULL,
`public_statistics_is_enabled` tinyint(4) NOT NULL DEFAULT '0',
`public_statistics_password` VARCHAR(128) DEFAULT NULL,
`is_enabled` tinyint(4) NOT NULL DEFAULT '0',
`datetime` datetime NOT NULL,
`last_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`website_id`),
KEY `user_id` (`user_id`),
KEY `pixel` (`pixel_key`),
KEY `host` (`host`),
CONSTRAINT `websites_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `domains` (
`domain_id` INT NOT NULL AUTO_INCREMENT,
`user_id` INT DEFAULT NULL,
`scheme` VARCHAR(8) NOT NULL DEFAULT 0,
`host` VARCHAR(128) NOT NULL DEFAULT 0,
`custom_index_url` VARCHAR(256) DEFAULT NULL,
`custom_not_found_url` VARCHAR(256) DEFAULT NULL,
`is_enabled` tinyint(4) DEFAULT '0',
`datetime` datetime DEFAULT NULL,
`last_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`domain_id`),
KEY `user_id` (`user_id`),
KEY `host` (`host`),
CONSTRAINT `domains_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- SEPARATOR --


ALTER TABLE websites ADD CONSTRAINT websites_domains_domain_id_fk FOREIGN KEY (domain_id) REFERENCES domains (domain_id) ON UPDATE cascade ON DELETE SET NULL;

-- SEPARATOR --


CREATE TABLE `lightweight_events` (
`event_id` INT NOT NULL AUTO_INCREMENT,
`website_id` INT NOT NULL,
`type` enum('landing_page', 'pageview') DEFAULT NULL,
`path` VARCHAR(1024) DEFAULT NULL,
`referrer_host` VARCHAR(256) DEFAULT NULL,
`referrer_path` VARCHAR(1024) DEFAULT NULL,
`utm_source` VARCHAR(128) DEFAULT NULL,
`utm_medium` VARCHAR(128) DEFAULT NULL,
`utm_campaign` VARCHAR(128) DEFAULT NULL,
`continent_code` ENUM('AF', 'AN', 'AS', 'EU', 'NA', 'OC', 'SA') DEFAULT NULL,
`country_code` VARCHAR(8) DEFAULT NULL,
`city_name` VARCHAR(128) DEFAULT NULL,
`os_name` VARCHAR(32) DEFAULT NULL,
`browser_name` VARCHAR(32) DEFAULT NULL,
`browser_language` VARCHAR(16) DEFAULT NULL,
`browser_timezone` VARCHAR(32) DEFAULT NULL,
`screen_resolution` VARCHAR(16) DEFAULT NULL,
`device_type` enum('mobile', 'tablet', 'desktop') DEFAULT NULL,
`theme` enum('light', 'dark') DEFAULT NULL,
`date` datetime DEFAULT NULL,
`expiration_date` DATE DEFAULT NULL,
PRIMARY KEY (`event_id`),
KEY `website_id` (`website_id`),
KEY `date` (`date`) USING BTREE,
KEY `expiration_date` (`expiration_date`),
CONSTRAINT `lightweight_events_ibfk_1` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- SEPARATOR --


CREATE TABLE `teams` (
`team_id` INT NOT NULL AUTO_INCREMENT,
`user_id` INT NOT NULL,
`name` VARCHAR(32) DEFAULT NULL,
`websites_ids` text,
`last_datetime` datetime DEFAULT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`team_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `teams_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `teams_associations` (
`team_association_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`team_id` INT NOT NULL,
`user_id` INT DEFAULT NULL,
`user_email` VARCHAR(128) DEFAULT NULL,
`is_accepted` tinyint(4) NOT NULL DEFAULT '0',
`date` datetime NOT NULL,
`accepted_date` datetime DEFAULT NULL,
PRIMARY KEY (`team_association_id`),
KEY `team_id` (`team_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `teams_associations_ibfk_1` FOREIGN KEY (`team_id`) REFERENCES `teams` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `teams_associations_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `websites_visitors` (
`visitor_id` INT NOT NULL AUTO_INCREMENT,
`visitor_uuid_binary` BINARY(16) DEFAULT NULL,
`website_id` INT NOT NULL,
`goals_conversions_ids` text DEFAULT NULL,
`ip` VARCHAR(64) DEFAULT NULL,
`custom_parameters` text,
`continent_code` ENUM('AF', 'AN', 'AS', 'EU', 'NA', 'OC', 'SA') DEFAULT NULL,
`country_code` VARCHAR(8) DEFAULT NULL,
`city_name` VARCHAR(128) DEFAULT NULL,
`os_name` VARCHAR(32) DEFAULT NULL,
`os_version` VARCHAR(16) DEFAULT NULL,
`browser_name` VARCHAR(32) DEFAULT NULL,
`browser_version` VARCHAR(16) DEFAULT NULL,
`browser_language` VARCHAR(16) DEFAULT NULL,
`browser_timezone` VARCHAR(32) DEFAULT NULL,
`screen_resolution` VARCHAR(16) DEFAULT NULL,
`device_type` enum('mobile', 'tablet', 'desktop') DEFAULT NULL,
`theme` enum('light', 'dark') DEFAULT NULL,
`total_sessions` INT DEFAULT '0',
`last_event_id` INT DEFAULT NULL,
`date` datetime NOT NULL,
`last_date` datetime DEFAULT NULL,
PRIMARY KEY (`visitor_id`),
UNIQUE KEY `websites_visitors_pk` (`visitor_uuid_binary`),
KEY `website_id` (`website_id`),
CONSTRAINT `websites_visitors_ibfk_1` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `visitors_sessions` (
`session_id` INT NOT NULL AUTO_INCREMENT,
`session_uuid_binary` BINARY(16) DEFAULT NULL,
`visitor_id` INT NOT NULL,
`website_id` INT NOT NULL,
`total_events` INT DEFAULT '1',
`date` datetime NOT NULL,
PRIMARY KEY (`session_id`),
UNIQUE KEY `session_uuid_binary` (`session_uuid_binary`),
KEY `website_id` (`website_id`),
KEY `visitor_id` (`visitor_id`),
KEY `session_id` (`session_id`),
KEY `date` (`date`),
CONSTRAINT `visitors_sessions_ibfk_1` FOREIGN KEY (`visitor_id`) REFERENCES `websites_visitors` (`visitor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `visitors_sessions_ibfk_2` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ROW_FORMAT=DYNAMIC ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `sessions_events` (
`event_id` INT NOT NULL AUTO_INCREMENT,
`event_uuid_binary` BINARY(16) DEFAULT NULL,
`session_id` INT NOT NULL,
`visitor_id` INT NOT NULL,
`website_id` INT NOT NULL,
`type` enum('landing_page', 'pageview') NOT NULL DEFAULT 'pageview',
`path` VARCHAR(1024) NOT NULL DEFAULT '',
`title` VARCHAR(512) DEFAULT NULL,
`referrer_host` VARCHAR(256) DEFAULT NULL,
`referrer_path` VARCHAR(1024) DEFAULT NULL,
`utm_source` VARCHAR(128) DEFAULT NULL,
`utm_medium` VARCHAR(128) DEFAULT NULL,
`utm_campaign` VARCHAR(128) DEFAULT NULL,
`viewport_width` INT DEFAULT NULL,
`viewport_height` INT DEFAULT NULL,
`has_bounced` INT DEFAULT NULL,
`date` datetime NOT NULL,
`expiration_date` DATE DEFAULT NULL,
PRIMARY KEY (`event_id`),
KEY `visitor_id` (`visitor_id`),
KEY `session_id` (`session_id`),
KEY `event_uuid_binary` (`event_uuid_binary`),
KEY `date` (`date`),
KEY `expiration_date` (`expiration_date`),
KEY `website_id` (`website_id`),
CONSTRAINT `sessions_events_ibfk_1` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `sessions_events_ibfk_2` FOREIGN KEY (`visitor_id`) REFERENCES `websites_visitors` (`visitor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `sessions_events_ibfk_3` FOREIGN KEY (`session_id`) REFERENCES `visitors_sessions` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `events_children` (
`id` INT NOT NULL AUTO_INCREMENT,
`event_id` INT NOT NULL,
`session_id` INT NOT NULL,
`visitor_id` INT NOT NULL,
`snapshot_id` INT DEFAULT NULL,
`website_id` INT NOT NULL,
`type` enum('click', 'scroll', 'form', 'resize') NOT NULL DEFAULT 'click',
`data` longtext,
`count` INT DEFAULT '1',
`date` datetime NOT NULL,
`expiration_date` DATE DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `visitor_id` (`visitor_id`),
KEY `website_id` (`website_id`),
KEY `session_id` (`session_id`),
KEY `event_uuid` (`event_id`),
KEY `snapshot_id` (`snapshot_id`),
KEY `expiration_date` (`expiration_date`),
CONSTRAINT `events_children_ibfk_1` FOREIGN KEY (`visitor_id`) REFERENCES `websites_visitors` (`visitor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `events_children_ibfk_2` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `events_children_ibfk_3` FOREIGN KEY (`session_id`) REFERENCES `visitors_sessions` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `sessions_replays` (
`replay_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT DEFAULT NULL,
`session_id` INT NOT NULL,
`visitor_id` INT NOT NULL,
`website_id` INT NOT NULL,
`events` INT DEFAULT NULL,
`size` BIGINT UNSIGNED NOT NULL DEFAULT '0',
`is_offloaded` tinyint DEFAULT '0',
`is_too_short` tinyint DEFAULT 1,
`datetime` datetime NOT NULL,
`last_datetime` datetime DEFAULT NULL,
`expiration_date` DATE DEFAULT NULL,
PRIMARY KEY (`replay_id`),
UNIQUE KEY `sessions_replays_pk` (`session_id`),
KEY `session_id` (`session_id`),
KEY `visitor_id` (`visitor_id`),
KEY `website_id` (`website_id`),
KEY `expiration_date` (`expiration_date`),
KEY `sessions_replays_users_user_id_fk` (`user_id`),
CONSTRAINT `sessions_replays_ibfk_1` FOREIGN KEY (`session_id`) REFERENCES `visitors_sessions` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `sessions_replays_ibfk_2` FOREIGN KEY (`visitor_id`) REFERENCES `websites_visitors` (`visitor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `sessions_replays_ibfk_3` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `sessions_replays_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `websites_heatmaps` (
`heatmap_id` INT NOT NULL AUTO_INCREMENT,
`user_id` INT DEFAULT NULL,
`website_id` INT NOT NULL,
`snapshot_id_desktop` INT DEFAULT NULL,
`desktop_size` BIGINT UNSIGNED NOT NULL DEFAULT '0',
`snapshot_id_tablet` INT DEFAULT NULL,
`tablet_size` BIGINT UNSIGNED NOT NULL DEFAULT '0',
`snapshot_id_mobile` INT DEFAULT NULL,
`mobile_size` BIGINT UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0,
`path` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0,
`is_enabled` tinyint NOT NULL DEFAULT '1',
`last_datetime` datetime DEFAULT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`heatmap_id`),
KEY `website_id` (`website_id`),
KEY `snapshot_id_desktop` (`snapshot_id_desktop`),
KEY `snapshot_id_tablet` (`snapshot_id_tablet`),
KEY `snapshot_id_mobile` (`snapshot_id_mobile`),
KEY `websites_heatmaps_users_user_id_fk` (`user_id`),
CONSTRAINT `websites_heatmaps_ibfk_1` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `websites_heatmaps_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `heatmaps_snapshots` (
`snapshot_id` INT NOT NULL AUTO_INCREMENT,
`heatmap_id` INT NOT NULL,
`website_id` INT NOT NULL,
`type` enum('desktop', 'mobile', 'tablet') NOT NULL,
`data` longblob NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`snapshot_id`),
KEY `heatmap_id` (`heatmap_id`),
KEY `website_id` (`website_id`),
KEY `type` (`type`),
CONSTRAINT `heatmaps_snapshots_ibfk_1` FOREIGN KEY (`heatmap_id`) REFERENCES `websites_heatmaps` (`heatmap_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `heatmaps_snapshots_ibfk_2` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


ALTER TABLE events_children ADD CONSTRAINT events_children_heatmaps_snapshots_snapshot_id_fk FOREIGN KEY (snapshot_id) REFERENCES heatmaps_snapshots (snapshot_id) ON UPDATE cascade ON DELETE SET NULL;

-- SEPARATOR --


ALTER TABLE websites_heatmaps ADD CONSTRAINT `websites_heatmaps_ibfk_2` FOREIGN KEY (`snapshot_id_desktop`) REFERENCES `heatmaps_snapshots` (`snapshot_id`) ON DELETE SET NULL ON UPDATE CASCADE;

-- SEPARATOR --


ALTER TABLE websites_heatmaps ADD  CONSTRAINT `websites_heatmaps_ibfk_3` FOREIGN KEY (`snapshot_id_tablet`) REFERENCES `heatmaps_snapshots` (`snapshot_id`) ON DELETE SET NULL ON UPDATE CASCADE;

-- SEPARATOR --


ALTER TABLE websites_heatmaps ADD  CONSTRAINT `websites_heatmaps_ibfk_4` FOREIGN KEY (`snapshot_id_mobile`) REFERENCES `heatmaps_snapshots` (`snapshot_id`) ON DELETE SET NULL ON UPDATE CASCADE;

-- SEPARATOR --


CREATE TABLE `websites_goals` (
`goal_id` INT NOT NULL AUTO_INCREMENT,
`website_id` INT NOT NULL,
`key` VARCHAR(16) NOT NULL DEFAULT 0,
`type` enum('pageview', 'custom') NOT NULL DEFAULT 'pageview',
`path` VARCHAR(256) DEFAULT NULL,
`name` VARCHAR(64) DEFAULT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`goal_id`),
KEY `website_id` (`website_id`),
KEY `key` (`key`),
CONSTRAINT `websites_goals_ibfk_1` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `goals_conversions` (
`conversion_id` INT NOT NULL AUTO_INCREMENT,
`event_id` INT DEFAULT NULL,
`session_id` INT DEFAULT NULL,
`visitor_id` INT DEFAULT NULL,
`goal_id` INT NOT NULL,
`website_id` INT NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`conversion_id`),
KEY `event_id` (`event_id`),
KEY `session_id` (`session_id`),
KEY `visitor_id` (`visitor_id`),
KEY `goal_id` (`goal_id`),
KEY `website_id` (`website_id`),
KEY `date` (`date`),
CONSTRAINT `goals_conversions_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `sessions_events` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `goals_conversions_ibfk_2` FOREIGN KEY (`session_id`) REFERENCES `visitors_sessions` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `goals_conversions_ibfk_3` FOREIGN KEY (`visitor_id`) REFERENCES `websites_visitors` (`visitor_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `goals_conversions_ibfk_4` FOREIGN KEY (`goal_id`) REFERENCES `websites_goals` (`goal_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `goals_conversions_ibfk_5` FOREIGN KEY (`website_id`) REFERENCES `websites` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `email_reports` (
`id` BIGINT  UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT NOT NULL,
`website_id` INT NOT NULL,
`datetime` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `website_id` (`website_id`),
KEY `datetime` (`datetime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `broadcasts` (
`broadcast_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(64) DEFAULT NULL,
`subject` VARCHAR(128) DEFAULT NULL,
`content` text,
`segment` VARCHAR(64) DEFAULT NULL,
`settings` text COLLATE utf8mb4_unicode_ci,
`users_ids` longtext CHARACTER SET utf8mb4,
`sent_users_ids` longtext,
`sent_emails` INT UNSIGNED DEFAULT '0',
`total_emails` INT UNSIGNED DEFAULT '0',
`status` VARCHAR(16) DEFAULT NULL,
`views` BIGINT UNSIGNED DEFAULT '0',
`clicks` BIGINT UNSIGNED DEFAULT '0',
`last_sent_email_datetime` datetime DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
`last_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`broadcast_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `broadcasts_statistics` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT DEFAULT NULL,
`broadcast_id` BIGINT UNSIGNED DEFAULT 0,
`type` enum('view', 'click') COLLATE utf8mb4_unicode_ci,
`target` VARCHAR(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `broadcast_id` (`broadcast_id`),
KEY `broadcasts_statistics_user_id_broadcast_id_type_index` (`broadcast_id`,`user_id`,`type`),
CONSTRAINT `broadcasts_statistics_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `broadcasts_statistics_ibfk_2` FOREIGN KEY (`broadcast_id`) REFERENCES `broadcasts` (`broadcast_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `internal_notifications` (
`internal_notification_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT DEFAULT NULL,
`for_who` VARCHAR(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`from_who` VARCHAR(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icon` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` VARCHAR(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_read` tinyint UNSIGNED DEFAULT '0',
`datetime` datetime DEFAULT NULL,
`read_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`internal_notification_id`),
KEY `user_id` (`user_id`),
KEY `users_notifications_for_who_idx` (`for_who`) USING BTREE,
CONSTRAINT `internal_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


CREATE TABLE `settings` (
`id` INT NOT NULL AUTO_INCREMENT,
`key` VARCHAR(64) NOT NULL DEFAULT 0,
`value` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- SEPARATOR --


SET @cron_key = MD5(RAND());

-- SEPARATOR --


INSERT INTO `settings` (`key`, `value`)
VALUES
('main', '{"title":"Your title","default_language":"english","default_theme_style":"light","default_timezone":"UTC","index_url":"","terms_and_conditions_url":"","privacy_policy_url":"","not_found_url":"","se_indexing":true,"ai_scraping_is_allowed":true,"display_index_plans":true,"display_index_testimonials":true,"display_index_faq":true,"default_results_per_page":100,"default_order_type":"DESC","auto_language_detection_is_enabled":true,"blog_is_enabled":false,"api_is_enabled":true,"theme_style_change_is_enabled":true,"logo_light":"","logo_dark":"","logo_email":"","opengraph":"","favicon":"","openai_api_key":"","openai_model":"gpt-3.5-turbo","force_https_is_enabled":false,"broadcasts_statistics_is_enabled":false,"breadcrumbs_is_enabled":true,"display_pagination_when_no_pages":true}'),
('languages', '{"english":{"status":"active"}}'),
('users', '{\"email_confirmation\":false,\"login_lockout_time\":60,\"blacklisted_domains\":[],\"register_is_enabled\":true,\"blacklisted_countries\":[],\"register_lockout_time\":10,\"user_deletion_reminder\":0,\"login_lockout_is_enabled\":true,\"welcome_email_is_enabled\":false,\"login_lockout_max_retries\":3,\"auto_delete_inactive_users\":90,\"lost_password_lockout_time\":60,\"register_lockout_is_enabled\":true,\"register_only_social_logins\":false,\"auto_delete_unconfirmed_users\":30,\"resend_activation_lockout_time\":60,\"lost_password_lockout_is_enabled\":true,\"lost_password_lockout_max_retries\":3,\"register_lockout_max_registrations\":3,\"login_rememberme_checkbox_is_checked\":false,\"register_display_newsletter_checkbox\":false,\"resend_activation_lockout_is_enabled\":true,\"resend_activation_lockout_max_retries\":3}'),
('ads', '{"ad_blocker_detector_is_enabled":true,"ad_blocker_detector_lock_is_enabled":false,"ad_blocker_detector_delay":5,"header":"","footer":"","header_biolink":"","footer_biolink":"","header_splash":"","footer_splash":""}'),
('captcha', '{"type":"basic","recaptcha_public_key":"","recaptcha_private_key":"","login_is_enabled":0,"register_is_enabled":0,"lost_password_is_enabled":0,"resend_activation_is_enabled":0}'),
('cron', concat('{\"key\":\"', @cron_key, '\"}')),
('email_notifications', '{"emails":"","new_user":false,"delete_user":false,"new_payment":false,"new_domain":false,"new_affiliate_withdrawal":false,"contact":false}'),
('internal_notifications', '{"users_is_enabled":true,"admins_is_enabled":true,"new_user":true,"delete_user":true,"new_newsletter_subscriber":true,"new_payment":true,"new_affiliate_withdrawal":true}'),
('content', '{"blog_is_enabled":true,"blog_share_is_enabled":true,"blog_categories_widget_is_enabled":true,"blog_popular_widget_is_enabled":true,"blog_views_is_enabled":true,"pages_is_enabled":true,"pages_share_is_enabled":true,"pages_popular_widget_is_enabled":true,"pages_views_is_enabled":true}'),
('sso', '{"is_enabled":true,"display_menu_items":true,"websites":{}}'),
('facebook', '{"is_enabled":false,"app_id":"","app_secret":""}'),
('google', '{"is_enabled":false,"client_id":"","client_secret":""}'),
('twitter', '{"is_enabled":false,"consumer_api_key":"","consumer_api_secret":""}'),
('discord', '{"is_enabled":false,"client_id":"","client_secret":""}'),
('linkedin', '{"is_enabled":false,"client_id":"","client_secret":""}'),
('microsoft', '{"is_enabled":false,"client_id":"","client_secret":""}'),
('plan_custom', '{"plan_id":"custom","name":"Custom","description":"Contact us for enterprise pricing.","price":"Custom","custom_button_url":"mailto:[email protected]","color":null,"status":2,"settings":{}}'),
('plan_free', '{"plan_id":"free","name":"Free","days":null,"status":0,"settings":{"no_ads":false,"email_reports_is_enabled":false,"teams_is_enabled":false,"websites_limit":1,"sessions_events_limit":15000,"events_children_limit":10000,"events_children_retention":90,"sessions_replays_limit":25,"sessions_replays_retention":30,"sessions_replays_time_limit":30,"websites_heatmaps_limit":1,"websites_goals_limit":10,"api_is_enabled":false,"affiliate_is_enabled":false}}'),
('payment', '{"is_enabled":false,"type":"both","default_payment_frequency":"monthly","currencies":{"USD":{"code":"USD","symbol":"$","default_payment_processor":"offline_payment"}},"default_currency":"USD","codes_is_enabled":true,"taxes_and_billing_is_enabled":true,"invoice_is_enabled":true,"user_plan_expiry_reminder":0,"user_plan_expiry_checker_is_enabled":0,"currency_exchange_api_key":""}'),
('paypal', '{\"is_enabled\":\"0\",\"mode\":\"sandbox\",\"client_id\":\"\",\"secret\":\"\"}'),
('stripe', '{\"is_enabled\":\"0\",\"publishable_key\":\"\",\"secret_key\":\"\",\"webhook_secret\":\"\"}'),
('offline_payment', '{\"is_enabled\":\"0\",\"instructions\":\"Your offline payment instructions go here..\"}'),
('coinbase', '{"is_enabled":false,"api_key":"","webhook_secret":"","currencies":["USD"]}'),
('payu', '{"is_enabled":false,"mode":"sandbox","merchant_pos_id":"","signature_key":"","oauth_client_id":"","oauth_client_secret":"","currencies":["USD"]}'),
('iyzico', '{"is_enabled":false,"mode":"live","api_key":"","secret_key":"","currencies":["USD"]}'),
('paystack', '{"is_enabled":false,"public_key":"","secret_key":"","currencies":["USD"]}'),
('razorpay', '{"is_enabled":false,"key_id":"","key_secret":"","webhook_secret":"","currencies":["USD"]}'),
('mollie', '{"is_enabled":false,"api_key":""}'),
('myfatoorah', '{}'),
('yookassa', '{"is_enabled":false,"shop_id":"","secret_key":""}'),
('crypto_com', '{"is_enabled":false,"publishable_key":"","secret_key":"","webhook_secret":""}'),
('paddle', '{"is_enabled":false,"mode":"sandbox","vendor_id":"","api_key":"","public_key":"","currencies":["USD"]}'),
('mercadopago', '{"is_enabled":false,"access_token":"","currencies":["USD"]}'),
('midtrans', '{"is_enabled":false,"server_key":"","mode":"sandbox","currencies":["USD"]}'),
('flutterwave', '{"is_enabled":false,"secret_key":"","currencies":["USD"]}'),
('lemonsqueezy', '{"is_enabled":false,"api_key":"","signing_secret":"","store_id":"","one_time_monthly_variant_id":"","one_time_annual_variant_id":"","one_time_lifetime_variant_id":"","recurring_monthly_variant_id":"","recurring_annual_variant_id":"","currencies":["USD"]}'),
('smtp', '{"from_name":"","from":"","host":"","encryption":"tls","port":"","auth":false,"username":"","password":"","display_socials":false,"company_details":""}'),
('theme', '{"light_is_enabled": false, "dark_is_enabled": false}'),
('custom', '{"head_js":"","head_css":"","head_js_biolink":"","head_css_biolink":"","head_js_splash_page":"","head_css_splash_page":""}'),
('socials', '{"threads":"","youtube":"","facebook":"","x":"","instagram":"","tiktok":"","linkedin":"","whatsapp":"","email":""}'),
('announcements', '{"guests_id":"16e2fdd0e771da32ec9e557c491fe17d","guests_content":"","guests_text_color":"#ffffff","guests_background_color":"#000000","users_id":"16e2fdd0e771da32ec9e557c491fe17d","users_content":"","users_text_color":"#dbebff","users_background_color":"#000000"}'),
('business', '{\"invoice_is_enabled\":\"0\",\"name\":\"\",\"address\":\"\",\"city\":\"\",\"county\":\"\",\"zip\":\"\",\"country\":\"\",\"email\":\"\",\"phone\":\"\",\"tax_type\":\"\",\"tax_id\":\"\",\"custom_key_one\":\"\",\"custom_value_one\":\"\",\"custom_key_two\":\"\",\"custom_value_two\":\"\"}'),
('webhooks', '{"user_new":"","user_delete":"","payment_new":"","code_redeemed":"","contact":"","cron_start":"","cron_end":"","domain_new":"","domain_update":""}'),
('analytics', '{\"pixel_cache\":300,\"blacklisted_domains\":[],\"blacklisted_keywords\":[],\"email_reports_is_enabled\":0,\"pixel_exposed_identifier\":\"analytics\",\"sessions_replays_is_enabled\":\"1\",\"websites_heatmaps_is_enabled\":\"1\",\"sessions_replays_minimum_duration\":\"1\"}'),
('cookie_consent', '{"is_enabled":false,"logging_is_enabled":false,"necessary_is_enabled":true,"analytics_is_enabled":true,"targeting_is_enabled":true,"layout":"bar","position_y":"middle","position_x":"center"}'),
('license', '{\"license\":\"Nulled by LostKoean - Babia.to\","type\":\"\"}'),
('support', '{}'),
('custom_images', '{}'),
('product_info', '{\"version\":\"43.0.0\", \"code\":\"4300\"}');

-- SEPARATOR --


INSERT IGNORE INTO `settings` (`key`, `value`) VALUES ('support', '{}');

-- SEPARATOR --


UPDATE `settings` SET `value` = '{"key": "Nulled by LostKorean - Babia.to", "expiry_datetime": "2100-01-01 00:00:00"}' WHERE  `key` = 'support';