hi
im trying to import a database table, but it has an error

can someone tell me what it is, and give the corrected version

DROP TABLE IF EXISTS `information`;
CREATE TABLE `information` (
  `information_id` tinyint(3) unsigned NOT NULL auto_increment,
  `information_group_id` int(11) unsigned NOT NULL default '0',
  `information_title` varchar(255) NOT NULL default '',
  `information_description` text NOT NULL,
  `parent_id` int(11) default NULL,
  `sort_order` tinyint(3) unsigned NOT NULL default '0',
  `visible` enum('1','0') NOT NULL default '1',
  `language_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`information_id`,`language_id`)
 ENGINE=MyISAM  DEFAULT CHARSET=latin1 );
-- 
-- Table structure for table `information_group`
-- 
DROP TABLE IF EXISTS `information_group`;
CREATE TABLE `information_group` (
  `information_group_id` int(11) NOT NULL auto_increment,
  `information_group_title` varchar(64) NOT NULL default '',
  `information_group_description` varchar(255) NOT NULL default '',
  `sort_order` int(5) default NULL,
  `visible` int(1) default '1',
  `locked` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`information_group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

DROP TABLE IF EXISTS `information`;
CREATE TABLE `information` (
  `information_id` tinyint(3) unsigned NOT NULL auto_increment,
  `information_group_id` int(11) unsigned NOT NULL default '0',
  `information_title` varchar(255) NOT NULL default '',
  `information_description` text NOT NULL,
  `parent_id` int(11) default NULL,
  `sort_order` tinyint(3) unsigned NOT NULL default '0',
  `visible` enum('1','0') NOT NULL default '1',
  `language_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`information_id`,`language_id`))
 ENGINE=MyISAM  DEFAULT CHARSET=latin1 );
-- 
-- Table structure for table `information_group`
-- 
DROP TABLE IF EXISTS `information_group`;
CREATE TABLE `information_group` (
  `information_group_id` int(11) NOT NULL auto_increment,
  `information_group_title` varchar(64) NOT NULL default '',
  `information_group_description` varchar(255) NOT NULL default '',
  `sort_order` int(5) default NULL,
  `visible` int(1) default '1',
  `locked` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`information_group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;

What's the error? A lot of times for me it's just that you have to delete the ENGINE=MyISAM DEFAULT CHARSET=latin1 part for compatibility.

Posted at the same time as vn5ltr -- good catch!