• last updated 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- use entities for single quotes

- use consistently varchar(1000) for object_types

- bump version number to 5.9.1d3

file upgrade-5.9.1d2-5.9.1d3.sql was initially added on branch oacs-5-9.

Remove type discrepancy introduced in 2002:

- acs_object_types.object_type has type varchar(1000), while

- acs_object_types.supertype has type varchar(100)

... several more data types are involved, using acs_object_types.object_type as foreign key

file upgrade-5.9.1d8-5.9.1d9.sql was initially added on branch oacs-5-9.

- remove unneeded line

- Slightly faster (around 10%) versions for the base permission query functions.

In the new versions the lookup of acs__magic_object_id was moved out of the loop.

file upgrade-5.9.1d7-5.9.1d8.sql was initially added on branch oacs-5-9.

- rename attribute "tag" to "originating_rel_id" to avoid confusion

- Create an "identity relationship" (-10)

- Use the new identity relation instead of value "0" in party_approved_member_map

- Add a foreign key to avoid garbage in "originating_rel_id"

- Speed up referential integrity

- Improve get_func_definition() to return SQL function/procedure

definitions with argument names and defaults (contained just types before)

file upgrade-5.9.1d6-5.9.1d7.sql was initially added on branch oacs-5-9.

- Add a redirector for outdated releases

clean up of inconsistency between old and new installations

--

-- Since many years, new installations are created with "Registered

-- Users" (object_id -2) having object_type as "application_group" and

-- the context id of the main subsite (see

-- acs-kernel/sql/postgresql/acs-install.sql).

--

-- However, it seems as if some prior upgrade scripts have not cared

-- sufficiently to update all installation correctly (some have still

-- "group", some have no context_id set). This upgrade script tries to

-- bring everything in sync such that "newer" and "older"

-- installations behave the same.

--

file upgrade-5.9.1d5-5.9.1d6.sql was initially added on branch oacs-5-9.

- handle HTML5 attribute "autocomplete"

    • -2
    • +2
    /openacs-4/packages/xowiki/xowiki.info
- use entities for apostrophes in xml/html/adp to ease life of sonarsrv checker

  1. … 308 more files in changeset.
- modernize HTML

    • -1
    • +1
    /openacs-4/packages/dotlrn/www/clone.adp
    • -2
    • +2
    /openacs-4/packages/dotlrn/www/members-chunk.adp
  1. … 14 more files in changeset.
- modernize HTML

    • -531
    • +531
    /openacs-4/packages/chat/www/doc/design.html
    • -245
    • +245
    /openacs-4/packages/chat/www/doc/requirements.html
- modernize HTML

  1. … 192 more files in changeset.
- replace <b> and <i> tags by <strong> and <em> tags

- improve validity of HTML

- updated postgres information (removed fully obsolete information and broken links)

- updated constraint naming (_idx was missing)

  1. … 106 more files in changeset.
- brace expression

- modernize SQL

- apply fresh patches to oacs-5-9 branch

    • -15
    • +15
    /openacs-4/packages/chat/tcl/chat-procs.tcl
    • -3
    • +3
    /openacs-4/packages/chat/www/grant-entry.adp
    • -1
    • +1
    /openacs-4/packages/chat/www/html-chat.adp
    • -4
    • +4
    /openacs-4/packages/chat/www/html-chat.tcl
    • -3
    • +3
    /openacs-4/packages/chat/www/index.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/java-chat.adp
  1. … 39 more files in changeset.
- tighten page contracts

    • -2
    • +2
    /openacs-4/packages/chat/www/room-delete-2.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/room-delete.tcl
    • -1
    • +1
    /openacs-4/packages/chat/www/room-edit.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/room-enter.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/room-exit.tcl
  1. … 15 more files in changeset.
- make sure, only swa try to execute this script

- modernize HTML markup

- follow adp converions for properties

    • -3
    • +3
    /openacs-4/packages/chat/www/grant-entry.adp
    • -1
    • +1
    /openacs-4/packages/chat/www/html-chat.adp
    • -2
    • +2
    /openacs-4/packages/chat/www/java-chat.adp
    • -2
    • +2
    /openacs-4/packages/chat/www/noactive.adp
    • -3
    • +3
    /openacs-4/packages/chat/www/room-delete.adp
    • -2
    • +2
    /openacs-4/packages/chat/www/room-edit.adp
    • -2
    • +2
    /openacs-4/packages/chat/www/search-2.adp
    • -2
    • +2
    /openacs-4/packages/chat/www/search.adp
  1. … 5 more files in changeset.
- remove deprecated calls

    • -2
    • +2
    /openacs-4/packages/chat/tcl/chat-procs.tcl
    • -3
    • +3
    /openacs-4/packages/chat/www/html-chat.tcl
    • -3
    • +3
    /openacs-4/packages/chat/www/index.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/room-delete-2.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/room-delete.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/search-2.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/search-3.tcl
  1. … 5 more files in changeset.
- modernize Tcl

    • -14
    • +14
    /openacs-4/packages/chat/tcl/chat-procs.tcl
    • -1
    • +1
    /openacs-4/packages/chat/www/html-chat.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/room-enter.tcl
    • -2
    • +2
    /openacs-4/packages/chat/www/room-exit.tcl
    • -10
    • +10
    /openacs-4/packages/chat/www/search-2.tcl
- use base tables in queries instead of mega-view cc_users