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: 16:06
Commits this week: 0
Total Lines of Code (LoC): 3,467
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 12 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 02 Dec 2023
12:10 pm

gustafn

Avoid duplicate entries in acs_sc_msg_type_elements

-- The three columns msg_type_id, element_name, and

-- element_msg_type_id identify the paramter uniquely, and must be

-- therefore not null.

Bump version number to 5.10.1b2

Options
    • -4
    • +8
    ./acs-sc-msg-types-create.sql
    • -0
    • +19
    ./upgrade/upgrade-5.10.1b1-5.10.1b2.sql
  3. … 3 more files in changeset.
12:10 pm

gustafn

file upgrade-5.10.1b1-5.10.1b2.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.10.1b1-5.10.1b2.sql
  2. … 1 more file in changeset.
Wednesday 04 Apr 2018
6:22 am

gustafn

fix typo

Options
    • -1
    • +1
    ./sc-sample-create.sql
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -2
    • +2
    ./acs-sc-packages-create.sql
    • -2
    • +2
    ./upgrade/upgrade-4.7d2-4.7d3.sql
    • -2
    • +2
    ./upgrade/upgrade-4.7d3-5.0d1.sql
  4. … 7832 more files in changeset.
Friday 21 Apr 2017
6:21 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./acs-sc-packages-create.sql
    • -2
    • +2
    ./upgrade/upgrade-4.7d2-4.7d3.sql
    • -2
    • +2
    ./upgrade/upgrade-4.7d3-5.0d1.sql
  4. … 7 more files in changeset.
Tuesday 26 Sep 2006
5:13 pm

byronl

Correction of name constraint

Options
    • -3
    • +3
    ./acs-sc-tables-create.sql
  2. … 5 more files in changeset.
Thursday 31 Aug 2006
6:31 pm

emmar

Downcase table_name and column_id of object types

Options
    • -7
    • +7
    ./acs-sc-object-types-create.sql
Friday 12 Mar 2004
7:48 pm

jeffd

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

Options
    • -2
    • +3
    ./acs-sc-msg-types-create.sql
    • -4
    • +13
    ./acs-sc-packages-create.sql
    • -0
    • +603
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  4. … 95 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

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

Options
    • -2
    • +1
    ./acs-sc-msg-types-create.sql
    • -12
    • +3
    ./acs-sc-packages-create.sql
    • -603
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  4. … 94 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
    • -2
    • +3
    ./acs-sc-msg-types-create.sql
    • -4
    • +13
    ./acs-sc-packages-create.sql
    • -0
    • +603
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  4. … 94 more files in changeset.
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.