[Sommaire] [Imprimer]

   1  <?php
   2      /**************************************************************************\
   3      * eGroupWare - Setup                                                       *
   4      * http://www.eGroupWare.org                                                *
   5      * Created by eTemplates DB-Tools written by ralfbecker@outdoor-training.de *
   6      * --------------------------------------------                             *
   7      * This program is free software; you can redistribute it and/or modify it  *
   8      * under the terms of the GNU General Public License as published by the    *
   9      * Free Software Foundation; either version 2 of the License, or (at your   *
  10      * option) any later version.                                               *
  11      \**************************************************************************/
  12      
  13      /* $Id: tables_current.inc.php 20226 2006-01-11 05:15:43Z ralfbecker $ */
  14  
  15  
  16      $phpgw_baseline = array(
  17          'egw_pm_projects' => array(
  18              'fd' => array(
  19                  'pm_id' => array('type' => 'auto','nullable' => False),
  20                  'pm_number' => array('type' => 'varchar','precision' => '64','nullable' => False),
  21                  'pm_title' => array('type' => 'varchar','precision' => '255','nullable' => False),
  22                  'pm_description' => array('type' => 'text','default' => ''),
  23                  'pm_creator' => array('type' => 'int','precision' => '4','nullable' => False),
  24                  'pm_created' => array('type' => 'int','precision' => '8','nullable' => False),
  25                  'pm_modifier' => array('type' => 'int','precision' => '4'),
  26                  'pm_modified' => array('type' => 'int','precision' => '8'),
  27                  'pm_planned_start' => array('type' => 'int','precision' => '8'),
  28                  'pm_planned_end' => array('type' => 'int','precision' => '8'),
  29                  'pm_real_start' => array('type' => 'int','precision' => '8'),
  30                  'pm_real_end' => array('type' => 'int','precision' => '8'),
  31                  'cat_id' => array('type' => 'int','precision' => '4','default' => '0'),
  32                  'pm_access' => array('type' => 'varchar','precision' => '7','default' => 'public'),
  33                  'pm_priority' => array('type' => 'int','precision' => '2','default' => '1'),
  34                  'pm_status' => array('type' => 'varchar','precision' => '9','default' => 'active'),
  35                  'pm_completion' => array('type' => 'int','precision' => '2','default' => '0'),
  36                  'pm_used_time' => array('type' => 'int','precision' => '4'),
  37                  'pm_planned_time' => array('type' => 'int','precision' => '4'),
  38                  'pm_used_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  39                  'pm_planned_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  40                  'pm_overwrite' => array('type' => 'int','precision' => '4','default' => '0'),
  41                  'pm_accounting_type' => array('type' => 'varchar','precision' => '10','default' => 'times')
  42              ),
  43              'pk' => array('pm_id'),
  44              'fk' => array(),
  45              'ix' => array('pm_title'),
  46              'uc' => array('pm_number')
  47          ),
  48          'egw_pm_extra' => array(
  49              'fd' => array(
  50                  'pm_id' => array('type' => 'int','precision' => '4'),
  51                  'pm_extra_name' => array('type' => 'varchar','precision' => '40'),
  52                  'pm_extra_value' => array('type' => 'text')
  53              ),
  54              'pk' => array('pm_id','pm_extra_name'),
  55              'fk' => array('pm_id' => array('egw_pm_projects' => 'pm_id')),
  56              'ix' => array(),
  57              'uc' => array()
  58          ),
  59          'egw_pm_elements' => array(
  60              'fd' => array(
  61                  'pm_id' => array('type' => 'int','precision' => '4'),
  62                  'pe_id' => array('type' => 'int','precision' => '4'),
  63                  'pe_title' => array('type' => 'varchar','precision' => '255','nullable' => False),
  64                  'pe_completion' => array('type' => 'int','precision' => '2'),
  65                  'pe_planned_time' => array('type' => 'int','precision' => '4'),
  66                  'pe_used_time' => array('type' => 'int','precision' => '4'),
  67                  'pe_planned_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  68                  'pe_used_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  69                  'pe_planned_start' => array('type' => 'int','precision' => '8'),
  70                  'pe_real_start' => array('type' => 'int','precision' => '8'),
  71                  'pe_planned_end' => array('type' => 'int','precision' => '8'),
  72                  'pe_real_end' => array('type' => 'int','precision' => '8'),
  73                  'pe_overwrite' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  74                  'pl_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  75                  'pe_synced' => array('type' => 'int','precision' => '8'),
  76                  'pe_modified' => array('type' => 'int','precision' => '8','nullable' => False),
  77                  'pe_modifier' => array('type' => 'int','precision' => '4','nullable' => False),
  78                  'pe_status' => array('type' => 'varchar','precision' => '8','nullable' => False,'default' => 'new'),
  79                  'pe_unitprice' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  80                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  81                  'pe_share' => array('type' => 'int','precision' => '4'),
  82                  'pe_health' => array('type' => 'int','precision' => '2'),
  83                  'pe_resources' => array('type' => 'varchar','precision' => '255'),
  84                  'pe_details' => array('type' => 'text'),
  85                  'pe_planned_quantity' => array('type' => 'float','precision' => '8'),
  86                  'pe_used_quantity' => array('type' => 'float','precision' => '8')
  87              ),
  88              'pk' => array('pm_id','pe_id'),
  89              'fk' => array(),
  90              'ix' => array(array('pm_id','pe_status')),
  91              'uc' => array()
  92          ),
  93          'egw_pm_constraints' => array(
  94              'fd' => array(
  95                  'pm_id' => array('type' => 'int','precision' => '4'),
  96                  'pe_id_end' => array('type' => 'int','precision' => '4'),
  97                  'pe_id_start' => array('type' => 'int','precision' => '4'),
  98                  'ms_id' => array('type' => 'int','precision' => '4')
  99              ),
 100              'pk' => array('pm_id','pe_id_end','pe_id_start','ms_id'),
 101              'fk' => array(),
 102              'ix' => array(array('pm_id','pe_id_start'),array('pm_id','ms_id')),
 103              'uc' => array()
 104          ),
 105          'egw_pm_milestones' => array(
 106              'fd' => array(
 107                  'ms_id' => array('type' => 'auto','nullable' => False),
 108                  'pm_id' => array('type' => 'int','precision' => '4','nullable' => False),
 109                  'ms_date' => array('type' => 'int','precision' => '8','nullable' => False),
 110                  'ms_title' => array('type' => 'varchar','precision' => '255'),
 111                  'ms_description' => array('type' => 'text')
 112              ),
 113              'pk' => array('ms_id'),
 114              'fk' => array(),
 115              'ix' => array('pm_id'),
 116              'uc' => array()
 117          ),
 118          'egw_pm_roles' => array(
 119              'fd' => array(
 120                  'role_id' => array('type' => 'auto','nullable' => False),
 121                  'pm_id' => array('type' => 'int','precision' => '4','default' => '0'),
 122                  'role_title' => array('type' => 'varchar','precision' => '80','nullable' => False),
 123                  'role_description' => array('type' => 'varchar','precision' => '255'),
 124                  'role_acl' => array('type' => 'int','precision' => '4','nullable' => False)
 125              ),
 126              'pk' => array('role_id'),
 127              'fk' => array(),
 128              'ix' => array('pm_id'),
 129              'uc' => array()
 130          ),
 131          'egw_pm_members' => array(
 132              'fd' => array(
 133                  'pm_id' => array('type' => 'int','precision' => '4','nullable' => False),
 134                  'member_uid' => array('type' => 'int','precision' => '4','nullable' => False),
 135                  'role_id' => array('type' => 'int','precision' => '4','default' => '0'),
 136                  'member_availibility' => array('type' => 'float','precision' => '4','default' => '100.0')
 137              ),
 138              'pk' => array('pm_id','member_uid'),
 139              'fk' => array(),
 140              'ix' => array(),
 141              'uc' => array()
 142          ),
 143          'egw_pm_pricelist' => array(
 144              'fd' => array(
 145                  'pl_id' => array('type' => 'auto','nullable' => False),
 146                  'pl_title' => array('type' => 'varchar','precision' => '255','nullable' => False),
 147                  'pl_description' => array('type' => 'text','default' => ''),
 148                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
 149                  'pl_unit' => array('type' => 'varchar','precision' => '20','nullable' => False)
 150              ),
 151              'pk' => array('pl_id'),
 152              'fk' => array(),
 153              'ix' => array(),
 154              'uc' => array()
 155          ),
 156          'egw_pm_prices' => array(
 157              'fd' => array(
 158                  'pm_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
 159                  'pl_id' => array('type' => 'int','precision' => '4','nullable' => False),
 160                  'pl_validsince' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
 161                  'pl_price' => array('type' => 'float','precision' => '8'),
 162                  'pl_modifier' => array('type' => 'int','precision' => '4','nullable' => False),
 163                  'pl_modified' => array('type' => 'int','precision' => '8','nullable' => False),
 164                  'pl_customertitle' => array('type' => 'varchar','precision' => '255'),
 165                  'pl_billable' => array('type' => 'int','precision' => '2','default' => '1')
 166              ),
 167              'pk' => array('pm_id','pl_id','pl_validsince'),
 168              'fk' => array(),
 169              'ix' => array(),
 170              'uc' => array()
 171          )
 172      );