Файловый менеджер - Редактировать - /home/wuectly/www/03cbe/sql.zip
Назад
PK �t!]'��� mysql.xmlnu &1i� <?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>PK �t!]2� � � sqlsrv.xmlnu &1i� <?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>sqlsrv</driver> <driver>sqlazure</driver> </drivers> </meta> <sql> <action table="#__akeeba_common" canfail="0"> <condition type="missing" value=""/> <query><![CDATA[ CREATE TABLE [#__akeeba_common] ( [key] [NVARCHAR](192) NOT NULL, [value] [TEXT] NOT NULL, CONSTRAINT [PK_#__akeeba_common] PRIMARY KEY CLUSTERED ( [key] ASC ) WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ) ]]></query> </action> </sql> </schema>PK �t!]%nh h postgresql.xmlnu &1i� <?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>postgres</driver> <driver>postgresql</driver> </drivers> </meta> <sql> <action table="#__akeeba_common" canfail="0"> <condition type="missing" value=""/> <query><![CDATA[ CREATE TABLE IF NOT EXISTS "#__akeeba_common" ( "key" character varying(192) NOT NULL, "value" text NOT NULL, PRIMARY KEY ("key") ); ]]></query> </action> </sql> </schema>PK T|!]ӝ/yJ J install.mysql.utf8.sqlnu &1i� -- -- Table structure for table `#__newsfeeds` -- CREATE TABLE IF NOT EXISTS `#__newsfeeds` ( `catid` int NOT NULL DEFAULT 0, `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `link` varchar(2048) NOT NULL DEFAULT '', `published` tinyint NOT NULL DEFAULT 0, `numarticles` int unsigned NOT NULL DEFAULT 1, `cache_time` int unsigned NOT NULL DEFAULT 3600, `checked_out` int unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int NOT NULL DEFAULT 0, `rtl` tinyint NOT NULL DEFAULT 0, `access` int unsigned NOT NULL DEFAULT 0, `language` char(7) NOT NULL DEFAULT '', `params` text NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int unsigned NOT NULL DEFAULT 0, `created_by_alias` varchar(255) NOT NULL DEFAULT '', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int unsigned NOT NULL DEFAULT 0, `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `description` text NOT NULL, `version` int unsigned NOT NULL DEFAULT 1, `hits` int unsigned NOT NULL DEFAULT 0, `images` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`published`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; PK T|!]�)�&