Author: david
Date: Mon Jul 2 11:24:47 2012
New Revision: 11837
Log:
Use fields for all free text strings. Refs issue 1628.
Modified:
trunk/config/schema.yml
trunk/data/sql/lib.model.schema.sql
Modified: trunk/config/schema.yml
==============================================================================
--- trunk/config/schema.yml Mon Jul 2 00:03:01 2012 (r11836)
+++ trunk/config/schema.yml Mon Jul 2 11:24:47 2012 (r11837)
@@ -2,19 +2,19 @@
actor:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
- corporate_body_identifiers: varchar(255)
+ corporate_body_identifiers: longvarchar
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: varchar(255)
- source_standard: varchar(255)
+ description_identifier: longvarchar
+ source_standard: longvarchar
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: varchar(255)
- dates_of_existence: varchar(255)
+ authorized_form_of_name: longvarchar
+ dates_of_existence: longvarchar
history: longvarchar
places: longvarchar
legal_status: longvarchar
@@ -22,7 +22,7 @@
mandates: longvarchar
internal_structures: longvarchar
general_context: longvarchar
- institution_responsible_identifier: varchar(255)
+ institution_responsible_identifier: longvarchar
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: varchar(255)
+ contact_person: longvarchar
street_address: longvarchar
- website: varchar(255)
+ website: longvarchar
email: varchar(255)
telephone: varchar(255)
fax: varchar(255)
@@ -44,23 +44,23 @@
updated_at:
contact_information_i18n:
- contact_type: varchar(255)
- city: varchar(255)
- region: varchar(255)
+ contact_type: longvarchar
+ city: longvarchar
+ region: longvarchar
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: { type: varchar(50) }
+ mime_type: varchar(255)
media_type_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
- name: varchar(255) not null
- path: varchar(1000) not null
+ name: { type: longvarchar, required: true }
+ path: { type: longvarchar, required: true }
sequence: integer
byte_size: integer
checksum: varchar(255)
- checksum_type: { type: varchar(50) }
+ checksum_type: varchar(255)
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: varchar(255)
+ name: longvarchar
description: longvarchar
- date: varchar(255)
+ date: longvarchar
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: varchar(255)
- source_standard: varchar(255)
+ description_identifier: longvarchar
+ source_standard: longvarchar
lft: integer
rgt: integer
function_i18n:
- authorized_form_of_name: varchar(255)
- classification: varchar(255)
- dates: varchar(255)
+ authorized_form_of_name: longvarchar
+ classification: longvarchar
+ dates: longvarchar
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: varchar(255)
+ identifier: longvarchar
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: varchar(255)
- source_standard: varchar(255)
+ description_identifier: longvarchar
+ source_standard: longvarchar
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
information_object_i18n:
- title: varchar(255)
- alternate_title: varchar(255)
- edition: varchar(255)
+ title: longvarchar
+ alternate_title: longvarchar
+ edition: longvarchar
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: varchar(255)
+ institution_responsible_identifier: longvarchar
rules: longvarchar
sources: longvarchar
revision_history: longvarchar
@@ -149,21 +149,21 @@
menu:
parent_id: { type: integer, foreignTable: menu, foreignReference: id,
onDelete: cascade }
- name: varchar(255)
- path: varchar(255)
+ name: longvarchar
+ path: longvarchar
lft: { type: integer, required: true, nestedSetLeftKey: true }
rgt: { type: integer, required: true, nestedSetRightKey: true }
created_at:
updated_at:
menu_i18n:
- label: varchar(255)
+ label: longvarchar
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: varchar(255)
+ scope: longvarchar
user_id:
note_i18n:
@@ -176,14 +176,14 @@
end_timestamp: timestamp
last_harvest: timestamp
last_harvest_attempt: timestamp
- metadataPrefix: varchar(255)
- set: varchar(255)
+ metadataPrefix: longvarchar
+ set: longvarchar
created_at:
oai_repository:
id:
- name: varchar(512)
- uri: varchar(255)
+ name: longvarchar
+ uri: longvarchar
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: varchar(255)
- note: varchar(255)
+ name: longvarchar
+ note: longvarchar
dates: longvarchar
physical_object:
@@ -220,17 +220,17 @@
rgt: { type: integer, required: true, nestedSetRightKey: true }
physical_object_i18n:
- name: varchar(255)
+ name: longvarchar
description: longvarchar
location: longvarchar
property:
object_id: { type: integer, required: true, foreignTable: object,
foreignReference: id, onDelete: cascade }
- scope: varchar(255)
- name: varchar(255)
+ scope: longvarchar
+ name: longvarchar
property_i18n:
- value: varchar(255)
+ value: longvarchar
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: varchar(255)
+ date: longvarchar
repository:
id: { type: integer, required: true, primaryKey: true, foreignTable:
actor, foreignReference: id, onDelete: cascade, inheritanceKey: true }
- identifier: varchar(255)
+ identifier: longvarchar
desc_status_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
desc_detail_id: { type: integer, foreignTable: term, foreignReference: id,
onDelete: setnull }
- desc_identifier: varchar(255)
+ desc_identifier: longvarchar
upload_limit: { type: float }
repository_i18n:
@@ -264,7 +264,7 @@
research_services: longvarchar
reproduction_services: longvarchar
public_facilities: longvarchar
- desc_institution_identifier: varchar(255)
+ desc_institution_identifier: longvarchar
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: varchar(255)
+ copyright_jurisdiction: longvarchar
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: varchar(255)
- scope: varchar(255)
+ name: longvarchar
+ scope: longvarchar
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: varchar(255)
+ title: longvarchar
content: longvarchar
status:
@@ -322,25 +322,25 @@
taxonomy:
id: { type: integer, required: true, primaryKey: true, foreignTable:
object, foreignReference: id, onDelete: cascade, inheritanceKey: true }
- usage: varchar(255)
+ usage: longvarchar
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: varchar(255)
+ name: longvarchar
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: varchar(255)
+ code: longvarchar
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: varchar(255)
+ name: longvarchar
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 Mon Jul 2 00:03:01 2012 (r11836)
+++ trunk/data/sql/lib.model.schema.sql Mon Jul 2 11:24:47 2012 (r11837)
@@ -13,12 +13,12 @@
CREATE TABLE `actor`
(
`id` INTEGER NOT NULL,
- `corporate_body_identifiers` VARCHAR(255),
+ `corporate_body_identifiers` TEXT,
`entity_type_id` INTEGER,
`description_status_id` INTEGER,
`description_detail_id` INTEGER,
- `description_identifier` VARCHAR(255),
- `source_standard` VARCHAR(255),
+ `description_identifier` TEXT,
+ `source_standard` TEXT,
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -58,8 +58,8 @@
CREATE TABLE `actor_i18n`
(
- `authorized_form_of_name` VARCHAR(255),
- `dates_of_existence` VARCHAR(255),
+ `authorized_form_of_name` TEXT,
+ `dates_of_existence` TEXT,
`history` TEXT,
`places` TEXT,
`legal_status` TEXT,
@@ -67,7 +67,7 @@
`mandates` TEXT,
`internal_structures` TEXT,
`general_context` TEXT,
- `institution_responsible_identifier` VARCHAR(255),
+ `institution_responsible_identifier` TEXT,
`rules` TEXT,
`sources` TEXT,
`revision_history` TEXT,
@@ -91,9 +91,9 @@
(
`actor_id` INTEGER NOT NULL,
`primary_contact` TINYINT,
- `contact_person` VARCHAR(255),
+ `contact_person` TEXT,
`street_address` TEXT,
- `website` VARCHAR(255),
+ `website` TEXT,
`email` VARCHAR(255),
`telephone` VARCHAR(255),
`fax` VARCHAR(255),
@@ -123,9 +123,9 @@
CREATE TABLE `contact_information_i18n`
(
- `contact_type` VARCHAR(255),
- `city` VARCHAR(255),
- `region` VARCHAR(255),
+ `contact_type` TEXT,
+ `city` TEXT,
+ `region` TEXT,
`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(50),
+ `mime_type` VARCHAR(255),
`media_type_id` INTEGER,
- `name` VARCHAR(255),
- `path` VARCHAR(1000),
+ `name` TEXT NOT NULL,
+ `path` TEXT NOT NULL,
`sequence` INTEGER,
`byte_size` INTEGER,
`checksum` VARCHAR(255),
- `checksum_type` VARCHAR(50),
+ `checksum_type` VARCHAR(255),
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -232,9 +232,9 @@
CREATE TABLE `event_i18n`
(
- `name` VARCHAR(255),
+ `name` TEXT,
`description` TEXT,
- `date` VARCHAR(255),
+ `date` TEXT,
`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` VARCHAR(255),
- `source_standard` VARCHAR(255),
+ `description_identifier` TEXT,
+ `source_standard` TEXT,
`lft` INTEGER,
`rgt` INTEGER,
`source_culture` VARCHAR(7) NOT NULL,
@@ -295,9 +295,9 @@
CREATE TABLE `function_i18n`
(
- `authorized_form_of_name` VARCHAR(255),
- `classification` VARCHAR(255),
- `dates` VARCHAR(255),
+ `authorized_form_of_name` TEXT,
+ `classification` TEXT,
+ `dates` TEXT,
`description` TEXT,
`history` TEXT,
`legislation` TEXT,
@@ -324,7 +324,7 @@
CREATE TABLE `information_object`
(
`id` INTEGER NOT NULL,
- `identifier` VARCHAR(255),
+ `identifier` TEXT,
`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` VARCHAR(255),
- `source_standard` VARCHAR(255),
+ `description_identifier` TEXT,
+ `source_standard` TEXT,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
@@ -381,9 +381,9 @@
CREATE TABLE `information_object_i18n`
(
- `title` VARCHAR(255),
- `alternate_title` VARCHAR(255),
- `edition` VARCHAR(255),
+ `title` TEXT,
+ `alternate_title` TEXT,
+ `edition` TEXT,
`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` VARCHAR(255),
+ `institution_responsible_identifier` TEXT,
`rules` TEXT,
`sources` TEXT,
`revision_history` TEXT,
@@ -439,8 +439,8 @@
CREATE TABLE `menu`
(
`parent_id` INTEGER,
- `name` VARCHAR(255),
- `path` VARCHAR(255),
+ `name` TEXT,
+ `path` TEXT,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
`created_at` DATETIME NOT NULL,
@@ -465,7 +465,7 @@
CREATE TABLE `menu_i18n`
(
- `label` VARCHAR(255),
+ `label` TEXT,
`description` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -487,7 +487,7 @@
(
`object_id` INTEGER NOT NULL,
`type_id` INTEGER,
- `scope` VARCHAR(255),
+ `scope` TEXT,
`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` VARCHAR(255),
- `set` VARCHAR(255),
+ `metadataPrefix` TEXT,
+ `set` TEXT,
`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` VARCHAR(512),
- `uri` VARCHAR(255),
+ `name` TEXT,
+ `uri` TEXT,
`admin_email` VARCHAR(255),
`earliest_timestamp` DATETIME,
`created_at` DATETIME NOT NULL,
@@ -661,8 +661,8 @@
CREATE TABLE `other_name_i18n`
(
- `name` VARCHAR(255),
- `note` VARCHAR(255),
+ `name` TEXT,
+ `note` TEXT,
`dates` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -713,7 +713,7 @@
CREATE TABLE `physical_object_i18n`
(
- `name` VARCHAR(255),
+ `name` TEXT,
`description` TEXT,
`location` TEXT,
`id` INTEGER NOT NULL,
@@ -735,8 +735,8 @@
CREATE TABLE `property`
(
`object_id` INTEGER NOT NULL,
- `scope` VARCHAR(255),
- `name` VARCHAR(255),
+ `scope` TEXT,
+ `name` TEXT,
`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` VARCHAR(255),
+ `value` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`,`culture`),
@@ -812,7 +812,7 @@
CREATE TABLE `relation_i18n`
(
`description` TEXT,
- `date` VARCHAR(255),
+ `date` TEXT,
`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` VARCHAR(255),
+ `identifier` TEXT,
`desc_status_id` INTEGER,
`desc_detail_id` INTEGER,
- `desc_identifier` VARCHAR(255),
+ `desc_identifier` TEXT,
`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` VARCHAR(255),
+ `desc_institution_identifier` TEXT,
`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` VARCHAR(255),
+ `copyright_jurisdiction` TEXT,
`statute_determination_date` DATE,
`source_culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`),
@@ -988,8 +988,8 @@
CREATE TABLE `setting`
(
- `name` VARCHAR(255),
- `scope` VARCHAR(255),
+ `name` TEXT,
+ `scope` TEXT,
`editable` TINYINT default 0,
`deleteable` TINYINT default 0,
`source_culture` VARCHAR(7) NOT NULL,
@@ -1066,7 +1066,7 @@
CREATE TABLE `static_page_i18n`
(
- `title` VARCHAR(255),
+ `title` TEXT,
`content` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
@@ -1119,7 +1119,7 @@
CREATE TABLE `taxonomy`
(
`id` INTEGER NOT NULL,
- `usage` VARCHAR(255),
+ `usage` TEXT,
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -1144,7 +1144,7 @@
CREATE TABLE `taxonomy_i18n`
(
- `name` VARCHAR(255),
+ `name` TEXT,
`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` VARCHAR(255),
+ `code` TEXT,
`parent_id` INTEGER,
`lft` INTEGER NOT NULL,
`rgt` INTEGER NOT NULL,
@@ -1196,7 +1196,7 @@
CREATE TABLE `term_i18n`
(
- `name` VARCHAR(255),
+ `name` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
PRIMARY KEY (`id`,`culture`),
--
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.
