mocean_sms_broadcast-1.x-dev/mocean_sms_broadcast.install

<?php

function mocean_sms_broadcast_schema() {
  $schema['mocean_sms_history'] = array(
    'description' => 'Stores SMS transaction log',
    'fields' => array(
      'pid' => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => 'Primary Key: Unique id for each SMS transaction',
      ),
      'sender' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
        'description' => 'Sender of the message',
      ),
      'datetime' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
        'description' => 'Store date and time of transaction',
      ),
       'message' => array(
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => '',
        'description' => 'Store message of transaction',
      ),
      'recipient' => array(
        'type' => 'varchar',
        'length' => 15,
        'not null' => TRUE,
        'default' => 0,
        'description' => 'Store recipient of transaction',
      ),
      'response' => array(
        'type' => 'varchar',
		'length' => 255,
        'not null' => TRUE,
        'default' => '',
        'description' => 'The response of the transaction',
      ),
      'status' => array(
        'type' => 'varchar',
        'not null' => TRUE,
		'length' => 10,
        'default' => '',
        'description' => 'The status of the transaction',
      ),
    ),
    'primary key' => array('pid'),
  );

  return $schema;
}