• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added missing drop statements

the workflow_user_deputy_map view was broken in oracle. Caught thanks to the extensive automated tests written by Lars

    • -2
    • +4
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
porting the table-create sql script and the 1.2-2.0d1 upgrade script from PG to Oracle

    • -114
    • +169
    ./oracle/workflow-tables-create.sql
    • -79
    • +230
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -4
    • +4
    ./postgresql/workflow-tables-create.sql
    • -6
    • +6
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 1 more file in changeset.
the trigger type constraint in the upgrade script was old. Caught this problem thanks to the automated tests that Lars have written.

    • -2
    • +2
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
need to drop old workflow_deputies column with cascade

    • -3
    • +3
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
changing proc workflow::case::fsm::get to allow parent_enabled_action_id to be null. Removing two obsolete TODOs

    • -4
    • +1
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 1 more file in changeset.
- Short_names are workflow-wide

- pretty-names are unique per parent_action_id

    • -2
    • +2
    ./postgresql/workflow-tables-create.sql
    • -1
    • +14
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 4 more files in changeset.
Added support for workflows with hierarchy, parallel actions, and dynamic number of parallel actions. Phew.

    • -5
    • +3
    ./postgresql/workflow-procedural-create.sql
    • -199
    • +212
    ./postgresql/workflow-tables-create.sql
    • -176
    • +221
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 15 more files in changeset.
Added unique constraint on workflow_fsm_action_en_in_st table

    • -2
    • +3
    ./postgresql/workflow-tables-create.sql
    • -1
    • +5
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
Recursive workflows

    • -3
    • +5
    ./postgresql/workflow-procedural-create.sql
    • -17
    • +33
    ./postgresql/workflow-tables-create.sql
    • -1
    • +114
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 10 more files in changeset.
Definition-level support for recursive workflows

    • -24
    • +15
    ./oracle/workflow-tables-create.sql
    • -24
    • +15
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -24
    • +13
    ./postgresql/workflow-tables-create.sql
    • -24
    • +15
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 2 more files in changeset.
- Fixed on delete cascade -> on delete set null for workflow_fsm_actions

- Added definition level tables for recursive workflows

    • -0
    • +40
    ./oracle/workflow-tables-create.sql
    • -1
    • +57
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -1
    • +40
    ./postgresql/workflow-tables-create.sql
    • -1
    • +50
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
Do not default to text/plain for description_mime_type

    • -2
    • +2
    ./postgresql/workflow-tables-create.sql
New ::edit API that handles insert/update/delete for cascaded types (action -> fsm_action -> something else)

    • -0
    • +4
    ./postgresql/workflow-tables-create.sql
    • -1
    • +6
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 9 more files in changeset.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

    • -11
    • +3
    ./oracle/workflow-procedural-create.sql
    • -0
    • +148
    ./oracle/upgrade/upgrade-1.2d1-1.2b2.sql
    • -10
    • +0
    ./postgresql/workflow-procedural-create.sql
    • -0
    • +130
    ./postgresql/upgrade/upgrade-1.2d1-1.2b2.sql
  1. … 594 more files in changeset.
Comment about a missing unique constraint

    • -0
    • +1
    ./postgresql/workflow-tables-create.sql
fixing typo in comment that was causing an Oracle error

- Added role::edit, role::get_options

- Adding unique constraints on short_name and pretty_name to roles, actions, fsm_states

    • -3
    • +16
    ./oracle/workflow-tables-create.sql
    • -1
    • +12
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -3
    • +15
    ./postgresql/workflow-tables-create.sql
    • -1
    • +12
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 5 more files in changeset.
Added timed actions

    • -1
    • +41
    ./oracle/workflow-tables-create.sql
    • -0
    • +48
    ./oracle/upgrade/upgrade-1.2-2.0d1.sql
    • -1
    • +38
    ./postgresql/workflow-tables-create.sql
    • -0
    • +42
    ./postgresql/upgrade/upgrade-1.2-2.0d1.sql
  1. … 15 more files in changeset.
file upgrade-1.2d1-1.2b2.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./oracle/upgrade/upgrade-1.2d1-1.2b2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.2d1-1.2b2.sql
Fixed bug #361 again (parent_id of log entry cr_items point to case's object), this time providing an upgrade script, changing the parent_id of existing log entries, and fixing the case deletion proc to delete cases properly given the parent_id.

    • -11
    • +3
    ./oracle/workflow-procedural-create.sql
    • -0
    • +148
    ./oracle/upgrade/upgrade-1.2d1-1.2b2.sql
    • -10
    • +0
    ./postgresql/workflow-procedural-create.sql
    • -0
    • +130
    ./postgresql/upgrade/upgrade-1.2d1-1.2b2.sql
  1. … 1 more file in changeset.
added description and description_mime_types to workflows

    • -0
    • +13
    ./oracle/upgrade/upgrade-1.2d1.1.2d2.sql
    • -0
    • +2
    ./postgresql/workflow-tables-create.sql
    • -0
    • +17
    ./postgresql/upgrade/upgrade-1.2d1-1.2d2.sql
added two new fields to workflow_actions

    • -0
    • +13
    ./oracle/upgrade/upgrade-1.1d1-1.2d1.sql
    • -0
    • +2
    ./postgresql/workflow-tables-create.sql
    • -0
    • +17
    ./postgresql/upgrade/upgrade-1.1d1-1.2d1.sql
bug 361: making cr_items.parent_id of case log entries be the object_id of the object governed by the case, just like for the acs_object.context_id of the case

    • -1
    • +1
    ./oracle/workflow-procedural-create.sql
    • -1
    • +1
    ./postgresql/workflow-procedural-create.sql
drop workflow_case_assigned_actions view

    • -1
    • +1
    ./postgresql/workflow-tables-create.sql
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)

    • -9
    • +9
    ./oracle/workflow-procedural-create.sql
  1. … 273 more files in changeset.
Added view workflow_case_assigned_actions

    • -1
    • +22
    ./oracle/workflow-tables-create.sql
    • -0
    • +27
    ./oracle/upgrade/upgrade-1.0d5-1.1d1.sql
    • -0
    • +21
    ./postgresql/workflow-tables-create.sql
    • -0
    • +26
    ./postgresql/upgrade/upgrade-1.0d5-1.1d1.sql
  1. … 1 more file in changeset.
adding the workflow deputy feature (when someone goes on vacation he can assign his tasks temporarily to someone else). Improving caching in the Tcl API and adding a cache API test

    • -0
    • +60
    ./oracle/workflow-tables-create.sql
    • -0
    • +68
    ./oracle/upgrade/upgrade-1.0d4-1.0d5.sql
    • -0
    • +60
    ./postgresql/workflow-tables-create.sql
    • -0
    • +68
    ./postgresql/upgrade/upgrade-1.0d4-1.0d5.sql
  1. … 6 more files in changeset.
we forgot to change the name of workflow_case to workflow_case_pkg in drop script

Added upgrade script to rename workflow_case__delete to avoid name-clash with old acs-workflow

    • -0
    • +97
    ./postgresql/upgrade/upgrade-1.0d3-1.0d4.sql