danielebarchiesi@0: fetchCol(); danielebarchiesi@0: foreach ($vocabularies as $vocabulary) { danielebarchiesi@0: field_attach_delete_bundle('taxonomy_term', $vocabulary); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements hook_schema(). danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_schema() { danielebarchiesi@0: $schema['taxonomy_term_data'] = array( danielebarchiesi@0: 'description' => 'Stores term information.', danielebarchiesi@0: 'fields' => array( danielebarchiesi@0: 'tid' => array( danielebarchiesi@0: 'type' => 'serial', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'description' => 'Primary Key: Unique term ID.', danielebarchiesi@0: ), danielebarchiesi@0: 'vid' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'description' => 'The {taxonomy_vocabulary}.vid of the vocabulary to which the term is assigned.', danielebarchiesi@0: ), danielebarchiesi@0: 'name' => array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 255, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => '', danielebarchiesi@0: 'description' => 'The term name.', danielebarchiesi@0: 'translatable' => TRUE, danielebarchiesi@0: ), danielebarchiesi@0: 'description' => array( danielebarchiesi@0: 'type' => 'text', danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'size' => 'big', danielebarchiesi@0: 'description' => 'A description of the term.', danielebarchiesi@0: 'translatable' => TRUE, danielebarchiesi@0: ), danielebarchiesi@0: 'format' => array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 255, danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'description' => 'The {filter_format}.format of the description.', danielebarchiesi@0: ), danielebarchiesi@0: 'weight' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'description' => 'The weight of this term in relation to other terms.', danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'primary key' => array('tid'), danielebarchiesi@0: 'foreign keys' => array( danielebarchiesi@0: 'vocabulary' => array( danielebarchiesi@0: 'table' => 'taxonomy_vocabulary', danielebarchiesi@0: 'columns' => array('vid' => 'vid'), danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'taxonomy_tree' => array('vid', 'weight', 'name'), danielebarchiesi@0: 'vid_name' => array('vid', 'name'), danielebarchiesi@0: 'name' => array('name'), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: $schema['taxonomy_term_hierarchy'] = array( danielebarchiesi@0: 'description' => 'Stores the hierarchical relationship between terms.', danielebarchiesi@0: 'fields' => array( danielebarchiesi@0: 'tid' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'description' => 'Primary Key: The {taxonomy_term_data}.tid of the term.', danielebarchiesi@0: ), danielebarchiesi@0: 'parent' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'description' => "Primary Key: The {taxonomy_term_data}.tid of the term's parent. 0 indicates no parent.", danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'parent' => array('parent'), danielebarchiesi@0: ), danielebarchiesi@0: 'foreign keys' => array( danielebarchiesi@0: 'taxonomy_term_data' => array( danielebarchiesi@0: 'table' => 'taxonomy_term_data', danielebarchiesi@0: 'columns' => array('tid' => 'tid'), danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'primary key' => array('tid', 'parent'), danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: $schema['taxonomy_vocabulary'] = array( danielebarchiesi@0: 'description' => 'Stores vocabulary information.', danielebarchiesi@0: 'fields' => array( danielebarchiesi@0: 'vid' => array( danielebarchiesi@0: 'type' => 'serial', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'description' => 'Primary Key: Unique vocabulary ID.', danielebarchiesi@0: ), danielebarchiesi@0: 'name' => array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 255, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => '', danielebarchiesi@0: 'description' => 'Name of the vocabulary.', danielebarchiesi@0: 'translatable' => TRUE, danielebarchiesi@0: ), danielebarchiesi@0: 'machine_name' => array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 255, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => '', danielebarchiesi@0: 'description' => 'The vocabulary machine name.', danielebarchiesi@0: ), danielebarchiesi@0: 'description' => array( danielebarchiesi@0: 'type' => 'text', danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'size' => 'big', danielebarchiesi@0: 'description' => 'Description of the vocabulary.', danielebarchiesi@0: 'translatable' => TRUE, danielebarchiesi@0: ), danielebarchiesi@0: 'hierarchy' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'size' => 'tiny', danielebarchiesi@0: 'description' => 'The type of hierarchy allowed within the vocabulary. (0 = disabled, 1 = single, 2 = multiple)', danielebarchiesi@0: ), danielebarchiesi@0: 'module' => array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 255, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => '', danielebarchiesi@0: 'description' => 'The module which created the vocabulary.', danielebarchiesi@0: ), danielebarchiesi@0: 'weight' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'description' => 'The weight of this vocabulary in relation to other vocabularies.', danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'primary key' => array('vid'), danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'list' => array('weight', 'name'), danielebarchiesi@0: ), danielebarchiesi@0: 'unique keys' => array( danielebarchiesi@0: 'machine_name' => array('machine_name'), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: $schema['taxonomy_index'] = array( danielebarchiesi@0: 'description' => 'Maintains denormalized information about node/term relationships.', danielebarchiesi@0: 'fields' => array( danielebarchiesi@0: 'nid' => array( danielebarchiesi@0: 'description' => 'The {node}.nid this record tracks.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: ), danielebarchiesi@0: 'tid' => array( danielebarchiesi@0: 'description' => 'The term ID.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: ), danielebarchiesi@0: 'sticky' => array( danielebarchiesi@0: 'description' => 'Boolean indicating whether the node is sticky.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'size' => 'tiny', danielebarchiesi@0: ), danielebarchiesi@0: 'created' => array( danielebarchiesi@0: 'description' => 'The Unix timestamp when the node was created.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default'=> 0, danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'term_node' => array('tid', 'sticky', 'created'), danielebarchiesi@0: 'nid' => array('nid'), danielebarchiesi@0: ), danielebarchiesi@0: 'foreign keys' => array( danielebarchiesi@0: 'tracked_node' => array( danielebarchiesi@0: 'table' => 'node', danielebarchiesi@0: 'columns' => array('nid' => 'nid'), danielebarchiesi@0: ), danielebarchiesi@0: 'term' => array( danielebarchiesi@0: 'table' => 'taxonomy_term_data', danielebarchiesi@0: 'columns' => array('tid' => 'tid'), danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: return $schema; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements hook_field_schema(). danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_field_schema($field) { danielebarchiesi@0: return array( danielebarchiesi@0: 'columns' => array( danielebarchiesi@0: 'tid' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'tid' => array('tid'), danielebarchiesi@0: ), danielebarchiesi@0: 'foreign keys' => array( danielebarchiesi@0: 'tid' => array( danielebarchiesi@0: 'table' => 'taxonomy_term_data', danielebarchiesi@0: 'columns' => array('tid' => 'tid'), danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements hook_update_dependencies(). danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_dependencies() { danielebarchiesi@0: // taxonomy_update_7004() migrates taxonomy term data to fields and therefore danielebarchiesi@0: // must run after all Field modules have been enabled, which happens in danielebarchiesi@0: // system_update_7027(). danielebarchiesi@0: $dependencies['taxonomy'][7004] = array( danielebarchiesi@0: 'system' => 7027, danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: return $dependencies; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Utility function: get the list of vocabularies directly from the database. danielebarchiesi@0: * danielebarchiesi@0: * This function is valid for a database schema version 7002. danielebarchiesi@0: * danielebarchiesi@0: * @ingroup update_api danielebarchiesi@0: */ danielebarchiesi@0: function _update_7002_taxonomy_get_vocabularies() { danielebarchiesi@0: return db_query('SELECT v.* FROM {taxonomy_vocabulary} v ORDER BY v.weight, v.name')->fetchAllAssoc('vid', PDO::FETCH_OBJ); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Rename taxonomy tables. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7001() { danielebarchiesi@0: db_rename_table('term_data', 'taxonomy_term_data'); danielebarchiesi@0: db_rename_table('term_hierarchy', 'taxonomy_term_hierarchy'); danielebarchiesi@0: db_rename_table('term_node', 'taxonomy_term_node'); danielebarchiesi@0: db_rename_table('term_relation', 'taxonomy_term_relation'); danielebarchiesi@0: db_rename_table('term_synonym', 'taxonomy_term_synonym'); danielebarchiesi@0: db_rename_table('vocabulary', 'taxonomy_vocabulary'); danielebarchiesi@0: db_rename_table('vocabulary_node_types', 'taxonomy_vocabulary_node_type'); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Add {vocabulary}.machine_name column. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7002() { danielebarchiesi@0: $field = array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 255, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => '', danielebarchiesi@0: 'description' => 'The vocabulary machine name.', danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: db_add_field('taxonomy_vocabulary', 'machine_name', $field); danielebarchiesi@0: danielebarchiesi@0: // Do a direct query here, rather than calling taxonomy_get_vocabularies(), danielebarchiesi@0: // in case Taxonomy module is disabled. danielebarchiesi@0: $vids = db_query('SELECT vid FROM {taxonomy_vocabulary}')->fetchCol(); danielebarchiesi@0: foreach ($vids as $vid) { danielebarchiesi@0: $machine_name = 'vocabulary_' . $vid; danielebarchiesi@0: db_update('taxonomy_vocabulary') danielebarchiesi@0: ->fields(array('machine_name' => $machine_name)) danielebarchiesi@0: ->condition('vid', $vid) danielebarchiesi@0: ->execute(); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: // The machine_name unique key can only be added after we ensure the danielebarchiesi@0: // machine_name column contains unique values. danielebarchiesi@0: db_add_unique_key('taxonomy_vocabulary', 'machine_name', array('machine_name')); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Remove the related terms setting from vocabularies. danielebarchiesi@0: * danielebarchiesi@0: * This setting has not been used since Drupal 6. The {taxonomy_relations} table danielebarchiesi@0: * itself is retained to allow for data to be upgraded. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7003() { danielebarchiesi@0: db_drop_field('taxonomy_vocabulary', 'relations'); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Move taxonomy vocabulary associations for nodes to fields and field instances. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7004() { danielebarchiesi@0: $taxonomy_index = array( danielebarchiesi@0: 'description' => 'Maintains denormalized information about node/term relationships.', danielebarchiesi@0: 'fields' => array( danielebarchiesi@0: 'nid' => array( danielebarchiesi@0: 'description' => 'The {node}.nid this record tracks.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: ), danielebarchiesi@0: 'tid' => array( danielebarchiesi@0: 'description' => 'The term ID.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: ), danielebarchiesi@0: 'sticky' => array( danielebarchiesi@0: 'description' => 'Boolean indicating whether the node is sticky.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'size' => 'tiny', danielebarchiesi@0: ), danielebarchiesi@0: 'created' => array( danielebarchiesi@0: 'description' => 'The Unix timestamp when the node was created.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default'=> 0, danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'term_node' => array('tid', 'sticky', 'created'), danielebarchiesi@0: 'nid' => array('nid'), danielebarchiesi@0: ), danielebarchiesi@0: 'foreign keys' => array( danielebarchiesi@0: 'tracked_node' => array( danielebarchiesi@0: 'table' => 'node', danielebarchiesi@0: 'columns' => array('nid' => 'nid'), danielebarchiesi@0: ), danielebarchiesi@0: 'term' => array( danielebarchiesi@0: 'table' => 'taxonomy_term_data', danielebarchiesi@0: 'columns' => array('tid' => 'tid'), danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: db_create_table('taxonomy_index', $taxonomy_index); danielebarchiesi@0: danielebarchiesi@0: // Use an inline version of Drupal 6 taxonomy_get_vocabularies() here since danielebarchiesi@0: // we can no longer rely on $vocabulary->nodes from the API function. danielebarchiesi@0: $result = db_query('SELECT v.*, n.type FROM {taxonomy_vocabulary} v LEFT JOIN {taxonomy_vocabulary_node_type} n ON v.vid = n.vid ORDER BY v.weight, v.name'); danielebarchiesi@0: $vocabularies = array(); danielebarchiesi@0: foreach ($result as $record) { danielebarchiesi@0: // If no node types are associated with a vocabulary, the LEFT JOIN will danielebarchiesi@0: // return a NULL value for type. danielebarchiesi@0: if (isset($record->type)) { danielebarchiesi@0: $node_types[$record->vid][$record->type] = $record->type; danielebarchiesi@0: unset($record->type); danielebarchiesi@0: $record->nodes = $node_types[$record->vid]; danielebarchiesi@0: } danielebarchiesi@0: elseif (!isset($record->nodes)) { danielebarchiesi@0: $record->nodes = array(); danielebarchiesi@0: } danielebarchiesi@0: $vocabularies[$record->vid] = $record; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: foreach ($vocabularies as $vocabulary) { danielebarchiesi@0: $field_name = 'taxonomy_' . $vocabulary->machine_name; danielebarchiesi@0: $field = array( danielebarchiesi@0: 'field_name' => $field_name, danielebarchiesi@0: 'module' => 'taxonomy', danielebarchiesi@0: 'type' => 'taxonomy_term_reference', danielebarchiesi@0: 'cardinality' => $vocabulary->multiple || $vocabulary->tags ? FIELD_CARDINALITY_UNLIMITED : 1, danielebarchiesi@0: 'settings' => array( danielebarchiesi@0: 'required' => $vocabulary->required ? TRUE : FALSE, danielebarchiesi@0: 'allowed_values' => array( danielebarchiesi@0: array( danielebarchiesi@0: 'vocabulary' => $vocabulary->machine_name, danielebarchiesi@0: 'parent' => 0, danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: _update_7000_field_create_field($field); danielebarchiesi@0: danielebarchiesi@0: foreach ($vocabulary->nodes as $bundle) { danielebarchiesi@0: $instance = array( danielebarchiesi@0: 'label' => $vocabulary->name, danielebarchiesi@0: 'field_name' => $field_name, danielebarchiesi@0: 'bundle' => $bundle, danielebarchiesi@0: 'entity_type' => 'node', danielebarchiesi@0: 'settings' => array(), danielebarchiesi@0: 'description' => $vocabulary->help, danielebarchiesi@0: 'required' => $vocabulary->required, danielebarchiesi@0: 'widget' => array(), danielebarchiesi@0: 'display' => array( danielebarchiesi@0: 'default' => array( danielebarchiesi@0: 'type' => 'taxonomy_term_reference_link', danielebarchiesi@0: 'weight' => 10, danielebarchiesi@0: ), danielebarchiesi@0: 'teaser' => array( danielebarchiesi@0: 'type' => 'taxonomy_term_reference_link', danielebarchiesi@0: 'weight' => 10, danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: if ($vocabulary->tags) { danielebarchiesi@0: $instance['widget'] = array( danielebarchiesi@0: 'type' => 'taxonomy_autocomplete', danielebarchiesi@0: 'module' => 'taxonomy', danielebarchiesi@0: 'settings' => array( danielebarchiesi@0: 'size' => 60, danielebarchiesi@0: 'autocomplete_path' => 'taxonomy/autocomplete', danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: $instance['widget'] = array( danielebarchiesi@0: 'type' => 'select', danielebarchiesi@0: 'module' => 'options', danielebarchiesi@0: 'settings' => array(), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: _update_7000_field_create_instance($field, $instance); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: // Some contrib projects stored term node associations without regard for the danielebarchiesi@0: // selections in the taxonomy_vocabulary_node_types table, or have more terms danielebarchiesi@0: // for a single node than the vocabulary allowed. We construct the danielebarchiesi@0: // taxonomyextra field to store all the extra stuff. danielebarchiesi@0: danielebarchiesi@0: // Allowed values for this extra vocabs field is every vocabulary. danielebarchiesi@0: $allowed_values = array(); danielebarchiesi@0: foreach (_update_7002_taxonomy_get_vocabularies() as $vocabulary) { danielebarchiesi@0: $allowed_values[] = array( danielebarchiesi@0: 'vocabulary' => $vocabulary->machine_name, danielebarchiesi@0: 'parent' => 0, danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: $field_name = 'taxonomyextra'; danielebarchiesi@0: $field = array( danielebarchiesi@0: 'field_name' => $field_name, danielebarchiesi@0: 'module' => 'taxonomy', danielebarchiesi@0: 'type' => 'taxonomy_term_reference', danielebarchiesi@0: 'cardinality' => FIELD_CARDINALITY_UNLIMITED, danielebarchiesi@0: 'settings' => array( danielebarchiesi@0: 'required' => FALSE, danielebarchiesi@0: 'allowed_values' => $allowed_values, danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: _update_7000_field_create_field($field); danielebarchiesi@0: danielebarchiesi@0: foreach (_update_7000_node_get_types() as $bundle) { danielebarchiesi@0: $instance = array( danielebarchiesi@0: 'label' => 'Taxonomy upgrade extras', danielebarchiesi@0: 'field_name' => $field_name, danielebarchiesi@0: 'entity_type' => 'node', danielebarchiesi@0: 'bundle' => $bundle->type, danielebarchiesi@0: 'settings' => array(), danielebarchiesi@0: 'description' => 'Debris left over after upgrade from Drupal 6', danielebarchiesi@0: 'widget' => array( danielebarchiesi@0: 'type' => 'taxonomy_autocomplete', danielebarchiesi@0: 'module' => 'taxonomy', danielebarchiesi@0: 'settings' => array(), danielebarchiesi@0: ), danielebarchiesi@0: 'display' => array( danielebarchiesi@0: 'default' => array( danielebarchiesi@0: 'type' => 'taxonomy_term_reference_link', danielebarchiesi@0: 'weight' => 10, danielebarchiesi@0: ), danielebarchiesi@0: 'teaser' => array( danielebarchiesi@0: 'type' => 'taxonomy_term_reference_link', danielebarchiesi@0: 'weight' => 10, danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: _update_7000_field_create_instance($field, $instance); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: $fields = array('help', 'multiple', 'required', 'tags'); danielebarchiesi@0: foreach ($fields as $field) { danielebarchiesi@0: db_drop_field('taxonomy_vocabulary', $field); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Migrate {taxonomy_term_node} table to field storage. danielebarchiesi@0: * danielebarchiesi@0: * @todo: This function can possibly be made much faster by wrapping a danielebarchiesi@0: * transaction around all the inserts. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7005(&$sandbox) { danielebarchiesi@0: // $sandbox contents: danielebarchiesi@0: // - total: The total number of term_node relationships to migrate. danielebarchiesi@0: // - count: The number of term_node relationships that have been danielebarchiesi@0: // migrated so far. danielebarchiesi@0: // - last: The db_query_range() offset to use when querying danielebarchiesi@0: // term_node; this field is incremented in quantities of $batch danielebarchiesi@0: // (1000) but at the end of each call to this function, last and danielebarchiesi@0: // count are the same. danielebarchiesi@0: // - vocabularies: An associative array mapping vocabulary id and node danielebarchiesi@0: // type to field name. If a voc id/node type pair does not appear danielebarchiesi@0: // in this array but a term_node relationship exists mapping a danielebarchiesi@0: // term in voc id to node of that type, the relationship is danielebarchiesi@0: // assigned to the taxonomymyextra field which allows terms of all danielebarchiesi@0: // vocabularies. danielebarchiesi@0: // - cursor[values], cursor[deltas]: The contents of $values and danielebarchiesi@0: // $deltas at the end of the previous call to this function. These danielebarchiesi@0: // need to be preserved across calls because a single batch of danielebarchiesi@0: // 1000 rows from term_node may end in the middle of the terms for danielebarchiesi@0: // a single node revision. danielebarchiesi@0: // danielebarchiesi@0: // $values is the array of values about to be/most recently inserted danielebarchiesi@0: // into the SQL data table for the taxonomy_term_reference danielebarchiesi@0: // field. Before $values is constructed for each record, the danielebarchiesi@0: // $values from the previous insert is checked to see if the two danielebarchiesi@0: // records are for the same node revision id; this enables knowing danielebarchiesi@0: // when to reset the delta counters which are incremented across all danielebarchiesi@0: // terms for a single field on a single revision, but reset for each danielebarchiesi@0: // new field and revision. danielebarchiesi@0: // danielebarchiesi@0: // $deltas is an associative array mapping field name to the number danielebarchiesi@0: // of term references stored so far for the current revision, which danielebarchiesi@0: // provides the delta value for each term reference data insert. The danielebarchiesi@0: // deltas are reset for each new revision. danielebarchiesi@0: danielebarchiesi@0: $conditions = array( danielebarchiesi@0: 'type' => 'taxonomy_term_reference', danielebarchiesi@0: 'deleted' => 0, danielebarchiesi@0: ); danielebarchiesi@0: $field_info = _update_7000_field_read_fields($conditions, 'field_name'); danielebarchiesi@0: danielebarchiesi@0: // This is a multi-pass update. On the first call we need to initialize some danielebarchiesi@0: // variables. danielebarchiesi@0: if (!isset($sandbox['total'])) { danielebarchiesi@0: $sandbox['last'] = 0; danielebarchiesi@0: $sandbox['count'] = 0; danielebarchiesi@0: danielebarchiesi@0: // Run the same joins as the query that is used later to retrieve the danielebarchiesi@0: // term_node data, this ensures that bad records in that table - for danielebarchiesi@0: // tids which aren't in taxonomy_term_data or nids which aren't in {node} danielebarchiesi@0: // are not included in the count. danielebarchiesi@0: $sandbox['total'] = db_query('SELECT COUNT(*) FROM {taxonomy_term_data} td INNER JOIN {taxonomy_term_node} tn ON td.tid = tn.tid INNER JOIN {node} n ON tn.nid = n.nid LEFT JOIN {node} n2 ON tn.vid = n2.vid')->fetchField(); danielebarchiesi@0: danielebarchiesi@0: // Use an inline version of Drupal 6 taxonomy_get_vocabularies() here since danielebarchiesi@0: // we can no longer rely on $vocabulary->nodes from the API function. danielebarchiesi@0: $result = db_query('SELECT v.vid, v.machine_name, n.type FROM {taxonomy_vocabulary} v INNER JOIN {taxonomy_vocabulary_node_type} n ON v.vid = n.vid'); danielebarchiesi@0: $vocabularies = array(); danielebarchiesi@0: foreach ($result as $record) { danielebarchiesi@0: danielebarchiesi@0: // If no node types are associated with a vocabulary, the LEFT JOIN will danielebarchiesi@0: // return a NULL value for type. danielebarchiesi@0: if (isset($record->type)) { danielebarchiesi@0: $vocabularies[$record->vid][$record->type] = 'taxonomy_'. $record->machine_name; danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: if (!empty($vocabularies)) { danielebarchiesi@0: $sandbox['vocabularies'] = $vocabularies; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: db_create_table('taxonomy_update_7005', array( danielebarchiesi@0: 'description' => 'Stores temporary data for taxonomy_update_7005.', danielebarchiesi@0: 'fields' => array( danielebarchiesi@0: 'n' => array( danielebarchiesi@0: 'description' => 'Preserve order.', danielebarchiesi@0: 'type' => 'serial', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: ), danielebarchiesi@0: 'vocab_id' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: ), danielebarchiesi@0: 'tid' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: ), danielebarchiesi@0: 'nid' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: ), danielebarchiesi@0: 'vid' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'default' => NULL, danielebarchiesi@0: ), danielebarchiesi@0: 'type' => array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 32, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => '', danielebarchiesi@0: ), danielebarchiesi@0: 'created' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: ), danielebarchiesi@0: 'sticky' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: ), danielebarchiesi@0: 'is_current' => array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: ), danielebarchiesi@0: ), danielebarchiesi@0: 'primary key' => array('n'), danielebarchiesi@0: )); danielebarchiesi@0: danielebarchiesi@0: // Query selects all revisions at once and processes them in revision and danielebarchiesi@0: // term weight order. danielebarchiesi@0: $query = db_select('taxonomy_term_data', 'td'); danielebarchiesi@0: // We are migrating term-node relationships. If there are none for a danielebarchiesi@0: // term, we do not need the term_data row. danielebarchiesi@0: $query->join('taxonomy_term_node', 'tn', 'td.tid = tn.tid'); danielebarchiesi@0: // If a term-node relationship exists for a nid that does not exist, we danielebarchiesi@0: // cannot migrate it as we have no node to relate it to; thus we do not danielebarchiesi@0: // need that row from term_node. danielebarchiesi@0: $query->join('node', 'n', 'tn.nid = n.nid'); danielebarchiesi@0: // If the current term-node relationship is for the current revision of danielebarchiesi@0: // the node, this left join will match and is_current will be non-NULL danielebarchiesi@0: // (we also get the current sticky and created in this case). This danielebarchiesi@0: // tells us whether to insert into the current data tables in addition danielebarchiesi@0: // to the revision data tables. danielebarchiesi@0: $query->leftJoin('node', 'n2', 'tn.vid = n2.vid'); danielebarchiesi@0: $query->addField('td', 'vid', 'vocab_id'); danielebarchiesi@0: $query->addField('td', 'tid'); danielebarchiesi@0: $query->addField('tn', 'nid'); danielebarchiesi@0: $query->addField('tn', 'vid'); danielebarchiesi@0: $query->addField('n', 'type'); danielebarchiesi@0: $query->addField('n2', 'created'); danielebarchiesi@0: $query->addField('n2', 'sticky'); danielebarchiesi@0: $query->addField('n2', 'nid', 'is_current'); danielebarchiesi@0: // This query must return a consistent ordering across multiple calls. danielebarchiesi@0: // We need them ordered by node vid (since we use that to decide when danielebarchiesi@0: // to reset the delta counters) and by term weight so they appear danielebarchiesi@0: // within each node in weight order. However, tn.vid,td.weight is not danielebarchiesi@0: // guaranteed to be unique, so we add tn.tid as an additional sort key danielebarchiesi@0: // because tn.tid,tn.vid is the primary key of the D6 term_node table danielebarchiesi@0: // and so is guaranteed unique. Unfortunately it also happens to be in danielebarchiesi@0: // the wrong order which is less efficient, but c'est la vie. danielebarchiesi@0: $query->orderBy('tn.vid'); danielebarchiesi@0: $query->orderBy('td.weight'); danielebarchiesi@0: $query->orderBy('tn.tid'); danielebarchiesi@0: danielebarchiesi@0: // Work around a bug in the PostgreSQL driver that would result in fatal danielebarchiesi@0: // errors when this subquery is used in the insert query below. See danielebarchiesi@0: // https://drupal.org/node/2057693. danielebarchiesi@0: $fields = &$query->getFields(); danielebarchiesi@0: unset($fields['td.weight']); danielebarchiesi@0: unset($fields['tn.tid']); danielebarchiesi@0: danielebarchiesi@0: db_insert('taxonomy_update_7005') danielebarchiesi@0: ->from($query) danielebarchiesi@0: ->execute(); danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: // We do each pass in batches of 1000. danielebarchiesi@0: $batch = 1000; danielebarchiesi@0: danielebarchiesi@0: $result = db_query_range('SELECT vocab_id, tid, nid, vid, type, created, sticky, is_current FROM {taxonomy_update_7005} ORDER BY n', $sandbox['last'], $batch); danielebarchiesi@0: if (isset($sandbox['cursor'])) { danielebarchiesi@0: $values = $sandbox['cursor']['values']; danielebarchiesi@0: $deltas = $sandbox['cursor']['deltas']; danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: $deltas = array(); danielebarchiesi@0: } danielebarchiesi@0: foreach ($result as $record) { danielebarchiesi@0: $sandbox['count'] += 1; danielebarchiesi@0: danielebarchiesi@0: // Use the valid field for this vocabulary and node type or use the danielebarchiesi@0: // overflow vocabulary if there is no valid field. danielebarchiesi@0: $field_name = isset($sandbox['vocabularies'][$record->vocab_id][$record->type]) ? $sandbox['vocabularies'][$record->vocab_id][$record->type] : 'taxonomyextra'; danielebarchiesi@0: $field = $field_info[$field_name]; danielebarchiesi@0: danielebarchiesi@0: // Start deltas from 0, and increment by one for each term attached to a danielebarchiesi@0: // node. danielebarchiesi@0: if (!isset($deltas[$field_name])) { danielebarchiesi@0: $deltas[$field_name] = 0; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: if (isset($values)) { danielebarchiesi@0: danielebarchiesi@0: // If the last inserted revision_id is the same as the current record, danielebarchiesi@0: // use the previous deltas to calculate the next delta. danielebarchiesi@0: if ($record->vid == $values[2]) { danielebarchiesi@0: danielebarchiesi@0: // For limited cardinality fields, the delta must not be allowed to danielebarchiesi@0: // exceed the cardinality during the update. So ensure that the danielebarchiesi@0: // delta about to be inserted is within this limit. danielebarchiesi@0: // @see field_default_validate(). danielebarchiesi@0: if ($field['cardinality'] != FIELD_CARDINALITY_UNLIMITED && ($deltas[$field_name] + 1) > $field['cardinality']) { danielebarchiesi@0: danielebarchiesi@0: // For excess values of a single-term vocabulary, switch over to danielebarchiesi@0: // the overflow field. danielebarchiesi@0: $field_name = 'taxonomyextra'; danielebarchiesi@0: $field = $field_info[$field_name]; danielebarchiesi@0: if (!isset($deltas[$field_name])) { danielebarchiesi@0: $deltas[$field_name] = 0; danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: danielebarchiesi@0: // When the record is a new revision, empty the deltas array. danielebarchiesi@0: $deltas = array($field_name => 0); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: // Table and column found in the field's storage details. During upgrades, danielebarchiesi@0: // it's always SQL. danielebarchiesi@0: $table_name = "field_data_{$field_name}"; danielebarchiesi@0: $revision_name = "field_revision_{$field_name}"; danielebarchiesi@0: $value_column = $field_name . '_tid'; danielebarchiesi@0: danielebarchiesi@0: // Column names and values in field storage are the same for current and danielebarchiesi@0: // revision. danielebarchiesi@0: $columns = array('entity_type', 'entity_id', 'revision_id', 'bundle', 'language', 'delta', $value_column); danielebarchiesi@0: $values = array('node', $record->nid, $record->vid, $record->type, LANGUAGE_NONE, $deltas[$field_name]++, $record->tid); danielebarchiesi@0: danielebarchiesi@0: // Insert rows into the revision table. danielebarchiesi@0: db_insert($revision_name)->fields($columns)->values($values)->execute(); danielebarchiesi@0: danielebarchiesi@0: // is_current column is a node ID if this revision is also current. danielebarchiesi@0: if ($record->is_current) { danielebarchiesi@0: db_insert($table_name)->fields($columns)->values($values)->execute(); danielebarchiesi@0: danielebarchiesi@0: // Update the {taxonomy_index} table. danielebarchiesi@0: db_insert('taxonomy_index') danielebarchiesi@0: ->fields(array('nid', 'tid', 'sticky', 'created',)) danielebarchiesi@0: ->values(array($record->nid, $record->tid, $record->sticky, $record->created)) danielebarchiesi@0: ->execute(); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: // Store the set of inserted values and the current revision's deltas in the danielebarchiesi@0: // sandbox. danielebarchiesi@0: $sandbox['cursor'] = array( danielebarchiesi@0: 'values' => $values, danielebarchiesi@0: 'deltas' => $deltas, danielebarchiesi@0: ); danielebarchiesi@0: $sandbox['last'] += $batch; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: if ($sandbox['count'] < $sandbox['total']) { danielebarchiesi@0: $sandbox['#finished'] = FALSE; danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: db_drop_table('taxonomy_vocabulary_node_type'); danielebarchiesi@0: db_drop_table('taxonomy_term_node'); danielebarchiesi@0: danielebarchiesi@0: // If there are no vocabs, we're done. danielebarchiesi@0: db_drop_table('taxonomy_update_7005'); danielebarchiesi@0: $sandbox['#finished'] = TRUE; danielebarchiesi@0: danielebarchiesi@0: // Determine necessity of taxonomyextras field. danielebarchiesi@0: $field = $field_info['taxonomyextra']; danielebarchiesi@0: $revision_name = 'field_revision_' . $field['field_name']; danielebarchiesi@0: $node_types = db_select($revision_name)->distinct()->fields($revision_name, array('bundle')) danielebarchiesi@0: ->execute()->fetchCol(); danielebarchiesi@0: danielebarchiesi@0: if (empty($node_types)) { danielebarchiesi@0: // Delete the overflow field if there are no rows in the revision table. danielebarchiesi@0: _update_7000_field_delete_field('taxonomyextra'); danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: // Remove instances which are not actually used. danielebarchiesi@0: $bundles = db_query('SELECT bundle FROM {field_config_instance} WHERE field_name = :field_name', array(':field_name' => 'taxonomyextra'))->fetchCol(); danielebarchiesi@0: $bundles = array_diff($bundles, $node_types); danielebarchiesi@0: foreach ($bundles as $bundle) { danielebarchiesi@0: _update_7000_field_delete_instance('taxonomyextra', 'node', $bundle); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Add {taxonomy_term_data}.format column. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7006() { danielebarchiesi@0: db_add_field('taxonomy_term_data', 'format', array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => TRUE, danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'description' => 'The {filter_format}.format of the description.', danielebarchiesi@0: )); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Add index on {taxonomy_term_data}.name column to speed up taxonomy_get_term_by_name(). danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7007() { danielebarchiesi@0: db_add_index('taxonomy_term_data', 'name', array('name')); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Change the weight columns to normal int. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7008() { danielebarchiesi@0: db_drop_index('taxonomy_term_data', 'taxonomy_tree'); danielebarchiesi@0: db_change_field('taxonomy_term_data', 'weight', 'weight', array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'description' => 'The weight of this term in relation to other terms.', danielebarchiesi@0: ), array( danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'taxonomy_tree' => array('vid', 'weight', 'name'), danielebarchiesi@0: ), danielebarchiesi@0: )); danielebarchiesi@0: danielebarchiesi@0: db_drop_index('taxonomy_vocabulary', 'list'); danielebarchiesi@0: db_change_field('taxonomy_vocabulary', 'weight', 'weight', array( danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default' => 0, danielebarchiesi@0: 'description' => 'The weight of this vocabulary in relation to other vocabularies.', danielebarchiesi@0: ), array( danielebarchiesi@0: 'indexes' => array( danielebarchiesi@0: 'list' => array('weight', 'name'), danielebarchiesi@0: ), danielebarchiesi@0: )); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Change {taxonomy_term_data}.format into varchar. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7009() { danielebarchiesi@0: db_change_field('taxonomy_term_data', 'format', 'format', array( danielebarchiesi@0: 'type' => 'varchar', danielebarchiesi@0: 'length' => 255, danielebarchiesi@0: 'not null' => FALSE, danielebarchiesi@0: 'description' => 'The {filter_format}.format of the description.', danielebarchiesi@0: )); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Change {taxonomy_index}.created to support signed int. danielebarchiesi@0: */ danielebarchiesi@0: function taxonomy_update_7010() { danielebarchiesi@0: db_change_field('taxonomy_index', 'created', 'created', array( danielebarchiesi@0: 'description' => 'The Unix timestamp when the node was created.', danielebarchiesi@0: 'type' => 'int', danielebarchiesi@0: 'unsigned' => FALSE, danielebarchiesi@0: 'not null' => TRUE, danielebarchiesi@0: 'default'=> 0, danielebarchiesi@0: )); danielebarchiesi@0: } danielebarchiesi@0: