= array(
    'productSummaryLastQuarterID' => array('type'=>'INT', 'increment'=>true, 'index'=>true),
    'upc' => array('type'=>'VARCHAR(13)', 'primary_key'=>true),
    'qtyThisWeek' => array('type'=>'DECIMAL(10,2)'),
    'totalThisWeek' => array('type'=>'MONEY'),
    'qtyLastQuarter' => array('type'=>'DECIMAL(10,2)'),
    'totalLastQuarter' => array('type'=>'MONEY'),
    'percentageStoreSales' => array('type'=>'DECIMAL(10,5)'),
    'percentageSuperDeptSales' => array('type'=>'DECIMAL(10,5)'),
    'percentageDeptSales' => array('type'=>'DECIMAL(10,5)'),
    )