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: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 85,961
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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 25 Sep 2003
10:59 am

peterm

when removing file db model, forgot to replace reference to apm_package_files.path%TYPE with varchar. Doing so now and changing upgrade script

Options
    • -2
    • +2
    ./postgresql/apm-create.sql
    • -0
    • +47
    ./postgresql/upgrade/upgrade-5.0d7-5.0d9.sql
9:35 am

peterm

removing call to apm_package.enable (proc no longer exists)

Options
    • -2
    • +1
    ./oracle/acs-install.sql
    • -3
    • +0
    ./postgresql/acs-install.sql
4:38 am

vinodk

removed comment on apm_packages.enabled_p since the column's gone

Options
    • -6
    • +0
    ./postgresql/apm-create.sql
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
    • -31
    • +1
    ./oracle/apm-create.sql
    • -289
    • +586
    ./oracle/upgrade/upgrade-5.0d7-5.0d9.sql
    • -22
    • +0
    ./postgresql/apm-create.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.0d7-5.0d9.sql
  5. … 1 more file 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
    • -174
    • +4
    ./oracle/apm-create.sql
    • -0
    • +565
    ./oracle/upgrade/upgrade-5.0d7-5.0d9.sql
    • -151
    • +0
    ./postgresql/apm-create.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-5.0d7-5.0d9.sql
Monday 22 Sep 2003
1:52 pm

lars

Applied patch #280 for bug #820

Options
    • -2
    • +2
    ./postgresql/acs-objects-create.sql
    • -1
    • +47
    ./postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
Thursday 18 Sep 2003
7:08 pm

lars

Rewrote cookie handling

Options
    • -1
    • +3
    ./oracle/community-core-create.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-5.0d6-5.0d7.sql
    • -0
    • +2
    ./postgresql/community-core-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.0d6-5.0d7.sql
  5. … 6 more files in changeset.
Tuesday 16 Sep 2003
3:03 pm

lars

Removed snapshot_p flag from data model, and moved into auth_sync_retrieve service contract

Options
    • -7
    • +1
    ./oracle/authentication-create.sql
    • -5
    • +1
    ./postgresql/authentication-create.sql
  3. … 1 more file in changeset.
Thursday 11 Sep 2003
11:27 am

peterm

adding format column for the help_contact_text richtext column

Options
    • -1
    • +2
    ./oracle/authentication-create.sql
    • -1
    • +2
    ./postgresql/authentication-create.sql
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
    • -12
    • +2
    ./oracle/authentication-package-create.sql
    • -13
    • +3
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -4
    • +0
    ./postgresql/acs-create.sql
    • -15
    • +5
    ./postgresql/authentication-package-create.sql
    • -16
    • +6
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
Tuesday 09 Sep 2003
3:19 pm

peterm

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

Options
    • -1
    • +11
    ./oracle/authentication-package-create.sql
    • -2
    • +12
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -2
    • +10
    ./postgresql/authentication-package-create.sql
    • -3
    • +11
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
1:15 pm

peterm

adding batch sync related columns to the auth_authorities table

Options
    • -2
    • +18
    ./oracle/authentication-create.sql
    • -2
    • +12
    ./oracle/authentication-package-create.sql
    • -8
    • +33
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -0
    • +4
    ./postgresql/acs-create.sql
    • -3
    • +14
    ./postgresql/authentication-create.sql
    • -5
    • +15
    ./postgresql/authentication-package-create.sql
    • -12
    • +37
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
Friday 05 Sep 2003
3:26 pm

peterm

seems create or replace view doesn't work with PG 7.2 so changing to create view

Options
    • -1
    • +1
    ./postgresql/acs-create.sql
Thursday 04 Sep 2003
5:47 pm

daveb

Added all_users view to get basic user info without all the baggae of cc_users.

Options
    • -0
    • +10
    ./postgresql/acs-create.sql
4:35 pm

lars

I messed up with that Main Site -> Home change. Turns out there's code all over the place which depends on that name

Options
    • -2
    • +2
    ./oracle/acs-install.sql
    • -2
    • +2
    ./postgresql/acs-install.sql
1:17 pm

lars

Renamed Main Site to Home (uh-oh, hope I won't get kicked and yelled at)

Options
    • -3
    • +3
    ./oracle/acs-install.sql
    • -2
    • +2
    ./postgresql/acs-install.sql
Wednesday 03 Sep 2003
9:52 pm

lars

Just an indentation fix

Options
    • -15
    • +17
    ./postgresql/authentication-create.sql
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
    ./oracle/upgrade/upgrade-5.0d3-5.0d4.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-5.0d3-5.0d4.sql
5:21 pm

peterm

making key column in parameters table varchar instead of clob (text)

Options
    • -2
    • +2
    ./oracle/authentication-create.sql
    • -2
    • +2
    ./postgresql/authentication-create.sql
Thursday 28 Aug 2003
1:35 pm

peterm

bugfix: cannot reference acs_sc_impl table from acs-kernel

Options
    • -2
    • +3
    ./oracle/authentication-create.sql
    • -2
    • +3
    ./oracle/upgrade/upgrade-5.0d3-5.0d4.sql
    • -2
    • +3
    ./postgresql/authentication-create.sql
    • -2
    • +3
    ./postgresql/upgrade/upgrade-5.0d3-5.0d4.sql
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
    • -3
    • +11
    ./oracle/acs-create.sql
    • -2
    • +6
    ./oracle/acs-objects-create.sql
    • -1
    • +2
    ./oracle/community-core-create.sql
    • -1
    • +48
    ./oracle/groups-body-create.sql
    • -1
    • +47
    ./oracle/groups-create.sql
    • -0
    • +41
    ./oracle/upgrade/upgrade-4.6.3-4.6.4.sql
    • -0
    • +702
    ./oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -0
    • +118
    ./oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -3
    • +8
    ./postgresql/acs-create.sql
    • -10
    • +16
    ./postgresql/acs-objects-create.sql
    • -1
    • +1
    ./postgresql/apm-create.sql
    • -0
    • +1
    ./postgresql/community-core-create.sql
    • -0
    • +67
    ./postgresql/groups-body-create.sql
    • -15
    • +45
    ./postgresql/groups-create.sql
    • -0
    • +117
    ./postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
  16. … 802 more files in changeset.
9:54 am

peterm

adding datamodel for authority parameters and bumping version to 5.0d4

Options
    • -1
    • +17
    ./oracle/authentication-create.sql
    • -0
    • +25
    ./oracle/upgrade/upgrade-5.0d3-5.0d4.sql
    • -1
    • +17
    ./postgresql/authentication-create.sql
    • -0
    • +25
    ./postgresql/upgrade/upgrade-5.0d3-5.0d4.sql
  5. … 1 more file 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
    ./oracle/upgrade/upgrade-5.0d-5.0d2.sql
    • -2
    • +2
    ./postgresql/acs-objects-create.sql
    • -3
    • +3
    ./postgresql/upgrade/upgrade-5.0d-5.0d2.sql
Sunday 24 Aug 2003
2:27 am

donb

Modified Barry Brooks's context_id update trigger speedup for PostgreSQL,

did some testing ...

Options
    • -7
    • +11
    ./postgresql/acs-objects-create.sql
    • -1
    • +78
    ./postgresql/upgrade/upgrade-5.0d-5.0d2.sql
1:47 am

donb

Added Barry Brook's speed-up to the object context update trigger (untested as

yet, will get Janine to test at Sloan)

Options
    • -8
    • +8
    ./oracle/acs-objects-create.sql
Friday 22 Aug 2003
5:05 pm

lars

Changed acs_user.new and acs.add_user to take authority_id and username. Removed password_question/answer to make room.

Options
    • -6
    • +6
    ./oracle/acs-create.sql
    • -9
    • +18
    ./oracle/community-core-create.sql
    • -25
    • +55
    ./postgresql/acs-create.sql
    • -44
    • +76
    ./postgresql/community-core-create.sql
3:54 pm

lars

We cannot create the local authority in authentication-procs, because acs_magic_objects isn't defined until acs-create.sql, and is referenced by a trigger on acs-objects.

Options
    • -0
    • +12
    ./oracle/acs-create.sql
    • -13
    • +1
    ./oracle/authentication-create.sql
    • -0
    • +28
    ./postgresql/acs-create.sql
    • -20
    • +1
    ./postgresql/authentication-create.sql
3:31 pm

peterm

fixing broken installation: changing service contract implementation id columns in the auth_authorities table to reference acs_objects instead of acs_sc_impls table as the latter table is created later

Options
    • -4
    • +5
    ./oracle/authentication-create.sql
    • -4
    • +5
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -4
    • +5
    ./postgresql/authentication-create.sql
    • -4
    • +5
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
1:38 pm

peterm

Support for external authentication: two new columns added to users table - username and authority. New object type authority with corresponding table auth_authorities. Bumping version number to 5.0d3

Options
    • -1
    • +2
    ./oracle/acs-kernel-create.sql
    • -1
    • +2
    ./oracle/acs-kernel-drop.sql
    • -0
    • +95
    ./oracle/authentication-create.sql
    • -0
    • +28
    ./oracle/authentication-drop.sql
    • -0
    • +93
    ./oracle/authentication-package-create.sql
    • -0
    • +6
    ./oracle/authentication-package-drop.sql
    • -5
    • +15
    ./oracle/community-core-create.sql
    • -0
    • +215
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -0
    • +1
    ./postgresql/acs-kernel-create.sql
    • -0
    • +1
    ./postgresql/acs-kernel-drop.sql
    • -0
    • +97
    ./postgresql/authentication-create.sql
    • -0
    • +32
    ./postgresql/authentication-drop.sql
    • -0
    • +85
    ./postgresql/authentication-package-create.sql
    • -0
    • +25
    ./postgresql/authentication-package-drop.sql
    • -19
    • +29
    ./postgresql/community-core-create.sql
    • -0
    • +204
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
  17. … 1 more file in changeset.
Friday 15 Aug 2003
4:35 pm

peterm

adding locale and timezone to user_preferences table. Adding default_locale to apm_packages table

Options
    • -2
    • +4
    ./oracle/apm-create.sql
    • -2
    • +4
    ./oracle/community-core-create.sql
    • -0
    • +23
    ./oracle/upgrade/upgrade-4.7.2d-5.0d.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-5.0d-5.0d2.sql
    • -1
    • +3
    ./postgresql/apm-create.sql
    • -1
    • +3
    ./postgresql/community-core-create.sql
    • -0
    • +23
    ./postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.0d-5.0d2.sql
  9. … 1 more file in changeset.