IP : 18.226.200.44Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
jackpotjunglegam/
../
../
var/
softaculous/
./
wp58/
./
./
../
symfony24/
../
ruko/
ruko.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `app_access_rules` --
CREATE TABLE `app_access_rules` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `entities_id` int(10) unsigned NOT NULL, `fields_id` int(10) unsigned NOT NULL, `choices` text NOT NULL, `users_groups` text NOT NULL, `access_schema` text NOT NULL, `fields_view_only_access` text NOT NULL, `comments_access_schema` varchar(64) NOT NULL, PRIMARY KEY (`id`), KEY `idx_entities_id` (`entities_id`), KEY `idx_fields_id` (`fields_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_dashboard_pages` --
CREATE TABLE `app_dashboard_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `created_by` int(11) NOT NULL, `sections_id` int(11) NOT NULL, `type` varchar(16) NOT NULL, `is_active` tinyint(1) NOT NULL, `name` varchar(255) NOT NULL, `icon` varchar(64) NOT NULL, `description` text NOT NULL, `color` varchar(16) NOT NULL, `users_fields` text NOT NULL, `users_groups` text NOT NULL, `sort_order` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `idx_created_by` (`created_by`), KEY `idx_sections_id` (`sections_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_emails_on_schedule` --
CREATE TABLE `app_emails_on_schedule` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date_added` bigint(20) unsigned NOT NULL, `email_to` varchar(255) NOT NULL, `email_to_name` varchar(255) NOT NULL, `email_subject` varchar(255) NOT NULL, `email_body` text NOT NULL, `email_from` varchar(255) NOT NULL, `email_from_name` varchar(255) NOT NULL, `email_attachments` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_entities_menu` --
CREATE TABLE `app_entities_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `name` varchar(64) NOT NULL, `icon` varchar(64) NOT NULL, `icon_color` varchar(7) NOT NULL, `bg_color` varchar(7) NOT NULL, `entities_list` text NOT NULL, `reports_list` text NOT NULL, `pages_list` text NOT NULL, `type` varchar(16) DEFAULT 'entity', `url` varchar(255) NOT NULL, `users_groups` text NOT NULL, `assigned_to` text NOT NULL, `sort_order` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `idx_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_entity_22` --
CREATE TABLE `app_entity_22` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) DEFAULT '0', `parent_item_id` int(11) DEFAULT '0', `linked_id` int(11) DEFAULT '0', `date_added` bigint(20) NOT NULL DEFAULT '0', `date_updated` bigint(20) NOT NULL DEFAULT '0', `created_by` int(11) DEFAULT NULL, `sort_order` int(11) DEFAULT '0', `field_167` text NOT NULL, `field_168` text NOT NULL, `field_169` text NOT NULL, `field_170` text NOT NULL, `field_171` text NOT NULL, `field_172` text NOT NULL, `field_173` varchar(64) NOT NULL, `field_174` varchar(64) NOT NULL, `field_175` bigint(20) NOT NULL DEFAULT '0', `field_176` bigint(20) NOT NULL DEFAULT '0', `field_177` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_parent_id` (`parent_id`), KEY `idx_parent_item_id` (`parent_item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_help_pages` --
CREATE TABLE `app_help_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `entities_id` int(11) NOT NULL, `created_by` int(11) NOT NULL, `type` varchar(16) NOT NULL, `is_active` tinyint(1) NOT NULL, `name` varchar(255) NOT NULL, `icon` varchar(64) NOT NULL, `start_date` int(11) NOT NULL, `end_date` int(11) NOT NULL, `description` text NOT NULL, `color` varchar(16) NOT NULL, `position` varchar(16) NOT NULL, `users_groups` text NOT NULL, `sort_order` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `idx_created_by` (`created_by`), KEY `idx_entities_id` (`entities_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
CREATE TABLE `app_holidays` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_records_visibility_rules` --
CREATE TABLE `app_records_visibility_rules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `entities_id` int(11) NOT NULL, `is_active` tinyint(1) NOT NULL, `users_groups` text NOT NULL, `merged_fields` text NOT NULL, `merged_fields_empty_values` text NOT NULL, `notes` text NOT NULL, `mysql_query` text NOT NULL, `php_code` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_entities_id` (`entities_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
CREATE TABLE `app_reports` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL DEFAULT '0', `entities_id` int(11) NOT NULL, `created_by` int(11) NOT NULL, `reports_type` varchar(64) NOT NULL, `name` varchar(64) NOT NULL, `description` text NOT NULL, `menu_icon` varchar(64) NOT NULL, `icon_color` varchar(7) NOT NULL, `bg_color` varchar(7) NOT NULL, `in_menu` tinyint(1) NOT NULL DEFAULT '0', `in_dashboard` tinyint(4) NOT NULL DEFAULT '0', `in_dashboard_counter` tinyint(1) NOT NULL DEFAULT '0', `in_dashboard_icon` tinyint(1) NOT NULL, `in_dashboard_counter_color` varchar(16) NOT NULL, `in_dashboard_counter_bg_color` varchar(16) NOT NULL, `in_dashboard_counter_fields` varchar(255) NOT NULL, `dashboard_counter_hide_count` tinyint(1) NOT NULL DEFAULT '0', `dashboard_counter_hide_zero_count` tinyint(1) NOT NULL, `dashboard_counter_sum_by_field` int(11) NOT NULL, `in_header` tinyint(1) NOT NULL DEFAULT '0', `in_header_autoupdate` tinyint(1) NOT NULL, `dashboard_sort_order` int(11) DEFAULT NULL, `header_sort_order` int(11) NOT NULL DEFAULT '0', `dashboard_counter_sort_order` int(11) NOT NULL DEFAULT '0', `listing_order_fields` text NOT NULL, `users_groups` text NOT NULL, `assigned_to` text NOT NULL, `displays_assigned_only` tinyint(1) NOT NULL DEFAULT '0', `parent_entity_id` int(11) NOT NULL DEFAULT '0', `parent_item_id` int(11) NOT NULL DEFAULT '0', `fields_in_listing` text NOT NULL, `rows_per_page` int(11) NOT NULL DEFAULT '0', `notification_days` varchar(32) NOT NULL, `notification_time` varchar(255) NOT NULL, `listing_type` varchar(16) NOT NULL, `listing_col_width` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_entities_id` (`entities_id`), KEY `idx_created_by` (`created_by`), KEY `idx_parent_id` (`parent_id`), KEY `idx_parent_entity_id` (`parent_entity_id`), KEY `idx_parent_item_id` (`parent_item_id`), KEY `idx_reports_type` (`reports_type`), KEY `idx_in_dashboard` (`in_dashboard`), KEY `idx_in_dashboard_counter` (`in_dashboard_counter`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=66 ;
-- -- Table structure for table `app_reports_groups` --
CREATE TABLE `app_reports_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `menu_icon` varchar(64) NOT NULL, `icon_color` varchar(7) NOT NULL, `bg_color` varchar(7) NOT NULL, `in_menu` tinyint(1) NOT NULL, `in_dashboard` tinyint(1) NOT NULL, `sort_order` smallint(6) NOT NULL, `counters_list` text NOT NULL, `reports_list` text NOT NULL, `created_by` int(11) NOT NULL, `is_common` tinyint(1) NOT NULL DEFAULT '0', `users_groups` text NOT NULL, `assigned_to` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_created_by` (`created_by`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_users_alerts` --
CREATE TABLE `app_users_alerts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `is_active` tinyint(1) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, `type` varchar(16) NOT NULL, `location` varchar(16) NOT NULL, `start_date` bigint(20) unsigned NOT NULL, `end_date` bigint(20) unsigned NOT NULL, `assigned_to` text NOT NULL, `users_groups` text NOT NULL, `created_by` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `idx_created_by` (`created_by`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- -- Table structure for table `app_who_is_online` --
CREATE TABLE `app_who_is_online` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `users_id` int(11) NOT NULL, `date_updated` bigint(20) NOT NULL, PRIMARY KEY (`id`), KEY `idx_users_id` (`users_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
/*!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 */;