Changeset 715

Timestamp:

01/05/10 16:08:01 (2 years ago)

Author:

brieb

Message:

• Oh dear, we forgot to explicitly set the base modules uuid. This would have caused lots of headaches in the future.

Location:

trunk/phpbms/install

Files:

• generateuuids.php (modified) (7 diffs)
• updatev0.98.sql (modified) (1 diff)

trunk/phpbms/install/generateuuids.php

@@ -195 +195 @@
                                   );
             $this->updateFields("invoices", $invoiceArray);
-            
+
             $clientArray = array(
                                 "taxareaid"         =>$this->taxList,
@@ -288 +288 @@
 
         $queryresult = $this->db->query($querystatement);
-        
+
         $initialClause = "";
-        
+
         $tablestatement = "
             SHOW FIELDS FROM
@@ -299 +299 @@
                 `field` = 'modifieddate'
         ";
-        
+
         $tableresult = $this->db->query($tablestatement);
 
@@ -305 +305 @@
         while($tablerecord = $this->db->fetchArray($tableresult))
             switch($tablerecord["Field"]){
-                
+
                 case "modifieddate":
                 case "stamp":
                     $initialClause .= ", `".$tablerecord["Field"]."` = `".$tablerecord["Field"]."`";
                     break;
-                
+
                 default:
                     break;
             }//end switch
-            
+
         while($therecord = $this->db->fetchArray($queryresult)){
 
@@ -323 +323 @@
                 if(strpos($therecord[$key],":") === false)
                     $updateClause .= ", `".$key."` = '".$value[$therecord[$key]]."'";
-            
+
             if($updateClause){
 
@@ -336 +336 @@
                         `id` = ".$therecord["id"]."
                 ";
-                
+
                 $this->db->query($updatestatement);
 
@@ -348 +348 @@
     /**
       *  function creatUUIDs
-      *  
+      *
       *  Gives randomly created uuids to a table with $tabledefuuid (keeping
       *  the prefix in the tabledef consistent).
-      *  
+      *
       *  @param string $tabledefuuid
       */
-    
+
     function createUUIDs($tabledefuuid){
 

trunk/phpbms/install/updatev0.98.sql

@@ -97 +97 @@
     ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`;
 --end modules ALTER--
+UPDATE `modules` SET `uuid`='mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7' WHERE `id`='1';
 --notes ALTER--
 ALTER TABLE `notes` ENGINE=INNODB;