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

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 29
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 52,389
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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 22 Feb 2005
9:40 pm

jeffd

rename upgrade-4.6.1-4.7d.sql to upgrade-4.6.1d1-4.6.1d2.sql so the ordering of application is no longer ambiguous

Options
    • -676
    • +0
    ./upgrade/upgrade-4.6.1-4.7d.sql
    • -0
    • +676
    ./upgrade/upgrade-4.6.1d1-4.6.1d2.sql
  3. … 2 more files in changeset.
Monday 31 Jan 2005
8:30 am

timoh

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.4-5.1.4d1.sql
8:29 am

timoh

fixed some upgrade scripts for oracle

Options
    • -7
    • +16
    ./acs-objects-create.sql
    • -0
    • +714
    ./upgrade/upgrade-5.1.4-5.1.4d1.sql
  3. … 6 more files in changeset.
Tuesday 18 Jan 2005
5:22 pm

andrewg

Bugfix for apm_package.new. Moved the insert into apm_packages up, before the update on acs_objects, to satisfy referential integrity on acs_object.package_id.

Options
    • -6
    • +6
    ./apm-create.sql
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
    • -3
    • +2
    ./acs-create.sql
    • -0
    • +17
    ./upgrade/upgrade-5.1.2d2-5.1.2d3.sql
  3. … 2274 more files in changeset.
Monday 06 Dec 2004
1:04 pm

timoh

added check to prevent insert of object with empty creation_date

Options
    • -2
    • +9
    ./acs-objects-create.sql
Monday 20 Sep 2004
10:21 pm

andrewg

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: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
    ./acs-create.sql
    • -0
    • +17
    ./upgrade/upgrade-5.1.2d2-5.1.2d3.sql
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
    • -1
    • +6
    ./acs-objects-create.sql
    • -0
    • +15
    ./upgrade/upgrade-5.2.0d6-5.2.0d7.sql
  3. … 3 more files 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
    • -9
    • +9
    ./groups-body-create.sql
    • -0
    • +192
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  3. … 115 more files in changeset.
Friday 09 Jul 2004
11:43 am

jeffd

flip order of delete for group delete

Options
    • -10
    • +10
    ./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
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  2. … 3 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
1:29 pm

jeffd

name constraints

Options
    • -1
    • +4
    ./apm-create.sql
    • -3
    • +7
    ./authentication-create.sql
Wednesday 30 Jun 2004
10:04 pm

andrewg

Update to apm package body in v1.26.2.1 of apm-create.sql,to include a bugfix/simplication to the cursor in apm.register_parameter.

Options
    • -0
    • +384
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.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
    • -13
    • +7
    ./apm-create.sql
  2. … 687 more files in changeset.
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
    ./apm-create.sql
Thursday 24 Jun 2004
5:05 pm

jeffd

make the apm_package_version_attr version_id on delete cascade, otherwise deleting packages fails (forgot oracle file)

Options
    • -3
    • +4
    ./apm-create.sql
    • -3
    • +3
    ./upgrade/upgrade-5.2.0d3-5.2.0d4.sql
5:03 pm

jeffd

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

Options
    • -0
    • +1
    ./upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  2. … 2 more files in changeset.
Tuesday 15 Jun 2004
6:25 pm

andrewg

Merging fix from oacs-5-1 branch onto HEAD

Options
    • -1
    • +4
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
5:48 pm

andrewg

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

Options
    • -1
    • +4
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
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
    • -1
    • +17
    ./apm-create.sql
    • -0
    • +15
    ./upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  3. … 9 more files in changeset.
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
    • -2
    • +3
    ./acs-install.sql
  2. … 647 more files in changeset.
Tuesday 06 Apr 2004
9:50 pm

andrewg

Removing acs_objects_package_id_fk constraint, which was breaking the install. We can put it back in and have things work if we first rearrange the code in apm_package.new to perform the insert into apm_packages before the update on acs_objects. But for now we'll do as the PG version does, which is to not define the constraint at all.

Options
    • -4
    • +1
    ./apm-create.sql
Thursday 25 Mar 2004
4:08 pm

jeffd

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

Options
    • -2643
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
    • -0
    • +2643
    ./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
    • -2
    • +3
    ./acs-install.sql
  2. … 1 more file in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -3
    • +4
    ./acs-create.sql
    • -6
    • +89
    ./acs-objects-create.sql
    • -1
    • +2
    ./acs-relationships-create.sql
    • -4
    • +28
    ./apm-create.sql
    • -0
    • +1
    ./authentication-package-create.sql
    • -3
    • +13
    ./community-core-create.sql
    • -1
    • +5
    ./groups-body-create.sql
    • -1
    • +2
    ./journal-create.sql
    • -1
    • +2
    ./rel-constraints-body-create.sql
    • -1
    • +5
    ./rel-segments-body-create.sql
    • -1
    • +3
    ./site-nodes-create.sql
    • -0
    • +2643
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  13. … 86 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -4
    • +3
    ./acs-create.sql
    • -88
    • +5
    ./acs-objects-create.sql
    • -1
    • +0
    ./acs-relationships-create.sql
    • -27
    • +3
    ./apm-create.sql
    • -1
    • +0
    ./authentication-package-create.sql
    • -12
    • +2
    ./community-core-create.sql
    • -5
    • +1
    ./groups-body-create.sql
    • -1
    • +0
    ./journal-create.sql
    • -1
    • +0
    ./rel-constraints-body-create.sql
    • -4
    • +0
    ./rel-segments-body-create.sql
    • -2
    • +0
    ./site-nodes-create.sql
    • -2643
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  13. … 85 more files in changeset.
Tuesday 02 Mar 2004
6:38 pm

andrewg

fixing a syntax error

Options
    • -2
    • +2
    ./groups-body-create.sql
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -3
    • +4
    ./acs-create.sql
    • -6
    • +89
    ./acs-objects-create.sql
    • -1
    • +2
    ./acs-relationships-create.sql
    • -4
    • +28
    ./apm-create.sql
    • -0
    • +1
    ./authentication-package-create.sql
    • -3
    • +13
    ./community-core-create.sql
    • -1
    • +5
    ./groups-body-create.sql
    • -1
    • +2
    ./journal-create.sql
    • -1
    • +2
    ./rel-constraints-body-create.sql
    • -1
    • +5
    ./rel-segments-body-create.sql
    • -1
    • +3
    ./site-nodes-create.sql
    • -0
    • +2643
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  13. … 85 more files in changeset.