CREATE TABLE `dashboardinfo` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`storeId`  int(10) NOT NULL DEFAULT 1 ,
`value`  double(14,4) NOT NULL DEFAULT 0.0000 ,
`month`  varchar(7) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' ,
`typeId`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`active`  tinyint(1) NOT NULL DEFAULT 1 ,
`created`  datetime NOT NULL DEFAULT '0001-01-01 00:00:00' ,
`createdById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`updated`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`updatedById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
INDEX `typeId` (`typeId`) USING BTREE ,
INDEX `createdById` (`createdById`) USING BTREE ,
INDEX `updatedById` (`updatedById`) USING BTREE ,
INDEX `value` (`value`) USING BTREE ,
INDEX `storeId` (`storeId`) USING BTREE ,
INDEX `month` (`month`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Compact
;

CREATE TABLE `dashboardinfotype` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`active`  tinyint(1) NOT NULL DEFAULT 1 ,
`created`  datetime NOT NULL DEFAULT '0001-01-01 00:00:00' ,
`createdById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
`updated`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`updatedById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
UNIQUE INDEX `name` (`name`) USING BTREE ,
INDEX `createdById` (`createdById`) USING BTREE ,
INDEX `updatedById` (`updatedById`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Compact
;