[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] old/brewer/setup/tables_current.inc.php, 1.1
From: |
nomail |
Subject: |
[Phpgroupware-cvs] old/brewer/setup/tables_current.inc.php, 1.1 |
Date: |
Thu, 30 Dec 2004 08:50:59 +0100 |
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()
)
);
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] old/brewer/setup/tables_current.inc.php, 1.1,
nomail <=