OpenACS / openacs-4 / packages / workflow / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 2,123
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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 29 Apr 2004
10:20 pm

jeffd

upgrade-1.2d1-1.2b2.sql should have been named upgrade-1.2d2-1.2b2.sql as it overlapped with the upgrade-1.2d1-1.2d2.sql script an so was not executed when upgrading from core 5.0.4

Options
    • -130
    • +0
    ./upgrade/upgrade-1.2d1-1.2b2.sql
    • -0
    • +130
    ./upgrade/upgrade-1.2d2-1.2b2.sql
  3. … 2 more files in changeset.
Sunday 07 Mar 2004
12:08 pm

maltes

Added missing drop statements

Options
    • -0
    • +6
    ./workflow-tables-drop.sql
Friday 30 Jan 2004
10:46 am

peterm

porting the table-create sql script and the 1.2-2.0d1 upgrade script from PG to Oracle

Options
    • -4
    • +4
    ./workflow-tables-create.sql
    • -6
    • +6
    ./upgrade/upgrade-1.2-2.0d1.sql
  3. … 3 more files in changeset.
Thursday 29 Jan 2004
1:47 pm

peterm

the trigger type constraint in the upgrade script was old. Caught this problem thanks to the automated tests that Lars have written.

Options
    • -2
    • +2
    ./upgrade/upgrade-1.2-2.0d1.sql
12:10 pm

peterm

need to drop old workflow_deputies column with cascade

Options
    • -3
    • +3
    ./upgrade/upgrade-1.2-2.0d1.sql
Wednesday 28 Jan 2004
10:39 am

peterm

changing proc workflow::case::fsm::get to allow parent_enabled_action_id to be null. Removing two obsolete TODOs

Options
    • -4
    • +1
    ./upgrade/upgrade-1.2-2.0d1.sql
  2. … 1 more file in changeset.
Monday 26 Jan 2004
1:33 pm

lars

- Short_names are workflow-wide

- pretty-names are unique per parent_action_id

Options
    • -2
    • +2
    ./workflow-tables-create.sql
    • -1
    • +14
    ./upgrade/upgrade-1.2-2.0d1.sql
  3. … 4 more files in changeset.
Friday 23 Jan 2004
12:02 pm

lars

Added support for workflows with hierarchy, parallel actions, and dynamic number of parallel actions. Phew.

Options
    • -5
    • +3
    ./workflow-procedural-create.sql
    • -199
    • +212
    ./workflow-tables-create.sql
    • -176
    • +221
    ./upgrade/upgrade-1.2-2.0d1.sql
  4. … 15 more files in changeset.
Monday 12 Jan 2004
11:56 am

lars

Added unique constraint on workflow_fsm_action_en_in_st table

Options
    • -2
    • +3
    ./workflow-tables-create.sql
    • -1
    • +5
    ./upgrade/upgrade-1.2-2.0d1.sql
Friday 09 Jan 2004
4:47 pm

lars

Recursive workflows

Options
    • -3
    • +5
    ./workflow-procedural-create.sql
    • -17
    • +33
    ./workflow-tables-create.sql
    • -1
    • +114
    ./upgrade/upgrade-1.2-2.0d1.sql
  4. … 10 more files in changeset.
Thursday 08 Jan 2004
5:00 pm

lars

Definition-level support for recursive workflows

Options
    • -24
    • +13
    ./workflow-tables-create.sql
    • -0
    • +1
    ./workflow-tables-drop.sql
    • -24
    • +15
    ./upgrade/upgrade-1.2-2.0d1.sql
  4. … 4 more files in changeset.
2:23 pm

lars

- Fixed on delete cascade -> on delete set null for workflow_fsm_actions

- Added definition level tables for recursive workflows

Options
    • -1
    • +40
    ./workflow-tables-create.sql
    • -1
    • +50
    ./upgrade/upgrade-1.2-2.0d1.sql
  3. … 2 more files in changeset.
Monday 05 Jan 2004
4:42 pm

lars

Do not default to text/plain for description_mime_type

Options
    • -2
    • +2
    ./workflow-tables-create.sql
Tuesday 16 Dec 2003
7:18 pm

lars

New ::edit API that handles insert/update/delete for cascaded types (action -> fsm_action -> something else)

Options
    • -0
    • +4
    ./workflow-tables-create.sql
    • -1
    • +6
    ./upgrade/upgrade-1.2-2.0d1.sql
  3. … 9 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -10
    • +0
    ./workflow-procedural-create.sql
    • -0
    • +130
    ./upgrade/upgrade-1.2d1-1.2b2.sql
  3. … 597 more files in changeset.
Wednesday 10 Dec 2003
5:05 pm

lars

Comment about a missing unique constraint

Options
    • -0
    • +1
    ./workflow-tables-create.sql
Monday 01 Dec 2003
10:53 am

lars

- Added role::edit, role::get_options

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

Options
    • -3
    • +15
    ./workflow-tables-create.sql
    • -1
    • +12
    ./upgrade/upgrade-1.2-2.0d1.sql
  3. … 7 more files in changeset.
Tuesday 18 Nov 2003
6:57 pm

lars

Added timed actions

Options
    • -1
    • +38
    ./workflow-tables-create.sql
    • -0
    • +42
    ./upgrade/upgrade-1.2-2.0d1.sql
  3. … 17 more files in changeset.
6:54 pm

lars

file upgrade-1.2d1-1.2b2.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-1.2d1-1.2b2.sql
  2. … 1 more file in changeset.
6:54 pm

lars

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.

Options
    • -10
    • +0
    ./workflow-procedural-create.sql
    • -0
    • +130
    ./upgrade/upgrade-1.2d1-1.2b2.sql
  3. … 3 more files in changeset.
Thursday 13 Nov 2003
3:22 pm

joela

added description and description_mime_types to workflows

Options
    • -0
    • +2
    ./workflow-tables-create.sql
    • -0
    • +17
    ./upgrade/upgrade-1.2d1-1.2d2.sql
  3. … 2 more files in changeset.
Thursday 30 Oct 2003
12:14 pm

joela

added two new fields to workflow_actions

Options
    • -0
    • +2
    ./workflow-tables-create.sql
    • -0
    • +17
    ./upgrade/upgrade-1.1d1-1.2d1.sql
  3. … 2 more files in changeset.
Friday 03 Oct 2003
3:26 pm

peterm

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

Options
    • -1
    • +1
    ./workflow-procedural-create.sql
  2. … 1 more file in changeset.
12:12 pm

jeffd

drop workflow_case_assigned_actions view

Options
    • -1
    • +1
    ./workflow-tables-create.sql
    • -0
    • +1
    ./workflow-tables-drop.sql
Sunday 28 Sep 2003
3:24 am

lars

Added view workflow_case_assigned_actions

Options
    • -0
    • +21
    ./workflow-tables-create.sql
    • -0
    • +26
    ./upgrade/upgrade-1.0d5-1.1d1.sql
  3. … 3 more files in changeset.
Monday 01 Sep 2003
3:43 pm

peterm

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

Options
    • -0
    • +60
    ./workflow-tables-create.sql
    • -0
    • +2
    ./workflow-tables-drop.sql
    • -0
    • +68
    ./upgrade/upgrade-1.0d4-1.0d5.sql
  4. … 9 more files in changeset.
Thursday 28 Aug 2003
2:08 pm

lars

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

Options
    • -0
    • +97
    ./upgrade/upgrade-1.0d3-1.0d4.sql
2:03 pm

lars

Moving object-type creation out of an inline-function.

Options
    • -19
    • +12
    ./workflow-tables-create.sql
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -4
    • +4
    ./workflow-procedural-create.sql
    • -0
    • +8
    ./workflow-procedural-drop.sql
    • -1
    • +1
    ./workflow-service-contracts-create.sql
  4. … 814 more files in changeset.
Saturday 17 May 2003
2:45 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -0
    • +31
    ./upgrade/upgrade-1.0d2-1.0d3.sql
  2. … 29 more files in changeset.