OpenACS / openacs-4 / packages / curriculum

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 1,453
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
Wednesday 08 Oct 2003
6:53 pm

mohanp

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

Options
    • -0
    • +258
    ./oracle/upgrade/upgrade-0.4d-0.5d1.sql
  2. … 23 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
    ./oracle/curriculum-curriculum-package-create.sql
    • -2
    • +2
    ./oracle/curriculum-element-package-create.sql
  3. … 274 more files in changeset.
Tuesday 10 Jun 2003
11:43 am

olah

New upgrade script. Column 'external_p' was added to cu_elements.

Options
    • -0
    • +13
    ./postgresql/upgrade/upgrade-0.2d-0.3d.sql
11:28 am

olah

Added a couple of package params and bumped up the version # because of\nan added 'external_p' column to cu_elements and the associated upgrade script.

Options
    • -4
    • +4
    ./oracle/curriculum-curriculum-package-create.sql
    • -1
    • +7
    ./oracle/curriculum-element-create.sql
    • -3
    • +5
    ./oracle/curriculum-element-package-create.sql
    • -4
    • +4
    ./postgresql/curriculum-curriculum-package-create.sql
    • -1
    • +7
    ./postgresql/curriculum-element-create.sql
    • -11
    • +13
    ./postgresql/curriculum-element-package-create.sql
  7. … 17 more files in changeset.
Tuesday 03 Jun 2003
8:51 pm

olah

Permissions inherited wrongly, both for curriculums ad elements.\nI had left out coalesce(p_context_id, p_package_id), etc.\nprovided an upgrade script for the sake of (my own) convenience ...

Options
    • -2
    • +2
    ./postgresql/curriculum-curriculum-package-create.sql
    • -2
    • +2
    ./postgresql/curriculum-element-package-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
12:45 pm

olah

Addded not null contraint to cu_elements.curriculum_id, modified the del procedures, etc.

Options
    • -30
    • +73
    ./oracle/curriculum-create.sql
    • -4
    • +7
    ./oracle/curriculum-curriculum-package-create.sql
    • -2
    • +3
    ./oracle/curriculum-drop.sql
    • -2
    • +4
    ./oracle/curriculum-element-create.sql
    • -30
    • +73
    ./postgresql/curriculum-create.sql
    • -4
    • +4
    ./postgresql/curriculum-curriculum-package-create.sql
    • -2
    • +3
    ./postgresql/curriculum-drop.sql
    • -2
    • +4
    ./postgresql/curriculum-element-create.sql
Monday 26 May 2003
7:42 pm

olah

Added PostgreSQL datamodel scripts.

Options
    • -0
    • +45
    ./postgresql/curriculum-create.sql
    • -0
    • +58
    ./postgresql/curriculum-curriculum-create.sql
    • -0
    • +15
    ./postgresql/curriculum-curriculum-drop.sql
    • -0
    • +109
    ./postgresql/curriculum-curriculum-package-create.sql
    • -0
    • +7
    ./postgresql/curriculum-curriculum-package-drop.sql
    • -0
    • +16
    ./postgresql/curriculum-drop.sql
    • -0
    • +67
    ./postgresql/curriculum-element-create.sql
    • -0
    • +16
    ./postgresql/curriculum-element-drop.sql
    • -0
    • +105
    ./postgresql/curriculum-element-package-create.sql
    • -0
    • +7
    ./postgresql/curriculum-element-package-drop.sql
    • -0
    • +22
    ./postgresql/curriculum-privileges-create.sql
    • -0
    • +20
    ./postgresql/curriculum-privileges-drop.sql
7:40 pm

olah

Added Oracle datamodel scripts.

Options
    • -0
    • +45
    ./oracle/curriculum-create.sql
    • -0
    • +60
    ./oracle/curriculum-curriculum-create.sql
    • -0
    • +20
    ./oracle/curriculum-curriculum-drop.sql
    • -0
    • +126
    ./oracle/curriculum-curriculum-package-create.sql
    • -0
    • +7
    ./oracle/curriculum-curriculum-package-drop.sql
    • -0
    • +16
    ./oracle/curriculum-drop.sql
    • -0
    • +69
    ./oracle/curriculum-element-create.sql
    • -0
    • +21
    ./oracle/curriculum-element-drop.sql
    • -0
    • +126
    ./oracle/curriculum-element-package-create.sql
    • -0
    • +7
    ./oracle/curriculum-element-package-drop.sql
    • -0
    • +25
    ./oracle/curriculum-privileges-create.sql
    • -0
    • +25
    ./oracle/curriculum-privileges-drop.sql