[Phpgroupware-cvs] property/setup setup.inc.php tables_update.inc....

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/03/02 12:46:10

Modified files:
        setup          : setup.inc.php tables_update.inc.php 
                         tables_current.inc.php default_records.inc.php 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/setup.inc.php.diff?tr1=1.31&tr2=1.32&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/tables_update.inc.php.diff?tr1=1.31&tr2=1.32&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/tables_current.inc.php.diff?tr1=1.48&tr2=1.49&r1=text&r2=text
http://cvs.savannah.gnu.org/viewcvs/phpgroupware/property/setup/default_records.inc.php.diff?tr1=1.22&tr2=1.23&r1=text&r2=text

Patches:
Index: property/setup/default_records.inc.php
diff -u property/setup/default_records.inc.php:1.22 
property/setup/default_records.inc.php:1.23
--- property/setup/default_records.inc.php:1.22 Thu Mar  2 06:39:15 2006
+++ property/setup/default_records.inc.php      Thu Mar  2 12:46:10 2006
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: default_records.inc.php,v 1.22 2006/03/02 06:39:15 
sigurdne Exp $
+       * @version $Id: default_records.inc.php,v 1.23 2006/03/02 12:46:10 
sigurdne Exp $
        */
 
 
@@ -58,6 +58,17 @@
 
 $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_owner (id, abid, 
org_name, category) VALUES (1, 1, 'demo-owner 1',1)");
 
+
+
+#
+#fm_owner_attribute
+#
+
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_owner_attribute (id, 
list, column_name, input_text, statustext, size, datatype, attrib_sort, 
precision_, scale, default_value, nullable, search) VALUES (1, 1, 'abid', 
'Contact', 'Contakt person', NULL, 'AB', 1, 4, NULL, NULL, 'True', NULL)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_owner_attribute (id, 
list, column_name, input_text, statustext, size, datatype, attrib_sort, 
precision_, scale, default_value, nullable, search) VALUES (2, 1, 'org_name', 
'Name', 'The name of the owner', NULL, 'V', 2, 50, NULL, NULL, 'True', 1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_owner_attribute (id, 
list, column_name, input_text, statustext, size, datatype, attrib_sort, 
precision_, scale, default_value, nullable, search) VALUES (3, 1, 'remark', 
'remark', 'remark', NULL, 'T', 3, NULL, NULL, NULL, 'True', NULL)");
+
+
 #
 #fm_location1
 #
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.31 property/setup/setup.inc.php:1.32
--- property/setup/setup.inc.php:1.31   Tue Feb 28 13:29:12 2006
+++ property/setup/setup.inc.php        Thu Mar  2 12:46:10 2006
@@ -8,12 +8,12 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: setup.inc.php,v 1.31 2006/02/28 13:29:12 sigurdne Exp $
+       * @version $Id: setup.inc.php,v 1.32 2006/03/02 12:46:10 sigurdne Exp $
        */
 
        $setup_info['property']['name']      = 'property';
        $setup_info['property']['title']         = 'Property';
-       $setup_info['property']['version']   = '0.9.17.514';
+       $setup_info['property']['version']   = '0.9.17.515';
        $setup_info['property']['app_order'] = 8;
        $setup_info['property']['enable']    = 1;
 
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.48 
property/setup/tables_current.inc.php:1.49
--- property/setup/tables_current.inc.php:1.48  Tue Feb 28 13:29:12 2006
+++ property/setup/tables_current.inc.php       Thu Mar  2 12:46:10 2006
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: tables_current.inc.php,v 1.48 2006/02/28 13:29:12 
sigurdne Exp $
+       * @version $Id: tables_current.inc.php,v 1.49 2006/03/02 12:46:10 
sigurdne Exp $
        */
 
        $phpgw_baseline = array(
@@ -1459,7 +1459,7 @@
                'fm_owner' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
-                               'abid' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'abid' => array('type' => 'int','precision' => 
'4','nullable' => True),
                                '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),
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.31 
property/setup/tables_update.inc.php:1.32
--- property/setup/tables_update.inc.php:1.31   Tue Feb 28 13:29:12 2006
+++ property/setup/tables_update.inc.php        Thu Mar  2 12:46:10 2006
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage setup
-       * @version $Id: tables_update.inc.php,v 1.31 2006/02/28 13:29:12 
sigurdne Exp $
+       * @version $Id: tables_update.inc.php,v 1.32 2006/03/02 12:46:10 
sigurdne Exp $
        */
 
        /**
@@ -1049,3 +1049,20 @@
                return $GLOBALS['setup_info']['property']['currentver'];
        }
 
+       /**
+       * Update property version from 0.9.17.514 to 0.9.17.515
+       */
+
+       $test[] = '0.9.17.514';
+       function property_upgrade0_9_17_514()
+       {
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
fm_owner_attribute (id, list, column_name, input_text, statustext, size, 
datatype, attrib_sort, precision_, scale, default_value, nullable, search) 
VALUES (1, 1, 'abid', 'Contact', 'Contakt person', NULL, 'AB', 1, 4, NULL, 
NULL, 'True', NULL)");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
fm_owner_attribute (id, list, column_name, input_text, statustext, size, 
datatype, attrib_sort, precision_, scale, default_value, nullable, search) 
VALUES (2, 1, 'org_name', 'Name', 'The name of the owner', NULL, 'V', 2, 50, 
NULL, NULL, 'True', 1)");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
fm_owner_attribute (id, list, column_name, input_text, statustext, size, 
datatype, attrib_sort, precision_, scale, default_value, nullable, search) 
VALUES (3, 1, 'remark', 'remark', 'remark', NULL, 'T', 3, NULL, NULL, NULL, 
'True', NULL)");
+
+               $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.515';
+               return $GLOBALS['setup_info']['property']['currentver'];
+       }
+
+
+