"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2019-03-30.sql" (13 Sep 2021, 388 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 ALTER TABLE "#__menu" ADD COLUMN "publish_up" timestamp without time zone;
    2 ALTER TABLE "#__menu" ADD COLUMN "publish_down" timestamp without time zone;
    3 
    4 ALTER TABLE "#__menu" ALTER COLUMN "checked_out_time" DROP NOT NULL;
    5 ALTER TABLE "#__menu" ALTER COLUMN "checked_out_time" DROP DEFAULT;
    6 
    7 UPDATE "#__menu" SET "checked_out_time" = NULL WHERE "checked_out_time" = '1970-01-01 00:00:00';