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

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 29
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 52,389
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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 06 Jun 2003
10:40 am

lars

file upgrade-4.6.3-4.6.4.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.3-4.6.4.sql
  2. … 1 more file in changeset.
10:39 am

lars

Added password_changed_date column to users table, so we can expire passwords after a certain number of days

Options
    • -2
    • +3
    ./community-core-create.sql
    • -0
    • +41
    ./upgrade/upgrade-4.6.3-4.6.4.sql
  3. … 3 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -9
    • +11
    ./acs-create.sql
    • -1
    • +1
    ./acs-install.sql
    • -1
    • +11
    ./acs-metadata-create.sql
    • -1
    • +11
    ./acs-objects-create.sql
    • -66
    • +4
    ./acs-permissions-create.sql
    • -1
    • +1
    ./apm-create.sql
    • -3
    • +45
    ./groups-body-create.sql
    • -1
    • +1
    ./rel-segments-create.sql
    • -2
    • +1475
    ./upgrade/upgrade-4.6-4.6.1.sql
    • -0
    • +887
    ./upgrade/upgrade-4.6.1-4.6.2.sql
    • -0
    • +31
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  12. … 20 more files in changeset.
Sunday 04 May 2003
2:33 am

donb

Forgot to add my upgrade script during my last commit ...

Options
    • -0
    • +31
    ./upgrade/upgrade-4.6.2-4.6.3.sql
2:33 am

donb

file upgrade-4.6.2-4.6.3.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.2-4.6.3.sql
1:51 am

donb

1. removed some needless LARS notices

2. removed acs_methods and friends from the permissions documentation

and got rid of the commented-out table stubs.

3. dropping of permissions was broken in PG, fixed that.

4. cc_users and registered_users views have been sped up.

5. removed an unused and incorrect proc from revision-procs

6. updated acs-kernel to 4.6.3

-------------------------------------------------------------------------------------

Options
    • -9
    • +11
    ./acs-create.sql
    • -66
    • +4
    ./acs-permissions-create.sql
  3. … 10 more files in changeset.
Monday 24 Mar 2003
9:30 pm

donb

Fixed a problem with the party_approved_member_map uncovered by Dave Bauer.

Options
    • -3
    • +45
    ./groups-body-create.sql
    • -0
    • +211
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  3. … 3 more files in changeset.
Friday 21 Mar 2003
3:57 pm

donb

Accidently dropped the latest PG rather than Oracle versions of these files

here.

Options
    • -382
    • +198
    ./acs-permissions-create.sql
    • -603
    • +458
    ./groups-body-create.sql
    • -119
    • +97
    ./rel-segments-body-create.sql
    • -223
    • +301
    ./rel-segments-create.sql
Monday 17 Mar 2003
10:58 pm

donb

Migrated the 4.6.1 permissions stuff to HEAD

Options
    • -318
    • +391
    ./acs-permissions-create.sql
    • -458
    • +603
    ./groups-body-create.sql
    • -97
    • +119
    ./rel-segments-body-create.sql
    • -301
    • +223
    ./rel-segments-create.sql
  5. … 4 more files in changeset.
Thursday 13 Mar 2003
9:22 pm

donb

Migrated over changes to move some GIF resources into a common subdirectory

in the subsite package, so anyone who can read the main site can read

the images (previously you had to grant read privs to "/doc" explicitly

to get the graphics stored by acs-datetime to show up.

Options
    • -18
    • +20
    ./rel-segments-create.sql
  2. … 38 more files in changeset.
Wednesday 05 Mar 2003
3:38 pm

lars

file upgrade-4.6.1-4.6.2.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  2. … 1 more file in changeset.
3:37 pm

lars

Upgrade to 4.6.2: APM changes and change in installation procedure

Options
    • -82
    • +1
    ./acs-install.sql
    • -6
    • +48
    ./apm-create.sql
    • -0
    • +676
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  4. … 4 more files in changeset.
Wednesday 26 Feb 2003
10:37 pm

jeffd

add email and url as acs_datatypes

Options
    • -1
    • +11
    ./acs-metadata-create.sql
    • -0
    • +13
    ./upgrade/upgrade-4.6-4.6.1.sql
  3. … 2 more files in changeset.
3:21 am

donb

A bunch of things

1. AOLserver 4.0's nsxml appears to expose a gcc bug which causes the

backwards-compatible "getattr" command to fail. I dug around nsxml

and it does appear to be a gcc bug. I changed to the proper nsxml v2

syntax.

2. In the course of exploring #1 above, I realized that the calls to

dom:: Tcl XML package commands were still being executed despite

being commented out. Typical Tcl misunderstanding on someone's part.

Net effect: we were parsing all APM .info files twice, once in Tcl

and once in ns_xml! Yuk!

3. Fixed a minor notifications bug - you couldn't delete a notification

request if any unsent notifications were pending, causing the homework

package to bomb if you deleted an uploaded homework file and the prof

hadn't yet received their notification.

4. Fixed an obscure corner case in my permissions denormalization code.

Options
    • -19
    • +21
    ./rel-segments-create.sql
    • -18
    • +24
    ./upgrade/upgrade-4.6-4.6.1.sql
  3. … 14 more files in changeset.
Wednesday 19 Feb 2003
10:54 pm

donb

My upgrade invalidated the acs_group package.

Options
    • -0
    • +182
    ./upgrade/upgrade-4.6-4.6.1.sql
9:26 am

jeffd

merge bug 180 fix to 4.6 branch

Options
    • -1
    • +1
    ./upgrade/upgrade-4.2-4.2.1.sql
Tuesday 18 Feb 2003
9:53 pm

donb

Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

Options
    • -27
    • +60
    ./acs-create.sql
    • -1
    • +17
    ./acs-install.sql
    • -18
    • +37
    ./acs-objects-create.sql
    • -19
    • +60
    ./groups-body-create.sql
    • -37
    • +208
    ./rel-segments-create.sql
  6. … 13 more files in changeset.
9:54 am

peterm

the upgrade scripts for message_catalog file type must check if the file type is already there since the upgrade script came so late

Options
    • -1
    • +14
    ./upgrade/upgrade-4.7d-4.7.2d.sql
  2. … 1 more file in changeset.
12:55 am

peterm

trying to fix issue with APM upgrade UI breaking on new APM filetype message_catalog described here: http://openacs.org/forums/message-view?message_id=80178 Issuing warning in log file instead of erroring out on un-recognized filetypes. Adding upgrade script to acs-kernel that adds the message_catalog filetype

Options
    • -0
    • +1
    ./upgrade/upgrade-4.7d-4.7.2d.sql
  2. … 3 more files in changeset.
Sunday 16 Feb 2003
3:15 am

donb

Minor bug fix tweaks to the Oracle version, and some rewriting on the

PostgreSQL side to better match the structure of the Oracle side.

Options
    • -2
    • +3
    ./groups-body-create.sql
    • -1
    • +1
    ./upgrade/upgrade-4.6-4.6.1.sql
  3. … 3 more files in changeset.
Saturday 15 Feb 2003
11:30 pm

jeffd

change the delete from acs_permissions to be a dynamic sql delete since the table is not defined at the time the package body is created. Its a hack but further cleanup will have to wait for 4.7

Options
    • -2
    • +9
    ./acs-objects-create.sql
    • -1
    • +8
    ./upgrade/upgrade-4.6-4.6.1.sql
9:56 pm

donb

Fixed various problems with the new permissions and minor main site changes

Options
    • -0
    • +19
    ./acs-create.sql
    • -3
    • +4
    ./acs-install.sql
    • -2
    • +2
    ./acs-objects-create.sql
    • -49
    • +35
    ./groups-body-create.sql
    • -2
    • +2
    ./rel-segments-create.sql
    • -31
    • +79
    ./upgrade/upgrade-4.6-4.6.1.sql
2:10 pm

jeffd

finish my sentence about why the pkg body being replaced. Thanks Don.

Options
    • -1
    • +2
    ./upgrade/upgrade-4.6-4.6.1.sql
4:23 am

donb

First cut at Oracle perm rewrite and some whacking around on the PG version

Options
    • -41
    • +55
    ./acs-create.sql
    • -1
    • +16
    ./acs-install.sql
    • -18
    • +37
    ./acs-objects-create.sql
    • -139
    • +28
    ./acs-permissions-create.sql
    • -1
    • +55
    ./groups-body-create.sql
    • -37
    • +208
    ./rel-segments-create.sql
    • -0
    • +595
    ./upgrade/upgrade-4.6-4.6.1.sql
  8. … 4 more files in changeset.
Thursday 13 Feb 2003
11:30 pm

jeffd

delete direct permissions in acs_object__delete (oracle and postgres) upgrade provided, bug 234 patch 74 Tilmann Singer

Options
    • -1
    • +4
    ./acs-objects-create.sql
    • -2
    • +623
    ./upgrade/upgrade-4.6-4.6.1.sql
  3. … 2 more files in changeset.
Friday 31 Jan 2003
5:17 pm

peterm

acs-install.sql doesn't need to instantiate acs-kernel as this is done during install of that package (since it's a singleton)

Options
    • -17
    • +3
    ./acs-install.sql
  2. … 1 more file in changeset.
3:01 pm

peterm

Adding missing piece to the db upgrade of acs-kernel 4.6.1-4.7d - the callbacks were not being copied when upgrading a package through the edit package page. Changing to create or replace syntax for functions in PG (works in 7.2 and 7.1 is deprecated)

Options
    • -1
    • +6
    ./apm-create.sql
    • -0
    • +5
    ./upgrade/upgrade-4.6.1-4.7d.sql
  3. … 2 more files in changeset.
Thursday 30 Jan 2003
3:08 pm

peterm

moving instantiation and mounting of all core packages (acs-lang, acs-admin, api-doc etc.) except acs-kernel and main site (retained because they are needed during install) from the acs-install.sql file to the Tcl proc apm_mount_core_packages that is invoked on first startup. Note that this unfortunately means that callbacks will not be invoked for the main site node and for the acs-kernel instance.

Options
    • -94
    • +1
    ./acs-install.sql
  2. … 5 more files in changeset.
Wednesday 29 Jan 2003
10:43 am

peterm

as part of the sql upgrade of acs-kernel from 4.6.1 to 4.7d I forgot to change views and plsql code. Adding these changes now to make the upgrade complete

Options
    • -6
    • +11
    ./apm-create.sql
    • -1
    • +638
    ./upgrade/upgrade-4.6.1-4.7d.sql
  3. … 2 more files in changeset.
Monday 27 Jan 2003
11:36 am

peterm

upgrading acs-kernel from 4.6.1 to 4.7d to support APM auto mounting of packages, and Tcl procedure package callbacks such as after-install, after-instantiate, and after-mount. Upgrade scripts supplied to add table apm_package_callbacks and add column auto_mount to table apm_package_versions.

Options
    • -1
    • +8
    ./apm-create.sql
    • -0
    • +34
    ./upgrade/upgrade-4.6.1-4.7d.sql
  3. … 3 more files in changeset.