CoreFiles by mySites.guru
4.0.0-2018-07-19.sql31 lines, 1,961 bytes, from Joomla_4.2.2-Stable-Full_Package.zip
Raw History Compare with 4.2.1
md5
44c45f4095c1757fffc5624ead40110b
sha1
2f0d9f09c3f873d45868caf5724a4f9f64629093
sha256
ab804260ed79e16c97b42251bc2d200ebe9cf37534f22b730d2d7c24aae4b813
-- From 4.0.0-2018-06-03.sql
-- This has been removed as com_csp has been removed from the final build

-- From 4.0.0-2018-06-26.sql
ALTER TABLE "#__user_notes" ALTER COLUMN "modified_user_id" SET DEFAULT 0;

-- From 4.0.0-2018-07-02.sql
INSERT INTO "#__extensions" ("package_id", "name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "manifest_cache", "params", "custom_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
(0, 'plg_extension_namespacemap', 'plugin', 'namespacemap', 'extension', 0, 0, 1, 1, '', '{}', '', 0, '1970-01-01 00:00:00', 0, 0);

-- From 4.0.0-2018-07-19.sql
CREATE TABLE IF NOT EXISTS "#__template_overrides" (
  "id" serial NOT NULL,
  "template" varchar(50) DEFAULT '' NOT NULL,
  "hash_id" varchar(255) DEFAULT '' NOT NULL,
  "extension_id" bigint DEFAULT 0,
  "state" smallint DEFAULT 0 NOT NULL,
  "action" varchar(50) DEFAULT '' NOT NULL,
  "client_id" smallint DEFAULT 0 NOT NULL,
  "created_date" timestamp without time zone NOT NULL,
  "modified_date" timestamp without time zone,
  PRIMARY KEY ("id")
);
-- The following two statements were modified for 4.1.1 by adding the "/** CAN FAIL **/" installer hint.
-- See https://github.com/joomla/joomla-cms/pull/37156
CREATE INDEX "#__template_overrides_idx_template" ON "#__template_overrides" ("template") /** CAN FAIL **/;
CREATE INDEX "#__template_overrides_idx_extension_id" ON "#__template_overrides" ("extension_id") /** CAN FAIL **/;

INSERT INTO "#__extensions" ("package_id", "name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "manifest_cache", "params", "custom_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
(0, 'plg_installer_override', 'plugin', 'override', 'installer', 0, 1, 1, 1, '', '', '', 0, '1970-01-01 00:00:00', 4, 0),
(0, 'plg_quickicon_overridecheck', 'plugin', 'overridecheck', 'quickicon', 0, 1, 1, 1, '', '', '', 0, '1970-01-01 00:00:00', 0, 0);

The same content is in 80 releases, Joomla 4.2.0-alpha1 to 4.4.14. See them all, or every version of this file.