Author: david
Date: Wed Jul  4 13:49:11 2012
New Revision: 11849

Log:
Increase width of digital_object.mime_type to 255 chars.  Add data migration.  
Fix version number (off by one error)

Modified:
   trunk/config/schema.yml
   trunk/data/fixtures/settings.yml
   trunk/lib/task/migrate/arUpgrader120.class.php

Modified: trunk/config/schema.yml
==============================================================================
--- trunk/config/schema.yml     Wed Jul  4 13:36:46 2012        (r11848)
+++ trunk/config/schema.yml     Wed Jul  4 13:49:11 2012        (r11849)
@@ -53,7 +53,7 @@
     id: { type: integer, required: true, primaryKey: true, foreignTable: 
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
     information_object_id:
     usage_id: { type: integer, foreignTable: term, foreignReference: id, 
onDelete: setnull }
-    mime_type: varchar(50)
+    mime_type: varchar(255)
     media_type_id: { type: integer, foreignTable: term, foreignReference: id, 
onDelete: setnull }
     name: { type: varchar(1024), required: true }
     path: { type: varchar(1024), required: true }

Modified: trunk/data/fixtures/settings.yml
==============================================================================
--- trunk/data/fixtures/settings.yml    Wed Jul  4 13:36:46 2012        (r11848)
+++ trunk/data/fixtures/settings.yml    Wed Jul  4 13:49:11 2012        (r11849)
@@ -3,7 +3,7 @@
     name: version
     editable: 0
     deleteable: 0
-    value: 82
+    value: 84
   QubitSetting_2:
     name: upload_dir
     editable: 0

Modified: trunk/lib/task/migrate/arUpgrader120.class.php
==============================================================================
--- trunk/lib/task/migrate/arUpgrader120.class.php      Wed Jul  4 13:36:46 
2012        (r11848)
+++ trunk/lib/task/migrate/arUpgrader120.class.php      Wed Jul  4 13:49:11 
2012        (r11849)
@@ -238,7 +238,6 @@
         {
           foreach ($cols as $col)
           {
-            var_dump($tablename, $col);
             $sql = sprintf('ALTER TABLE %s MODIFY %s VARCHAR(1024) NOT NULL;', 
$tablename, $col);
             QubitPdo::modify($sql);
           }
@@ -246,8 +245,15 @@
 
         break;
 
+      // Increase width of digital_object.mime_type to 255 chars
+      case 83:
+        $sql = 'ALTER TABLE digital_object MODIFY `mime_type` VARCHAR(255);';
+        QubitPdo::modify($sql);
+
+        break;
+
       // TODO Add refId column to terms table???
-      case 82:
+      case 84:
         // $sql = sprintf('ALTER TABLE %s ADD COLUMN ref_id varchar(255);', 
QubitTaxonomy::TABLE_NAME);
         // $sql = sprintf('ALTER TABLE %s ADD COLUMN ref_id varchar(255);', 
QubitTerm::TABLE_NAME);
         return false;

-- 
You received this message because you are subscribed to the Google Groups 
"Qubit Toolkit Commits" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/qubit-commits?hl=en.

Reply via email to