TODD MCCARTY reacted to
Marc Stridgen in Upgrade & Configuration Error
August 16, 2022
Feel free to try this. Note, this is outside the scope of support.
--
-- Table structure for table `core_achievements_log_milestones`
--
CREATE TABLE `core_achievements_log_milestones` (
`milestone_id` bigint(20) UNSIGNED NOT NULL,
`milestone_member_id` bigint(20) UNSIGNED NOT NULL,
`milestone_rule` int(10) UNSIGNED NOT NULL,
`milestone_log_id` bigint(20) UNSIGNED NOT NULL,
`milestone_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'subject'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_alerts_seen`
--
CREATE TABLE `core_alerts_seen` (
`seen_alert_id` int(11) NOT NULL,
`seen_member_id` int(11) NOT NULL,
`seen_date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_content_featured`
--
CREATE TABLE `core_content_featured` (
`feature_id` int(11) NOT NULL,
`feature_content_id` int(11) NOT NULL DEFAULT 0,
`feature_content_class` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`feature_content_author` int(11) NOT NULL DEFAULT 0,
`feature_date` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_editor_stored_replies`
--
CREATE TABLE `core_editor_stored_replies` (
`reply_id` int(11) NOT NULL,
`reply_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`reply_text` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`reply_added_by` int(11) NOT NULL,
`reply_enabled` tinyint(3) UNSIGNED DEFAULT 0,
`reply_position` int(10) UNSIGNED DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_follow_count_cache`
--
CREATE TABLE `core_follow_count_cache` (
`id` bigint(20) NOT NULL DEFAULT 0,
`class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`count` int(11) NOT NULL DEFAULT 0,
`added` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_item_member_map`
--
CREATE TABLE `core_item_member_map` (
`map_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`map_item_id` int(11) NOT NULL DEFAULT 0,
`map_member_id` int(11) DEFAULT 0,
`map_latest_date` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_item_redirect`
--
CREATE TABLE `core_item_redirect` (
`redirect_id` int(11) NOT NULL,
`redirect_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`redirect_item_id` int(11) NOT NULL DEFAULT 0,
`redirect_new_item_id` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_item_statistics_cache`
--
CREATE TABLE `core_item_statistics_cache` (
`cache_id` int(11) NOT NULL,
`cache_class` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`cache_item_id` int(11) NOT NULL DEFAULT 0,
`cache_added` int(11) NOT NULL DEFAULT 0,
`cache_contents` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_members_logins`
--
CREATE TABLE `core_members_logins` (
`member_id` int(11) NOT NULL,
`member_date` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`member_timestamp` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `core_member_recognize`
--
CREATE TABLE `core_member_recognize` (
`r_id` int(11) NOT NULL,
`r_member_id` int(11) NOT NULL,
`r_content_class` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`r_content_id` int(11) NOT NULL DEFAULT 0,
`r_message` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`r_added` int(11) NOT NULL DEFAULT 0,
`r_badge` int(10) UNSIGNED NOT NULL DEFAULT 0,
`r_points` int(10) UNSIGNED NOT NULL DEFAULT 0,
`r_given_by` int(10) UNSIGNED NOT NULL DEFAULT 0,
`r_public` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Show this message publicly?'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `core_achievements_log_milestones`
--
ALTER TABLE `core_achievements_log_milestones`
ADD PRIMARY KEY (`milestone_id`),
ADD UNIQUE KEY `lookup` (`milestone_member_id`,`milestone_rule`,`milestone_type`);
--
-- Indexes for table `core_alerts_seen`
--
ALTER TABLE `core_alerts_seen`
ADD UNIQUE KEY `alert_member` (`seen_alert_id`,`seen_member_id`);
--
-- Indexes for table `core_content_featured`
--
ALTER TABLE `core_content_featured`
ADD PRIMARY KEY (`feature_id`),
ADD KEY `feature_lookup` (`feature_content_id`,`feature_content_class`,`feature_content_author`);
--
-- Indexes for table `core_editor_stored_replies`
--
ALTER TABLE `core_editor_stored_replies`
ADD PRIMARY KEY (`reply_id`);
--
-- Indexes for table `core_follow_count_cache`
--
ALTER TABLE `core_follow_count_cache`
ADD UNIQUE KEY `id_class` (`id`,`class`(171)),
ADD KEY `added` (`added`);
--
-- Indexes for table `core_item_member_map`
--
ALTER TABLE `core_item_member_map`
ADD UNIQUE KEY `map_unique` (`map_class`(171),`map_item_id`,`map_member_id`),
ADD KEY `map_lookup` (`map_item_id`,`map_member_id`),
ADD KEY `map_member_id` (`map_member_id`);
--
-- Indexes for table `core_item_redirect`
--
ALTER TABLE `core_item_redirect`
ADD PRIMARY KEY (`redirect_id`),
ADD KEY `redirect_lookup` (`redirect_class`(181),`redirect_item_id`),
ADD KEY `redirect_delete` (`redirect_class`(181),`redirect_new_item_id`);
--
-- Indexes for table `core_item_statistics_cache`
--
ALTER TABLE `core_item_statistics_cache`
ADD PRIMARY KEY (`cache_id`),
ADD UNIQUE KEY `cache_lookup` (`cache_class`,`cache_item_id`),
ADD KEY `cache_added` (`cache_added`);
--
-- Indexes for table `core_members_logins`
--
ALTER TABLE `core_members_logins`
ADD UNIQUE KEY `lookup` (`member_id`,`member_date`);
--
-- Indexes for table `core_member_recognize`
--
ALTER TABLE `core_member_recognize`
ADD PRIMARY KEY (`r_id`),
ADD KEY `r_member_id` (`r_member_id`),
ADD KEY `r_content` (`r_content_class`,`r_content_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `core_achievements_log_milestones`
--
ALTER TABLE `core_achievements_log_milestones`
MODIFY `milestone_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `core_content_featured`
--
ALTER TABLE `core_content_featured`
MODIFY `feature_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `core_editor_stored_replies`
--
ALTER TABLE `core_editor_stored_replies`
MODIFY `reply_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `core_item_redirect`
--
ALTER TABLE `core_item_redirect`
MODIFY `redirect_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `core_item_statistics_cache`
--
ALTER TABLE `core_item_statistics_cache`
MODIFY `cache_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `core_member_recognize`
--
ALTER TABLE `core_member_recognize`
MODIFY `r_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;