OpenACS / openacs-4 / packages / acs-kernel

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 44
Last Commit: 12 Sep 13
Commits this week: 0
Total Lines of Code (LoC): 62,025
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 31 Jan 2005
8:29 am

timoh

fixed some upgrade scripts for oracle

Options
    • -7
    • +16
    ./oracle/acs-objects-create.sql
    • -0
    • +714
    ./oracle/upgrade/upgrade-5.1.4-5.1.4d1.sql
  3. … 6 more files in changeset.
Tuesday 21 Sep 2004
2:17 am

rocaelh

putting create or replace instead of just create

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.1.2d2-5.1.2d3.sql
Monday 20 Sep 2004
10:18 pm

andrewg

Modified cc_users moving the magic object lookup to its own query. The view was really slow when joined against the acs_magic_objects table.

Options
    • -3
    • +2
    ./oracle/acs-create.sql
    • -0
    • +17
    ./oracle/upgrade/upgrade-5.1.2d2-5.1.2d3.sql
10:08 pm

donb

Changed cc_users and registered_users views to use the acs__magic_object_id

function that was written quite some time ago but never used in those views.

And those views are really slow when joined against the acs_magic_objects

table ...

Options
    • -15
    • +5
    ./postgresql/acs-create.sql
    • -0
    • +28
    ./postgresql/upgrade/upgrade-5.1.2d2-5.1.2d3.sql
  3. … 1 more file in changeset.
Friday 09 Jul 2004
11:43 am

jeffd

flip order of delete for group delete

Options
    • -10
    • +10
    ./oracle/groups-body-create.sql
11:01 am

jeffd

flip order of delete of rels and rel segments, bump version to 5.1.2d2, upgrade scripts for oracle and pg, bug 775 patch 267 Randy O'Meara

Options
    • -0
    • +192
    ./oracle/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
    • -9
    • +9
    ./postgresql/groups-body-create.sql
    • -0
    • +40
    ./postgresql/upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  4. … 1 more file in changeset.
Thursday 01 Jul 2004
10:18 pm

donb

Wouldn't let me tag after adding to HEAD so am committing directly...

Options
    • -0
    • +57
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
10:12 pm

donb

Oops did this wrong ... want to do exactly what Andrew did for consistency

Options
    • -61
    • +0
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
10:09 pm

donb

Upgrade to apply previous register parameter bug fix

Options
    • -0
    • +61
    ./postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql
Wednesday 30 Jun 2004
8:16 pm

donb

Ported Andrew's Oracle register parameter patch.

Options
    • -15
    • +13
    ./postgresql/apm-create.sql
Friday 25 Jun 2004
2:16 am

andrewg

Simplifying the cursor in apm.register_parameter to fix a bug, and make it simpler. Don's doing the PG version.

Options
    • -13
    • +7
    ./oracle/apm-create.sql
Tuesday 15 Jun 2004
5:48 pm

andrewg

Applied Dave's bugfix for \#1419 here to fix the same bug

Options
    • -1
    • +4
    ./oracle/upgrade/upgrade-5.0.0b4-5.0.0b5.sql
Monday 07 Jun 2004
6:56 pm

jeffd

do not create the cc_users_of_package_id view since we dont create application_users view anymore so its not used

Options
    • -6
    • +1
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
Wednesday 21 Apr 2004
1:07 pm

olah

Drop views with 'CASCADE' and recreate depending views. http://openacs.org/forums/message-view?message_id=177253

Options
    • -3
    • +15
    ./postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
    • -2
    • +13
    ./postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -2
    • +8
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
Friday 19 Mar 2004
2:06 pm

peterm

setting context_id of registered users group to be the main site package so that admin privilege on that package entitles you to add users. See http://openacs.org/forums/message-view?message_id=171339

Options
    • -2
    • +3
    ./oracle/acs-install.sql
    • -1
    • +2
    ./postgresql/acs-install.sql