OpenACS / openacs-4 / packages / faq / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 16:34
Commits this week: 0
Total Lines of Code (LoC): 627
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
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./faq-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -1
    • +1
    ./faq-create.sql
    • -2
    • +2
    ./upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  3. … 8098 more files in changeset.
Saturday 12 Feb 2022
9:11 pm

gustafn

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

Options
    • -2
    • +2
    ./upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  2. … 8 more files in changeset.
Thursday 14 Feb 2019
5:15 pm

gustafn

Bring files on oacs-5-10 in sync with HEAD

Options
    • -3
    • +5
    ./faq-create.sql
  2. … 162 more files in changeset.
Wednesday 30 Jan 2019
1:13 pm

antoniop

Put on delete cascade defined in previous upgrades in creation sql as well

Options
    • -2
    • +2
    ./faq-create.sql
  2. … 1 more file in changeset.
Tuesday 29 Jan 2019
6:10 pm

antoniop

Introduce ON DELETE CASCADE on faq main datamodel tables, so generic acs_object db api can be used to e.g. delete a faq (fixes downstream errors when deleting FAQ package)

Options
    • -2
    • +4
    ./faq-create.sql
    • -0
    • +64
    ./upgrade/upgrade-5.10.0d5-5.10.0d6.sql
  3. … 3 more files in changeset.
Friday 18 Mar 2005
7:48 pm

andrewg

Renamed a mis-named variable.

Options
    • -2
    • +2
    ./faq-package-create.sql
Friday 02 Apr 2004
12:52 am

jeffd

split package from datamodel create, add fts contract, update for tip 42,43 fix name_method on pg

Options
    • -206
    • +8
    ./faq-create.sql
    • -0
    • +217
    ./faq-package-create.sql
    • -0
    • +1
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  4. … 6 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
    • -4
    • +4
    ./faq-create.sql
  2. … 275 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -1
    • +2
    ./faq-create.sql
    • -0
    • +212
    ./upgrade/upgrade-4.0-4.6.sql
  3. … 102 more files in changeset.
Tuesday 29 Oct 2002
2:52 am

vinodk

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

Options
    • -0
    • +0
    ./upgrade/upgrade-4.0-4.6.sql
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
    • -0
    • +212
    ./upgrade/upgrade-4.0-4.6.sql
  2. … 30 more files in changeset.
Monday 28 Oct 2002
5:16 pm

jeffd

adds disabled_p to table faqs (used by dotlrn)

Options
    • -1
    • +2
    ./faq-create.sql
  2. … 1 more file in changeset.
Thursday 30 May 2002
1:04 am

arjun

pl/sql proc to clone news items from one package to another

Options
    • -1
    • +47
    ./faq-create.sql
  2. … 1 more file in changeset.
Friday 20 Apr 2001
10:51 pm

donb

Forgot to define binary files before importing, so .gifs were messed up.

Options
    • -0
    • +0
    ./faq-create.sql
    • -0
    • +0
    ./faq-drop.sql
  3. … 2478 more files in changeset.
10:51 pm

donb

Initial revision

Options
    • -0
    • +276
    ./faq-create.sql
    • -0
    • +6
    ./faq-drop.sql
  3. … 2478 more files in changeset.