<?php
// $Id$

/**
 * @file
 * Install databes table for sms_dbstorage.module
 */
 
/**
 * Implementation of hook_install().
 */
function sms_dbstorage_install(){
  drupal_install_schema('sms_dbstorage');
  //set module to weight -2 to be processed before most modules
  db_query("UPDATE {system} SET weight = -2 WHERE name = 'sms_dbstorage'");
}

/**
 * Implementation of hook_uninstall().
 */
function sms_dbstorage_uninstall(){
  drupal_uninstall_schema('sms_dbstorage');
}
 
 /**
  * Implementation of hook_schema().
  */
 function sms_dbstorage_schema(){
  $schema['sms'] = array(
    'description' => t('Stores sms messages'),
    'fields' => array(
      'mid' => array(
        'type' => 'serial', 
        'unsigned' => TRUE,
        'size' => 'normal',
        'description' => t('Message id'),
      ),
      'direction' => array(
        'type' => 'varchar',  
        'length' => '3',
        'not null' => TRUE,
        'description' => t('On or out for receiving or sending'),
      ),
      'type' => array(
        'type' => 'varchar',  
        'length' => '32',
        'not null' => TRUE,
        'description' => t('message type'),
      ),
      'text' => array(
        'type' => 'varchar',  
        'length' => '255',
        'not null' => TRUE,
        'description' => t('message text of sms'),
      ),
      'sender' => array(
        'type' => 'varchar',  
        'length' => '255',
        'not null' => TRUE,
        'description' => t('mobile number of sender'),
      ),
      'recipient' => array(
        'type' => 'varchar',  
        'length' => '255',
        'not null' => TRUE,
        'description' => t('mobile number of recipient'),
      ),
      'sms' => array(
        'type' => 'text', 
        'size' => 'medium',
        'not null' => TRUE,
        'description' => t('serialized data of whole message'),
        'serialize' => TRUE,
      ),
      'timestamp' => array(
        'type' => 'int',
        'size' => 'normal',
        'not null' => TRUE,
        'description'  => t('timestamp of message sent or received'),
      ),
    ),
    'primary key' => array('mid'),
    'indexes' => array(
      'sender' => array('sender'),
      'account' => array('recipient'),
      'direction' => array('direction'),
      'type' => array('type'),
    ),
  );
  return $schema;
}