protected function ViewsSqlTest::schemaDefinition in Views (for Drupal 7) 6.3

Same name and namespace in other branches

1. 7.3 tests/views_query.test \ViewsSqlTest::schemaDefinition()

The schema definition.

1 call to ViewsSqlTest::schemaDefinition()

ViewsSqlTest::setUp in tests/views_query.test

Generates a random database prefix, runs the install scripts on the prefixed database and enable the specified modules. After installation many caches are flushed and the internal browser is setup so that the page requests will run on the new prefix.…

File

tests/views_query.test, line 131

Tests for Views query features.

Class

ViewsSqlTest

Code

protected function schemaDefinition() {
  $schema['views_test'] = array(
    'description' => 'Basic test table for Views tests.',
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'name' => array(
        'description' => "A person's name",
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
      ),
      'age' => array(
        'description' => "The person's age",
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'job' => array(
        'description' => "The person's job",
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => 'Undefined',
      ),
      'created' => array(
        'description' => "The creation date of this record",
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array(
      'id',
    ),
    'unique keys' => array(
      'name' => array(
        'name',
      ),
    ),
    'indexes' => array(
      'ages' => array(
        'age',
      ),
    ),
  );
  return $schema;
}