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
Friday 23 Sep 2005
11:46 am

josee

file upgrade-5.2.0b1-5.2.0b2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0b1-5.2.0b2.sql
11:46 am

josee

changing version number and adding respective upgrade script

Options
    • -0
    • +1
    ./upgrade/upgrade-5.2.0b1-5.2.0b2.sql
  2. … 1 more file in changeset.
11:40 am

josee

adding missing line:

select define_function_args('acs_rel__new','rel_id,rel_type,object_id_one,object_id_two,context_id,creation_user,creation_ip');

Options
    • -1
    • +3
    ./acs-relationships-create.sql
Thursday 22 Sep 2005
6:40 pm

josee

adding missing line:

select define_function_args('acs_rel__new','rel_id,rel_type,object_id_one,object_id_two,context_id,creation_user,creation_ip');

Options
    • -1
    • +3
    ./acs-relationships-create.sql
Wednesday 27 Jul 2005
2:43 pm

maltes

More I18N

Options
    • -3
    • +3
    ./acs-create.sql
    • -4
    • +4
    ./acs-install.sql
    • -3
    • +3
    ./rel-constraints-create.sql
    • -3
    • +3
    ./rel-segments-create.sql
  5. … 2 more files in changeset.
Tuesday 19 Jul 2005
9:07 am

maltes

I18N of Names in sql files

Options
    • -6
    • +6
    ./acs-create.sql
    • -16
    • +16
    ./community-core-create.sql
    • -11
    • +11
    ./groups-create.sql
  4. … 1 more file in changeset.
Wednesday 06 Jul 2005
12:41 pm

jeffd

change to create or replace function

Options
    • -24
    • +24
    ./postgresql.sql
Friday 10 Jun 2005
11:49 pm

maltes

yet even more I18N fixes..

Options
    • -6
    • +6
    ./acs-create.sql
    • -6
    • +6
    ./groups-create.sql
  3. … 2 more files in changeset.
Wednesday 08 Jun 2005
1:11 pm

enriquec

file upgrade-5.1.5-5.2.0a1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.5-5.2.0a1.sql
  2. … 1 more file in changeset.
1:11 pm

enriquec

Fixing bugs in user merge support. Improving the process, making it more generic and now it works for acs-core. Adding the upgrade scripts for oracle and pg.

Options
    • -0
    • +17
    ./upgrade/upgrade-5.1.5-5.2.0a1.sql
  2. … 13 more files in changeset.
Friday 03 Jun 2005
10:14 pm

maltes

I18N of Attributes

Options
    • -16
    • +16
    ./community-core-create.sql
    • -5
    • +5
    ./groups-create.sql
  3. … 1 more file in changeset.
Tuesday 24 May 2005
4:21 am

enriquec

Adding the member_state 'merged'. Added plsql functions and upgrade scripts for oracle and pg.

Options
    • -1
    • +13
    ./groups-body-create.sql
    • -2
    • +2
    ./groups-create.sql
    • -0
    • +17
    ./upgrade/upgrade-5.2.0d9-5.2.0d10.sql
  4. … 4 more files in changeset.
4:21 am

enriquec

file upgrade-5.2.0d9-5.2.0d10.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.2.0d9-5.2.0d10.sql
  2. … 1 more file in changeset.
Tuesday 22 Mar 2005
6:53 am

gabrielb

Fixes bug #2300.

Options
    • -5
    • +5
    ./postgresql.sql
Monday 21 Mar 2005
12:59 pm

rob

Added annotate permission as per TIP 74

Options
    • -0
    • +1
    ./acs-create.sql
  2. … 1 more file in changeset.
Sunday 06 Mar 2005
8:09 pm

jeffd

add an explicit cast of proname in drop_package needed in pg8

Options
    • -1
    • +1
    ./postgresql.sql
    • -0
    • +30
    ./upgrade/upgrade-5.2.0d8-5.2.0d9.sql
  3. … 1 more file in changeset.
Sunday 27 Feb 2005
8:23 pm

donb

Realized that I only need to define function args for the most verbose

form of acs_object__new, since package_instantiate_object handles

default values very nicely.

Options
    • -13
    • +1
    ./acs-objects-create.sql
    • -12
    • +0
    ./upgrade/upgrade-5.2.0d7-5.2.0d8.sql
2:21 am

donb

A variety of group oriented things, and finally added the definitions of

acs-objects package procs in PG so that we can use package_instantiate_object

and package_db_exec with them.

Options
    • -1
    • +52
    ./acs-objects-create.sql
    • -4
    • +7
    ./acs-permissions-create.sql
    • -3
    • +6
    ./acs-relationships-create.sql
    • -6
    • +14
    ./groups-create.sql
    • -5
    • +9
    ./rel-segments-create.sql
    • -0
    • +41
    ./upgrade/upgrade-5.2.0d7-5.2.0d8.sql
  7. … 5 more files in changeset.
Saturday 26 Feb 2005
8:48 pm

jeffd

rename 4.6-4.6.1 upgrade to not overlap 4.6.1d1-4.6.1d2

Options
    • -804
    • +0
    ./upgrade/upgrade-4.6-4.6.1.sql
    • -0
    • +804
    ./upgrade/upgrade-4.6-4.6.1d1.sql
  3. … 2 more files in changeset.
Wednesday 23 Feb 2005
11:07 am

jeffd

set title in acs objects when creating security context root, set titles for parameters, make acs_objects.package_id on delete set null

Options
    • -1
    • +4
    ./acs-create.sql
    • -7
    • +18
    ./apm-create.sql
    • -1
    • +1
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  4. … 3 more files in changeset.
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
    • -208
    • +0
    ./upgrade/upgrade-4.6.1-4.7d.sql
    • -0
    • +208
    ./upgrade/upgrade-4.6.1d1-4.6.1d2.sql
  3. … 2 more files in changeset.
Saturday 22 Jan 2005
9:25 pm

jeffd

some tweaks to install on pg 8.0 -- for some reason acs__magic_object_id declared immutable breaks the install on 8.0 so make it stable

Options
    • -2
    • +2
    ./acs-create.sql
    • -5
    • +5
    ./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
    • -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.