<?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_pub_install() {

	drupal_install_schema('tripal_pub');
	
}


/**
 * Implementation of hook_uninstall() 
 */
function tripal_pub_uninstall() {

	drupal_uninstall_schema('tripal_pub');
	
}


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

	//specification for 'tripal_pub_instances'
	$schema['chado_pub'] = 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
    	 'pub_id' => array(
   	   	'type' => 'int',
   	   	'unsigned' => TRUE,
   	   	'not null' => TRUE,
    	)	 	
  	  	
    ),//end of shema
  	
  	'primary key' => array('nid','vid','pub_id'),
	
	);

  return $schema;
}