function uc_views_marketing_schema in Ubercart Views 6.3

Implementation of hook_schema().

File

uc_views_marketing/uc_views_marketing.install, line 27

Code

function uc_views_marketing_schema() {
  $schema['uc_order_products_user_vw'] = array(
    'description' => t('VIEW'),
    'fields' => array(
      'nid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'uid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'order_count' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'big',
        'not null' => TRUE,
        'default' => 0,
      ),
      'avg_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'numeric',
        'not null' => FALSE,
        'precision' => '10',
        'scale' => '4',
      ),
      'sum_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'numeric',
        'not null' => FALSE,
        'precision' => '28',
        'scale' => '0',
      ),
      'max_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'size' => 'small',
        'not null' => FALSE,
      ),
      'min_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'size' => 'small',
        'not null' => FALSE,
      ),
    ),
  );
  $schema['uc_order_products_qty_vw'] = array(
    'description' => t('VIEW'),
    'fields' => array(
      'nid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'order_count' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'big',
        'not null' => TRUE,
        'default' => 0,
      ),
      'avg_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'numeric',
        'not null' => FALSE,
        'precision' => '10',
        'scale' => '4',
      ),
      'sum_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'numeric',
        'not null' => FALSE,
        'precision' => '28',
        'scale' => '0',
      ),
      'max_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'size' => 'small',
        'not null' => FALSE,
      ),
      'min_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'size' => 'small',
        'not null' => FALSE,
      ),
    ),
  );
  $schema['uc_order_products_pair_vw'] = array(
    'description' => t('VIEW'),
    'fields' => array(
      'nid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'pair_nid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'pair_sum_qty' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'numeric',
        'not null' => FALSE,
        'precision' => '28',
        'scale' => '0',
      ),
      'order_count' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'big',
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
  );
  return $schema;
}