[Sommaire] [Imprimer]

   1  <?php
   2    /**************************************************************************\
   3    * E-GroupWare - Setup                                                      *
   4    * http://www.egroupware.org                                                *
   5    * --------------------------------------------                             *
   6    *  This program is free software; you can redistribute it and/or modify it *
   7    *  under the terms of the GNU General Public License as published by the   *
   8    *  Free Software Foundation; either version 2 of the License, or (at your  *
   9    *  option) any later version.                                              *
  10    \**************************************************************************/
  11  
  12      /* $Id: tables_current.inc.php 19356 2005-10-11 12:50:31Z regis_glc $ */
  13  
  14      $phpgw_baseline = array(
  15          'egw_wf_activities' => array(
  16              'fd' => array(
  17                  'wf_activity_id'    => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
  18                  'wf_name'        => array('type' => 'varchar', 'precision' => '80', 'nullable' => True),
  19                  'wf_normalized_name'    => array('type' => 'varchar', 'precision' => '80', 'nullable' => True),
  20                  'wf_p_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
  21                  'wf_type'        => array('type' => 'varchar', 'precision' => '25', 'nullable' => True),
  22                  'wf_is_autorouted'    => array('type' => 'char', 'precision' => '1', 'nullable' => True),
  23                  'wf_flow_num'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
  24                  'wf_is_interactive'    => array('type' => 'char', 'precision' => '1', 'nullable' => True),
  25                  'wf_last_modif'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
  26                  'wf_description'    => array('type' => 'text', 'nullable' => True),
  27                  'wf_default_user'    => array('type' => 'varchar', 'precision' => '200', 'nullable' => True, 'default'=> '*'),
  28              ),
  29              'pk' => array('wf_activity_id'),
  30              'fk' => array(),
  31              'ix' => array(),
  32              'uc' => array()
  33          ),
  34          'egw_wf_activity_roles' => array(
  35              'fd' => array(
  36                  'wf_activity_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => False),
  37                  'wf_role_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
  38                  'wf_readonly'        => array('type' => 'int', 'precision' => '1', 'nullable' => False, 'default'=> 0),
  39              ),
  40              'pk' => array('wf_activity_id', 'wf_role_id'),
  41              'fk' => array(),
  42              'ix' => array(),
  43              'uc' => array()
  44          ),
  45          'egw_wf_instance_activities' => array(
  46              'fd' => array(
  47                  'wf_instance_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => False),
  48                  'wf_activity_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => False),
  49                  'wf_started'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
  50                  'wf_ended'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
  51                  'wf_user'        => array('type' => 'varchar', 'precision' => '200', 'nullable' => True),
  52                  'wf_status'        => array('type' => 'varchar', 'precision' => '25', 'nullable' => True),
  53              ),
  54              'pk' => array('wf_instance_id', 'wf_activity_id'),
  55              'fk' => array(),
  56              'ix' => array(array('wf_activity_id'),array('wf_instance_id'), array('wf_user')),
  57              'uc' => array()
  58          ),
  59          'egw_wf_instance_supplements' => array(
  60              'fd' => array(
  61              'wf_supplement_id'     => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
  62                  'wf_supplement_type'    => array('type' => 'varchar', 'precision' => '50', 'nullable' => True),
  63                  'wf_supplement_name'    => array('type' => 'varchar', 'precision' => '100', 'nullable' => True),
  64                  'wf_supplement_value'    => array('type' => 'text', 'nullable' => True),
  65                  'wf_workitem_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => True),
  66                  'wf_supplement_blob'    => array('type' => 'blob', 'nullable' => True)
  67              ),
  68              'pk' => array('wf_supplement_id'),
  69              'fk' => array(),
  70              'ix' => array(),
  71              'uc' => array()
  72          ),
  73          'egw_wf_instances' => array(
  74              'fd' => array(
  75                  'wf_instance_id'    => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
  76                  'wf_p_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
  77                  'wf_started'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
  78                  'wf_owner'        => array('type' => 'varchar', 'precision' => '200', 'nullable' => True),
  79                  'wf_next_activity'    => array('type' => 'blob', 'nullable' => True),
  80                  'wf_next_user'        => array('type' => 'varchar', 'precision' => '200', 'nullable' => True),
  81                  'wf_ended'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
  82                  'wf_status'        => array('type' => 'varchar', 'precision' => '25', 'nullable' => True),
  83                  'wf_priority'        => array('type' => 'int', 'precision' => '4', 'nullable' => True, 'default'=> 0),
  84                  'wf_properties'        => array('type' => 'blob', 'nullable' => True),
  85                  'wf_name'        => array('type' => 'varchar', 'precision'=>'120', 'nullable' => True),
  86                  'wf_category'        => array('type' => 'int', 'precision'=>'4', 'nullable' => True),
  87              ),
  88              'pk' => array('wf_instance_id'),
  89              'fk' => array(),
  90              'ix' => array(array('wf_owner'), array('wf_status')),
  91              'uc' => array()
  92          ),
  93          'egw_wf_processes' => array(
  94              'fd' => array(
  95                  'wf_p_id'        => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
  96                  'wf_name'        => array('type' => 'varchar', 'precision' => '80', 'nullable' => True),
  97                  'wf_is_valid'        => array('type' => 'char', 'precision' => '1', 'nullable' => True),
  98                  'wf_is_active'        => array('type' => 'char', 'precision' => '1', 'nullable' => True),
  99                  'wf_version'        => array('type' => 'varchar', 'precision' => '12', 'nullable' => True),
 100                  'wf_description'    => array('type' => 'text', 'nullable' => True),
 101                  'wf_last_modif'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
 102                  'wf_normalized_name'    => array('type' => 'varchar', 'precision' => '80', 'nullable' => True),
 103              ),
 104              'pk' => array('wf_p_id'),
 105              'fk' => array(),
 106              'ix' => array(array('wf_p_id','wf_is_active')),
 107              'uc' => array()
 108          ),
 109          'egw_wf_roles' => array(
 110              'fd' => array(
 111                  'wf_role_id'        => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
 112                  'wf_p_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 113                  'wf_last_modif'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
 114                  'wf_name'        => array('type' => 'varchar', 'precision' => '80', 'nullable' => True),
 115                  'wf_description'    => array('type' => 'text', 'nullable' => True),
 116              ),
 117              'pk' => array('wf_role_id'),
 118              'fk' => array(),
 119              'ix' => array(),
 120              'uc' => array()
 121          ),
 122          'egw_wf_transitions' => array(
 123              'fd' => array(
 124                  'wf_p_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 125                  'wf_act_from_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 126                  'wf_act_to_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 127              ),
 128              'pk' => array('wf_act_from_id', 'wf_act_to_id'),
 129              'fk' => array(),
 130              'ix' => array(),
 131              'uc' => array()
 132          ),
 133          'egw_wf_user_roles' => array(
 134              'fd' => array(
 135                  'wf_role_id'        => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
 136                  'wf_p_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 137                  'wf_user'        => array('type' => 'varchar', 'precision' => '200', 'nullable' => False),
 138                  'wf_account_type'    => array('type' => 'char', 'precision' => '1', 'nullable' => True, 'default' => 'u'),
 139              ),
 140              'pk' => array('wf_role_id', 'wf_user', 'wf_account_type'),
 141              'fk' => array(),
 142              'ix' => array(),
 143              'uc' => array()
 144          ),
 145          'egw_wf_workitems' => array(
 146              'fd' => array(
 147                  'wf_item_id'        => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
 148                  'wf_instance_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 149                  'wf_order_id'        => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 150                  'wf_properties'        => array('type' => 'blob', 'nullable' => True),
 151                  'wf_activity_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 152                  'wf_started'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
 153                  'wf_ended'        => array('type' => 'int', 'precision' => '4', 'nullable' => True),
 154                  'wf_user'        => array('type' => 'varchar', 'precision' => '200', 'nullable' => True),
 155                  'wf_note'        => array('type' => 'text', 'nullable' => True),
 156                  'wf_action'        => array('type' => 'text', 'nullable' => True),
 157              ),
 158              'pk' => array('wf_item_id'),
 159              'fk' => array(),
 160              'ix' => array(),
 161              'uc' => array()
 162          ),
 163          'egw_wf_process_config' => array( 
 164              'fd' => array(
 165                  'wf_p_id'               => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 166                  'wf_config_name'     => array('type' => 'varchar', 'precision' => '255', 'nullable' => False),
 167                  'wf_config_value'    => array('type' => 'text', 'nullable' => True),
 168                  'wf_config_value_int'    => array('type' => 'int', 'precision' => '4', 'nullable' => True),
 169              ),
 170              'pk' => array('wf_p_id','wf_config_name'),
 171              'fk' => array(),
 172              'ix' => array(),
 173              'uc' => array()
 174          ),
 175          'egw_wf_activity_agents' => array( 
 176              'fd' => array(
 177                  'wf_activity_id'    => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 178                  'wf_agent_id'         => array('type' => 'int', 'precision' => '4', 'nullable' => False),
 179                  'wf_agent_type'        => array('type' => 'varchar', 'precision' => '15', 'nullable' => False),
 180              ),
 181              'pk' => array('wf_activity_id', 'wf_agent_id'),
 182              'fk' => array(),
 183              'ix' => array(),
 184              'uc' => array()
 185          ),
 186          'egw_wf_agent_mail_smtp' => array( 
 187              'fd' => array(
 188                  'wf_agent_id'        => array('type' => 'auto', 'precision' => '4', 'nullable' => False),
 189                  'wf_to'         => array('type' => 'varchar', 'precision' => '255', 'nullable' => False, 'default' => '%roles%'),
 190                  'wf_cc'            => array('type' => 'varchar', 'precision' => '255', 'nullable' => True),
 191                  'wf_bcc'        => array('type' => 'varchar', 'precision' => '255', 'nullable' => True),
 192                  'wf_from'        => array('type' => 'varchar', 'precision' => '255', 'nullable' => True, 'default' => '%user%'),
 193                  'wf_replyTo'        => array('type' => 'varchar', 'precision' => '255', 'nullable' => True, 'default' => '%user%'),
 194                  'wf_subject'        => array('type' => 'varchar', 'precision' => '255', 'nullable' => True),
 195                  'wf_message'        => array('type' => 'text', 'nullable' => True),
 196                  'wf_send_mode'        => array('type' => 'int', 'precision' => '4', 'nullable' => True, 'default' => 0),
 197              ),
 198              'pk' => array('wf_agent_id'),
 199              'fk' => array(),
 200              'ix' => array(),
 201              'uc' => array()
 202          ),
 203      );