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

acs-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 22 May
Commits this week: 0
Total Lines of Code (LoC): 440
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 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 10 Sep 2003
10:40 am

peterm

committed the authority__new function with more than 16 arguments which doesn't work in PG. Reverting back to 16 args

Options
    • -4
    • +0
    ./acs-create.sql
  2. … 4 more files in changeset.
Tuesday 09 Sep 2003
1:15 pm

peterm

adding batch sync related columns to the auth_authorities table

Options
    • -0
    • +4
    ./acs-create.sql
  2. … 6 more files in changeset.
Friday 05 Sep 2003
3:26 pm

peterm

seems create or replace view doesn't work with PG 7.2 so changing to create view

Options
    • -1
    • +1
    ./acs-create.sql
Thursday 04 Sep 2003
5:47 pm

daveb

Added all_users view to get basic user info without all the baggae of cc_users.

Options
    • -0
    • +10
    ./acs-create.sql
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -3
    • +8
    ./acs-create.sql
  2. … 816 more files in changeset.
Friday 22 Aug 2003
5:05 pm

lars

Changed acs_user.new and acs.add_user to take authority_id and username. Removed password_question/answer to make room.

Options
    • -25
    • +55
    ./acs-create.sql
  2. … 3 more files in changeset.
3:54 pm

lars

We cannot create the local authority in authentication-procs, because acs_magic_objects isn't defined until acs-create.sql, and is referenced by a trigger on acs-objects.

Options
    • -0
    • +28
    ./acs-create.sql
  2. … 3 more files in changeset.
Wednesday 06 Aug 2003
7:58 pm

donb

"Registered users" had a join policy of "open", which meant a user could

visit the join group registration page manually and turn user_id 0 (the

public) into a registered user. Bad ...

Options
    • -2
    • +2
    ./acs-create.sql
  2. … 3 more files in changeset.
Friday 04 Jul 2003
2:22 pm

lars

1. Made object_id 0 be a user instead of a person;

2. Created a rel_type 'admin_rel' and corresponding role 'admin'.

Options
    • -1
    • +6
    ./acs-create.sql
  2. … 8 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -9
    • +12
    ./acs-create.sql
  2. … 30 more files in changeset.
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
    • -9
    • +12
    ./acs-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
    • -32
    • +77
    ./acs-create.sql
  2. … 7 more files in changeset.
Sunday 02 Mar 2003
11:32 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -1
    • +1
    ./acs-create.sql
  2. … 53 more files 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
    • -13
    • +0
    ./acs-create.sql
  2. … 4 more files in changeset.
Tuesday 18 Feb 2003
9:53 pm

donb

Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

Options
    • -45
    • +0
    ./acs-create.sql
  2. … 17 more files in changeset.
Monday 17 Feb 2003
4:32 pm

jeffd

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

Options
    • -76
    • +89
    ./acs-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
    • -89
    • +76
    ./acs-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
    • -89
    • +76
    ./acs-create.sql
  2. … 23 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -1
    • +1
    ./acs-create.sql
  2. … 54 more files in changeset.
Thursday 16 Jan 2003
2:27 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -1
    • +1
    ./acs-create.sql
  2. … 33 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -1
    • +1
    ./acs-create.sql
  2. … 54 more files in changeset.
Tuesday 17 Dec 2002
11:22 am

jeffd

changes acs__magic_object_id to isstrict,iscachable, bump version to 4.6.1, upgrade script provided

Options
    • -1
    • +1
    ./acs-create.sql
  2. … 3 more files in changeset.
Sunday 26 Aug 2001
2:30 pm

danw

changed magic object -3 from a group to a plain object

Options
    • -6
    • +2
    ./acs-create.sql
Thursday 24 May 2001
3:30 am

danw

porting of template queries

Options
    • -0
    • +19
    ./acs-create.sql
  2. … 41 more files in changeset.
Wednesday 18 Apr 2001
1:41 am

danw

added comments for default api values

Options
    • -11
    • +11
    ./acs-create.sql
  2. … 12 more files in changeset.
Wednesday 11 Apr 2001
1:53 am

danw

patch submitted by steve woodcock, and workflow porting

Options
    • -1
    • +1
    ./acs-create.sql
  2. … 1 more file in changeset.
Saturday 17 Mar 2001
5:00 pm

danw

fixed data-change violation on acs_privilege_hierarchy_index

Options
    • -16
    • +23
    ./acs-create.sql
  2. … 1 more file 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
    • +310
    ./acs-create.sql
  2. … 37 more files in changeset.