function eloqua_schema in Eloqua 6
File
- ./
eloqua.install, line 4
Code
function eloqua_schema() {
$schema = array();
$schema[ELOQUA_SCHEMA_SAVED_POSTS] = array(
'description' => t('Webform Settings'),
'primary key' => array(
ELOQUA_POST_FIELD_POST_ID,
),
'unique keys' => array(),
'indexes' => array(
ELOQUA_SCHEMA_SAVED_POSTS . '_form_id' => array(
ELOQUA_POST_FIELD_FORM_ID,
),
),
'fields' => array(
ELOQUA_POST_FIELD_FORM_ID => array(
// Associated Form Id
'description' => 'Form ID that generated this post',
'type' => 'varchar',
'size' => 'normal',
'length' => 32,
'not null' => TRUE,
'default' => '',
),
ELOQUA_POST_FIELD_POST_ID => array(
// Serial Number
'type' => 'serial',
'size' => 'normal',
'unsigned' => TRUE,
'not null' => TRUE,
),
ELOQUA_POST_FIELD_STATUS => array(
// Form Posted Status
'description' => 'Eloqua option name',
'type' => 'varchar',
'size' => 'normal',
'length' => 32,
'not null' => TRUE,
'default' => '',
),
ELOQUA_POST_FIELD_POST_TIME => array(
// Post Time
'description' => 'Node Id',
'type' => 'int',
'size' => 'normal',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
ELOQUA_POST_FIELD_DATA => array(
// Form Contents
'description' => 'Extra data to be stored with the field',
'type' => 'text',
'size' => 'normal',
/* 16KB in mySql */
'not null' => TRUE,
'default' => '',
),
),
);
$schema[ELOQUA_SCHEMA_WEBFORM] = array(
'description' => t('Webform Settings'),
'primary key' => array(
ELOQUA_WEBFORM_FIELD_NODE_ID,
),
'unique keys' => array(),
'indexes' => array(
ELOQUA_SCHEMA_WEBFORM . '_active' => array(
ELOQUA_WEBFORM_FIELD_ACTIVE,
),
),
'fields' => array(
ELOQUA_WEBFORM_FIELD_NODE_ID => array(
// Webform Node Id
'description' => 'Node Id',
'type' => 'int',
'size' => 'normal',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
ELOQUA_WEBFORM_FIELD_FORM_NAME => array(
// Eloqua Form Name
'description' => 'Eloqua form name',
'type' => 'varchar',
'size' => 'normal',
'length' => 64,
'not null' => TRUE,
'default' => '',
),
ELOQUA_WEBFORM_FIELD_ACTIVE => array(
// Is this webform eloqua enabled
'description' => 'Whether this form is eloqua active',
'type' => 'int',
'size' => 'tiny',
'not null' => TRUE,
'default' => 0,
'unsigned' => TRUE,
),
ELOQUA_WEBFORM_FIELD_DATA => array(
'description' => 'Extra data to be stored with the field',
'type' => 'text',
'size' => 'normal',
/* 16KB in mySql */
'not null' => TRUE,
'default' => '',
),
),
);
return $schema;
}