libhours.install~

<?php
// $Id$

/**
 * @file
 * Install, Uninstalls Schema for lib hours module
 *
 * @author Parth Shah <parth.shah@ucdenver.edu>
 * 
 */
 
/**
 * Implements hook_install()
 */

function libhours_install(){
	
	
	/* pre-populate the semesters and type tables.
	   need to check if the table already has something in there to avoid overwrites or duplicates
	   that can happen when enabling/disabling the module.
	*/
  $has_rows_semesters = (bool) db_query_range('SELECT name FROM {libhours_semesters}', 0, 1) -> fetchField();
  
  if(!$has_rows_semesters)  {
    $insert_id = db_insert('libhours_semesters') ->fields(array('name' => 'Fall')) -> execute();
    $insert_id = db_insert('libhours_semesters') ->fields(array('name' => 'Spring')) -> execute();
    $insert_id = db_insert('libhours_semesters') ->fields(array('name' => 'Summer')) -> execute();
    $insert_id = db_insert('libhours_semesters') ->fields(array('name' => 'Finals')) -> execute();
    $insert_id = db_insert('libhours_semesters') ->fields(array('name' => 'Winter Break')) -> execute();
    $insert_id = db_insert('libhours_semesters') ->fields(array('name' => 'Spring Break')) -> execute();
    $insert_id = db_insert('libhours_semesters') ->fields(array('name' => 'Intersession')) -> execute();
  }
  
  $has_rows_type = (bool) db_query_range('SELECT name FROM {libhours_type}', 0, 1) -> fetchField();
  
  if(!$has_rows_type)  {
    $insert_id = db_insert('libhours_type') ->fields(array('name' => 'Holiday')) -> execute();
    $insert_id = db_insert('libhours_type') ->fields(array('name' => 'Emergency')) -> execute();
    $insert_id = db_insert('libhours_type') ->fields(array('name' => 'Unexpected')) -> execute();
   
  }

}

/**
 * Implements hook_uninstall()
*/ 
function libhours_uninstall()  {
	drupal_uninstall_schema('libhours');
}


/**
 * Implements hook_schema()
 */
function libhours_schema()  {
	$schema['libhours_locations'] = array(
		'description' => 'Library Locations',
		'fields' => array(
			'lid' => array(
				'description' => 'unique identifier for locations',
				'type' => 'serial',
				'not null' => true,
				'unsigned' => true),
			'name' => array(
				'description' => 'name of location',
				'type' => 'varchar',
				'length' => 100,
				'not null' => true,
				'default' => ''),
			'description' => array(
				'description' => 'location description text',
				'type' => 'varchar',
				'length' => 500,
				'not null' => true,
				'default' => ''),
			'parent' => array(
				'description' => 'parent location lid identifier',
				'type' => 'int',
				'not null' => true,
				'unsigned' => true,
				'default' => 0)
		),
		'primary key' => array('lid')
	);
	
	$schema['libhours_periods'] = array(
		'description' => 'Location periods',
		'fields' => array(
			'pid' => array(
				'description' => 'unique identifier for periods',
				'type' => 'serial',
				'not null' => true,
				'unsigned' => true),
			'lid' => array(
				'description' => 'foreign key to locations identifier',
				'type' => 'int',
				'not null' => true,
				'unsigned' => true),
			'sid' => array(
				'description' => 'foreign key to semester identifier',
				'type' => 'int',
				'not null' => true,
				'unsigned' => true),
			'from_date' => array(
				'description' => 'periods start date',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true),
			'to_date' => array(
				'description' => 'periods end date',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true),
		),
		'primary key' => array('pid')		
	);
	
	$schema['libhours_semesters'] = array(
		'description' => 'Semesters for a period',
		'fields' => array(
			'sid' => array(
				'description' => 'unique identifier for semesters',
				'type' => 'serial',
				'not null' => true,
				'unsigned' => true),
			'name' => array(
				'description' => 'semester name',
				'type' => 'varchar',
				'length' => 100,
				'not null' => true,
				'default' => '')
		),
		'primary key' => array('sid')
	);
	
	$schema['libhours_hours'] = array(
		'description' => 'Period hours of operation',
		'fields' => array(
			'hid' => array(
				'description' => 'unique identifier for hours',
				'type' => 'serial',
				'not null' => true,
				'unsigned' => true),
			'pid' => array(
				'description' => 'foreign key to periods identifier',
				'type' => 'int',
				'not null' => true,
				'unsigned' => true),
			'dow' => array(
				'description' => 'Days of week binary string',
				'type' => 'varchar',
				'length' => 7,
				'not null' => true,
				'default' => '1111111'),
			'open' => array(
				'description' => 'The hour the location opens. Open 24hours is when open is 0 and close is 2400. Close 24hours is when open and close are 0',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true),
			'close' => array(
				'description' => 'The hour the location closes',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true)
		),
		'primary key' => array('hid')
	);
	
	$schema['libhours_exceptions'] = array(
		'description' => 'Exceptions for locations',
		'fields' => array(
			'eid' => array(
				'description' => 'unique identifier for exceptions',
				'type' => 'serial',
				'not null' => true,
				'unsigned' => true),
			'lid' => array(
				'description' => 'foreign key to location identifier',
				'type' => 'int',
				'not null' => true,
				'unsigned' => true),
			'tid' => array(
				'description' => 'foreign key to type identifier',
				'type' => 'int',
				'not null' => true,
				'unsigned' => true),
			'label' => array(
				'description' => 'exception description label',
				'type' => 'varchar',
				'length' => 500,
				'not null' => true,
				'default' => ''),
			'from_date' => array(
				'description' => 'exception start date',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true),
			'to_date' => array(
				'description' => 'exception end date',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true),
			'open' => array(
				'description' => 'The hour the location opens. Open 24hours is when open is 0 and close is 2400. Close 24hours is when open and close are 0',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true),
			'close' => array(
				'description' => 'The hour the location closes',
				'type' => 'int',
				'not null' => FALSE,
				'unsigned' => true)
		),
		'primary key' => array('eid')
	);

	$schema['libhours_type'] = array(
		'description' => 'Exception type identifier',
		'fields' => array(
			'tid' => array(
				'description' => 'unique identifier for exception type',
				'type' => 'serial',
				'not null' => true,
				'unsigned' => true),
			'name' => array(
				'description' => 'type name',
				'type' => 'varchar',
				'length' => 100,
				'default' => ''),
		),
		'primary key' => array('tid')
	);

	return $schema;
}