[Sommaire] [Imprimer]

   1  <?php
   2    /**************************************************************************\
   3    * eGroupWare                                                               *
   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 20601 2006-03-17 20:57:23Z ralfbecker $ */
  13  
  14      $phpgw_baseline = array(
  15          'egw_infolog' => array(
  16              'fd' => array(
  17                  'info_id' => array('type' => 'auto','nullable' => False),
  18                  'info_type' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => 'task'),
  19                  'info_from' => array('type' => 'varchar','precision' => '255'),
  20                  'info_addr' => array('type' => 'varchar','precision' => '255'),
  21                  'info_subject' => array('type' => 'varchar','precision' => '255'),
  22                  'info_des' => array('type' => 'text'),
  23                  'info_owner' => array('type' => 'int','precision' => '4','nullable' => False),
  24                  'info_responsible' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '0'),
  25                  'info_access' => array('type' => 'varchar','precision' => '10','default' => 'public'),
  26                  'info_cat' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  27                  'info_datemodified' => array('type' => 'int','precision' => '8','nullable' => False),
  28                  'info_startdate' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
  29                  'info_enddate' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
  30                  'info_id_parent' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  31                  'info_planned_time' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  32                  'info_used_time' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  33                  'info_status' => array('type' => 'varchar','precision' => '40','default' => 'done'),
  34                  'info_confirm' => array('type' => 'varchar','precision' => '10','default' => 'not'),
  35                  'info_modifier' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  36                  'info_link_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  37                  'info_priority' => array('type' => 'int','precision' => '2','default' => '1'),
  38                  'pl_id' => array('type' => 'int','precision' => '4'),
  39                  'info_price' => array('type' => 'float','precision' => '8'),
  40                  'info_percent' => array('type' => 'int','precision' => '2','default' => '0'),
  41                  'info_datecompleted' => array('type' => 'int','precision' => '8'),
  42                  'info_location' => array('type' => 'varchar','precision' => '255')
  43              ),
  44              'pk' => array('info_id'),
  45              'fk' => array(),
  46              'ix' => array(array('info_owner','info_responsible','info_status','info_startdate'),array('info_id_parent','info_owner','info_responsible','info_status','info_startdate')),
  47              'uc' => array()
  48          ),
  49          'egw_infolog_extra' => array(
  50              'fd' => array(
  51                  'info_id' => array('type' => 'int','precision' => '4','nullable' => False),
  52                  'info_extra_name' => array('type' => 'varchar','precision' => '32','nullable' => False),
  53                  'info_extra_value' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '')
  54              ),
  55              'pk' => array('info_id','info_extra_name'),
  56              'fk' => array(),
  57              'ix' => array(),
  58              'uc' => array()
  59          )
  60      );