[Phpgroupware-cvs] phpgwapi/inc class.schema_proc_pgsql.inc.php

[Sigurd Nes]

CVSROOT:        /sources/phpgwapi
Module name:    phpgwapi
Branch:         
Changes by:     Sigurd Nes <address@hidden>     06/03/13 14:18:31

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?tr1=1.10&tr2=1.11&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.10 
phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.11
--- phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.10   Thu Dec 30 06:47:31 2004
+++ phpgwapi/inc/class.schema_proc_pgsql.inc.php        Mon Mar 13 14:18:31 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.10 2004/12/30 
06:47:31 skwashd Exp $
+       * @version $Id: class.schema_proc_pgsql.inc.php,v 1.11 2006/03/13 
14:18:31 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);
                }