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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 30 Mar 2001
7:44 am

ben

query dispatcher progress

Options
    • -3
    • +4
    ./postgresql/apm-create.sql
  2. … 5 more files in changeset.
5:15 am

danw

added Don's lob hack to support content-repository porting

Options
    • -0
    • +110
    ./postgresql/lob.sql
Thursday 29 Mar 2001
3:21 am

danw

more cleanup, added lob support for cr_revisions

Options
    • -0
    • +1
    ./postgresql/acs-kernel-create.sql
  2. … 9 more files in changeset.
Tuesday 27 Mar 2001
7:20 am

danw

added functons for introspection of db functions

Options
    • -0
    • +98
    ./postgresql/postgresql.sql
Saturday 24 Mar 2001
1:34 am

danw

fixed up some tree queries

Options
    • -1
    • +1
    ./postgresql/acs-permissions-create.sql
    • -25
    • +32
    ./postgresql/rel-constraints-create.sql
    • -16
    • +33
    ./postgresql/site-nodes-create.sql
    • -0
    • +46
    ./postgresql/test/rel-constraints-test.sql
    • -0
    • +1
    ./postgresql/test/rel-segments-test.sql
Friday 23 Mar 2001
1:21 am

danw

finished porting test-harness code

Options
    • -19
    • +37
    ./postgresql/acs-objects-create.sql
    • -11
    • +6
    ./postgresql/postgresql.sql
    • -6
    • +8
    ./postgresql/rel-constraints-body-create.sql
    • -9
    • +10
    ./postgresql/test/acs-objects-test.sql
    • -53
    • +179
    ./postgresql/test/rel-constraints-test.sql
    • -21
    • +20
    ./postgresql/test/rel-segments-test-types-create.sql
    • -3
    • +3
    ./postgresql/test/rel-segments-test-types-drop.sql
    • -58
    • +71
    ./postgresql/test/rel-segments-test.sql
    • -14
    • +3
    ./postgresql/test-harness/acs-core.sql
Thursday 22 Mar 2001
1:21 am

danw

added postgresql specific test files

Options
    • -0
    • +311
    ./postgresql/test/acs-objects-test.sql
    • -0
    • +170
    ./postgresql/test/groups-test.sql
    • -0
    • +363
    ./postgresql/test/rel-constraints-test.sql
    • -0
    • +205
    ./postgresql/test/rel-segments-test-types-create.sql
    • -0
    • +14
    ./postgresql/test/rel-segments-test-types-drop.sql
    • -0
    • +377
    ./postgresql/test/rel-segments-test.sql
    • -0
    • +79
    ./postgresql/test-harness/acs-core.sql
    • -0
    • +250
    ./postgresql/test-harness/acs-permissions.sql
1:09 am

danw

more porting of test-harness packages

Options
    • -17
    • +14
    ./postgresql/acs-relationships-create.sql
    • -0
    • +2
    ./postgresql/groups-create.sql
    • -3
    • +3
    ./postgresql/rel-constraints-body-create.sql
Wednesday 21 Mar 2001
7:41 am

danw

fixed a couple of dynamic sql statements

Options
    • -10
    • +12
    ./postgresql/acs-objects-create.sql
6:46 am

danw

fixed exception messages, membership_rels delete trigger and composition_rels delete trigger

Options
    • -18
    • +19
    ./postgresql/acs-objects-create.sql
    • -1
    • +1
    ./postgresql/acs-relationships-create.sql
    • -2
    • +1
    ./postgresql/apm-create.sql
    • -6
    • +2
    ./postgresql/groups-body-create.sql
    • -2
    • +2
    ./postgresql/groups-create.sql
    • -2
    • +1
    ./postgresql/site-nodes-create.sql
Tuesday 20 Mar 2001
11:51 pm

donb

bootstrapper can now load either the Oracle or PostgreSQL acs-kernel

datamodel. It checks on-the-fly for which db is configured in the OpenNSD

database pools allocated to OpenACS. Only acs-kernel is correctly self-

configured at this point.

Options
    • -274
    • +0
    ./acs-create.sql
    • -12
    • +0
    ./acs-drop.sql
    • -119
    • +0
    ./acs-install.sql
    • -32
    • +0
    ./acs-kernel-create.sql
    • -25
    • +0
    ./acs-kernel-drop.sql
    • -104
    • +0
    ./acs-logs-create.sql
    • -3
    • +0
    ./acs-logs-drop.sql
    • -689
    • +0
    ./acs-metadata-create.sql
    • -21
    • +0
    ./acs-metadata-drop.sql
    • -1024
    • +0
    ./acs-objects-create.sql
    • -25
    • +0
    ./acs-objects-drop.sql
    • -391
    • +0
    ./acs-permissions-create.sql
    • -23
    • +0
    ./acs-permissions-drop.sql
    • -506
    • +0
    ./acs-relationships-create.sql
    • -16
    • +0
    ./acs-relationships-drop.sql
  16. … 99 more files in changeset.
7:02 am

danw

more cleanup

Options
    • -7
    • +11
    ./postgresql/acs-metadata-create.sql
    • -15
    • +25
    ./postgresql/acs-objects-create.sql
    • -12
    • +12
    ./postgresql/acs-relationships-create.sql
    • -3
    • +3
    ./postgresql/groups-body-create.sql
    • -3
    • +3
    ./postgresql/rel-segments-body-create.sql
    • -2
    • +2
    ./postgresql/site-nodes-create.sql
    • -1
    • +1
    ./postgresql/utilities-create.sql
5:20 am

danw

removed more debug code

Options
    • -1
    • +1
    ./postgresql/acs-objects-create.sql
5:14 am

danw

removed debug code

Options
    • -19
    • +19
    ./postgresql/acs-objects-create.sql
5:12 am

danw

fixed several name conflicts

Options
    • -31
    • +37
    ./postgresql/acs-objects-create.sql
    • -13
    • +9
    ./postgresql/groups-body-create.sql
    • -2
    • +2
    ./postgresql/groups-create.sql
    • -2
    • +3
    ./postgresql/rel-constraints-body-create.sql
Monday 19 Mar 2001
6:07 am

danw

fixed name conflicts with for loop records

Options
    • -29
    • +25
    ./postgresql/acs-objects-create.sql
    • -6
    • +13
    ./postgresql/groups-body-create.sql
    • -0
    • +2
    ./postgresql/postgresql.sql
Sunday 18 Mar 2001
6:22 am

danw

fixed up a bunch of typos

Options
    • -1
    • +1
    ./postgresql/acs-kernel-create.sql
    • -6
    • +6
    ./postgresql/acs-objects-create.sql
    • -24
    • +3
    ./postgresql/acs-relationships-create.sql
    • -1
    • +1
    ./postgresql/apm-create.sql
    • -0
    • +29
    ./postgresql/community-core-create.sql
    • -7
    • +34
    ./postgresql/groups-body-create.sql
    • -2
    • +2
    ./postgresql/groups-create.sql
    • -45
    • +5
    ./postgresql/rel-constraints-create.sql
    • -2
    • +1
    ./postgresql/site-nodes-create.sql
5:44 am

danw

added new file from 4.2 beta

Options
    • -0
    • +171
    ./postgresql/rel-constraints-body-create.sql
Saturday 17 Mar 2001
10:46 pm

danw

fixed up for loops

Options
    • -36
    • +62
    ./postgresql/groups-body-create.sql
    • -4
    • +6
    ./postgresql/groups-create.sql
    • -2
    • +3
    ./postgresql/rel-segments-body-create.sql
    • -1
    • +2
    ./postgresql/rel-segments-drop.sql
9:21 pm

danw

fixed typo

Options
    • -1
    • +1
    ./postgresql/acs-objects-create.sql
8:53 pm

danw

fixed up a bunch of for loops

Options
    • -14
    • +16
    ./postgresql/acs-objects-create.sql
5:14 pm

danw

minor cleanup

Options
    • -9
    • +6
    ./postgresql/acs-permissions-create.sql
5:00 pm

danw

fixed data-change violation on acs_privilege_hierarchy_index

Options
    • -16
    • +23
    ./postgresql/acs-create.sql
    • -62
    • +67
    ./postgresql/acs-permissions-create.sql
2:19 am

danw

fixed problem with trigger recursion function

Options
    • -1
    • +1
    ./postgresql/acs-permissions-create.sql
2:12 am

danw

redo of acs_privilege_hierarchy tree query tree triggers

Options
    • -161
    • +96
    ./postgresql/acs-permissions-create.sql
Friday 16 Mar 2001
7:22 am

danw

modified acs_privilege_descendant_map to user exists instead of in

Options
    • -10
    • +13
    ./postgresql/acs-permissions-create.sql
3:50 am

danw

added tree query support for the acs_privilege_hierarchy table

Options
    • -5
    • +248
    ./postgresql/acs-permissions-create.sql
Thursday 15 Mar 2001
2:37 am

danw

added tree query support for acs_objects, site_nodes and fixed up tree queries for rel_constraints

Options
    • -3
    • +82
    ./postgresql/acs-objects-create.sql
    • -16
    • +18
    ./postgresql/acs-permissions-create.sql
    • -86
    • +101
    ./postgresql/rel-constraints-create.sql
    • -1
    • +79
    ./postgresql/site-nodes-create.sql
Wednesday 14 Mar 2001
3:07 pm

danw

fixed up some typos

Options
    • -4
    • +4
    ./postgresql/acs-metadata-create.sql
    • -3
    • +3
    ./postgresql/acs-objects-create.sql
    • -2
    • +2
    ./postgresql/acs-relationships-create.sql
    • -3
    • +3
    ./postgresql/rel-constraints-create.sql
    • -3
    • +3
    ./postgresql/rel-segments-create.sql
6:57 am

danw

removed bogus test file

Options
    • -109
    • +0
    ./postgresql/tst.sql