OpenACS / openacs-4 / packages / acs-kernel / sql / postgresql

acs-permissions-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 804
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 38 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 30 Jan 2003
5:28 pm

danw

Modified permissions code to materialize acs_privilege_descendant_map view. Needed to speed up queries on acs_object_grantee_priv_map view.

Options
    • -1
    • +27
    ./acs-permissions-create.sql
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -13
    • +15
    ./acs-permissions-create.sql
  2. … 62 more files in changeset.
Saturday 01 Dec 2001
6:55 pm

donb

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

Options
    • -3
    • +3
    ./acs-permissions-create.sql
  2. … 11 more files in changeset.
Wednesday 28 Nov 2001
7:39 pm

donb

First round of speedups for verious permissions issues. Key finding is that

the all_object_party_privilege_map is speedy in PostgreSQL and apparently in

Oracle, as well (having re-read some of the optimization threads).

Options
    • -36
    • +78
    ./acs-permissions-create.sql
  2. … 23 more files in changeset.
Thursday 15 Nov 2001
2:47 am

donb

1. Fixed permissions bug in the PG version (missing OR clause in a view)

2. Added (untested thus far) site-wide-search to glossary

3. Added centralized support for importing files into the CR (either into

the filesystem or the database).

4. Fixed wp-slim. Fixed it some more. Fixed it again. It still needs

more fixing.

Options
    • -1
    • +2
    ./acs-permissions-create.sql
  2. … 61 more files in changeset.
Saturday 01 Sep 2001
10:26 pm

donb

Install acs-service-contract ...

Options
    • -106
    • +8
    ./acs-permissions-create.sql
  2. … 2 more files in changeset.
Saturday 12 May 2001
11:48 pm

danw

fixed permissions problem for handling insertion of dup index values

Options
    • -11
    • +51
    ./acs-permissions-create.sql
  2. … 1 more file in changeset.
Tuesday 01 May 2001
5:11 pm

stevew

Speedy replacement for permission_p from Matthew Avalos

Options
    • -16
    • +71
    ./acs-permissions-create.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
    • -4
    • +4
    ./acs-permissions-create.sql
  2. … 23 more files 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
    ./acs-permissions-create.sql
  2. … 6 more files in changeset.
Wednesday 18 Apr 2001
1:41 am

danw

added comments for default api values

Options
    • -2
    • +2
    ./acs-permissions-create.sql
  2. … 12 more files in changeset.
Saturday 24 Mar 2001
1:34 am

danw

fixed up some tree queries

Options
    • -1
    • +1
    ./acs-permissions-create.sql
  2. … 4 more files in changeset.
Saturday 17 Mar 2001
5:14 pm

danw

minor cleanup

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

danw

fixed data-change violation on acs_privilege_hierarchy_index

Options
    • -62
    • +67
    ./acs-permissions-create.sql
  2. … 1 more file in changeset.
2:19 am

danw

fixed problem with trigger recursion function

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

danw

redo of acs_privilege_hierarchy tree query tree triggers

Options
    • -161
    • +96
    ./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
    ./acs-permissions-create.sql
3:50 am

danw

added tree query support for the acs_privilege_hierarchy table

Options
    • -5
    • +248
    ./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
    • -16
    • +18
    ./acs-permissions-create.sql
  2. … 3 more files in changeset.
Wednesday 14 Mar 2001
5:39 am

danw

initial import of acs kernel data-model ported to postgresql - implementation of tree queries completed for acs_object_types. Still need to finish tree queries for acs_privilege_hierarchy and rel_constraints tables.

Options
    • -0
    • +426
    ./acs-permissions-create.sql
  2. … 37 more files in changeset.