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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 15 Jul 2003
2:38 am

donb

Added csv_data as a package file type ...

Options
    • -0
    • +1
    ./apm-create.sql
    • -0
    • +1
    ./upgrade/upgrade-4.7.2d-5.0d.sql
  3. … 2 more files in changeset.
Saturday 12 Jul 2003
3:10 am

donb

1. removed some errant log statemets previously inserted when debugging

2. sql/common/*sql files weren't being displayed by the APM, are now

3. added index on start_date in timespan-create after user reported

very slow calendar queries in .LRN

Options
    • -65
    • +0
    ./utilities-create.sql
  2. … 7 more files in changeset.
Friday 04 Jul 2003
2:22 pm

lars

1. Made object_id 0 be a user instead of a person;

2. Created a rel_type 'admin_rel' and corresponding role 'admin'.

Options
    • -1
    • +6
    ./acs-create.sql
    • -0
    • +67
    ./groups-body-create.sql
    • -15
    • +45
    ./groups-create.sql
    • -0
    • +114
    ./upgrade/upgrade-4.6.5-4.6.6.sql
  5. … 5 more files in changeset.
2:22 pm

lars

file upgrade-4.6.5-4.6.6.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.5-4.6.6.sql
  2. … 1 more file in changeset.
Monday 23 Jun 2003
8:47 pm

janines

add user id and IP address to update_last_modified()

Options
    • -10
    • +16
    ./acs-objects-create.sql
    • -0
    • +47
    ./upgrade/upgrade-4.6.4-4.6.5.sql
  3. … 9 more files in changeset.
8:47 pm

janines

file upgrade-4.6.4-4.6.5.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.4-4.6.5.sql
  2. … 1 more file in changeset.
Monday 16 Jun 2003
6:19 pm

peterm

fixing lame = 0 instead of is null bug in register_parameter proc that would cause default values of new parameters to not be propagated to package instances during package upgrade

Options
    • -1
    • +1
    ./apm-create.sql
    • -1
    • +57
    ./upgrade/upgrade-4.6.3-4.6.4.sql
Friday 06 Jun 2003
10:40 am

lars

file upgrade-4.6.3-4.6.4.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.3-4.6.4.sql
  2. … 1 more file in changeset.
10:39 am

lars

Added password_changed_date column to users table, so we can expire passwords after a certain number of days

Options
    • -1
    • +2
    ./community-core-create.sql
    • -0
    • +61
    ./upgrade/upgrade-4.6.3-4.6.4.sql
  3. … 3 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -9
    • +12
    ./acs-create.sql
    • -1
    • +1
    ./acs-logs-create.sql
    • -0
    • +10
    ./acs-metadata-create.sql
    • -8
    • +11
    ./acs-objects-create.sql
    • -46
    • +16
    ./acs-permissions-create.sql
    • -10
    • +10
    ./apm-create.sql
    • -5
    • +5
    ./apm-drop.sql
    • -45
    • +6
    ./community-core-create.sql
    • -4
    • +37
    ./groups-body-create.sql
    • -2
    • +2
    ./groups-create.sql
    • -1
    • +1
    ./journal-create.sql
    • -131
    • +31
    ./postgresql.sql
    • -1
    • +1
    ./rel-segments-create.sql
    • -1
    • +1
    ./security-create.sql
    • -1
    • +1
    ./upgrade/upgrade-4.5-4.5.1.sql
  16. … 16 more files in changeset.
Sunday 04 May 2003
1:51 am

donb

1. removed some needless LARS notices

2. removed acs_methods and friends from the permissions documentation

and got rid of the commented-out table stubs.

3. dropping of permissions was broken in PG, fixed that.

4. cc_users and registered_users views have been sped up.

5. removed an unused and incorrect proc from revision-procs

6. updated acs-kernel to 4.6.3

-------------------------------------------------------------------------------------

Options
    • -9
    • +12
    ./acs-create.sql
    • -46
    • +16
    ./acs-permissions-create.sql
    • -1
    • +49
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  4. … 9 more files in changeset.
Monday 21 Apr 2003
3:02 am

donb

file upgrade-4.6.2-4.6.3.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.2-4.6.3.sql
3:00 am

donb

Changed a minor bug regarding the definition of user_tab_comments, bumped

to 4.6.3 and added an upgrade script (we may not release a 4.6.3 but if we

do, we're ready!)

Options
    • -131
    • +31
    ./postgresql.sql
    • -0
    • +13
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  3. … 1 more file in changeset.
Monday 24 Mar 2003
9:30 pm

donb

Fixed a problem with the party_approved_member_map uncovered by Dave Bauer.

Options
    • -4
    • +38
    ./groups-body-create.sql
    • -1
    • +1
    ./rel-segments-create.sql
    • -0
    • +217
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  4. … 2 more files in changeset.
Sunday 23 Mar 2003
2:59 am

donb

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

Options
    • -1
    • +1
    ./apm-create.sql
    • -1
    • +26
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  3. … 34 more files in changeset.
Monday 17 Mar 2003
10:58 pm

donb

Migrated the 4.6.1 permissions stuff to HEAD

Options
    • -32
    • +77
    ./acs-create.sql
    • -318
    • +189
    ./acs-permissions-create.sql
    • -2
    • +5
    ./groups-body-create.sql
    • -1
    • +1
    ./rel-segments-body-create.sql
  5. … 4 more files in changeset.
Thursday 13 Mar 2003
9:22 pm

donb

Migrated over changes to move some GIF resources into a common subdirectory

in the subsite package, so anyone who can read the main site can read

the images (previously you had to grant read privs to "/doc" explicitly

to get the graphics stored by acs-datetime to show up.

Options
    • -5
    • +8
    ./groups-body-create.sql
    • -19
    • +25
    ./rel-segments-create.sql
  3. … 37 more files in changeset.
5:02 pm

peterm

bumping up allowed length of group_type column in group_types table from 100 to 400. Adding a subject in dotlrn with a 100 length subject pretty_name would break otherwise (the group_type becomes department key + subject pretty_name)

Options
    • -1
    • +1
    ./groups-create.sql
4:59 pm

peterm

making upgrade script use timestamptz like the create script

Options
    • -1
    • +1
    ./upgrade/upgrade-4.6.1-4.6.2.sql
Wednesday 12 Mar 2003
3:31 am

donb

I accidently dropped a trigger create when I switched back to dropping and

creating them instead of using "create or replace function" (which doesn't

quite work in PG 7.3 unfortunately when the function's attached to a trigger)

Options
    • -2
    • +5
    ./groups-body-create.sql
Tuesday 11 Mar 2003
3:31 am

donb

Sped up the view used to build the denormalized acs_privilege_descendant_map

table.

Options
    • -11
    • +11
    ./acs-permissions-create.sql
    • -0
    • +87
    ./upgrade/upgrade-4.6.1-4.6.2.sql
Wednesday 05 Mar 2003
3:38 pm

lars

file upgrade-4.6.1-4.6.2.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  2. … 1 more file in changeset.
3:37 pm

lars

Upgrade to 4.6.2: APM changes and change in installation procedure

Options
    • -142
    • +0
    ./acs-install.sql
    • -21
    • +61
    ./apm-create.sql
    • -0
    • +208
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  4. … 4 more files in changeset.
Sunday 02 Mar 2003
11:32 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -1
    • +1
    ./acs-create.sql
    • -1
    • +1
    ./acs-logs-create.sql
    • -8
    • +8
    ./acs-objects-create.sql
    • -9
    • +9
    ./apm-create.sql
    • -5
    • +5
    ./apm-drop.sql
    • -6
    • +6
    ./community-core-create.sql
    • -1
    • +1
    ./journal-create.sql
    • -1
    • +1
    ./rel-segments-body-create.sql
    • -1
    • +1
    ./security-create.sql
  10. … 45 more files in changeset.
4:23 pm

donb

Made changes so we can install under PG 7.3.

Options
    • -5
    • +8
    ./groups-body-create.sql
Wednesday 26 Feb 2003
10:37 pm

jeffd

add email and url as acs_datatypes

Options
    • -0
    • +10
    ./acs-metadata-create.sql
    • -1
    • +13
    ./upgrade/upgrade-4.6-4.6.1.sql
  3. … 2 more files in changeset.
4:08 am

donb

Fixed a couple of minor upgrade problems.

Options
    • -20
    • +15
    ./upgrade/upgrade-4.6-4.6.1.sql
3:21 am

donb

A bunch of things

1. AOLserver 4.0's nsxml appears to expose a gcc bug which causes the

backwards-compatible "getattr" command to fail. I dug around nsxml

and it does appear to be a gcc bug. I changed to the proper nsxml v2

syntax.

2. In the course of exploring #1 above, I realized that the calls to

dom:: Tcl XML package commands were still being executed despite

being commented out. Typical Tcl misunderstanding on someone's part.

Net effect: we were parsing all APM .info files twice, once in Tcl

and once in ns_xml! Yuk!

3. Fixed a minor notifications bug - you couldn't delete a notification

request if any unsent notifications were pending, causing the homework

package to bomb if you deleted an uploaded homework file and the prof

hadn't yet received their notification.

4. Fixed an obscure corner case in my permissions denormalization code.

Options
    • -19
    • +25
    ./rel-segments-create.sql
    • -21
    • +29
    ./upgrade/upgrade-4.6-4.6.1.sql
  3. … 14 more files in changeset.
Sunday 23 Feb 2003
5:22 pm

danw

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

Options
    • -13
    • +0
    ./acs-create.sql
    • -15
    • +3
    ./acs-permissions-create.sql
  3. … 3 more files in changeset.
6:58 am

danw

Eliminated acs_privilege_hierarchy_index in favor of using acs_privilege_descendant_map. In addition, rewrote trigger for creating acs_privilege_descendant_map as permissions creation was getting too slow on .LRN. .LRN has somewhere in the neighborhood of 90 entries in the privilege hierarchy, which is much higher than anticipated.

Options
    • -151
    • +134
    ./acs-permissions-create.sql