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 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 15 Jun 2004
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.
Monday 26 Jan 2004
4:39 pm

jeffd

merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

Options
    • -2
    • +704
    ./upgrade/upgrade-5.0d2-5.0d3.sql
    • -18
    • +982
    ./upgrade/upgrade-5.0d7-5.0d9.sql
    • -421
    • +345
    ./upgrade/upgrade-5.0d9-5.0d13.sql
  4. … 284 more files in changeset.
Sunday 25 Jan 2004
2:25 am

daveb

Seperate delete of perissions by grantee_id into its own statement.

Fixes bug#1419

Options
    • -2
    • +5
    ./acs-objects-create.sql
Tuesday 06 Jan 2004
4:54 pm

peterm

integrity violation fix for acs_object__delete function. Making it delete matching acs_permission.grantee_id records in addition to the object_id ones. Bumping version of kernel to 5.0.0b5

Options
    • -2
    • +2
    ./acs-objects-create.sql
    • -0
    • +632
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  3. … 3 more files in changeset.
Monday 29 Dec 2003
10:03 pm

tracya

upgrade problems. Placing package definitions above bodies so they compile

Options
    • -413
    • +337
    ./upgrade/upgrade-5.0d9-5.0d13.sql
8:45 pm

tracya

upgrade problems. Adding package headers to accompany bodies and adding site_nodes package so site_node.del is defined

Options
    • -18
    • +982
    ./upgrade/upgrade-5.0d7-5.0d9.sql
Tuesday 23 Dec 2003
6:18 am

tracya

redifining acs-object package to use del instead of delete

Options
    • -2
    • +704
    ./upgrade/upgrade-5.0d2-5.0d3.sql
Monday 15 Dec 2003
2:50 am

donb

Removed unused Java-based function from the Oracle version.

Options
    • -30
    • +1
    ./utilities-create.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -5
    • +6
    ./acs-objects-create.sql
    • -2
    • +7
    ./groups-create.sql
    • -0
    • +73
    ./upgrade/upgrade-5.0.0b1-5.0.0b2.sql
    • -0
    • +10
    ./upgrade/upgrade-5.0.0b2-5.0.0b3.sql
    • -0
    • +37
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
  6. … 594 more files in changeset.
Thursday 04 Dec 2003
12:38 am

donb

Move over the bandaid patch for bug #1144 from the 5.0 branch. This needs

to be fixed for real (including datamodel changes with upgrade scripts) in

5.1.

Options
    • -2
    • +4
    ./acs-create.sql
  2. … 8 more files in changeset.
Sunday 30 Nov 2003
2:17 am

donb

Fixed bug 1142 again (more?)

Options
    • -1
    • +3
    ./acs-create.sql
    • -0
    • +37
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
  3. … 3 more files in changeset.
2:17 am

donb

file upgrade-5.0.0b3-5.0.0b4.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
Wednesday 26 Nov 2003
11:47 pm

donb

Fixed bug #1144 - users added to relsegs of registered_users showed up twice

in the registered_users and cc_users views.

Options
    • -0
    • +1
    ./acs-create.sql
  2. … 1 more file in changeset.
Friday 21 Nov 2003
11:09 pm

jeffd

Use lower(username) rather than upper(username), create case folded

indexes on postgres for username, email, screen_name, move some of

the queries in community-core-procs to .xql file.

rename the updgrade files...doh!

Options
    • -10
    • +0
    ./upgrade/updgrade-5.0.0b2-5.0.0b3.sql
    • -0
    • +10
    ./upgrade/upgrade-5.0.0b2-5.0.0b3.sql
  3. … 7 more files in changeset.
11:09 pm

jeffd

file upgrade-5.0.0b2-5.0.0b3.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0b2-5.0.0b3.sql
  2. … 1 more file in changeset.
2:39 am

donb

Fixed bug 1144.

Options
    • -0
    • +1
    ./acs-create.sql
  2. … 1 more file in changeset.
Thursday 20 Nov 2003
10:24 pm

jeffd

file updgrade-5.0.0b2-5.0.0b3.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/updgrade-5.0.0b2-5.0.0b3.sql
  2. … 1 more file in changeset.
10:24 pm

jeffd

Change the all_users to acs_users_all, bump version to 5.0.0b3, provide

upgrade script. fix where its used in logger, weblogger-portlet, and lars-blogger.

fixes bug 1174.

Options
    • -1
    • +1
    ./acs-create.sql
    • -0
    • +10
    ./upgrade/updgrade-5.0.0b2-5.0.0b3.sql
  3. … 8 more files in changeset.
5:32 pm

jeffd

Adds max_child_sortkey to acs_objects, uses select for update to incr

tree_sortkey (fixes concurrency problems and substantially improves

performance), drop group_elem_idx_container_idx (not useful) and

acs_objects_context_object_idx (which is superflous since there is an

identical unique constraint). changes acs_objects_get_tree_sortkey to

be isstrict/iscachable fixes a bug in acs_objects_context_id_up_tr on

both oracle an postgres.

See http://openacs.org/forums/message-view?message_id=142769 for discussion.

Options
    • -5
    • +6
    ./acs-objects-create.sql
    • -2
    • +7
    ./groups-create.sql
    • -0
    • +73
    ./upgrade/upgrade-5.0.0b1-5.0.0b2.sql
  4. … 5 more files in changeset.
5:32 pm

jeffd

file upgrade-5.0.0b1-5.0.0b2.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0b1-5.0.0b2.sql
  2. … 1 more file in changeset.
Saturday 01 Nov 2003
1:27 pm

jeffd

the cc_users view in the upgrade did not match the current version of cc_users (cf http://openacs.org/forums/message-view?message_id=97099 )

Options
    • -5
    • +10
    ./upgrade/upgrade-5.0d2-5.0d3.sql