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

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 40
Last Commit: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 32,051
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -16
    • +6
    ./acs-create.sql
    • -0
    • +28
    ./upgrade/upgrade-5.1.2d2-5.1.2d3.sql
  3. … 2274 more files in changeset.
Tuesday 21 Sep 2004
2:17 am

rocaelh

putting create or replace instead of just create

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

donb

file upgrade-5.1.2d2-5.1.2d3.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./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
    ./acs-create.sql
    • -0
    • +28
    ./upgrade/upgrade-5.1.2d2-5.1.2d3.sql
  3. … 1 more file in changeset.
Monday 26 Jul 2004
2:21 pm

jeffd

preserve last_modified when explicitly updated, replaces acs_objects_last_mod_update_tr, bump version, upgrade scripts

Options
    • -3
    • +5
    ./acs-objects-create.sql
    • -0
    • +17
    ./upgrade/upgrade-5.2.0d6-5.2.0d7.sql
  3. … 3 more files in changeset.
Saturday 24 Jul 2004
4:44 pm

jeffd

fix some bugs which break things in pg7.5; mostly syntax errors in existing procs.

Options
    • -12
    • +25
    ./apm-create.sql
    • -2
    • +3
    ./lob.sql
    • -5
    • +5
    ./postgresql.sql
    • -0
    • +94
    ./upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  5. … 1 more file in changeset.
Monday 12 Jul 2004
4:49 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040628 and jcd-merge-5-1-20040712 to HEAD

Options
    • -8
    • +8
    ./groups-body-create.sql
    • -0
    • +40
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  3. … 115 more files in changeset.
Friday 09 Jul 2004
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
    • -9
    • +9
    ./groups-body-create.sql
    • -0
    • +40
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  3. … 2 more files in changeset.
11:01 am

jeffd

file upgrade-5.1.2d1-5.1.2d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  2. … 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
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.sql
10:15 pm

donb

Committing re-added upgrade file

Options
    • -0
    • +57
    ./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
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.sql
10:09 pm

donb

Upgrade to apply previous register parameter bug fix

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

donb

file upgrade-5.1.1d1-5.1.1d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.sql
1:29 pm

jeffd

name constraints and make lob_data.lob_id on delete cascade

Options
    • -2
    • +3
    ./apm-create.sql
    • -3
    • +7
    ./authentication-create.sql
    • -6
    • +10
    ./lob.sql
Wednesday 30 Jun 2004
8:20 pm

donb

Ported Andrew's Oracle patch to register parameter.

Options
    • -19
    • +14
    ./apm-create.sql
8:16 pm

donb

Ported Andrew's Oracle register parameter patch.

Options
    • -15
    • +13
    ./apm-create.sql
Tuesday 29 Jun 2004
12:17 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

Options
    • -1
    • +1
    ./upgrade/upgrade-5.0d2-5.0d3.sql
  2. … 687 more files in changeset.
Thursday 24 Jun 2004
6:20 pm

olah

Looks like someone snuck in a little 'x' too much.

Options
    • -2
    • +2
    ./apm-create.sql
5:03 pm

jeffd

make the apm_package_version_attr version_id on delete cascade, otherwise deleting packages fails

Options
    • -3
    • +4
    ./apm-create.sql
    • -2
    • +3
    ./upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  3. … 1 more file in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./acs-create-2.sql
    • -1
    • +1
    ./acs-create.sql
    • -1
    • +1
    ./acs-drop.sql
    • -1
    • +1
    ./acs-install.sql
    • -1
    • +1
    ./acs-kernel-create.sql
    • -1
    • +1
    ./acs-kernel-drop.sql
    • -1
    • +1
    ./acs-logs-create.sql
    • -1
    • +1
    ./acs-metadata-create.sql
    • -1
    • +1
    ./acs-metadata-drop.sql
    • -1
    • +1
    ./acs-objects-create.sql
    • -1
    • +1
    ./acs-objects-drop.sql
    • -1
    • +1
    ./acs-permissions-create.sql
    • -1
    • +1
    ./acs-permissions-drop.sql
    • -1
    • +1
    ./acs-relationships-create.sql
    • -1
    • +1
    ./acs-relationships-drop.sql
  16. … 18 more files in changeset.
Thursday 17 Jun 2004
1:22 pm

maltes

TYPO: should read parameter, not paramer

Options
    • -1
    • +1
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.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
    ./upgrade/upgrade-5.0d2-5.0d3.sql
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -2
    • +14
    ./upgrade/upgrade-4.6.3-4.6.4.sql
    • -2
    • +13
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -2
    • +8
    ./upgrade/upgrade-5.0d2-5.0d3.sql
  4. … 832 more files in changeset.
Monday 26 Apr 2004
8:50 pm

peterm

Adding new package version attributes maturity, license, and license_url. Introducing the concept of dynamic package version attributes so that these can be added easily in the future. The attributes are driven by a metadata spec returned by the proc apm::package_version::attributes::get_spec.The attributes are stored in the skinny table apm_package_version_attr and managed through the Tcl API in namespace apm::package_version::attributes. Changing the parse and generate info XML file procs to use the dynamic attributes. Adding the dynamic attributes to the manifest XML file as well. The attributes are editable in the APM admin UI.

Options
    • -0
    • +18
    ./apm-create.sql
    • -0
    • +15
    ./upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  3. … 9 more files in changeset.
Sunday 25 Apr 2004
11:52 am

donb

Applied the first patch contained in patch #397 (the other problem had

previously been fixed by someone else)

Options
    • -1
    • +176
    ./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
    ./upgrade/upgrade-4.6.3-4.6.4.sql
    • -2
    • +13
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -2
    • +8
    ./upgrade/upgrade-5.0d2-5.0d3.sql
Tuesday 20 Apr 2004
11:12 pm

jeffd

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

Options
    • -1
    • +2
    ./acs-install.sql
  2. … 647 more files in changeset.
Thursday 25 Mar 2004
4:08 pm

jeffd

bump the title, package_id tip 42 upgrade to 5.2.0d1-d2

Options
    • -1124
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
    • -0
    • +1124
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  3. … 3 more files in changeset.
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
    • -1
    • +2
    ./acs-install.sql
  2. … 1 more file in changeset.