 -- Records of coffeetypes
 -- ----------------------------
 BEGIN;
-INSERT INTO `coffeetypes` VALUES ('1', '100% Robusta with unknown roasting date', '300.00', '1', '1'), ('2', '100% Robusta with unknown roasting date', '400.00', '1', '1'), ('3', '30/70 Robusta/Arabica blend with unknown roasting date', '450.00', '1', '1'), ('4', '10/90 Robusta/Arabica blend with unknown roasting date', '470.00', '1', '1'), ('5', '100% Arabica with unknown roasting date', '500.00', '1', '1'), ('6', 'Commodity grade Arabica, freshly roasted', '600.00', '1', '1'), ('7', 'Specialty coffee, freshly roasted', '700.00', '1', '1'), ('8', 'Micro lot, freshly roasted', '750.00', '1', '1'), ('9', 'Nano lot, freshly roasted', '800.00', '1', '1');
+INSERT INTO `coffeetypes` VALUES ('1', '100% Robusta with unknown roasting date', '300.00', '1', '1', 'coffee1'), ('2', '100% Robusta with unknown roasting date', '400.00', '1', '1', 'coffee2'), ('3', '30/70 Robusta/Arabica blend with unknown roasting date', '450.00', '1', '1', 'coffee3'), ('4', '10/90 Robusta/Arabica blend with unknown roasting date', '470.00', '1', '1', 'coffee4'), ('5', '100% Arabica with unknown roasting date', '500.00', '1', '1', 'coffee5'), ('6', 'Commodity grade Arabica, freshly roasted', '600.00', '1', '1', 'coffee6'), ('7', 'Specialty coffee, freshly roasted', '700.00', '1', '1', 'coffee7'), ('8', 'Micro lot, freshly roasted', '750.00', '1', '1', 'coffee8'), ('9', 'Nano lot, freshly roasted', '800.00', '1', '1', 'coffee9');
 COMMIT;
 
 -- ----------------------------

-- Records of coffeeplaces
-- ----------------------------
BEGIN;
INSERT INTO `coffeeplaces` VALUES ('1', 'Sufficient', '6000.00', '1', '1'), ('2', 'Slightly better', '8000.00', '1', '1'), ('3', 'Good', '14000.00', '1', '1'), ('4', 'Great', '55000.00', '1', '1'), ('5', 'Fantastic', '130000.00', '1', '1');
COMMIT;

-- ----------------------------

`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`price`  decimal(15,2) NOT NULL ,
`currency_id`  int(11) NULL DEFAULT NULL ,
`translate_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`coffeeMachine_id`)
)
ENGINE=MyISAM
