This is the database structure according to a fresh Joomla 4.2.3 installation:
CREATE TABLE IF NOT EXISTS `#__extensions` (
`extension_id` int NOT NULL AUTO_INCREMENT,
`package_id` int NOT NULL DEFAULT 0 COMMENT 'Parent package ID for extensions installed as a package.',
`name` varchar(100) NOT NULL,
`type` varchar(20) NOT NULL,
`element` varchar(100) NOT NULL,
`changelogurl` text,
`folder` varchar(100) NOT NULL,
`client_id` tinyint NOT NULL,
`enabled` tinyint NOT NULL DEFAULT 0,
`access` int unsigned NOT NULL DEFAULT 1,
`protected` tinyint NOT NULL DEFAULT 0 COMMENT 'Flag to indicate if the extension is protected. Protected extensions cannot be disabled.',
`locked` tinyint NOT NULL DEFAULT 0 COMMENT 'Flag to indicate if the extension is locked. Locked extensions cannot be uninstalled.',
`manifest_cache` text NOT NULL,
`params` text NOT NULL,
`custom_data` text NOT NULL,
`checked_out` int unsigned,
`checked_out_time` datetime,
`ordering` int DEFAULT 0,
`state` int DEFAULT 0,
`note` varchar(255),
PRIMARY KEY (`extension_id`),
KEY `element_clientid` (`element`,`client_id`),
KEY `element_folder_clientid` (`element`,`folder`,`client_id`),
KEY `extension` (`type`,`element`,`folder`,`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
Please post a rating at the
Joomla! Extensions Directory