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

[nomail]

Update of /phpgwapi/inc
Modified Files:
        Branch: Version-0_9_16-branch
          class.schema_proc_pgsql.inc.php

date: 2004/11/06 15:34:26;  author: powerstat;  state: Exp;  lines: +11 -11

Log Message:
Bugfixes HTML; makes it a bit more W3C conform;
see patch  #3503
=====================================================================
Index: phpgwapi/inc/class.schema_proc_pgsql.inc.php
diff -u phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.5.2.11 
phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.5.2.12
--- phpgwapi/inc/class.schema_proc_pgsql.inc.php:1.5.2.11       Thu Feb 26 
20:20:35 2004
+++ phpgwapi/inc/class.schema_proc_pgsql.inc.php        Sat Nov  6 15:34:26 2004
@@ -354,7 +354,7 @@
                        $sdc->query($sql_pri_keys);
                        while ($sdc->next_record())
                        {
-                               //echo '<br> checking: ' . $sdc->f(4);
+                               //echo '<br /> checking: ' . $sdc->f(4);
                                if ($sdc->f(4) == 't')
                                {
                                        $this->pk[] = $sdc->f(2);
@@ -433,7 +433,7 @@
                function GetSequenceForTable($oProc,$table,&$sSequenceName)
                {
                        global $DEBUG;
-                       if($DEBUG) { echo '<br>GetSequenceForTable: ' . $table; 
}
+                       if($DEBUG) { echo '<br />GetSequenceForTable: ' . 
$table; }
 
                        $oProc->m_odb->query("SELECT relname FROM pg_class 
WHERE NOT relname ~ 'pg_.*' AND relname LIKE 'seq_$table' AND relkind='S' ORDER 
BY relname",__LINE__,__FILE__);
                        $oProc->m_odb->next_record();
@@ -447,7 +447,7 @@
                function GetSequenceFieldForTable($oProc,$table,&$sField)
                {
                        global $DEBUG;
-                       if($DEBUG) { echo '<br>GetSequenceFieldForTable: You 
rang?'; }
+                       if($DEBUG) { echo '<br />GetSequenceFieldForTable: You 
rang?'; }
                        $oProc->m_odb->query("SELECT a.attname FROM 
pg_attribute a, pg_class c, pg_attrdef d WHERE c.relname='$table' AND 
c.oid=d.adrelid AND d.adsrc LIKE '%seq_$table%' AND a.attrelid=c.oid AND 
d.adnum=a.attnum");
                        $oProc->m_odb->next_record();
                        if ($oProc->m_odb->f('attname'))
@@ -460,7 +460,7 @@
                function DropSequenceForTable($oProc,$table)
                {
                        global $DEBUG;
-                       if($DEBUG) { echo '<br>DropSequenceForTable: ' . 
$table; }
+                       if($DEBUG) { echo '<br />DropSequenceForTable: ' . 
$table; }
 
                        
$this->GetSequenceForTable($oProc,$table,$sSequenceName);
                        if ($sSequenceName)
@@ -508,10 +508,10 @@
                function RenameTable($oProc, &$aTables, $sOldTableName, 
$sNewTableName)
                {
                        global $DEBUG;
-                       if ($DEBUG) { echo '<br>RenameTable(): Fetching old 
sequence for: ' . $sOldTableName; }
+                       if ($DEBUG) { echo '<br />RenameTable(): Fetching old 
sequence for: ' . $sOldTableName; }
                        
$this->GetSequenceForTable($oProc,$sOldTableName,$sSequenceName);
                        if ($DEBUG) { echo ' - ' . $sSequenceName; }
-                       if ($DEBUG) { echo '<br>RenameTable(): Fetching 
sequence field for: ' . $sOldTableName; }
+                       if ($DEBUG) { echo '<br />RenameTable(): Fetching 
sequence field for: ' . $sOldTableName; }
                        
$this->GetSequenceFieldForTable($oProc,$sOldTableName,$sField);
                        if ($DEBUG) { echo ' - ' . $sField; }
 
@@ -521,7 +521,7 @@
                                $oProc->m_odb->next_record();
                                $lastval = $oProc->m_odb->f(0);
 
-                               if ($DEBUG) { echo '<br>RenameTable(): dropping 
old sequence: ' . $sSequenceName . ' used on field: ' . $sField; }
+                               if ($DEBUG) { echo '<br />RenameTable(): 
dropping old sequence: ' . $sSequenceName . ' used on field: ' . $sField; }
                                
$this->DropSequenceForTable($oProc,$sOldTableName);
 
                                if ($lastval)
@@ -529,9 +529,9 @@
                                        $lastval = ' start ' . $lastval;
                                }
                                
$this->GetSequenceSQL($sNewTableName,$sSequenceSQL);
-                               if ($DEBUG) { echo '<br>RenameTable(): Making 
new sequence using: ' . $sSequenceSQL . $lastval; }
+                               if ($DEBUG) { echo '<br />RenameTable(): Making 
new sequence using: ' . $sSequenceSQL . $lastval; }
                                $oProc->m_odb->query($sSequenceSQL . 
$lastval,__LINE__,__FILE__);
-                               if ($DEBUG) { echo '<br>RenameTable(): Altering 
column default for: ' . $sField; }
+                               if ($DEBUG) { echo '<br />RenameTable(): 
Altering column default for: ' . $sField; }
                                $oProc->m_odb->query("ALTER TABLE 
$sOldTableName ALTER $sField SET DEFAULT nextval('seq_" . $sNewTableName . 
"')",__LINE__,__FILE__);
                        }
 
@@ -657,7 +657,7 @@
                                /* create sequence first since it will be 
needed for default */
                                if ($bCreateSequence && $sSequenceSQL != '')
                                {
-                                       if ($DEBUG) { echo '<br>Making sequence 
using: ' . $sSequenceSQL; }
+                                       if ($DEBUG) { echo '<br />Making 
sequence using: ' . $sSequenceSQL; }
                                        $oProc->m_odb->query($sSequenceSQL);
                                }