"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/2.5.0-2011-12-24.sql" (18 Jun 2022, 317 Bytes) of package /linux/www/Joomla_3.10.10-Stable-Full_Package.tar.bz2:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 ALTER TABLE `#__menu` DROP INDEX `idx_client_id_parent_id_alias`;
    2 
    3 --
    4 -- The following statment had to be modified for utf8mb4 in Joomla! 3.5.1, changing
    5 -- `alias` to `alias`(100)
    6 --
    7 
    8 ALTER TABLE `#__menu` ADD UNIQUE `idx_client_id_parent_id_alias_language` ( `client_id` , `parent_id` , `alias`(100) , `language` );