[Phpgroupware-cvs] phpgwapi/inc class.schema_proc_pgsql.inc.php [Version-0_9_16-branch]

[Sigurd Nes]

CVSROOT:        /sources/phpgwapi
Module name:    phpgwapi
Branch:         Version-0_9_16-branch
Changes by:     Sigurd Nes <address@hidden>     06/03/14 07:42:18

Modified files:
        inc            : class.schema_proc_pgsql.inc.php 

Log message:
        Add 'CASCADE' to the drop statement of tables and sequenses.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/phpgwapi/inc/class.schema_proc_pgsql.inc.php.diff?only_with_tag=Version-0_9_16-branch&tr1=1.5.2.12&tr2=1.5.2.13&r1=text&r2=text

Patches:
Index: phpgwapi/inc/class.schema_proc_pgsql.inc.php
diff -u phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.5.2.12 
phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.5.2.13
--- phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.5.2.12       Sat Nov  6 
15:34:26 2004
+++ phpgwapi/inc/class.schema_proc_pgsql.inc.php        Tue Mar 14 07:42:18 2006
@@ -12,7 +12,7 @@
        * @license http://www.fsf.org/licenses/gpl.html GNU General Public 
License
        * @package phpgwapi
        * @subpackage database
-       * @version $Id: class.schema_proc_pgsql.inc.php,v 1.5.2.12 2004/11/06 
15:34:26 powerstat Exp $
+       * @version $Id: class.schema_proc_pgsql.inc.php,v 1.5.2.13 2006/03/14 
07:42:18 sigurdne Exp $
        * @link http://www.greatbridge.org/project/phppgadmin
        * @internal SQL for table properties taken from phpPgAdmin Version 2.2.1
        */
@@ -465,7 +465,7 @@
                        
$this->GetSequenceForTable($oProc,$table,$sSequenceName);
                        if ($sSequenceName)
                        {
-                               $oProc->m_odb->query("DROP SEQUENCE " . 
$sSequenceName,__LINE__,__FILE__);
+                               $oProc->m_odb->query("DROP SEQUENCE " . 
$sSequenceName . " CASCADE",__LINE__,__FILE__);
                        }
                        return True;
                }
@@ -474,7 +474,7 @@
                {
                        $this->DropSequenceForTable($oProc,$sTableName);
 
-                       return $oProc->m_odb->query("DROP TABLE " . 
$sTableName) &&
+                       return $oProc->m_odb->query("DROP TABLE " . $sTableName 
. " CASCADE") &&
                               $this->DropSequenceForTable($oProc, $sTableName);
                }