Activity OpenACS/openacs-4/packages/acs-lang/sql/postgresql/ad-locales.sql

Tree
Accordion

Stats

Commits this week: 0

Total Committers:	13
Last Commit:	05 Apr
Commits this week:	0
Total Lines of Code (LoC):	403
Net change in LoC this week:	0

Commit Activity

last updated 2 hours ago

Constraints

Constraints: committers

Committer:

Log Comment:

Constraints: files

File Extension:

File Name:

Constraints: dates

Start Date:

End Date:

Thursday 14 Mar 2019

11:23 am

antoniop

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?

- -2
- +2
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 5 more files in changeset.

Tuesday 08 Aug 2017

1:47 am

gustafn

More
MAIN:gustafn:20170807234743
changed 7835 files
MAIN

merged changes from the oacs-5-9 branch and resolved conflicts

- -2
- +4
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 7834 more files in changeset.

Friday 21 Apr 2017

5:59 pm

gustafn

More
oacs-5-9:gustafn:20170421155920
changed 49 files
oacs-5-9

Fix spelling errors

- -2
- +2
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 48 more files in changeset.

Saturday 26 Nov 2016

8:42 am

gustafn

- make upgrade script more robust

- -2
- +1
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 1 more file in changeset.

Friday 25 Nov 2016

12:22 pm

antoniop

Add index on ad_locale_user_prefs for foreign key user_id

- -1
- +4
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 2 more files in changeset.

Sunday 17 Oct 2010

11:06 pm

donb

More
MAIN:donb:20101017210607
changed 215 files
MAIN

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.

- -18
- +1
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 214 more files in changeset.

Friday 14 May 2010

3:15 pm

emmar

More
oacs-5-6:emmar:20100514131545
changed 13 files
oacs-5-6

- Moves support for 3 chars language codes to ref-language

- Adds dependencies to ref-language and ref-countries

- Bumps version number

- -18
- +1
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 12 more files in changeset.

Monday 22 Mar 2010

1:51 am

donb

More
MAIN:donb:20100322005138
changed 2 files
MAIN

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 :(.

- -3
- +3
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 1 more file in changeset.

Friday 08 Jan 2010

6:39 pm

emmar

More
MAIN:emmar:20100108173958
changed 16 files
MAIN

Implements TIP#137 Support for 3-chars language codes

- -7
- +24
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 15 more files in changeset.

Saturday 07 Jun 2008

10:28 pm

donb

More
MAIN:donb:20080607202846
changed 284 files
MAIN

Merged from 5.4.2

- -3
- +10
./ad-locales.sql
- History
- Source
- Diff
./ad-locales.sql
… 283 more files in changeset.

Saturday 22 Mar 2008

11:25 pm

emmar

More
oacs-5-4:emmar:20080322222559
changed 10 files
oacs-5-4

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.