tbs_department.install

<?php
function tbs_department_schema(){
    $schema['tbs_department'] = array(
        'description' => 'the base table for department.',
        'fields' => array(
            'dep_id' => array(
                'description' => 'The primary identifier for a department',
                'type' => 'serial',
                'unsigned' => TRUE,
                'not null' => TRUE,
            ),
            'dep_vid' => array(
                'description' => 'The current {tbs_department_revision}.dep_vid version identifier',
                'type' => 'int',
                'unsigned' => TRUE,
                'not null' => TRUE,
                'default' => 0,
            ),
            'dep_uid' => array(
                'description' => 'The current user id that entered the department.',
                'type' => 'int',
                'unsigned' => TRUE,
                'not null' => TRUE,
                'default' => 0,
            ),
            'dep_type' => array(
                'description' => 'The machine readable name of the deparment.',
                'type' => 'varchar',
                'length' => 32,
                'not null' => TRUE,
                'default' => '',
            ),
            'dep_name' => array(
                'description' => 'The name of the department.',
                'type' => 'varchar',
                'length' => 32,
                'not null' => TRUE,
                'default' => '',
            ),
            'dep_created' => array(
                'description' => 'the unix timestamp when the department was created.',
                'type' => 'int',
                'not null' => TRUE,
                'default' => 0,
            ),
            'dep_changed' => array(
                'description' => 'the unix timestamp when the department was most recently saved',
                'type' => 'int',
                'not null' => TRUE,
                'default' => 0,
            ),
        ),
        'unique keys' => array(
            'dep_id_dep_vid' => array('dep_id','dep_vid'),
            'dep_id' => array('dep_id')
        ),
        'primary key' => array('dep_id'),
    );
    $schema['tbs_department_type'] = array(
        'description' => 'this table stores information about the types of bundel',
        'fields' => array(
            'dep_type_id' => array(
                'description' => 'The {tbs_department_type}. this is the primary identifier for a department type.',
                'type' => 'serial',
                'unsigned' => TRUE,
                'not null' => TRUE,
            ),
            'dep_type' => array(
                'description' => 'this holds the bundle machine readable name.',
                'type' => 'varchar',
                'length' => 255,
                'not null' => TRUE,
                'default' => '',
            ),
            'name' => array(
                'description' => 'This holds the human readable name of the bundle.',
                'type' => 'varchar',
                'length' => 255,
                'not null' => TRUE,
                'default' => '',
            ),
            'description' => array(
                'description' => 'This holds a short description of the bundle',
                'type' => 'varchar',
                'length' => 255,
                'not null' => TRUE,
                'default' => '',
            ),
            'weight' => array(
                'description' => 'The weight of this department type in relation to others',
                'type' => 'int',
                'not null' => TRUE,
                'default' => 0,
                'size' => 'tiny',
            ),
            'data' => array(
                'description' => 'A serialized array of additional data related to the type',
                'type' => 'text',
                'not null' => FALSE,
                'size' => 'big',
                'serialize' => TRUE,
                
            ),
            'created' => array(
                'description' => 'This holds the unix timstamp on when the type was created',
                'type' => 'int',
                'not null' => TRUE,
                'default' => 0,
            ),
        ),
        'primary key' => array('dep_type_id'),
        'unique keys' => array(
            'dep_type' => array('dep_type')
        ),
    );
    $schema['tbs_department_revision'] = array(
        'description' => 'Stores information about each saved version of a department.',
        'fields' => array(
            'dep_id' => array(
                'description' => 'The {tbs_department} this version belongs to.',
                'type' => 'int',
                'unsigned' => TRUE,
                'not null' => TRUE,
                'default' => 0,
            ),
            'dep_vid' => array(
                'description' => 'The primary identifier for this version.',
                'type' => 'serial',
                'unsigned' => TRUE,
                'not null' => TRUE,
            ),
            'dep_name' => array(
                'description' => 'The Department of this version',
                'type' => 'varchar',
                'length' => 32,
                'not null' => TRUE,
                'default' => '',
            ),
            'dep_created' => array(
                'description' => 'The unix timestamp when the department was created',
                'type' => 'int',
                'not null' => TRUE,
                'default' => 0,
            ),
        ),
        
        
        'indexes' => array(
            'dep_id' => array('dep_id'),
        ),
        'primary key' => array('dep_vid'),
        'foreign Keys' => array(
            'tbs_department' => array(
                'table' => 'tbs_department',
                'columns' => array('dep_id'=> 'dep_id'),
            ),
            'users' => array(
                'table' => 'users',
                'columns' => array('uid' => 'dep_id'),
            ),
        ),
    );
    
    return $schema;
    
}
/**
 * Implements hook_uninstall().
 */
 function tbs_department_uninstall()
 {
    // Make sure tbs_department.module is included.
    require dirname(__FILE__) . DIRECTORY_SEPARATOR . 'tbs_department.module';
    // Bypass entity_load() as we cannot use it here.
    foreach(department_types() as $department_type ) {
        field_attach_delete_bundle('department', $department_type->dep_type);
    }
 }