Server : LiteSpeed System : Linux server 3.10.0-1160.90.1.el7.x86_64 #1 SMP Thu May 4 15:21:22 UTC 2023 x86_64 User : alsaif ( 1057) PHP Version : 7.4.33 Disable Function : show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/alsaif/public_html/libraries/fof30/sql/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?xml version="1.0" encoding="UTF-8"?>
<!--
  ~ @package   FOF
  ~ @copyright Copyright (c)2010-2020 Nicholas K. Dionysopoulos / Akeeba Ltd
  ~ @license   GNU General Public License version 2, or later
  -->

<schema>
	<meta>
		<drivers>
			<driver>mysql</driver>
			<driver>mysqli</driver>
			<driver>pdomysql</driver>
		</drivers>
		<!-- We don't want this table to be converted to a different charset automatically. We will only convert a single
		 column. -->
		<autocollation>false</autocollation>
	</meta>

	<sql>
		<action table="#__akeeba_common" canfail="0">
			<condition type="missing" value=""/>
			<query><![CDATA[
CREATE TABLE IF NOT EXISTS `#__akeeba_common` (
	`key` varchar(190) NOT NULL,
	`value` longtext NOT NULL,
	PRIMARY KEY (`key`)
) DEFAULT COLLATE utf8_general_ci CHARSET=utf8;
			]]></query>
		</action>

		<action table="#__akeeba_common" canfail="1">
			<condition type="utf8mb4upgrade"/>
			<query><![CDATA[
ALTER TABLE `#__akeeba_common` MODIFY COLUMN `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL;
			]]></query>
		</action>

		<action table="#__akeeba_common" canfail="1">
			<condition type="true" />
			<query><![CDATA[
ALTER TABLE `#__akeeba_common` MODIFY COLUMN `key` varchar(190) COLLATE utf8_unicode_ci NOT NULL;
			]]></query>
		</action>
	</sql>
</schema>