core_sessions Table

[Dominyka]

Our website is experiencing a 500 error.

We hired someone to look at that and they found out that the table core_sessions is missing from our database. Can anyone provide me with the table structure, anything? I really have no idea how to proceed here. I can't access the admin panel either.

[Martin A.]

CREATE TABLE `core_sessions` (
  `id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `member_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `member_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(46) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `running_time` int(10) DEFAULT NULL,
  `login_type` tinyint(1) DEFAULT 0,
  `member_group` smallint(3) DEFAULT NULL,
  `in_error` tinyint(1) NOT NULL DEFAULT 0,
  `current_appcomponent` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `current_module` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `current_controller` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `uagent_key` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `uagent_version` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `uagent_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `search_thread_id` int(11) NOT NULL DEFAULT 0,
  `search_thread_time` int(11) NOT NULL DEFAULT 0,
  `data` blob DEFAULT NULL,
  `location_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_lang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_permissions` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_id` int(10) UNSIGNED DEFAULT NULL,
  `theme_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `in_editor` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'User is currently using an editor'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;