"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2018-07-19.sql" (13 Sep 2021, 1767 Bytes) of package /linux/www/Joomla_4.0.3-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 -- From 4.0.0-2018-06-03.sql
    2 -- This has been removed as com_csp has been removed from the final build
    3 
    4 -- From 4.0.0-2018-06-26.sql
    5 ALTER TABLE "#__user_notes" ALTER COLUMN "modified_user_id" SET DEFAULT 0;
    6 
    7 -- From 4.0.0-2018-07-02.sql
    8 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
    9 (0, 'plg_extension_namespacemap', 'plugin', 'namespacemap', 'extension', 0, 0, 1, 1, '', '{}', '', 0, '1970-01-01 00:00:00', 0, 0);
   10 
   11 -- From 4.0.0-2018-07-19.sql
   12 CREATE TABLE IF NOT EXISTS "#__template_overrides" (
   13   "id" serial NOT NULL,
   14   "template" varchar(50) DEFAULT '' NOT NULL,
   15   "hash_id" varchar(255) DEFAULT '' NOT NULL,
   16   "extension_id" bigint DEFAULT 0,
   17   "state" smallint DEFAULT 0 NOT NULL,
   18   "action" varchar(50) DEFAULT '' NOT NULL,
   19   "client_id" smallint DEFAULT 0 NOT NULL,
   20   "created_date" timestamp without time zone NOT NULL,
   21   "modified_date" timestamp without time zone,
   22   PRIMARY KEY ("id")
   23 );
   24 CREATE INDEX "#__template_overrides_idx_template" ON "#__template_overrides" ("template");
   25 CREATE INDEX "#__template_overrides_idx_extension_id" ON "#__template_overrides" ("extension_id");
   26 
   27 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
   28 (0, 'plg_installer_override', 'plugin', 'override', 'installer', 0, 1, 1, 1, '', '', '', 0, '1970-01-01 00:00:00', 4, 0),
   29 (0, 'plg_quickicon_overridecheck', 'plugin', 'overridecheck', 'quickicon', 0, 1, 1, 1, '', '', '', 0, '1970-01-01 00:00:00', 0, 0);