[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 19821 2005-11-14 18:16:56Z nelius_weiss $ */
  14  
  15  
  16      $phpgw_baseline = array(
  17          'egw_resources' => array(
  18              'fd' => array(
  19                  'res_id' => array('type' => 'auto'),
  20                  'name' => array('type' => 'varchar','precision' => '100'),
  21                  'short_description' => array('type' => 'varchar','precision' => '100'),
  22                  'cat_id' => array('type' => 'int','precision' => '11','nullable' => False),
  23                  'quantity' => array('type' => 'int','precision' => '11','default' => '1'),
  24                  'useable' => array('type' => 'int','precision' => '11','default' => '1'),
  25                  'location' => array('type' => 'varchar','precision' => '100'),
  26                  'bookable' => array('type' => 'varchar','precision' => '1'),
  27                  'buyable' => array('type' => 'varchar','precision' => '1'),
  28                  'prize' => array('type' => 'varchar','precision' => '200'),
  29                  'long_description' => array('type' => 'longtext'),
  30                  'picture_src' => array('type' => 'varchar','precision' => '20'),
  31                  'accessory_of' => array('type' => 'int','precision' => '11','default' => '-1'),
  32                  'storage_info' => array('type' => 'varchar','precision' => '200'),
  33                  'inventory_number' => array('type' => 'varchar','precision' => '20')
  34              ),
  35              'pk' => array('res_id'),
  36              'fk' => array(),
  37              'ix' => array(),
  38              'uc' => array()
  39          ),
  40          'egw_resources_extra' => array(
  41              'fd' => array(
  42                  'extra_id' => array('type' => 'int','precision' => '4','nullable' => False),
  43                  'extra_name' => array('type' => 'varchar','precision' => '40','nullable' => False),
  44                  'extra_owner' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '-1'),
  45                  'extra_value' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '')
  46              ),
  47              'pk' => array('extra_id','extra_name','extra_owner'),
  48              'fk' => array(),
  49              'ix' => array(),
  50              'uc' => array()
  51          )
  52      );