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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 22 Oct 2003
3:51 pm

peterm

adding forgotten view all_users to upgrade scripts

Options
    • -11
    • +18
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
Friday 17 Oct 2003
10:42 am

lars

Fixed upgrade script for authentication, collapsed two upgrade scripts

Options
    • -8
    • +31
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -26
    • +0
    ./oracle/upgrade/upgrade-5.0d3-5.0d4.sql
    • -7
    • +29
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
    • -26
    • +0
    ./postgresql/upgrade/upgrade-5.0d3-5.0d4.sql
1:56 am

lars

Added all_users view to Oracle

Options
    • -0
    • +10
    ./oracle/acs-create.sql
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
    • -2
    • +3
    ./oracle/authentication-create.sql
    • -0
    • +17
    ./oracle/upgrade/upgrade-5.0.0a1-5.0.0a2.sql
  3. … 1 more file in changeset.
Friday 10 Oct 2003
1:35 pm

lars

Fixed bug #657: Create admin rel segment for main site

Options
    • -1
    • +12
    ./oracle/acs-install.sql
    • -0
    • +24
    ./postgresql/acs-install.sql
Wednesday 08 Oct 2003
6:53 pm

mohanp

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

Options
    • -0
    • +5255
    ./oracle/upgrade/upgrade-5.0d9-5.0d13.sql
  2. … 23 more files in changeset.
1:30 pm

lars

Added Andrew's OpenACS authentication server as a separate package

Options
    • -2
    • +1
    ./postgresql/authentication-create.sql
  2. … 11 more files in changeset.
11:58 am

lars

Added column user_info_impl_id for on-demand-sync, cleaned up comments

Options
    • -7
    • +11
    ./oracle/authentication-create.sql
    • -7
    • +11
    ./postgresql/authentication-create.sql
Monday 06 Oct 2003
3:16 pm

peterm

making acs__remove_user do what the Oracle version already does, i.e. remove records referencing the user record before attempting to delete it. Version number bumped to 5.0d12

Options
    • -2
    • +13
    ./postgresql/acs-create.sql
    • -0
    • +27
    ./postgresql/upgrade/upgrade-5.0d11-5.0d12.sql
  3. … 1 more file 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
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -2
    • +5
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
Tuesday 30 Sep 2003
5:59 pm

peterm

forgot to set legacy users authority_id to local in upgrade script

Options
    • -2
    • +7
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
2:48 pm

peterm

the auth_auhtorities.help_contact_text_format column was missing from the upgrade scripts

Options
    • -7
    • +2
    ./oracle/upgrade/upgrade-5.0d2-5.0d3.sql
    • -6
    • +2
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -15
    • +23
    ./oracle/acs-create.sql
    • -6
    • +6
    ./oracle/acs-objects-create.sql
    • -4
    • +4
    ./oracle/acs-relationships-create.sql
    • -37
    • +37
    ./oracle/apm-create.sql
    • -1
    • +1
    ./oracle/authentication-package-create.sql
    • -16
    • +16
    ./oracle/community-core-create.sql
    • -15
    • +19
    ./oracle/groups-body-create.sql
    • -5
    • +5
    ./oracle/groups-create.sql
    • -7
    • +7
    ./oracle/journal-create.sql
    • -4
    • +4
    ./oracle/rel-constraints-body-create.sql
    • -8
    • +15
    ./oracle/rel-constraints-create.sql
    • -6
    • +6
    ./oracle/rel-segments-body-create.sql
    • -2
    • +2
    ./oracle/rel-segments-create.sql
    • -2
    • +2
    ./oracle/rel-segments-drop.sql
    • -5
    • +5
    ./oracle/site-nodes-create.sql
  16. … 261 more files in changeset.
11:45 am

peterm

upgrade script fix: cannot drop columns with PG 7.2. Also, shouldn't say drop table CASCADE with PG 7.2

Options
    • -3
    • +4
    ./postgresql/upgrade/upgrade-5.0d7-5.0d9.sql
11:32 am

peterm

upgrade script fix: authority__new had too many arguments. Seems we cannot alter a column to have not null constraint

Options
    • -6
    • +3
    ./postgresql/upgrade/upgrade-5.0d2-5.0d3.sql
11:05 am

peterm

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

Options
    • -2
    • +10
    ./oracle/upgrade/upgrade-4.6.5-4.6.6.sql
    • -1
    • +18
    ./postgresql/upgrade/upgrade-4.6.5-4.6.6.sql
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