modules/letters/letters.install

<?php
// $Id: letters.install,v 1.4 2009/06/08 15:19:09 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' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE),
      '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'),
  );
  return $schema;
}

/**
* Implementation of hook_update().
*/
function letters_update_1() {
  $ret = array();
  db_drop_primary_key($ret, 'letters_newspapers');
  db_change_field($ret, 'letters_newspapers', 'newsid', 'newsid',
    array('type' => 'serial', 'not null' => TRUE),
    array('primary key' => array('newsid'))
  );
  return $ret;
}
1	<?php
2	// $Id: letters.install,v 1.4 2009/06/08 15:19:09 seanr Exp $
3	function letters_install() {
4	drupal_install_schema('letters');
5	}
6
7	function letters_uninstall() {
8	drupal_uninstall_schema('letters');
9	}
10
11	/**
12	* Implementation of hook_schema().
13	*/
14	function letters_schema() {
15	$schema['letters_newspapers'] = array(
16	'fields' => array(
17	'newsid' => array('type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE),
18	'title' => array('type' => 'varchar', 'not null' => TRUE, 'length' => 255),
19	'address' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
20	'city' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
21	'state' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 2),
22	'zip' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 10),
23	'phone' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 15),
24	'fax' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 15),
25	'email' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
26	'homepage' => array('type' => 'varchar', 'not null' => FALSE, 'length' => 255),
27	'statewide' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0),
28	),
29	'indexes' => array(
30	'letters_zip' => array('zip')
31	),
32	'primary key' => array('newsid'),
33	);
34	return $schema;
35	}
36
37	/**
38	* Implementation of hook_update().
39	*/
40	function letters_update_1() {
41	$ret = array();
42	db_drop_primary_key($ret, 'letters_newspapers');
43	db_change_field($ret, 'letters_newspapers', 'newsid', 'newsid',
44	array('type' => 'serial', 'not null' => TRUE),
45	array('primary key' => array('newsid'))
46	);
47	return $ret;
48	}