<?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');
	$dbxref = array('accession' => 'abstract', 'db_id'=>array('name'=>'tripal'));
	$success = tripal_core_chado_insert('dbxref',$dbxref);
	if ($success) {
		tripal_core_chado_insert('cvterm',array('name'=>'abstract','cv_id'=>array('name'=>'tripal'), 'db
xref_id'=>$dbxref));
	}
}


/**
 * Implementation of hook_uninstall() 
 */
function tripal_pub_uninstall() {
	//Remove tables
	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,
    	),	
    	
    	 //a intfield, not null and project_id is the unique_id of the project in chado
    	 'pubmed_id' => array(
   	   	'type' => 'int',
   	   	'unsigned' => TRUE,
   	   	'not null' => FALSE,
    	),
    	'author' => array(
        'type' => 'text',
        'size' => 'normal',
        'not null' => TRUE,
        'default' => '',
        'description' => 'The Author Name.',
      ),
  	 ), 	
     //end of shema
  	
  	'primary key' => array('nid'),
	
	);

  return $schema;
}