source: sipp/0.3-stable-modules/reportes_sipp/reportes_sipp.install

<?php
  /**
  * Sistema Integral de Planificación y Presupuesto (SIPP)
  * @file reportes_sipp.install
  * Drupal part Module to Sistema Integral de Planificación y Presupuesto (SIPP)
  * Copyright 2013 Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana (CENDITEL)
  *
  * This program is free software; you can redistribute it and/or modify
  * it under the terms of the GNU General Public License as published by
  * the Free Software Foundation; either version 2 of the License, or
  * (at your option) any later version.
  * 
  * This program is distributed in the hope that it will be useful,
  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  * GNU General Public License for more details.
  * 
  * You should have received a copy of the GNU General Public License
  * along with this program; if not, write to the Free Software
  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
  *
  * @author Cenditel Merida - Ing. Diego Uzcátegui (diego.uzc [at] gmail [dot] com)
  * @date 2013-05-01 // (a&#241;o-mes-dia)
  * @version 0.1 // (0.1)
  *
  */

/*
 * Implementation of hook_install()
 */
function reportes_sipp_install() {
  // Notify content module when this module is uninstalled.
  drupal_install_schema('reportes_sipp');
  db_query("DELETE FROM {cache}");
  
}

/*
 * Implementation of hook_uninstall()
 */
function  reportes_sipp_uninstall() {
  // Notify content module when this module is uninstalled.
  drupal_uninstall_schema('reportes_sipp');
  db_query("DELETE FROM {cache}");

}

/**
 * Implementation of hook_schema()
 * @return array of Schema API table definitions.
 */
function reportes_sipp_schema() {
  $schema = array();

  $schema['microinformes_area_estrategica_mcti'] = array(
    'description' => 'Microinformes.',
    'fields' => array(
      'id_microinforme' => array(
        'description' => 'The id identifier to microinforme.',
        'type' => 'serial',
        'not null' => TRUE,
      ),
      'anho' => array(
        'description' => 'anho para el microinforme.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'id_area_estrategica' => array(
        'description' => 'identificador a area estrategica.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'informacion_textual' => array(
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
        'default' => ''
      ),
      'datos_graficas_y_tablas' => array(
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
        'default' => ''
      ),
      'fecha_creacion' => array(
        'description' => 'Fecha de creación.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
          'fecha_ultima_actualizacion' => array(
        'description' => 'Fecha última actualización.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'uid' => array(
        'description' => 'Referencia al autor.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'indexes' => array(
      'id_microinforme' => array('id_microinforme'),
    ),
    'primary key' => array('id_microinforme'),
  );

  return $schema;
}