[Fmsystem-commits] [10596] property: datatype

[Sigurd Nes]

Revision: 10596
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10596
Author:   sigurdne
Date:     2012-12-14 11:42:59 +0000 (Fri, 14 Dec 2012)
Log Message:
-----------
property: datatype

Modified Paths:
--------------
    trunk/property/setup/tables_current.inc.php
    trunk/property/setup/tables_update.inc.php

Modified: trunk/property/setup/tables_current.inc.php
===================================================================
--- trunk/property/setup/tables_current.inc.php 2012-12-14 11:27:13 UTC (rev 
10595)
+++ trunk/property/setup/tables_current.inc.php 2012-12-14 11:42:59 UTC (rev 
10596)
@@ -494,7 +494,7 @@
                                'chapter_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'start_date' => array('type' => 
'int','precision' => '8','nullable' => False),
-                               'end_date' => array('type' => 'int','precision' 
=> '8','nullable' => False),
+                               'end_date' => array('type' => 'int','precision' 
=> '8','nullable' => true),
                                'coordinator' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'vendor_id' => array('type' => 
'int','precision' => '4','nullable' => True),
                                'status' => array('type' => 
'varchar','precision' => '20','nullable' => False,'default' => 'active'),
@@ -1487,7 +1487,7 @@
                                'category' => array('type' => 'int','precision' 
=> '4','nullable' => true),
                                'entry_date' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'start_date' => array('type' => 
'int','precision' => '8','nullable' => False),
-                               'end_date' => array('type' => 'int','precision' 
=> '8','nullable' => False),
+                               'end_date' => array('type' => 'int','precision' 
=> '8','nullable' => true),
                                'coordinator' => array('type' => 
'int','precision' => '4','nullable' => False),
                                'status' => array('type' => 
'varchar','precision' => '20','nullable' => False,'default' => 'active'),
                                'descr' => array('type' => 'text','nullable' => 
True),

Modified: trunk/property/setup/tables_update.inc.php
===================================================================
--- trunk/property/setup/tables_update.inc.php  2012-12-14 11:27:13 UTC (rev 
10595)
+++ trunk/property/setup/tables_update.inc.php  2012-12-14 11:42:59 UTC (rev 
10596)
@@ -6965,7 +6965,7 @@
                
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_project','end_date',array(
                        'type'          => 'int',
                        'precision'     => 8,
-                       'nullable'      => false
+                       'nullable'      => true
                        )
                );
                
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_workorder','start_date',array(
@@ -6977,7 +6977,7 @@
                
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_workorder','end_date',array(
                        'type'          => 'int',
                        'precision'     => 8,
-                       'nullable'      => false
+                       'nullable'      => true
                        )
                );
                
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_request','start_date',array(