[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      /* tables_baseline.inc.php,v 1.1 2005/05/08 08:00:03 ralfbecker Exp */
  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_planed_start' => array('type' => 'int','precision' => '8'),
  28                  'pm_planed_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_coordinator' => array('type' => 'int','precision' => '4'),
  37                  'pm_used_time' => array('type' => 'int','precision' => '4'),
  38                  'pm_planed_time' => array('type' => 'int','precision' => '4'),
  39                  'pm_used_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  40                  'pm_planed_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  41                  'pm_overwrite' => array('type' => 'int','precision' => '4','default' => '0')
  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_planed_time' => array('type' => 'int','precision' => '4'),
  66                  'pe_used_time' => array('type' => 'int','precision' => '4'),
  67                  'pe_planed_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  68                  'pe_used_budget' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  69                  'pe_planed_start' => array('type' => 'int','precision' => '8'),
  70                  'pe_real_start' => array('type' => 'int','precision' => '8'),
  71                  'pe_planed_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                  'pe_activity_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_cost_per_time' => array('type' => 'decimal','precision' => '20','scale' => '2'),
  80                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')
  81              ),
  82              'pk' => array('pm_id','pe_id'),
  83              'fk' => array(),
  84              'ix' => array(array('pm_id','pe_status')),
  85              'uc' => array()
  86          )
  87      );