"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2020-05-29.sql" (13 Sep 2021, 6833 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-2020-04-11.sql
    2 INSERT INTO "#__extensions" ("package_id", "name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "locked", "manifest_cache", "params", "custom_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
    3 (0, 'plg_quickicon_downloadkey', 'plugin', 'downloadkey', 'quickicon', 0, 1, 1, 0, 1, '', '', '', 0, NULL, 0, 0);
    4 
    5 -- From 4.0.0-2020-04-16.sql
    6 INSERT INTO "#__mail_templates" ("template_id", "language", "subject", "body", "htmlbody", "attachments", "params") VALUES
    7 ('com_contact.mail', '', 'COM_CONTACT_ENQUIRY_SUBJECT', 'COM_CONTACT_ENQUIRY_TEXT', '', '', '{"tags":["sitename","name","email","subject","body","url","customfields"]}'),
    8 ('com_contact.mail.copy', '', 'COM_CONTACT_COPYSUBJECT_OF', 'COM_CONTACT_COPYTEXT_OF', '', '', '{"tags":["sitename","name","email","subject","body","url","customfields"]}'),
    9 ('com_users.massmail.mail', '', 'COM_USERS_MASSMAIL_MAIL_SUBJECT', 'COM_USERS_MASSMAIL_MAIL_BODY', '', '', '{"tags":["subject","body","subjectprefix","bodysuffix"]}'),
   10 ('com_users.password_reset', '', 'COM_USERS_EMAIL_PASSWORD_RESET_SUBJECT', 'COM_USERS_EMAIL_PASSWORD_RESET_BODY', '', '', '{"tags":["name","email","sitename","link_text","link_html","token"]}'),
   11 ('com_users.reminder', '', 'COM_USERS_EMAIL_USERNAME_REMINDER_SUBJECT', 'COM_USERS_EMAIL_USERNAME_REMINDER_BODY', '', '', '{"tags":["name","username","sitename","email","link_text","link_html"]}'),
   12 ('plg_system_updatenotification.mail', '', 'PLG_SYSTEM_UPDATENOTIFICATION_EMAIL_SUBJECT', 'PLG_SYSTEM_UPDATENOTIFICATION_EMAIL_BODY', '', '', '{"tags":["newversion","curversion","sitename","url","link","releasenews"]}'),
   13 ('plg_user_joomla.mail', '', 'PLG_USER_JOOMLA_NEW_USER_EMAIL_SUBJECT', 'PLG_USER_JOOMLA_NEW_USER_EMAIL_BODY', '', '', '{"tags":["name","sitename","url","username","password","email"]}');
   14 
   15 -- From 4.0.0-2020-05-21.sql
   16 -- Renaming table
   17 ALTER TABLE "#__ucm_history" RENAME TO "#__history";
   18 -- Rename ucm_item_id to item_id as the new primary identifier for the original content item
   19 ALTER TABLE "#__history" RENAME "ucm_item_id" TO "item_id";
   20 ALTER TABLE "#__history" ALTER COLUMN "item_id" TYPE character varying(50);
   21 ALTER TABLE "#__history" ALTER COLUMN "item_id" SET NOT NULL;
   22 ALTER TABLE "#__history" ALTER COLUMN "item_id" DROP DEFAULT;
   23 
   24 -- Extend the original field content with the alias of the content type
   25 UPDATE "#__history" AS h SET "item_id" = CONCAT(c."type_alias", '.', "item_id") FROM "#__content_types" AS c WHERE h."ucm_type_id" = c."type_id";
   26 
   27 -- Now we don't need the ucm_type_id anymore and drop it.
   28 ALTER TABLE "#__history" DROP COLUMN "ucm_type_id";
   29 ALTER TABLE "#__history" ALTER COLUMN "save_date" DROP DEFAULT;
   30 
   31 -- From 4.0.0-2020-05-29.sql
   32 ALTER TABLE "#__extensions" ALTER COLUMN "checked_out" DROP DEFAULT;
   33 ALTER TABLE "#__extensions" ALTER COLUMN "checked_out" DROP NOT NULL;
   34 ALTER TABLE "#__menu" ALTER COLUMN "checked_out" DROP DEFAULT;
   35 ALTER TABLE "#__menu" ALTER COLUMN "checked_out" DROP NOT NULL;
   36 ALTER TABLE "#__modules" ALTER COLUMN "checked_out" DROP DEFAULT;
   37 ALTER TABLE "#__modules" ALTER COLUMN "checked_out" DROP NOT NULL;
   38 ALTER TABLE "#__tags" ALTER COLUMN "checked_out" DROP DEFAULT;
   39 ALTER TABLE "#__tags" ALTER COLUMN "checked_out" DROP NOT NULL;
   40 ALTER TABLE "#__update_sites" ALTER COLUMN "checked_out" DROP DEFAULT;
   41 ALTER TABLE "#__update_sites" ALTER COLUMN "checked_out" DROP NOT NULL;
   42 ALTER TABLE "#__user_notes" ALTER COLUMN "checked_out" DROP DEFAULT;
   43 ALTER TABLE "#__user_notes" ALTER COLUMN "checked_out" DROP NOT NULL;
   44 ALTER TABLE "#__workflows" ALTER COLUMN "checked_out" DROP DEFAULT;
   45 ALTER TABLE "#__workflows" ALTER COLUMN "checked_out" DROP NOT NULL;
   46 ALTER TABLE "#__workflow_stages" ALTER COLUMN "checked_out" DROP DEFAULT;
   47 ALTER TABLE "#__workflow_stages" ALTER COLUMN "checked_out" DROP NOT NULL;
   48 ALTER TABLE "#__workflow_transitions" ALTER COLUMN "checked_out" DROP DEFAULT;
   49 ALTER TABLE "#__workflow_transitions" ALTER COLUMN "checked_out" DROP NOT NULL;
   50 ALTER TABLE "#__banners" ALTER COLUMN "checked_out" DROP DEFAULT;
   51 ALTER TABLE "#__banners" ALTER COLUMN "checked_out" DROP NOT NULL;
   52 ALTER TABLE "#__banner_clients" ALTER COLUMN "checked_out" DROP DEFAULT;
   53 ALTER TABLE "#__banner_clients" ALTER COLUMN "checked_out" DROP NOT NULL;
   54 ALTER TABLE "#__contact_details" ALTER COLUMN "checked_out" DROP DEFAULT;
   55 ALTER TABLE "#__contact_details" ALTER COLUMN "checked_out" DROP NOT NULL;
   56 ALTER TABLE "#__content" ALTER COLUMN "checked_out" DROP DEFAULT;
   57 ALTER TABLE "#__content" ALTER COLUMN "checked_out" DROP NOT NULL;
   58 ALTER TABLE "#__finder_filters" ALTER COLUMN "checked_out" DROP DEFAULT;
   59 ALTER TABLE "#__finder_filters" ALTER COLUMN "checked_out" DROP NOT NULL;
   60 ALTER TABLE "#__newsfeeds" ALTER COLUMN "checked_out" DROP DEFAULT;
   61 ALTER TABLE "#__newsfeeds" ALTER COLUMN "checked_out" DROP NOT NULL;
   62 ALTER TABLE "#__categories" ALTER COLUMN "checked_out" DROP DEFAULT;
   63 ALTER TABLE "#__categories" ALTER COLUMN "checked_out" DROP NOT NULL;
   64 ALTER TABLE "#__fields" ALTER COLUMN "checked_out" DROP DEFAULT;
   65 ALTER TABLE "#__fields" ALTER COLUMN "checked_out" DROP NOT NULL;
   66 ALTER TABLE "#__fields_groups" ALTER COLUMN "checked_out" DROP DEFAULT;
   67 ALTER TABLE "#__fields_groups" ALTER COLUMN "checked_out" DROP NOT NULL;
   68 ALTER TABLE "#__ucm_content" ALTER COLUMN "core_checked_out_user_id" DROP DEFAULT;
   69 ALTER TABLE "#__ucm_content" ALTER COLUMN "core_checked_out_user_id" DROP NOT NULL;
   70 
   71 UPDATE "#__extensions" SET "checked_out" = null WHERE "checked_out" = 0;
   72 UPDATE "#__menu" SET "checked_out" = null WHERE "checked_out" = 0;
   73 UPDATE "#__modules" SET "checked_out" = null WHERE "checked_out" = 0;
   74 UPDATE "#__tags" SET "checked_out" = null WHERE "checked_out" = 0;
   75 UPDATE "#__update_sites" SET "checked_out" = null WHERE "checked_out" = 0;
   76 UPDATE "#__user_notes" SET "checked_out" = null WHERE "checked_out" = 0;
   77 UPDATE "#__workflows" SET "checked_out" = null WHERE "checked_out" = 0;
   78 UPDATE "#__workflow_stages" SET "checked_out" = null WHERE "checked_out" = 0;
   79 UPDATE "#__workflow_transitions" SET "checked_out" = null WHERE "checked_out" = 0;
   80 UPDATE "#__banners" SET "checked_out" = null WHERE "checked_out" = 0;
   81 UPDATE "#__banner_clients" SET "checked_out" = null WHERE "checked_out" = 0;
   82 UPDATE "#__contact_details" SET "checked_out" = null WHERE "checked_out" = 0;
   83 UPDATE "#__content" SET "checked_out" = null WHERE "checked_out" = 0;
   84 UPDATE "#__finder_filters" SET "checked_out" = null WHERE "checked_out" = 0;
   85 UPDATE "#__newsfeeds" SET "checked_out" = null WHERE "checked_out" = 0;
   86 UPDATE "#__categories" SET "checked_out" = null WHERE "checked_out" = 0;
   87 UPDATE "#__fields" SET "checked_out" = null WHERE "checked_out" = 0;
   88 UPDATE "#__fields_groups" SET "checked_out" = null WHERE "checked_out" = 0;
   89 UPDATE "#__ucm_content" SET "core_checked_out_user_id" = null WHERE "core_checked_out_user_id" = 0;