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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Wednesday 17 Mar 2004
4:29 pm

jeffd

trim function name and args in define_function_args to avoid difficult to track down problems when calling package_plsql_exec et al

Options
    • -10
    • +10
    ./postgresql.sql
11:23 am

jeffd

minor typo prevented setting title even if provided in acs_object__new

Options
    • -1
    • +1
    ./acs-objects-create.sql
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
    • -23
    • +159
    ./acs-objects-create.sql
    • -1
    • +4
    ./acs-relationships-create.sql
    • -0
    • +25
    ./apm-create.sql
    • -1
    • +3
    ./authentication-package-create.sql
    • -1
    • +6
    ./community-core-create.sql
    • -1
    • +5
    ./groups-body-create.sql
    • -1
    • +4
    ./journal-create.sql
    • -2
    • +5
    ./rel-constraints-body-create.sql
    • -0
    • +4
    ./rel-segments-body-create.sql
    • -1
    • +4
    ./site-nodes-create.sql
    • -0
    • +1124
    ./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
    • -159
    • +23
    ./acs-objects-create.sql
    • -4
    • +1
    ./acs-relationships-create.sql
    • -25
    • +0
    ./apm-create.sql
    • -3
    • +1
    ./authentication-package-create.sql
    • -6
    • +1
    ./community-core-create.sql
    • -4
    • +0
    ./groups-body-create.sql
    • -4
    • +1
    ./journal-create.sql
    • -4
    • +1
    ./rel-constraints-body-create.sql
    • -4
    • +0
    ./rel-segments-body-create.sql
    • -4
    • +1
    ./site-nodes-create.sql
    • -1124
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  13. … 85 more files in changeset.
Wednesday 03 Mar 2004
2:20 am

donb

Fixed typo in TImo's upgrade to the PG version - kernel didn't (actually

still doesn't due to other errors) install.

Options
    • -1
    • +1
    ./apm-create.sql
Tuesday 02 Mar 2004
6:00 pm

timoh

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

Options
    • -3
    • +4
    ./acs-create.sql
    • -23
    • +159
    ./acs-objects-create.sql
    • -1
    • +4
    ./acs-relationships-create.sql
    • -0
    • +25
    ./apm-create.sql
    • -1
    • +3
    ./authentication-package-create.sql
    • -1
    • +6
    ./community-core-create.sql
    • -1
    • +5
    ./groups-body-create.sql
    • -1
    • +4
    ./journal-create.sql
    • -2
    • +5
    ./rel-constraints-body-create.sql
    • -0
    • +4
    ./rel-segments-body-create.sql
    • -1
    • +4
    ./site-nodes-create.sql
    • -0
    • +1124
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  13. … 85 more files in changeset.
Saturday 07 Feb 2004
11:25 pm

lars

Fixed references to user_group_types table: It's now called group_types (and has been for 3+ years)

Options
    • -4
    • +4
    ./acs-metadata-create.sql
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
    • +5
    ./acs-relationships-create.sql
    • -6
    • +7
    ./apm-create.sql
    • -3
    • +7
    ./upgrade/upgrade-4.6.5-4.6.6.sql
    • -0
    • +15
    ./upgrade/upgrade-5.0.0a1-5.0.0a2.sql
    • -6
    • +183
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -7
    • +8
    ./upgrade/upgrade-5.0d2-5.0d3.sql
    • -5
    • +74
    ./upgrade/upgrade-5.0d7-5.0d9.sql
  8. … 280 more files in changeset.
Saturday 17 Jan 2004
12:54 am

vinodk

Upgrade script for auth_driver_params changes

Options
    • -0
    • +15
    ./upgrade/upgrade-5.0.0a1-5.0.0a2.sql
12:54 am

vinodk

file upgrade-5.0.0a1-5.0.0a2.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0a1-5.0.0a2.sql
Friday 16 Jan 2004
1:34 am

vinodk

Changes to apm_package_version__delete and apm_package_version__copy didn't get into an upgrade script

Options
    • -0
    • +68
    ./upgrade/upgrade-5.0d7-5.0d9.sql
Wednesday 14 Jan 2004
6:35 pm

donb

Fixed bug 1361

Options
    • -1
    • +1
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
Saturday 10 Jan 2004
6:52 pm

vinodk

drop table statements won't work until the view is dropped

Options
    • -3
    • +4
    ./upgrade/upgrade-5.0d7-5.0d9.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
    • -1
    • +3
    ./acs-objects-create.sql
    • -0
    • +55
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  3. … 3 more files in changeset.
Tuesday 30 Dec 2003
5:30 pm

daveb

Additional fix for bug#1311. Drop and recreate acs_user__new function.

Options
    • -0
    • +89
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
5:23 pm

daveb

Drop the old acs__add_user, the signature is different.

Options
    • -0
    • +2
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
5:17 pm

daveb

Add new version of acs__add_user to upgrade script. Fixes bug#1311

Options
    • -0
    • +82
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
Tuesday 16 Dec 2003
3:35 am

daveb

Fix creation of admin role. Patch#395 from Robert Gaszewski

Options
    • -3
    • +7
    ./upgrade/upgrade-4.6.5-4.6.6.sql
Monday 15 Dec 2003
8:34 am

jeffd

apm_package__singleton_p returns an integer, not a boolean

Options
    • -1
    • +1
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
3:21 am

daveb

Correctly drop column and view otherwise upgrade script fails. Drop column is supported on pg 7.3 and 5.0 only supports pg 7.3

Options
    • -2
    • +2
    ./upgrade/upgrade-5.0d7-5.0d9.sql
1:30 am

jeffd

make upgrade scripts work, make it a little safer for accidental resourcing (so it won't step on existing usernames), drop views, patch 391 Robert Gaszewski

Options
    • -2
    • +5
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -7
    • +8
    ./upgrade/upgrade-5.0d2-5.0d3.sql
Saturday 13 Dec 2003
1:50 am

jeffd

typo from last commit

Options
    • -1
    • +1
    ./acs-relationships-create.sql
1:48 am

jeffd

split getting max version into two queries for performance, don't assign to constant in acs_rel_type__drop_type

Options
    • -2
    • +5
    ./acs-relationships-create.sql
    • -6
    • +7
    ./apm-create.sql
    • -4
    • +5
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

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

Options
    • -4
    • +4
    ./acs-create.sql
    • -16
    • +10
    ./acs-metadata-create.sql
    • -13
    • +13
    ./acs-object-util.sql
    • -111
    • +122
    ./acs-objects-create.sql
    • -2
    • +2
    ./acs-permissions-create.sql
    • -6
    • +12
    ./acs-relationships-create.sql
    • -94
    • +90
    ./apm-create.sql
    • -45
    • +35
    ./community-core-create.sql
    • -3
    • +9
    ./groups-body-create.sql
    • -2
    • +7
    ./groups-create.sql
    • -8
    • +12
    ./lob.sql
    • -71
    • +39
    ./postgresql.sql
    • -13
    • +12
    ./rel-constraints-body-create.sql
    • -17
    • +12
    ./rel-segments-body-create.sql
    • -10
    • +10
    ./site-nodes-create.sql
  16. … 584 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
    • -0
    • +2
    ./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
    • +32
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
  3. … 3 more files in changeset.