source: sipp/0.3-stable-modules/entes_detail_workflow/entes_detail_workflow.install @ e51826a

<?php
  /**
  * Modulo para la gestión de los detalles de comentarios en workflow
  * Sistema Automatizado para la Planificación Estratégico-Situacional en la Administración Pública Venezolana
  * @file entes_detail_workflow.install
  * Drupal part Module to code ente planificador module
  * Copyright 2011 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 - Msc. Juan Vizcarrondo
  * @date 2015-05-21 // (a&#241;o-mes-dia)
  * @version 0.2 // (0.1)
  *
  */
/*
 * Implementation of hook_install()
 */
function entes_detail_workflow_install() {
  // Notify content module when this module is uninstalled.
  drupal_install_schema('entes_detail_workflow');
}

/*
 * Implementation of hook_uninstall()
 */
function entes_detail_workflow_uninstall() {
  drupal_uninstall_schema('entes_detail_workflow');
  db_query("DELETE FROM {variable} WHERE name LIKE '%s'", 'entes_detail_workflow_r%');
}

/*
 * Implementation of hook_schema
 */
function entes_detail_workflow_schema() {
  $schema['entes_detail_workflow'] = array(
    'description' => 'proyectos reformula.',
    'fields' => array(
      'id' => array(
        'description' => 'id de la entidad a que se le hace el woirkflow.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'vid' => array(
        'description' => 'vid de la version de la entidad a que se le hace el woirkflow.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'default' => 0,
      ),
      'sid' => array(
        'description' => 'El id del del cambio de workflow.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'active' => array(
        'description' => 'El id del del cambio de workflow.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'default' => 0,
      ),
      'time' => array(
        'description' => 'El id del del cambio de workflow.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'default' => 0,
      ),
      'tipo' => array(
        'type' => 'varchar',
        'description' => 'El tipo de entidad.',
        'length' => 255,
        'not null' => FALSE,
        'default' => ''
      ),
      'field_name' => array(
        'type' => 'varchar',
        'description' => 'El tipo de entidad.',
        'length' => 255,
        'not null' => TRUE,
        'default' => ''
      ),
      'hid' => array(
        'description' => 'El id del historico del worflow.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'default' => 0,
      ),
      'comentario' => array(
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
        'default' => ''
      ),
    ),
    'indexes' => array(
      'id' => array('id'),
      'sid' => array('sid'),
      'tipo' => array('tipo'),
      'field_name' => array('field_name'),
      'id_sid' => array('id', 'sid'),
      'id_tipo' => array('id', 'tipo'),
      'id_field_name' => array('id', 'field_name'),
      'id_active_field_name' => array('id', 'active'),
    ),
  );
  return $schema;
}