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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Friday 08 Aug 2003
10:45 am

simonc

removed what looks like a copy-and-pase mistake at the end of the script

Options
    • -2
    • +1
    ./oracle/acs-permissions-create.sql
Wednesday 06 Aug 2003
7:58 pm

donb

"Registered users" had a join policy of "open", which meant a user could

visit the join group registration page manually and turn user_id 0 (the

public) into a registered user. Bad ...

Options
    • -2
    • +4
    ./oracle/acs-create.sql
    • -5
    • +2
    ./oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -2
    • +2
    ./postgresql/acs-create.sql
    • -5
    • +2
    ./postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
Thursday 17 Jul 2003
3:10 am

donb

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

Options
    • -2
    • +2
    ./oracle/apm-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.7.2d-5.0d.sql
    • -1
    • +1
    ./postgresql/apm-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
  5. … 30 more files in changeset.
Wednesday 16 Jul 2003
2:15 am

donb

Added code to allow loading of data for packages like ref-timezones with

SQL*Loader or PostgreSQL's COPY command.

Options
    • -1
    • +2
    ./oracle/apm-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-4.7.2d-5.0d.sql
    • -1
    • +2
    ./postgresql/apm-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
  5. … 5 more files in changeset.
Tuesday 15 Jul 2003
2:39 am

donb

Fixed typo oops!

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
2:38 am

donb

Added csv_data as a package file type ...

Options
    • -1
    • +2
    ./oracle/apm-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-4.7.2d-5.0d.sql
    • -0
    • +1
    ./postgresql/apm-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-4.7.2d-5.0d.sql
Saturday 12 Jul 2003
3:10 am

donb

1. removed some errant log statemets previously inserted when debugging

2. sql/common/*sql files weren't being displayed by the APM, are now

3. added index on start_date in timespan-create after user reported

very slow calendar queries in .LRN

Options
    • -65
    • +0
    ./postgresql/utilities-create.sql
  2. … 7 more files in changeset.
Friday 04 Jul 2003
2:22 pm

lars

1. Made object_id 0 be a user instead of a person;

2. Created a rel_type 'admin_rel' and corresponding role 'admin'.

Options
    • -1
    • +7
    ./oracle/acs-create.sql
    • -1
    • +48
    ./oracle/groups-body-create.sql
    • -1
    • +47
    ./oracle/groups-create.sql
    • -0
    • +121
    ./oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -1
    • +6
    ./postgresql/acs-create.sql
    • -0
    • +67
    ./postgresql/groups-body-create.sql
    • -15
    • +45
    ./postgresql/groups-create.sql
    • -0
    • +114
    ./postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
  9. … 1 more file in changeset.
2:22 pm

lars

file upgrade-4.6.5-4.6.6.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
Monday 23 Jun 2003
8:47 pm

janines

add user id and IP address to update_last_modified()

Options
    • -2
    • +6
    ./oracle/acs-objects-create.sql
    • -0
    • +702
    ./oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -10
    • +16
    ./postgresql/acs-objects-create.sql
    • -0
    • +47
    ./postgresql/upgrade/upgrade-4.6.4-4.6.5.sql
  5. … 7 more files in changeset.
8:47 pm

janines

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-4.6.4-4.6.5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6.4-4.6.5.sql
Monday 16 Jun 2003
6:19 pm

peterm

fixing lame = 0 instead of is null bug in register_parameter proc that would cause default values of new parameters to not be propagated to package instances during package upgrade

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
    • -1
    • +57
    ./postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
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
    ./oracle/upgrade/upgrade-4.6.3-4.6.4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
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
    ./oracle/community-core-create.sql
    • -0
    • +41
    ./oracle/upgrade/upgrade-4.6.3-4.6.4.sql
    • -1
    • +2
    ./postgresql/community-core-create.sql
    • -0
    • +61
    ./postgresql/upgrade/upgrade-4.6.3-4.6.4.sql
  5. … 1 more file in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -9
    • +11
    ./oracle/acs-create.sql
    • -1
    • +1
    ./oracle/acs-install.sql
    • -1
    • +11
    ./oracle/acs-metadata-create.sql
    • -1
    • +11
    ./oracle/acs-objects-create.sql
    • -66
    • +4
    ./oracle/acs-permissions-create.sql
    • -1
    • +1
    ./oracle/apm-create.sql
    • -3
    • +45
    ./oracle/groups-body-create.sql
    • -1
    • +1
    ./oracle/rel-segments-create.sql
    • -2
    • +1475
    ./oracle/upgrade/upgrade-4.6-4.6.1.sql
    • -0
    • +887
    ./oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -0
    • +31
    ./oracle/upgrade/upgrade-4.6.2-4.6.3.sql
    • -9
    • +12
    ./postgresql/acs-create.sql
    • -1
    • +1
    ./postgresql/acs-logs-create.sql
    • -0
    • +10
    ./postgresql/acs-metadata-create.sql
    • -8
    • +11
    ./postgresql/acs-objects-create.sql
  16. … 16 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
    ./oracle/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
    ./oracle/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
    ./oracle/acs-create.sql
    • -66
    • +4
    ./oracle/acs-permissions-create.sql
    • -9
    • +12
    ./postgresql/acs-create.sql
    • -46
    • +16
    ./postgresql/acs-permissions-create.sql
    • -1
    • +49
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
  6. … 7 more files in changeset.
Monday 21 Apr 2003
3:02 am

donb

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
3:00 am

donb

Changed a minor bug regarding the definition of user_tab_comments, bumped

to 4.6.3 and added an upgrade script (we may not release a 4.6.3 but if we

do, we're ready!)

Options
    • -131
    • +31
    ./postgresql/postgresql.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-4.6.2-4.6.3.sql
  3. … 1 more file 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
    ./oracle/groups-body-create.sql
    • -0
    • +211
    ./oracle/upgrade/upgrade-4.6.1-4.6.2.sql
    • -4
    • +38
    ./postgresql/groups-body-create.sql
    • -1
    • +1
    ./postgresql/rel-segments-create.sql
    • -0
    • +217
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
Sunday 23 Mar 2003
2:59 am

donb

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
    • -1
    • +26
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
  3. … 34 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
    ./oracle/acs-permissions-create.sql
    • -603
    • +458
    ./oracle/groups-body-create.sql
    • -119
    • +97
    ./oracle/rel-segments-body-create.sql
    • -223
    • +301
    ./oracle/rel-segments-create.sql
Monday 17 Mar 2003
10:58 pm

donb

Migrated the 4.6.1 permissions stuff to HEAD

Options
    • -318
    • +391
    ./oracle/acs-permissions-create.sql
    • -458
    • +603
    ./oracle/groups-body-create.sql
    • -97
    • +119
    ./oracle/rel-segments-body-create.sql
    • -301
    • +223
    ./oracle/rel-segments-create.sql
    • -32
    • +77
    ./postgresql/acs-create.sql
    • -318
    • +189
    ./postgresql/acs-permissions-create.sql
    • -2
    • +5
    ./postgresql/groups-body-create.sql
    • -1
    • +1
    ./postgresql/rel-segments-body-create.sql
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
    ./oracle/rel-segments-create.sql
    • -5
    • +8
    ./postgresql/groups-body-create.sql
    • -19
    • +25
    ./postgresql/rel-segments-create.sql
  4. … 36 more files in changeset.