Drupal 6: Define a numeric field type in the database schema

Often it is useful to define numeric fields in the database for information such as pricing or measurement.

In Drupal, the way to define a numeric type is to also declare the "precision" option.

$schema['products'] = array(
  'description' => t('Stores product data.'),
  'fields' => array(
    'prodid' => array('type' => 'int', 'not null' => TRUE),
    'manufacturer' => array('type' => 'text'),
    'product_name' => array('type' => 'text'),
    'description' => array('type' => 'text'),
    'price' => array('type' => 'numeric', 'precision' => 2),
  ),
  'primary key' => array(prodid'),
);