[Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.2,1.2.2.1 tables_current.inc.php,1.16.2.2,1.16.2.3

[Sigurd Nes <address@hidden>]

Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv25605/setup

Modified Files:
      Tag: Version-0_9_14-branch
        default_records.inc.php tables_current.inc.php 
Log Message:
no message

Index: default_records.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/default_records.inc.php,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** default_records.inc.php     11 Nov 2002 21:34:33 -0000      1.2
--- default_records.inc.php     29 Jan 2003 22:16:12 -0000      1.2.2.1
***************
*** 47,49 ****
--- 47,58 ----
  $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_ns3420 (id, tekst1, 
enhet,tekst2) VALUES ('D20', 'RIGGING, ANLEGGSTOMT', 'RS','TILFØRSEL- OG 
FORSYNINGSANLEGG')");
  
+ #
+ #  `idgenerator`
+ #
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO idgenerator (name, value, 
increment) VALUES ('Bilagsnummer', '1', '1')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO idgenerator (name, value, 
increment) VALUES ('Ecobatchid', '1', '1')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO idgenerator (name, value, 
increment) VALUES ('project', '1', '1')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO idgenerator (name, value, 
increment) VALUES ('Statuslog', '1', '1')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO idgenerator (name, value, 
increment) VALUES ('workorder', '1', '1')");
+ 
  ?>

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.16.2.2
retrieving revision 1.16.2.3
diff -C2 -r1.16.2.2 -r1.16.2.3
*** tables_current.inc.php      2 Dec 2002 18:35:03 -0000       1.16.2.2
--- tables_current.inc.php      29 Jan 2003 22:16:12 -0000      1.16.2.3
***************
*** 447,451 ****
                                'id' => array('type' => 'int', 'precision' => 
4,'nullable' => False),
                                'num' => array('type' => 'varchar', 'precision' 
=> 20,'nullable' => False),
!                               'project_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                'owner' => array('type' => 'int', 'precision' 
=> 4,'nullable' => False),
                                'access' => array('type' => 'varchar', 
'precision' => 7,'nullable' => True),
--- 447,451 ----
                                'id' => array('type' => 'int', 'precision' => 
4,'nullable' => False),
                                'num' => array('type' => 'varchar', 'precision' 
=> 20,'nullable' => False),
!                               'project_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'owner' => array('type' => 'int', 'precision' 
=> 4,'nullable' => False),
                                'access' => array('type' => 'varchar', 
'precision' => 7,'nullable' => True),
***************
*** 465,468 ****
--- 465,470 ----
                                'rig_addition' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'location_code' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
+                               'equipment_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
+                               'equipment_type' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
                                'objekt_id' => array('type' => 'varchar', 
'precision' => 4,'nullable' => True),
                                'property_name' => array('type' => 'varchar', 
'precision' => 50,'nullable' => True),
***************
*** 513,517 ****
                                'billperae' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
                                'dim_d' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
!                               'descr' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
                                'branch_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'agreement_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True)
--- 515,519 ----
                                'billperae' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
                                'dim_d' => array('type' => 'int', 'precision' 
=> 4,'nullable' => True),
!                               'descr' => array('type' => 'text','nullable' => 
True),
                                'branch_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'agreement_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True)
***************
*** 613,616 ****
--- 615,619 ----
                                'unit' => array('type' => 'varchar', 
'precision' => 6,'nullable' => True),
                                'ns3420_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
+                               'tolerance' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'building_part' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
                                'quantity' => array('type' => 'decimal', 
'precision' => 20, 'scale' => 2,'nullable' => True),
***************
*** 1123,1136 ****
                'fm_investment' => array(
                        'fd' => array(
!                               'id' => array('type' => 'int','precision' => 
4,'nullable' => False),
!                               'location_code' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
!                               'objekt_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
!                               'cost_id' => array('type' => 'int', 'precision' 
=> 4,'nullable' => False),
!                               'descr' => array('type' => 'int', 'precision' 
=> 4,'nullable' => False),
!                               'type' => array('type' => 'int', 'precision' => 
4,'nullable' => False),
!                               'bygg_id' => array('type' => 'int', 'precision' 
=> 4,'nullable' => False),
!                               'equipment_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False)
                        ),
!                       'pk' => array('id'),
                        'fk' => array(),
                        'ix' => array(),
--- 1126,1137 ----
                'fm_investment' => array(
                        'fd' => array(
!                               'entity_id' => array('type' => 
'varchar','precision' => 20,'nullable' => False),
!                               'invest_id' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
!                               'entity_type' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
!                               'location_code' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True),
!                               'descr' => array('type' => 'varchar', 
'precision' => 255,'nullable' => True),
!                               'writeoff_year' => array('type' => 'int', 
'precision' => 4,'nullable' => True)
                        ),
!                       'pk' => array('entity_id','invest_id'),
                        'fk' => array(),
                        'ix' => array(),