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' => array(
'lat' => array(
'type' => 'float',
'size' => 'big',
'not null' => false,
),
'lng' => array(
'type' => 'float',
'size' => 'big',
'not null' => false,
),
'mapTypeId' => array(
'type' => 'varchar',
'length' => '15',
'not null' => false,
),
'zoom' => array(
'type' => 'integer',
'size' => 'small',
'not null' => false,
),
),
'indexes' => array(
'lat_lng' => array('lat', 'lng'),
),
);
}
I hope somebody can point out my mistake here. If some informations missing, please comment.
Thank you in advance.