[Phpgroupware-cvs] old/brewer/setup/tables_current.inc.php, 1.1

[nomail]

Update of /old/brewer/setup
Added Files:
        Branch: 
          tables_current.inc.php

date: 2004/12/30 07:50:59;  author: skwashd;  state: Exp;

Log Message:
keep a historic record of the app
=====================================================================
<?php
  /**************************************************************************\
  * phpGroupWare - Setup                                                     *
  * http://www.phpgroupware.org                                              *
  * --------------------------------------------                             *
  *  This program is free software; you can redistribute it and/or modify it *
  *  under the terms of the GNU General Public License as published by the   *
  *  Free Software Foundation; either version 2 of the License, or (at your  *
  *  option) any later version.                                              *
  \**************************************************************************/

  /**************************************************************************\
  * This file should be generated for you. It should never be edited by hand *
  \**************************************************************************/

  /* $Id: tables_current.inc.php,v 1.1 2004/12/30 07:50:59 skwashd Exp $ */

  // table array for brewer
        $phpgw_baseline = array(
                'phpgw_brewer_recipes' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','nullable' => 
False),
                                'name' => array('type' => 'varchar', 
'precision' => 64,'nullable' => True),
                                'style' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
                                'total_vol' => array('type' => 'decimal', 
'precision' => 4, 'scale' => 2,'nullable' => True),
                                'vol_units' => array('type' => 'varchar', 
'precision' => 16,'nullable' => True),
                                'boil_vol' => array('type' => 'decimal', 
'precision' => 4, 'scale' => 2,'nullable' => True),
                                'boil_units' => array('type' => 'varchar', 
'precision' => 16,'nullable' => True),
                                'boil_time' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'yeasts' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'num_yeasts' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'yeast_amounts' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'yeast_units' => array('type' => 'varchar', 
'precision' => 16,'nullable' => True),
                                'malts' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'num_malts' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'malt_amounts' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'malt_colors' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'malt_gravities' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'malt_units' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'hops' => array('type' => 'varchar', 
'precision' => 255,'nullable' => False),
                                'num_hops' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'hop_amounts' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'hop_times' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'hop_IBUs' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'hop_units' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'hop_bag' => array('type' => 'char', 
'precision' => 1,'nullable' => True),
                                'IBU_method' => array('type' => 'varchar', 
'precision' => 32,'nullable' => True),
                                'extraction_efficiency' => array('type' => 
'decimal', 'precision' => 4, 'scale' => 2,'nullable' => True),
                                'apparent_attenuation' => array('type' => 
'decimal', 'precision' => 4, 'scale' => 2,'nullable' => True),
                                'real_attenuation' => array('type' => 
'decimal', 'precision' => 4, 'scale' => 2,'nullable' => True),
                                'original_gravity' => array('type' => 
'decimal', 'precision' => 5, 'scale' => 3,'nullable' => True),
                                'final_gravity' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 3,'nullable' => True),
                                'alcohol_by_volume' => array('type' => 
'decimal', 'precision' => 5, 'scale' => 2,'nullable' => True),
                                'color' => array('type' => 'varchar', 
'precision' => 32,'nullable' => True),
                                'IBUs' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
                'phpgw_brewer_styles' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','nullable' => 
False),
                                'name' => array('type' => 'varchar', 
'precision' => 64,'nullable' => True),
                                'stock' => array('type' => 'char', 'precision' 
=> 1,'nullable' => True),
                                'description' => array('type' => 
'text','nullable' => True),
                                'ingredients' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'mingravity' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 3,'nullable' => True),
                                'maxgravity' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 3,'nullable' => True),
                                'minalcohol' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 2,'nullable' => True),
                                'maxalcohol' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 2,'nullable' => True),
                                'mincolor' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 2,'nullable' => True),
                                'maxcolor' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 2,'nullable' => True),
                                'minbitter' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 2,'nullable' => True),
                                'maxbitter' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 2,'nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
                'phpgw_brewer_yeasts' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','nullable' => 
False),
                                'name' => array('type' => 'varchar', 
'precision' => 64,'nullable' => True),
                                'avgatten' => array('type' => 'decimal', 
'precision' => 4, 'scale' => 2,'nullable' => True),
                                'flocrate' => array('type' => 'int', 
'precision' => 2,'nullable' => True),
                                'description' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
                'phpgw_brewer_malts' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','nullable' => 
False),
                                'name' => array('type' => 'varchar', 
'precision' => 64,'nullable' => True),
                                'gravity' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 3,'nullable' => True),
                                'avg_color' => array('type' => 'decimal', 
'precision' => 5, 'scale' => 2,'nullable' => True),
                                'starch_conv' => array('type' => 'int', 
'precision' => 2,'nullable' => True),
                                'description' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
                'phpgw_brewer_hops' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','nullable' => 
False),
                                'name' => array('type' => 'varchar', 
'precision' => 64,'nullable' => True),
                                'avg_alpha' => array('type' => 'decimal', 
'precision' => 4, 'scale' => 2,'nullable' => True),
                                'avg_iols' => array('type' => 'decimal', 
'precision' => 4, 'scale' => 2,'nullable' => True),
                                'description' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                )
        );
?>