OpenACS / openacs-4 / packages / glossary / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 4
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 1,699
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 15 May 2018
11:41 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./glossary-drop.sql
  2. … 10 more files in changeset.
Tuesday 17 Apr 2018
4:47 pm

hectorr

Fix a bunch of typos

Options
    • -1
    • +1
    ./glossary-create.sql
  2. … 120 more files in changeset.
Thursday 05 Apr 2018
4:44 pm

hectorr

Fix typos

Options
    • -19
    • +19
    ./wf-full-term-publish-create.sql
  2. … 150 more files in changeset.
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
    • -2
    • +2
    ./glossary-drop.sql
  2. … 275 more files in changeset.
Saturday 09 Mar 2002
3:00 am

donb

1. Changed a lot of package info files to fix problems ...

2. Added Vinod's bboard patch

3. Rationalized party e-mail checking by putting a "before insert or update"

trigger on the table that lower-cases email (this was already done by the

party.new() func but at least one update missed this). Got rid of all

"lower(email) = " and "upper(email) = " checks and just made all use the

db email column directly and lower-cased Tcl vars. In this way the index

on the email column is always and consistently used without needing to

define functional indexes on the column (an EE feature for Oracle).

4. Rationalized naming of a couple of workflows and fixed a glossary PG bug

where apparently its workflow got overwritten by one from the CMS at some

point in time.

5. Made the .cmp/.dat/.frm filters in the template code usable though not

very beautiful nor exactly correct. But with practice you can use them

to debug pages in the packages/* hierarchy. I also turned these off by

default as there's no need to run these filters on a production site!

6. Performed minor surgery on templating, including adding a new

"ad_return_exception_template" that allows you to return a templated

error page and aborts the script.

7. ??? probably but I think this covers most stuff.

Options
    • -40
    • +39
    ./wf-term-submission.sql
  2. … 74 more files in changeset.
Sunday 23 Dec 2001
1:58 am

donb

1. Removed call to "schedule_proc" in acs-workflow. It's no longer needed.

2. Changed admin UI so you can enter the sort order when adding or editing

places.

3. Duplicated Bart Teeuwisse's glossary changes for Oracle.

Options
    • -6
    • +115
    ./glossary-create.sql
    • -0
    • +1
    ./glossary-drop.sql
  3. … 11 more files in changeset.
Monday 19 Nov 2001
11:37 pm

neophytosd

initial revision of acs-workflow-4.3

Options
    • -2
    • +2
    ./wf-full-term-publish-create.sql
    • -1
    • +1
    ./wf-term-submission.sql
11:26 pm

neophytosd

initial revision of acs-workflow-4.3

Options
    • -329
    • +3
    ./glossary-workflows.sql
    • -0
    • +617
    ./wf-full-term-publish-create.sql
    • -0
    • +94
    ./wf-term-go-live.sql
    • -0
    • +426
    ./wf-term-submission.sql
  5. … 5 more files in changeset.
Friday 16 Nov 2001
4:11 am

donb

1. The PG port of apm__register_parameter had a tiny error which caused it

to not set the new parameter to its default value in any of the effected

package instances.

2. Glossary - added admin as a parent of glossary_admin so admins can admin.

3. edit-this-page PG: removed code that was written because of #1 above

4. edit-this-page Oracle: finished the datamodel port, added drop script

Options
    • -1
    • +2
    ./glossary-create.sql
  2. … 8 more files in changeset.
Thursday 25 Oct 2001
3:52 am

donb

navigation-procs-oracle.xql: we inherited a query from aD that sorted

backwards, messing up the database-derived nav bars generated from the

site map.

The rest is partial work towards getting glossary to work. After running

the query dispatcher it no longer worked even for Oracle due to a bunch

of duplicate query names in several files. Boo-hiss...

Options
    • -0
    • +23
    ./glossary-drop.sql
  2. … 40 more files in changeset.
Wednesday 24 Oct 2001
4:14 am

donb

news was subtyping content_revision with a NULL supertype. glossary-drop

broken for Oracle (probably still broken but it's better, I added stuff

I discovered as I worked on the PG version). The html doc had a missing

tag.

Options
    • -29
    • +16
    ./glossary-drop.sql
  2. … 2 more files in changeset.
Friday 20 Apr 2001
10:51 pm

donb

Initial revision

Options
    • -0
    • +265
    ./glossary-create.sql
    • -0
    • +174
    ./glossary-drop.sql
    • -0
    • +329
    ./glossary-workflows.sql
  4. … 2477 more files in changeset.