Author: david
Date: Wed Jul 4 13:31:40 2012
New Revision: 11847
Log:
Revert r11837. Use VARCHAR(1024) instead of TEXT for performance reasons (TEXT
cannot read from memory when using temp tables). Update migration script to
match.
Modified:
trunk/config/schema.yml
trunk/data/sql/lib.model.schema.sql
trunk/lib/task/migrate/arUpgrader120.class.php
Modified: trunk/config/schema.yml
==============================================================================
--- trunk/config/schema.yml Wed Jul 4 12:55:20 2012 (r11846)
+++ trunk/config/schema.yml Wed Jul 4 13:31:40 2012 (r11847)
@@ -2,19 +2,19 @@
actor:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
- corporate_body_identifiers: longvarchar
+ corporate_body_identifiers: varchar(1024)
entity_type_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
description_status_id: { type: integer, foreignTable: term,
foreignReference: id, onDelete: setnull }
description_detail_id: { type: integer, foreignTable: term,
foreignReference: id, onDelete: setnull }
- description_identifier: longvarchar
- source_standard: longvarchar
+ description_identifier: varchar(1024)
+ source_standard: varchar(1024)
parent_id: { type: integer, foreignTable: actor, foreignReference: id }
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
actor_i18n:
- authorized_form_of_name: longvarchar
- dates_of_existence: longvarchar
+ authorized_form_of_name: varchar(1024)
+ dates_of_existence: varchar(1024)
history: longvarchar
places: longvarchar
legal_status: longvarchar
@@ -22,7 +22,7 @@
mandates: longvarchar
internal_structures: longvarchar
general_context: longvarchar
- institution_responsible_identifier: longvarchar
+ institution_responsible_identifier: varchar(1024)
rules: longvarchar
sources: longvarchar
revision_history: longvarchar
@@ -30,9 +30,9 @@
contact_information:
actor_id: { type: integer, required: true, foreignTable: actor,
foreignReference: id, onDelete: cascade }
primary_contact: boolean
- contact_person: longvarchar
+ contact_person: varchar(1024)
street_address: longvarchar
- website: longvarchar
+ website: varchar(1024)
email: varchar(255)
telephone: varchar(255)
fax: varchar(255)
@@ -44,23 +44,23 @@
updated_at:
contact_information_i18n:
- contact_type: longvarchar
- city: longvarchar
- region: longvarchar
+ contact_type: varchar(1024)
+ city: varchar(1024)
+ region: varchar(1024)
note: longvarchar
digital_object:
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(255)
+ mime_type: { type: varchar(50) }
media_type_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
- name: { type: longvarchar, required: true }
- path: { type: longvarchar, required: true }
+ name: varchar(1024) not null
+ path: varchar(1000) not null
sequence: integer
byte_size: integer
checksum: varchar(255)
- checksum_type: varchar(255)
+ checksum_type: { type: varchar(50) }
parent_id: { type: integer, foreignTable: digital_object,
foreignReference: id }
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
@@ -76,9 +76,9 @@
actor_id:
event_i18n:
- name: longvarchar
+ name: varchar(1024)
description: longvarchar
- date: longvarchar
+ date: varchar(1024)
function:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
@@ -86,15 +86,15 @@
parent_id: { type: integer, foreignTable: function, foreignReference: id }
description_status_id: { type: integer, foreignTable: term,
foreignReference: id }
description_detail_id: { type: integer, foreignTable: term,
foreignReference: id }
- description_identifier: longvarchar
- source_standard: longvarchar
+ description_identifier: varchar(1024)
+ source_standard: varchar(1024)
lft: integer
rgt: integer
function_i18n:
- authorized_form_of_name: longvarchar
- classification: longvarchar
- dates: longvarchar
+ authorized_form_of_name: varchar(1024)
+ classification: varchar(1024)
+ dates: varchar(1024)
description: longvarchar
history: longvarchar
legislation: longvarchar
@@ -105,7 +105,7 @@
information_object:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
- identifier: longvarchar
+ identifier: varchar(1024)
oai_local_identifier: { type: integer, index: unique, required: true,
autoIncrement: true }
level_of_description_id: { type: integer, foreignTable: term,
foreignReference: id, onDelete: setnull }
collection_type_id: { type: integer, foreignTable: term, foreignReference:
id }
@@ -113,15 +113,15 @@
parent_id: { type: integer, foreignTable: information_object,
foreignReference: id }
description_status_id: { type: integer, foreignTable: term,
foreignReference: id, onDelete: setnull }
description_detail_id: { type: integer, foreignTable: term,
foreignReference: id, onDelete: setnull }
- description_identifier: longvarchar
- source_standard: longvarchar
+ description_identifier: varchar(1024)
+ source_standard: varchar(1024)
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
information_object_i18n:
- title: longvarchar
- alternate_title: longvarchar
- edition: longvarchar
+ title: varchar(1024)
+ alternate_title: varchar(1024)
+ edition: varchar(1024)
extent_and_medium: longvarchar
archival_history: longvarchar
acquisition: longvarchar
@@ -136,7 +136,7 @@
location_of_originals: longvarchar
location_of_copies: longvarchar
related_units_of_description: longvarchar
- institution_responsible_identifier: longvarchar
+ institution_responsible_identifier: varchar(1024)
rules: longvarchar
sources: longvarchar
revision_history: longvarchar
@@ -149,21 +149,21 @@
menu:
parent_id: { type: integer, foreignTable: menu, foreignReference: id,
onDelete: cascade }
- name: longvarchar
- path: longvarchar
+ name: varchar(255)
+ path: varchar(255)
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
created_at:
updated_at:
menu_i18n:
- label: longvarchar
+ label: varchar(255)
description: longvarchar
note:
object_id: { type: integer, required: true, foreignTable: object,
foreignReference: id, onDelete: cascade }
type_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
- scope: longvarchar
+ scope: varchar(1024)
user_id:
note_i18n:
@@ -176,14 +176,14 @@
end_timestamp: timestamp
last_harvest: timestamp
last_harvest_attempt: timestamp
- metadataPrefix: longvarchar
- set: longvarchar
+ metadataPrefix: varchar(255)
+ set: varchar(1024)
created_at:
oai_repository:
id:
- name: longvarchar
- uri: longvarchar
+ name: varchar(1024)
+ uri: varchar(1024)
admin_email: varchar(255)
earliest_timestamp: timestamp
created_at:
@@ -204,12 +204,12 @@
other_name:
object_id: { type: integer, required: true, foreignTable: object,
foreignReference: id, onDelete: cascade }
type_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
- start_date: bu_date
+ start_date: bu_date
end_date: bu_date
other_name_i18n:
- name: longvarchar
- note: longvarchar
+ name: varchar(1024)
+ note: varchar(1024)
dates: longvarchar
physical_object:
@@ -220,17 +220,17 @@
rgt: { type: integer, required: true, nestedSetRightKey: true }
physical_object_i18n:
- name: longvarchar
+ name: varchar(1024)
description: longvarchar
location: longvarchar
property:
object_id: { type: integer, required: true, foreignTable: object,
foreignReference: id, onDelete: cascade }
- scope: longvarchar
- name: longvarchar
+ scope: varchar(1024)
+ name: varchar(1024)
property_i18n:
- value: longvarchar
+ value: varchar(1024)
relation:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
@@ -242,14 +242,14 @@
relation_i18n:
description: longvarchar
- date: longvarchar
+ date: varchar(1024)
repository:
id: { type: integer, required: true, primaryKey: true, foreignTable:
actor, foreignReference: id, onDelete: cascade, inheritanceKey: true }
- identifier: longvarchar
+ identifier: varchar(1024)
desc_status_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
desc_detail_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
- desc_identifier: longvarchar
+ desc_identifier: varchar(1024)
upload_limit: { type: float }
repository_i18n:
@@ -264,7 +264,7 @@
research_services: longvarchar
reproduction_services: longvarchar
public_facilities: longvarchar
- desc_institution_identifier: longvarchar
+ desc_institution_identifier: varchar(1024)
desc_rules: longvarchar
desc_sources: longvarchar
desc_revision_history: longvarchar
@@ -279,7 +279,7 @@
rights_holder_id: { type: integer, foreignTable: actor, foreignReference:
id, onDelete: setnull }
copyright_status_id: { type: integer, foreignTable: term,
foreignReference: id, onDelete: setnull }i
copyright_status_date: bu_date
- copyright_jurisdiction: longvarchar
+ copyright_jurisdiction: varchar(1024)
statute_determination_date: bu_date
rights_i18n:
@@ -296,8 +296,8 @@
id: { type: integer, required: true, primaryKey: true, foreignTable:
actor, foreignReference: id, onDelete: cascade, inheritanceKey: true }
setting:
- name: longvarchar
- scope: longvarchar
+ name: varchar(255)
+ scope: varchar(255)
editable: { type: boolean, default: false }
deleteable: { type: boolean, default: false }
@@ -312,7 +312,7 @@
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
static_page_i18n:
- title: longvarchar
+ title: varchar(1024)
content: longvarchar
status:
@@ -322,25 +322,25 @@
taxonomy:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
- usage: longvarchar
+ usage: varchar(1024)
parent_id: { type: integer, foreignTable: taxonomy, foreignReference: id }
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
taxonomy_i18n:
- name: longvarchar
+ name: varchar(1024)
note: longvarchar
term:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
taxonomy_id: { type: integer, required: true, foreignTable: taxonomy,
foreignReference: id, onDelete: cascade }
- code: longvarchar
+ code: varchar(1024)
parent_id: { type: integer, foreignTable: term, foreignReference: id }
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
term_i18n:
- name: longvarchar
+ name: varchar(1024)
user:
id: { type: integer, required: true, primaryKey: true, foreignTable:
actor, foreignReference: id, onDelete: cascade, inheritanceKey: true }
Modified: trunk/data/sql/lib.model.schema.sql
==============================================================================
--- trunk/data/sql/lib.model.schema.sql Wed Jul 4 12:55:20 2012 (r11846)
+++ trunk/data/sql/lib.model.schema.sql Wed Jul 4 13:31:40 2012 (r11847)
@@ -13,12 +13,12 @@
CREATE TABLE `actor`
(
`id` INTEGER NOT NULL,
- `corporate_body_identifiers` TEXT,
+ `corporate_body_identifiers` VARCHAR(1024),
`entity_type_id` INTEGER,
`description_status_id` INTEGER,
`description_detail_id` INTEGER,
- `description_identifier` TEXT,
- `source_standard` TEXT,
+ `description_identifier` VARCHAR(1024),
+ `source_standard` VARCHAR(1024),
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -58,8 +58,8 @@
CREATE TABLE `actor_i18n`
(
- `authorized_form_of_name` TEXT,
- `dates_of_existence` TEXT,
+ `authorized_form_of_name` VARCHAR(1024),
+ `dates_of_existence` VARCHAR(1024),
`history` TEXT,
`places` TEXT,
`legal_status` TEXT,
@@ -67,7 +67,7 @@
`mandates` TEXT,
`internal_structures` TEXT,
`general_context` TEXT,
- `institution_responsible_identifier` TEXT,
+ `institution_responsible_identifier` VARCHAR(1024),
`rules` TEXT,
`sources` TEXT,
`revision_history` TEXT,
@@ -91,9 +91,9 @@
(
`actor_id` INTEGER NOT NULL,
`primary_contact` TINYINT,
- `contact_person` TEXT,
+ `contact_person` VARCHAR(1024),
`street_address` TEXT,
- `website` TEXT,
+ `website` VARCHAR(1024),
`email` VARCHAR(255),
`telephone` VARCHAR(255),
`fax` VARCHAR(255),
@@ -123,9 +123,9 @@
CREATE TABLE `contact_information_i18n`
(
- `contact_type` TEXT,
- `city` TEXT,
- `region` TEXT,
+ `contact_type` VARCHAR(1024),
+ `city` VARCHAR(1024),
+ `region` VARCHAR(1024),
`note` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -148,14 +148,14 @@
`id` INTEGER NOT NULL,
`information_object_id` INTEGER,
`usage_id` INTEGER,
- `mime_type` VARCHAR(255),
+ `mime_type` VARCHAR(50),
`media_type_id` INTEGER,
- `name` TEXT NOT NULL,
- `path` TEXT NOT NULL,
+ `name` VARCHAR(1024),
+ `path` VARCHAR(1000),
`sequence` INTEGER,
`byte_size` INTEGER,
`checksum` VARCHAR(255),
- `checksum_type` VARCHAR(255),
+ `checksum_type` VARCHAR(50),
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -232,9 +232,9 @@
CREATE TABLE `event_i18n`
(
- `name` TEXT,
+ `name` VARCHAR(1024),
`description` TEXT,
- `date` TEXT,
+ `date` VARCHAR(1024),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`,`culture`),
@@ -258,8 +258,8 @@
`parent_id` INTEGER,
`description_status_id` INTEGER,
`description_detail_id` INTEGER,
- `description_identifier` TEXT,
- `source_standard` TEXT,
+ `description_identifier` VARCHAR(1024),
+ `source_standard` VARCHAR(1024),
`lft` INTEGER,
`rgt` INTEGER,
`source_culture` VARCHAR(7) NOT NULL,
@@ -295,9 +295,9 @@
CREATE TABLE `function_i18n`
(
- `authorized_form_of_name` TEXT,
- `classification` TEXT,
- `dates` TEXT,
+ `authorized_form_of_name` VARCHAR(1024),
+ `classification` VARCHAR(1024),
+ `dates` VARCHAR(1024),
`description` TEXT,
`history` TEXT,
`legislation` TEXT,
@@ -324,7 +324,7 @@
CREATE TABLE `information_object`
(
`id` INTEGER NOT NULL,
- `identifier` TEXT,
+ `identifier` VARCHAR(1024),
`oai_local_identifier` INTEGER NOT NULL AUTO_INCREMENT,
`level_of_description_id` INTEGER,
`collection_type_id` INTEGER,
@@ -332,8 +332,8 @@
`parent_id` INTEGER,
`description_status_id` INTEGER,
`description_detail_id` INTEGER,
- `description_identifier` TEXT,
- `source_standard` TEXT,
+ `description_identifier` VARCHAR(1024),
+ `source_standard` VARCHAR(1024),
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
@@ -381,9 +381,9 @@
CREATE TABLE `information_object_i18n`
(
- `title` TEXT,
- `alternate_title` TEXT,
- `edition` TEXT,
+ `title` VARCHAR(1024),
+ `alternate_title` VARCHAR(1024),
+ `edition` VARCHAR(1024),
`extent_and_medium` TEXT,
`archival_history` TEXT,
`acquisition` TEXT,
@@ -398,7 +398,7 @@
`location_of_originals` TEXT,
`location_of_copies` TEXT,
`related_units_of_description` TEXT,
- `institution_responsible_identifier` TEXT,
+ `institution_responsible_identifier` VARCHAR(1024),
`rules` TEXT,
`sources` TEXT,
`revision_history` TEXT,
@@ -439,8 +439,8 @@
CREATE TABLE `menu`
(
`parent_id` INTEGER,
- `name` TEXT,
- `path` TEXT,
+ `name` VARCHAR(255),
+ `path` VARCHAR(255),
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
`created_at` DATETIME NOT NULL,
@@ -465,7 +465,7 @@
CREATE TABLE `menu_i18n`
(
- `label` TEXT,
+ `label` VARCHAR(255),
`description` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -487,7 +487,7 @@
(
`object_id` INTEGER NOT NULL,
`type_id` INTEGER,
- `scope` TEXT,
+ `scope` VARCHAR(1024),
`user_id` INTEGER,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
@@ -543,8 +543,8 @@
`end_timestamp` DATETIME,
`last_harvest` DATETIME,
`last_harvest_attempt` DATETIME,
- `metadataPrefix` TEXT,
- `set` TEXT,
+ `metadataPrefix` VARCHAR(255),
+ `set` VARCHAR(1024),
`created_at` DATETIME NOT NULL,
`serial_number` INTEGER default 0 NOT NULL,
PRIMARY KEY (`id`),
@@ -565,8 +565,8 @@
CREATE TABLE `oai_repository`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
- `name` TEXT,
- `uri` TEXT,
+ `name` VARCHAR(1024),
+ `uri` VARCHAR(1024),
`admin_email` VARCHAR(255),
`earliest_timestamp` DATETIME,
`created_at` DATETIME NOT NULL,
@@ -661,8 +661,8 @@
CREATE TABLE `other_name_i18n`
(
- `name` TEXT,
- `note` TEXT,
+ `name` VARCHAR(1024),
+ `note` VARCHAR(1024),
`dates` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -713,7 +713,7 @@
CREATE TABLE `physical_object_i18n`
(
- `name` TEXT,
+ `name` VARCHAR(1024),
`description` TEXT,
`location` TEXT,
`id` INTEGER NOT NULL,
@@ -735,8 +735,8 @@
CREATE TABLE `property`
(
`object_id` INTEGER NOT NULL,
- `scope` TEXT,
- `name` TEXT,
+ `scope` VARCHAR(1024),
+ `name` VARCHAR(1024),
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
`serial_number` INTEGER default 0 NOT NULL,
@@ -757,7 +757,7 @@
CREATE TABLE `property_i18n`
(
- `value` TEXT,
+ `value` VARCHAR(1024),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`,`culture`),
@@ -812,7 +812,7 @@
CREATE TABLE `relation_i18n`
(
`description` TEXT,
- `date` TEXT,
+ `date` VARCHAR(1024),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`,`culture`),
@@ -832,10 +832,10 @@
CREATE TABLE `repository`
(
`id` INTEGER NOT NULL,
- `identifier` TEXT,
+ `identifier` VARCHAR(1024),
`desc_status_id` INTEGER,
`desc_detail_id` INTEGER,
- `desc_identifier` TEXT,
+ `desc_identifier` VARCHAR(1024),
`upload_limit` FLOAT,
`source_culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`),
@@ -875,7 +875,7 @@
`research_services` TEXT,
`reproduction_services` TEXT,
`public_facilities` TEXT,
- `desc_institution_identifier` TEXT,
+ `desc_institution_identifier` VARCHAR(1024),
`desc_rules` TEXT,
`desc_sources` TEXT,
`desc_revision_history` TEXT,
@@ -906,7 +906,7 @@
`rights_holder_id` INTEGER,
`copyright_status_id` INTEGER,
`copyright_status_date` DATE,
- `copyright_jurisdiction` TEXT,
+ `copyright_jurisdiction` VARCHAR(1024),
`statute_determination_date` DATE,
`source_culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`),
@@ -988,8 +988,8 @@
CREATE TABLE `setting`
(
- `name` TEXT,
- `scope` TEXT,
+ `name` VARCHAR(255),
+ `scope` VARCHAR(255),
`editable` TINYINT default 0,
`deleteable` TINYINT default 0,
`source_culture` VARCHAR(7) NOT NULL,
@@ -1066,7 +1066,7 @@
CREATE TABLE `static_page_i18n`
(
- `title` TEXT,
+ `title` VARCHAR(1024),
`content` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -1119,7 +1119,7 @@
CREATE TABLE `taxonomy`
(
`id` INTEGER NOT NULL,
- `usage` TEXT,
+ `usage` VARCHAR(1024),
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -1144,7 +1144,7 @@
CREATE TABLE `taxonomy_i18n`
(
- `name` TEXT,
+ `name` VARCHAR(1024),
`note` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -1166,7 +1166,7 @@
(
`id` INTEGER NOT NULL,
`taxonomy_id` INTEGER NOT NULL,
- `code` TEXT,
+ `code` VARCHAR(1024),
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -1196,7 +1196,7 @@
CREATE TABLE `term_i18n`
(
- `name` TEXT,
+ `name` VARCHAR(1024),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`,`culture`),
Modified: trunk/lib/task/migrate/arUpgrader120.class.php
==============================================================================
--- trunk/lib/task/migrate/arUpgrader120.class.php Wed Jul 4 12:55:20
2012 (r11846)
+++ trunk/lib/task/migrate/arUpgrader120.class.php Wed Jul 4 13:31:40
2012 (r11847)
@@ -184,14 +184,10 @@
'identifier', 'description_identifier', 'source_standard'),
'information_object_i18n' => array(
'title', 'alternate_title', 'edition',
'institution_responsible_identifier'),
- 'menu' => array(
- 'name', 'path'),
- 'menu_i18n' => array(
- 'label'),
'note' => array(
'scope'),
'oai_harvest' => array(
- 'metadataPrefix', 'set'),
+ 'set'),
'oai_repository' => array(
'name', 'uri'),
'other_name_i18n' => array(
@@ -210,8 +206,6 @@
'desc_institution_identifier'),
'rights' => array(
'copyright_jurisdiction'),
- 'setting' => array(
- 'name', 'scope'),
'static_page_i18n' => array(
'title'),
'taxonomy' => array(
@@ -229,7 +223,7 @@
{
foreach ($cols as $col)
{
- $sql = sprintf('ALTER TABLE %s MODIFY `%s` TEXT;', $tablename,
$col);
+ $sql = sprintf('ALTER TABLE %s MODIFY `%s` VARCHAR(1024);',
$tablename, $col);
QubitPdo::modify($sql);
}
}
@@ -245,7 +239,7 @@
foreach ($cols as $col)
{
var_dump($tablename, $col);
- $sql = sprintf('ALTER TABLE %s MODIFY %s TEXT NOT NULL;',
$tablename, $col);
+ $sql = sprintf('ALTER TABLE %s MODIFY %s VARCHAR(1024) NOT NULL;',
$tablename, $col);
QubitPdo::modify($sql);
}
}
--
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.
