

--
-- Copyright 2004 The Apache Software Foundation.
--
-- Licensed under the Apache License, Version 2.0 (the "License")
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.

-- MySQL dump 9.11
--
-- Host: localhost    Database: agila
-- ------------------------------------------------------
-- Server version	4.0.21-max

--
-- Table structure for table `bpm_businessprocess`
--

CREATE TABLE bpm_businessprocess (
  businessprocessid int(11) NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  xml text
) TYPE=MyISAM;

--
-- Table structure for table `bpm_instance`
--

CREATE TABLE bpm_instance (
  instanceid int(11) NOT NULL default '0',
  processid int(11) NOT NULL default '0',
  graphname varchar(255) default NULL,
  params blob,
  status int(11) default NULL,
  startdate datetime default NULL,
  stepdate datetime default NULL,
  PRIMARY KEY  (instanceid)
) TYPE=MyISAM;

--
-- Table structure for table `bpm_task`
--

CREATE TABLE bpm_task (
  id int(11) NOT NULL default '0',
  userid int(11) NULL,
  groupid int(11) NULL,
  description varchar(255) default NULL,
  expiration datetime default NULL,
  tokenid int(11) NOT NULL default '0',
  status int(11) NOT NULL default '0',
  instanceid int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `bpm_token`
--

CREATE TABLE bpm_token (
  tokenid int(11) NOT NULL default '0',
  instanceid int(11) NOT NULL default '0',
  nodeid int(11) NOT NULL default '0',
  state int(11) NOT NULL default '0',
  active tinyint(4) default NULL,
  PRIMARY KEY  (tokenid)
) TYPE=MyISAM;

--
-- Table structure for table `bpm_unique_key`
--

CREATE TABLE bpm_unique_key (
  next_hi int(11) NOT NULL auto_increment,
  tstamp timestamp(14) NOT NULL,
  PRIMARY KEY  (next_hi)
) TYPE=MyISAM;

--
-- Table structure for table `bpm_userinfo`
--

CREATE TABLE bpm_userinfo (
  userid int(11) NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  principal varchar(255) NOT NULL default '',
  isadmin tinyint(4) default NULL,
  PRIMARY KEY  (userid)
) TYPE=MyISAM;

