[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 20295 2006-02-15 12:31:25Z  $ */
  13  
  14      $phpgw_baseline = array(
  15          'egw_cal' => array(
  16              'fd' => array(
  17                  'cal_id' => array('type' => 'auto','nullable' => False),
  18                  'cal_uid' => array('type' => 'varchar','precision' => '255','nullable' => False),
  19                  'cal_owner' => array('type' => 'int','precision' => '4','nullable' => False),
  20                  'cal_category' => array('type' => 'varchar','precision' => '30'),
  21                  'cal_modified' => array('type' => 'int','precision' => '8'),
  22                  'cal_priority' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '2'),
  23                  'cal_public' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '1'),
  24                  'cal_title' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '1'),
  25                  'cal_description' => array('type' => 'text'),
  26                  'cal_location' => array('type' => 'varchar','precision' => '255'),
  27                  'cal_reference' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  28                  'cal_modifier' => array('type' => 'int','precision' => '4'),
  29                  'cal_non_blocking' => array('type' => 'int','precision' => '2','default' => '0')
  30              ),
  31              'pk' => array('cal_id'),
  32              'fk' => array(),
  33              'ix' => array(),
  34              'uc' => array()
  35          ),
  36          'egw_cal_holidays' => array(
  37              'fd' => array(
  38                  'hol_id' => array('type' => 'auto','nullable' => False),
  39                  'hol_locale' => array('type' => 'char','precision' => '2','nullable' => False),
  40                  'hol_name' => array('type' => 'varchar','precision' => '50','nullable' => False),
  41                  'hol_mday' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
  42                  'hol_month_num' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
  43                  'hol_occurence' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
  44                  'hol_dow' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
  45                  'hol_observance_rule' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0')
  46              ),
  47              'pk' => array('hol_id'),
  48              'fk' => array(),
  49              'ix' => array('hol_locale'),
  50              'uc' => array()
  51          ),
  52          'egw_cal_repeats' => array(
  53              'fd' => array(
  54                  'cal_id' => array('type' => 'int','precision' => '4','nullable' => False),
  55                  'recur_type' => array('type' => 'int','precision' => '2','nullable' => False),
  56                  'recur_enddate' => array('type' => 'int','precision' => '8'),
  57                  'recur_interval' => array('type' => 'int','precision' => '2','default' => '1'),
  58                  'recur_data' => array('type' => 'int','precision' => '2','default' => '1'),
  59                  'recur_exception' => array('type' => 'text')
  60              ),
  61              'pk' => array('cal_id'),
  62              'fk' => array(),
  63              'ix' => array(),
  64              'uc' => array()
  65          ),
  66          'egw_cal_user' => array(
  67              'fd' => array(
  68                  'cal_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  69                  'cal_recur_date' => array('type' => 'int','precision' => '8','default' => '0'),
  70                  'cal_user_type' => array('type' => 'varchar','precision' => '1','nullable' => False,'default' => 'u'),
  71                  'cal_user_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  72                  'cal_status' => array('type' => 'char','precision' => '1','default' => 'A'),
  73                  'cal_quantity' => array('type' => 'int','precision' => '4','default' => '1')
  74              ),
  75              'pk' => array('cal_id','cal_recur_date','cal_user_type','cal_user_id'),
  76              'fk' => array(),
  77              'ix' => array(),
  78              'uc' => array()
  79          ),
  80          'egw_cal_extra' => array(
  81              'fd' => array(
  82                  'cal_id' => array('type' => 'int','precision' => '4','nullable' => False),
  83                  'cal_extra_name' => array('type' => 'varchar','precision' => '40','nullable' => False),
  84                  'cal_extra_value' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '')
  85              ),
  86              'pk' => array('cal_id','cal_extra_name'),
  87              'fk' => array(),
  88              'ix' => array(),
  89              'uc' => array()
  90          ),
  91          'egw_cal_dates' => array(
  92              'fd' => array(
  93                  'cal_id' => array('type' => 'int','precision' => '4','nullable' => False),
  94                  'cal_start' => array('type' => 'int','precision' => '8','nullable' => False),
  95                  'cal_end' => array('type' => 'int','precision' => '8','nullable' => False)
  96              ),
  97              'pk' => array('cal_id','cal_start'),
  98              'fk' => array(),
  99              'ix' => array(),
 100              'uc' => array()
 101          )
 102      );