phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] property/setup setup.inc.php, 1.8 default_records.inc


From: sigurdne
Subject: [Phpgroupware-cvs] property/setup setup.inc.php, 1.8 default_records.inc.php, 1.6 tables_current.inc.php, 1.18 tables_update.inc.php, 1.3
Date: Thu, 24 Feb 2005 14:36:36 -0000

Update of property/setup

Modified Files:
     Branch: MAIN
            setup.inc.php lines: +24 -17
            default_records.inc.php lines: +27 -18
            tables_current.inc.php lines: +80 -65
            tables_update.inc.php lines: +25 -14

Log Message:
no message

====================================================
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.7 property/setup/setup.inc.php:1.8
--- property/setup/setup.inc.php:1.7    Fri Oct 22 13:59:42 2004
+++ property/setup/setup.inc.php        Fri Jan 14 08:50:50 2005
@@ -1,20 +1,26 @@
 <?php
-       
/**************************************************************************\
-       * phpGroupWare - property                                               
   *
-       * http://www.phpgroupware.org                                           
   *
-       *                                                                       
   *
-       * Facilities Management                                                 
   *
-       * Written by Sigurd Nes [sigurdne at online.no]                         
   *
-       * 
------------------------------------------------------------------------ *
-       * Copyright 2000 - 2003 Free Software Foundation, Inc                   
   *
-       * This program is part of the GNU project, see http://www.gnu.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.                                            
   *
-       
\**************************************************************************/
-       /* $Id$ */
+       /**
+       * phpGroupWare - property
+       * address@hidden http://www.phpgroupware.org}
+       *
+       * Property: a Facilities Management System.
+       *
+       * Copyright 2000 - 2003 Free Software Foundation, Inc
+       * This program is part of the GNU project, see address@hidden 
http://www.gnu.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.
+       *
+       * To contact the author write to address@hidden mailto:address@hidden 
Sigurd Nes}
+       *
+       * This is the setup information
+       * @author Sigurd Nes
+       * @package property
+       * @subpackage setup
+       * @version $Id$
+       */

        $setup_info['property']['name']      = 'property';
        $setup_info['property']['version']   = '0.9.15.001';
@@ -189,7 +195,8 @@
                'fm_s_agreement_choice',
                'fm_s_agreement_detail',
                'fm_s_agreement_pricing',
-               'fm_async_method'
+               'fm_async_method',
+               'fm_cron_log'
        );

        /* The hooks this app includes, needed for hooks registration */

====================================================
Index: property/setup/default_records.inc.php
diff -u property/setup/default_records.inc.php:1.5 
property/setup/default_records.inc.php:1.6
--- property/setup/default_records.inc.php:1.5  Fri Aug  6 20:16:49 2004
+++ property/setup/default_records.inc.php      Fri Jan 14 08:50:50 2005
@@ -1,22 +1,30 @@
 <?php
-       
/**************************************************************************\
-       * phpGroupWare - property                                               
   *
-       * http://www.phpgroupware.org                                           
   *
-       *                                                                       
   *
-       * Facilities Management                                                 
   *
-       * Written by Sigurd Nes [sigurdne at online.no]                         
   *
-       * 
------------------------------------------------------------------------ *
-       * Copyright 2000 - 2003 Free Software Foundation, Inc                   
   *
-       * This program is part of the GNU project, see http://www.gnu.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.                                            
   *
-       
\**************************************************************************/
-
-  /* $Id$ */
-
+       /**
+       * phpGroupWare - property
+       * address@hidden http://www.phpgroupware.org}
+       *
+       * Property: a Facilities Management System.
+       *
+       * Copyright 2000 - 2003 Free Software Foundation, Inc
+       * This program is part of the GNU project, see address@hidden 
http://www.gnu.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.
+       *
+       * To contact the author write to address@hidden mailto:address@hidden 
Sigurd Nes}
+       * @author Sigurd Nes
+       * @package property
+       * @subpackage setup
+       * @version $Id$
+       */
+
+
+       /**
+        * Description
+        * @package property
+        */
 #
 #fm_workorder_category
 #
@@ -204,6 +212,7 @@
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.2.1', 'Report type 1', 1)");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr, 
allow_grant) VALUES ('.entity.2.2', 'Report type 2', 1)");
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.s_agreement', 'Service agreement')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr) 
VALUES ('.b_account', 'Budget account')");


 #

====================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.17 
property/setup/tables_current.inc.php:1.18
--- property/setup/tables_current.inc.php:1.17  Sat Oct 23 22:11:00 2004
+++ property/setup/tables_current.inc.php       Fri Jan 14 08:50:50 2005
@@ -1,28 +1,27 @@
 <?php
-       
/**************************************************************************\
-       * phpGroupWare - property                                               
   *
-       * http://www.phpgroupware.org                                           
   *
-       *                                                                       
   *
-       * Facilities Management                                                 
   *
-       * Written by Sigurd Nes [sigurdne at online.no]                         
   *
-       * 
------------------------------------------------------------------------ *
-       * Copyright 2000 - 2003 Free Software Foundation, Inc                   
   *
-       * This program is part of the GNU project, see http://www.gnu.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 by setup. It should not need to be *
-  * edited by hand.                                                          *
-  \**************************************************************************/
+       /**
+       * phpGroupWare - property
+       * address@hidden http://www.phpgroupware.org}
+       *
+       * Property: a Facilities Management System.
+       *
+       * Copyright 2000 - 2003 Free Software Foundation, Inc
+       * This program is part of the GNU project, see address@hidden 
http://www.gnu.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.
+       *
+       * To contact the author write to address@hidden mailto:address@hidden 
Sigurd Nes}
+       *
+       * This is the current set of tables for the app property
+       * @author Sigurd Nes
+       * @package property
+       * @subpackage setup
+       * @version $Id$
+       */

-  /* $Id$ */
-
-  /* table array for property */
        $phpgw_baseline = array(
                'fm_part_of_town' => array(
                        'fd' => array(
@@ -47,7 +46,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '100','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'split' => array('type' => 'int','precision' => 
'2','nullable' => True),
                                'remark' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'owner' => array('type' => 
'varchar','precision' => '5','nullable' => True),
@@ -72,7 +71,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'user_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'remark' => array('type' => 
'varchar','precision' => '255','nullable' => True)
@@ -95,7 +94,7 @@
                'fm_streetaddress' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
-                               'descr' => array('type' => 
'varchar','precision' => '50','nullable' => False)
+                               'descr' => array('type' => 
'varchar','precision' => '150','nullable' => False)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
@@ -105,6 +104,7 @@
                'fm_tenant' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'member_of' => array('type' => 
'varchar','precision' => '255','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'first_name' => array('type' => 
'varchar','precision' => '30','nullable' => True),
                                'last_name' => array('type' => 
'varchar','precision' => '30','nullable' => True),
@@ -166,7 +166,7 @@
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
-                               'org_name' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'org_name' => array('type' => 
'varchar','precision' => '100','nullable' => True),
                                'email' => array('type' => 
'varchar','precision' => '64','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'klasse' => array('type' => 
'varchar','precision' => '10','nullable' => True),
@@ -454,7 +454,7 @@
                ),
                'fm_drawing' => array(
                        'fd' => array(
-                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
                                'title' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'drawing_name' => array('type' => 
'varchar','precision' => '50','nullable' => False),
                                'descr' => array('type' => 
'varchar','precision' => '255','nullable' => True),
@@ -466,7 +466,7 @@
                                'p_entity_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'p_cat_id' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'location_code' => array('type' => 
'varchar','precision' => '20','nullable' => False),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'loc1' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
@@ -541,7 +541,7 @@
                                'act_vendor_cost' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
                                'addition' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'rig_addition' => array('type' => 
'int','precision' => '4','nullable' => True),
-                               'account_id' => array('type' => 
'int','precision' => '4','nullable' => True),
+                               'account_id' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'key_fetch' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'key_deliver' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'integration' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -694,7 +694,7 @@
                                'w_cost' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
                                'total_cost' => array('type' => 
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' => 
'0.00'),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
-                               'date' => array('type' => 'int','precision' => 
'4','nullable' => True),
+                               'index_date' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'user_id' => array('type' => 'int','precision' 
=> '4','nullable' => True)
                        ),
                        'pk' => 
array('activity_id','agreement_id','index_count'),
@@ -836,7 +836,7 @@
                                'owner' => array('type' => 'int','precision' => 
'4','nullable' => True),
                                'access' => array('type' => 
'varchar','precision' => '7','nullable' => True),
                                'floor' => array('type' => 
'varchar','precision' => '6','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '100','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'tenant_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -942,7 +942,7 @@
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'floor' => array('type' => 
'varchar','precision' => '6','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '100','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'tenant_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -957,7 +957,7 @@
                'fm_tts_views' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
-                               'account_id' => array('type' => 
'varchar','precision' => '40','nullable' => True),
+                               'account_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'time' => array('type' => 'int','precision' => 
'4','nullable' => False)
                        ),
                        'pk' => array(),
@@ -990,8 +990,8 @@
                        'fd' => array(
                                'bilagsnr' => array('type' => 'int','precision' 
=> '4','nullable' => False),
                                'belop' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
False),
-                               'fakturadato' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
-                               'forfallsdato' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'fakturadato' => array('type' => 
'timestamp','nullable' => False),
+                               'forfallsdato' => array('type' => 
'timestamp','nullable' => False),
                                'artid' => array('type' => 'int','precision' => 
'2','nullable' => False),
                                'godkjentbelop' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
True),
                                'spvend_code' => array('type' => 
'varchar','precision' => '12','nullable' => True),
@@ -999,11 +999,11 @@
                                'saksbehandlerid' => array('type' => 
'varchar','precision' => '12','nullable' => True),
                                'budsjettansvarligid' => array('type' => 
'varchar','precision' => '12','nullable' => False),
                                'utbetalingid' => array('type' => 
'varchar','precision' => '12','nullable' => True),
-                               'oppsynsigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
-                               'saksigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
-                               'budsjettsigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
-                               'utbetalingsigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
-                               'overftid' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp')
+                               'oppsynsigndato' => array('type' => 
'timestamp','nullable' => True),
+                               'saksigndato' => array('type' => 
'timestamp','nullable' => True),
+                               'budsjettsigndato' => array('type' => 
'timestamp','nullable' => True),
+                               'utbetalingsigndato' => array('type' => 
'timestamp','nullable' => True),
+                               'overftid' => array('type' => 
'timestamp','nullable' => True)
                        ),
                        'pk' => array('bilagsnr'),
                        'ix' => array(),
@@ -1021,12 +1021,12 @@
                                'kostra_id' => array('type' => 
'varchar','precision' => '8','nullable' => True),
                                'pmwrkord_code' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'belop' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
False),
-                               'fakturadato' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'fakturadato' => array('type' => 
'timestamp','nullable' => False),
                                'periode' => array('type' => 'int','precision' 
=> '2','nullable' => True),
-                               'forfallsdato' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'forfallsdato' => array('type' => 
'timestamp','nullable' => False),
                                'fakturanr' => array('type' => 
'varchar','precision' => '15','nullable' => False),
                                'spbudact_code' => array('type' => 
'varchar','precision' => '30','nullable' => True),
-                               'regtid' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'regtid' => array('type' => 
'timestamp','nullable' => False),
                                'artid' => array('type' => 'int','precision' => 
'2','nullable' => False),
                                'godkjentbelop' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
True),
                                'spvend_code' => array('type' => 
'varchar','precision' => '12','nullable' => True),
@@ -1039,10 +1039,10 @@
                                'saksbehandlerid' => array('type' => 
'varchar','precision' => '12','nullable' => True),
                                'budsjettansvarligid' => array('type' => 
'varchar','precision' => '12','nullable' => False),
                                'utbetalingid' => array('type' => 
'varchar','precision' => '12','nullable' => True),
-                               'oppsynsigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
-                               'saksigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
-                               'budsjettsigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
-                               'utbetalingsigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
+                               'oppsynsigndato' => array('type' => 
'timestamp','nullable' => True),
+                               'saksigndato' => array('type' => 
'timestamp','nullable' => True),
+                               'budsjettsigndato' => array('type' => 
'timestamp','nullable' => True),
+                               'utbetalingsigndato' => array('type' => 
'timestamp','nullable' => True),
                                'merknad' => array('type' => 'text','nullable' 
=> True),
                                'splitt' => array('type' => 'int','precision' 
=> '2','nullable' => True),
                                'kreditnota' => array('type' => 
'int','precision' => '2','nullable' => True),
@@ -1064,12 +1064,12 @@
                                'kostra_id' => array('type' => 
'varchar','precision' => '8','nullable' => True),
                                'pmwrkord_code' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'belop' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
False),
-                               'fakturadato' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'fakturadato' => array('type' => 
'timestamp','nullable' => False),
                                'periode' => array('type' => 'int','precision' 
=> '2','nullable' => True),
-                               'forfallsdato' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'forfallsdato' => array('type' => 
'timestamp','nullable' => False),
                                'fakturanr' => array('type' => 
'varchar','precision' => '15','nullable' => False),
                                'spbudact_code' => array('type' => 
'varchar','precision' => '30','nullable' => True),
-                               'regtid' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'regtid' => array('type' => 
'timestamp','nullable' => False),
                                'artid' => array('type' => 'int','precision' => 
'2','nullable' => False),
                                'godkjentbelop' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
True),
                                'spvend_code' => array('type' => 
'varchar','precision' => '12','nullable' => True),
@@ -1085,7 +1085,7 @@
                                'oppsynsigndato' => array('type' => 
'timestamp','nullable' => True),
                                'saksigndato' => array('type' => 
'timestamp','nullable' => True),
                                'budsjettsigndato' => array('type' => 
'timestamp','nullable' => True),
-                               'utbetalingsigndato' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
+                               'utbetalingsigndato' => array('type' => 
'timestamp','nullable' => True),
                                'overftid' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp'),
                                'ordrebelop' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
False),
                                'merknad' => array('type' => 'text','nullable' 
=> True),
@@ -1243,7 +1243,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '100','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'tenant_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '20','nullable' => True),
                                'key_fetch' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -1295,7 +1295,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'descr' => array('type' => 
'varchar','precision' => '255','nullable' => True),
                                'writeoff_year' => array('type' => 
'int','precision' => '4','nullable' => True)
                        ),
@@ -1313,7 +1313,7 @@
                                'this_index' => array('type' => 
'decimal','precision' => '20','scale' => '4','default' => '0','nullable' => 
True),
                                'initial_value' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
True),
                                'value' => array('type' => 
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' => 
True),
-                               'date' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp')
+                               'index_date' => array('type' => 
'timestamp','nullable' => True,'default' => 'current_timestamp')
                        ),
                        'pk' => array('entity_id','invest_id','index_count'),
                        'fk' => array(),
@@ -1352,7 +1352,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'coordinator' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'vendor_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'branch_id' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -1490,7 +1490,8 @@
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
                                'abid' => array('type' => 'int','precision' => 
'4','nullable' => False),
-                               'org_name' => array('type' => 
'varchar','precision' => '50','nullable' => False),
+                               'org_name' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'contact_name' => array('type' => 
'varchar','precision' => '50','nullable' => True),
                                'category' => array('type' => 'int','precision' 
=> '4','nullable' => False),
                                'member_of' => array('type' => 
'varchar','precision' => '255','nullable' => True),
                                'remark' => array('type' => 
'varchar','precision' => '255','nullable' => True),
@@ -1605,7 +1606,8 @@
                                'tracking' => array('type' => 'int','precision' 
=> '4','nullable' => True),
                                'location_level' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'fileupload' => array('type' => 
'int','precision' => '4','nullable' => True),
-                               'loc_link' => array('type' => 'int','precision' 
=> '4','nullable' => True)
+                               'loc_link' => array('type' => 'int','precision' 
=> '4','nullable' => True),
+                               'start_project' => array('type' => 
'int','precision' => '4','nullable' => True)
                        ),
                        'pk' => array('entity_id','id'),
                        'fk' => array(),
@@ -1662,7 +1664,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'tenant_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '30','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -1691,7 +1693,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'tenant_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '30','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -1720,7 +1722,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'tenant_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '30','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -1749,7 +1751,7 @@
                                'loc2' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc3' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
                                'loc4' => array('type' => 'varchar','precision' 
=> '4','nullable' => True),
-                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => True),
+                               'address' => array('type' => 
'varchar','precision' => '150','nullable' => True),
                                'tenant_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'contact_phone' => array('type' => 
'varchar','precision' => '30','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => True),
@@ -1819,7 +1821,7 @@
                                'termination_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)
+                               'account_id' => array('type' => 'varchar', 
'precision' => 20,'nullable' => True)
                        ),
                        'pk' => array('id'),
                        'fk' => array(),
@@ -1881,7 +1883,7 @@
                                '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' => True),
-                               'address' => array('type' => 'varchar', 
'precision' => 100,'nullable' => True),
+                               'address' => array('type' => 'varchar', 
'precision' => 150,'nullable' => True),
                                'p_num' => array('type' => 'varchar', 
'precision' => 15,'nullable' => True),
                                'p_entity_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True,'default' => '0'),
                                'p_cat_id' => array('type' => 'int', 
'precision' => 4,'nullable' => True,'default' => '0'),
@@ -1908,7 +1910,7 @@
                                '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),
+                               'index_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)
                        ),
@@ -1928,5 +1930,18 @@
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
+               ),
+               'fm_cron_log' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
+                               'cron' => array('type' => 'int','precision' => 
'2','nullable' => True),
+                               'cron_date' => array('type' => 
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+                               'process' => array('type' => 
'varchar','precision' => '255','nullable' => False),
+                               'message' => array('type' => 'text','nullable' 
=> True)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
                )
        );

====================================================
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.2 
property/setup/tables_update.inc.php:1.3
--- property/setup/tables_update.inc.php:1.2    Wed Jun  2 18:42:33 2004
+++ property/setup/tables_update.inc.php        Fri Jan 14 08:50:50 2005
@@ -1,22 +1,33 @@
 <?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.                                           
   *
-       
\**************************************************************************/
-       /* $Id$ */
+       /**
+       * phpGroupWare - property
+       * address@hidden http://www.phpgroupware.org}
+       *
+       * Property: a Facilities Management System.
+       *
+       * Copyright 2000 - 2003 Free Software Foundation, Inc
+       * This program is part of the GNU project, see address@hidden 
http://www.gnu.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.
+       *
+       * To contact the author write to address@hidden mailto:address@hidden 
Sigurd Nes}
+       * @author Sigurd Nes
+       * @package property
+       * @subpackage setup
+       * @version $Id$
+       */
+
+       /**
+       * Update property version from 0.9.15.001 to 0.9.15.002
+       */

-       /* Include older phpGroupWare update support */
        $test[] = '0.9.15.001';
        function property_upgrade0_9_15_001()
        {
-               
$GLOBALS['phpgw_setup']->oProc->RenameColumn('fm_entity_1_1','attribute7','attribute8');
-
                $GLOBALS['setup_info']['property']['currentver'] = '0.9.15.002';
-               return $GLOBALS['setup_info']['projects']['currentver'];
+               return $GLOBALS['setup_info']['property']['currentver'];
        }
 ?>






reply via email to

[Prev in Thread] Current Thread [Next in Thread]