• last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Do not insert object_ids that do not exist in acs_object (leftover group message keys)

    • -1
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
Take also care to populate the newly created column with the group ids coming from automatically generated message keys

    • -0
    • +7
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d13-5.10.0d14.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d13-5.10.0d14.sql
Create index on the new lang_message_keys.object_id column

    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d12-5.10.0d13.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d12-5.10.0d13.sql
file upgrade-5.10.0d11-5.10.0d12.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
acs-lang reform

Provide an optional object_id which can be used to register message keys that will be bound to the lifecycle of an acs-object. When the object is deleted, so will the message key.

This is useful for groups that automatically define a message key for their pretty name. Tcl api was already aware of this and would cleanup such message keys, but other idioms e.g. stored procedures used to delete groups would leave leftovers behind. These can become relatively numerous on group-intensive systems such as LEARN.

Other future usages for this new feature might be the automatic localization of xowiki FormPage properties.

    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  1. … 6 more files in changeset.
Trim padding from column to be sure

Redefine ad_locales.language table column as varchar to avoid Oracle idiosyncrasies when comparing a char(n) with other string datatypes when using bind variables (following insightful LARS's remark)

char(n) in Oracle are automatically padded to be n characters long. Apparently, comparing char(n) -> char(n) is "blanks insensitive", while comparing char(n) -> varchar2(n) will account for such automatically inserted blanks. When using bind variables, one should carefully specify the type to use to avoid surprises with char(n) (for this we should touch the oracle driver), normalize the value via trim/pad all the time or replace every char(n) datatype with varchar2. ...are there other places where this is happening?

    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  1. … 2 more files in changeset.
file upgrade-5.10.0d2-5.10.0d3.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
Removed obsolete @arch-tag

  1. … 27 more files in changeset.
Fix typos

    • -1
    • +1
    ./oracle/upgrade/upgrade-4.1-4.7d2.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-4.1-4.7d2.sql
  1. … 5 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -0
    • +21
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  1. … 7828 more files in changeset.
Fix spelling errors

  1. … 43 more files in changeset.
- make upgrade script more robust

    • -2
    • +20
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
Add index on ad_locale_user_prefs for foreign key user_id

  1. … 1 more file in changeset.
file upgrade-5.9.1d1-5.9.1d2.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.9.1d1-5.9.1d2.sql
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2546 more files in changeset.
- change to dollar-quoting

Merged oacs-5-6 to HEAD. HEAD now installs and passes all core tests. There

may still be some lingering problems due to my screwing up the oacs-5-6

branch earlier, I'll be looking into this later.

    • -21
    • +1
    ./postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  1. … 209 more files in changeset.
- Moves support for 3 chars language codes to ref-language

- Adds dependencies to ref-language and ref-countries

- Bumps version number

    • -21
    • +1
    ./postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  1. … 7 more files in changeset.
And for PG too ...

Same change to pk constraint names as for initial install.

Changed primary key constraints to meet our naming conventions, because

the slightly non-standard name caused my pretty "no errors" page for this

package to turn red :(.

Implements TIP#137 Support for 3-chars language codes

    • -0
    • +6
    ./oracle/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
    • -0
    • +34
    ./oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
    • -0
    • +6
    ./postgresql/upgrade/upgrade-5.6.0d1-5.6.0d2.sql
    • -0
    • +34
    ./postgresql/upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  1. … 8 more files in changeset.
Merged from 5.4.2

  1. … 278 more files in changeset.
file upgrade-5.4.1d2-5.4.1d3.sql was initially added on branch oacs-5-4.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.4.1d2-5.4.1d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.4.1d2-5.4.1d3.sql
Add foreign key constraint on user_preferences.locale to force referencial integrity. This column is now added by acs-lang at creation time, to create the constraint at the same moment.

  1. … 6 more files in changeset.
file upgrade-5.4.1d1-5.4.1d2.sql was initially added on branch oacs-5-4.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.4.1d1-5.4.1d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.4.1d1-5.4.1d2.sql
Fixed for en_CA and fr_CA locale definitions

  1. … 1 more file in changeset.