[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.3
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.3 |
Date: |
Fri, 11 Jun 2004 20:44:02 +0200 |
Update of /property/setup
Modified Files:
Branch:
tables_current.inc.php
date: 2004/06/11 18:44:02; author: sigurdne; state: Exp; lines: +128 -1
Log Message:
no message
=====================================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.2
property/setup/tables_current.inc.php:1.3
--- property/setup/tables_current.inc.php:1.2 Wed Jun 2 18:36:31 2004
+++ property/setup/tables_current.inc.php Fri Jun 11 18:44:02 2004
@@ -1717,5 +1717,132 @@
'fk' => array(),
'ix' => array(),
'uc' => array()
+ ),
+
+ 'fm_orders' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'type' => array('type' => 'varchar',
'precision' => 50,'nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'vendor_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'name' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
+ 'descr' => array('type' => 'text','nullable' =>
True),
+ 'status' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
+ 'category' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'member_of' => array('type' =>
'text','nullable' => True),
+ 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'start_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'end_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
+ 'actual_cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
+ 'account_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'merknad' => array('type' => 'text','nullable'
=> True),
+ 'ukedag' => array('type' => 'text','nullable'
=> True),
+ 'dato' => array('type' =>
'timestamp','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_attribute' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0'),
+ 'list' => array('type' => 'int', 'precision' =>
2,'nullable' => True),
+ 'location_form' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'lookup_form' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'column_name' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
+ 'input_text' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
+ 'statustext' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
+ 'size' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
+ 'datatype' => array('type' => 'varchar',
'precision' => 10,'nullable' => False),
+ 'attrib_sort' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'precision_' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'scale' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
+ 'default_value' => array('type' => 'varchar',
'precision' => 18,'nullable' => True),
+ 'nullable' => array('type' => 'varchar',
'precision' => 5,'nullable' => False,'default' => 'True'),
+ 'search' => array('type' => 'int', 'precision'
=> 2,'nullable' => True)
+ ),
+ 'pk' => array('id','attrib_detail'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_category' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_choice' => array(
+ 'fd' => array(
+ 'attrib_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'value' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
+ 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0')
+ ),
+ 'pk' => array('attrib_id','id','attrib_detail'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_detail' => array(
+ 'fd' => array(
+ 'agreement_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'location_code' => array('type' => 'varchar',
'precision' => 30,'nullable' => False),
+ 'address' => array('type' => 'varchar',
'precision' => 100,'nullable' => True),
+ 'p_num' => array('type' => 'varchar',
'precision' => 15,'nullable' => False),
+ 'p_entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'p_cat_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'descr' => array('type' => 'text','nullable' =>
True),
+ 'unit' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
+ 'quantity' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
+ 'frequency' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
+ 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'test' => array('type' => 'text','nullable' =>
True),
+ 'cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True)
+ ),
+ 'pk' => array('agreement_id','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_pricing' => array(
+ 'fd' => array(
+ 'agreement_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'item_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'current_index' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'this_index' => array('type' => 'decimal',
'precision' => 20, 'scale' => 4,'nullable' => True),
+ 'cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
+ 'date' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
+ 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True)
+ ),
+ 'pk' => array('agreement_id','item_id','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
)
);
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.3,
nomail <=