OpenACS / openacs-4 / packages / acs-kernel / sql / oracle

upgrade

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 23
Last Commit: 21 Jun
Commits this week: 0
Total Lines of Code (LoC): 37,300
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 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 29 Dec 2003
8:45 pm

tracya

upgrade problems. Adding package headers to accompany bodies and adding site_nodes package so site_node.del is defined

Options
    • -18
    • +982
    ./upgrade-5.0d7-5.0d9.sql
Tuesday 23 Dec 2003
6:18 am

tracya

redifining acs-object package to use del instead of delete

Options
    • -2
    • +704
    ./upgrade-5.0d2-5.0d3.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -0
    • +73
    ./upgrade-5.0.0b1-5.0.0b2.sql
    • -0
    • +10
    ./upgrade-5.0.0b2-5.0.0b3.sql
    • -0
    • +37
    ./upgrade-5.0.0b3-5.0.0b4.sql
  4. … 596 more files in changeset.
Sunday 30 Nov 2003
2:17 am

donb

Fixed bug 1142 again (more?)

Options
    • -0
    • +37
    ./upgrade-5.0.0b3-5.0.0b4.sql
  2. … 4 more files in changeset.
2:17 am

donb

file upgrade-5.0.0b3-5.0.0b4.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade-5.0.0b3-5.0.0b4.sql
Friday 21 Nov 2003
11:09 pm

jeffd

Use lower(username) rather than upper(username), create case folded

indexes on postgres for username, email, screen_name, move some of

the queries in community-core-procs to .xql file.

rename the updgrade files...doh!

Options
    • -10
    • +0
    ./updgrade-5.0.0b2-5.0.0b3.sql
    • -0
    • +10
    ./upgrade-5.0.0b2-5.0.0b3.sql
  3. … 7 more files in changeset.
11:09 pm

jeffd

file upgrade-5.0.0b2-5.0.0b3.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade-5.0.0b2-5.0.0b3.sql
  2. … 1 more file in changeset.
Thursday 20 Nov 2003
10:24 pm

jeffd

file updgrade-5.0.0b2-5.0.0b3.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./updgrade-5.0.0b2-5.0.0b3.sql
  2. … 1 more file in changeset.
10:24 pm

jeffd

Change the all_users to acs_users_all, bump version to 5.0.0b3, provide

upgrade script. fix where its used in logger, weblogger-portlet, and lars-blogger.

fixes bug 1174.

Options
    • -0
    • +10
    ./updgrade-5.0.0b2-5.0.0b3.sql
  2. … 9 more files in changeset.
5:32 pm

jeffd

Adds max_child_sortkey to acs_objects, uses select for update to incr

tree_sortkey (fixes concurrency problems and substantially improves

performance), drop group_elem_idx_container_idx (not useful) and

acs_objects_context_object_idx (which is superflous since there is an

identical unique constraint). changes acs_objects_get_tree_sortkey to

be isstrict/iscachable fixes a bug in acs_objects_context_id_up_tr on

both oracle an postgres.

See http://openacs.org/forums/message-view?message_id=142769 for discussion.

Options
    • -0
    • +73
    ./upgrade-5.0.0b1-5.0.0b2.sql
  2. … 7 more files in changeset.
5:32 pm

jeffd

file upgrade-5.0.0b1-5.0.0b2.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade-5.0.0b1-5.0.0b2.sql
  2. … 1 more file in changeset.
Saturday 01 Nov 2003
1:27 pm

jeffd

the cc_users view in the upgrade did not match the current version of cc_users (cf http://openacs.org/forums/message-view?message_id=97099 )

Options
    • -5
    • +10
    ./upgrade-5.0d2-5.0d3.sql
Wednesday 22 Oct 2003
3:51 pm

peterm

adding forgotten view all_users to upgrade scripts

Options
    • -11
    • +18
    ./upgrade-5.0d9-5.0d13.sql
  2. … 1 more file in changeset.
Friday 17 Oct 2003
10:42 am

lars

Fixed upgrade script for authentication, collapsed two upgrade scripts

Options
    • -8
    • +31
    ./upgrade-5.0d2-5.0d3.sql
    • -26
    • +0
    ./upgrade-5.0d3-5.0d4.sql
  3. … 2 more files in changeset.
Thursday 16 Oct 2003
12:57 pm

lars

Fixed bug in auth_driver_params on Oracle, table had wrong unique constraint instead of primary key constraint

Options
    • -0
    • +17
    ./upgrade-5.0.0a1-5.0.0a2.sql
  2. … 2 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +5255
    ./upgrade-5.0d9-5.0d13.sql
  2. … 23 more files in changeset.
Wednesday 01 Oct 2003
1:23 pm

peterm

cannot set username to email for the unregistered visitor user since he/she has a null email

Options
    • -3
    • +7
    ./upgrade-5.0d2-5.0d3.sql
  2. … 1 more file in changeset.
Tuesday 30 Sep 2003
2:48 pm

peterm

the auth_auhtorities.help_contact_text_format column was missing from the upgrade scripts

Options
    • -7
    • +2
    ./upgrade-5.0d2-5.0d3.sql
  2. … 1 more file in changeset.
11:05 am

peterm

upgrade script fix: only creating admin rel role if it hasn't already been created by dotlrn

Options
    • -2
    • +10
    ./upgrade-4.6.5-4.6.6.sql
  2. … 1 more file in changeset.
Wednesday 24 Sep 2003
7:25 pm

peterm

when removing the apm_package.enabled_p column I forgot to remove the apm_package.enable/disable functions, so removing those now

Options
    • -289
    • +586
    ./upgrade-5.0d7-5.0d9.sql
  2. … 4 more files in changeset.
2:20 pm

peterm

Upgrading kernel to 5.0d9. Fixing bug 555 - Removing apm_packages.enabled_p column and taking the opportunity to remove obsolete file related datamodel

Options
    • -0
    • +565
    ./upgrade-5.0d7-5.0d9.sql
  2. … 3 more files in changeset.
Thursday 18 Sep 2003
7:08 pm

lars

Rewrote cookie handling

Options
    • -0
    • +12
    ./upgrade-5.0d6-5.0d7.sql
  2. … 9 more files in changeset.
Wednesday 10 Sep 2003
10:40 am

peterm

committed the authority__new function with more than 16 arguments which doesn't work in PG. Reverting back to 16 args

Options
    • -13
    • +3
    ./upgrade-5.0d2-5.0d3.sql
  2. … 4 more files in changeset.
Tuesday 09 Sep 2003
3:19 pm

peterm

making sort order default to the current highest sort order plus one for authorities

Options
    • -2
    • +12
    ./upgrade-5.0d2-5.0d3.sql
  2. … 3 more files in changeset.
1:15 pm

peterm

adding batch sync related columns to the auth_authorities table

Options
    • -8
    • +33
    ./upgrade-5.0d2-5.0d3.sql
  2. … 6 more files in changeset.
Friday 29 Aug 2003
6:26 pm

peterm

changing datatype to varchar for the key column of the parameters table in upgrade scripts

Options
    • -2
    • +2
    ./upgrade-5.0d3-5.0d4.sql
  2. … 1 more file in changeset.
Thursday 28 Aug 2003
1:35 pm

peterm

bugfix: cannot reference acs_sc_impl table from acs-kernel

Options
    • -2
    • +3
    ./upgrade-5.0d3-5.0d4.sql
  2. … 3 more files in changeset.
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -0
    • +41
    ./upgrade-4.6.3-4.6.4.sql
    • -0
    • +702
    ./upgrade-4.6.4-4.6.5.sql
    • -0
    • +118
    ./upgrade-4.6.5-4.6.6.sql
  4. … 814 more files in changeset.
9:54 am

peterm

adding datamodel for authority parameters and bumping version to 5.0d4

Options
    • -0
    • +25
    ./upgrade-5.0d3-5.0d4.sql
  2. … 4 more files in changeset.
Monday 25 Aug 2003
11:40 pm

donb

Corrected PG version of Barry Brooks speed up to the object update trigger,

added the new Oracle trigger to the proper upgrade script.

Options
    • -1
    • +68
    ./upgrade-5.0d-5.0d2.sql
  2. … 2 more files in changeset.