Do you have this tested with a clear MySQL Database ? Otherwise you got the following error.message.
I think you must use "Drop Table if exist " or "Alter Table" instead of "Create Table"
Your SVN 1161 works for me. Only if i try to update to SVN 1163 then i have this error
[Err] 1050 - Table 'cp_itemshop' already exists
[Err] CREATE TABLE `cp_itemshop` (
`id` int(11) unsigned NOT NULL auto_increment,
`nameid` int(11) unsigned NOT NULL default '0',
`quantity` int(11) unsigned NOT NULL default '0',
`cost` int(11) unsigned NOT NULL,
`info` text,
`create_date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Item shop';
[Msg] Finished - Unsuccessfully
--------------------------------------------------