<?php 
 $GLOBALS["dictionary"]["EmailText"]=array (
  'table' => 'emails_text',
  'comment' => 'Large email text fields',
  'mysqlengine' => 'MyISAM',
  'engine' => 'MyISAM',
  'fields' => 
  array (
    'email_id' => 
    array (
      'name' => 'email_id',
      'vname' => 'LBL_ID',
      'type' => 'id',
      'dbType' => 'id',
      'len' => 36,
      'required' => true,
      'reportable' => true,
      'comment' => 'Foriegn key to emails table',
    ),
    'from_addr' => 
    array (
      'name' => 'from_addr',
      'vname' => 'LBL_FROM',
      'type' => 'varchar',
      'len' => 255,
      'comment' => 'Email address of person who send the email',
    ),
    'reply_to_addr' => 
    array (
      'name' => 'reply_to_addr',
      'vname' => 'LBL_REPLY_TO',
      'type' => 'varchar',
      'len' => 255,
      'comment' => 'reply to email address',
    ),
    'to_addrs' => 
    array (
      'name' => 'to_addrs',
      'vname' => 'LBL_TO',
      'type' => 'text',
      'comment' => 'Email address(es) of person(s) to receive the email',
    ),
    'cc_addrs' => 
    array (
      'name' => 'cc_addrs',
      'vname' => 'LBL_CC',
      'type' => 'text',
      'comment' => 'Email address(es) of person(s) to receive a carbon copy of the email',
    ),
    'bcc_addrs' => 
    array (
      'name' => 'bcc_addrs',
      'vname' => 'LBL_BCC',
      'type' => 'text',
      'comment' => 'Email address(es) of person(s) to receive a blind carbon copy of the email',
    ),
    'description' => 
    array (
      'name' => 'description',
      'vname' => 'LBL_TEXT_BODY',
      'type' => 'longtext',
      'reportable' => false,
      'comment' => 'Email body in plain text',
    ),
    'description_html' => 
    array (
      'name' => 'description_html',
      'vname' => 'LBL_HTML_BODY',
      'type' => 'longhtml',
      'reportable' => false,
      'comment' => 'Email body in HTML format',
    ),
    'raw_source' => 
    array (
      'name' => 'raw_source',
      'vname' => 'LBL_RAW',
      'type' => 'longtext',
      'reportable' => false,
      'comment' => 'Full raw source of email',
    ),
    'deleted' => 
    array (
      'name' => 'deleted',
      'type' => 'bool',
      'default' => 0,
    ),
  ),
  'indices' => 
  array (
    0 => 
    array (
      'name' => 'emails_textpk',
      'type' => 'primary',
      'fields' => 
      array (
        0 => 'email_id',
      ),
    ),
    1 => 
    array (
      'name' => 'emails_textfromaddr',
      'type' => 'index',
      'fields' => 
      array (
        0 => 'from_addr',
      ),
    ),
  ),
);