UpdateDatabase.php
authorAlan Knowles <alan@roojs.com>
Wed, 14 Aug 2013 11:31:21 +0000 (19:31 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 14 Aug 2013 11:31:21 +0000 (19:31 +0800)
UpdateDatabase.php

index 0134c48..a35a9d7 100644 (file)
@@ -404,7 +404,16 @@ class Pman_Core_UpdateDatabase extends Pman
          
         $c->initEnums($ctb);
         
-        
+        $c = DB_DataObject::Factory('Companies');
+        $c->query("
+            UPDATE Companies 
+                SET
+                    comptype_id = (SELECT id FROM core_enum where etype='comptype' and name=Companies.comptype)
+                WHERE
+                    comptype_id = 0
+                  
+                  
+                  ");