<?php
/**
*Implements hook_schema().
*/

function dca_horario_schema(){
	//$schema = array();
	$schema['dca_asigdocest'] = array(
		'fields' => array(
			'id_rel' => array(
				'type' => 'serial',
				),
			'id_asignatura' => array(
				'type' => 'int',
				),
			'id_docente' => array(
				'type' => 'int',
				),
			'id_estudiante' => array(
				'type' => 'int',
				),
			),
		'primary key' => array('id_rel'),
		);

	$schema['dca_asignatura'] = array(
		'fields' => array(
			'id_asignatura' => array(
				'type' => 'serial',
				),
			'nombre' => array(
				'type' => 'varchar',
				'length' => 255,
				),
			'descripcion' => array(
				'type' => 'varchar',
				'length' => 255,
				),			
			),
		'primary key' => array('id_asignatura'),
		);

	$schema['dca_docente'] = array(
		'fields' => array(
			'id_profesor' => array(
				'type' => 'serial',
				),
			'nombre' => array(
				'type' => 'varchar',
				'length' => 255,
				),
			'id_universidad' => array(
				'type' => 'int',
				),			
			),
		'primary key' => array('id_profesor'),
		);

	$schema['dca_estudiante'] = array(
		'fields' => array(
			'id_estudiante' => array(
				'type' => 'serial',
				),
			'nombre' => array(
				'type' => 'varchar',
				'length' => 255,
				),
			'cohorte' => array(
				'type' => 'varchar',
				'length' => 10,
				),			
			),
		'primary key' => array('id_estudiante'),
		);

	$schema['dca_horario'] = array(
		'fields' => array(
			'id_horario' => array(
				'type' => 'serial',
				),
			'year' => array(
				'type' => 'int',
				),
			'periodo' => array(
				'type' => 'varchar',
				'length' => 2,
				),
			'dia' => array(
				'type' => 'varchar',
				'length' => 255,
				),
			'hora' => array(
				'type' => 'varchar',
				'length' => 255,
				),			
			'id_relasigdocente' => array(
				'type' => 'int',
				),			
			),
		'primary key' => array('id_horario'),
		);

	$schema['dca_universidad'] = array(
		'fields' => array(
			'id_universidad' => array(
				'type' => 'serial',
				),
			'nombre' => array(
				'type' => 'varchar',
				'length' => 255,
				),			
			),
		'primary key' => array('id_universidad'),
		);

	return $schema;
}

/**
 * Implementation of hook_install().
 */

function dca_horario_install() {
  drupal_install_schema('dca_horario');	
}

/**
 * Implementation of hook_uninstall().
 */
function dca_horario_uninstall() {
  drupal_uninstall_schema('dca_horario');
}