[daisy] [attention trunk users!] workflow branch merged

[Bruno Dumon]

Hi,

I've merged the BRANCH_WORKFLOW into the trunk. The work on workflow is
not finished, however there is enough progress and stability to justify
a merge into trunk, which will also make it easier for anyone to give it
a try.

I'll give more details with respect to the actual workflow stuff in
another mail, here are some things to take care of when moving to the
post-workflow SVN trunk:

Execute the following changes on the Daisy database:

CREATE TABLE wfpool_sequence
(
    maxid BIGINT
) Type=InnoDB;

CREATE TABLE wf_pools
(
    id BIGINT NOT NULL,
    name_ VARCHAR (100) NOT NULL,
    description VARCHAR (255),
    last_modified DATETIME NOT NULL,
    last_modifier BIGINT NOT NULL,
    updatecount BIGINT NOT NULL,
    PRIMARY KEY(id),
    UNIQUE (name_)
) Type=InnoDB;

CREATE TABLE wf_pool_members
(
    pool_id BIGINT NOT NULL,
    user_id BIGINT NOT NULL,
    added DATETIME NOT NULL,
    adder BIGINT NOT NULL,
    PRIMARY KEY(pool_id,user_id),
    FOREIGN KEY (pool_id) REFERENCES wf_pools (id),
    INDEX wf_pool_members_I_1 (user_id)
) Type=InnoDB;

===========================================================

Add the following to the myconfig.xml:

  <target path="/daisy/extensions/workflow/workflow-manager">
    <configuration>
      <jbpm>
        <hibernate>
          <properties>
            <entry key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</entry>
          </properties>
        </hibernate>
      </jbpm>
    </configuration>
  </target>

And that's (I think) all. The jBPM tables will be created the next time
you start the repository server. This will take some time, so you will
have to wait a bit longer for the repository to be fully started.

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org