Hi,
Please find below the create table syntax for that table. I'd be concerned that there would be other tables missing though - so I would recommend running your database through the Magento database repair tool available at:
http://www.magentocommerce.com/download
CREATE TABLE `sales_bestsellers_aggregated_yearly` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
`period` date DEFAULT NULL COMMENT 'Period',
`store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
`product_id` int(10) unsigned DEFAULT NULL COMMENT 'Product Id',
`product_name` varchar(255) DEFAULT NULL COMMENT 'Product Name',
`product_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Product Price',
`qty_ordered` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Qty Ordered',
`rating_pos` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Rating Pos',
PRIMARY KEY (`id`),
UNIQUE KEY `UNQ_SALES_BESTSELLERS_AGGRED_YEARLY_PERIOD_STORE_ID_PRD_ID` (`period`,`store_id`,`product_id`),
KEY `IDX_SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID` (`store_id`),
KEY `IDX_SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID` (`product_id`),
CONSTRAINT `FK_SALES_BESTSELLERS_AGGRED_YEARLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_SALES_BESTSELLERS_AGGRED_YEARLY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='Sales Bestsellers Aggregated Yearly';
