function ViewsSqlTest::schemaDefinition

Same name in other branches
  1. 7.x-3.x tests/views_query.test \ViewsSqlTest::schemaDefinition()

The schema definition.

1 call to ViewsSqlTest::schemaDefinition()
ViewsSqlTest::setUp in tests/views_query.test

File

tests/views_query.test, line 131

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;
}