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: 18:21
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 a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • -46
    • +16
    ./acs-permissions-create.sql
  2. … 11 more files in changeset.
Monday 17 Mar 2003
10:58 pm

donb

Migrated the 4.6.1 permissions stuff to HEAD

Options
    • -318
    • +189
    ./acs-permissions-create.sql
  2. … 7 more files in changeset.
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
  2. … 1 more file 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
    • -15
    • +3
    ./acs-permissions-create.sql
  2. … 4 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
Monday 17 Feb 2003
4:32 pm

jeffd

rollback Dons commit which should have gone in on 4.6 rather than HEAD

Options
    • -27
    • +185
    ./acs-permissions-create.sql
  2. … 7 more files in changeset.
Friday 14 Feb 2003
3:47 am

donb

More mucking around with the denormalized party_approved_member_map ...

Options
    • -185
    • +27
    ./acs-permissions-create.sql
  2. … 7 more files in changeset.
Tuesday 11 Feb 2003
6:03 pm

donb

1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

Options
    • -186
    • +54
    ./acs-permissions-create.sql
  2. … 23 more files in changeset.
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.