Currently the database execution does not support multiple variable handlers of the same class, as of the suggested database model, due to the primary key:
DROP TABLE IF EXISTS variable_handler; CREATE TABLE variable_handler ( workflow_id INTEGER UNSIGNED NOT NULL REFERENCES workflow.workflow_id, variable VARCHAR(255) NOT NULL, class VARCHAR(255) NOT NULL, -- PRIMARY KEY (workflow_id, class) ) ENGINE=InnoDB; but i believe that a proper key would be: PRIMARY KEY (workflow_id, class, variable) is this a bug? seems odd -- José Moreira * http://pt.linkedin.com/in/josemoreira -- Components mailing list Components@lists.ez.no http://lists.ez.no/mailman/listinfo/components
