27505f7501
Completes the MokoJoomCross → MokoSuiteCross rebrand across all language string keys, Joomla event names, documentation, and wiki pages. - 1,151 language key references renamed (COM_, PLG_, PKG_ prefixes) - Event names renamed (onMokoJoomCross* → onMokoSuiteCross*) - CLAUDE.md, CHANGELOG.md, wiki docs updated - Zero mokojoomcross references remaining in codebase Closes #128, closes #138
15 lines
699 B
SQL
15 lines
699 B
SQL
-- MokoSuiteCross 01.01.00 — Category routing rules
|
|
-- Copyright (C) 2026 Moko Consulting. All rights reserved.
|
|
-- SPDX-License-Identifier: GPL-3.0-or-later
|
|
-- Note: also in install.mysql.sql for fresh installs; IF NOT EXISTS prevents conflicts
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__mokosuitecross_category_rules` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`category_id` int(10) unsigned NOT NULL,
|
|
`service_id` int(10) unsigned NOT NULL,
|
|
`published` tinyint(1) NOT NULL DEFAULT 1,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `idx_category_service` (`category_id`, `service_id`),
|
|
KEY `idx_category` (`category_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|