• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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 ...

    • -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
Addded not null contraint to cu_elements.curriculum_id, modified the del procedures, etc.

    • -4
    • +7
    ./oracle/curriculum-curriculum-package-create.sql
    • -2
    • +4
    ./oracle/curriculum-element-create.sql
    • -30
    • +73
    ./postgresql/curriculum-create.sql
    • -4
    • +4
    ./postgresql/curriculum-curriculum-package-create.sql
    • -2
    • +4
    ./postgresql/curriculum-element-create.sql
Added PostgreSQL datamodel scripts.

    • -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
Added Oracle datamodel scripts.

    • -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