MySQL error when creating field schema I have a problem when adding a new field to a content type. The schema installer for the specified field always causes the following error:


  Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL DEFAULT NULL, PRIMARY KEY (entity_type, entity_id, deleted, delta,' at line 12.


Here is the hook_field_schema() implementation:

function google_directions_field_schema($field)
{
    return array(
        'columns' =&gt; array(
            'lat' =&gt; array(
                'type' =&gt; 'float',
                'size' =&gt; 'big',
                'not null' =&gt; false,
            ),
            'lng' =&gt; array(
                'type' =&gt; 'float',
                'size' =&gt; 'big',
                'not null' =&gt; false,
            ),
            'mapTypeId' =&gt; array(
                'type' =&gt; 'varchar',
                'length' =&gt; '15',
                'not null' =&gt; false,
            ),
            'zoom' =&gt; array(
                'type' =&gt; 'integer',
                'size' =&gt; 'small',
                'not null' =&gt; false,
            ),
        ),
        'indexes' =&gt; array(
            'lat_lng' =&gt; array('lat', 'lng'),
        ),
    );
}


I hope somebody can point out my mistake here. If some informations missing, please comment.

Thank you in advance.
I fixed this problem by myself. Please note the mistyped column type name integer which is now int:

function google_directions_field_schema($field)
{
    return array(
        'columns' =&gt; array(
            'lat' =&gt; array(
                'type' =&gt; 'float',
                'size' =&gt; 'big',
                'not null' =&gt; false,
            ),
            'lng' =&gt; array(
                'type' =&gt; 'float',
                'size' =&gt; 'big',
                'not null' =&gt; false,
            ),
            'mapTypeId' =&gt; array(
                'type' =&gt; 'varchar',
                'length' =&gt; '15',
                'not null' =&gt; false,
            ),
            'zoom' =&gt; array(
                'type' =&gt; 'int',
                'size' =&gt; 'small',
                'not null' =&gt; false,
            ),
        ),
        'indexes' =&gt; array(
            'lat_lng' =&gt; array('lat', 'lng'),
        ),
    );
}