<?php
// $Id: letters.install,v 1.2 2007/11/07 16:31:47 seanr Exp $
function letters_install() {
  drupal_install_schema('letters');
}

function letters_uninstall() {
  drupal_uninstall_schema('letters');
}

/**
* Implementation of hook_schema().
*/
function letters_schema() {
  $schema['letters_newspapers'] = array(
    'fields' => array(
      'newsid' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
      'title' => array('type' => 'varchar', 'not null' => TRUE, 'length' => 255),
      'address' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
      'city' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
      'state' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 2),
      'zip' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 10),
      'phone' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 15),
      'fax' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 15),
      'email' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
      'homepage' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
      'statewide' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
    ),
    'indexes' => array(
      'letters_zip' => array('zip')
    ),
    'primary key' => array('newsid'),
  );
}