Hi,
this answer is allready given (from me anywhere), but nevertheless: If you have this db and get some syntax errors, it could be, that you have no rights to set a database like roundcube give the syntax. Have a look at the code:
-- Table structure for table `session`
CREATE TABLE `session` (
`sess_id` varchar(40) NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ip` varchar(15) NOT NULL,
`vars` text NOT NULL,
PRIMARY KEY(`sess_id`)
) TYPE=MYISAM CHARACTER SET ascii COLLATE ascii_general_ci;
If this is not your very own server, try to remove TYPE=MYISAM CHARACTER SET ascii COLLATE ascii_general_ci
. It is possible, that your hoster have set up a fix type, char set... and you have no permission to change that. By removing this line, the table will be created with your default setting and should work fine. Tell us, if not and with what kind of error message.