OpenACS / openacs-4 / packages / acs-lang / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 1,446
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 14 Mar 2019
11:41 am

antoniop

Trim padding from column to be sure

Options
    • -0
    • +3
    ./upgrade/upgrade-5.10.0d2-5.10.0d3.sql
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?

Options
    • -2
    • +2
    ./ad-locales.sql
    • -0
    • +11
    ./upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  3. … 4 more files in changeset.
11:23 am

antoniop

file upgrade-5.10.0d2-5.10.0d3.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  2. … 1 more file in changeset.
Wednesday 15 Aug 2018
6:48 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
    • -1
    • +0
    ./upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  3. … 29 more files in changeset.
Tuesday 27 Mar 2018
2:43 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./upgrade/upgrade-4.1-4.7d2.sql
  2. … 6 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -2
    • +2
    ./ad-locales.sql
    • -2
    • +2
    ./message-catalog.sql
    • -1
    • +1
    ./upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  4. … 7832 more files in changeset.
Friday 21 Apr 2017
5:59 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./ad-locales.sql
    • -2
    • +2
    ./message-catalog.sql
    • -1
    • +1
    ./upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  4. … 46 more files in changeset.
Sunday 17 Oct 2010
11:06 pm

donb

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.

Options
    • -3
    • +2
    ./ad-locales-drop.sql
    • -18
    • +1
    ./ad-locales.sql
    • -21
    • +1
    ./upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  4. … 212 more files in changeset.
Friday 14 May 2010
3:15 pm

emmar

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

- Adds dependencies to ref-language and ref-countries

- Bumps version number

Options
    • -3
    • +2
    ./ad-locales-drop.sql
    • -18
    • +1
    ./ad-locales.sql
    • -21
    • +1
    ./upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  4. … 10 more files in changeset.
Monday 22 Mar 2010
2:24 am

donb

Same change to pk constraint names as for initial install.

Options
    • -2
    • +2
    ./upgrade/upgrade-5.6.0d2-5.6.0d3.sql
1:51 am

donb

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

Options
    • -3
    • +3
    ./ad-locales.sql
  2. … 1 more file in changeset.
Friday 08 Jan 2010
6:39 pm

emmar

Implements TIP#137 Support for 3-chars language codes

Options
    • -2
    • +3
    ./ad-locales-drop.sql
    • -9
    • +26
    ./ad-locales.sql
    • -0
    • +6
    ./upgrade/upgrade-5.6.0d1-5.6.0d2.sql
    • -0
    • +34
    ./upgrade/upgrade-5.6.0d2-5.6.0d3.sql
  5. … 12 more files in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -3
    • +13
    ./ad-locales.sql
    • -0
    • +6
    ./upgrade/upgrade-5.4.1d1-5.4.1d2.sql
    • -0
    • +4
    ./upgrade/upgrade-5.4.1d2-5.4.1d3.sql
  4. … 281 more files in changeset.
Saturday 22 Mar 2008
11:26 pm

emmar

file upgrade-5.4.1d2-5.4.1d3.sql was initially added on branch oacs-5-4.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.4.1d2-5.4.1d3.sql
  2. … 1 more file in changeset.
11:25 pm

emmar

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.

Options
    • -1
    • +11
    ./ad-locales.sql
    • -0
    • +4
    ./upgrade/upgrade-5.4.1d2-5.4.1d3.sql
  3. … 8 more files in changeset.
Wednesday 19 Mar 2008
7:44 pm

emmar

file upgrade-5.4.1d1-5.4.1d2.sql was initially added on branch oacs-5-4.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.4.1d1-5.4.1d2.sql
  2. … 1 more file in changeset.
7:44 pm

emmar

Fixed for en_CA and fr_CA locale definitions

Options
    • -3
    • +3
    ./ad-locales.sql
    • -0
    • +6
    ./upgrade/upgrade-5.4.1d1-5.4.1d2.sql
  3. … 3 more files in changeset.
Monday 14 May 2007
10:30 pm

donb

Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

Options
    • -2
    • +2
    ./ad-locales.sql
  2. … 324 more files in changeset.
Monday 23 Apr 2007
7:54 am

victorg

Importing catalog files from traslate.openacs.org for Openacs Core Packages (5.3.1)

and .LRN Packages (2.3.0).

Options
    • -2
    • +2
    ./ad-locales.sql
  2. … 996 more files in changeset.
Tuesday 26 Sep 2006
4:58 pm

byronl

Correction of name constraint

Options
    • -10
    • +10
    ./ad-locales.sql
    • -2
    • +2
    ./message-catalog.sql
  3. … 1 more file in changeset.
Saturday 24 Jun 2006
9:04 am

torbenb

adding locales, currently used in the development of accounting packages (from sql-ledger locales)

Options
    • -1
    • +87
    ./ad-locales.sql
    • -0
    • +97
    ./upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  3. … 3 more files in changeset.
Friday 23 Jun 2006
11:13 am

torbenb

removing file meant for head instead of oacs-5-2 stable

Options
    • -97
    • +0
    ./upgrade/upgrade-5.2.3b2-5.2.3b3.sql
  2. … 1 more file in changeset.
11:09 am

torbenb

reverting to 1.29.2.1 oacs-5-2 stable

Options
    • -92
    • +0
    ./ad-locales.sql
7:20 am

torbenb

adding new locales for oracle

Options
    • -1
    • +93
    ./ad-locales.sql
7:18 am

torbenb

adding upgrade script for new locales

Options
    • -0
    • +97
    ./upgrade/upgrade-5.2.3b2-5.2.3b3.sql
  2. … 1 more file in changeset.
7:18 am

torbenb

file upgrade-5.2.3b2-5.2.3b3.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.3b2-5.2.3b3.sql
  2. … 1 more file in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -1
    • +21
    ./ad-locales.sql
    • -0
    • +30
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
  3. … 720 more files in changeset.
Saturday 11 Feb 2006
4:27 pm

victorg

Fixing version from 5.2.2d2 to 5.2.3d2 ( We are releasing 5.2.3, not

5.2.2 :) ). Adding correct upgrade files.

Options
    • -30
    • +0
    ./upgrade/upgrade-5.2.2d1-5.2.2d2.sql
    • -0
    • +30
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
  3. … 3 more files in changeset.
4:27 pm

victorg

file upgrade-5.2.3d1-5.2.3d2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.3d1-5.2.3d2.sql
  2. … 1 more file in changeset.
Wednesday 01 Feb 2006
10:32 pm

victorg

Adding locales: es_CO, ind_ID, bg_BG, pa_IN

Options
    • -1
    • +21
    ./ad-locales.sql
    • -0
    • +30
    ./upgrade/upgrade-5.2.2d1-5.2.2d2.sql
  3. … 3 more files in changeset.