Author: david
Date: Wed Aug 1 15:03:05 2012
New Revision: 12026
Log:
Increase width of property_i18n.value field to allow storing entire text of PDF
documents. Add upgrade script. Refs issue 1252.
Modified:
trunk/config/schema.yml
trunk/data/fixtures/settings.yml
trunk/data/sql/lib.model.schema.sql
trunk/lib/model/map/ObjectTableMap.php
trunk/lib/model/map/PropertyI18nTableMap.php
trunk/lib/task/migrate/arUpgrader120.class.php
Modified: trunk/config/schema.yml
==============================================================================
--- trunk/config/schema.yml Wed Aug 1 12:45:31 2012 (r12025)
+++ trunk/config/schema.yml Wed Aug 1 15:03:05 2012 (r12026)
@@ -230,7 +230,7 @@
name: varchar(1024)
property_i18n:
- value: varchar(1024)
+ value: longvarchar
relation:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
Modified: trunk/data/fixtures/settings.yml
==============================================================================
--- trunk/data/fixtures/settings.yml Wed Aug 1 12:45:31 2012 (r12025)
+++ trunk/data/fixtures/settings.yml Wed Aug 1 15:03:05 2012 (r12026)
@@ -3,7 +3,7 @@
name: version
editable: 0
deleteable: 0
- value: 90
+ value: 91
QubitSetting_2:
name: upload_dir
editable: 0
Modified: trunk/data/sql/lib.model.schema.sql
==============================================================================
--- trunk/data/sql/lib.model.schema.sql Wed Aug 1 12:45:31 2012 (r12025)
+++ trunk/data/sql/lib.model.schema.sql Wed Aug 1 15:03:05 2012 (r12026)
@@ -757,7 +757,7 @@
CREATE TABLE `property_i18n`
(
- `value` VARCHAR(1024),
+ `value` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`,`culture`),
Modified: trunk/lib/model/map/ObjectTableMap.php
==============================================================================
--- trunk/lib/model/map/ObjectTableMap.php Wed Aug 1 12:45:31 2012
(r12025)
+++ trunk/lib/model/map/ObjectTableMap.php Wed Aug 1 15:03:05 2012
(r12026)
@@ -49,9 +49,9 @@
*/
public function buildRelations()
{
+ $this->addRelation('aclPermission', 'aclPermission',
RelationMap::ONE_TO_MANY, array('id' => 'object_id', ), 'CASCADE', null);
$this->addRelation('accession', 'accession', RelationMap::ONE_TO_ONE,
array('id' => 'id', ), 'CASCADE', null);
$this->addRelation('deaccession', 'deaccession', RelationMap::ONE_TO_ONE,
array('id' => 'id', ), 'CASCADE', null);
- $this->addRelation('aclPermission', 'aclPermission',
RelationMap::ONE_TO_MANY, array('id' => 'object_id', ), 'CASCADE', null);
$this->addRelation('actor', 'actor', RelationMap::ONE_TO_ONE, array('id'
=> 'id', ), 'CASCADE', null);
$this->addRelation('digitalObject', 'digitalObject',
RelationMap::ONE_TO_ONE, array('id' => 'id', ), 'CASCADE', null);
$this->addRelation('event', 'event', RelationMap::ONE_TO_ONE, array('id'
=> 'id', ), 'CASCADE', null);
Modified: trunk/lib/model/map/PropertyI18nTableMap.php
==============================================================================
--- trunk/lib/model/map/PropertyI18nTableMap.php Wed Aug 1 12:45:31
2012 (r12025)
+++ trunk/lib/model/map/PropertyI18nTableMap.php Wed Aug 1 15:03:05
2012 (r12026)
@@ -36,7 +36,7 @@
$this->setPackage('lib.model');
$this->setUseIdGenerator(false);
// columns
- $this->addColumn('VALUE', 'value', 'VARCHAR', false, 1024,
null);
+ $this->addColumn('VALUE', 'value', 'LONGVARCHAR', false, null,
null);
$this->addForeignPrimaryKey('ID', 'id', 'INTEGER' , 'property',
'ID', true, null, null);
$this->addPrimaryKey('CULTURE', 'culture', 'VARCHAR', true, 7,
null);
// validators
Modified: trunk/lib/task/migrate/arUpgrader120.class.php
==============================================================================
--- trunk/lib/task/migrate/arUpgrader120.class.php Wed Aug 1 12:45:31
2012 (r12025)
+++ trunk/lib/task/migrate/arUpgrader120.class.php Wed Aug 1 15:03:05
2012 (r12026)
@@ -410,6 +410,12 @@
break;
+ case 90:
+ $sql = 'ALTER TABLE `property_i18n` MODIFY `value` TEXT;';
+ QubitPdo::modify($sql);
+
+ break;
+
// Return false if no upgrade available
default:
--
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.
