<?php
// $Id$

/**
 * @file
 * This file contains all the functions which describe and implement drupal database tables
 * needed by this module. This module was developed by Chad N.A. Krilow and Lacey-Anne Sanderson, 
 * University of Saskatchewan. 
 *
 * The project manamgenet module allows you to sync data in a chado/Tripal instance with
 * multiple project/mysql instances as well as manage and create such project instances
 */

/**
 * Implementation of hook_install()
 */
function tripal_project_install() {
	drupal_install_schema('tripal_project');
}

/**
 * Implementation of hook_uninstall() 
 */
function tripal_project_uninstall() {
	drupal_uninstall_schema('tripal_project');
}

/**
 * Implementation of hook_schema()
 */
function tripal_project_schema() {

	//specification for 'tripal_project_instances'
	$schema['chado_project'] = array(
		
		'fields' => array(
      
	    //a int field that cannot be null and acts as a unique identifier for all nid's
      'nid' => array(
				'type' => 'int',
				'unsigned' => TRUE,
				'not null' => TRUE,
 	 	  ),
		
	    //a int field that cannot be null and is vid 	  
  		'vid' => array(
   	   	'type' => 'int',
   	   	'not null' => TRUE,
  	  ),
   	 	
      //a intfield, not null and project_id is the unique_id of the project in chado
    	 'project_id' => array(
   	   	'type' => 'int',
   	   	'unsigned' => TRUE,
   	   	'not null' => TRUE,
    	),
    	 	
  	  	
    ),//end of shema
  	
  	'primary key' => array('nid','vid','project_id'),
	
	);

  return $schema;
}