You are here

function lingotek_schema in Lingotek Translation 7.3

Same name and namespace in other branches
  1. 8 lingotek.install \lingotek_schema()
  2. 8.2 lingotek.install \lingotek_schema()
  3. 6 lingotek.install \lingotek_schema()
  4. 7.7 lingotek.install \lingotek_schema()
  5. 7.2 lingotek.install \lingotek_schema()
  6. 7.4 lingotek.install \lingotek_schema()
  7. 7.5 lingotek.install \lingotek_schema()
  8. 7.6 lingotek.install \lingotek_schema()
  9. 4.0.x lingotek.install \lingotek_schema()
  10. 3.0.x lingotek.install \lingotek_schema()
  11. 3.1.x lingotek.install \lingotek_schema()
  12. 3.2.x lingotek.install \lingotek_schema()
  13. 3.3.x lingotek.install \lingotek_schema()
  14. 3.4.x lingotek.install \lingotek_schema()
  15. 3.5.x lingotek.install \lingotek_schema()
  16. 3.6.x lingotek.install \lingotek_schema()
  17. 3.7.x lingotek.install \lingotek_schema()
  18. 3.8.x lingotek.install \lingotek_schema()

File

./lingotek.install, line 79
Installation for Lingotek Community Translation Module.

Code

function lingotek_schema() {
  $schema['lingotek'] = array(
    'description' => 'Table for storing node related data.',
    'fields' => array(
      'nid' => array(
        'description' => 'The primary identifier for a node',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'lingokey' => array(
        'description' => 'Key in key/value pairs',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
      'lingovalue' => array(
        'description' => 'Value of the specified key',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
    ),
    'primary key' => array(
      'nid',
      'lingokey',
    ),
  );
  $schema['lingotek_entity_metadata'] = array(
    'description' => 'Stores Lingotek-related metadata about Drupal entities.',
    'fields' => array(
      'entity_id' => array(
        'description' => 'The primary identifier for the entity.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'entity_type' => array(
        'description' => 'The entity type (node, comment, etc.).',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
      'entity_key' => array(
        'description' => 'The ID for the Lingotek-associated value.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
      'value' => array(
        'description' => 'Value for the specified key.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
    ),
    'primary key' => array(
      'entity_id',
      'entity_type',
      'entity_key',
    ),
  );
  $schema['lingotek_config_metadata'] = array(
    'description' => 'Stores Lingotek-related metadata about Drupal translations from locales source and target tables.',
    'fields' => array(
      'id' => array(
        'description' => 'the segment ID assigned to the given range of strings.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'config_key' => array(
        'description' => 'The ID for the Lingotek-associated value.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
      'value' => array(
        'description' => 'Value for the specified key.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
    ),
    'primary key' => array(
      'id',
      'config_key',
    ),
  );
  return $schema;
}