Hi
i'm trying to install a table from a mysql dump i've been given but i keep getting an error and i can't figure what the the prob is
here's the code :
DROP TABLE IF EXISTS `be_groups`;
CREATE TABLE `be_groups` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`non_exclude_fields` text NOT NULL,
`explicit_allowdeny` text NOT NULL,
`allowed_languages` tinytext NOT NULL,
`custom_options` text NOT NULL,
`db_mountpoints` varchar(255) NOT NULL default '',
`pagetypes_select` tinytext NOT NULL,
`tables_select` text NOT NULL,
`tables_modify` text NOT NULL,
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`groupMods` text NOT NULL,
`file_mountpoints` varchar(255) NOT NULL default '',
`hidden` tinyint(1) unsigned NOT NULL default '0',
`inc_access_lists` tinyint(3) unsigned NOT NULL default '0',
`description` text NOT NULL,
`lockToDomain` varchar(50) NOT NULL default '',
`deleted` tinyint(1) unsigned NOT NULL default '0',
`TSconfig` text NOT NULL,
`subgroup` tinytext NOT NULL,
`hide_in_lists` tinyint(4) NOT NULL default '0',
`workspace_perms` tinyint(3) NOT NULL default '1',
`tt_news_categorymounts` tinytext NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Contenu de la table `be_groups`
--
INSERT INTO `be_groups` VALUES (1, 0, 1181731430, 'readinggroup', '', '', '', '', '1', '1,2,5', 'pages,tt_content', 'pages,tt_content', 1181731386, 1, 'web,web_layout,web_view,web_list,web_perm,file,file_list,user,user_task,user_setup,user_ws', '', 0, 1, '', '', 0, '', '', 0, 1, '');
INSERT INTO `be_groups` VALUES (2, 0, 1183711702, 'groupe_client', '', '', '', '', '', '', '', '', 1183711596, 1, '', '', 0, 0, '', '', 1, '', '', 0, 0, '');
the error is
#1064 - Syntax error near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' line 30
The version of MySQL is MySQL 4.0.15
can anyone see what the problem is ?
thanks
