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

acs-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 369
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 28 Mar 2023
1:20 pm

antoniop

Remove no_alarms_until column

Rationale: the column or the related api is never used in upstream code to check whether notifications should be sent or not or not. The UI to manage the column's value was not linked anywhere. On the instances accessible by me downstream, no tuple was found where this column had a value.

Options
    • -2
    • +2
    ./acs-create.sql
  2. … 18 more files in changeset.
Sunday 28 Oct 2007
12:10 am

donb

'annotate' was not a child of 'admin' - pffft!

Options
    • -3
    • +4
    ./acs-create.sql
  2. … 3 more files in changeset.
Tuesday 26 Sep 2006
4:48 pm

byronl

Correction of name constraint

Options
    • -4
    • +4
    ./acs-create.sql
  2. … 13 more files in changeset.
Friday 18 Aug 2006
8:17 pm

emmar

Applying constraint naming standard

Options
    • -2
    • +3
    ./acs-create.sql
  2. … 10 more files in changeset.
Monday 21 Mar 2005
12:59 pm

rob

Added annotate permission as per TIP 74

Options
    • -0
    • +1
    ./acs-create.sql
  2. … 1 more file in changeset.
Wednesday 23 Feb 2005
11:07 am

jeffd

set title in acs objects when creating security context root, set titles for parameters, make acs_objects.package_id on delete set null

Options
    • -1
    • +2
    ./acs-create.sql
  2. … 5 more files in changeset.
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -3
    • +2
    ./acs-create.sql
  2. … 2275 more files in changeset.
Monday 20 Sep 2004
10:18 pm

andrewg

Modified cc_users moving the magic object lookup to its own query. The view was really slow when joined against the acs_magic_objects table.

Options
    • -3
    • +2
    ./acs-create.sql
  2. … 1 more file in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -3
    • +4
    ./acs-create.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -4
    • +3
    ./acs-create.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -3
    • +4
    ./acs-create.sql
  2. … 96 more files in changeset.
Thursday 04 Dec 2003
12:38 am

donb

Move over the bandaid patch for bug #1144 from the 5.0 branch. This needs

to be fixed for real (including datamodel changes with upgrade scripts) in

5.1.

Options
    • -2
    • +4
    ./acs-create.sql
  2. … 8 more files in changeset.
Sunday 30 Nov 2003
2:17 am

donb

Fixed bug 1142 again (more?)

Options
    • -1
    • +3
    ./acs-create.sql
  2. … 4 more files in changeset.
Wednesday 26 Nov 2003
11:47 pm

donb

Fixed bug #1144 - users added to relsegs of registered_users showed up twice

in the registered_users and cc_users views.

Options
    • -0
    • +1
    ./acs-create.sql
  2. … 1 more file in changeset.
Friday 21 Nov 2003
2:39 am

donb

Fixed bug 1144.

Options
    • -0
    • +1
    ./acs-create.sql
  2. … 1 more file in changeset.
Thursday 20 Nov 2003
10:24 pm

jeffd

Change the all_users to acs_users_all, bump version to 5.0.0b3, provide

upgrade script. fix where its used in logger, weblogger-portlet, and lars-blogger.

fixes bug 1174.

Options
    • -1
    • +1
    ./acs-create.sql
  2. … 9 more files in changeset.
Friday 17 Oct 2003
1:56 am

lars

Added all_users view to Oracle

Options
    • -0
    • +10
    ./acs-create.sql
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -15
    • +23
    ./acs-create.sql
  2. … 275 more files in changeset.
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
    • +11
    ./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
    • -6
    • +6
    ./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
    • +12
    ./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
    • +4
    ./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
    • +7
    ./acs-create.sql
  2. … 8 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -9
    • +11
    ./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
    • +11
    ./acs-create.sql
  2. … 11 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
    • -27
    • +60
    ./acs-create.sql
  2. … 17 more files in changeset.
Saturday 15 Feb 2003
9:56 pm

donb

Fixed various problems with the new permissions and minor main site changes

Options
    • -0
    • +19
    ./acs-create.sql
  2. … 5 more files in changeset.
4:23 am

donb

First cut at Oracle perm rewrite and some whacking around on the PG version

Options
    • -41
    • +55
    ./acs-create.sql
  2. … 10 more files in changeset.
Friday 07 Jun 2002
6:32 am

arjun

added "(select acs.magic_object_id('registered_users') from dual)"

clause to registered_users view based on results from scalability testing.

Options
    • -1
    • +1
    ./acs-create.sql
Wednesday 13 Feb 2002
5:58 pm

yon

fixed remove_user function to do the right things

Options
    • -107
    • +122
    ./acs-create.sql
  2. … 1 more file in changeset.