Output of running SQL

output.txt

Forum2Discourse::Exporters::PunBB
  #categories
 ~ (0.000194) SET sql_auto_is_null = 0
 ~ (0.000126) SET SESSION sql_mode = 'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
 ~ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(10) unsigned NOT NULL AUTO_' at line 7 (code: 1064, sql state: 42000, query: --
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(80) NOT NULL DEFAULT 'New Category',
  `disp_position` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `cat_name`, `disp_position`) VALUES
(1, 'Test Category', 1),
(2, 'Other Test Category', 2);
, uri: mysql:root@127.0.0.1:3306/forum2discourse_test?scheme=mysql&user=root&password=&host=127.0.0.1&port=3306&path=/forum2discourse_test&query=&fragment=&adapter=mysql)
    exports the correct categories (FAILED - 1)

Failures:

  1) Forum2Discourse::Exporters::PunBB#categories exports the correct categories
     Failure/Error: TestDatabase.prepare
     DataObjects::SQLError:
       You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `categories` (
         `id` int(10) unsigned NOT NULL AUTO_' at line 7
     # ./spec/test_database.rb:10:in `prepare'
     # ./spec/exporters/punbb_spec.rb:8:in `block (2 levels) in <top (required)>'