CREATE TABLE IF NOT EXISTS `qb_test_table` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `code2` varchar(2) COLLATE utf8_bin DEFAULT NULL,
  `code3` varchar(3) COLLATE utf8_bin DEFAULT NULL,
  `numeric_code` int(5) DEFAULT NULL,
  `symbol` varchar(4) COLLATE utf8_bin DEFAULT NULL,
  `decimal_symbol` varchar(1) COLLATE utf8_bin DEFAULT NULL,
  `thousands_symbol` varchar(1) COLLATE utf8_bin DEFAULT NULL,
  `format` enum('{cod} ##','## {cod}','{sim} ##','## {sim}') COLLATE utf8_bin NOT NULL DEFAULT '## {sim}',
  `active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE `qb_test_table`
  ADD PRIMARY KEY (`id`);