OpenACS / openacs-4 / packages / acs-kernel

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 44
Last Commit: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 85,961
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
Saturday 12 May 2001
11:48 pm

danw

fixed permissions problem for handling insertion of dup index values

Options
    • -11
    • +51
    ./postgresql/acs-permissions-create.sql
  2. … 1 more file in changeset.
Friday 11 May 2001
10:57 pm

donb

Just what it says ...

Options
    • -0
    • +1531
    ./oracle/upgrade/upgrade-4.2-4.2.1.sql
2:14 am

donb

1. Polished up the query files for the root www directory

2. Turned a bunch of bitmap indexes into b-tree indexes

3. the developer support .info file had been messed over by an early

version of my APM port to PG.

Options
    • -6
    • +11
    ./oracle/acs-metadata-create.sql
    • -2
    • +3
    ./oracle/acs-objects-create.sql
    • -3
    • +5
    ./oracle/acs-permissions-create.sql
    • -5
    • +9
    ./oracle/acs-relationships-create.sql
    • -4
    • +5
    ./oracle/apm-create.sql
    • -2
    • +3
    ./oracle/upgrade/upgrade-4.0-4.0.1.sql
  7. … 3 more files in changeset.
Thursday 10 May 2001
7:10 am

danw

fixed comment for distribution_tarball attribute that was removed

Options
    • -2
    • +2
    ./oracle/apm-create.sql
12:32 am

donb

1. Added a new attribute to the .info file which tells the bootstrap

installer whether or not a package is part of the acs-core. Only

acs-core packages are now installed during the initial bootstrap install

of the system.

2. Fixed a dupe query name problem in a couple of queryfiles. The problem

is not with the dispatcher but with the extractor, and for the moment it

is just easier to kludge the resulting queryfile than fix the extractor.

Options
    • -5
    • +69
    ./oracle/apm-create.sql
    • -494
    • +78
    ./postgresql/apm-create.sql
    • -0
    • +57
    ./postgresql/apm-drop.sql
  4. … 34 more files in changeset.
Monday 07 May 2001
7:18 am

jong

updated with streamlined permission_p

Options
    • -16
    • +69
    ./oracle/acs-permissions-create.sql
Saturday 05 May 2001
7:39 pm

danw

converted apm to store tarballs in the content repository

Options
    • -4
    • +8
    ./oracle/apm-create.sql
    • -4
    • +6
    ./postgresql/apm-create.sql
  3. … 6 more files in changeset.
Friday 04 May 2001
8:04 am

danw

converted apm to store package tarballs in the content repository

Options
    • -8
    • +11
    ./postgresql/apm-create.sql
  2. … 7 more files in changeset.
Tuesday 01 May 2001
8:58 pm

stevew

Fix return type of acs_user__receives_alerts_p

Options
    • -1
    • +1
    ./postgresql/community-core-create.sql
5:11 pm

stevew

Speedy replacement for permission_p from Matthew Avalos

Options
    • -16
    • +71
    ./postgresql/acs-permissions-create.sql
Monday 30 Apr 2001
10:02 pm

stevew

party__name should return varchar

Options
    • -1
    • +1
    ./postgresql/community-core-create.sql
3:34 am

danw

added file support to CR data-model

Options
    • -0
    • +311
    ./test/acs-objects-test.sql
    • -0
    • +170
    ./test/groups-test.sql
    • -0
    • +363
    ./test/rel-constraints-test.sql
    • -0
    • +205
    ./test/rel-segments-test-types-create.sql
    • -0
    • +14
    ./test/rel-segments-test-types-drop.sql
    • -0
    • +377
    ./test/rel-segments-test.sql
  7. … 7 more files in changeset.
Sunday 29 Apr 2001
9:17 pm

stevew

Add instr(varchar,char) helper function

Options
    • -0
    • +9
    ./postgresql/postgresql.sql
Saturday 28 Apr 2001
7:35 pm

donb

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

Options
    • -1
    • +1
    ./postgresql/acs-logs-create.sql
    • -14
    • +14
    ./postgresql/acs-metadata-create.sql
    • -7
    • +13
    ./postgresql/acs-objects-create.sql
    • -4
    • +4
    ./postgresql/acs-permissions-create.sql
    • -26
    • +25
    ./postgresql/apm-create.sql
    • -7
    • +7
    ./postgresql/community-core-create.sql
    • -2
    • +2
    ./postgresql/groups-create.sql
    • -5
    • +5
    ./postgresql/journal-create.sql
    • -1
    • +1
    ./postgresql/security-create.sql
    • -1
    • +1
    ./postgresql/site-nodes-create.sql
  11. … 14 more files in changeset.
3:04 am

danw

fixed problem with initalizing a_order and added missing as to select query

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
  2. … 1 more file in changeset.
Friday 27 Apr 2001
7:39 pm

donb

More porting of the APM is complete! Nearly done, a bug in the datamodel

API and we need to convert from direct use of blobs to using the

content repository.

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
  2. … 11 more files in changeset.
Friday 20 Apr 2001
8:04 pm

danw

added index

Options
    • -0
    • +3
    ./postgresql/rel-constraints-create.sql
6:29 am

danw

finished tree query support for rel_constraints

Options
    • -141
    • +124
    ./postgresql/rel-constraints-create.sql
4:03 am

danw

added tcl variable support to db api

Options
    • -1
    • +22
    ./postgresql/rel-constraints-body-create.sql
    • -7
    • +24
    ./postgresql/rel-constraints-create.sql
    • -1
    • +7
    ./postgresql/rel-segments-body-create.sql
  4. … 1 more file in changeset.
Thursday 19 Apr 2001
4:52 pm

ben

applied patches from Steve Woodcock that port a few more queries, fix a few data model PL/SQL quirks, and generally allow us to get further into a working OpenACS!

Options
    • -4
    • +4
    ./postgresql/acs-permissions-create.sql
  2. … 6 more files in changeset.
3:17 am

danw

more strict string handling changes

Options
    • -1
    • +1
    ./postgresql/acs-objects-create.sql
    • -1
    • +1
    ./postgresql/apm-create.sql
  3. … 3 more files in changeset.
Wednesday 18 Apr 2001
7:20 am

danw

partial fix of rel_constraints tree queries - more work required

Options
    • -9
    • +22
    ./postgresql/rel-constraints-create.sql
    • -1
    • +2
    ./postgresql/rel-segments-body-create.sql
1:41 am

danw

added comments for default api values

Options
    • -11
    • +11
    ./postgresql/acs-create.sql
    • -15
    • +15
    ./postgresql/acs-metadata-create.sql
    • -8
    • +8
    ./postgresql/acs-objects-create.sql
    • -2
    • +2
    ./postgresql/acs-permissions-create.sql
    • -13
    • +13
    ./postgresql/acs-relationships-create.sql
    • -80
    • +80
    ./postgresql/apm-create.sql
    • -26
    • +26
    ./postgresql/community-core-create.sql
    • -18
    • +18
    ./postgresql/groups-body-create.sql
    • -6
    • +6
    ./postgresql/journal-create.sql
    • -7
    • +7
    ./postgresql/rel-constraints-body-create.sql
    • -4
    • +2
    ./postgresql/rel-constraints-create.sql
    • -9
    • +9
    ./postgresql/rel-segments-body-create.sql
    • -7
    • +7
    ./postgresql/site-nodes-create.sql
Saturday 14 Apr 2001
7:29 am

danw

more cleanup of nullable strings in kernel

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
7:21 am

danw

more cleanup of nullable strings in kernel

Options
    • -1
    • +1
    ./postgresql/apm-create.sql
7:12 am

danw

more cleanup of nullable strings in kernel

Options
    • -2
    • +2
    ./postgresql/acs-logs-create.sql
    • -1
    • +1
    ./postgresql/acs-metadata-create.sql
    • -4
    • +4
    ./postgresql/acs-objects-create.sql
    • -7
    • +7
    ./postgresql/apm-create.sql
    • -1
    • +1
    ./postgresql/groups-body-create.sql
    • -2
    • +2
    ./postgresql/groups-create.sql
    • -3
    • +3
    ./postgresql/rel-constraints-body-create.sql
    • -1
    • +1
    ./postgresql/site-nodes-create.sql
    • -2
    • +2
    ./postgresql/test/rel-constraints-test.sql
Wednesday 11 Apr 2001
2:41 pm

danw

applied patch from Steve Woodcock

Options
    • -1
    • +3
    ./postgresql/postgresql.sql
  2. … 2 more files in changeset.
1:53 am

danw

patch submitted by steve woodcock, and workflow porting

Options
    • -1
    • +1
    ./postgresql/acs-create.sql
  2. … 1 more file in changeset.
Monday 09 Apr 2001
6:55 am

danw

fixed problem with infinite recursion on updates of tables with tree query triggers

Options
    • -1
    • +2
    ./postgresql/acs-metadata-create.sql
    • -1
    • +2
    ./postgresql/site-nodes-create.sql
  3. … 3 more files in changeset.
Sunday 08 Apr 2001
6:13 pm

danw

fixed acs_object tree trigger

Options
    • -0
    • +1
    ./postgresql/acs-install.sql
    • -1
    • +2
    ./postgresql/acs-objects-create.sql
    • -1
    • +1
    ./postgresql/security-create.sql