One Hat Cyber Team

Your IP: 216.73.216.19
Server IP: 178.33.27.10
Server: Linux cpanel.dev-unit.com 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64
Server Software: Apache/2.4.57 (Unix) OpenSSL/1.0.2k-fips
PHP Version: 8.2.11
Buat File | Buat Folder

Dir : ~/usr/local/cwpsrv/var/services/pma/sql/

View File Name : upgrade_column_info_4_3_0+.sql

-- -------------------------------------------------------------
-- SQL Commands to upgrade pmadb.pma__column_info table
-- for normal phpMyAdmin operation
--
-- This file is meant for use with phpMyAdmin 4.3.0 and above!
-- For older releases, please use create_tables.sql
--
-- Please don't forget to set up the table names in config.inc.php
--

-- --------------------------------------------------------

--
-- Database : `phpmyadmin`
--
USE `phpmyadmin`;

-- --------------------------------------------------------

--
-- Update table structure for table `pma__column_info`
--
UPDATE `pma__column_info`
  SET `mimetype` = REPLACE(`mimetype`, 'octet-stream', 'octetstream');
UPDATE `pma__column_info`
  SET `transformation` = REPLACE(REPLACE(`transformation`, '__', '_'), 'inc.php', 'class.php');
UPDATE `pma__column_info`
  SET `transformation` = ''
  WHERE `transformation` = '_';
UPDATE `pma__column_info`
  SET `transformation` = CONCAT('output/', `transformation`)
  WHERE `transformation` IN (
    'application_octetstream_download.class.php',
    'application_octetstream_hex.class.php',
    'image_jpeg_inline.class.php',
    'image_jpeg_link.class.php',
    'image_png_inline.class.php',
    'text_plain_bool2text.class.php',
    'text_plain_dateformat.class.php',
    'text_plain_external.class.php',
    'text_plain_formatted.class.php',
    'text_plain_imagelink.class.php',
    'text_plain_sql.class.php'
  );
ALTER TABLE `pma__column_info`
  ADD `input_transformation` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  ADD `input_transformation_options` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';