OpenACS / openacs-4 / packages / acs-service-contract / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 25 Sep
Commits this week: 0
Total Lines of Code (LoC): 3,490
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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 21 Oct 2003
9:22 pm

tilmanns

This failed previously because it used acs_sc_msg_type.get_id which does not return NULL when the msg_type is not defined but a no_data_found exception.

Options
    • -4
    • +9
    ./upgrade/upgrade-4.5.1-4.6.sql
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +924
    ./upgrade/upgrade-4.7d3-5.0d1.sql
  2. … 23 more files in changeset.
Wednesday 01 Oct 2003
12:28 pm

peterm

upgrade script fix: the defaulting of pretty name to impl_name was not working

Options
    • -5
    • +7
    ./upgrade/upgrade-4.7d2-4.7d3.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
    • -4
    • +4
    ./acs-sc-msg-types-create.sql
    • -22
    • +22
    ./acs-sc-packages-create.sql
    • -8
    • +8
    ./sc-sample-drop.sql
  4. … 273 more files in changeset.
Tuesday 16 Sep 2003
10:29 am

lars

- Default impl_pretty_name to impl_name

- Include impl_owner_name and impl_pretty_name in views

- Clean up UI and make it use list builder

Options
    • -4
    • +4
    ./acs-sc-views-create.sql
    • -1
    • +55
    ./upgrade/upgrade-4.7d2-4.7d3.sql
  3. … 13 more files in changeset.
Thursday 11 Sep 2003
10:58 am

peterm

making pretty_name of acs_sc_impls default to null in plsql new function

Options
    • -3
    • +3
    ./acs-sc-packages-create.sql
    • -4
    • +3
    ./upgrade/upgrade-4.7d2-4.7d3.sql
Wednesday 10 Sep 2003
4:53 pm

simonc

adding upgrades scripts for pretty_names on acs sc impls

Options
    • -0
    • +182
    ./upgrade/upgrade-4.7d2-4.7d3.sql
  2. … 1 more file in changeset.
4:52 pm

simonc

added support for pretty_names to acs sc impls

Options
    • -5
    • +7
    ./acs-sc-packages-create.sql
    • -1
    • +2
    ./acs-sc-tables-create.sql
  3. … 8 more files in changeset.
Saturday 17 May 2003
11:55 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./acs-sc-packages-create.sql
  2. … 107 more files in changeset.
Saturday 10 May 2003
1:03 am

lars

Clarified the error message when a service contract cannot be bound. Did the same for PostgreSQL a while ago.

Options
    • -2
    • +2
    ./acs-sc-packages-create.sql
Saturday 30 Nov 2002
6:11 pm

jeffd

merge from oacs-4-6

Options
    • -2
    • +3
    ./upgrade/upgrade-4.5-4.5.1.sql
    • -0
    • +19
    ./upgrade/upgrade-4.5.1-4.6.sql
  3. … 109 more files in changeset.
Tuesday 29 Oct 2002
2:51 am

vinodk

file upgrade-4.5.1-4.6.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.5.1-4.6.sql
  2. … 3 more files in changeset.
2:51 am

vinodk

- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

Options
    • -2
    • +3
    ./upgrade/upgrade-4.5-4.5.1.sql
    • -0
    • +19
    ./upgrade/upgrade-4.5.1-4.6.sql
  3. … 29 more files in changeset.
Tuesday 20 Aug 2002
11:05 pm

vinodk

fixed typos in my addition of acs_sc_impl_alias package

Options
    • -4
    • +4
    ./acs-sc-packages-create.sql
    • -7
    • +6
    ./upgrade/upgrade-4.5-4.5.1.sql
Saturday 17 Aug 2002
5:59 am

vinodk

1) Fixes Bug 1645

2) Adds acs_sc_impl_alias pacakge to Oracle version so it's consistent with PG version

3) Adds upgrade script for above changes

Options
    • -32
    • +100
    ./acs-sc-packages-create.sql
    • -0
    • +339
    ./upgrade/upgrade-4.5-4.5.1.sql
  3. … 1 more file in changeset.
Wednesday 26 Jun 2002
9:52 pm

yon

was out of sync with postgres version, was missing timestamp type

Options
    • -1
    • +2
    ./acs-sc-msg-types-create.sql
Friday 15 Feb 2002
4:36 pm

donb

Someone had written this script to do the drops in a PL/SQL block, can't

do that.

Options
    • -9
    • +5
    ./acs-sc-packages-drop.sql
3:55 pm

donb

Changed names of oracle views to be consistent with PG.

Options
    • -4
    • +4
    ./acs-sc-views-create.sql
Wednesday 06 Feb 2002
10:58 pm

yon

fixing acs_sc_impl.delete() bug

Options
    • -49
    • +39
    ./acs-sc-packages-create.sql
Thursday 31 Jan 2002
4:04 am

donb

Fixed bugs and added query files for Oracle so the damn thing works on both

RDBMSs (Kapil's fault, not Neophytos, as Kapil had claimed to have ported

this over)

Options
    • -3
    • +3
    ./acs-sc-packages-create.sql
    • -12
    • +1
    ./acs-sc-tables-create.sql
  3. … 8 more files in changeset.
Tuesday 15 Jan 2002
12:08 pm

neophytosd

added float and bytearray message types

Options
    • -1
    • +3
    ./acs-sc-msg-types-create.sql
  2. … 1 more file in changeset.
Sunday 21 Oct 2001
8:16 pm

donb

Started port of directory to postgresql, fixed some acs-service-contract

Oracle glitches ...

Options
    • -1
    • +1
    ./acs-sc-tables-drop.sql
    • -4
    • +4
    ./acs-sc-views-create.sql
  3. … 11 more files in changeset.
Tuesday 09 Oct 2001
7:37 am

ben

fixed for Oracle: acs_sc_impl_alias to acs_sc_impl_aliases

Options
    • -10
    • +10
    ./acs-sc-packages-create.sql
    • -4
    • +4
    ./acs-sc-tables-create.sql
7:14 am

ben

fixed for Oracle

Options
    • -2
    • +2
    ./acs-sc-packages-create.sql
6:53 am

ben

fixed delete_aliases to delete_alias (ben)

Options
    • -3
    • +4
    ./acs-sc-packages-create.sql
Thursday 20 Sep 2001
12:59 am

donb

Added Kapil's Oracle port of acs-service-contract.

Options
    • -0
    • +352
    ./acs-sc-msg-types-create.sql
    • -0
    • +17
    ./acs-sc-msg-types-drop.sql
    • -0
    • +31
    ./acs-sc-object-types-create.sql
    • -0
    • +14
    ./acs-sc-object-types-drop.sql
    • -0
    • +568
    ./acs-sc-packages-create.sql
    • -0
    • +10
    ./acs-sc-packages-drop.sql
    • -0
    • +95
    ./acs-sc-tables-create.sql
    • -0
    • +5
    ./acs-sc-tables-drop.sql
    • -0
    • +48
    ./acs-sc-views-create.sql
    • -0
    • +4
    ./acs-sc-views-drop.sql
    • -0
    • +5
    ./acs-service-contract-create.sql
    • -0
    • +7
    ./acs-service-contract-drop.sql
    • -0
    • +100
    ./sc-sample-create.sql
    • -0
    • +24
    ./sc-sample-drop.sql