Re: GED - first try

This is a multi-part message in MIME format.
--------------020008040002070600080905
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Maât wrote:
>> 2) When adding a file - the database complains about a Not null
>> violation in column 'url'  for the table 'ged_versions'
> url cand be null for files or directories...
> 
Ok - then I would propose this tiny patch (see attachment).

Regards

Sigurd

--------------020008040002070600080905
Content-Type: text/x-patch;
 name="ged.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="ged.diff"

diff -aburN --exclude='SVN*' --exclude=.svn ged.old/setup/setup.inc.php ged/setup/setup.inc.php
--- ged.old/setup/setup.inc.php	2010-01-10 12:40:19.894468763 +0100
+++ ged/setup/setup.inc.php	2010-01-10 12:41:20.125966559 +0100
@@ -26,7 +26,7 @@
 
 	$setup_info['ged']['name']='ged';
 	$setup_info['ged']['title']='Document Management System';
-	$setup_info['ged']['version']='0.9.18.009';
+	$setup_info['ged']['version']='0.9.18.010';
 	$setup_info['ged']['app_order']=17;
 	$setup_info['ged']['enable']=1;
 	$setup_info['calendar']['app_group']    = 'office';
diff -aburN --exclude='SVN*' --exclude=.svn ged.old/setup/tables_current.inc.php ged/setup/tables_current.inc.php
--- ged.old/setup/tables_current.inc.php	2010-01-10 12:40:19.894468763 +0100
+++ ged/setup/tables_current.inc.php	2010-01-10 12:40:50.946466222 +0100
@@ -107,7 +107,7 @@
 		),
 		'ged_versions' => array(
 			'fd' => array(
-				'url' => array('type' => 'varchar', 'precision' => 100,'nullable' => False),
+				'url' => array('type' => 'varchar', 'precision' => 100,'nullable' => True),
 				'size' => array('type' => 'int', 'precision' => 4,'nullable' => False,'default' => '0'),
 				'status' => array('type' => 'varchar', 'precision' => 100,'nullable' => False),
 				'creator_id' => array('type' => 'int', 'precision' => 4,'nullable' => False,'default' => '0'),
diff -aburN --exclude='SVN*' --exclude=.svn ged.old/setup/tables_update.inc.php ged/setup/tables_update.inc.php
--- ged.old/setup/tables_update.inc.php	2010-01-10 12:40:19.894468763 +0100
+++ ged/setup/tables_update.inc.php	2010-01-10 12:48:21.053972709 +0100
@@ -34,6 +34,7 @@
 	$test[]='0.9.18.006';
 	$test[]='0.9.18.007';
 	$test[]='0.9.18.008';	
+	$test[]='0.9.18.009';
 					
 	function ged_upgrade0_9_16_000()
 	{
@@ -525,3 +526,14 @@
 		
 	}	
 	
+	function ged_upgrade0_9_18_009()
+	{
+		$GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+		$GLOBALS['phpgw_setup']->oProc->AlterColumn('ged_versions','url',array('type' => 'varchar', 'precision' => 100,'nullable' => True));
+
+		if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+		{
+			$GLOBALS['setup_info']['ged']['currentver']='0.9.18.010';
+			return $GLOBALS['setup_info']['ged']['currentver'];			
+		}
+	}

--------------020008040002070600080905
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
phpGroupWare-developers mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers

--------------020008040002070600080905--