[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_baseline.inc.php 16293 2004-08-09 11:07:58Z reinerj $ */
  13  
  14      $phpgw_baseline = array(
  15          'phpgw_felamimail_cache' => array(
  16              'fd' => array(
  17                  'accountid'     => array('type' => 'int', 'precision' => 4, 'nullable' => false),
  18                  'hostname'     => array('type' => 'varchar', 'precision' => 60, 'nullable' => false),
  19                  'accountname'     => array('type' => 'varchar', 'precision' => 200, 'nullable' => false),
  20                  'foldername'     => array('type' => 'varchar', 'precision' => 200, 'nullable' => false),
  21                  'uid'         => array('type' => 'int', 'precision' => 4, 'nullable' => false),
  22                  'subject'    => array('type' => 'text'),
  23                  'striped_subject'=> array('type' => 'text'),
  24                  'sender_name'    => array('type' => 'varchar', 'precision' => 120),
  25                  'sender_address'=> array('type' => 'varchar', 'precision' => 120),
  26                  'to_name'    => array('type' => 'varchar', 'precision' => 120),
  27                  'to_address'    => array('type' => 'varchar', 'precision' => 120),
  28                  'date'        => array('type' => 'varchar', 'precision' => 120),
  29                  'size'        => array('type' => 'int', 'precision' => 4),
  30                  'attachments'    => array('type' => 'varchar', 'precision' =>120)
  31              ),
  32              'pk' => array('accountid','hostname','accountname','foldername','uid'),
  33              'fk' => array(),
  34              'ix' => array(),
  35              'uc' => array()
  36          ),
  37          'phpgw_felamimail_folderstatus' => array(
  38              'fd' => array(
  39                  'accountid'     => array('type' => 'int', 'precision' => 4, 'nullable' => false),
  40                  'hostname'     => array('type' => 'varchar', 'precision' => 60, 'nullable' => false),
  41                  'accountname'     => array('type' => 'varchar', 'precision' => 200, 'nullable' => false),
  42                  'foldername'     => array('type' => 'varchar', 'precision' => 200, 'nullable' => false),
  43                  'messages'     => array('type' => 'int', 'precision' => 4),
  44                  'recent'    => array('type' => 'int', 'precision' => 4),
  45                  'unseen'    => array('type' => 'int', 'precision' => 4),
  46                  'uidnext'    => array('type' => 'int', 'precision' => 4),
  47                  'uidvalidity'    => array('type' => 'int', 'precision' => 4)
  48              ),
  49              'pk' => array('accountid','hostname','accountname','foldername'),
  50              'fk' => array(),
  51              'ix' => array(),
  52              'uc' => array()
  53          )
  54      );
  55  ?>