Solved 10.99 Table 'ots_server.store_history' doesn't exist

[Shadow Dan]

Anyone knows SQL command to add working table 'store_history' for new ingame store?

[Error - mysql_real_query] Query: INSERT INTO `store_history`(`account_id`, `mode`, `description`, `coin_amount`, `time`) VALUES (3879, 0, 'Shadow transfered you this amount.', 25, 1478724576)
Message: Table 'ots_server.store_history' doesn't exist

[Error - mysql_real_query] Query: INSERT INTO `store_history`(`account_id`, `mode`, `description`, `coin_amount`, `time`) VALUES (2, 0, '1x Thunderheart Platemail', -12, 1478725013)
Message: Table 'ots_server.store_history' doesn't exist

Is that something like that?

CREATE TABLE `store_history`
(
`account_id`,
`mode`,
`description`,
`coin_amount`,
`time`
) ENGINE = InnoDB;

 

[Cornex]

Try this:

CREATE TABLE `store_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `mode` int(11) NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `coin_amount` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

[Shadow Dan]

Cool, perfect!