fix my install .sql please someone!! :(

Ok guys so I had a module made a few month back and i know find myself having to reinstall the module it is mostly just a case of drag and drop and a "simple" sql query to use in the phpmyadmin area on my host's cpanel. well went to install a few days ago and got an error when i tried to run the code through the phpmyadmin and also the admin page for my zen cart. can anyone help me fix the code so it will generate the relevant database required or at least be able to decode the coders reply to a request for support???

the code is.....

CREATE TABLE IF NOT EXISTS `zen_xboxcodes` (
`codeid` int(11) NOT NULL auto_increment,
`code` varchar(29) NOT NULL,
`type` varchar(255) NOT NULL,
`order_id` varchar(111) default NULL,
`used` enum('YES','NO') NOT NULL default 'NO',
`usedby` varchar(111) default NULL,
`usedate` datetime NOT NULL,
PRIMARY KEY (`codeid`),
UNIQUE KEY `code_2` (`code`),
KEY `code` (`code`,`type`)
)

and the coders response to asking what was wrong with the "easy install pack" i created with his list of modified files was.....

You did not choose the database to work on.
You have to select the database to run the sql query.

what error message are you getting ?
your current zencart database tables using prefix ? this query is trying to create table with zen_ as prefix ..

you can remove zen_ from the table name .. and use zencart built in sql patch install by copy pasting the code in the box and try to install that way . ..

back up before you do anything to DB.

thanks for the advice. i tried it in the admin panel and it simply failed but when i tried the exact same code in the myphpadmin on cpanel it worked a treat for some reason. the only downside now is that i created the table xboxship_zencart_xboxcodes but when i go to add a code to the database it comes up with this following error....

1146 Table 'xboxship_zencart.xboxcodes' doesn't exist
in:
[INSERT INTO xboxcodes SET code='12345-12345-12345-12345-12345', type = '12mxbl' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Am I right in thinking that this error is now being caused due to the fact there should be a _ in the coding rather than a . (dot) and i would actually need to find the offending line and edit as the phpmyadmin won't allow me to create the database with a dot:huh: